| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data Analyst Commercial Analytics & Sales Forecasting (Oncology, Pharmaceuticals)Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLEVisa Type: H1B, Open For: C2C/W2SUMMARYConsultant with more than five years of demonstrated work record in commercial analytics, strategy, sales and forecasting; business process optimization and automation, product development life cycle (PDLC); and market research in pharmaceutical industry. Skilled in data insights generation and analytics, reporting, ETL, Business Intelligence, Quality Assurance, SQL, PowerBIPROFILEData Analysis/Management:Worked on data management and reporting dashboards to allocate best target product profiles and sales for different in line and pipeline products/drugs to deliver performance tracking reports to sales and upstream analytics teamBuilt dashboards and reports in PowerBI (using DAX codes), Spotfire and Tableau for global and regional heads to visualize commercial sales and forecast outputs at overall portfolio levelDeveloped and tested ETL flow (informatica) and supported the technology teamUsed R programming to run different regression analyses including factor regression, linear and multiple regression, ANNOVA test, conjoint, attribute and correlation analyses to analyse HCPs responsesUsed SQL to manage large datasets as HCPs responses gathered from programmed and fielded surveys as part of awareness, tracking and usage drug projectsCommercial Analytics and Sales Forecasting - Oncology:Built dashboards and reports in PowerBI (using DAX codes), Spotfire and Tableau for global and regional heads to visualize commercial sales and forecast outputs at overall portfolio levelCreated product analogues using to deliver insights on inline and pipeline products in PowerBI and Tableau that helped country market leads to analyse the market dynamicRequirement gathering and documentation of business models, flowcharts and treatment algorithms used for sales forecasting and other commercial analysesLean six sigma certified: Automation of various excel based models to VBA based models which reduced manual intervention to ~10 mins from 24 hrs task and increased efficiencyDeveloped an in-house BI tool for range forecasting (Monte Carlo Simulations), waterfall and sensitivity analysesDeveloped excel based forecast models and dashboards for top 10 markets as well as several countriesCreated market share calculator for three different regions including US, EU and JCAP to calculate steady state and overall product shares using launch dates and class share KPI using VBA and power queryCreated KM curve repository using power pivot and used PowerBI to present it globallyReleased global guidance roll outs, long-range and short-range forecast using different forecast approaches including patient based, trend based, demand, and simple forecasting approachesLeading various User Acceptance Test (UAT) activities performed on web-based global tools and platforms which highlights Global Scenario Planning, Global Guidance Tool, PowerBI based Assumption Analyzer and Global Forecast SummaryHands-on various secondary databases including Factiva, CapitalIQ, SEER, KANTAR, IQVIA Claims (APLD), IQVIA XPONENT, DRG, FIDO, Globocan, EPIC, Bloomberg, IQVIA DDD, IQVIA Analytics, IQVIA SMART, Pubmed, Cancer.org, AJMC, BeaconUsed R programming to run different regression analyses including factor regression, linear and multiple regression, ANNOVA test, conjoint, attribute and correlation analyses to analyse HCPs responsesUsed SQL to manage large datasets as HCPs responses gathered from programmed and fielded surveys as part of awareness, tracking and usage drug projects in OncologySKILLSBusiness Visualization Tools: Qliksense, Power BI, PowerPivots, SpotfireBusiness Intelligence Tools: Microsoft Power Point, Word and Advance Excel, Forecast Pro, SPSS, PSP, HFSS, VISIO, MS Access, IBM CognosProduct Owner Tools: JIRA, AHA, Lucidchart, Lucidspark, googleforms, Rally, FlamigoLanguages: Basics of C, Advance SQL, R, PythonSecondary Databases: Factiva, CapitalIQ, SEER, KANTAR, IQVIA Claims (APLD), IQVIA XPONENT, DRG, FIDO, Globocan, EPIC, Bloomberg, IQVIA DDD, IQVIA Analytics, IQVIA SMART, Pubmed, Cancer.org, AJMC, BeaconCertification: Risk Management (ISO27001), Project Management, Digital Marketing, Lean Six SigmaTraining: BSNL, GDPR, ITIL v3 FoundationEXPERIENCEScemblix CML and Kisqali Breast Cancers Patient Journey, Trial Mapping and Sales Forecasting, Novartis, New Jersey, USBusiness Consultant (US Commercial Analytics & Forecasting, PharmaACE Analytics), February 2024-May 2024Forecasting, market assessment and business lead for the Chronic Myeloid Leukaemia (CML) in Oncology as therapeutic areaLead for one in-line primary brand and three secondary pipeline brands for US marketLeading transition and overall development of propriety tool/model implementation to forecast the products for three year and 10-year forecastKeytruda Trial Mapping and Sales Forecasting Global Portfolio Oncology, Merck (Genpact), New Jersey, USAssistant Manager (US Commercial Analytics & Forecasting), February 2023-January 2024Managing global requests from pan-tumour team which includes reporting workstreams of fifteen year forecast for Keytruda portfolioLeading various User Acceptance Test (UAT) activities performed on web-based global tools and platforms which highlights Global Scenario Planning, Global Guidance Tool, PowerBI based Assumption Analyzer and Global Forecast SummaryHandling ad-hoc pan-tumour analyses requests in collaboration with business development teamKeytruda Trial Mapping and Sales Forecasting Bladder, RCC and Prostate Cancers Oncology, Merck, New Jersey, USSenior Business Analyst (US Commercial Analytics & Forecasting, Genpact), March 2021-Jan 2023Team lead for Tumour specific project. Managing forecasting, global guidance rollouts and modelling work streams for North, South, Latin America. Consulting Europe and Asia-Pacific on their respective forecastingPresented last four forecast cycles for Bladder, two forecast cycles for Prostate and one forecast cycle of RCC tumour in oncology and collaborated with c-level executives from commercial forecasting and global strategic disease leadsDeveloping forecast models including both early and late stage, simple and trend based, epidemiology dashboards, share calculators, patient flow excel based modelsLead and overseen transition of excel VBA onto proprietary tools co-developed with IBMImplementing co-ordination with capability teams to assess business requirementsWorked with cross-functional teams including business development and analytical on diverse projectsSemi-annual meet with finance and marketing directors to discuss on long-term and short-term product placement and performanceXTANDI Awareness, Tracking and Usage for HCPs Prostate Cancer Oncology, AstellasDecision Analyst Associate (US ATU Business Consulting, ZS Associates), July 2020-January 2021Managed prostrate tumour specific awareness, tracking and usage (ATU) projects leverage standard MR practicesDeveloping market surveys by assessing varied key business questions (KBQs) and customer specific unmet needsCollaborated with different programming vendors to analyse the survey requirements and fieldingPre-assessment and UAT for surveys in multi-linguistic for prostrate, vaccines, tuberculosisDevelop and maintain data pipelines, ETL processes, data warehouses, reporting systemsMonitor and analyze healthcare data for accuracy and completenessResponsible for data gathering, analyses, maintaining data dictionaries and data representation leveraging MS-office, ZS proprietary, PowerBI, Qliksense toolsShowcasing reports via dashboards on data quarterly with directors and concluding on product performance and future upcoming productsAptara Corporation (Techbook International), Noida, Uttar PradeshResearch Analyst, May 2020June 2020Responsible for executing market research practices including strategy building and competitive intelligence in ed-tech app development project at a start-upBuilding surveys and analysing key business questions to gather unmet needsData validation gathering and visualizationDevelop and maintain data quality assurance processesSupported the development of Business Process Design documents and gathering functional requirementInteracted with end users to determine functional requirementsWorked on designing test plans and involved in various testing phase of the project such as SST, SIT and UAT during Implementation and Support phases of the projectConducted trainings for the better understanding of the business processes for the teamCreated UML diagrams for the development team for the better understanding of the functionalityFrost and Sullivan, Gurgaon, Haryana,Research Associate, April 2019-April 2020Groomed into role of research associate, generated competitive intelligence reportsPrepared company profiles, brochures, executive summaries, newslettersAssessed market dynamics including growth estimations, SWOT, PESTLE, BCG matrix and Porters Five ForcesCreated reports on emerging digital technologies including AI, Blockchain, Fintech, RPAConducted focus group discussions on trending technologies with expert panel from ASEAN for market researchDocumented country business guides (CBGs) and dossiers about ASEAN countries to handover to sales for business enhancementConducted market research utilizing global tools such as IDC, IQVIA, Factiva, Bloomberg, CapitalIQInvolved in business requirement gathering and project scope determination through meetings and discussions with the key stakeholders, customers and subject matter expertsInvolved in creation of use cases after analyzing the scope of the project to achieve better understanding of the business process from the Users perspectiveLearned various utilities business processes such as such as Move-in/out, Move-in transfer, Quotation Management, Contract Management, Product Change, Cancel and End ContractDeveloped process flow documents for the projectInvolved in User Acceptance Testing and used HP quality center tool for the testEDUCATIONSymbiosis Institute of Digital and Telecom Management, SIU, June 2017 - Mar 2019Pune, MaharashtraMaster of Business Administration (MBA)Sri Ram Murti Smarak College of Engineering & Technology, June 2011 - June 2015Bareilly, Uttar PradeshBachelors of Technology (Btech)PROJECTSSales & Collaboration (S&D) with Jio Point Teams, April 2018-May 2018Future of Mobility in Auto-Tailing, Financing & Insurance, December 2018-Feb 2019Determinants for enhancing online shopping experience on e-commerce websites, August 2018-February 2019 |
