Power BI & MSBI Consultant
Location : Hyderabad
Experience : 5.5 Year
Rate: $11 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
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.
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
