Sudharsanan Ravichandran

WORK EXPERIENCE

Data Analyst Intern – Clement Albert IT Services – France October 2024 – May 2025

Analyzed 10M+ records with MySQL/Python, delivering insights that increased revenue by 12%.
Designed Power BI/Tableau dashboards, enabling real-time manufacturing KPI’s tracking and reducing report time by 30%.
Built time-series models, improving supply chain accuracy by 18% and reducing inventory costs 15%.
Automated data collection and cleaning workflows, saving 20+ hours/month and cutting reporting errors by 25%.

Master Thesis – Magna Electronics Europe GmbH & Co. OHG – Germany October 2023 – May 2024

„Developing a Strategic Industry 4.0 Roadmap for Adoption in Magna Electronics globally by 2030 “, (Grade 1,0)
Developed Power BI dashboards integrating IoT data to visualize Industry 4.0 trends and used SQL queries to extract insights from large datasets.
Analyzed operational gaps using SQL for data extraction, Excel for scenario modeling, and Power BI for visualizing future-state projections.

Working Student – Magna Electronics Europe GmbH & Co. OHG – Germany March 2023 – September 2024

Designed real-time Power BI dashboards integrating SQL-based operational data from nine manufacturing plants, enabling KPI monitoring and decision-making.
Streamlined customer requirement analysis with SQL queries and tracked quoting process efficiency using Power BI.
Automated quotation generation using Excel VBA, reducing manual effort by 50%, and tracked system improvements with Power BI dashboards.
Developed multilingual Power BI dashboards to present quotation system performance metrics to global teams.

Intern – Magna Mirrors Holding GmbH (MML) – Germany August 2022 – January 2023

Build a dashboard showcasing cost comparisons and efficiency metrics for EV charging port mechanisms versus competitor products.
Create dashboards that visualize supplier performance trends and production feasibility metrics to support decision-making during prototype development.
Create dashboards summarizing 3D printer outputs and comparing them against expected design specifications.

Product Engineer – SL Lumax – India July 2017 – September 2021

Used Excel's conditional formatting and Power Query to clean and prepare production datasets for performance analysis.
Utilized advanced Excel functions (e.g., VLOOKUP, INDEX MATCH) to analyze component failure rates and identify root causes.
Developed interactive dashboards using PivotTables and charts to visualize production trends and optimize resource allocation.
Conducted regression analysis in Excel to evaluate the impact of material changes on product durability.

Master of Business Administration and Engineering (MBA & Eng.) Hof University of Applied Sciences – Hof October 2021 – July 2024: Program – Operational Excellence
Major: Data Analytics, Project Management, Industry 4.0 | Grade: 1,6

Bachelors of Engineering Anna University – India July 2013 – May 2017: Program – Mechanical Engineering
Major: Product Development | Grade: 2,0