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

• Drove BI delivery across 3 Agile squads (14+ stakeholders) by owning analytics requirements and standardizing Power BI data models, reducing analytics rework by 30% and improving sprint delivery predictability by 25%.
• Defined analytics logic, dimensional model structures, and data validation standards across product, finance, and supply chain reporting, ensuring consistency in KPI reporting and downstream consumption.
• Mentored 2 junior analysts on SQL optimization, DAX best practices, and data modeling, improving code quality and reducing onboarding dependency through structured reviews and documentation.
• Partnered with data engineering teams on Azure Databricks to validate ELT pipeline outputs across bronze, silver, and gold layers, improving data reliability before BI consumption.
• Engineered a market-comparison framework in SQL to extract and profile ERP datasets across Singapore, Thailand, and Sri Lanka, ensuring data completeness before analysis.
• Developed Power BI dashboards with DAX-based KPIs (growth rate, inventory turnover, forecast accuracy), implementing Row-Level Security (RLS) to support 8+ stakeholders and increase analytics adoption by 35%.
• Executed data reconciliation against source systems and led UAT sessions with Sales, Finance, and Supply Chain teams, improving data reliability and stakeholder confidence in reporting outputs.
• Delivered APAC expansion analytics to senior leadership, informing the decision to prioritize Thailand as the expansion market based on measurable sales momentum and forecast reliability.

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

• Engineered complex SQL queries utilizing CTEs, window functions, and multi-table joins to analyze large operational datasets (5M+ rows), reducing reporting latency by 40% by replacing manual extraction methods.
• Built and maintained ETL/ELT workflows using Python (Pandas, NumPy) to process data from JDE ERP and e￾commerce sources, reducing data preparation effort by 4 hours per weekly cycle and improving dataset reliability.
• Developed Power BI dashboards integrated with Power BI Service, enabling automated refresh and consistent KPI reporting, improving data accuracy by 30% through structured validation checks.
• Partnered with the data engineering team to test Azure Databricks pipelines, validating Spark-processed datasets against source-system records and documenting discrepancy resolutions for governance compliance.
• Served as the primary BI expert, partnering with WebTech, Data Integration, and ERP teams to design SQL-based analytics logic and Power BI reporting models for a customer self-service returns platform.
• Executed trend and variance analysis to identify critical bottlenecks in refund processing, specifically delays within validation and approval workflows.
• Built automated KPI tracking to surface these inefficiencies, driving targeted process optimizations that reduced refund cycle time by 50% and manual intervention by 40%.

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

• Analyzed audience viewership datasets using SQL to identify consumption patterns, contributing to 11% increase in ratings and 4% revenue uplift.
• Built real-time Power BI dashboards to monitor signal latency, eliminating manual log reviews and ensuring adherence to SLA targets across live events.
• Developed a system log monitoring workflow to detect and escalate technical failures, reducing unplanned downtime by 20% and improving incident resolution time (MTTR).
• Partnered with production, engineering, and operations teams to translate business SLAs into measurable data tracking thresholds, improving monitoring consistency.
• Standardized operational reporting workflows using SQL and Excel, ensuring consistent metric definitions and reducing manual effort by 30%.

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

• The broadcast operations role focused on system monitoring and live event execution.
• 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.