SHUBHAM SINGH
Bengaluru
Summary
Motivated, team-oriented Data Analyst with over 3 years of hands-on experience in interpreting and analyzing data to develop successful business solutions.
Overview
3
3
years of professional experience
Work History
Data Analyst
PwC
Bengaluru
03.2024 - Current
- Created and automated Power BI dashboards (executive, production, and quality) using advanced DAX queries, reducing decision-making time by 90%
- Developed SQL queries for Client to analyze claim denials, identifying top denial reasons, which resulted in a 20% reduction in claim denial rates within three months
- Automated claim resolution workflows for AdventHealth using Python and optimized data fetching and analysis with SQL, leading to a 25% improvement in process efficiency
Analyst
Zeta Global
Bengaluru
06.2023 - 09.2023
- Devised and executed digital advertising strategies with my findings for over 40 campaigns, accruing $11M in revenue, optimizing performance via Zeta's DSP
- Developed and executed SQL reports and Hive/Vertica scripts for thorough campaign trend analysis and growth opportunity identification
- Optimized media campaigns for dynamic ads for a new client, resulting in a 63% drop in acquisition costs and annual revenue of $1.5M
Data Analyst
Tekion
Bengaluru
02.2023 - 06.2023
- Managed the data migration for over 50 dealerships to Tekion's flagship product, resulting in a significant revenue uplift of $25 million
- Streamlined data operations using Python scripts, achieving a 40% reduction in repetitive data loading tasks
- Devised data pipelines that reduced S3 to Athena data load efforts by 60%, efficiently managing approximately 100 GBs of data
- Handled large-scale data validation using SQL queries on AWS Athena, ensuring accuracy and integrity
Data Analyst
MIQ Digital
Bengaluru
07.2022 - 01.2023
- Enhanced the effectiveness and reach of various political and product ad campaigns, leveraging SQL and Excel for data analytics, directly leading to a significant 9% boost in campaign ROI and revenue growth
- Streamlined and optimized SQL query operations, successfully reducing processing times by over 50%, thus enhancing overall database efficiency and response times for business-critical operations
- Used statistical analytics and data modeling in ad targeting, segmentation to enhance campaign precision
Programmer Analyst Trainee
Cognizant
Bengaluru
09.2021 - 07.2022
- Utilized SQL, advanced Excel, and Python for data processing and analysis, successfully deploying a quality project for client AIG, focusing on efficiency and accuracy in data handling
- Analyzed, reviewed, and revised programs to increase operating efficiency by up to 30%, significantly enhancing system performance and user satisfaction
Education
Bachelor of Technology - Computer Science and Engineering
Inderprastha Engineering College
Ghaziabad, Uttar Pradesh08.2021
Skills
- Power BI
- DAX Queries
- SQL
- MySQL
- Python
- Pandas
- Numpy
- Tableau
- Advanced Excel
- Business Analysis
- Data Analysis
- Data Modeling
- Database Maintenance
- Customer Acquisition
Timeline
Data Analyst
PwC
03.2024 - Current
Analyst
Zeta Global
06.2023 - 09.2023
Data Analyst
Tekion
02.2023 - 06.2023
Data Analyst
MIQ Digital
07.2022 - 01.2023
Programmer Analyst Trainee
Cognizant
09.2021 - 07.2022
Bachelor of Technology - Computer Science and Engineering
Inderprastha Engineering College
Similar Profiles
Julian WalleJulian Walle
Technology Operations Manager at PwCTechnology Operations Manager at PwC
Olivia KnightOlivia Knight
Internship at PWCInternship at PWC
Vartika SinghVartika Singh
Internship Trainee at PwCInternship Trainee at PwC
ERIN MONTRASTELLEERIN MONTRASTELLE
Engagement Support Concierge/ Onboarding- Workplace Solutions at PwCEngagement Support Concierge/ Onboarding- Workplace Solutions at PwC
Mohammed Zaid BangiMohammed Zaid Bangi
Middleware Administrator at AccentureMiddleware Administrator at Accenture