Open to New Opportunities

Rohan
Maharana

Data Analyst  ·  MIS Specialist  ·  Mumbai, India

Turning Data into Meaningful Business insights.
I don't just work with data; I use it to solve real-world business problems. — I enjoy turning messy data into clear, actionable insights through data cleaning, exploration, and analysis, helping businesses make smarter, data-driven decisions.

View My Work
Rohan Maharana — Data Analyst
Data Analyst
``` ---

// 01 — about

Driven by Data,
Defined by Results

I am a Data Analyst and MIS Specialist currently at Mumbai, where I own end-to-end analytics workflows — from raw data ingestion to boardroom-ready dashboards.

My core expertise spans SQL, Python, Power BI, Advanced Excel (VBA/Macros), and Looker Studio, Machine Learning, Deep learning Ai automation. I have applied these tools to solve real business problems — including customer churn prediction, fraud detection, and macro-economic analysis covering six decades of data.

I believe the best analysts do not just report numbers — they ask better questions. My approach combines statistical rigour with clear storytelling so stakeholders can act on insights, not just read them.

Rohan Maharana

// 02 — skills

Technical Toolkit

SQL
Complex joins, window functions, stored procedures, and query optimisation across large datasets.
Python
Pandas, Scikit-learn, NumPy — data wrangling, EDA, and end-to-end ML pipelines.
Power BI
DAX measures, custom visuals, KPI dashboards, and automated executive reporting.
Advanced Excel
VBA macros, Power Query, pivot tables, and financial modelling at scale.
Looker Studio
Interactive dashboards with live Google data connectors and cross-platform reporting.
Machine Learning
SMOTE, classification, regression, ensemble models, and evaluation metrics (AUC, F1, recall).
A/B Testing
Hypothesis testing, statistical significance, experiment design, and conversion analysis.
MIS Reporting
Management information systems, operational analytics, and multi-source data reconciliation.

// 03 — projects

Featured Work

01
Churn Prediction — PowerCo
Python SMOTE Scikit-learn ML
Customer Churn Prediction — PowerCo

Built an end-to-end churn prediction pipeline for a BCG X simulation. Used SMOTE to resolve class imbalance and trained ensemble models achieving high recall on at-risk customers, enabling targeted retention campaigns with measurable ROI.

View on GitHub →
02
A/B Testing Analysis
Python Pandas Statistics A/B Testing
A/B Testing Analysis — 11,000+ Customers

Designed and executed a rigorous A/B experiment across 11,000+ customer records. Calculated statistical significance, controlled for confounding variables, and delivered actionable recommendations that demonstrably improved conversion metrics.

View on GitHub →
03
Power BI embed coming soon
Power BI DAX Macro Analysis 1962–2023
Indian Economy Dashboard — 60 Years of Data

Comprehensive macro-economic analysis of India spanning 1962–2023. Interactive Power BI dashboard covering GDP growth, inflation cycles, trade balance, and sectoral shifts — giving decision-makers a single source of historical truth.

04
Screenshot coming soon
Python SQL Fraud Detection Anomaly Detection
Home Booking Fraud Analyzer

Developed a fraud detection system for home booking platforms combining rule-based logic with ML signals. Identified high-risk booking patterns, significantly reduced false positives, and improved platform trust and transaction safety.

// 04 — experience

Work History

2023 — Present

Data Analyst / MIS Executive

Yadgreen   ·  Mumbai, India

Own the full MIS reporting lifecycle — from data extraction and validation to executive delivery. Built automated Excel dashboards using VBA macros that cut manual reporting time by 60%. Designed Power BI reports consumed by senior management for weekly decision reviews. Perform SQL-based data reconciliation across multiple source systems, ensuring data integrity and audit readiness.

2022 — 2023

Data & Operations Analyst

Manoj Ornaments  ·   Mumbai, India

Digitised inventory and sales records using Advanced Excel and Looker Studio, eliminating manual tracking errors. Created KPI dashboards monitoring daily sales performance, stock movement, and supplier SLAs. Identified procurement inefficiencies through data-driven analysis, contributing directly to measurable cost savings.

// 05 — blog

Latest Articles

Let's Build
Something Great.

Open to full-time roles, freelance projects & collaborations  ·  Mumbai, India