Lokesh Pandey
0
Excel
Projects
Power BI
0
Power BI
Projects
SQL
0
SQL
Projects
Python
0
ML & Python
Projects
Open to Opportunities

Hello, I am
Lokesh Pandey

|

Data Analyst turning business data into measurable decisions.
4+ years operational expertise combined with analytics & machine learning.

View Projects Get My CV
About Me

Who I Am

A unique blend of retail operations and data analytics

Lokesh Pandey
4+Years

Turning data into insights, and insights into action.

From Retail Floors to Data Pipelines

I'm Lokesh — a Data Analyst who bridges the gap between real-world operations and analytics. With 4+ years at Reliance Retail, I don't just analyze numbers — I understand the business behind them.

My toolkit — SQL, Python, Power BI & Excel — helps me turn messy, raw data into clear insights. From reducing stock variance by 15% to building ML pipelines with 84.68% accuracy, I believe in analysis that changes decisions.

15%
Stock Variance Reduced
84.68%
ML Churn Accuracy
20%
Model Improvement
40-60%
Faster Reporting
My Arsenal

Skills & Tools

Technologies I use to deliver results

Core Proficiency

Python85%
SQL90%
Power BI / DAX88%
Excel92%
Machine Learning75%
Data Visualization88%

DATA ANALYSIS

Python
SQL
Excel
Pandas
NumPy
Data Cleaning
Pivot Tables

VISUALIZATION & BI

Power BI
DAX
Dashboarding
KPI Design
Matplotlib
Seaborn

MACHINE LEARNING

EDA
Modeling
Scikit-learn
Evaluation
Feature Eng.
Portfolio

Featured Projects

Real-world data projects with measurable business impact

Amazon Sales
Excel Analytics

Amazon Sales Analytics Dashboard

  • Cleaned & standardized raw e-commerce data.
  • Built interactive KPI dashboards.
  • Tracked Revenue, AOV, & Order Volume.

ExcelData CleansingKPI
Wonderland Sales
SQL + Power BI

Wonderland Sales Analytics

  • Consolidated multi-year sales data with SQL.
  • Modeled customer segmentation & profitability.
  • Delivered insights for targeted marketing.

SQLPower BIDAX
Swiggy Sales
Excel Analytics

Swiggy Sales Analytics

  • Developed Pivot Table dashboards.
  • Analyzed monthly revenue & category performance.
  • Uncovered demand trends for management.

ExcelPivot Tables
Netflix Analysis
Python EDA

Netflix Content Strategy Analysis

  • Performed EDA on 6,200+ content titles.
  • Uncovered trends in ratings, genres & countries.
  • Identified that Movies dominate 70% of the library.

PythonPandasSeaborn
Churn Prediction
Machine Learning

Telecom Customer Churn Prediction

  • Predicted churn for 7K customers
  • Built ensemble ML models
  • Achieved 84.68% accuracy
  • Identified high-risk segments

Pythonscikit-learnML
Career

Work Experience

Professional journey and milestones

October 2021 — Present

Department Manager

Reliance Retail — Managed Services

  • Root cause analysis on 1,000+ SKU inventory data — reduced stock variance by 15%.
  • Built interactive Power BI dashboards & Excel reports for senior leadership.
  • Data cleansing & validation on multi-source datasets for reliable decisions.
  • Cross-functional collaboration to streamline reporting workflows.
  • Executive-ready BI presentations driving operational efficiency.
Power BIExcelData AnalysisKPIs
Sep 2025 — Mar 2026

Research & Analytics Intern

Labmantrix

  • ML models on large datasets — 20% improvement in predictive accuracy.
  • End-to-end analytics projects delivered within scope & timeline.
  • Research on emerging AI/ML technologies for actionable recommendations.
PythonMLEDAResearch
Background

Education

Academic qualifications

🎓

Bachelor of Business Management

Swami Vivekanand Inst., AP

2017 – 2020 (Distance)

GPA: 7.0 / 10
💊

Diploma in Pharmacy

Govt. Polytechnic Pithuwala, Dehradun

2014 – 2016

GPA: 8.0 / 10
Credentials

Certifications

Professional achievements

OdinSchool Certificate

Certified Data Science Professional

OdinSchool — Data Science Bootcamp

Issued: 04 October 2025

ID: ODIN1005371

Verify Certificate
Reach Out

Let's Connect

Always open to new opportunities & collaborations

Get in Touch

I'm always open to discussing data challenges, project ideas, or opportunities. Let's turn data into impact together.

Email

pandeylokesh87@gmail.com

LinkedIn

linkedin.com/in/lokesh-pandey

GitHub

github.com/Lokesh7-pqndey
Lokesh Pandey

Lokesh Pandey

Data Analyst | Data Scientist

pandeylokesh87@gmail.com
+91-9456382363
LinkedIn Profile
Get Resume