Pyspark
Gaurav Kumar
Data Engineer & Analytics
München,Bavaria
"Success is not a target, it is a process"
Gaurav Kumar
Summary
I hold a master's degree in Data Analytics and Decision Science, complemented by approximately five years of experience as a data analyst and data engineer. My technical proficiency includes statistical modeling, machine learning, and data visualization, with strong skills in R, Python, SQL, and Tableau. As a data science enthusiast and proactive team player, I thrive in taking on increasing responsibilities and challenging assignments.
I am a results-oriented analyst adept at managing and interpreting large volumes of information. My proactive approach allows me to identify trends that impact business success and to preemptively address operational, workflow, and production issues. I am seeking a technical role that leverages my expertise as a data engineer and data analyst to drive business growth and innovation.
Overview
6
6
years of professional experience
4
4
Certificates
3
3
Languages
Tableaupublic
https://public.tableau.com/profile/gaurav.kumar7925#!/
Blog
https://medium.com/@gauravkumarjha1195
Work History
Senior Technical Consultant
NTT DATA DACH
2 2023 - Current
- Market Research Analyst specializing in forecasting 2023 technology trends
- Proficient in Tableau for dashboard development and server setup, focusing on finance logistics
- Skilled in creating automated data processing scripts using AWS and VS Code
- Experienced in data cleaning and processing with AWS services
- Skilled in GIT/Terraform
- Adept at documenting business requirements and conducting knowledge transfers to colleagues.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
Data Analyst Consultant
Umlaut
02.2021 - 12.2022
- Cloud Experience
I have extensive hands-on experience working with AWS cloud services, including EMR clusters, S3 buckets, Athena, Glue, and CloudFormation. My expertise encompasses setting up and managing EMR clusters for big data processing, leveraging S3 buckets for scalable storage solutions, utilizing Athena for interactive query services, employing Glue for ETL processes, and implementing infrastructure as code using CloudFormation. This comprehensive skill set has enabled us to deliver results to customers with high efficiency. - Visualization and Dashboard
I possess significant experience in creating insightful visualizations and dashboards for telecommunications customers using Tableau. My work involves visualizing key performance indicators (KPIs) such as signal strength, throughput, latency, and active users. These visualizations have played a crucial role in optimizing network performance by 80-90%, leading to enhanced service quality and customer satisfaction. - Data Engineering and Analysis
I have developed numerous Scala scripts using Zeppelin notebooks and VS Code to perform ETL jobs and analysis tasks. Furthermore, I have utilized Athena queries to significantly reduce the time required for primary analysis of telecommunication data. These efforts have facilitated efficient data processing and insightful analysis, thereby improving decision-making and operational efficiency in the telecommunications sector. - Deployment, Documentation, and Onboarding
I am experienced in deploying code to production using GitHub, documenting processes, and effectively communicating with stakeholders. Additionally, I support the onboarding of new employees by providing comprehensive knowledge transfer, ensuring they are well-prepared to contribute effectively to the team. - Project Management and Task Tracking
I am experienced in creating Jira tickets and maintaining them on a Kanban board, ensuring smooth project management and task tracking. This practice helps streamline workflows, prioritize tasks effectively, and ensure timely completion of projects. My approach to project management enhances team collaboration and productivity, leading to successful project outcomes.
Internship
Bosch
11.2020 - 02.2021
- Data Engineering
I have extensive experience in data engineering using PySpark on a Hadoop Cluster and working with relational databases such as MySQL. My key responsibilities include pivoting and transforming data from HDFS using PySpark, as well as transforming batch CSV data and uploading it to MySQL using Python. This expertise allows for efficient handling and processing of large datasets, ensuring data integrity and facilitating effective data management. - Data Visualization and Dashboard
I have extensive experience in data visualization using Tableau. My work includes creating a landing page for different products, including sensors, a dashboard for analyzing the optical inspection process, and a dashboard for analyzing the electrical testing process. These Tableau dashboards provide valuable insights, helping customers access crucial information, save time by 40%, and increase the productivity of sensor production by 90%. - Version Control and Documentation
I have experience in version control and documentation of scripts using GitLab and GitHub. This includes deploying code to production, documenting processes, and effectively communicating with stakeholders. Additionally, I manage Jira tickets on a Kanban board, ensuring smooth project management and task tracking. My approach ensures comprehensive documentation and efficient version control, contributing to successful project outcomes and enhanced team collaboration.
Data Analyst
Cognizant
12.2017 - 09.2019
- Tableau Workbook Maintenance
I am responsible for maintaining a Tableau workbook for the pharmaceutical industry that consists of several dashboards providing insights into monthly active users 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 in the deployment across all five environments (dev, qa, prod, qr, preprod). Additionally, I am responsible for documenting support and maintenance activities to ensure smooth operations and efficient issue resolution.
Education
Master's in data Analytics and Decision Science -
Optimization, Heuristic Optimization, Machine Learning, Predictive Modeling, Advanced Machine Learning, Design and Algorithm
Bachelor of Technology in Electronics and Telecommunication - undefined
Certification
Tableau for Analysts
Skills
AWS Cloud Services
undefinedSoftware
Python
Scala
Tableau
Jenkins
Terraform
AWS
Linux
Research
THESIS
Clustering of electric vehicle charging stations using nearby points of interest., RWTH Aachen, 08/2021-02/2022, Matching of POIs to charging stations, Clustering of charging stations, Creation of regression models and statistical models to understand correlations between POIs and charging station usage., Effect of corona on charging patterns.
Projects
Analytics Project, 04/2020 - 07/2020,
RWTH AACHEN & ALL MY HOMES GmbH, Finding the relationship of rent vs purchase prices and investigate major drivers.
Work Preference
Work Type
Full TimePart TimeContract WorkWork Location
On-SiteRemoteHybridImportant To Me
Company CultureWork-life balanceCareer advancementPaid sick leave4-day work weekPaid time offHealthcare benefitsTeam Building / Company RetreatsFlexible work hoursWork from home optionPersonal development programsStock Options / Equity / Profit SharingWork Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Interests
Travelling
Cooking
Photography