Mohit Sharma Email & Phone Number

Bangalore Urban, Karnataka, India

• Supporting Region Europe commercial business of a major generic based pharmaceutical client• Facilitating Qlik dashboard development team through extracting backend data by running, maintaining, and optimising complex SQL queries for 18 countries in Snowflake. Utilizing Alteryx as ETL tool to extract data in local system. Co-ordinating with Data Engineering team to resolve data issues• Supporting a cross-functional stakeholder by providing analysis, leading to creating forecasting models and taking business development and licensing related strategic decision• Maintaining, and delivering 3 analytics reports of Biosimilar products for Region Europe market covering KPIs and sales related metrics by extracting, and transforming large dataset from multiple data sources including internal data sources and IQVIA MIDAS• Developed multiple Alteryx workflows for optimised data processing, saved 10+ hours on monthly basis

Hyderabad, Telangana, India

• Delivered basic Alteryx training to 5 team members, enhancing their automation skills and improving team’s productivity• Developed an interactive Excel dashboard using advanced functions such as VLOOKUP, Index-Match to visualise sales trend of a key oncology brand across five major markets, received request to update dashboard for three more quarterly updates with additional brands, increased team's revenue by 3x• Integrated an Alteryx flow to streamline the backend process of an Excel dashboard. Reduced number of backend sheets by half, increased dashboard's functionality by 50%, and reduced data errors• Analyzed historical sales data of CAR-T across key markets to identify potential prescribers and hospitals, resulted in 30% cost saving, and optimizing field force by focusing on top accounts• Automated repetitive tasks in 35 Excel files for a cross-team through leveraging Python, mitigated the files update time by 50%, and eliminating manual errors occurring earlier• Provided support to an analytics team of the generic division during its short-handed situation, delivered four key reports till one quarter with highest accuracy. Additionally, created an Alteryx workflow and saved 10% of the team's time on a monthly basis.• Analyzed historical sales data for in-house an oncology brand and a competitor's generic to identify historical volume trends, enabling optimized inventory management and maximizing sales opportunities amid competitor shortages• Independently maintained 5+ data-driven reports of top oncology brands across major markets to effectively present sales metrics with comparison of achieved vs target, market share, sales growth, patient number growth• Sustained multiple complex reports of CAR-T, an advanced oncology therapy. Covered weekly and monthly tracking of orders received, and complicated KPIs such as calculating billable orders out of all orders produced

Gurugram, Haryana, India

• Executed and delivered more than 300 requests across industries primarily focused on pharmaceutical and healthcare industry under rapid-research work environment• Achieved more than 60% additional data request from clients on projects, escalated team’s revenue generation by 20%• Developed 50+ company profiles which served as decision making repository to clients for better decision making • Generated and shared insights on the basis of data received, surged client’s interaction rate by 15%

Gurugram, Haryana, India

• Composed and updated 6 knowledge assets including client updates, competitive intelligence, industry research across areas including diabetes, oncology, and medical devices for US and Europe markets• Delivered more than 200 key development activities such as clinical trial results, drug approval of key pharmaceutical companies, client engagement and project acquisition rate boosted by 40%• Compiled over 80 monthly updates on ZS's clients, project teams and practice areas, strengthened internal awareness by 85%