Open to Opportunities

Turning Business Data Into Decisions.

Data Analyst combining SQL, Python, Power BI and 4+ years of business operations experience to uncover insights, build analytics solutions, and support better decisions.

Lokesh Pandey — Data Analyst
4+ Years Experience
4+ Years Business Operations
SQL Advanced Analytics
Power BI Dashboarding & BI
Python Data & ML
8+ Analytics Projects

From Operations Floor
to Data Pipeline

Lokesh Pandey

Most analysts understand data. I understand the business behind it.

With 4+ years managing data and operations at Reliance Retail, I've spent years on the ground — tracking inventory across 1,000+ SKUs, diagnosing stock variances, preparing executive-ready reports, and collaborating cross-functionally to drive operational efficiency. I know what it costs when data is wrong and what it enables when analysis is right.

I expanded into analytics and data science through structured training at OdinSchool and an internship at Labmentix Private Limited, where I built ML pipelines that delivered a 20% improvement in predictive accuracy. Today I combine both worlds: the business context to ask the right questions and the technical toolkit — SQL, Python, Power BI — to answer them with evidence.

My work doesn't stop at a dashboard. It ends at a decision.

Business Operations Reliance Retail · 4+ yrs
Analytics & BI Power BI · SQL · Excel
Python & ML OdinSchool · Labmentix
Data-Driven Decisions Full-stack analyst
0
%
Stock Variance Reduced
Root cause analysis on 1,000+ SKUs at Reliance Retail
0
%
Predictive Accuracy Gain
ML model improvement at Labmentix internship
84.68
%
Churn Model Accuracy
Telecom customer churn prediction project
40–60
%
Faster Reporting
Automated dashboards for senior leadership

Work Experience

Sep 2025 — Mar 2026

Research & Analytics Intern

Labmentix Private Limited

Python ML EDA Research
Problem
Large datasets with underperforming predictive models requiring accuracy improvement.
Action
Built and tuned ML models using Python and scikit-learn. Conducted end-to-end analytics projects from data ingestion to model evaluation. Researched emerging AI/ML methodologies for actionable recommendations.
Impact
20% improvement in predictive accuracy. Delivered projects within scope and timeline.
Oct 2021 — Present

Department Manager — Data & Operations

Reliance Retail (Managed Services)

Power BI Excel Data Analysis SAP
Problem
High stock variance across 1,000+ SKUs impacting inventory accuracy and decision-making quality for senior leadership.
Action
Conducted root cause analysis on inventory data. Built interactive Power BI dashboards and Excel reports. Performed data cleansing and validation across multi-source datasets. Collaborated cross-functionally to streamline reporting workflows.
Impact
15% reduction in stock variance. 40–60% faster reporting cycles for executive stakeholders.

Featured Projects

Flagship Project
Food-Tech · Churn Analytics · ML

Swiggy End-to-End Data Analytics & Churn Prediction

A complete analytics pipeline — from raw SQL modeling to machine learning churn prediction — built on a 150K+ order dataset across 11,419 restaurants and 100K users. Identified that 80% of revenue comes from just 20% of users, and predicted 87.76% of churning customers using a Random Forest model.

SQL Python scikit-learn Power BI Flask Docker
Dataset
150K+ orders
SQL Modeling
5-table pipeline
EDA & RFM
Segmentation
Random Forest
AUC 0.91
Retention
Action Plan
150K+Orders Analyzed
₹964MRevenue Dataset
0.91ROC AUC Score
87.76%Churn Detected
11,419Restaurants
5-pagePower BI Dashboard
Media · Content Intelligence

Netflix Content Strategy Analysis

What does Netflix's catalog tell us about their content strategy?

8,000+Titles Analyzed
68%Movies
33%TV-MA Content

EDA across 8,000+ titles revealing content composition, genre distribution, regional patterns, and missing data insights. Delivered actionable content intelligence using Python visualization stack.

Python Pandas Matplotlib Seaborn
E-Commerce · Sales Analytics

Amazon Sales Analytics

How can sales performance data drive better product and category decisions?

KPIDashboards
MultiCategory

Cleaned and standardized raw e-commerce data, built interactive dashboards tracking revenue, AOV, and order volume trends. Category-level profitability analysis for business decision support.

Excel Data Cleaning KPI Design Pivot Tables
Finance · Interactive Dashboarding

Mutual Fund Analysis Dashboard

How can investors visually track and compare mutual fund performance?

PythonAnalysis
Power BIDashboard

Combined Python-based financial analysis with Power BI interactive dashboarding to enable fund performance comparison, return analysis, and risk evaluation.

Python Power BI DAX Financial Analytics
HR · Workforce Intelligence · SQL

Fintech HR Analytics SQL Project

Which employees are at retention risk and which departments drive payroll costs?

30KEmployees
6Departments

Advanced SQL analysis using CTEs, Window Functions, and CASE statements to identify salary variance, retention risk, and workforce distribution across 30,000 employee records.

MySQL CTEs Window Functions EDA
Marketing · Segmentation Analytics

Customer Segmentation

How can behavioral data group customers into actionable segments?

RFMSegmentation
PythonPipeline

End-to-end customer segmentation using Python. Behavioral clustering to identify high-value, at-risk, and dormant customers for targeted marketing action.

Python Pandas Clustering EDA
Telecom · Predictive ML

Telecom Customer Churn Prediction

Which customers are most likely to churn, and why?

7K+Customers
84.68%Accuracy

Built ensemble ML models including Voting Classifier to predict churn on a 7,000+ customer telecom dataset. Identified high-risk customer segments for proactive retention.

Python scikit-learn Voting Classifier EDA

What I Can Do With Data

SQL & Data Modeling

Complex multi-table queries, CTEs, window functions, and data pipeline construction from raw sources to analysis-ready models.

MySQL · PostgreSQL · CTEs · Window Functions
"Why are revenue numbers inconsistent across reports?"

Business Intelligence

Multi-page Power BI dashboards with DAX measures, KPI tracking, and executive-ready reporting for operational and strategic decisions.

Power BI · DAX · KPI Design · Dashboarding
"What does leadership need to see every Monday morning?"

Python Analytics

End-to-end EDA, data cleaning, transformation, RFM segmentation, and visualization using the full Python analytics stack.

Pandas · NumPy · Matplotlib · Seaborn · EDA
"What patterns exist in this 100K+ row dataset?"

Predictive Analytics

Feature engineering, ML model development, evaluation with ROC AUC, and churn / risk prediction for business decisions.

scikit-learn · Random Forest · Voting Classifier
"Which customers will leave us in the next 30 days?"

Business Analysis

Root cause analysis, inventory diagnostics, operational KPI design, and translating business questions into analytical frameworks.

Root Cause Analysis · KPI Frameworks · SAP
"Why has stock variance increased by 10% this quarter?"

Dashboard Development

Interactive, executive-ready dashboards with drill-through capability, dynamic filters, and clear data storytelling.

Power BI · Excel · Pivot Tables · Advanced Excel
"Can we replace this 40-page report with something actionable?"

Technology Ecosystem

SQL & Databases

SQL MySQL CTEs Window Functions Subqueries Data Modeling

Python & Analytics

Python Pandas NumPy Matplotlib Seaborn EDA Jupyter

BI & Visualization

Power BI DAX Advanced Excel Pivot Tables KPI Design Dashboarding

Machine Learning

scikit-learn Random Forest Feature Engineering Model Evaluation Predictive Modelling RFM Segmentation

Business Analytics

Business Analytics Root Cause Analysis KPI Frameworks Stakeholder Reporting Inventory Analysis

ERP & Operations

SAP Data Cleaning Data Validation Reporting Automation Operations Analytics

Certifications

OdinSchool

Certified Data Science Professional

Data Science Bootcamp
October 4, 2025 ID: ODIN1005371
Verify Certificate
BCG · Forage

Data Science Job Simulation

BCG Virtual Experience
Deloitte · Forage

Data Analytics Job Simulation

Deloitte Virtual Experience

Academic Background

2017 – 2020

Bachelor of Business Management

Swami Vivekanand Institute of Management Science & Technology
Distance · GPA: 7.0 / 10
Programme

Data Science Certification

OdinSchool
Completed Oct 2025 · ID: ODIN1005371
2014 – 2016

Diploma in Pharmacy

Govt. Polytechnic College, Dehradun
GPA: 8.0 / 10

GitHub Work

Have a data problem
worth solving?

Open to Data Analyst, Business Analyst, and analytics-focused opportunities. Let's talk about how data can drive your next decision.

Download Resume