Data Analyst - EV IoT & Dashboard Specialist

Mounika Mecharapu

Illinois, Chicago • ****************@*****.*** • +1-872-***-**** • Valid Work Permit Career Summary

Data analyst with 2 years of work experience in the electric vehicle (EV) product domain, leveraging agile and lean methodologies to optimize product performance and deliver iterative data analysis insights. Technical expertise in developing dashboards and visualizations using Power BI, Tableau, and Excel. Demonstrates strong problem-solving abilities and effective communication, facilitating stakeholder engagement by translating complex data findings into actionable recommendations. Proven track record of adapting to diverse projects and industries.

Education

Elmhurst University, Chicago 2025

Master of Engineering (Information Technology) Overall GPA: 4.0/4.0 Jawaharlal Nehru Technological University, Kakinada (JNTUK) 2022 Bachelor of Engineering (Electronics & Communication Engineering) CGPA: 8.59/10 Experience

Data Analyst Gear Head Motors, India Mar 2022 — Nov 2023

• IoT Data Analysis: Led the assessment of high-volume IoT telemetry and sensory data from electric vehicle (EV) motors. Successfully identified performance trends, achieving improved operational efficiency up to 93%.

• Dashboard Development: Designed and maintained real-time Key Performance Indicator (KPI) dashboards in Power BI, monitoring battery health and usage metrics.

• Automated Reporting Timelines: Efficiently built and automated reporting pipelines using SQL and Python, reducing manual reporting by 40%

• Stakeholder Management: Managed and collaborated with diverse stakeholders, including Strategy, UI, UX, CS, Data Science, the Development team, third-party firms, executives, customers, and partners to implement predictive analysis models for battery failure detection, ensuring a 15% reduction in system downtimes. Data Analyst Intern Gear Head Motors, India Dec 2021 — Feb 2022

• Data Development Support: Cleaned, transformed, and documented confidential data sets with 94% accuracy, integrating into analytics pipelines.

Key metrics: error rate reduction, data readiness time, validation success rate

• Analytics Documentations: Contributed to reporting standards, analytics documentation, and metadata structuring for cross-team accessibility.

• SQL and Excel Reporting: Assisted in writing optimized SQL queries and Excel-based performance reports to be used by engineering and production systems teams.

Key metrics: query execution time, report automation rate, stakeholder satisfaction rate, average report generation time Projects

Real-time Vehicle Dashboard

• Built a predictive model for battery failure forecasting with 92% accuracy, reducing unexpected downtimes and enabling proactive maintenance.

IoT Data Quality Framework

• Spearheaded ETL workflows with robust error-checking, schema validation, and missing value handling, ensuring high-quality input for analytical teams. Processed over 300K+ IoT sensor records daily with 99.5% accuracy. Skills

• Data Mining

• Python

• Power BI

• Extract, Transform,

Load (ETL) Pipelines

• Agile Sprints

• Verbal communication

• Microsoft Excel

• Statistical Analysis

• Data Warehousing

• SCRUM

• SQL

• Data Analysis

• R

• Adaptability

• Data Cleaning &

Preparation

• A/B Testing

• Dashboard

Development

• Time Management

• Cross-functional

Collaboration

• Tableau

• Data Governance

Certifications

• Joy of Computing Python by National Programme on Technology Enhanced Language (NPTEL) scored 86% Silver Category

• Andhra Pradesh State Skill Development Corporation (APSSDC) Data Science with Machine Learning: Trained in end-to- end machine learning workflows using tools like pandas, NumPy and scikit-learn

• Data Analytics and Programming Essentials in Python by CISCO Networking Academy

Contact this candidate