Narmatha Annadurai

Data Aspirant

[email protected]

Hello, I am

Narmatha Annadurai.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

I work at the intersection of data analysis and operations digging into messy, high-volume data to find where a process breaks down, then building the reporting and automation to fix it.

Over nearly 2 years in quality operations at Delta Electronics, I built Power BI dashboards, DAX models, and SQL-driven reporting that turned raw failure data into decisions leadership acted on.

Highlights:

* Analyzed 4,500+ failure cases monthly using SQL, Excel & Sheets
* Improved First Pass Yield by 16 percentage points
* Cut recurring customer complaints by 20% via 4 new QA checkpoints
* Resolved 90%+ of technical escalations with cross-border teams
* Led a team of 7 across 3 shifts, mentoring data-first thinking

Stack: SQL | Power BI | DAX | Excel | Google Sheets | Python (learning)
Certified: Microsoft PL-300 Power BI Data Analyst — 850/1000

Key Skills

SQL · Power BI · DAX · Advanced Excel · Google Sheets · Python (Basics)

Data Cleaning & Validation · Trend & Root Cause Analysis · Process Optimization · Data-Driven Decision Making

Strategic Planning · Stakeholder Management · Operational Support · 8D Problem-Solving · 5S & Control Plan Audits · Kaizen · Pre-Audit Expertise

Cross-Functional Team Leadership · CFT Meeting Leadership · Team Mentoring (7 direct reports) · Written & Verbal Communication · Presentation

My Projects

Decoding the 2026 Tamil Nadu Election: A Data Storytelling Project for AtliQ Media

Domain/Function: Media/ Broadcasting

India EV Market Entry Strategy - AtliQ Motors

Domain/Function: Market Intelligence & Predictive Strategy

AtliQ Hardware: Global Sales & Financial Performance Analytics

Domain/Function: Sales & Financial Analytics

Business Insights 360 Enterprise Reporting Engine

Domain/Function: Enterprise Analytics & Financial Decision Support

AtliQ Hardware: Automated SQL Sales Intelligence

Domain/Function: Sales & Finance Operations

My Experience

FlyRank AI Machine Learning Engineering Intern (Self-Paced) | Remote Jul 2026 – Present

Building Foundational ML Skills: Developing core machine learning and data analysis skills through a self-paced internship, gaining hands-on exposure to Python and foundational ML concepts to complement my data analytics background.

Delta Electronics Assistant Quality Assurance Engineer | Krishnagiri, TN Jul 2024 – Feb 2026

Field Failure Analysis & Cross-Border Support: Delivered root-cause analysis and technical support on a ₹50+ lakh BEX & EV Car Charger project, managing 5P-level failure investigations across component-level issues while coordinating directly with the Taiwan BU team. Escalation Management: Resolved 90%+ of complex technical issues and escalations through daily 24-hour tracking, coordinating with CFT, engineering, and Taiwan BU teams to drive rapid corrective action. Customer Advocacy & Process Improvement: Identified recurring pain points in customer complaints and implemented 4 critical-stage (CTQ) verification checkpoints, reducing customer complaint recurrence by 20%. Data-Driven Process Enhancement: Leveraged process data and trend analysis to identify 3 human-error-prone steps, translating insights into engineering checkpoints that improved defect detection efficiency by 13%. Advanced Analytics for Quality Optimization: Used SQL, advanced Excel, and Google Sheets to analyze 4,500+ failure cases monthly, improving First Pass Yield Rate by 16 percentage points. Team Leadership: Led a team of 7 (3 IPQC, 2 OQA, 2 GET trainees) across 3 shifts as engineer-in-charge, training them on process auditing and data analysis, and mentoring trainees ahead of IATF 16949 certification prep.

Delta Electronics GET – Industrial & QA | Krishnagiri, TN Jan 2024 – Jun 2024

5S & Control Plan Audits: Executed daily 5S and control plan audits across the production line, reducing recurring defects from 12% to 7%. Incoming Quality Re-Screening: Conducted incoming re-screening to catch vendor defects before customer escalation, reducing quality issues by 40%. Cross-Functional Scrap Reduction: Collaborated with issue owners across 30+ product models to drive root-cause resolution, reducing plant-wide scrap rate from 8% to 4%. Process Auditing: Served as a hands-on process auditor, driving defect prevention and root-cause resolution to ensure on-time, defect-free customer delivery.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Google Data Analytics

Business English: Management and Leadership

Certification Tests SQL (Advanced)

Certification Tests SQL (Intermediate)

Microsoft-Extract, Transform and Load Data in Power BI

Microsoft-Harnessing the Power of Data with Power BI

Microsoft-Preparing Data for Analysis with Microsoft Excel

Microsoft Certified: Power BI Data Analyst Associate

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/narmatha-annadurai-32ba14237/

GitHub

https://github.com/narmatha0303

PowerBI Project

Decoding the 2026 Tamil Nadu Election: A Data Storytelling Project for AtliQ Media

Domain/Function: Media/ Broadcasting

An election data storytelling project analyzing all 234 constituencies. Shifted the media narrative from basic statewide seat totals to granular, fact-based insights uncovering a 69.66% constituency flip rate, regional flip intensities, and hyper-competitive local margins.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

Power Query

DAX

Microsoft PowerPoint

Interactive Power BI dashboard tracking 2021 vs 2026 electoral insights. Features high-level KPI cards for the 163 flipped seats, a comparative party seat bar chart, a regional dominance matrix, and a dynamic top 10 closest contests table.

Executive stakeholder slide illustrating the "Connected Findings" storytelling framework. Connects constituency realignment data, regional flip intensities (such as Chennai Metro at 93.8%), and micro-margin competitiveness into a unified synthesis.

Project Details

Developed a descriptive analytics and data storytelling framework for AtliQ Media analyzing the Tamil Nadu Assembly Election across 234 constituencies. Shifted the stakeholder narrative from basic statewide seat counts to deep-dive micro-level trends focusing on constituency realignment, regional flip intensities, and local victory margins.

Key Analytical Pillars:
- Q2 Realignment: Quantified a major 69.66% statewide shift rate, proving that 163 out of 234 constituencies flipped winning parties, led by a 65-seat transition from DMK to TVK.
- Q1 Geographic Shift: Mapped localized concentration showing high flip intensities in Chennai Metro (93.8%) and Kongu (81.8%) versus stability in the Delta region (45.5%).
- Q6 Margin Analytics: Isolated electoral competitiveness, highlighting a historic 1-vote victory margin.
Engineered data validation pipelines using SQL window functions to ensure primary key (AC Number) integrity, building a clean, interactive Power BI executive dashboard.

Project video

Live Interactive Dashboard

PowerBI Project

India EV Market Entry Strategy - AtliQ Motors

Domain/Function: Market Intelligence & Predictive Strategy

Evaluated 2022-2024 EV market trends across 28 states and 50+ manufacturers using Power BI and SQL to design a strategic entry model. Identified high-penetration regional clusters, segment distribution channels, and infrastructure gaps to accelerate competitive market positioning.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

MS Excel

Data Modeling

Competitive Benchmarking

Trend Analytics

Power BI Data Model showing relationships between dim_date, electric_vehicle_sales_by_makers, electric_vehicle_sales_by_state, revenue, and operational tables for comprehensive EV market analysis

Executive Dashboard displaying key metrics: 57M total vehicles sold, 2M EV sales, 13.6% CAGR, state-wise penetration analysis, and projected EV sales 2030 for top 10 states by growth rate

Project Details

Problem: AtliQ Motors has 25% market share in North America but only 2% in India's EV market. How to enter a complex, price-sensitive, geographically fragmented ecosystem?

Analysis: Conducted comprehensive 2022-2024 EV market analysis across 28 Indian states, evaluating 50+ manufacturers using Power BI, SQL, and Excel.

Key Insights:

✅ Identified Maharashtra as top-performing state with 15% EV penetration and best charging infrastructure—primary entry market.
✅ Discovered 2-wheelers dominate (56% share) while 4-wheelers grow fastest (35% YoY), revealing dual-segment opportunity.
✅ Pinpointed infrastructure gap as biggest barrier—states with mature networks show 5-10x higher penetration.
✅ Validated Ola Electric (35% 2W share) & Tata Motors (4W leader) as benchmarks; no single national winner.
✅ Engineered state-level strategy: Karnataka (10.2%) and Delhi (8.7%) identified as secondary entry markets.

Project video

Live Interactive Dashboard

Excel Project

AtliQ Hardware: Global Sales & Financial Performance Analytics

Domain/Function: Sales & Financial Analytics

Engineered an automated financial reporting system in Excel to evaluate multi-year fiscal data across global markets. Utilized Power Query ETL and data modeling to structure P&L statements, track YoY net sales trends, and isolate high-growth product performance metrics.

View Project
on GitHUB

Other Tools

Power Query

Power Pivot

DAX Formulas

Data Modeling

Financial Reporting

Comprehensive Profit & Loss statement by market, showcasing Net Sales, COGS, and Gross Margin percentages.

Visualization of the top 10 products by revenue growth, highlighting the AQ Smash 2's 2,489.5% increase.

Project Details

The Problem : AtliQ Hardware lacked a centralized analytical framework to evaluate global market performance, net sales trends, and cross-border customer growth against set targets across different local currencies for the 2021 fiscal year.

The Implementation : Ingested and cleaned multi-year transactional records using Power Query ETL pipelines, designed a data model normalized to USD to calculate Gross Margin (GM%) and YoY growth, and built dynamic filters for granular regional and divisional exploration.

The Impact : Automated dynamic P&L statements and isolated a 541% growth surge for the 'AQ Electron 4 Desktop Processor'. Identified India as the primary market asset ($161.26M net sales), highlighted Amazon as the top customer ($82.1M), and structured a global grand total of $598.9M in net sales.

PowerBI Project

Business Insights 360 Enterprise Reporting Engine

Domain/Function: Enterprise Analytics & Financial Decision Support

Isolated an unmonitored $54.9M latent revenue gap and optimized interactive dashboard execution refresh tracking speeds by 40%. Developed high-performance relational architectures in Power BI to drive full KPI visibility, increasing the operational First Pass Yield Rate from 86% to 93%.

View Project
on GitHUB

Other Tools

Power BI

DAX

Excel

Power Query

This view provides a deep dive into product and customer performance. It features a bubble chart for Net Sales vs. GM% over time and a detailed table tracking SKU-level metrics like Gross Margin % and YoY variance.

This dashboard focuses on operational efficiency, featuring Forecast Accuracy % (68.12%) and absolute error tracking. It includes a trend analysis of accuracy vs. net error and risk profiling by customer and product segment (e.g., Desktop, Notebook).

Project Details

The Problem : The enterprise suffered from isolated, disconnected business unit data logs, causing massive cross-functional reporting silos and restricted operational visibility that masked an 86% baseline First Pass Yield Rate.

The Implementation : Orchestrated the extraction, data cleansing, and structural join consolidation of 5+ disparate business unit tracking datasets into a unified relational data model while writing complex custom DAX metrics and optimizing dimensional tables.

The Impact : Successfully broke down corporate reporting silos by 30%, accelerated interactive dashboard execution speeds by 40%, and drove real-time KPI tracking visibility that scaled the operational First Pass Yield Rate from 86% to 93% while isolating an unmonitored $54.9M revenue expansion opportunity.

Live Interactive Dashboard

SQL Project

AtliQ Hardware: Automated SQL Sales Intelligence

Domain/Function: Sales & Finance Operations

Engineered a centralized relational SQL database repository using optimized primary/foreign key indexing to manage high-frequency transactional data requests. Decreased manual ad-hoc technical report query overhead by 20% for 50+ global business partners via automated stored procedures.

View Project
on GitHUB

View Project
on GitHub

Other Tools

MySQL

Relational Database Schemas

Stored Procedures

Indexing

This Stored Procedure (get_market_badge) automates the categorization of business regions based on sales performance.

the successful translation of complex transactional data into a simple, actionable executive metric (the "Gold" status), which can then be used for regional marketing and incentive strategies.

Project Details

The Problem High-frequency transactional data operations were bottlenecked by slow, manual ad-hoc reporting pipelines, causing a massive technical request backlog and operational delays for business partners.

The Implementation : Engineered a centralized relational SQL database repository, mapped precise primary/foreign key connections, and programmed automated MySQL stored procedures (including dynamic get_market_badge optimization scripts) to handle complex backend queries.

The Impact : Eliminated redundant manual analytical compilation times and processing overhead, successfully decreasing ad-hoc technical request friction by 20% across 50+ global business partners through optimized, self-service analytical tables.

Already have an account? Sign in