Hi, I’m
KIRTI YADAV
Data Analyst
Dhar
Summary
Data Analyst with 1 + year of hands-on experience in end-to-end data processing, reporting, automation, and dashboard development. Demonstrated ability to translate raw data into actionable insights using Power BI and Tableau, automate manual processes using Python and Google Apps Script, and build robust data pipelines using Informatica and SQL. Strong background in optimizing workflows, improving data accuracy, and supporting business decision-making through clean, reliable, and automated data systems.
Overview
3
years of professional experience
3
Certifications
Work History
Codify Software Services Pvt. Ltd.Pune
DATA ANALYST
12.2024 - Current
Job overview
- Engineered full-scale automation of critical hourly reports for ground teams and general managers using Python and Google Apps Script, directly resulting in a 12% increase in delivery conversion rates within the first month.
- Designed and developed interactive dashboards using Power BI and Tableau, enabling stakeholders to monitor KPIs, including operations, finance, and performance metrics.
- Created automated refresh schedules, drill-through reports, slicers, and data models for advanced analytics.
- Optimized data models by implementing DAX calculations, relationships, and hierarchies, improving dashboard load time by up to 30%.
- Automated, repetitive manual tasks using Python scripts reduce processing time and human errors.
- I built Google Apps Script automations for Google Sheets and Gmail.
- Automated data extraction, cleaning, and validation processes.
- Set up an automated email with attached report links.
- Successfully eliminated 40–50 hours of weekly manual work, allowing teams to focus on strategic tasks.
- Reduced data processing errors by 20% through consistent, script-based validation.
- Constructed and maintained ETL pipelines using Informatica, ensuring seamless data movement from multiple sources to data warehouses.
Softyom Consulting Services Pvt. Ltd.Indore
DATA ANALYST EXECUTIVE
05.2024 - 08.2024
Job overview
- Strengthened analytical and problem-solving skills through hands-on internship experience, applying data analysis techniques to real-world business challenges.
- Developed proficiency in core Python libraries, including Pandas, NumPy, Matplotlib, and Seaborn, for efficient data manipulation, statistical analysis, and visual storytelling.
- Executed end-to-end data cleaning, preprocessing, and exploratory data analysis (EDA), transforming raw datasets into meaningful insights to support data-driven decision-making.
- Enhanced ability to create insightful dashboards, data visualizations, and trend analyses, preparing for more advanced data analytics responsibilities.
Mobar Networks Pvt. LtdIndore
FINANCE EXECUTIVE
02.2023 - 03.2024
Job overview
- Managed and analyzed large volumes of financial data using Microsoft Excel and Google Sheets, ensuring high data accuracy and integrity across reporting functions.
- Designed and implemented an in-house HR employee dashboard using Tableau, improving data accessibility, and enabling faster, insight-driven decision-making.
- Created comprehensive financial reports and interactive data presentations using Microsoft Word and PowerPoint, delivering clear, and actionable insights to stakeholders.
- Maintained and processed complex financial datasets with a strong focus on precision, contributing to effective budgeting, forecasting, and performance tracking.
Education
Radiant Institute of Management & ScienceIndore, India
Master in Commerce from Finance & Advanced Statistics
09.2024
University Overview
Indore Institute of LawIndore, India
Bachelor in Commerce from Tax Procedure & Practices
05.2022
University Overview
Skills
Language – Python, R
AI/ML Libraries – Numpy, Pandas, Matplotlib, Seaborn, Scikit-learn
Tools - Power-BI, Tableau, MS-Excel, Google Sheets, MS PowerPoint
Data Base - MYSQL, SQL Lite
Platforms – PyCharm, Jupyter Notebook, Visual-Studio Code
Data Warehousing – Azure Data Factory, Teradata, Google Big Query, ETL Workflows, SQL Report Building
Soft Skills- Report Building, Strong Stakeholder management, Strong Analytics , Adaptability
Certification
Data Analyst Internship Certification – Softyom Consulting Pvt. Ltd
Timeline
DATA ANALYST
Codify Software Services Pvt. Ltd.
12.2024 - Current
DATA ANALYST EXECUTIVE
Softyom Consulting Services Pvt. Ltd.
05.2024 - 08.2024
FINANCE EXECUTIVE
Mobar Networks Pvt. Ltd
02.2023 - 03.2024
Radiant Institute of Management & Science
Master in Commerce from Finance & Advanced Statistics
Indore Institute of Law
Bachelor in Commerce from Tax Procedure & Practices