DataCollector
A software product to automate the life-cycle of data collection process
The Product
DataCollector is a web-based electronic data submission and report generating system for banks, large corporate and any apex organisation, which allows end users to manage the entire process of information collection – right from creation of forms required for data submission to generation of reports by using the application interface.
The Challenge
In today's dynamic world, the efficiency of any regulatory supervision system depends on the access to right data at the right time. If a regulator or any apex organisation needs to urgently collect data that does not form a part of the standard data collection format, and regulated entities, then there is a requirement of a system that allows them to provide the requested data seamlessly. The regulator's need encompasses information management, collation, validation, report generation, analysis, and correlation with other datasets in a secure environment capable of warning users based on trigger values for different ratios, KPIs, and KRIs.
Solution
DataCollector addresses all formats of data submission, with multiple methods for uploading the data, including excel. It uses a flexible 3-tier modular architecture that can generate parameterised reports and ratios based on the submitted data. DataCollector can also define threshold values for a trigger ratio that automatically warns users when breached via an SMS and an Email. There is peer group comparison report functionality together with tools to analyse data submitted by a given user or a selected group of users and to generate sector, regional, and country reports. The application is secure and has a user profile-based home page with a detailed audit trail capability.
The Technology
The DataCollector software is Java based and the back-end can be used either in SQL or Oracle.
Value Addition
Entities (say, banks) submitting data to the regulator, only need a browser to access the application using a secured connection to the data center hosting the application. They also have the facility to retrieve any data that they have already submitted.
Features
- Platform - DataCollector is a web-based system for data submission by user, be it banks, individuals, corporate entities, own business units or branches that would obviate manual entry of data, paper-based form or ad-hoc excel form, and allow data to be uploaded to a database seamlessly
- Efficient - DataCollector reporting functionality includes the capability to create a peer group comparison report, and temporal analysis of items submitted by a given user or a selected group of users. The system also generates aggregate reports at sector level, regional level and at the country level
- Network - DataCollector has capability to generate automatic alerts whenever a given item submitted by a user crosses a threshold level. The system provides online help, guidelines, and business rules used to create various surveys, questionnaires, and forms, etc
- Flexibility - DataCollector allows creation of pre-formatted and ad-hoc reports based on data submitted by users. Any other derived data would be calculated by the system itself as and when such data is uploaded into
- Performance - DataCollector allows creation of pre-formatted and ad-hoc reports based on data submitted by users. Any other derived data would be calculated by the system itself as and when such data are uploaded into the system
- Support - DataCollector can be used for online distribution of pre-inspection surveys/ questionnaires to a group of users, and submission of the same by the latter directly into the system
- Engine - DataCollector allows multiple methods of submitting data into the system like EXCEL upload and online form-based upload
- Security - DataCollector ensures data security, password protected access, and user profile-based home page. The system has detailed audit trail capability