Open to Data Analyst · BI Analyst · Business Analyst roles

Data Analyst & BI Analyst.

POWER BI · SQL · PYTHON · EXCEL · DAX

2.8 years of experience turning operational and business data into dashboards, analysis, KPI reporting and actionable insights across Automotive, Smart City and QSR domains. Currently working as an MIS Executive while pursuing an MBA in Business Analytics.

View projects Download résumé LinkedIn

2.8 yrsExperience

5+Core tools

3Domains

6+Projects

2.8 yrsAnalytics & MIS experienceCurrent: Automotive

3Industry domainsAutomotive · Smart City · QSR

58 → 16Registration pendencyOperational improvement

MBABusiness AnalyticsCurrently pursuing

Capabilities

Analysis that connects data to business decisions.

Data Analysis

Clean, validate and explore business and operational datasets to identify trends, exceptions and patterns.

Business Intelligence

Build Power BI dashboards, DAX measures and KPI reporting systems for recurring business decisions.

Business Insights

Identify root causes, performance gaps and operational opportunities from structured analysis.

Report Automation

Reduce repetitive reporting work with Excel, Power Query and Python-based workflows.

Analytics workflow

From raw data to an actionable insight.

01 / DATA

Collect

Pull orders, registrations, enquiries, logs and other operational sources.

02 / CLEAN

Validate

Deduplicate, reconcile, structure and validate the source data.

03 / ANALYZE

Analyze

Use SQL and Python to identify patterns, trends and root causes.

04 / VISUALIZE

Visualize

Build Power BI dashboards and KPI reporting around the findings.

05 / INSIGHT

Decide

Turn the output into a clear business action or decision.

About

A practical analytics profile.

I turn operational and business data into insights that support better decisions.

Across Automotive dealership analytics, Smart City / AI data operations, and QSR customer journey analysis, my work has centered on finding signal in scattered data, structuring it and reporting it clearly enough for someone to act on.

My day-to-day toolkit includes Power BI, SQL, Python, DAX and Excel, with a focus on dashboards, KPI reporting, data validation, business analysis and automation.

I am currently completing an MBA in Business Analytics at Amrita Vishwa Vidyapeetham alongside my professional work.

Analytics

SQLPythonPandasData CleaningEDAData Validation

BI & Visualization

Power BIDAXPower QueryTableauDashboard DevelopmentKPI Reporting

Business Analysis

Root Cause AnalysisSales PerformanceMarket ShareCustomer AnalysisOperational Analysis

Automation

Advanced ExcelPivot TablesXLOOKUPReport AutomationPython Automation

Experience

Where the analysis came from.

Nov 2025 — Present

MIS Executive

Nippon Motor Corporation Pvt. Ltd., Kerala

Developed and maintained daily MIS reports and KPI reporting covering sales orders, registrations, enquiries, conversions and operational pendency across three dealerships.
Analyzed enquiry-to-order conversion, registration pendency, test-drive activity and sales performance to provide management with operational insights.
Centralized dealership-level reporting using structured Excel-based workflows, improving visibility and reducing fragmented manual tracking.
Monitored registration pendency and highlighted operational bottlenecks, contributing to a reduction from 58 to 16 open cases.
Supported management decision-making through data validation, trend analysis, exception tracking and recurring performance reporting.

Nov 2023 — Apr 2025

Junior Lead — Data Analysis

Cogniphi Technologies

Automated repetitive data-processing workflows using Python/Pandas, reducing manual effort by approximately 35%.
Built Power BI dashboards and DAX measures to monitor annotation quality, productivity, throughput and team performance.
Led a 10-member data annotation team, implementing quality checks that reduced annotation errors by approximately 20%.
Translated operational datasets into KPI reports supporting Smart City data-collection and AI development workflows.

Apr 2023 — Oct 2023

Data Analyst

Cogniphi Technologies

Analyzed QSR customer journey and drive-through datasets to identify operational patterns and performance metrics.
Developed analytical dashboards supporting AI model development, engineering analysis and testing workflows.

Selected projects

Built around business questions, not just charts.

Each project demonstrates a combination of analysis, visualization, business reasoning and technical execution.

Power BI · DAX · Excel

Retail Sales Root Cause Dashboard

Integrated revenue, profit, discount and delivery data to isolate root causes of declining profitability.

Key finding: 21%+ discounting in Technology and delayed deliveries were identified as contributors to a South-region profit drop after July 2024.

View on GitHub →

Power BI · DAX · Excel

Marketing ROI Dashboard

Analyzed ROI, conversion rate, cost per conversion and revenue per customer at campaign level.

Finding: Mobile campaigns delivered 2.1× ROI on 40% of spend.

View on GitHub →

Power BI · SQL

QSR Customer Journey Dashboard

Analyzed customer wait times, peak-hour demand and service throughput to identify operational efficiency opportunities.

View on GitHub →

Python · RFM · K-Means

Customer Segmentation & Personas

Used RFM analysis and K-Means clustering to identify high-value customer segments and behavioral patterns.

View on GitHub →

Power BI · Python · EDA

Bike Sales Analysis

Exploratory analysis and dashboard covering the Indian bike resale market, regional performance, inventory patterns and customer demographics.

View on GitHub →

Python · XGBoost · SMOTE · SHAP · Streamlit

Fraud Detection Explorer

Built an end-to-end classification workflow with XGBoost, SMOTE for class imbalance and SHAP-based explainability.

View on GitHub →

Education

Formal study alongside professional work.

MBA — Business Analytics

Amrita Vishwa Vidyapeetham

Currently pursuing

B.Tech — Computer Science

Glocal University

Completed

Additional experience

Analytics simulations & applied training.

Quantium

Data Analytics Simulation

Customer analytics, uplift testing and strategic reporting on transaction data.

Certificate →

Tata Group

GenAI Powered Data Analytics

EDA and predictive framework work for delinquency risk using GenAI tools.

Certificate →

Deloitte

Data Analytics Simulation

Forensic data analysis and classification in Excel, presented via Tableau.

Certificate →

Tata Group

Data Visualization Simulation

Executive data visuals and strategic questions for leadership decisions.

Certificate →

Accenture

Data Analytics & Visualization

Cleaned and analyzed seven datasets for a social media client and presented findings.

Certificate →

Credentials

Certifications & learning.

IBM

Data Analysis Using Python

IBM

Data Visualization Using Python

Cisco

Data Analytics Essentials

Microsoft & LinkedIn

Career Essentials in Data Analysis

General

SQL and Relational Databases

General

Statistics Fundamentals

Google Cloud

Architecting with Google Cloud

UAE Initiative

1 Million Prompters

Contact

Open to the next analytics opportunity.

For Data Analyst, BI Analyst and Business Analyst opportunities, reach out directly.

appu12anand@gmail.com

↗

linkedin.com/in/appuanand

↗

GitHub

github.com/Appu-Anand