Gaurav Kumar — Associate Consultant

Gaurav Kumar: Data Engineer & Analytics Portfolio https://notebooklm.google.com/notebook/f1762eee-f588-4229-8f39-c1e84d77fd47?artifactId=25708b09-984c-44e9-a8aa-225cc9fa5b6b With a Master’s in Data Analytics and Decision Science from RWTH Aachen and 6+ years of industry experience, I deliver scalable, data-driven solutions across diverse sectors, including telecom, pharma, automobile, and manufacturing. 🔧 Tech Stack: Python | R | SQL | PySpark | Scala | AWS (QuickSight, Glue, Athena & more) | Tableau 📊 Skilled in building optimized ETL pipelines, data modeling, and crafting interactive dashboards that empower decision-makers. 💼 Strong consulting background with a proven ability to translate complex business problems into effective technical solutions. I thrive in fast-paced environments, collaborating cross-functionally to unlock insights and improve processes. I am always open to new challenges in Data Engineering, Big Data, Business Intelligence, and Analytics domains. --------------------------------------------------------------------------------------------------------------- Mit einem Masterabschluss in Data Analytics & Decision Science von der RWTH Aachen und über 6 Jahren Berufserfahrung entwickle ich skalierbare, datengesteuerte Lösungen für verschiedene Branchen – darunter Telekommunikation, Pharma und Fertigung. 🔧 Tech-Stack: Python | R | SQL | PySpark | Scala | AWS (QuickSight, Glue, Athena & mehr) | Tableau 📊 Erfahrung in der Entwicklung effizienter ETL-Pipelines, Datenmodellierung und der Erstellung interaktiver Dashboards zur datenbasierten Entscheidungsfindung. 💼 Durch meine Tätigkeit im Consulting besitze ich ein ausgeprägtes Verständnis dafür, komplexe Geschäftsanforderungen in technische Lösungen zu übersetzen. Ich arbeite gerne in dynamischen, interdisziplinären Teams und bin stets offen für neue Herausforderungen im Bereich Data Engineering, Big Data, Business Intelligence und Analytics. --------------------------------------------------------------------------------------------------------------- Have a look at my work: ●GitHub;https://github.com/Gaurav715 and https://github.com/gAURAV-715 ●Tableau:https://public.tableau.com/app/profile/gaurav715/vizzes ●certdirectory : https://certdirectory.io/profile/425fd136-1242-46eb-b65e-57925eb39841 ●Blog: https://medium.com/@gauravkumarjha1195 ●Notion: https://gaurav715.notion.site/Gaurav-Kumar-6878857018ad4dafb4782769034bcfc ●Photography: https://www.flickr.com/photos/200996354@N08/ ● YouTube: https://www.youtube.com/channel/UCPbQ9bo03uz2sKwfTvG5CIQ

Stackforce AI infers this person is a Big Data and Analytics professional with expertise in Data Engineering across multiple industries.

Location: Munich, Bavaria, Germany

Experience: 6 yrs 6 mos

Skills

Data Engineering
Big Data
Business Intelligence
Big Data Analytics
Data Analytics
Machine Learning

Career Highlights

6+ years of experience in data engineering and analytics.
Expert in building optimized ETL pipelines and interactive dashboards.
Strong consulting background translating business problems into technical solutions.

Work Experience

NTT DATA DACH

Senior Technical Consultant (1 yr 8 mos)

Technical Consultant (1 yr 5 mos)

umlaut company

Big Data Analyst (9 mos)

Big Data Analyst (1 yr)

Chair for Electrochemical Energy Conversion and Storage Systems (ISEA) / RWTH Aachen University

Master Thesis (7 mos)

Bosch Center for Artificial Intelligence (BCAI)

Big Data and Machine Learning Intern (2 mos)

Cognizant

Programmer Analyst (7 mos)

Programmer Analyst Trainee (1 yr 1 mo)

Education

Master's degree at RWTH Aachen University

B-Tech at Kalinga Institute of Industrial Technology, Bhubaneswar

Gaurav Kumar

Associate Consultant

Munich, Bavaria, Germany6 yrs 6 mos experience

Most Likely To SwitchAI Enabled

Key Highlights

6+ years of experience in data engineering and analytics.
Expert in building optimized ETL pipelines and interactive dashboards.
Strong consulting background translating business problems into technical solutions.

Stackforce AI infers this person is a Big Data and Analytics professional with expertise in Data Engineering across multiple industries.

Contact

Skills

Core Skills

Data EngineeringBig DataBusiness IntelligenceBig Data AnalyticsData AnalyticsMachine Learning

Other Skills

AWS AthenaAWS CloudFormationAWS EMRAWS GlueAWS QuickSightAWS S3AWS Step FunctionsAgile methodologiesAmazon Web Services (AWS)Analytical SkillsApache SparkApache ZeppelinAtmel AVRAxway Polict studioAxway policy studio

About

Experience

Ntt data dach

2 roles

Senior Technical Consultant

Promoted

Jul 2024 – Present · 1 yr 8 mos · Munich, Bavaria, Germany

Developed and optimized ETL pipelines using PySpark, processing over 100 TB of automobiles and inventory data, enhancing data accuracy and accessibility for finance and management teams.
Leveraged AWS services, including Athena, Glue Crawler, S3, Step Functions, and CloudFormation, to streamline data management, resulting in a 50% reduction in query times and improved data organization.
Working on ETL pipelines and data visualization using AWS QuickSight for an automobile maintenance dashboard covering 17 manufacturing plants across Europe and the UK.
Enhances report accessibility and visibility across departments, improving collaboration and decision-making.

PySparkAWS GlueAWS AthenaAWS S3AWS Step FunctionsAWS CloudFormation+5

Technical Consultant

Feb 2023 – Jul 2024 · 1 yr 5 mos · Munich, Bavaria, Germany

Data Engineering & Analysis: Conducted ETL processes using PySpark for finance and management
teams of automobile customers.
Customized Financial Performance Dashboards: Developed interactive Tableau dashboards focusing on
expenses, revenue, profit margins, and cost efficiencies. These dashboards help customers track the
costs of each car part regularly, optimizing processes and saving 20-30% in costs.
Cloud Experience: Used AWS services like Athena for easy data searches,Glue Crawler to organize
data, S3 for storing files, Step Functions to manage tasks, and CloudFormation to set up everything
quickly and efficiently.
Deployment, Documentation, and Project Management: Deployed code with Terraform, documented
processes in Atlassian, and managed an agile 4-member team with Kanban boards and sprint planning.

PySparkAWS AthenaAWS GlueAWS S3TableauTerraform+3

Umlaut company

2 roles

Big Data Analyst

Mar 2022 – Dec 2022 · 9 mos · Aachen, North Rhine-Westphalia, Germany

Implementation and Testing of Crowd Raw Data Export for telco customers.
Monitoring of Crowd Raw Data Exports on AWS EMR cluster on a daily, weekly, and monthly basis.
Development of scala scripts using AWS tools like Athena, Zeppelin, S3, and Glue for analytics tasks.
Creation of tableau dashboard and report presentation.
Support for product development tasks.
Version Control and Documentation of scripts in Gitlab.
Handling the Jira ticket.
Knowledge transfer to colleagues.

AWS EMRScalaAWS AthenaTableauGitlabJira+2

Big Data Analyst

Feb 2021 – Feb 2022 · 1 yr · Aachen, North Rhine-Westphalia, Germany

Analysis of telecommunication crowd data.
Working with EMR cluster, S3 bucket, Athena,
Development of Data Analysis scripts on AWS (Spark Scala).
Visualizations of analyses using tableau.
Data Engineering on crowd data and data preparation for further analysis.
Creating schema for raw data export

AWS EMRAWS S3AWS AthenaTableauData EngineeringBig Data Analytics

Chair for electrochemical energy conversion and storage systems (isea) / rwth aachen university

Master Thesis

Jul 2021 – Feb 2022 · 7 mos · Aachen, North Rhine-Westphalia, Germany

Matching of POIs to charging stations
Clustering of charging stations
Creation of regression models to understand correlations between POIs and charging station usage.
Effect of corona on charging patterns.
Implemented Pooled OLS, Panel OLS, Random OLS, Fixed Effect Model like LSDV and Between OLS.

Regression modelsData analysisPooled OLSPanel OLSData Analytics

Bosch center for artificial intelligence (bcai)

Big Data and Machine Learning Intern

Nov 2020 – Jan 2021 · 2 mos · Stuttgart, Baden-Württemberg, Germany

Data Engineering with Pyspark on a Hadoop Cluster and with relational Databases (MySQL)
1. Pivotization and Transformation of data from HDFS with Pyspark
2.Transformation of batch csv data and upload to MySQL in Python
Data Visualization with Tableau
1.Landing Page for different products
2.Dashboard for Analysis of optical inspection process
3.Dashboard for Analysis of an electrical testing process
Version Control and Documentation of scripts in Gitlab.

PySparkHadoopMySQLTableauGitlabData Engineering+1

Cognizant

2 roles

Programmer Analyst

Feb 2019 – Sep 2019 · 7 mos

Tableau Workbook Maintenance:
I am responsible for maintaining a Tableau workbook for the pharmaceutical industry. The workbook consists of several dashboards providing insights into monthly and yearly active users. These dashboards are crucial for tracking user engagement and trends over time, enabling data-driven decision-making and strategic planning within the pharmaceutical sector.
Incident Management and Server Monitoring:
I am responsible for creating tickets in ServiceNow and BMC Remedy tools if any issues arise in the SQL database or Tableau dashboard and resolving these issues efficiently. Additionally, I monitor the servers of all five environments (dev, qa, prod, qr, preprod). If a server goes down, I promptly restart it to ensure continuous process efficiency without any delay.
Production Support and Documentation
I support the data analyst and data engineering teams deploying across all five environments (dev, qa, prod, qr, prepod). Additionally, I document support and maintenance activities to ensure smooth operations and efficient issue resolution.

TableauSQLServiceNowBMC RemedyBusiness Intelligence

Programmer Analyst Trainee

Dec 2017 – Jan 2019 · 1 yr 1 mo

Tableau Workbook Maintenance
I am responsible for maintaining a Tableau workbook for the pharmaceutical industry. The workbook consists of several dashboards providing insights into monthly and yearly active users. These dashboards are crucial for tracking user engagement and trends over time, enabling data-driven decision-making and strategic planning within the pharmaceutical sector.
Incident Management and Server Monitoring
I am responsible for creating tickets in ServiceNow and BMC Remedy tools if any issues arise in the SQL database or Tableau dashboard and resolving these issues efficiently. Additionally, I monitor the servers of all five environments (dev, qa, prod, qr, preprod). If a server goes down, I promptly restart it to ensure continuous process efficiency without any delay.

TableauSQLServiceNowBMC RemedyBusiness Intelligence