Rohit Ranjan

Experience

• 

  Palash Healthcare Systems Pvt. Ltd.

  Sept 2016 - Dec 2016

  Application Development Intern
• 

  Capgemini

  Aug 2018 - Jan 2020

  Engineered data solutions by developing ETL pipelines to seamlessly integrate various data sources, facilitating unified analytic reporting across the organization. Collaborated on enhancing the ERP tool by incorporating customized functionalities aligned with specific business requirements. Leverage of SAP reporting tools to craft essential reports meeting diverse organizational needs.

  • Data Integration | ETL

    Jan 2019 - Jan 2020

  • SAP Business Warehouse Analyst

    Aug 2018 - Dec 2018
• 

  Fractal

  Jan 2020 - Aug 2021

  1. Pricing & Promotion Analyticso Conducted an in-depth regression analysis of monthly sales to calculate elasticities of price, promotions, and media advertisements. Translated the statistical inference to business and innovatively created a simulator to analyze the drivers and their impact. This contribution was instrumental in optimizing the price and budget for various promotions and media advertisements.o Utilized Linear and Bayesian regression to meticulously finalize the independent variables through comprehensive statistical analysis.o Spearheaded and collaborated with cross-functional teams of proficient data engineers to architect ETL pipelines. Leveraged big data tools such as Azure Data Lake, Data Factory, and Data Bricks to efficiently manage large Point of Sale datasets using PySpark for model creation and maintenance. Show less

  • Data Science Consultant

    Apr 2021 - Aug 2021

  • Associate Data Scientist

    Jan 2020 - Apr 2021
• 

  ZS

  Aug 2021 - now

  Decision Analytics Associate Consultant

  1. Pharma Commercial Analyticso Identified approximately N potential physicians and meticulously segmented them for a specific drug, considering customer potential and specialty, using clustering methodology.o Spearheaded the organization's downsizing of the field force, strategically reducing the workforce by x% to optimize ROI. This achievement was realized without compromising optimal reach to physicians, thanks to a data-driven approach and BI reporting tool.o Orchestrated strategies for optimal call planning by precisely determining the number of calls required for each physician, taking into account HCP potential and bandwidth. This approach leveraged advanced data analytics.o Innovatively developed a survey tool for HCPs to capture feedback after-sales personnel briefings. Employed Tableau to craft compelling stories and reports for retrospective improvements.2. Pharma R&D Analyticso Employed regression analysis to forecast FTEs required for ongoing trials at distinct phases, facilitating strategic budget planning and informing decision-making for workforce addition and trial prioritization within the R&D team.o Engineered a robust quality check framework using Python and Excel reports to systematically address trial data anomalies resulting from human errors. This initiative enhanced solution reliability and bolstered confidence in insights. Show less