DHEEPIKA GNANASEKARAN
Data Analyst SQL Power BI Automotive & Manufacturing Analytics Client Reporting Chennai, India +91-986******* ********************@*****.*** Remote Ready PROFESSIONAL SUMMARY
Data Analyst with 3+ years of experience interpreting data and turning it into reports, dashboards, and actionable business insights. Background spans automotive manufacturing (MIS/production analytics at Lucas TVS) and financial services (loan portfolio and risk analytics at an NBFC), with hands-on experience building KPI dashboards, automating reporting processes, and improving data validation and accuracy. Skilled in SQL (joins, CTEs, aggregations, window functions), Power BI, and Python (Pandas) for analyzing large datasets, identifying trends, and presenting insights to both technical and non-technical stakeholders. Experienced liaising directly with internal and client stakeholders to understand reporting requirements and deliver reliable, decision-ready analysis. Comfortable working with manufacturing performance metrics and quick to build new domain knowledge, having adapted across automotive, finance, retail, and hospitality reporting environments. CORE SKILLS
Reporting & BI Tools: Power BI (Data Modeling, DAX, Power Query, Dashboards, RLS), Advanced Excel (PivotTables, VLOOKUP/XLOOKUP, Power Query), Google Data Studio / Looker Studio SQL & Databases: SQL (Joins, CTEs, Subqueries, Aggregations, Window Functions), Query Optimization, Google BigQuery Programming: Python (Pandas, Data Processing, Automation) Domain Exposure: Automotive Manufacturing (Production MIS, 4M Loss Analysis), Financial Services / NBFC Lending Analytics, Risk Segmentation
Analytics Process: KPI Definition & Tracking, Data Validation & Cleansing, Automation of Reporting Processes, Survey & Trend Analysis, Client & Stakeholder Reporting
Version Control: GitHub (source code and reporting asset management) PROFESSIONAL EXPERIENCE
Data Analyst Apr 2023 - Present
Real Touch Finance Limited (NBFC) Chennai, India
• Gathered and interpreted data from multiple sources (BigQuery, loan management systems, Google Sheets trackers) to identify patterns and trends across loan portfolios and customer segments.
• Built and maintained Power BI dashboards and scorecards reporting key performance indicators including disbursement value, approval rates, and collection efficiency, presented to internal stakeholders through weekly and monthly reviews.
• Identified areas to increase efficiency and automation of reporting processes; automated recurring workflows using Python
(Pandas) and Excel macros, reducing processing time by 25%.
• Implemented data validation and quality-check processes across multiple data sources to maximize reporting accuracy and consistency.
• Applied segmentation and risk analysis to categorize customers into risk tiers, contributing to a 10% reduction in default risk; translated findings into clear recommendations for business stakeholders.
• Worked directly with business stakeholders to understand reporting requirements and translate them into effective SQL and Power BI reporting solutions.
MIS Analyst May 2019 - Jul 2022
Lucas TVS (Automotive Manufacturing) Chennai, India
• Analyzed complex production datasets using Advanced Excel to identify trends, performance gaps, and opportunities for process improvement on the manufacturing floor.
• Built and maintained interactive dashboards and MIS reports tracking operational production KPIs, ensuring data accuracy and consistency for management reporting.
• Defined and tracked operational KPIs aligned with production targets, proactively flagging gaps between planned and actual performance to support manufacturing decision-making.
• Led 4M Loss Analysis (Man, Machine, Material, Method), identifying root causes of production inefficiency and recommending measurable, data-backed process improvements.
• Gained direct exposure to automotive manufacturing performance metrics and production data environments, within the TVS Group, a major Indian automotive and EV components group. PERSONAL PROJECTS
Supply Chain KPI Dashboard - FMCG (AtliQ Mart) (2023) Tools: Power BI, SQL
• Used SQL (CTEs, aggregations) to analyze supply chain datasets, identified performance gaps in OTIF, OT%, and IF% KPIs, and built an interactive Power BI dashboard supporting decisions that saved 20% on expansion investment. Sales and Revenue Insights - Retail Business (AtliQ Hardware) (2023) Tools: Power BI, SQL
• Converted business questions about revenue performance into structured SQL analysis and built a Power BI dashboard projected to boost revenue by 7%.
Retail Sales Data Cleaning & Analysis (2026)
Tools: SQL (Google BigQuery), Python (Pandas)
• Designed an end-to-end data cleaning pipeline in BigQuery SQL and Python (Pandas) to standardize inconsistent formats and missing data across a 4,300+ row dataset, documenting data-quality logic for auditability.
• Built and validated analytical queries to surface business insights on revenue, profit margin, return rates, and customer retention.
HR Analytics - Workforce Performance Tracking (2023) Tools: Power BI, Excel
• Defined workforce KPIs and built an interactive Power BI dashboard tracking performance trends; automated reporting saved 3- 4 hours of manual work daily.
EDUCATION & CERTIFICATIONS
B.E., Electronics and Communication Engineering
Anjalai Ammal Mahalingam Engineering College 2014 - 2018 Google Data Analytics Professional Certificate
Coursera (In Progress)