Aug 2020 – Present · 5 yrs 10 mos

• Involved in creating relationships between dimensions and measure groups as per business requirement.
• Responsible for extracting data from multiple sources like flat files, oracle, and SQL server for transforming, cleansing and validating the data to load into final Destination
• Responsible for creating ETL packages to move data from feed files (XML, CSV and TXT) to database
• Responsible for developing Stored Procedures, Views and User defined functions
• Responsible for fine-tuning of stored procedures to improve the performance
• Involved in discussion with business users and provide technical guidance for Power BI Desktop and Power BI Service.
• Created Filters and apply conditional formatting based on user requirement. Created Slicer and measures and columns in Power BI Desktop.
• Created scheduling and sharing the reports & Dashboards using Data Gateway. Creating Content packs and sharing reports and Dashboards.
• Generating reports using DAX time intelligence functions and other kind of DAX functions.
• Involved in Creating Hierarchies and giving the relationship between attributes to decrease processing time.

Oct 2018 – Jul 2020 · 1 yr 9 mos

• Track and monitor performance and Sales of key partners their performance
• Responsible for developing and building the Reports/Dashboards.

Aug 2018 – Present · 7 yrs 10 mos

• Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset
• Extensively worked on data extraction, transforming and loading by using SSIS
• Scheduling the reports weekly and monthly basis as per client requirements and providing security for the reports.
• Worked with dimensional modeling and create Star schema for the given system and good knowledge development of Snow flake schema.