Mar 2022 – Jun 2024 · 2 yrs 3 mos · Bengaluru, Karnataka, India · On-site

• Designed and automated Employee Management dashboards using SQL and Tableau, enabling performance tracking for 2,500+ staff and saving 2,000+ manager hours annually via strategic process enhancements
• Received ‘Above and Beyond' award for improving global support call routing process by analyzing 500M+ call flow records, SRE coverage and queue logic, reducing average customer wait times by 30%
• Automated Quarterly Business Review report using SQL, Python and Tableau to track Time to Resolution(TTR) across 9 products, reducing manual operations effort from 5 days to 10 minutes saving 160 hours annually
• Implemented a one-stop Support Renewal dashboard to track key contract extension metrics, streamlining ~50 monthly renewal decisions, saving 50 hours annually and preserving $3M+ in recurring revenue
• Facilitated bi-weekly Agile sprint meetings for 15 cross-functional team members, overseeing JIRA prioritization, task assignment and backlog grooming, to ensure alignment across PMs, engineers, and data teams
• Developed optimized SQL workflows to redesign Tableau dashboards with enhanced filters, layouts, and drill-downs, reducing support tickets by 20% and tripling adoption across product and support teams

May 2021 – Mar 2022 · 10 mos · Bengaluru, Karnataka, India · Remote

• Spearheaded Competitive Intelligence Solution to assess market dynamics and optimize pricing strategy for 3 Ecommerce verticals delivering end-to-end analytics from data scraping to price recommendations
• Built weekly-price forecasting model using historical trend and elasticity analysis across 10,000+ SKUs, enabling data-driven pricing decisions that increased off-season profits by 6.5%
• Delivered daily forecasting reports during White Wednesday campaign, partnering with Pricing and senior leadership to implement real-time price adjustments that drove 15% campaign sales over target
• Collaborated with Pricing and Merchandising Teams to refine and deploy pricing logic, influencing price decisions for ~30% of all SKUs and support dynamic pricing and preserve margin targets
• Automated web scraping across 3 competitor websites using BeautifulSoup, Selenium, Scrapy, and Requests, reducing manual data collection by ~90% and improving data freshness for weekly pricing decisions
• Led pre- and post-analysis meetings with senior leadership and non-technical stakeholders, driving iterative improvements to pricing and assortment decisions across respective product categories

Oct 2020 – Apr 2021 · 6 mos · Gurugram, Haryana, India

• Planning and envisioning the Indian & International video-on-demand content, Esports, Mobile Gaming on all tenants ready for Airtel’s OTT platforms.
• Strategizing, planning, promotion and curation of all sporting events(India vs Australia cricket series - record stream-time, Australia Open, WWE etc) for Airtel Xstream.
• Coordinating with suppliers to ensure the delivery of the right content for the right audience to match the demand and supply chain.
• Spearheaded project for UEFA Champions League on Xstream encompassing planning, strategizing, promotion, marketing and curation.
• Responsible for content layout for both Airtel Xstream and Thanks App.
• Manage and curate content by studying and drawing insights from the data through Tableau for English, Hindi and other regional languages.

May 2020 – Oct 2020 · 5 mos · New Delhi, Delhi

• QlipCast is social network mobile app for audio content. Users can listen to podcasts on the app, bookmark, and clip their favourite parts.
• My responsibilities as an Intern includes finding valuable content that could be Clipped as part of podcasts, verify their quality and report those Clips to the common database.

Jun 2019 – Jul 2019 · 1 mo · Kanpur Area, India

• MALWARE ANALYSIS OF APK'S USING MACHINE LEARNING :
• AndroidManifest.xml & .smali files of apk's are parsed to get
• frequencies of android permissions & opcodes which are saved in
• separate excel files. Weka is applied to build a classification model.
• Accuracy obtained - 97.52%
• Technologies Used : APKTool, Weka, Python Libraries (os, glob,
• ElementTree, csv, pandas)

May 2018 – Jul 2018 · 2 mos · Gurugram, Haryana 122008

• > Worked in the Quality Assurance(QA) team
• > Worked on several technologies for linting like Flake8, PyTest, PyLint.
• > Additionally, worked on the Fabric 2.x module which is used to execute shell commands remotely over SSH.