Portfolio - Sankalp Anand

Sankalp Anand

Senior Analyst (BI)

[email protected]

PHONE

+91 9650458745

Download CV

About Me

Most business problems don’t come clearly defined—they show up as vague asks, shifting expectations, and reports that people don’t fully trust.
I work with product, analytics, and data engineering teams to bring structure to those situations.

My work focuses on:
🟆 analyzing large datasets using SQL to identify trends and performance gaps
🟆 building Power BI dashboards to track sales, inventory, and operational KPIs
🟆 using Python for data cleaning, exploration, and improving data reliability

A big part of my work is making sure what gets built actually matches the business need—whether that’s improving how requirements are defined, reducing rework, or making reporting more consistent and reliable.

I see my role at the intersection of business and data—where the goal isn’t just to build dashboards, but to create clarity. When that’s done right, teams stop questioning the numbers and can focus on making decisions with confidence.

2

PowerBI Projects

1

SQL Project

1

Machine Learning Project

1

Python Project

Key Skills

SQL

Python

Power BI

Agile Methodology

SDLC

Databricks

JIRA

Sprint Planning

RAID

UAT Coordination

My Projects

My Experience

Senior Analyst (BI) || TREK Bicycles, Gurugram, India || Oct 2025 - Jan 2026

Led BI initiatives delivering Power BI dashboards and SQL-based analytics models supporting product, finance, and supply chain teams across global retail operations.
Reduced analytics requirement rework by 30% by introducing feasibility reviews and structured data validation frameworks during sprint planning.
Coordinated analytics delivery across 3 cross-functional squads (14+ stakeholders), improving sprint delivery predictability by 25% through structured data validation and standardized reporting frameworks.
Designed Power BI dashboards tracking sales, inventory turnover, and supply chain KPIs across 4 regional markets, used by 15+ stakeholders.
Built cross-market analytics models integrating sales, inventory, and supply chain datasets to evaluate expansion readiness across APAC subsidiaries.
Developed executive dashboards comparing demand trends, inventory turnover, and operational capacity across Singapore, Thailand, and Sri Lanka.
Implemented Row-Level Security (RLS) supporting 8+ regional stakeholders, increasing analytics adoption by 35%.
Delivered analytics insights supporting leadership evaluation of market readiness and operational feasibility for Thailand expansion.

Business Intelligence Analyst || TREK Bicycles, Gurugram, India || Dec 2024 – Sep 2025

Engineered complex SQL queries using CTEs, window functions, and multi-table joins to analyze large operational datasets, accelerating reporting insights and reducing reporting latency.
Leveraged Python (Pandas, NumPy) for exploratory analysis and automated data cleansing, improving data reliability for downstream SQL reporting.
Developed Power BI dashboards tracking sales performance, operational KPIs, and supply chain metrics for crossfunctional business stakeholders.
Implemented structured data validation frameworks, improving reporting accuracy by 25–30%.
Served as BI expert for the transition from manual refund workflows to a customer self-service returns platform.
Coordinated with WebTech, Data Integration, and JDE ERP teams to design reporting models and backend analytics logic supporting automated returns processing.
Performed trend and variance analysis on returns data to identify operational bottlenecks in refund workflows.
Reduced refund processing cycle time by 50% and decreased manual intervention by 40%.

Associate Analyst || NEP India Pvt. Ltd., Gurugram, India || Feb 2022 – Nov 2024

Developed SQL-based failure logs and Power BI dashboards to identify root causes of recurring system failures, driving targeted fixes that reduced technical downtime by 20%.
Leveraged real-time performance KPIs (signal integrity, latency) to predict operational risks, ensuring 100% compliance with strict SLAs.
Ensured 99.9% uptime for live events by using historical performance data to plan infrastructure redundancy and validate system stress tests.
Developed equipment tracking logs and predictive maintenance schedules to forecast hardware failures before they impacted production.
Translated project requirements into actionable technical tasks, ensuring precise execution and on-time delivery for complex broadcast setups.
Collaborated with production crews, satellite engineers, and on-site operations to execute complex broadcast plans seamlessly.

Assistant Broadcast Engineer || NEP India Pvt. Ltd., Gurugram, India || Dec 2017 – Jan 2022

Designed standardized data collection frameworks using Excel to monitor equipment performance, providing early data visibility into failure patterns.
Developed Excel-based trackers to monitor equipment performance and maintenance schedules, providing early data visibility into failure patterns.
Coordinated kit preparation and logistics for off-site productions, ensuring hardware availability aligned with project timelines and delivery milestones.
Mentored interns and junior staff on configuration protocols, standardizing troubleshooting steps to reduce setup errors and improve operational consistency.
Conducted rigorous installation and testing of new facilities, verifying system functionality against technical specifications before go-live.