Sep 2023 – Nov 2023 · 2 mos · Delhi, India

May 2023 – Jul 2023 · 2 mos · Hyderabad, Telangana, India · On-site

• Worked as a part of FOPs Cards - Global Cards IN (Google Payments) team.
• 1. Implemented Cleanup Out of Compliance Cards Backfill, a critical component of the card storage code yellow project, ensuring compliance with RBI regulations.
• 2. Implemented a comprehensive dashboard and alerting system, providing timely detection of issues related to regulated cards and triggering alerts to the team when predefined thresholds were breached.
• 3. Authored comprehensive and detailed documentation for the project, facilitating launch, ease of maintenance and future enhancements.

May 2022 – Jul 2022 · 2 mos · Bangalore, India

• Worked as a part of the Collection and Ingestion of Data Team of Chronicle - Google Cloud Security
• 1. Parser Release Cadence: Designed ways to automate parser releases to customers in a fixed schedule.
• 2. Tests: Implemented tests to ensure that only directories that require fixed schedule updates are affected.
• 3. Tests: Implemented tests to ensure that an emergency update can be released without being bound by fixed cadence.
• 4. Freeze Dates Configuration: Built configuration to ensure that all the other non-release days are frozen.

Jul 2022 – Mar 2023 · 8 mos · Gurgaon, India

• Worked as a part of the UC Marketing Analytics Team.
• 1. Developed end-to-end funnel from scratch for a newly launched painting category, identifying key drop-off points to drive user engagement and increase conversion rates.
• 2. Designed queries for dashboard to track user behavior in the install-to-signup-to-first-order funnel for the Middle East Market, including the no. of days between each event, resulting in improved insights into user acquisition and retention.
• 3. Automated daily performance KPIs such as installs, spends, traffic funnel, user state at the category, device and country levels for the Middle East and Singapore, resulting in streamlined data processing and improved insights.
• 4. Streamlined data tracking processes by developing Python scripts for automatic updates, resulting in saved manual effort.
• 5. Developed Jarvis dashboards with KPIs at test/control group cut to monitor the impact of pricing experiments in real-time, resulting in improvement in category performance (Salon, EPC, AC).
• 6. Extracted and analyzed unique user-traffic and conversion data source-wise to identify priority categories to display on Home Screen, resulting in improvement in user-engagement and revenue.
• 7. Extracted SKU-level data to identify and segregate single and multiple SKU bookings, resulting in improved insights into customer behavior and product popularity.
• 8. Created and optimized queries to find society-level loyalists.
• 9. Successfully closed over 100 requests for data and dashboards and collaborated with 40 individuals including stakeholders, category leaders and team members, ensuring timely delivery of critical information and analysis.
• 10. Created a data dictionary of the tables within the database and documenting the most important queries used for analysis, validation, and reporting.
• 11. Designed queries to extract data for churn prediction model and recommendation model.
• 12. Worked 40+ hours per week while being a full-time student.

Sep 2021 – Feb 2022 · 5 mos · Noida, Uttar Pradesh, India

• Worked as a part of the FinTech Pod.
• 1. Performance Monitoring: Built performance monitoring dashboards for newly launched product features (Whatsapp integration, On-call SMS Trigger), their adoption rate, and effects using SQL and Metabase. Built operations dashboard to monitor CSAT and NPS.
• 2. Lead Prioritization Model: Created text analysis python script to funnelise customers for specialized customer support resulting in an increase in conversion.
• 3. Optimisation: Extracted actionable insights using data to optimize the lead conversion percentage in the SquadIQ team.
• Optimized already existing SQLs and dashboards to reduce their loading time by 50%.
• 4. Fraud-Detection: Worked extensively on fraud-detection of users on SquadIQ application which includes creating alerts to find duplicate users, automatic banning/unbanning of fraudulents, and so on.
• 5. Knowledge Training: Gave KT Sessions to Supply Analysts, Business Operation Analysts on basic SQL and dashboarding to reduce dependency and increase their efficiency.
• 6. Root Cause Analysis: Performed root cause analysis on SQLs not producing expected outputs and underlying database issues.
• Worked 40+ hrs a week while being a full-time student.

Apr 2021 – Dec 2021 · 8 mos

Jan 2021 – Jan 2022 · 1 yr