Jun 2021 – Apr 2025 · 3 yrs 10 mos · Bengaluru, Karnataka, India · On-site

• Key Responsibilities - Working with 20+ Program teams across three countries in cross-functional projects, Automating and managing recurring reports, delivering metrics, driving observations and insights impacting multiple stakeholders
• ▪ Unified Tool Reporting Automation – Developed end to end automated dashboards (using AWS - Glue, Redshift, s3, Spectrum and Quicksight) for 1222 Catalog employees across India, Europe, and Japan by independently connecting with 25+ stakeholders to analyze requirements, conceptualize process flow, worked across 10+ different data sources, technologies, and 3 engineering teams to source data, manipulating the data into queries, and generating reporting solutions for 10+ metrics, achieving an annualized efficiency savings of 15 HC.
• ▪ Automation of Weekly Business Reviews (WBRs) – Owned the migration and automation (data processing and visualization) of eight GCO Operational metrics covering 22 (100%) program teams in Weekly Business Review (WBR) allowing leaders to monitor historical trends and compare program numbers, eradicating manual reporting by 100% and contributing to annualized efficiency savings of 3.90 HC
• ▪ ETL and Dashboards – Migrated 15+ manual reports from Excel to Redshift - AWS Quicksight based dashboard ensuring data accuracy, reliability and saving 6+ HC
• ▪ Worked across multiple ambiguous problems by understanding data requirements, business impact, scoping efforts, setting project priorities and milestones, owning project communication and sharing crisp and focused observations and insights helping PMs/OMs take informed business decisions impacting various catalog defects.
• ▪ Training and Mentoring - Trained newly joined BAs within four weeks each by mentoring them on Tech and Domain knowledge, conducting KTs and transitioned regular reports, small scale and large scale projects

Apr 2021 – Jun 2021 · 2 mos

Feb 2020 – Mar 2021 · 1 yr 1 mo

• Key responsibilities: Working on a variety of data sources with Strategy and business team, Efficient and detail-oriented with a skill for building client rapport and offering support to senior management
•  Involved in data to decision journey - mainly focused on strategic projects, which later lead to business decisions. Experienced in improving operations efficiency, consumer experience, and behavior and implementing new business into the market. Tools such as Advance SQL and MicroStrategy are used every day.
•  Creating dashboards and collating data into a format where business leads are directly involved in business strategy. (consumer experience, operations, and Pharma Analytics)
•  Involved in conducting proof of concepts at firm level to onboard other tools and technologies into the analytics space (Redshift - Hive, MSTR-Hive Integration)

Jan 2019 – Feb 2020 · 1 yr 1 mo · Pune Area, India

• Key responsibilities: Requirements gathering, System designing, Problem-solving, Team Management
•  Lead implementation of data warehouse in Redshift for BI solutions (MicroStrategy) for top pharma client in the US including responsibilities such as requirements gathering, design, development, testing, and deployment of the solution
•  Leading a team of 5+ members (including onboarding and training) to manage and optimize infrastructure to deliver an analytic solution faster
•  Liaison with clients during the project lifecycle and provide necessary support/training to ensure smooth transition post-deployment to the end-users of the system including the transition to the operations team
•  Involved in conducting proof of concepts at the firm level and developing cutting edge solutions for clients
• Successfully implemented BI solutions for top pharmaceutical clients that helped them track their business performance and take timely/ informed decisions
•  MicroStrategy based managed market dashboards (Dossiers) for a leading pharma client as part of transforming its contract evaluation capability
•  Field reporting dashboards to identify potential targets, track performance & identify pull-through opportunities, processing ~14TB of data in AWS (Redshift, EC2)
•  Learnt, collaborated and developed the Customer-Centric Marketing Data Lake using Hive and inhouse tool (ZS Edge)
•  Market Research on how US pharma is evolving day-to-day from both manufacturer and payer perspective and hence saving ~$6M dollars of clients by helping them revolutionize their Pharma Rep Model.

Jun 2016 – Dec 2018 · 2 yrs 6 mos · Pune Area, India

• Key responsibilties: System designing, Problem solving, Developing Technical & Business Expertise
•  Involved in design, development, testing and deployment of first-ever AWS Spectrum framework in the space
•  Maintained project plans and timelines, managing change requests, leading weekly client meetings and cross
• office meetings
•  Developing end-user training modules for client management and sales force to aid them in providing inputs and
• performing data validations
•  Enhance operational efficiency by way of continuous process improvement and automation of manual processes