Dec 2021 – Present · 4 yrs 5 mos

Dec 2018 – Dec 2021 · 3 yrs

Jan 2016 – Dec 2018 · 2 yrs 11 mos

• Responsibilites
• Consulted Fortune 500 Pharma clients’ leadership with key brand insights & sales strategy formulation
• Automated Business Intelligence dashboards to streamline performance reporting & decision making
• Led & mentored a team of 4 analysts to design a user-friendly adhoc drag & drop application in Micro Strategy Web & Visual Insights; Enabled the HQ users to analyze sales, patient, call & sample activity data
• Profited client $100k annually by process automation & QC; Reduced reporting turnaround time by 90%
• Successfully deployed the ad-hoc MSTR environment for 200+ users & drove Client Operations for a year
• Collaborated with the Sales Force Effectiveness division of a Fortune 500 Pharma company to design Reporting Solutions for Sales Force directors to assess and improve sales performance year over year
• Liaised with cross office process improvement teams to improve the performance of client reporting systems
• Reduced weekly data refresh timings from 6 to 2 hrs & Quality Check process from 7 hrs to 1.5 hrs
• Appreciation testimonial received by client lead for the quality, performance and design
• Successfully deployed the ad-hoc MSTR environment for 200+ users & drove Client Operations for a year
• Impact
• Awarded 1st position in ‘Making my impact’; Identified as one of the best client relationship management and project operations in ZS Associates for two consecutive years – 2016 and 2017
• Selected from an offshore team of 20 members to travel onshore to demo the reporting system capabilities and present to the client Team of 12 members in Princeton, USA including Sales Directors and VPs
• Top performer (5% among 1,200); highly appreciated by Principal for automation & process design skills

Jun 2013 – Dec 2015 · 2 yrs 6 mos

• Responsibilites
• Spearheaded development on iPad reporting (MSTR Mobile) of an interactive and user-friendly application
• Collaborated with a team of 6 members to releases performance scorecards to medical reps
• Collaborated with Business Users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs and create functional mock-ups in QlikView and MSTR for clients
• Designed multiple dashboards in QlikView & Tableau with Oracle as backend system, to track performance of a newly launched drug to track KPIs such as growth, competition, reach among physicians
• Worked on RedShift (AWS) & Oracle to make tables, views, materialised views & queries for QC Analysis
• Impact
• Travelled client site to gather Business Requirements & seek end user feedback on existing source systems
• Successfully facilitated and coordinated MSTR, QlikView and Tableau training sessions for new recruits
• Awarded 1st position in ZS Associates, ‘ZStart Academy’ Case Study Competition in June’13 on ‘Healthcare Analytics’ while competing against 40 teams (220 participants) in a 5-day competition
• Associated with an internal initiative to enhance Overall Project Experience in ZS including smooth onboarding, receiving and providing constructive feedback and recognizing professional achievements