Month-end close automation
Situation. The month-end close consisted of recurring processing, checks and output into HFM.
What I built. A fixed close run for Exact/D365 with validation, mappings, processing and controls.
Result. From around three working days to a maximum of two hours. The steps and output are controllable, auditable and adaptable.
Technology: Exact, D365, HFM/SmartView, Python.
Quarter-end close package
Situation. The quarter-end close previously took around three working days each quarter.
What I built. An HFM/JSOX closing package with fixed processing, controls and traceable output.
Result. It now takes around one and a half hours to run. Exceptions remain visible and the work is easy to follow and adapt.
Technology: HFM, JSOX, Exact/D365, Python.
PDF tool for daily use
Situation. Standard PDF tasks required licences even though the work itself was simple and recurring.
What I built. An internal tool to merge, rotate, split and optimise PDFs.
Result. Built in around half an hour and now used almost every day within the company.
Status: live internal solution.
PSR for CargoWise
Situation. Operational data in CargoWise needed usable reporting and management information.
What I built. Reports, dashboards and management information from CargoWise data.
Result. Source data was made usable for daily management.
Technology: CargoWise, reporting and dashboards.