Shivam Garg
Analytics Enginer
Bulandshahr
Summary
Results-driven analytics professional adept at translating complex data into actionable insights. Proficient in data modeling, Snow SQL, dbt, Airflow, and Python. Emphasizes collaborative teamwork and goal achievement. Recognized for adaptability in meeting evolving demands and consistently delivering reliable, impactful solutions. Proactive in addressing challenges with sharp analytical abilities and a strategic approach.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Analytics Engineer
Deloitte
03.2024 - Current
- Acted as liaison between clients and technical associates, translating complex ideas into easy-to-understand explanations.
- Created dbt models, Airflow DAGs, and Snowflake processes.
- Migrate the client from SQL Server to Snowflake using dbt and Airflow on AWS.
- Collaborated with internal and external stakeholders to optimize data sourcing pipelines and verify data quality.
- Performed preemptive resolution of technical issues by utilizing detailed knowledge of ongoing processes and policies.
- Optimized data sources and processing rules to enhance data quality through design and development phases.
- Streamlined analytics workflows for faster decision-making and increased efficiency.
Data Analyst(NATWEST Project)
PwC
02.2023 - 02.2023
- Developed and fine-tuned complex T-SQL stored procedures and functions, resulting in a 30% increase in database processing speed and enhancing system stability.
- Analyzed and refactored SQL queries to increase database response time by 50%, leading to a 30% improvement in overall application performance.
- Analyzed customer data to identify trends and patterns, resulting in a 20% increase in customer retention and a 15% boost in upsell opportunities.
- Devised and implemented a comprehensive Power BI dashboard tracking sprint progress and team KPIs, improving sprint predictability by 40% and enabling proactive issue identification, reducing project delays by 25%.
- Directed the setup and maintenance of SSIS Jobs and Azure Jobs through Pipeline, driving a 25% enhancement in data flow accuracy and reducing system downtime by 15%.
SQL Developer
Varun Beverages Ltd.
02.2022 - 02.2023
- Company Overview: (Pepsico)
- Orchestrated the creation, deployment, and enhancement of stored procedures and functions utilizing T-SQL, driving a 25% reduction in query execution time and a 15% optimization in database indexing strategies.
- Analyzed and refactored SQL queries to increase database response time by 70%, leading to a 40% improvement in overall application performance.
- Enhanced data management efficiency by optimizing queries and improving database performance in MS SQL Server, resulting in a 25% reduction in report generation time for the reporting team.
- Was a major part of the team responsible for migration of old system(MS SQL System) to AWS Cloud(Snowflake).
- Spearheaded the development of Glue Jobs and DMS Jobs, meticulously oversaw 20+ S3 buckets, resulting in a 30% increase in data transfer efficiency and storage optimization.
- Implemented Snowpipe for real-time data ingestion from SQL SERVER & S3 Buckets, resulting in a 40% decrease in data processing time, enhancing data accessibility and enabling faster decision-making processes.
- (Pepsico)
ETL Developer
Cognizant Technology Solutions
09.2020 - 01.2022
- Orchestrated the migration of data for Kaiser Permanente and BCBNMN, optimizing ETL processes and enhancing data accuracy resulting in a 25% reduction in data errors and a 30% increase in data processing efficiency.
- Awarded the prestigious 'Most Impactful' award, given to the top 5 percent of engineers based on total impact to firm in the 1 year of joining(2021).
- Directed and executed the complex data migration project from OLD Systems to Teradata Datawarehouse, successfully implementing Type 2 changes; optimized query performance, resulting in a 30% reduction in data retrieval time.
- Analyzed, prioritized, and resolved 50+ incident reports, minimizing service disruptions and ensuring seamless user experience across platforms.
- Job Monitoring of everyday and weekly jobs.
Intern
Cognizant Technology Solutions
01.2020 - 04.2020
- Worked upon Teradata, PL-SQL, AWS.
- Executed an intensive internship program focused on immersing in SQL Developer environment and mastering roles in database management; gained proficiency in complex query writing and database optimization techniques.
Education
B.Tech -
SRM Institute of Science and Technology
08.2016 - 08.2020
CLASS XII - P.C.M
Sangam School Of Excellence
04.2015 - 06.2016
Skills
- Data manipulation with SQL
- Proficient in AWS cloud solutions
- Data Engineering
- Experienced with SnowSQL queries
- Database management
- Documentation
- Data Modelling
- Proficient in Python programming
- SQL database management
Certification
AWS Solutions Architect
Timeline
AWS Solutions Architect
11-2024
Analytics Engineer
Deloitte
03.2024 - Current
Data Analyst(NATWEST Project)
PwC
02.2023 - 02.2023
SQL Developer
Varun Beverages Ltd.
02.2022 - 02.2023
ETL Developer
Cognizant Technology Solutions
09.2020 - 01.2022
Intern
Cognizant Technology Solutions
01.2020 - 04.2020
B.Tech -
SRM Institute of Science and Technology
08.2016 - 08.2020
CLASS XII - P.C.M
Sangam School Of Excellence
04.2015 - 06.2016
Similar Profiles
Caitlin Nicole OelofseCaitlin Nicole Oelofse
Chartered Accountancy Articles at DeloitteChartered Accountancy Articles at Deloitte
Aryaman ChandelAryaman Chandel
Intern at DeloitteIntern at Deloitte
Fatima Zahra NouissiFatima Zahra Nouissi
Consultante Fonctionnelle SAP PP Confirmée at DeloitteConsultante Fonctionnelle SAP PP Confirmée at Deloitte
Ashutosh PatraAshutosh Patra
Consultant at DeloitteConsultant at Deloitte
Yogesh Kumar SainiYogesh Kumar Saini
Resident Medical Officer at Singh Nursing HomeResident Medical Officer at Singh Nursing Home