About
Business Analyst with 3+ years of experience in Business Intelligence, SQL analytics, Power BI/Tableau dashboards, KPIs, CX analytics, data modeling, ETL, automation, and stakeholder-driven insights.
Skills & Expertise (28)
Work Experience
Business Analyst
OYO Rooms Pvt Ltd
Oct 2023 - Jun 2025
Delivered Business Intelligence and data analytics using SQL/MySQL (CTEs, Window Functions, advanced JOINs) on 250K monthly records, improving NPS by 6% and reducing churn by 3%. Built and maintained Power BI, Tableau, and Looker dashboards, defining 30+ KPIs and metrics for CX analytics, customer journey, and operations, improving decision-making efficiency by 15%. Developed DAX measures, data models (Star Schema, Dimensional Modeling), and automated KRA scorecards for 320+ employees, improving performance tracking by 17%. Led ETL and automation initiatives using SSIS, PySpark, and Python (Pandas, NumPy), applying query optimization, indexing, and partitioning to improve operational efficiency by 14% and reduce report latency by 20%. Conducted root cause analysis and enforced data governance across 7 business units, improving data accuracy to 98%, while leveraging Python (Pandas, NumPy) and stakeholder management to deliver predictive and actionable insights.
Business Analyst
Byjus Pvt Ltd
May 2023 - Sep 2023
Analyzed customer journey and funnel metrics using SQL (LEAD, LAG, CTEs) and Power BI dashboards, tracking KPIs and conversion metrics to increase MAU by 8% (35K) and improve conversion rate by 6%. Automated BI reporting using ETL pipelines (PySpark, SSIS), stored procedures, and materialized views, while performing cohort and root cause analysis to improve retention by 5%, upsell by 7%, and reduce sales cycle time by 12% through accurate data cleansing and stakeholder collaboration.
Systems Engineer
HCL Technologies Pvt Ltd
Mar 2022 - Apr 2023
Delivered data analytics and BI solutions for a Chinese university client using SQL/MySQL (RANK, PERCENT_RANK, CUME_DIST) on 50K+ records, improving CX metrics and reducing service resolution time by 10–12%. Built and maintained Power BI, Tableau, and Looker dashboards with complex DAX, tracking 20+ KPIs and metrics across retention and operational performance, improving reporting effectiveness by 15%. Automated performance scorecards for 450+ academic and administrative staff using SQL MERGE, stored procedures, and triggers, improving productivity tracking accuracy by 12–15% and decision turnaround by 10%. Led ETL automation using SSIS and PySpark, strengthening data governance and quality to 96%, reducing reporting costs by 8%, improving efficiency by 12%, and enabling reliable financial and enrollment forecasting through Python-based analytics and stakeholder collaboration.
Education
Bachelor of Engineering in Electronics & Instrumentation Engineering - Siddaganga Institute Of Technology
2018 - 2022 · India
Certifications
SQL developer
WIPRO · 2024
Introduction to Python
Internshala · 2022
Introduction to Network
CISCO · 2022
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Open to Relocation
