Uday Sharma

Ingest the data using Dataflow Gen2 to perform low-code ETL (Extract, Transform, Load) and set the Lakehouse as the destination. Stored the data in Lakehouse as Delta format where enabled both Spark and SQL engine access. Orchestrated the workflow, scheduled dataflow execution and monitored the performance using Pipeline.

Project Description : -
1. Sustainability Planning Dashboard - Build using Real-Time Intelligence (KQL) in Microsoft Fabric and Power BI which focus on Total Emissions that enable them to visualize and analyze their Green House Gas (GHG) also calculates the Total Spend, Waste, and Revenue using multiple KPI’s through year, quarter, month and day by slicers. Ingest the data using Dataflow Gen2 to p

Project Description (GDIS, TLC, Humana Pharma, Sanofi Pharma) - Worked on DAX in Power BI to achieve the multiple requirements. Worked on PowerApps to build custom business apps that connect to data stored either in the underlying data platform. Scheduled to refresh the dataset of report using Power Automate.

Project Description: -
Audit Performance Report development into Power BI reporting tool.

Roles and Responsibilities: -
Created calculated column and measure using DAX in Power BI to achieve the multiple requirements. Integrate the database tables using SSIS and must deploy all the reports using Power BI and SSAS where data is stored in cubes (tabular format 2D and 3D).

SCOPE & OBJECTIVE:
Analys

Project Description: -
• Data Visualization Team: Handling IT service management data and incidents from North America and providing powerful insights to customers making them take strategic decisions.
• Sales Modernization Team: Leveraging Sales data of McDonalds and providing insights to clients.
• Air Finance Team: Being a Core team we are responsible for all stakeholders leveraging our

Integrate the database tables using SSIS and must deploy all the reports using Power BI and SSAS where data is stored in cubes (tabular format 2D and 3D).

Project Description: -
The ERDM Data Ops team is responsible for managing & maintaining Company Master information, providing support and key reference data to different organizations at NetApp.

Roles and Responsibilities: -
• Requests received to create new records (Companies and addresses) in enterprise systems which includes – Prospects, Customers, Partners and Vendors
• Source Systems reques

Designing, developing, and maintaining business intelligence solutions.

Automation Description: -

• Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for healthcare industry.
• Creating VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Developed complex reports to compare crude usage data from various carriers to p

Roles and Responsibilities
• Serve as primary contact for automating excel process into simplifying VBA macros.
• Committed to deliver assigned VBA macros projects to different departments like risk analysis, decision support etc.
• Perform analysis of systems and program requirements.
• Perform analysis of large complex enterprise-wide projects.
• Recommend designs and develop and integrate prog

Automation Description: -

a) Headsup Report for All Countries
I had created VBA macro to compare the trends for current and previous period on 11 countries and automatically generate the reports for the particular brands, channels and applications (i.e. Google, Facebook and YouTube). This resulted in reduced manual intervention and time reduction from 66 hours to 3 minutes.

b) AGF DE Panel Repor

First, 64%

First, 78%

First, 80%

Second, 59%

Completed Computer Applications