At WB Data Focus we find clients often require expertise and advice for specific areas of a project. This may be because they already have employees who can develop parts of the system within their teams. We enjoy going in and adding our specialist knowledge to these projects. The requirements are often quite dynamic, and our experience tends to progress a project rapidly.
At WB Data Focus, one client was mid-way through a customer satisfaction survey across EMEA. Working in a project management capacity we were heavily involved with seven disparate offices across the region, each using a silo of data. These offices were consolidating their customers’ survey results, we brought all these results together into a central source of data. Our role was specifically to manage blockers in the separate offices, ensure the surveys were continuing to progress whilst producing and monitoring scorecards for the project sponsors in America. Our involvement lead to a far greater coverage of results from across EMEA particularly the regions which had little uptake prior to our involvement. Focus we find clients often require expertise and advice for specific areas of a project. This may be because they already have employees who can develop parts of the system within their teams. We enjoy going in and adding our specialist knowledge to these projects. The requirements are often quite dynamic, and our experience tends to progress a project rapidly.
Another client was struggling to achieve KPIs whilst making cuts back due to austerity measures which had been introduced a year earlier. It was decided that there would be a review of processes with the expectation efficiencies could be made and KPIs would improve. Our role was to liaise with the areas of the business which were unable to achieve their KPIs, analyse the issues and suggest areas which could improve to the management, e.g. locum staff, single keying of records and cross training. During these discussions it became apparent both employees and management did not have a clear view of the business’ data and the final KPIs. This led to the development of a suite of management reports, the data was extracted from an internal system to produce regular reports which showed the data numerically and graphically. This was widely considered to be a great improvement and gave leverage for process changes.
Our insurance client was completing a long project of merging a pension book into their existing systems. A team of managers and analysts was in place however they were not able to check the quality of the data before it was loaded into the database. Our role was to develop queries to load the migrated data, check for quality / dirty data, duplicates rows, check business rules have been applied and finally ensure the data reconciles with the original data. The majority of this project was developed using Excel and Access, as the business could use these tools. The pension book was loaded and reconciled.