Experienced Power BI Analyst with over 2.9 years of experience ion various business domains like Financial, Insurance and Health Care. Excellent reputation for resolving problems and improving customer satisfaction.
• Gathered user requirements and analyzed and designed software solution and database.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
• Used Table , Matrix , Bar, Card , Gauge , Slicers visualizations
• Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Created New Calculated Column and Measure using DAX Expression.
• Responsible for implementation of creating complex SSIS packages using proper control and data flow elements with error handling.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation
SQL Server Enterprise Manager
undefined