Pravin Kumar Manager- MIS and Sales Administration
No reviews yet

Experienced Excel professional offering remote part-time services tailored to your data management, analysis, and reporting needs.
Proficient in leveraging Excel's advanced functions and formulas to streamline processes, enhance efficiency, and deliver accurate insights.
Flexible availability to accommodate various project scopes and deadlines.
Let me help you optimize your data-driven decision-making with precision and reliability.
Structured Approach, Efficient Data Management, Advanced Formulas and Functions, Data Analysis Techniques, Problem-Solving Skills, Continuous Learning and Improvement, Time Management: Prioritize tasks and manage time efficiently to meet deadlines and deliver results in a timely manner. Using Excel's productivity tools, such as keyboard shortcuts and macros, to optimize workflow and maximize efficiency.
Ability to combine technical proficiency with a strategic mindset, problem-solving skills, and a commitment to continuous improvement. By applying these principles and techniques in Excel work, accuracy, and effectiveness in delivering value to clients or organization set me as a great excel user.

Subjects

  • Microsoft Excel Expert

Experience

  • Manager- MIS and Sales Administration (Jan, 2017–Present) at La Pristine Bioceuticals Pvt Ltd
     Processing and auditing of Sales Team Expense Statements.
     Monthly MIS Data – Incentive Calculation, Administrative Report, Attrition Reports, Manager Working Analysis, Sales vs Outstanding, High Inventory.
     Preparing Product wise Sales Data:-
    Preparing All Product/Head Qtr/State wise Sales vs Free Issue, Sales vs Expiry, Sales vs Sales Return. Identifying low and zero sales Head Qtr and inform the same to SMT.
    Maintaining Product wise Sales vs Costing Data on Monthly/Quarterly/Fy-wise.
     Preparing Value wise Sales Data- Region wise, HQ wise, Product wise as required by management: -
    a) Primary and Secondary Sales Report
    b) Target vs Primary Sales
    c) Primary vs Free Issue/Expiry/Sales Return on Monthly, Quarterly/Monthly/FY wise
    d) Sales vs Costing (Salary, Field Expenses, Marketing Expenses, DSP, Sample Cost)
    e) Preparing Top Achiever and Low Performer Head Qtr/Employee/Manager on monthly/Quarterly/FY wise.
     Preparing Low performing Head Qtr and inform to all SMT on monthly basis.
     Assisting to DGM/GM in Target Projection (Value/Product).
     Handling Sales support and Distribution support, coordinating with different departments, and resolve issues of the sales team.
     Observation of daily working report of the sales team. I.e. DCR, Daily Expenses, Tour Plan, TP Deviation, Dr. covering details.
     Processing stockiest appointment.
     Preparing progress report of Weak Territories and new Appointed Stockiest.
     Preparing Data of High Inventory, Near Expiry products and informing to concerned team and stockiest for liquidation.
     Maintaining attendance and leave records of the sales team.
     Handling MDM and customization in CBO (Sales team reporting software) related work.

Education

  • B COM (Jan, 2007–Jan, 2010) from IGNOU

Fee details

    ₹2,000–6,000/hour (US$23.78–71.35/hour)

    The fee details are contingent upon the project scope, complexity of work, and the time allocated; however, if the task requires less than 15 minutes, no fee will be applicable.

Reviews

No reviews yet. Be the first one to review this tutor.