Piyush Kumar Singh

Data Analyst | Business Intelligence Analyst

Bangalore, India 1+ yrs exp 82 · Excellent

About

Data & BI Analyst with hands-on experience delivering end-to-end analytics across product, e-commerce, and FinTech domains. Proficient in advanced SQL (CTEs, Window Functions), Python, and Power BI (DAX, Star Schema) with a proven track record of processing 1M+ records, building automated ETL pipelines, and optimizing unit economics. Adept at designing A/B testing frameworks, translating complex data into actionable leadership dashboards, and driving measurable revenue growth.

Skills & Expertise (42)

Python Intermediate

6.7/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Data Quality Checks Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Exploratory data analysis Intermediate

6.5/10

Years Exp

Data Transformation Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Advanced Excel Intermediate

6.0/10

Years Exp

A/B testing Intermediate

5.5/10

Years Exp

KPI Dashboards VS Code Standardization Error Handling Jupyter Notebook DAX measures Star Schema Data Modeling Pivot Tables XLOOKUP Index-match Power Query GitHub Git JSON REST APIs Data Pipelines ETL Processes Relational Data Modeling Views Aggregations Window Functions Subqueries CTEs Joins SQL Server Hypothesis Testing Seaborn Matplotlib NumPy

Work Experience

Data Analyst Intern

CricsHub

Mar 2026 - Sep 2026

Ingested and aggregated application data via REST API endpoints and SQL queries; cleaned and preprocessed 10,000+ user and match records for reporting pipelines. Built 7 interactive Power BI dashboards and KPI reports tracking core application metrics, providing leadership with a centralized single source of truth. Analyzed user engagement and churn telemetry, pinpointing slow app response times from unindexed SQL queries as the root driver of uninstalls; collaborated with engineering to refactor queries, improving response latency. Conducted region-wise demographic and engagement analysis, delivering strategic market recommendations for launching a credit-based fantasy scoring feature.

Freelance Data Analyst

Birinj Biriyan

Jul 2025 - Feb 2026

Consolidated, cleaned, and standardized ∼30,000 sales records from Swiggy, Zomato, internal point-of-sale systems, and Excel workbooks using Python, SQL, and Power Query. Analyzed day-of-week sales trends, repeat customer behavior, and SKU performance for Pune operations, pinpointing low Thursday volume and high perishable food waste to optimize Ranchi expansion strategy. Formulated data-driven promotional bundles and menu redesigns that scaled the Ranchi location from ∼12–13 to ∼40 daily orders (∼3x growth), balancing delivery (∼55%) and dine-in (∼45%). Evaluated item-level gross margins and scrap rates, executing menu rationalization that cut slow-moving inventory waste by ∼50% and saved ∼15% in daily kitchen prep costs. Engineered an end-to-end Power BI financial dashboard integrating gross revenue, channel commissions, labor, rent, and utility costs to track net margins and support ROI marketing campaigns.