Cricket enthusiast; served as team captain, leading the side to two premiership wins (2021 & 2022) and back-to-back grand final appearances (2024 & 2025)
Rohit Gupta
Data Analyst
Carnegie
Summary
Analytical and results-driven Data Analyst with proven experience in transforming complex datasets into clear, actionable insights that support strategic decision-making. Highly skilled in Excel, Tableau, SQL, Power BI (currently pursuing Microsoft Power BI Data Analyst certification), and automation tools, with a strong track record of building interactive dashboards, optimizing reporting processes, and delivering meaningful business insights. Adept at stakeholder engagement, data storytelling, and process improvement, leveraging Lean Six Sigma methods to drive efficiency and accuracy. Passionate about using data to uncover trends, guide supply chain performance, and empower smarter decisions in a collaborative environment.
Overview
4
4
years of professional experience
9
9
Certifications
Work History
Materials Data Analyst
PACCAR
09.2022 - Current
- Partner with suppliers, planners, and other business stakeholders to gather reporting requirements, ensuring data outputs align with strategic objectives and support inventory management, order compliance, and supply performance.
- Cleanse, transform, and analyze complex datasets using SQL (Snowflake & SQL Management Studio), Excel, and Tableau, ensuring accuracy and consistency of supply chain reporting.
- Apply statistical and analytical methods to optimise Safety Stock, contributing to improvements in stock availability and order fulfillment.
- Enhance decision-making processes with accurate data analysis and advanced visualization techniques in Tableau and Excel, delivering clear insights into inventory, order compliance, and supply chain KPIs.
- Design, develop, and maintain interactive dashboards to provide real-time visibility into inventory levels, order status, and operational performance metrics.
- Translate supply chain trends and KPIs into clear, actionable insights for leadership teams, utilizing data storytelling to drive strategic decisions.
- Monitor and analyze key supply chain performance indicators, proactively identifying risks, bottlenecks, and opportunities for process improvement across inventory management and supply performance.
- Lead continuous improvement initiatives using Lean Six Sigma tools and root cause analysis, implementing effective countermeasures to optimize supply chain processes, and reporting accuracy.
- Automate manual data and reporting processes using Power Automate, SQL scripting, and dashboard enhancements, reducing turnaround time, and enhancing reporting efficiency.
- Collaborate on cross-functional projects to ensure data-driven solutions are embedded in business processes and operational strategies.
Mechanical Assembler
PACCAR
12.2021 - 09.2022
- Collaborated with other line workers and team members to assemble and fit truck parts in more than 1500 trucks across 8 months.
- Notified engineering of errors and discrepancies.
- Maintained neat and clean work area, clearing debris, organizing parts and keeping spaces open.
- Interpreted technical drawings, work instructions, and process documentation to deliver accurate and efficient assembly.
- Applied a continuous improvement mindset, identifying inefficiencies in assembly processes, and suggesting improvements that enhanced productivity and quality.
- Developed strong attention to detail, problem-solving, and teamwork skills in a fast-paced manufacturing environment.
Education
Master of Banking And Finance - Banking And Finance
Monash University
Clayton, VIC 04.2001 -
Bachelor's Degree - Mechanical Engineering
Shivaji University
India 04.2001 -
Skills
Tableau
Excel
Power BI
SQL
Inventory Management
Process Improvement (Lean Six Sigma Trained)
VBA Programming
Statistical Analysis
Accomplishments
- Recognized with the Employee of the Quarter Award for outstanding performance, initiative, and contribution to data-driven decision-making.
- Achieved highest rating in annual performance appraisal, reflecting consistent delivery of high-quality insights, stakeholder support, and process improvements.
Certification
Google data Analytics Professional Certificate
Interests
Timeline
Time Management
08-2025
Mini-MBA
08-2025
Presenting with Impact
06-2025
Google data Analytics Professional Certificate
10-2024
Tableau Advanced
08-2024
Lean Training
11-2023
SQL Essentials
03-2023
Tableau Intermediate
11-2022
Materials Data Analyst
PACCAR
09.2022 - Current
Mechanical Assembler
PACCAR
12.2021 - 09.2022
Master of Banking And Finance - Banking And Finance
Monash University
04.2001 -
Bachelor's Degree - Mechanical Engineering
Shivaji University
04.2001 -
Similar Profiles
Muhammad NormanMuhammad Norman
Material Handler at PACCARMaterial Handler at PACCAR
Soham ThakurSoham Thakur
Quality Assurance Technician at PACCARQuality Assurance Technician at PACCAR
Belinda GarciaBelinda Garcia
Account Management Department at PACCARAccount Management Department at PACCAR
Ngaio InskipNgaio Inskip
Additional Educator: Early Childhood at Glen EducationAdditional Educator: Early Childhood at Glen Education
Jim ZimbickiJim Zimbicki
Stay-at-Home Dad at Self-EmployedStay-at-Home Dad at Self-Employed