About
I am an Analyst with 5+ years of experience in manufacturing and consumer electronics, specializing in transforming operational data into actionable business insights. My expertise lies in SQL, Excel, and Power BI, where I work with structured datasets to perform data cleaning, exploratory data analysis (EDA), KPI tracking, and dashboard automation. I have experience querying large production datasets using SQL (JOINs, CTEs, Window Functions) to identify defect trends, optimize yield performance, and support data-driven decision-making. At Oppo Mobiles and Boat Lifestyle, I built KPI dashboards, conducted trend and variance analysis, and reduced reporting turnaround time by up to 30%. My work directly contributed to improving defect rates, increasing First Pass Yield (FPY), and optimizing production efficiency. What I bring: -Strong SQL querying and data exploration skills -Power BI dashboard development (DAX-based metrics) -Excel automation and advanced reporting -Business-focused analytical thinking -Clear stakeholder communication I am currently open to opportunities in: Data Analyst | Business Analyst | Operations Analyst | Product Analytics Let’s connect if you're looking for someone who can turn raw data into measurable business impact.
Skills & Expertise (13)
Work Experience
Analyst - Quality Assurance
Imagine Marketing India Ltd. - Boat Lifestyle
Sep 2023 - Dec 2023
Directed the development of 6 new PVT (Production Validation Test) devices for upcoming TWS earbud models, achieving a 15% reduction in production testing time. Designed automated Excel dashboards to track NPI model performance metrics, reducing manual reporting effort by 30%. Queried and analyzed production datasets using SQL (JOINs, GROUP BY, CTEs) to identify defect trends, reducing defect rate by 8%
Asst. Engineer - Design
Adroit Instruments
May 2019 - Jul 2020
Developed 3D models of plastic injection molding components in SolidWorks, translating detailed 2D drawings and physical prototypes, and enhancing design accuracy and efficiency by 40%. Interpreted technical drawings and made CAD modifications to existing models, decreasing lead times by 15%.
Field Service Coordinator
Johnson Controls - Hitachi Airconditioning
Jan 2018 - Sep 2018
Cleaned and transformed raw technician service datasets using Excel functions (Pivot Tables, VLOOKUP, INDEX-MATCH). Built performance dashboards tracking AMC renewals and service response metrics.
Analyst - Product Engineering
Oppo Mobiles India
Aug 2020 - May 2023
Conducted root cause analysis of structural and cosmetic issues during the smartphone lifecycle, reducing defect rate by 8%. Designed automated Excel KPI dashboards tracking FPY and OTPR metrics, contributing to a 15% increase in OTPR.
Education
Bachelor of Technology, Mechanical Engineering - Dr APJ Abdul Kalam Technical University (Formerly UPTU)
2013 - 2017 · India
Certifications
Career Essentials in Data Analysis by Microsoft and LinkedIn
Microsoft & LinkedIn · 2024
SQL Beginner to Advanced For Data Professionals
Codebasics · 2024
Power BI Data Analytics for All Levels 2.0
Codebasics · 2024
Google Project Management Professional Certificate (v2)
Google & Coursera · 2024
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Open to Relocation
