BOMS (Batch Operations Management System)
This solution makes the task of scheduling complex batch processes really simple to configure and provides simple interfaces to execute these tasks.
Organisation
A Leading Financial Securities Company.
Name of Project
BOMS (Batch Operations Management System)
"In this endeavour, Paramatrix has brought tremendous value to the table by architecting the most optimum system integration solution, within the constraints."
- Company Representative
Business Context
The customer has various batch processes to be triggered either at the scheduled time or based on an event. Prior to this solution, the batch processes were run manually by a dedicated team. Because of the large inter-dependencies between the processes, the chances of errors viz., wrong execution, incomplete executions, etc., were very high. The BOMS intends to address these issues by having tight control over the processes along with the contact points in case of failure.
Challenges
Key challenges that we addressed by BOMS
- Inter-dependencies of the processes to be checked
- Ability to define multiple steps for a process
- Multiple batch processes viz., File-based (.bat / .exe), SQL-based (Stored Procedures / ETL Packages)
- Option to retry tasks (if failed)
- To store Task-level contact details
- In-built access control to ensure the task is executed only by authorised persons
Solution
This application is built on open source based Django-Python-Nginx-MySQL stack and implements Role Hierarchy. Templates for Goal-sets are defined for applicable departments. Supervisors choose suitable templates and make modifications to them, while setting goal for subordinates. This process involves face-to-face meeting with subordinates and the capture of the crux of these discussionson the system, using the UIs provided.
The business need of the client was addressed by delivering the Batch Operations Management System (BOMS). The BOMS is a desktop-based solution built using useful components from the Microsoft technology-stack, viz., the .Net Framework 2.0, SQL Server 2012, SQL Server Integration Services. The BOMS allows users to define processs and the sequences of the tasks to be executed within the processes. It empowers the end-user to define the interdependencies between processes and tasks.
Benefits
Although the solution was delivered to a leading broking organisation, the BOMS is well equipped to address the need of scheduling inter-dependent batch processes for organisation in other industries as well. It allows users to create complex execution schedules and implements sophisticated checks and validations at the execution points of the tasks. The in-built access controls, ensure that only authorised personnel can run tasks. The robust solution architecture and strength of Microsoft SQL Server 2012 empowers the solution to be scalable and ready to handle large volume of data.
