MOUNIKA CH
Southfield,USA
Summary
Results-driven data analyst with over 5+ years of professional experience spanning automotive, healthcare, retail, and supply chain domains. Proven expertise in ADAS camera system integration, business intelligence, and advanced analytics. Highly skilled in Python, SQL, Tableau, PowerBI, Excel, and cloud environments, consistently delivering actionable insights for stakeholders.
Overview
6
6
years of professional experience
Work History
Software Engineering (ADAS Project)
Magna Electronics
10.2024 - 04.2025
- Configured and integrated camera modules for road object detection in ADAS systems, ensuring robust calibration and reliable performance under variable conditions.
- Workflow management - Project Requirements, SRS, tasks and issues using JIRA.
- Developed detailed functional and non-functional requirements, created use case diagrams, and worked closely with cross-functional teams to ensure alignment with overall project objectives in Software Requirements Specifications (SRS).
- Identified and resolved compiler/runtime warnings, improved memory safety, and optimized hardware-software integration for enhanced system stability in C programming debug and optimization.
- Developed and maintained interactive Excel dashboards to visualize test cycles, automate data consolidation, and monitor key performance indicators for camera systems.
- Hands-on experience with GitHub handling Code with Helix QAC warnings.
- Utilized Excel pivot tables and advanced formulas to validate detection metrics, identify issues, and support system improvements.
- Automated reporting and conducted trend analyses with Excel macros, streamlining manual documentation and accelerating project decisions.
- Developed Tableau dashboards to visualize camera detection accuracy and system warning events for stakeholder analysis.
- Collaborated to design complex functional test cases, leveraging SQL-based validation for system assessment.
- Environment: C, Python, PowerBI, Tableau, Excel, SQL, VS Code, GitHub, Jira, Jenkins, Helix QAC, Windows, Linux.
Data Analyst
M3 Software Solutions
11.2021 - 05.2023
- Led analytics projects for healthcare, supply chain, and education domains, optimizing Excel spreadsheet models for claims analysis, forecasting, and progress tracking.
- Automated project reporting with Excel macros, improving operational efficiency and reducing manual effort.
- Created complex Excel templates and formulas to standardize analysis, enhance data quality, and streamline team workflow.
- Built dynamic Tableau and PowerBI dashboards, integrating Excel and database datasets for impactful insights.
- Designed interactive Power BI dashboards with complex DAX calculations, layered filters, and slicers for drill-down analyses across domains.
- Integrated multiple data sources (SQL Server, MySQL, Oracle) to create unified datasets for flexible Power BI reporting and visualization.
- Developed and optimized queries in SQL Server, Oracle, and MySQL with Excel-driven validation and analytics logic.
- Conducted financial and resource modeling using Excel for project budgeting and tracking outcomes.
- Environment: SQL Server, MySQL, Oracle, PowerBI, Tableau, Excel, SAS, SSAS, Snowflake, Windows.
Data Analyst
Insta Global Source Pvt Ltd
03.2019 - 10.2021
- Produced monthly reports by designing Excel dashboards and advanced formulas for cost analysis, project status, and sales forecasting.
- Automated reporting in Excel using macros, increasing efficiency and reliability of project deliverables.
- Used Excel pivot tables to consolidate operational and financial data from database sources.
- Led the migration of business models to advanced Excel formats for reporting accuracy and stakeholder visibility.
- Performed competitor and market analysis via Excel analytics tools for improved business insights.
- Built and maintained SQL-driven data models for sales, finance, and operations metrics, enhancing report generation and supporting business growth.
- Scheduled automatic data refreshes in Power BI, maintaining up-to-date, validated metrics from SQL views and external connectors.
- Applied advanced SQL window functions and CTEs for cohort analysis and time-series reporting within regular business reviews.
- Environment: MySQL, SQL Server, Oracle, Excel, Tableau, PowerBI, SAS, SSAS, Python, Windows.
Education
Master of Science - Information Technology Management
Campbellsville University
KY05.2025
Skills
- Python, NumPy, Pandas, Matplotlib, Jupyter Notebook
- MySQL, SQL Server, Oracle, SQL
- Tableau, PowerBI, Excel, SAS, SSAS
- Docker, Snowflake
- C programming
- GitHub, Jira, Jenkins
- PyCharm, VS Code
- Helix QAC, Total Phase
- ETL pipelines, Data Visualization, Business Intelligence
Timeline
Software Engineering (ADAS Project)
Magna Electronics
10.2024 - 04.2025
Data Analyst
M3 Software Solutions
11.2021 - 05.2023
Data Analyst
Insta Global Source Pvt Ltd
03.2019 - 10.2021
Master of Science - Information Technology Management
Campbellsville University