Open to Work · Mumbai, India

Janki
Buchhada

Data Analyst  ·  MIS Executive  ·  BI Analyst

Results-driven Data Analyst with expertise in Python, SQL, and Power BI. Proven track record of analyzing 180K+ transactions, building dashboards tracking $24M+ revenue, and delivering insights that drive strategic decisions.

180K+
Transactions Analyzed
$24M+
Revenue Tracked
3
BI Dashboards Built
Janki Buchhada
jankibuchhada@gmail.com LinkedIn GitHub
Why Choose Me

What Sets Me Apart

Proven Project Impact

Delivered 3 end-to-end analytics projects with measurable outcomes — 99% data accuracy, $24M+ revenue tracking, and 15% revenue growth recommendations.

Full Analytics Stack

Proficient across the entire data pipeline — Python for processing, SQL for querying, Power BI & DAX for visualization, and Excel for reporting.

AI-Ready Analyst

Completed GenAI-powered data analytics simulation with TATA via Forage, experienced in AI-driven collections strategy and delinquency prediction.

Big-4 Exposure

Completed Deloitte's Data Analytics Job Simulation covering forensic technology and real-world data analysis, bringing consulting-level thinking to every problem.

Fast Learner, Self-Starter

Independently built and deployed complex Power BI dashboards with 12+ DAX measures, and analyzed 180K+ records — all while completing BCom degree.

Business-First Mindset

Frames every analysis around business outcomes — identifying profit drivers, attrition risks, and growth opportunities that directly support decision-making.

Skills Dashboard

Tools & Technologies

Programming
Python85%
SQL80%
DAX78%
BI & Visualization
Power BI88%
Microsoft Excel (Advanced)90%
Matplotlib / Seaborn80%
Data & Libraries
Pandas & NumPy85%
MySQL / PostgreSQL75%
Data Cleaning & EDA90%
Core Competencies
Statistical Analysis KPI Development Dashboard Design Data Storytelling Risk Profiling EDA Campaign Analysis Forensic Data Reporting MIS Reporting
Soft Skills
Analytical Thinking Problem-Solving Communication Team Collaboration Time Management
Languages
English Hindi Gujarati
Portfolio

Projects & Achievements

2025 · Python Project
Sales Data Analysis using Python
Python Pandas NumPy Matplotlib Google Colab
180K+
Transactions
99%
Data Accuracy
15%
Revenue Growth
  • Analyzed 180K+ sales transactions with 99% accuracy via data cleaning & preprocessing
  • Identified top 3 products driving 35% of revenue & 5 key regions generating 62% of sales
  • Built 8+ visualizations revealing trends; recommendations projected 15% revenue growth
2025 · Power BI Dashboard
AdventureWorks Sales Dashboard
Power BI DAX Excel
$24M+
Revenue
25K
Orders
22%
Profit Margin
  • Designed Power BI dashboard tracking $24M+ revenue with 22% profit margin & 2.8% return rate
  • Implemented 12+ dynamic DAX measures for real-time analysis by category, region & time
  • Uncovered top categories driving 68% of profit; recommended 12% margin improvement strategies
2025 · HR Analytics Dashboard
HR Analytics Dashboard
Power BI DAX Excel
1,470
Employees
16.1%
Attrition Rate
15+
Visualizations
  • Built HR dashboard analyzing 1,470 employees with 16.1% attrition rate & satisfaction metrics
  • Created 15+ visualizations covering attrition by department (83% R&D), gender, age & job satisfaction
  • Identified 3 attrition drivers: 59% male attrition, 45% salary dissatisfaction, 2.5x higher turnover
Experience

Virtual Job Simulations

TATA · Forage
GenAI Powered Data Analytics Job Simulation
June 2026
  • Performed exploratory data analysis and risk profiling on real-world datasets
  • Developed AI-driven delinquency prediction models using GenAI tools
  • Crafted business reports and data storytelling for collections strategy
  • Implemented an end-to-end AI-driven collections strategy
Deloitte · Forage
Data Analytics Job Simulation
May – June 2026
  • Conducted in-depth data analysis tasks simulating Deloitte's consulting workflow
  • Applied forensic technology techniques to investigate data anomalies
  • Practised structured problem-solving and analytical reporting for executive audiences
BCG X · Forage
Introduction to Data for Decision Makers Job Simulation
May 2026
  • Executed campaign performance analysis to assess marketing effectiveness
  • Translated data findings into clear, actionable insights for business decision-makers
  • Developed concise executive-level communication of data outputs
Credentials

Certifications

TATA · Forage
GenAI Powered Data Analytics
June 2026
EDA, Risk Profiling, AI Delinquency Prediction, Collections Strategy
Deloitte · Forage
Data Analytics Job Simulation
June 2026
Data Analysis · Forensic Technology
BCG X · Forage
Introduction to Data for Decision Makers
May 2026
Campaign Performance Analysis · Communicating Findings
ITech Computer Education
Power BI – Certificate of Merit
February 2026 · Grade A · No. ITC/NSPW/APR/15625
NIELIT Recognised · Central Government Recognised
ITech Computer Education
Advanced Excel
2025
Advanced Formulas · PivotTables · Data Analysis
ITech Computer Education
Diploma in MS-Office
2025
Word · Excel · PowerPoint · Outlook
ITech Computer Education
Data Analyst Certification
In Progress · 2026
Comprehensive Data Analytics Curriculum
Academic Background

Education

🎓 Graduation
Bachelor of Commerce (BCom)
A. E. Kalsekar College of Commerce & Management, Mumbai
CGPA 6.94 / 10 March 2025
📘 HSC (Class XII)
Higher Secondary Certificate
SMT. K. L. Tiwari Junior College, Mumbai
63% March 2022
📗 SSC (Class X)
Secondary School Certificate
Mother Mary's English High School, Mumbai
76% March 2020
Looking Ahead

Career Goals

📊

Data Analyst

Drive business decisions through robust data pipelines, EDA, and insightful reporting.

📋

MIS Executive / Analyst

Build and manage management information systems that empower leadership with real-time data.

📈

BI Analyst

Design Power BI dashboards and DAX models that translate raw data into strategic intelligence.

🔍

Reporting Analyst

Create automated, accurate reports that give stakeholders a clear view of business performance.

💼

Business Analyst

Bridge the gap between business needs and data solutions to optimize operations and profitability.

Get In Touch

Contact Information

Available for Opportunities

Open to Work

I'm actively seeking full-time positions and internships in data analytics, MIS, and BI roles. Based in Mumbai — open to on-site and hybrid opportunities.

Data Analyst MIS Executive MIS Analyst BI Analyst Business Analyst Intern Reporting Analyst

Send Me a Message