PROFESSIONAL SUMMARY:

• Having 5.5 years of IT experience with 5 years of Power BI experience as a Microsoft SQL Server developer implementing SSIS, SSRS and SSAS.

• Extensive knowledge in analyzing, designing and developing Client/Server, BI application, and various segments of software development life cycle (SDLC) involving business process analysis, requirement gathering and development.

• Experience in publishing Power BI Desktop reports on dashboards in Power BI server and in designing and developing Power BI graphical and visualization solutions based on business.

• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.

• Expert in Data Modeling and Multi-Dimensional Modeling.

• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.

• Experience in SFDC Integration using Web Service and Salesforce.com

• Extensive experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

• Experience in publishing Power BI reports on dashboards in Power BI server and Power BI Mobile App.

• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.

• Exploring App exchange applications and integrating them with Sales force.

• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.

• Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/ T-SQL /MS excel.

• Experience in Power BI, Power BI Pro, Power BI Mobile.

• Maintained security, roles, subscriptions in report manager in SSRS.

• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.

• Expertise in creating OLAP Cubes and Dimensions in SSAS.

• Expert in designing SSAS cubes with slowly changing dimensions, partitions, Aggregation and KPIs.