Summary
Overview
Work History
Education
Skills
Projects
Certification
Accomplishments
Affiliations
Timeline
Generic

Rohit Angre

Pune

Summary

Data Analyst with 4+ years of experience working with data as a strategic asset across in large, multi-business organizations. Experienced in bringing together data, tools, and people, including platforms such as Power BI, Python, SQL, Snowflake, Excel, ERP, and PIM systems to streamline processes and deliver measurable business value. Strong background in product master data, data governance, analytics, and automation, with a proven ability to translate stakeholder requirements into scalable, data-driven solutions. Known for clear communication, strong presentation skills, and effective cross-functional collaboration.

Overview

7
7
years of professional experience
3
3
Certifications

Work History

Data Analyst

Eaton
Pune
01.2023 - Current

Product Master Data & Governance

  • Owned end-to-end product master data management across multiple business divisions: ICD, PCD (Products Component Division), B-Line, and Life Safety.
  • Partnered with Product Management, Engineering, Supply Chain, and IT teams across North America to onboard, update, extend, and obsolete product data.
  • Ensured high data quality and governance across Eaton.com, Order Center, Bidman, and distributor syndication platforms.
  • Drove continuous improvement in data quality, increasing Data Quality KPI scores from ~85% to 90%+ across all managed businesses.

Analytics, Automation & Data Consulting

  • Used SQL, Python, and Power BI to extract, analyze, validate, and visualize large datasets.
  • Built dashboards and validation reports to identify gaps, drive cleanup actions, and support data governance decisions.
  • Supported UATs and platform migrations, including transition from Cloudera to Snowflake.
  • Actively contributed to defining and validating the Enterprise Product Hierarchy using large-scale data comparisons.

ERP, PIM & System Migrations

  • Played a key role in enterprise-wide migration from legacy ERP (Vista) to SAP S/4HANA, supporting reconciliation of millions of product records.
  • Built metrics and dashboards to validate alignment across SAP, legacy ERP, and PDH (Oracle-based PIM).
  • Currently supporting migration from PDH to Stibo, contributing to PIM modernization and adoption.

Junior Engineer – Manufacturing & Product Data

Flex
Pune
11.2021 - 12.2022

Manufacturing & Product Data Management

  • Executed engineering and manufacturing change management by processing ECOs, MCOs, and deviations, ensuring data accuracy and traceability across systems.
  • Managed and maintained product master data across Agile PLM, SAP, and ERP systems, including part creation, obsolescence, and item master governance.
  • Performed extensive BOM structuring, cleansing, validation, and data migration, including importing and exporting large datasets using advanced Excel and ERP tools.
  • Designed and delivered metrics, dashboards, and analytical reports for parts, inventories, and product transitions, and presented insights to global stakeholders during weekly and monthly reviews.
  • Acted as a data liaison between product managers, engineering, supply chain, and manufacturing teams, gathering requirements and translating them into structured data outputs.
  • Supported BOM analysis, part qualification, and project transitions across multiple sites in the AMER region, using data to drive readiness and alignment.
  • Developed automation solutions using Excel macros and RPA workflows to streamline repetitive data operations, improving data processing efficiency and reducing manual effort.
  • Created and maintained SOPs, work instructions, and one-point lessons to standardize product data handling, improve data quality, and ensure compliance.

Supplier Quality Engineer

TE Connectivity
Pune
07.2019 - 08.2020
  • Analyzed supplier quality performance data for local and overseas suppliers to ensure compliance with automotive quality standards.
  • Performed root cause analysis using 8D methodology, 5W2H, and Fishbone diagrams, and prepared data-backed 8D reports for supplier issue resolution.
  • Reviewed and validated PPAP documentation, including process capability (CP, CPK) and control plans, to assess supplier manufacturing readiness.
  • Collaborated with Manufacturing and Design Engineering teams to evaluate supplier process data and ensure adherence to required quality standards.
  • Assisted in supplier and customer audits, providing data, reports, and quality metrics to support audit requirements.
  • Monitored and reported supplier quality metrics, enabling data-driven decision-making and continuous improvement initiatives.

Education

Bachelor of Engineering (B.E.) - Mechanical Engineering

Dhole Patil College of Engineering
Pune
06-2019

Skills

Data & Analytics: Data Wrangling, Data Quality, Data Governance, KPI Tracking, Reporting & Insights


Tools & Technologies: Python, SQL, Power BI, Snowflake, SAP S/4HANA, PDH (Oracle-based PIM), Stibo ,SharePoint, Copilot


Automation: Python Scripting, Excel VBA & Macros, Process Automation


Data Platforms: ERP Systems (SAP, Legacy ERP), PIM, Cloud Data Warehouses


Soft Skills: Stakeholder Management, Cross-functional Collaboration, Presentation & Communication, Requirement Gathering

Data Governance & Master Data: Master Data Management (MDM), Product Master Data, Data Quality Frameworks, Business Rules & Validation, Metadata Management, Data Stewardship

Projects

Excel VBA Automation – Aerospace Product Catalog Decoding (Eaton)

•  Built an Excel VBA tool to decode complex alphanumeric catalog numbers (1.5 lakh+ parts) into 32+ product attributes.
•  Automated extraction of specifications and dimensional data previously stored across multiple PDF reference tables.
•  Reduced manual decoding time from 15–20 minutes per part to under 30 seconds, enabling faster website data onboarding and drawing automation.

Python Automation – Asset & Link Quality Validation (Eaton)

•  Developed Python scripts to proactively scan product document and image links for breakage and quality issues.
•  Validated image standards (resolution, DPI, background, naming conventions) and generated actionable Excel reports.
•  Helped reduce customer complaints by identifying issues before public exposure.

Python Web Scraping – Market Research Automation (Eaton)

•  Built a web scraping solution to monitor government tender listings using **23 targeted keywords**.
•  Automated extraction of tender details and links into Excel for the market research team.
•  Significantly reduced manual search effort and improved response time to market opportunities.

Power BI – Data Alignment & Inventory Dashboards (Eaton)

•  Created Power BI dashboards to compare and validate data across SAP, legacy ERP, and PIM systems during ERP migration.
•  Implemented governance logic using DAX to identify misalignment and data quality gaps.
• Developed an Inventory vs Orders dashboard for the Canada business, used by senior leadership in weekly operational reviews.

Certification

Data Analytics Certification - ExcelR

Accomplishments

Received 21 performance awards in 3 years, including Star of the Quarter (2x), Gem of the Month, Bright Beginner, Above & Beyond, and other stakeholder-driven recognitions.

Affiliations

CSR Lead – Sales & Marketing (SMC), Eaton

• Lead Corporate Social Responsibility (CSR) initiatives for the Sales & Marketing (SMC) organization at Eaton.

• Drive and coordinate CSR activities across Health, Education, and Environment domains.

• Plan and execute CSR events in collaboration with NGOs, schools, and community organizations.

• Manage end-to-end execution including stakeholder coordination, event planning, volunteering activities, and impact tracking.

• Recognized as a trusted point of contact for cross-team CSR engagement and community outreach.

Timeline

Data Analyst

Eaton
01.2023 - Current

Junior Engineer – Manufacturing & Product Data

Flex
11.2021 - 12.2022

Supplier Quality Engineer

TE Connectivity
07.2019 - 08.2020

Bachelor of Engineering (B.E.) - Mechanical Engineering

Dhole Patil College of Engineering
Rohit Angre