Jul 2024 – Present · 1 yr 11 mos · Mumbai, Maharashtra, India · On-site

• Business Testing, Analytics & Automation Support:
• Acted as a bridge between business, QA, and product teams to ensure test cases accurately reflected real-world business behavior.
• Reviewed and validated 9% of total test cases, contributing to high-quality feature releases aligned with user expectations.
• Designed and maintained a Business Behavior Inventory in Zephyr Scale (Jira), facilitating smooth collaboration between testing and analytics functions.
• Contributed to a centralized test case library for the McDonald’s account, improving automation readiness and testing standardization.
• Supported accurate tracking and instrumentation by building data tracking schemas and participating in UAT for newly launched features, ensuring seamless analytics integration.
• Enabled product analytics by setting up dashboards that drew data from Google Analytics, server logs, and internal DBs, helping business teams run custom hypothesis testing and monitor product usage.
• Automated recurring data requests and quality checks using Excel macros and Google Sheets scripting, improving data reliability and reducing turnaround time.
• Data-Driven Cost Optimization & Workforce Planning:
• Led an internal cost optimization initiative, driving improvements across five key KPIs within 2 months in collaboration with business and product stakeholders.
• Extracted, cleaned, and analyzed workforce data using SQL, Excel, and Google Sheets, enabling strategic decisions around employee mix, contribution margins, and resource deployment.
• Increased low-grade employee distribution from 24% to 28%, contributing to reduced costs without compromising delivery quality.
• Expanded shadow resource pool from 5.64% to 12%, improving delivery resilience and continuity.
• Maintained visibility over contribution margins to ensure workforce spending stayed aligned with the company’s 15% CM target.
• Proactively flagged data integrity issues to the Data Engineering team, ensuring accuracy in resource and cost dashboards.