Case study Development of Business Support System For Efficient Monitoring of Data

Client Bio

The client is the largest public Non-Profit Organization in the country, affiliated with skills development and training for the poor and vulnerable, enabling them to find sustainable employment. The client has worked with over 500,000 youth in 250+ demand-driven trades.

Client Goals

• Development of software serving as a centralized repository for information management.
• Automating manual tasks e.g., creation of training resources, schedules, and collaboration .
• Electronic payroll management mechanism.
• Timely alerts and notifications sent to the relevant authorities.
• Data verification from relevant external parties through API integrations.
• Robust monitoring of core business processes via interactive dashboards.
• Geographical information system dashboard for location mapping and tracking.

Solution(s) Offered

• Understood and mapped the organizational process by locking it through the Software Requirement Specification Document (SRS) which covered the Architecture design, database design, mockups, functional and non-functional requirements, and business rules.
• Developed test cases and test plans to guarantee seamless Quality Assurance.
• Migrated legacy application data (cleaning and removing anomalies) to newly developed BSS Application. The legacy data is being used for reporting purposes.
• Application development included the following major features:
  1. End to End Automation of Training services and their allied processes.
  2. User management, role and access management, workflow automation.
  3. Configurable business rule engine for classes, durations, stipends, violations etc.
  4. Creation of training schemes in the system.
  5. Training service providers, registrations, and allocation of classes.
  6. Automatic creation of batches and classes.
  7. Registration, verification by relevant government authorities and enrollment of trainees.
  8. Monitoring of trainees through an attendance system.
  9. Automation of stipend release to trainees through microfinance banks service providers.
  10. Exam-related data sharing of trainees with PBTE.
  11. Trainee employment mechanism and its related integration.
  12. Integration of BSS Application Purchase order, AP invoice and calculations with SAP system.
  13. Customized reporting and dashboards for management purposes by using the Tableau Business Intelligence tool.
  14. Advance search through keywords.
  15. GIS dashboard to visualize the geo-location of classes on an interactive map.
  16. Emails and Push notifications.
• Conducted User Acceptance Testing (UAT) with relevant business departments.
• Successfully went Live and deployed BSS Application.
• Provided the client with the BSS application User and Technical Manuals.

Client Challenge

• Lack of an efficient, automated, centralized repository of trainee information.
• Ineffective monitoring and evaluation of core business processes.
• Manual creation of training material, class schedules, etc.
• Disorganized tracking of finances and funds received.

Benefits

Reduce Systemic Inefficiencies

Save up on significant time lost due to automation

Effectively monitor and regulate the flow of finances

Significantly improve employee satisfaction & drive

Increase the number of training sessions conducted per day

Improve monitoring and management within the entire organization

Technologies Applied