Amish Baghel
Bengaluru
Summary
As a Data Analytics Consultant with over 4+ years of industry experience, I possess expertise in managing SQL and NoSQL databases like PostgreSQL and MongoDB, ensuring optimal performance through fine-tuning and query optimization. My experience includes deploying databases in Kubernetes environments using Kubernetes operators and working on Linux-based operating systems. Proficient in Python and shell scripting, I specialize in data modeling, ETL pipelines, database health monitoring, and reporting. With a track record of leveraging modern DevOps technology and generative AI, I bring innovative solutions to complex challenges.
Overview
5
5
years of professional experience
Work History
Analytics Consultant
Kantar IMRB
Bengaluru
04.2024 - Current
- Maintained cluster environments for SQL and NoSQL databases to ensure high availability.
- Conducted query optimization to improve database performance, and provided guidance to developers.
- Implemented Kubernetes-based database deployments using Kubernetes operators for automated scaling.
- Developed interactive dashboards using Power BI for enhanced decision-making.
- Maintained ETL pipelines for seamless data integration and reporting.
- Incorporated generative AI to optimize data analysis and reporting processes.
Senior PM
NielsenIQ
Vadodara
08.2023 - 03.2024
- Enhanced SQL database performance through effective monitoring.
- Automated database maintenance tasks using Python scripts to reduce manual efforts.
- Delivered regular updates to stakeholders through comprehensive KPI reports.
Data Analytics Engineer
SOMIKA SARL
Vadodara
05.2022 - 04.2023
- Ensured performance tuning and health monitoring of PostgreSQL databases to enhance reliability.
- Decreased ETL pipeline delay through optimized data ingestion processes.
- Developed machine learning models on Google Cloud to predict fuel consumption, achieving a 5% increase in fleet efficiency.
- Performed statistical analyses and anomaly detection for IoT device data, ensuring actionable insights.
- Designed time-based graphical insights to track fleet performance trends.
Senior Data Associate
Numerator
Vadodara
09.2019 - 02.2022
- Managed MongoDB clusters, optimized database performance, and monitored ingestion processes.
- Utilized tools like Airflow, Unix CRON jobs, and Kafka to automate ETL workflows and job tracking.
- Employed data cleansing methods to enhance data quality and accuracy in reporting.
- Sculpted and maintained databases through proficient use of Bash/Linux shell scripting.
- Collaborated with system architects to align database solutions with business requirements.
Education
Bachelor of Technology - Electrical Engineering
CHAROTAR UNIVERSITY
Changa,GujaratSkills
- Effective Communication in Diverse Teams
- Open-minded, empathetic, adaptable, and accountable
- Big-picture thinker with critical problem-solving abilities
- Positive attitude, with a willingness to learn
Timeline
Analytics Consultant
Kantar IMRB
04.2024 - Current
Senior PM
NielsenIQ
08.2023 - 03.2024
Data Analytics Engineer
SOMIKA SARL
05.2022 - 04.2023
Senior Data Associate
Numerator
09.2019 - 02.2022
Bachelor of Technology - Electrical Engineering
CHAROTAR UNIVERSITY