data analyst

Over 6 years of experienced with Oracle Database, SQL Server, Python, SQL, PLSQL programming, Data Migration, Performance tuning, Report writing and designing and production support. Identify issues, gather information from various sources, analyze data, interpret patterns and trends, give recommendations, and create insightful reports.  Skilled in creating Dashboard using Power BI and SQL. Analyze, prepare daily, weekly, monthly report.  Drive and support different teams by converting complex data and findings into understandable tables, graphs, and written reports. Experienced in writing PL-SQL, T-SQL package, Procedure, Function using collection, for all, Object types for processing high volume Banking application, insurance data. Skilled in Indexing, SQL and PL-SQL execution elapsed time, Identify problem SQL statement, Query execution plan. In depth understanding in Oracle Database Architecture, SGA & PGA memory and Background process, Explain plan. Working experience in Table Partitioning (Range, List, Hash). Skilled in writing complex query and visually design reports (iReport). Designing Index strategy, Parallel query operation, optimization techniques.
Working knowledge in Kafka for real time data processing.