Rohan Mishra

Data Analyst

Satna, India 80 · Excellent

About

Data Analyst focused on e-commerce and category analytics, skilled in SQL, Advanced Excel, Python, and Power BI to evaluate revenue drivers, gross margins, AOV, and customer purchasing behavior. Experienced in diagnosing pricing and operational disparities, building RFM-based customer segmentation, and designing interactive dashboards that support commercial decision-making. Brings an engineering background in reproducible data pipelines and clean, scalable analysis workflows.

Skills & Expertise (27)

SQL Advanced

8.2/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Advanced Excel Advanced

7.5/10

Years Exp

Python Intermediate

7.0/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Git Intermediate

6.0/10

Years Exp

JavaScript Intermediate

5.0/10

Years Exp

React.js Beginner

4.5/10

Years Exp

Node.js Beginner

4.0/10

Years Exp

Docker Beginner

3.5/10

Years Exp

NumPy Sales Trend Analysis REST APIs Pivot Tables XLOOKUP INDEX MATCH Seaborn Matplotlib Interactive Dashboards Pandas Window Functions CTEs Complex Joins Postgresql SQLite Scenario Modeling

Work Experience

E-Commerce Category Economics & Customer Retention Analyst

Olist

Present - Present

Analyzed transactional performance across 99,000+ orders and 9 relational tables representing R$15.4M GMV, tracking revenue realization, order cancellations, and fulfillment performance. Uncovered category revenue divergence: 'Watches & Gifts' generated 75% higher revenue per transaction despite having roughly half the sales volume of 'Bed, Bath & Table.' Executed an RFM (Recency, Frequency, Monetary) segmentation model across 96,000+ customer profiles, identifying that 40%+ of accounts were at risk of churn to inform promotional campaign planning. Conducted data auditing to isolate carrier routing failures causing default 180-day delivery estimates, preserving the accuracy of logistics SLA metrics used by commercial teams. Built an interactive Power BI dashboard featuring 5 dynamic slicers (Date Range, State, Category, RFM Segment, Shipping Type) to track revenue trajectories, AOV, and customer cohorts.

Analyst

Competitor Market Benchmarking & Catalog Analytics

Present - Present

Standardized and benchmarked 2,500+ multi-platform catalog listings across competing providers (Netflix, Prime Video, Hotstar) to evaluate inventory distribution and content acquisition strategy. Authored 13 advanced SQL queries deploying CTEs and window functions (RANK, ROW NUMBER, LAG) to evaluate YoY trend distributions and conduct Pareto analysis across high-demand segments. Engineered a normalized efficiency-ratio metric (popularity ÷ catalog volume) to differentiate high-conversion inventory from volume-heavy, low-yield assets. Resolved multi-table data modeling relationships to enable cross-filtering dashboards, supporting rapid ad-hoc reporting across genres and catalog vintage.

Engineer

Traffic Telemetry & Funnel Analytics Service

Present - Present

Engineered a real-time event logging engine capturing user acquisition channels, referral sources, and device demographics with sub-50ms response latency. Structured normalized relational schemas in PostgreSQL to track conversion drop-offs, user session volume, and platform traffic patterns. Configured automated data sanitation and bot filtering protocols, maintaining 95%+ data integrity across analytical reporting tables.