Sarvesh Kumar Pandey

COE Project Planning and Execution

• Execute high quality analytical and ad-hoc requests accurately, understanding business questions, extracting the data through SQL, Python in the form of tables and graphs which can respond to questions such as what the current market scenario is, competitors’ performance, new launches and innovation.
• Experience in working on various healthcare data sets such as IQVIA Claims, Veeva Calls data, Xponent, DDD, NPA, NPS, Symphony, Komodo,ION, etc.
• Worked on Patient level data for tracking the patient journey to pull various matrices like SOB, patient switch and persistency and adherence. This helped the brand to develop appropriate strategies for capturing the best patient share in the market.
• Worked with Payer level data to create insightful reports based on different payer and patient level matrices. This helped in appropriate planning and contracting the payers which helped to keep the brand in most favorable acceptable tiers.
• Implemented Python packages to automate the regular reports to create automated powerpoint and excel reports. This reduced the overall manual efforts which saved time and cost.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Work with senior client stakeholders and understand the requirements to carry out the desired analysis using SQL, Python and Machine Learning. Ex. KPI identification and tracking, insights generation from Claims data, etc.
• Experience in Predicting HCP Churn using Machine Learning XGBoost model.
• Standardization and manipulation of complex healthcare datasets in order to create the data foundation for further analytics and development of key insights (Snowflake, SQL, Python, Excel).

Marketing Mix Modelling

• Worked on Marketing Mix Modelling to create ROI's and market impact based on different marketing channels. This helped client to plan and prioritize the marketing channel to gain best ROI's for short and long term.
• Worked on Modelling and Segmentation of HCPs based on similar behavior to plan a segment specific targeting plan for best returns.
• Planned and executed various modelling methodologies on segmented data.

Patient Forecasting

• Worked on patient forecasting models using advance excel to predict and estimate the most accurate patient share in the market using various inbuilt tools.
• Creating the future trend line of sales and market share of the product and patients that was used by client in further decision making.

• Worked on development of front-end automation test-cases for adjustment tool by using BDD Cucumber and Java Selenium framework.
• Worked on development of backend automation test cases for one of the Financial Data warehouse source system where we need to check data in input Area for validating the data and aligning data for further processing.
• Worked on development and implementation of UI related test cases for salesforce application.
• Developed automation for Test Data Management and Data Masking activates.

• Projects:
• Open Banking System: This project was a part of Infosys training.
• This was based on Java and its applications.
• This also had additional frameworks like Spring-Boot, REST-API.
• This also implemented the concepts of load balancer using Feign and Ribbon framework.
• Delivered clerical support by handling range of routine and special requirements.
• Analyzed problems, identified solutions and made decisions.