Nov 2023 – Mar 2024 · 4 mos · Durham, North Carolina, United States · On-site

Sep 2023 – Nov 2023 · 2 mos · Campbell, California, United States · Hybrid

Sep 2022 – Jun 2023 · 9 mos · San Francisco Bay Area · Remote

• As part of MSBA, leveraging BI analytics to enhance visibility into $200M annual inventory and help pharmacy department at UCD best allocate resources, reduce overstocking, and minimize shrinkage
• Collaborated with BI team and pharmacists to define scope for 3 key milestones through requirements refinement, feasibility analysis & prioritization discussions
• Built two real-time Tableau dashboards to mitigate medication shortages by evaluating medication inventory on hand, usage/transactions, and corresponding costs trends to enable forecasting capabilities based on dynamic historical range
• Spearheaded a team of 5 to ensure smooth delivery(dashboard design, user-testing and final deployment) and led weekly client meetings to highlight progress, risks, and mitigation strategies
• Performed Exploratory Data Analysis to understand key metrics and highlight anomalies in Inventory/Transactions dataset

Jul 2020 – Jun 2022 · 1 yr 11 mos · On-site

• Design and lead implementations of business intelligence and analytical solutions (such as Customer alignment, Claim Data Analytics, Voice of Customer) to improve commercial effectiveness by leveraging expertise in business intelligence, CRM, system integration technologies and project management. Utilized tools such as Reporting tools, ETL processing, Data Integration tools, and ZS Proprietary Javelin Suite. Recently played a key role in migrating the entire solution architecture to AWS cloud
• Conducted in-depth analysis of client data using SQL/ Python/ Excel, to gain insights into specific sales and marketing challenges, and crafted tailored solutions based on the findings
• Managed a team of 4-6 associates, developing project timelines, and overseeing their daily tasks to ensure timely delivery of both short-term deliverables and the entire project
• Collaborated with clients and other vendor firms, gathered requirements, and led end-to-end implementation efforts while ensuring timely input and issue resolution

Jun 2017 – Jun 2020 · 3 yrs · On-site

• Conceptualize, design, build, implement and support digital and technology products and solutions that enable end-users to make critical decisions and help companies achieve better business results
• Created SQL based processes to run data operations and generate/automate custom downloadable Reports
• Managed operations and implemented new features for the Alignment Rules Manager for a giant pharma firm
• Designed and developed custom web call planning application with SQL backend for US & Europe based clients for handheld device

Jul 2016 – Nov 2016 · 4 mos · Bangalore

Jul 2015 – Jul 2016 · 1 yr · Pilani

• I was the co-ordinator of Project Umang which aimed at providing education to the underprivileged students in the rural area of Pilani. The main tasks included selection of the meritorious students through tests, collection of the funds for the scholarship and the overall development of the students.

May 2015 – Jul 2015 · 2 mos · Dehradun