Utkarsh Sharma
Delhi
Summary
As a seasoned Data Analyst Consultant with nearly 6 years of industry experience, I possess good command over Business intelligence & Data warehousing concepts. I have honed my expertise in Power BI administration & ETL tools as well. I have a proven track record of translating complex data into insights which facilitates strategic decision making.
Overview
5
5
years of professional experience
Work History
Power BI Admin/Consultant
American Express
Gurgaon
05.2023 - Current
- Leading the transformation of Power BI into an enterprise-grade solution through strategic collaboration with Microsoft and Nuedesic.
- Conducted Proof of Concepts to integrate Power BI with platforms like GCP, SQL Server & Snowflake in the AMEX environment.
- Developed PowerShell scripts using Power BI APIs for the governance of artifacts (workspaces, reports, apps).
- Proficiency in external tools like SSMS, Tabular Editor, ALM Toolkit & DAX Studio to implement incremental refresh and performance optimization.
- Crafted Python scripts with Selenium to extract Row-Level Security (RLS) user lists from security settings.
- Collaborated with cross-functional teams (HR, Finance, Technology) to design and deliver customized dashboards, followed by detailed handovers.
- Management of enterprise gateways.
Consultant 2
EXL
Gurgaon
12.2022 - 05.2023
- We developed a comprehensive learning tracker for SAS Studio, outlining resources and a plan for skill acquisition.
- Formulated a project blueprint encompassing both technical & functional views to guide project implementation.
- Successfully delivered a SAS model utilizing correlation techniques, complemented by a Power BI report.
- Provided technical assistance to the manager in the recruitment process, contributing insights and guidance for securing resources essential to the project’s success.
Analyst
Deloitte USI
Gurgaon
10.2021 - 12.2022
- Spearheaded the development of sophisticated Power BI reports for real-time tracking of company revenue, dealer inventory, inventory gaps, and order statuses.
- • Implemented intricate visualizations, including waterfall charts and a decomposition tree, to enhance the overall end-user experience.
- Ensured data privacy by Row-Level Security (RLS) implementation in reports.
- Employed ETL tools to construct robust data pipelines, streamlining the data preparation process for reporting.
- Implemented Slowly Changing Dimension (SCD) logic using SnapLogic, effectively maintaining historical data.
- Proficiently crafted complex SQL queries, Views, and Tasks within the Snowflake data warehouse environment.
- Automated manual tasks within Excel and Snowflake environments using Python, optimizing efficiency and accuracy in data handling processes.
System Engineer
TCS
Noida
06.2019 - 09.2021
- Successfully integrated data from diverse sources, including SharePoint and Snowflake for enhanced reporting capabilities.
- Developed Power BI reports encompassing Configuration Management Database (CMDB), assets, licenses, and other critical metrics.
- • Authored intricate SQL queries for data import at the report level, optimizing data retrieval and processing.
- Led the migration of Excel dashboards to Power BI, enhancing features and elevating the overall reporting capabilities.
- Conducted job monitoring and analysis on DataStage, performing Root Cause Analysis (RCA) to ensure optimal data flow and processing efficiency.
Education
B. Tech - E.C.E
Guru Gobind Singh Indraprastha University
Delhi, India05-2019
Skills
- Power BI
- SQL
- Excel
- Data Modelling
- Data Warehousing
- Data cleaning
- Data Ingestion
- Incremental refresh
- DAX
- Data Analysis
- Snowflake
- Snaplogic
- Big Query
- ETL
- Python
- Powershell
Languages
Hindi
First Language
English
Advanced (C1)
C1
Accomplishments
- Created a governance report to monitor usage of Power BI across enterprise with respect to different artifacts like reports, workspaces, users, pro licenses distribution etc.
- Ingested more than 600 million records in a Power BI report using custom partitions in Power BI premium capacity workspace.
- Automated a manual excel task to get completed in just 30 mins using Python which reduced manual efforts by 99%.
HOBBIES AND INTERESTS
- Gym
- Cricket
- Badminton
- Gaming
Timeline
Power BI Admin/Consultant
American Express
05.2023 - Current
Consultant 2
EXL
12.2022 - 05.2023
Analyst
Deloitte USI
10.2021 - 12.2022
System Engineer
TCS
06.2019 - 09.2021
B. Tech - E.C.E
Guru Gobind Singh Indraprastha University
Similar Profiles
Nemecio ContrerasNemecio Contreras
(Fraud Prevention) at American Express(Fraud Prevention) at American Express
Jorge Vance-GonzalezJorge Vance-Gonzalez
Travel Care Agent at American ExpressTravel Care Agent at American Express
Harshitha KomatineniHarshitha Komatineni
Software Engineer at American ExpressSoftware Engineer at American Express