APPASAHEB KASHINATH DHUPE
Pune
Summary
A result-oriented professional with 11+ years of experience in the Pharmaceutical Industries to Analytics, Forecasting and MIS Project delivery.
Adept at leveraging expertise in VBA, Advanced Excel, Power BI and Share point to develop innovative technical solutions and streamline business processes. Proven track record of success in designing and implementing custom forecasting models, optimizing data management systems, and driving operational efficiency. Skilled communicator with a demonstrated ability to collaborate across cross-functional teams and deliver impactful results. Ability to plan, prioritize, make effective judgments on the projects and run multiple tasks simultaneously.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Assistant Manager
GENPECT
Pune
02.2022 - Current
- Developed forecasting models for multiple therapy as per the requirements of the client
- 10-15 year of near future forecast using some attributes like Prevalence rate, Diagnosis rate, Treatment rate, Market access, Market share, Launch date, Price and so on.
- Creating the Forecast model in the Excel with backend VBA and Advance excel
- Using Excel VBA to Create dynamic flow of the various section like Baseline, Future Event, Price and Report
- Implemented tools with the capability to read and write data to tables, enhancing data management efficiency.
- Conducted regular assessments and updates to ensure the continued relevance and effectiveness of forecasting models
- Proactively researched and implemented innovative solutions to improve forecasting accuracy and efficiency
- Managed customer service inquiries and complaints in a timely manner
- Supervised daily operations including scheduling shifts, assigning duties
- Communicated regularly with customers to gain insights into their needs
- Organized schedules, workflows and shift coverage to meet expected business demands
- Ensured compliance with safety regulations and company policies
- Provided guidance and support to junior staff members on daily tasks, projects, and objectives.
- Developed share point repository for store for the importance data with advance functionality like Upload, search and chatbots .
Assistant Manager (Data Analyst - SFE)
Emcure Pharmaceuticals Ltd
07.2018 - 02.2022
- Developed dynamic dashboard for various Therapy using Advance excel and VBA
- Comprehensive diagnostics for monthly division SFE review meetings
- Design sales force deployment that complies with SFE guidelines, and optimizes investment of resources according to business potential and ROI
- Establish SFE monitoring systems correlating potential for business, investment of activities & results achieved
- Review SFE KPI metrics to ensure compliance with SFE guidelines and consult with Sales Director on remedial action required
- In consultation with the Sales Director, design the salesforce incentive scheme, ensuring compliance with SFE guidelines
- Ensure a national customer database is in place profiling customers against potential for business
- Customer segmentation & targeting implementation
- Provide analytical reports to the Division Head of SFE
- Lead initiatives to improve planning and doctor coverage of divisions
- Provide SFE support and coordinate with development team for changes in SFE portal
- Update secondary master in SFE portal for secondary entry in every month
- Prepare Primary and Secondary MIS and Pivot of Respective Division
- Project Drive Like Review Dashboard, PCP, Rx Tracker & weekly Secondary Tracker
- Developing Reports in VBA like Division dashboard, Effort Report and Repetitive activity.
Senior Executive
ZYDUS HEALTH CARE LIMITED
05.2017 - 07.2018
- Budget Preparation for the division
- Dashboard preparation for Internal Data (Brand Wise, Territory Wise, Region level, SM Wise YPM)
- Preparing Dashboard of Awacs Data (CVM vs Company)
- Analyze the IMS Data Zone wise & State wise
- Preparing Dashboard of Primary Vs Secondary Data
- Region wise & Brand sales trend report with graph
- Prepare MTD and YTD Marketing expenses v/s budgeting and MTD Provision
- Support to HOD, Marketing and Sales Team
- Providing the Expenses & Sales related data to Marketing Team
- Monitoring and Tracking of vendor’s bills
- Follow up with warehouse for dispatch of sample and input
- Coordinating with product manager for the dispatches of Promotional Material
- Checking and Evaluating Expenses Statement Reports of Marketing Team
- Coordinating with Accounts dept
- For billing, invoicing & Payment
- Handling day-to-day routine admin activities
- To coordinate with vendors in regards to printing materials such as Strategic booklet, Literature, Leaflets, Reminder cards, Visual aid, Personal Order Book, Daily Hand Book, Work Book and Brand Guide
- Perform general office duties such as ordering supplies, maintaining records management systems, and performing basic bookkeeping work
- Coordinating with Purchase dept
- To ensure timely confirmation of vendor and following up with vendor and delivery process.
Executive
CIPLA LTD. (Team Lease Services Ltd)
07.2015 - 05.2017
- Acquire data from primary, secondary and IMS data sources and maintain databases
- Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality with advance excel and back end VBA coding
- Identify, analyze, and interpret trends and growth and market share of product
- Inform to the management on timely basis, in case of deviation from previous data
- Making Marketing expenses budget and sales budget
- Handling Hospital special rate approval system
- Co-ordination with sales team for submit quotation to hospital
- Co-ordination with finance team for update approved rate in the system
- Perform general office duties such as ordering supplies, maintaining records management systems, and performing basic bookkeeping work
- Track YTD expenses v/s budget
- EAS-Expense approval System ID Generation
- Preparing presentations for Business Review Meetings
Executive
Fresenius Kabi India Pvt. Ltd. - A German Giant Healthcare MNC
05.2013 - 07.2015
- MTD Primary and Secondary reports
- ZSM/SM/ASM wise sales trend report with graph
- Brand wise and Division wise sales report
- Prepare quarterly expense forecast template
- Preparing presentations for Business Review Meetings
- Prepare MTD and YTD Marketing expenses v/s budgeting and MTD Provision
- Support to HOD, Marketing
- Compiling & Analysis of Key Account Reports
- Communicating to FF, Managers for dispatch of Promotional materials, reports etc
- Co-coordinating with vendors for Various Job works and rate negotioating for the same
- Preparing Purchase Orders as per given quotation in SAP
- Providing the Expenses & Sales related data through SAP
- Preparation of Marketing presentation and report slides for meetings
- Preparation of vouchers related to Marketing activities as per Code of Conduct
- Domestic Travel arrangements of marketing team and ensuring cost optimization
- Preparing the bank Vouchers & Journal Voucher of Specialty, Onco & Regulatory for payment process
- Updating and managing field employees reimbursement process.
Education
M. C. M. -
Dr. Babasaheb Ambedkar University, Aurangabad
01.2011
B. A. -
Dr. Babasaheb Ambedkar University, Aurangabad
01.2009
H. S. C. -
01.2006
S. S. C. -
01.2004
Skills
- VBA (Visual Basic for Application
- SQL
- Power BI
- Dataiku (Core Designer)
Programming Languages:
Data Analysis and Visualization:
- Microsoft Excel (Advance function and pivot Table
- Microsoft Team
- Jira
- GitHub
- Confluence
Project Management:
Certification
- Visual Basic for Application from Udemy
- Power BI Certified in the Genpact
- Generative AI Certified in the Genpact
- Agile Certified in the Genpact
- Core Designer Certified from Dataiku
- ML Practitioner, Advanced Designer, Developer Corticate Enrolled in Dataiku
- Google Datastudio Certification for Making Effective Dashboard and report
- Advance Python & Power-BI certification from Simplilearn
Personal Information
- Date of Birth: 06/22/88
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Languages
- Marathi
- Hindi
- English
Timeline
Assistant Manager
GENPECT
02.2022 - Current
Assistant Manager (Data Analyst - SFE)
Emcure Pharmaceuticals Ltd
07.2018 - 02.2022
Senior Executive
ZYDUS HEALTH CARE LIMITED
05.2017 - 07.2018
Executive
CIPLA LTD. (Team Lease Services Ltd)
07.2015 - 05.2017
Executive
Fresenius Kabi India Pvt. Ltd. - A German Giant Healthcare MNC
05.2013 - 07.2015
M. C. M. -
Dr. Babasaheb Ambedkar University, Aurangabad
B. A. -
Dr. Babasaheb Ambedkar University, Aurangabad
H. S. C. -
S. S. C. -
Similar Profiles
Nazia TabasumNazia Tabasum
Process associate at GenpectProcess associate at Genpect
Baijnath KumarBaijnath Kumar
Accounts Payable Analyst at GENPECT INDIA PRIVATE LIMITEDAccounts Payable Analyst at GENPECT INDIA PRIVATE LIMITED
Hinali ValaniHinali Valani
Process Associate at Genpect Ineternational Inc.Process Associate at Genpect Ineternational Inc.