Mis and inventory analyst
Pharmalink & Medicina Group
Total years of experience :15 years, 7 Months
Sales:-
Managing & Preparing the Daily, Weekly, Monthly & Yearly Sales Report of Medicina Pharmacies over UAE
Sales Crediting and allocation to the Pharmacies & Individuals based on promotions, Offers & Quotations
Quarterly & Yearly Incentives preparation & distribution based on agreed methodology
Providing Sales Reviews to the Branch Sales Managers & Management with in-depth analysis of Sales Performance,
Product Performance, Individual trends, Achievements over Target, Competition, etc.
Sales Dashboard Presentation to the Management which gives an Overview of Company’s Operation.
Deep Dive Analysis on Sales Return - Cash Discount - Margin % - Bulk Sale - Quotation.
Generate Ad-Hoc Reporting for BU Heads & Management.
Ongoing System related query resolution to Pharmacist & Doctors throughout Pharmacies in UAE
Inventory:-
Analyzing inventory statistics to determine which products are selling the most and which are under-performing.
Performing random inventory counts and verify the numbers against distribution and receiving logs.
Analyze root causes of inventory issues and provide resolutions
Records purchases, maintains database, performs physical count of inventory, and reconciles actual stock count to computer-generated reports
Conducting & Leading Weekly Stock Audit over the Pharmacies to Monitor and Control the Stock Movements.
Preparing the Stock Report and analyzing the Cost Variance between System & Physical Quantity.
Final Presentation to the Management with the Stock Audit & Ageing Performance.
Stock Adjustment with the Final Variation and its Reporting to the Pharmacy In Charge.
Stock re allocation based on Average Sales & Available Stocks.
Initial Stock preparation of new Pharmacy based on BU Head approval & item classification.
Managing the Internal Stock Transfers from Main Store to the Pharmacies and vice versa.
Purchase:-
Monthly Purchase Review Report to the Management which helps in monitoring the Supplier wise Margin %.
Monthly & Quarterly Claims Report for Purchase Rebate & Incentives.
Maintaining the Listing Fees, Marketing Fees & Credit Note Tracker.
Fortnight Product Expiry report to the Purchase Team for Replacement or Liquidation Process.
Monthly Re-Order Level Report for each Pharmacies in Comparision to the Stocks over Sales
Ad-Hoc Reporting as per the request from the Management.
Key Responsibilities:
•Handling & Managing the MIS operations of “TRA Contact Center”
•Real Time Monitoring the Call Flows and Contact Center Agents with detail to their activities.
•Generate Daily, Weekly & Monthly Reports which give an impression of the contact center health to management.
•Scheduling & planning the roster according to the call flow and agent availability.
•Provide data analysis to the management which supports in progress of contact center.
•Generate Ad hoc reports as and when needed.
•Develops MIS documentation to allow for smooth operations and easy system maintenance
Database operational support to the client as and when required
•Analyzing the data and writing queries to extract the data for reporting purpose (MS-SQL, SSIS)
•Creating new reports & updating existing reports in excel as per the requirements
•Handling Weekly, Monthly and Quarterly report which gives the client an overview of sales Revenue and Margin
•Reports are created in different views as per the business needs. Views like conversion Rate, Segment Type, etc
•Handling the client call for any changes and implementation of the same whenever required
•Identifying and applying checkpoints to audit Reports
•Designing the click level process flow in MS-Visio and creating the failure mode effect analysis of the reports
•To support the Team Managers for Process Reviews and Learning the processes on a daily basis
Key Responsibilities:
•To handle the helpdesk system of HRMS Application on a daily basis wherein users log a call for any issues related
•to Login Credential, Resignation, Leave Management, Performance Management, Resource Management,
•Personal Information and Project star nomination.
•To handle the System Administration by operations like update in login credentials, workforce Administration,
•Leaves, Resignations, Performance Document management, reports and Resource Management.
•Writing SQL query and providing data from MS-SQL database as per the requirements.
•Analyzing and finding the root cause of the helpdesk tickets.
Commerce