Shaarika Joanna

About Shaarika Joanna

Skills: SQL, PowerBi, ML, Snowflake, AirflowExperience: 3.5 yearsEducation: MBA, NIT Trichy

Experience

1. Senior Business Analyst

   Swiggy

   Sep 2023 — Present

   Developed data-driven formulae using solver techniques to prioritize leads calling, enhancing resource allocation and increasing weekly onboarding by DEs.Designed a dynamic tele-caller allocator simulator providing demand-backward and supply-backward views at the city queue level.Proposed a new rule reducing attrition by 200 DEs per week and reactivating 100 DEs on the platform, ensuring smooth zone operations.Identified and addressed IM batching pay structure issues, achieving ~₹12 lakhs in monthly savings.Optimized batching for same-customer orders, resulting in ~₹10 lakhs savings per month.Implemented Temporary DEs assignment to cake and pizza orders, improving O2Ar by 0.01.Achieved ~₹24 Lakhs per month in cost savings and a 3% reduction in IRCTC cancellations through batching and assignment logic improvements.Performed impact analysis using normalization techniques, supporting product feature scale-up decisions.Created real-time 3PL Vendor Performance Reports with Hive and Databricks, enhancing accountability and flexibility for multiple vendors.Built RILL reports to identify inactive DEs, improving communication efficiency and increasing weekly active users.

Education

• National Institute of Technology, Tiruchirappalli

  Master of Business Administration - MBA, HR,Finance

  2018 — 2020

• Department of Management Studies, NIT Trichy

  MBA - Master of Business Administration, Business Administration and Management, Business Analytics, HR, Finance

  2018 — 2020

• Karunya University

  B.Tech, Computer Science and Technology

  2014 — 2018