A global consulting and certification company needed to simplify their document automation and templating process which was dependent on multiple data sources and manual handling of thousands of documents each week. PSC developed a solution that shifted report design and publication from internal IT to business-line owners. Efficiency dramatically increased and the solution transformed their document generation capability from what was taking hours or sometimes days, to seconds per document and integrated it globally across the business to serve internal staff, partners and external clients.
The business of validating, auditing and certifying tens of thousands of various product categories in 40 countries produces a dizzying number of documents and document management challenges that require the attention of a dedicated team.
The company’s internal publication services team serves requests for generating various product documents, certificates of authority, and other certification docs utilizing more than 50+ types of templates, and generates as many as 7,000 to 10,000 documents each week reliant upon manually aggregated data from disparate production systems.
After partnering with PSC on other successful, large scale information management projects, the client team was confident that PSC could engineer a solution to improve their document generation process to benefit both its internal team as well as its customers. The resulting solution excited the PSC team as much as the client.
With 185 offices globally, more than 100,000 products are evaluated annually. The volume of documents manually produced to support that activity was challenging and complicated by the vast amount of data from multiple data sources in different locations that needed to be aggregated to produce each document.
The required query of data was dependent on separate systems to manually consume, collect and filter data into each specific document and was time-consuming and prone to error. Report data resided across legacy systems, multiple RDMS databases (both local and cloud based) and manual spreadsheets. Not only was information difficult to find, security sometimes prevented information from being obtained.
During the PSC led discovery, several goals for the project were identified to improve process accuracy and efficiency:
PSC worked with the client team to identify the first templates to automate and connect the data sources as part of the process.
PSC’s partnership and previous work with the client would reveal process and application efficiencies that would enable the desired outcome. All of the client’s goals were addressed with one utility, which surprised the client due to the many disparate data sources needed for their document generation requirements. PSC leveraged the Windward reporting engine and templates and wrote a custom user interface integrated with their Identity Access Management (IAM) system so the client could maintain a user-friendly interface and end users could easily produce custom templates and certificates with the required data on demand.
Windward proved to be the most cost-effective tool to automate the document generation process because it is user friendly and requires minimal training. It is also easier to use than other open source solutions the client considered and easy enough for business stakeholders to maintain without the need for IT to manage it day-to-day. The custom UI reduced ownership cost in both maintenance and licensing since only server cost came into play versus individual user access.
The client was so pleased with the outcome, they plan to promote it to the cloud and turn it into a self-service solution for external clients to look up status or publish a certificate for their unique product or logo on demand. The new system intelligently hosts multiple types of documents across clients – QA, engineering, certifications, manufacturing, etc. What began as a four-week proof of concept has expanded to an application that provides global publication of reports and documents in ways they never imagined.