A multi-national client wanted to improve on a business critical manual workflow through process automation. The primary goal was to eliminate the manual errors through standardization and create a process that was repeatable and auditable. Secondly, our client wanted to incorporate data typically thought of as downstream into upstream work to reduce redundancy, increase workflow efficiency, and improve data reliability. With the long learning curve on the manual process, our client was spending vast amounts of time in mentorships and on-the-job training in order to be proficient in the process. This time cost not only dollars in wages, but also dollars lost in valuable productivity. Finally, the existing process relied upon disparate systems which added unnecessary complexity, cost, and error to the workflow.
First, we documented the workflow needed to perform the manual process between applications, data conversions, and decision points. Careful attention was placed on understanding the data input and output requirements between each step to understand and document any data conversions or possible data quality loss. Once documented, steps were collapsed, removed, and migrated to a common platform.
Once streamlined, we then focused on reducing the long learning curve and long execution time. We fine-tuned algorithms extracted from the client’s knowledgebase and best practices, and then convert the resultant specifications into usable software. The processes of extracting and refinement were done through an Agile methodology to allow for iterative reviews and feedback to achieve accuracy in repeatability.
To achieve execution goals decomposed algorithms into smaller computable units, upgraded the .Net platform to leverage the Task Parallel Library, and optimized the decision tree to free memory space earlier.
Bluware was able to transform a business problem from the client into a solution that streamlined their process, increased efficiency and availability of their solution, and reduced the learning curve for new talent. We achieved time savings measured in orders of magnitude, increased software performance, increased usability and availability, increased reproducibility and reliability, while reducing process complexity and barrier for entry for new talent
Tools + Technologies
- Petrel 2012
- C# /.Net 4.0 Framework
- Task Parallel Library (TPL) / Multi-Threading
- Microsoft Windows 64-bit Operating System