Muhammad Jamil

Professional Summary

Highly skilled Database Systems Executive with a proven track record in developing and managing robust databases, tailored systems + implementations resulting in reduction of COGS by 11.5%, and interactive dashboards to optimize company-wide operations ensuring deliverance of results and saving time in retrospect.

---

Key Achievements

CrunchTime Inventory Management System Implementation and Management

Designed and systematized the database system, converting manual stock tracking into a tailored digital format that meets business needs.

• Recipe and SKU Importation: Verified and imported all company recipes with the head chef. Reformed and imported warehouse SKU descriptions to maintain professionalism and accuracy in stock management.
• System Configuration: Configured system settings, including location hierarchy setup, to align with business requirements.
• POS Integration: Integrated the Aloha Point of Sale system with the Inventory Management System for accurate COGS calculations post-sales input.
• Custom Reporting: Developed custom reports to support the Cost Controller, Finance Department, and Operations, ensuring precise data analysis and decision-making.
• Comprehensive Training Program: Rolled out the system across the kingdom, delivering a 5-day training program for managers and relevant personnel to ensure effective system usage.
• Financial and Inventory Calendars: Established financial and inventory take calendars for accurate COGS calculations, synchronized with business cycles.
• Cost Tracking and Inventory Accuracy: Ensured accurate cost tracking, stock movement records, consumption trends, and overall inventory accuracy within the system.

Interactive Departmental Dashboards: Tailored Dashboard Creation: Designed and implemented interactive dashboards for multiple departments, enabling real-time tracking of Key Performance Indicators (KPIs) through automated report exports using VBA codes.

HR Department Dashboards: Developed comprehensive dashboards including a Saudization Tracker, Onboarding/Offboarding Tracker, and a Nationality Chart with extensive filtering options to monitor HR metrics effectively.

Supply Chain Dashboards: Created dashboards to track savings, stock movement KPIs, and expiry alerts, enhancing visibility and management of supply chain operations.

Warehouse, Logistics, and Maintenance Dashboards: Implemented various KPI trackers, cost control measures, and efficiency metrics, WH capacity, used in monthly review meetings with department heads to drive performance improvements and operational efficiency.

Finance Dashboards: Collaborated with the Financial Controller to define KPI metrics for the finance department, measuring control and department performance, and implemented custom tracking dashboards.

Marketing Dashboards: Identified key performance indicators, suggested KPIs to be tracked, set up the dashboard, and introduced it to the Marketing Manager, facilitating better performance tracking and decision-making.

Policy and Procedure Development: Contributed significantly to formulating policies and procedures for Warehouse, Logistics, Supply Chain, and IT departments, ensuring standardization and compliance throughout the business.

ZEN HR Database Development and Implementation:
Lead the Successful Launch After 3 Failed Attempts:
Stepped in to lead the ZEN HR database project after three previous HR managers were unable to launch it successfully.

Creation of Policy and Procedure:
Developed comprehensive policies and procedures for the ZEN HR application, ensuring clarity and consistency across the organization.

Feature Management and Testing:
Managed and rigorously tested every feature of the application to ensure flawless performance before the official launch.

Data Import and Implementation:
Oversaw the smooth implementation of the ZEN HR system, meticulously importing manual HR data into the system’s format intake, ensuring data integrity and accuracy.

Setup of Transaction Requests:
Configured transaction requests within the system for leaves, vacations, and other HR-related requests, streamlining the process for users.

Departmental Grouping and Hierarchy Setup:
Established departmental name grouping and hierarchy to align with business needs, enhancing the accuracy of report exports.

Custom Learning Materials:
Created professional learning materials, including videos in six different languages, to train employees and managers on the new system.

Creation of Approval Matrix for Process Efficiency:
Developed and integrated an efficient approval matrix within the ZEN HR system, covering processes like vacations, business trips, per diem, and unpaid vacations, streamlining workflow, and ensuring policy adherence.

Integration of Custom HR Forms:
Innovatively converted HR forms into HTML code, facilitating seamless integration into the ZEN HR system. This transformation improved accessibility and user-friendliness for HR-related documentation and certificate exports.