DataCOLLECTOR, Report Generation Tool, Data Collection Technique | 63 Moons

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

FAQs

DATACollector Brochure