SHIV KUMAR PRAJAPATI
GHAZIABAD
Summary
Results-oriented and dedicated professional with over 13 years of experience in Sales Coordination, Sales Administration, MIS Reporting, and Facility Management within leading pharmaceutical organizations. Seeking a challenging role to leverage my skills in operations support, data analysis, and sales backend management to contribute to organizational success and growth.
A focused and result-oriented professional with over 13 years of rich experience:
Overview
13
13
years of professional experience
2
2
Certifications
1
1
Language
Work History
- Started and implementation of SFA (Sales Force Automation) at PAN India.
- Started and implementation of MDM (Mobile Device Management) at PAN India.
- Generating Brand Performance, SKU Performance & Market Share Reports.
- Preparing Target Vs Actual Report & monthly planning for primary and secondary.
- Preparing distributor & zone-wise performance.
- Primary & secondary sales data handling.
- Booking train, flight tickets & arrangements of stationery & etc.
- Providing stay, Imprest Cash, Visiting Cards, Company Assets like Laptop, Tablets, Data Cards, SIM Cards, Working Bags, Helmets, Glucometer, Flask, BCA Machine, Hand Dynamometer, Oximeter & etc. to the employees.
- Keeping records of company assets & handling its insurance claims which are issued to the sales team.
- Creating plans for replacements and repair for company assets.
Deputy Manager Sales Admin
Laborate Pharmaceuticals India Ltd.
10.2025 - Current
- Plan and Schedule Training Programs: Conduct a training schedule for onboarding new hires effectively to increase their knowledge, skills, and organizational understanding, enabling them to succeed in their roles.
- Coordinate the Sales Team: Manage schedules, file important documents, and communicate relevant information to ensure smooth operations.
- Sales Performance Tracking: Regularly monitor and evaluate the performance of the sales team.
- Daily Field Activity Monitoring: Track the sales team’s daily activities in the field, including attendance, location, and call start times for MRs, ASMs, RSMs, ZSMs, and DGMs.
- Full and Final Settlement Coordination: Collect full and final settlement data for the sales team in coordination with HR.
- Sample Arrangement: Arrange monthly samples for the sales team to support their field activities.
- CBO Software (Control Business Online) Report: Track DCR Plan & working of Sales team on alternate days.
- Approve the Doctor, Chemist, Leave, TP, and Expense, TA/DA in to the CBO.
- Resolve queries of sales team on daily basis which are facing on working time.
- Add new product details for generating POB value of Doctor, Chemist & stockiest.
- Sales MIS Reporting: Prepare and share Primary & Secondary Sales Report Product/HQ Wise, Manager Wise, Region Wise, Super Stockiest Wise.
- Prepare and share monthly product-wise sales and closing stock report as per super stockiest statement.
- Prepare sales team attendance and share with HR to dispute the salary.
- Quarterly & Yearly comparison of sales data. Growth comparison for Business Review.
- Preparing Incentive for pending claims i.e. Monthly/Qtrly/Half yearly.
- Analysis all India division’s Target/Achievement/Collection etc.
- SFA handling & coordination with sales team for submission of DCR, Samples and vendor for changes, updating and etc.
- Follow up with customer /Liaison regarding overdue payment.
- Co-ordinate with fiancé department to ensure timely payment of vendors.
- Generating TP/DCR deviation report less Dr. visit call report.
- EXPENSE PROCESSING: Monthly expense processing and reimbursement.
- Checking working day, leave TA, DA distance, fare.
- Checking hotel /taxi and other bills.
- CRM ACTIVITY: Tracking all the CRM activities and investment for doctors.
- Generating monthly report of all investment or CRM for doctors
- Taking care of ROI of every CRM activity of the doctors.
- Maintain proper details of all the bills of promotional item and reimbursement on time.
Deputy Manager –Sales& Admin
Maharishi Ayurveda Product Pvt Ltd
03.2025 - 10.2025
- Role & Responsibilities: We categorize MIS reporting in separate three parts Like Sales, CBO & Mkt please look below.
- A: Sales MIS Reporting: Provide Support and maintain for existing management information systems (MIS).
- Prepare Annual Budget with Sales Head and convert into HQ/ Product wise / Manager & Region Wise and share to sales team.
- Prepare and share Primary & Secondary Sales Report Product/HQ Wise, Manager Wise, Region Wise, Super Stockiest Wise
- Prepare and share monthly product-wise sales and closing stock report as per super stockiest statement.
- Prepare and share expiry goods / salable return and damage product report on monthly basis.
- Prepare sales team attendance and share with HR to dispute the salary.
- Prepare the incentive of sales team based on sales achievements with H1, H2 & Yearly frequency.
- Prepare and share sales team monthly scorecard to monitor their performance with all criteria.
- Prepare the monthly sales review format and align review meeting with all India sales team.
- Prepare the monthly Presentation to review meeting with directors and other HOD.
- Share month on month sales team vacancy requirement to HR and HOD to further fulfill.
- Prepare report channel wise like Export, Europe, Online, Offline, Hospital, Health Centre etc.
- Tracking, maintaining, and preparing the primary Sales, Secondary Sales and Closing Stock.
- Generate periodic and ad hoc reports to HOD for internal communication.
- Analysis of issues & errors and coordinate with team for solve to enhance efficiency.
- Capable of handling workloads and work pressures.
- B: CBO Software (Control Business Online) Report: Track DCR Plan & working of Sales team on alternate days.
- Add the customer party to the CBO on the same day within 1/2 hr of receiving the mail.
- Generate weekly super stockiest CBO billing report and share with sales team and HOD.
- DCR unlocks entry into the CBO on daily basis.
- Addition/ Deletion/ transfer and upload of doctor/chemist into the CBO after receiving the query.
- Weekly update of call avg and coverage of listed customers to HOD and sales team
- Prepare and share Missing Dr. list to concern MR with line manager to cover before month closing.
- Prepare and share joint working reports of Manager Work with MR and MR work with Manager.
- Open account of New joined employees into the CBO to start working via a CBO.
- Add new product details for generating POB value of Doctor, Chemist & stockiest.
- Marketing Support Report: Prepare the product complaint report like goods damage, packing issue, blank strip, leakage issue etc and share with HOD and internal management to reduce complaints.
- Prepare sales team sample allocation for every month and share with the dispatch team to dispatch.
- Track & prepare Activity Data like Diabetic, DGM & CME on Weekly/ Monthly basis and share to HOD.
- Provide the new Joiner kit to MR/ Manager along with samples.
- Take feedback of new joined field employee after joining 10 days and share the report to HOD.
- Prepare and provide the visiting card to existing employee and New Employee.
- Verify bills of sales scheme on monthly basis, and provide the inputs as per scheme and share
- Coordination with HR, IT, Finance/ Account, Dispatch and marketing as per requirements.
- Maharishi Ayurveda Product Pvt Ltd (Noida UP) was established in 1986. The company is a Manufacturer & Exporter of Ayurvedic Medicines.
Assistant Manager Sales Admin
Walter Bushnell Enterprises Pvt. Ltd.
06.2023 - 03.2025
- Maintain and create data in SAP MM module create customer and partner to the company in SAP.
- Create PO and invoice in SAP as per requirements.
- Validate the different types of standards and customize report from SAP.
- Check monthly Expenses of Field force PAN INDIA. (1200 Field Force with an average Deduction of Rs. 4.5 Lakhs)
- Rigorously Follow up Branch & Field Force for the updating of SECONDARY SALES.
- Prepare GRANGORAM for PAN India in every FINANCIAL YEARS.
- Do the Complete Arrangement of IOG (INDIAN OBSTETRICS & GYNAECOLOGY) for PAN India GYNECOLOGIST DOCTORS.
- Rigorously follow up with Field Force for BREAKAGE & EXPIRY.
- Successfully Launches SFE (Sales Force Enforce) Support System for Field Force.
- Taking care of complete New Stockiest Documentations as per the SOP.
- Analysis of Secondary Sales vs. Secondary Stock for appointment of new Stockiest.
- Follow up all mails daily and reply to the concern accordingly.
- Collect Monthly Reports & do the analysis.
- Check the Tour Program Monthly Basis (ZSM, RSM, ASM, RBM, ABM).
- Book flights according to their Tour Program.
- Prepare monthly attendance of Field force PAN INDIA.
- Arrange Budget Meeting & Cycle Meeting etc. Collect KCI (Key Customers Index) Quarterly Basis and share the same with the Director.
- Collect & verify the complete Documents for New Stockiest.
- Follow up the Doctors Order through CREATIO & SALES SUPPORT.
- Check the availability of Stock and Transit. And share the same with Business Managers/Territory Managers and get the stock arrange if any request/Shortage.
- Order with confirmation all the required inputs from the branch concerned.
- Sales administration and maintaining the CRM file, order processing sales reporting and analytics, Event and meeting coordination and sales team support.
- Approve the STP of field staff as per the SOP of the organization in our SFE Software if required from my side.
- Walter Bushnell Enterprises Pvt. Ltd, Gurugram (Pharmaceutical Industries)
Assistant Manager Sales Admin & Marketing Support
Aimil Pharmaceutical (I) Ltd.
05.2019 - 05.2023
- Sales Admin & Marketing Support Key Roles & Responsibilities Aimil Pharmaceuticals (I) Ltd.
- Prepare new customers, provide services to all existing customers and resolve all related issues.
- Prepare sales data of parties (Monthly, Quarterly, Yearly)
- Prepare sales data for all sales teams (BE, ASM, RSM ZSM, DGM DSM).
- Tracking of all field force by software.
- Prepare daily MIS report of sales team.
- Update all the information about the sales team in the system.
- Co-ordinate with all the sales team daily to collect information and resolve all related issues.
- Take care of all purchase orders of customers and process accordingly.
- Prepare monthly attendance of all sales team and send it to the HR department.
- Send all updates to the sales team related to them, timely.
- Prepare all documents and report required prior to the sales meeting.
- Coordinate with sales executive for order & Payment. Prepares (MIS) Reports. To maintain data base of employees.
- File management, net surfing new business growing ideas. Comparison of day – to day sales.
- Responsible for pan India gifting.
- All designing (Scheme/ circulars) Task as per the requirement of marketing team.
- Planning of inputs / Gifts dispatch records.
- Responsible for providing excel to senior Managers work & Company directors.
- Making of Target Sheets every quarter.
- Preparing PPT (Power Point Presentation) for the quarter and annual meeting.
- Following up with the field staff about visit wise activities, CME’s and Health Camps.
- Aggressively taking care of stationery items to be dispatched to field staff and taking care of their every requirement.
- Recording MOM (Minutes of Meeting) and later following up on all the points. Maintain the record of gift utilization.
- Maintaining the record of Depot Inventories.
- Responding to complaints from customers and giving after-sales support when requested.
- Coordinate with salesperson regarding TP, DCR (Daily Call Report) & Managers’ Working analysis.
- Handle the processing of all orders with accuracy and timeliness
- Inform clients of unforeseen delays or problems
- Monitor the team’s progress, identify shortcomings and propose improvements
- Assist in the preparation and organizing of promotional material or events
- Coordinating with Dispatch team and getting it dispatch the tester’s and help them to increase their sales and same for SO getting them samples with the help of dispatch team.
- Give complete training to the new joiners about the field assist software and help them till they get used to the software.
- Handling Employee Engagement birthday activity.
- Handling all Training Programs & Preparing the Training Calendar.
- Documentation & keeping updates of New Joining.
Assistant – Sales Department
Win Medicare Pvt. Ltd.
10.2017 - 05.2019
- Assistant Sales Key Roles & Responsibilities Win Medicare Pvt Ltd.
- Coordination with sales team daily regarding their queries & problems and following them with respect.
- To weekly & monthly submissions and managing end-to-end sales backend activities.
- Helping new Joinees in their induction, training process and providing stay, Imprest Cash, Business Cards, Company Assets like Laptop, Tablets, Data Cards, SIM Cards, Work Bags, Helmets, Glucometer, Flask, BMI Weighing Machine, Hand Dynamometer, Oximeter & etc.
- Taking care of optimum utilization of company assets. Liaison with different departments for smooth process flow.
- Looking after travel & stay arrangements for the entire field force for annual meets, resident meets, budget meets & etc.
- SFA handling & coordination with sales team for submission of DCR, Samples and vendors for changes, updating etc.
- Handling and Settling Claims of Medical activities like Detailing meet, CME meet, V meet, FGD meet, 1 on 1 meet Activities as per SOP.
- Assist sales management in understanding bottlenecks and in consistency. Facilitate an organization of continuous process improvement.
- Adroit in Leading meeting the performance of the team members to ensure efficiency in process so operations and meeting of individual & group targets.
- Helping brands team with new product launch, sampling activities and promotional activities to increase the awareness and demand of our product.
- Helping HR team with the confirmation of new employees and settlements of employees left.
- Helping the Finance team with the credit note calculations and letter of supplies issues to stockiest.
- Helping Compliance team for the completion of induction training to the new joinees.
- Helping the IT team with the management of IT assets like laptops, tablets, sim cards, data cards etc.
- I am skilled in performing operations & floor management, planning strategies, work force & workflow management, preparing various dashboards to analyze daily, weekly & monthly performance of the various Circles & for billing process.
- Developing and managing vendor contracts and sales team contracts.
- (Modi Group)
Sales Coordinator
Ranbaxy Laboratories Ltd.
02.2013 - 10.2017
- Sales Coordinator Key Roles & Responsibilities in Sun Pharma / Ranbaxy Laboratories Ltd due to merger of Ranbaxy to Sun Pharma from 25th March 2015.
- Experience as (Sales Coordinator) in Ranbaxy Lab. Ltd Efficiently Coordinating SM of North Region. (2 Division –STANLIFE AND INTENSIVA) Working in SAP, Assisting Coordinating Sales Manager of North Region Communication with HO /RO Field Staff Reporting to top Management on Sales, Stock Dispatch, Status, Pending Orders as well as in transit.
- Preparing SM Review Formats and updating Secondary Sales Data. Making MIS report and sending to H.O.
- Updating the sales data for the stores.
- Timely circulation of required MIS to Biz/ compliance /Finance teams.
- Defining monthly roster activities calendar in concurrence with team on monthly basis.
- Working in sap software, assisting and coordinating sales managers of north Region.
- Daily update of sales, stock, in–transit stock, and P.O to managers and whole team.
- Making of various formats by using of functions in Microsoft excel.
- Updating of General Credit Note.
- Updating of price Difference Credit Note.
- Follow up with customer/Liaison regarding overdue payment.
- Generation of Monthly Data from SAP.
- Knowledge of Billing in SAP (Order entry, delivery creation, PGI & Invoicing Raised.
- Knowledge of Stock Transfers.
- Knowledge of LR entry inSAP.
- Coordinating with Branch office (CFA), Field Staff, Stockiest & Head office.
- Very Good knowledge of working in excel i.e. Pivot Table, V-lookup, subtotal etc.
- Good experience of internet, email chatting & Prepare MIS on weekly basis.
- Good Knowledge of Warehouse Management.
- Produce and maintain all reports.
- Co-ordinate with the Finance department to ensure timely payment of vendors.
- Interaction with vendors regarding delivery schedule & regular Follow-up.
- Training and development: Training of SAP R/3 operation in Ranbaxy Laboratories Limited.
- Training at MS Office in Ranbaxy Laboratories Limited.
- Training of Metis software in Sun Pharmaceuticals Industries Limited
- All work responsibilities are related to SAP software SD/FI Modules.
- Ranbaxy Lab Ltd. world’s top pharmaceuticals companies, Manufacturing /Distribution of Medicine, The Company is having distribution and SAP Network all over India. now has been merged with SUN PHARMA.
Education
BCA (Bachelor of Computer Applications) -
Sikkim Manipal University
01.2012
12th - undefined
UP Board
01.2009
10th - undefined
UP Board
01.2006
Skills
Good knowledge of MS office Package
Good knowledge of SAP/Metis/Fox- Pro software
Good Knowledge of Sales Force Automation Software with GPS Location in Online & Offline Mode
Good Knowledge of CBO Software
Good Knowledge of Sane Force Software
Good Knowledge of Store and Inventory Management
Positive outlook & team Player
Adjustable nature Adaptable to new technologies
Results oriented, able to complete a task ahead of schedule and move on
Certification
One, Year Diploma in Computer Applications from Shiv Computer Education Silvassa [MS-, Word, Excel, Diploma in Computer Applications (MS Office, Photoshop, HTML).
Interests
Hobbies: Playing the Cricket & Listen the Music
Declaration
If given an opportunity to serve I assure you that my performance would be wholehearted, dedicated and always to the best of my capacity and in the prestige of the Company. Date: Place: Ghaziabad Signature (Shiv Kumar Prajapati)
Timeline
Deputy Manager Sales Admin
Laborate Pharmaceuticals India Ltd.
10.2025 - Current
Deputy Manager –Sales& Admin
Maharishi Ayurveda Product Pvt Ltd
03.2025 - 10.2025
Assistant Manager Sales Admin
Walter Bushnell Enterprises Pvt. Ltd.
06.2023 - 03.2025
Assistant Manager Sales Admin & Marketing Support
Aimil Pharmaceutical (I) Ltd.
05.2019 - 05.2023
Assistant – Sales Department
Win Medicare Pvt. Ltd.
10.2017 - 05.2019
Sales Coordinator
Ranbaxy Laboratories Ltd.
02.2013 - 10.2017
12th - undefined
UP Board
10th - undefined
UP Board
BCA (Bachelor of Computer Applications) -
Sikkim Manipal University