Business Analyst
With technical ability to design and configure the solution
IIntegration Monitor
Low Code solution using MS Access to monitor integration folders highlighting areas of concern. The tool monitors hundreds of interfaces and reported back delays that needed attention. This helped assist smooth integration between our clients. The tool has since been adopted by Central IT services and has been developed as a core support function. This is a personal favourite of mine
Rejects Analysis
Low code solution using MS Access to provide automation reject anaylsys for a well know Swiss Pet Food company. The report displayed KPI by suppling factory brocken down by reject type, overhang, weight, height, bad data. This was acheived by integrating the tool with the Movement Control and Warehouse Management Systems. By one click of a buttpn, daily, weekly & period analysis reports were produced within minutes.
Business Statistics reporting
Leadership statistics reporting tool that calculated all volumes in /out of a warehouse and monitored against the KPI's. The stats pack was the key part of the monthly steer committee meetings.
ICo-Packing Planning Tool
Low Code planing tool that created job sheets based on forecast and demand. The tool analysed warehouse volumes and allocated inventory following stock rotation rules while maximising warehouse space utilitation.
Finance Tool
Low Code solution using Ms Acess to import data directly from reports and calculating weekly/monthly client invoices in MS Excel
Warehouse Support
I developed a tool used by the operational teams to produce picking instructions, despatch paperwork, commercial invoice and pick accuracy reporting.
IOutside Storage
I created an outside storage solution to accurately select which pallets are selected for outside storage and which pallets are required for warehouse activities.
Location Optimisation
I created a part pallet consolidation tool to help reduce overall capacity in a High Bay. The tool also managed the tracking of batch and Best Before End Dates.
Pallet Control / Reconciliation
After a full investigation I eliminated additional pallet charges from CHEP with a full breakdown prooving the results. I then created a pallet management tool to ensure pallet balances were within a tolerance of 500 CHEP & 50 LPR
IETSF Container Freight
Full review of an ETSF container freight solution with customs-controls. I mapped the solution wrote the interface specification, worked with the deveolopers, testing in full and trained the warehouse team
Imports & Exports review
After a succesful ETSF Container Freight review I moved on to a process review for the entire warehouse, considering Air/Sea/road with additional functionality to split pallets after initial receipt while maining accurate records for customs controls.
Customer Invoice deficit
It was identified that £2,963,090.79 of invoices had not been sent to a client. After a review of the process I identified all the inputs/outputs both system and manual. I found that a team member on short term sick was the reason the invoices were not sent and there were some formatting issues in the file. The invoice process was rolled out to other members of the team and the formatting issues were resolved