Lead Data Analyst
ENTAIN INDIA (formerly Ivy Comptech) · Feb 2022 – Present
- Lead data analytics, business intelligence and reporting initiatives supporting operational and management decision-making across multiple channels.
- Developed the Operational Performance Dashboard (OPD) using SQL, Power BI and DAX, consolidating approximately 71 business and operational KPIs across Chat, Email, Voice, Social, First Time Resolution, Customer Satisfaction, CPA/CPU and Chatbot/Journey analytics.
- Own 25 interactive Power BI dashboards and 45 operational reports consumed by 100+ business stakeholders across operational and management functions.
- Automated significant portions of recurring Excel dashboard and PowerPoint reporting, eliminating approximately 6 working days of manual monthly preparation (about 4 days for PowerPoint and 2+ days for Excel) and reducing the effort associated with quarterly/half-year reporting that previously required approximately 4-5 days.
- Designed and developed a Chatbot Analytics Dashboard covering key Chat and Journey performance measures, including Deflection Rate, Completion Rate, Drop Rate, Transfer Rate, CSAT, Feedback, Journey Success and Journey Drop metrics.
- Translate chatbot and customer-interaction data into business-ready KPIs and interactive Power BI visualizations to monitor customer journeys, transfers, drops, completion and satisfaction.
- Used basic Python scripting and Pandas for data preparation, validation, duplicate checks and reconciliation to support recurring reports and dashboards.
- Automated recurring data extraction, transformation and reporting activities by combining SQL queries with Python-based data processing workflows.
- Developed and optimized complex SQL queries in Snowflake, leveraging temporary views and automated Tasks to support efficient data processing and reliable Power BI reporting.
- Develop DAX measures and business logic to support complex operational KPIs and analytical reporting requirements.
- Perform data validation, reconciliation and root-cause analysis to identify reporting discrepancies and improve data quality.
- Work with 100+ dashboard/report consumers and business stakeholders to gather requirements, define KPI logic and deliver scalable dashboards, reports and analytical solutions.
- Work across operational metrics including offered volume, new/reopen interactions, assignment performance, answer performance, abandonment, AHT, UHT, handlings, SLA performance, MET and breach metrics.
- Lead and mentor the Hyderabad Data Analyst team, providing direction on reporting, analytics, dashboard development, data validation and delivery priorities.
- Played a key role in establishing and scaling the Hyderabad Data Analyst team, participating in interviews and candidate evaluation for 6 analyst positions and helping build team capability for expanding analytics and reporting requirements.
- Drive reporting standardization, automation and continuous improvement while partnering with stakeholders and management on business-critical reporting initiatives.

