PROFESSIONAL EXPERIENCE

IT Analyst, 

Mar 2022 – present | Pune, India

Around 8 years of experience in ETL design and development, data warehousing analysis and visualization

Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization,

Star and Snowflake data models

Significant experience to implement ETL, OLAP and reports that meets client requirements

Experience in Reports Designing using tools like Power BI, SSRS, PPS and LogiInfo

Experience in working on Master Data Management (Microsoft)

Strong knowledge of full life cycle of Data Ware Housing including Dimensional modeling using Star / Snowflake schema, ETL design using tools like SSIS and Talend

Well acquainted with the Agile Methodology

Hands on experience in developing reports in Tableau An effective Client communication and excellent relationship building skills.

Associate, 

Jan 2021 – Feb 2022 | Pune, India

Significant experience to implement ETL, OLAP and reports that meets client requirements

Worked on data warehousing concepts, OLTP, OLAP, Normalization, Star and Snowflake data models.

Working experience of developing reports in Tableau Strong experience with client interactions with daily scrums and agile methodology of development.

Experience working on life cycle of Data Ware Housing including Dimensional modeling using Star / Snowflake schema, ETL design using tools like SSIS and Talend.

Worked on different BI tools like Power BI, SSRS, PPS and LogiInfo.

Holding strong experience on client side, from requirement to development and testing, production releases and managing end to end product life cycle. Experience in working on Master Data Management (Microsoft).

Developed reports with sources like SSAS, SQL, and Excel ,used various visualisations like slicers, graphs, tables, created measure using DAX.

Building SSRS report based on SSAS cube, creation of MDX query.

PROJECTS

PowerBI report creation

Team Size : 4 Role : Tech Lead

Technologies: Azure Databricks, PowerBI, Power Automate, Power Apps

Responsibilities :

Created PowerBI dashboard for pharma company it also included some of its manufacturing process.

Part of requirement gathering and understanding the use case of the reports

Analysed the source systems and the data its holding Developed the data model and gave solutions to the use case. Created PowerApps and PowerAutomate flow.

Migration of Power BI to SSRS

Team Size : 10

Role : Associate Project

Technologies: SSIS, Azure SQL Data warehouse

Responsibilities :

Client is multinational banking and financial services corporation. Its primary businesses are retail banking, direct banking, commercial banking, investment banking, wholesale banking, private banking, asset management, and insurance services.

Business understanding of the existing SSRS reports and the solution

Discussion with business for requirements and concerns Suggesting relevant graphs in Power BI

Building SSRS report based on SSAS cube Creation of MDX query.

Development of KPIs and data warehouse

Team Size : 5

Role : Senior Software Engineer

Technologies: SSIS, Azure SQL Data warehouse

Responsibilities:

Client is an Indian financial services company focused on lending, asset management, wealth management and insurance

Understanding the requirement of business and later identifying the column mapping from source system for developing KPIs

Automating the KPIs for monthly calculations

Data load in Azure SQL data warehouse using Azure BLOB storage

Creating SSIS package for data load

Maintaining control and log tables for the packages Handling package failures

Scheduling the packages.

Data syncing with MDM from source Oracle, SQL Sever

Team Size : 6

Role : Senior Software Engineer

Technologies: MDM(Microsoft), SSIS, SQL Server, Oracle

Responsibilities :

Senior Software Engineer, 

Oct 2018 – Jan 2021 | Pune, India

Experienced BI developer having working experience on different BI and reporting tools and technology such as Power BI, Tableau, SSRS, PPS, LogicInfo, SQL Server, SSIS.

Worked on Azure SQL Data warehouse, creation of MDX query, building SSRS report based on SSAS cube. Experience developing reports dashboards using tableau and data sources such as excel, sql server etc. Strong knowledge and experience in life cycle of Data Ware Housing i