Available for New Opportunities

AVINASHDUBEY

Results-driven Data Analyst specializing in SQL, Power BI & Python — delivering BI solutions that drive revenue growth, retention, and operational efficiency.

LinkedIn ↗ GitHub ↗ View My Work → Get in Touch
Avinash Dubey
Avinash Dubey
Data Analyst
2.9
Yrs Exp
3+
End-to-End Analytics Projects
₹31CR+
Revenue Analyzed
15 HRS
Saved/Wk
SQLPower BIPythonExcelDAX
Driving Smarter Decisions Through Data Analytics
Transforming raw data into executive-ready insights — from SQL pipelines to Power BI dashboards that drive real business impact.
₹31.38 CR
Revenue Analyzed
1M+ ROWS
Data Processed
15 HRS/WK
Reporting Time Saved
// 01 — About Me

THE PERSON BEHIND THE DATA

Data Analyst with ~3 years of experience at I3-Infosoft, building end-to-end BI solutions for FMCG, retail, and financial services clients. I work across the full analytics stack — T-SQL pipelines, Power BI dashboards, DAX modeling, and Python-based data cleaning — delivering insights that directly affect revenue, retention, and operational efficiency.

Key work includes uncovering ₹20.96 Cr revenue at risk across 1L+ transactions, tracking $2.27M+ in retail sales with 46.9% YoY growth, and building churn dashboards that contributed to a ~12% reduction in customer attrition.

// 02 — Key Skills

TECH STACK

🗃
SQL & Databases
T-SQLSQL ServerCTEsWindow FunctionsComplex JoinsSubqueriesData ModelingETLData Warehousing
📊
Power BI & DAX
Power BIDAXStar SchemaPower QueryRLSKPI DesignForecastingData VisualizationStakeholder Reporting
🐍
Python & Analytics
PandasNumPyMatplotlibSeabornEDASnowflake (Learning)Amazon S3 (Basics)
📈
Excel & Reporting
Advanced ExcelPivot TablesReport AutomationPower BI ServiceSSMSAd Hoc Analysis
// 03 — Projects

MY WORK

slide banner
FMCG Revenue Assurance & Retention Analytics
slide 3
Cancellation Rate by Channel
slide 4
Customer Segmentation
slide 5
YoY Revenue Growth
slide 6
Return Analysis
slide 7
Payment Reconciliation
FMCG / Consumer Goods Analytics
FMCG Revenue Assurance & Retention Analytics
ProblemRevenue flat 4 years, 33% cancellation rate, zero consolidated reporting.
Dataset1L+ transactions · 9 source tables · 2022-2025
ApproachModular T-SQL analytics — revenue trends, churn classification, payment reconciliation
Insights33.5% cancellation · ₹20.96 Cr at risk · 2,389 at-risk customers
Impact
Production-ready SQL analytics layer · Cohort & segmentation analysis · Revenue recovery enabled
SQL ServerT-SQLSSMSExcel
Data PipelineRaw Data (CSV/SQL) ➔ SQL Server (ETL/Cleaning) ➔ T-SQL Analytics ➔ SSMS (Query Output) ➔ Excel (Validation)
View on GitHub →
slide banner
End-to-End E-commerce Performance & Growth Suite
slide 1
Sales & Profit Dashboard
slide 3
Customer Segmentation Dashboard
Ecommerce / Retail Analytics
End-to-End E-commerce Performance & Growth Suite
ProblemNo unified KPI view — zero visibility into trends, regional gaps, or customer behavior.
DatasetRetail transactional dataset · Orders, products, customers, regions
ApproachStar schema in Power BI + DAX for Sales, Profit, AOV, Delivery KPIs
Insights$2.27M+ sales · 46.9% YoY growth · 4-region segmentation
Impact
Star-schema DAX model adopted by executives · Retention strategy for low-engagement cohorts
Power BIDAXSQLExcel
Data PipelineRaw Data (CSV/SQL) ➔ SQL Server (ETL/Cleaning) ➔ Power Query (Data Modeling) ➔ DAX (KPIs) ➔ Power BI Dashboard
View on GitHub →
slide banner
FinServ Customer Attrition & Risk Profiling
slide 1
Churn Analysis Dashboard
slide 3
Data Model - Star Schema
Financial Services / Customer Analytics
FinServ Customer Attrition & Risk Profiling
Problem20.66% churn rate — no data on who was leaving, when, or why.
Dataset30K+ customers · Demographics, tenure, credit score, account balance · 2016-2019
ApproachSQL segmentation + Power BI star schema + DAX KPIs — churn rate, tenure analysis, risk profiling
InsightsFemale churn 56% higher · Fair credit = most exits · Inactive = top driver
Impact
Retention strategy targeting high-risk segments — ~12% churn risk reduction
SQL ServerPower BIExcel
Data PipelineRaw Data (CSV/SQL) ➔ SQL Server (ETL/Cleaning) ➔ Power Query (Data Modeling) ➔ DAX (KPIs) ➔ Power BI Dashboard
View on GitHub →
// 04 — Experience

WORK HISTORY

I3-InfosoftJul 2023 – Present
Data Analyst · Full-time
Noida, Uttar Pradesh, India
Power BISQL ServerT-SQLPythonDAXPower QueryExcel
📊 BI Development & Dashboarding — Designed and deployed 8+ Power BI dashboards using DAX, Power Query, and star-schema models — tracking Sales, Revenue, Churn, and Customer KPIs for weekly executive reporting.
🗃 SQL Analytics & ETL Pipelines — Analyzed 1M+ records/cycle using T-SQL, CTEs, and Window Functions across Retail, E-commerce, and Consumer Goods accounts. Optimized T-SQL query performance by ~25%.
👥 Customer Segmentation & Cohort Analysis — Conducted segmentation and cohort analysis for 50K+ customers — enabling targeted retention strategies and reducing churn risk by ~12%.
⚡ Automation & Data Quality — Automated ETL pipelines and reporting via Python, SQL & Power Query. Managed CSV/flat-file ingestion with data validation checks — reducing turnaround by 30–40%, saving ~15 hrs/week.
// 05 — Certificates

AWARDS & LEARNING

📊
Excel: Mother of Business Intelligence
Codebasics
View Certificate ↗
⚡
Get Job Ready: Power BI Data Analytics for All Levels 3.0
Codebasics
View Certificate ↗
🗃
SQL Beginner to Advanced For Data Professionals
Codebasics
View Certificate ↗
🐍
Python: Beginner to Advanced For Data Professionals
Codebasics
View Certificate ↗
🎨
The Art of User-Centric Power BI Dashboards
Codebasics
View Certificate ↗
🧠
Think SQL: Go from Zero to Hero
NamasteSQL
Download ↓
📈
Power BI For Business Intelligence
NamasteSQL
Download ↓
// 06 — Contact

LET'S WORK TOGETHER

Feel free to reach out — email, LinkedIn, or GitHub. I respond within 24 hours.

✉
Email
dubeyavinash157@gmail.com
 📱
Phone
+91 7007682626
 💼
LinkedIn
linkedin.com/in/avinash7007
 🐈
GitHub
github.com/Avinash7007
OPEN TO NEW ROLES

Actively seeking Data Analyst opportunities where I can deliver measurable business impact through SQL analytics, BI solutions, and automation-driven insights. If you're building something data-driven — let's connect.

Send Me a Message →