Jul 2024 – Feb 2025 · 7 mos · Kolkata, West Bengal, India · On-site

• SQL-Based Reporting: Designed and optimized complex SQL queries to extract insights on restaurant performance, fleet operations, and delivery efficiency.
• Restaurant Performance Analysis (Supply): Evaluated restaurant metrics, including order volume, fulfillment rates, cancellations, and average preparation times, to assess supply efficiency and identify operational bottlenecks. Analyzed funnel conversion rates to improve the order journey from selection to checkout and provided insights on ads performance to optimize restaurant visibility and engagement.
• Fleet Performance Analysis (Logistics): Tracked and optimized fleet utilization by monitoring delivery partner availability, assignment efficiency, booking trends and order fulfillment times to enhance logistics performance. Analyzed delivery partners' earnings, identifying factors affecting income variability and proposing strategies to improve partner retention and engagement.
• Dashboard Development: Built and maintained Google Sheets dashboards and Redash Dashboards to visualize real-time restaurant order trends and fleet performance metrics.
• Cost Optimization: Identified inefficiencies in restaurant operations and fleet distribution, recommending data-driven optimizations to reduce delays and improve service quality.
• Automated Insights: Developed automated reports to track supply-demand gaps, restaurant service levels, and fleet availability, reducing manual monitoring efforts.
• Cross-Functional Collaboration: Worked closely with City CEO and operations teams to improve restaurant engagement strategies and fleet allocation efficiency.

Jan 2024 – Jun 2024 · 5 mos · Bengaluru, Karnataka, India · On-site

• Played a pivotal role in the ICAP team at Philips, specializing in test automation and verification for the Philips Advanced Visualization Workspace (AVW) application. Automated over 20 critical test cases and developed 90+ reusable scripts, resulting in a 35% increase in overall test coverage and improved testing efficiency.
• Contributed significantly to the quality assurance of the AVW application, actively supporting five of its latest builds by monitoring automated script runs, identifying failures, and implementing script enhancements to ensure optimal application performance and reliability.
• Demonstrated expertise in managing complex client-side defects and navigating through 10+ sub-applications like CTV, NMV, and MRC within Philips AVW, showcasing a deep understanding of the system's functionalities and intricacies.
• Spearheaded the automation of repetitive testing tasks using UiPath, simulating real-world usage scenarios to increase testing efficiency, accuracy, and coverage while ensuring compliance with stringent quality standards.
• Designed and executed robust test plans to verify the application's functionality, usability, and reliability. Collaborated closely with developers to identify, troubleshoot, and resolve software issues, enhancing user satisfaction and application performance.
• Provided actionable insights for feature and interface enhancements based on testing outcomes and client feedback, contributing to a more intuitive and user-friendly application.
• Maintained comprehensive documentation of test phases, defect reports, and automation scripts to support continuous improvement and adherence to industry best practices.

Jun 2023 – Aug 2023 · 2 mos · Jaipur, Rajasthan, India · Hybrid