Problem statement
The monthly financial reconciliation process is manual, time consuming, not detailed enough and at times miss deadlines. This manual process requires investigation & explanation for any variances that occur between 6 separate datasets supplied by 3 teams. This results in delays, overtime, and occasional missed monthly deadlines.
Objective
To simplify and error proof the the end on month reporting.
Lean Ireland consulting/training work
This project was completed by certified lean six sigma green belt (CLSSGB) candidates who undertook a customised in-house 5 day online training programme facilitated by Lean Ireland. The training involved interactive webinars, academic assignments and team-based project work within the organisation. The DMAIC (define, measure, analyse, improve and control) project framework, plus a varied toolset for each phase enabled the GB lead and the cross functional team to work through the project phases. The Lean Ireland facilitator, a certified black belt, provided project mentoring on a regular basis throughout the project lifecycle. Certification was achieved by completing the two academic assignments, and presenting the completed project to a certification review board comprising organisation managers, certified green belts and the Lean Ireland black belt assessor.
Detailed results of the client work
The GB team used the lean six sigma DMAIC process and toolset to standardise data base templates and report formats across teams. They eliminated manual SQL queries, reduced the movement of data between different systems and automated the process of identifying exceptions.
Level of Lean Ireland of engagement
Certified lean six sigma green belt (CLSSGB) training course facilitated by Lean Ireland to ISO 13053-1 standards. Project completed by Green Belt candidate team. Total consultant days involvement was approximately 15 days, including training, project mentoring and certification for a CLSSGB cohort of 12 candidates.