slide no. 1/17 what the market offers – an overview of mis-solutions available from indian and...
TRANSCRIPT
Slide No. 1/17
What the market offers – An overview of MIS-solutions available from Indian and international IT vendors
By Upendra Singh
Presentation for RMEP, Aug 2008, Pune
Slide No. 2/17
1. Evolution of technology
2. MIS profiles of Indian MFIs
3. IT vendors and their products
4. Reporting Tools
Presentation Outline
Slide No. 3/17
Evolution of Technology
Evolution of technology in an organization can be classified on the basis of their functionality and the time of entry into the organization
Technology Time of Entry Into the
Institution
Primary Functionality
Information System
Technologies (MIS)
First form of technology in any organization
Data and information
recording and reporting
POS Technologies Second level of intervention
after information systems,
provides additional functionality
Increasing operational
efficiency, maximizing
outreach, reducing costs
Integration
Technologies
Introduced in large organizations
that are on growth plateau and
Usually leverage POS techno -
logies
Integrating organizational processes
and systems through shared platforms:
MIS, POS, and networking
technologies
Slide No. 4/17
Evolution of Technology
Information System Technologies (MIS)
The basic technology building block for an MFI
Point of Sale/Service technologies (POS)
The MIS platform provides the supporting infrastructure for POS
POS in the microfinance context is the point where financial services are exchanged between the client and the financial institution
Technologies such as palmtops, personal digital assistants (PDAs), smart cards, biometrics, and mobile banks
Slide No. 5/17
Evolution of Technology
Integration Technology
Build upon an institution’s existing Infrastructure and aim to provide
networking solutions and a common integrated platform.
MFIs will also have found the balance between an optimum level of
technology infrastructure and institutional capacity
Having a Central Information Bureau form of integration technology that brings all partner MFIs under one information system umbrella, leading to cost sharing and facilitating process standardization
Slide No. 6/17
MIS profile of Indian MFI’s
Tier I
Manual / rudimentary paper based MIS systems
No IT team
To identify vendors for suitable MIS systems
Tier II
Automated/semi –automated systems (Excel and Access based).
Does not completely meet the requirements , Small IT team
Stabilizing MIS systems to meet organizational growth requirements
Slide No. 7/17
MIS profile of Indian MFI’s
Tier III
Well developed, sturdy automated, computer based MIS systems that meets all requirements.
Systems designed/co-developed by in house IT team or IT vendor
Dedicated IT teams, usually 15-20
Upgrading MIS systems to enable superior technologies
Slide No. 8/17
IT vendors and their products
Name of Organization : Atyati Technologies, BangaloreProduct Name : GanasevaKey Features : Complete suite of banking products features supported Operable with or without smartcard , Device could be static (PC ) or mobile(Laptop \PDA\Smartphone
Name of Organization : Force Ten Technologies , KolkataProduct Name : BIJLI ( Business Information Justified & Logically Integrated ) Software & Hardware Requirements : Visual Basic , SQL Server 2005 , Crystal Reports 9xKey Features : Accounting and portfolio tracking integrated system can be On line or Off line Backup and recovery module guides for back up and recovery Reports at every level Branch ,Credit officer ,center , group The HO module will automatically consolidate all or selected branches and generate reports dynamically,
Slide No. 9/17
IT vendors and their products
Name of Organization : Cranes Software International Ltd, BangaloreProduct Name : BRmfo & BR.NET Software & Hardware Requirements : Windows Server System 2003 ,GUI: VB6 ,Report: Crystal Report 9x , RDBMS: SQL Server 2000/2005 , ASP.NET, C#, jscript ,Report: Crystal Report 11xKey Features : Accounting and Portfolio systems are integrated in our BRmfo Disk mirroring is possible with server setup Off-the-shelf with scope for customization History details for selected master/transaction information BRmfo can take back-up on every EOD process
Name of Organization : Gradatim IT Ventures India Pvt Ltd, BangaloreProduct Name : MF RESOLVE Software & Hardware Requirements : ASP model and for data storage IBM severs are used , PINPOINT, Windows Server System 2003 , SQL Server 2000/2005
Slide No. 10/17
IT vendors and their products
Key Features : Fully customizable to suit customer requirements Through report engine on request as it uses a PIN POINT for report generation Backend infrastructure is built to handle failover ,if one server fails, we have RAID system to handle the transactions
Name of Organization : Sathguru Management & Consultants Pvt Ltd, Hyderabad Product Name : Delphix Enterprise Solution for Micro Finance IndustriesSoftware & Hardware Requirements : Developer 2000 , Oracle Discoverer 9i, Oracle 8i/10g, Windows Server System 2003Key Features : Following five modules Operations ; Financial Management ; Human Resources Management ;Payroll ; Head Office Consolidation Accounting and Portfolio systems are integrated Insurance Accounting & Members Accounting
Slide No. 11/17
IT vendors and their products
Name of Organization : Jayam Solutions Pvt Ltd , HyderabadProduct Name : Financial Information & Monitoring Organizer(FIMO) Software & Hardware Requirements :Visual Basics ,SQL server ,Crystal Reports 9x, Windows Server System 2003 Key Features : Integrated accounting package built on CGAP's guidelines on accounting principles Management can specify the permission levels for various users Following modules Institutions,Manager,Members,HRM,MIS,Accounts, Utilities,Report Incremental & full backup of database
Name of Organization : Kredits ,USAProduct Name : loan and savings information management Software & Hardware Requirements : Visual Basics ,SQL server ,Crystal Reports9x,MsAccess
Slide No. 12/17
IT vendors and their products
Key Features : supports both lending and savings transaction management runs on stand-alone PCs under a free, run-time version of Microsoft Access, powerful reporting and data export capabilities credit scoring module to analyze the risk
Name of Organization : Safal Solutions (P) Ltd , HyderabadProduct Name : SafalFin3.0(MFI Model ) / SafalFin2.0(SHG Model)Software & Hardware Requirements : Microsoft Windows 98/XP/2000 , Microsoft Access 97/2000 , .Net , delhpi , crystal reports , PHP, SQL server Key Features : monitors internal member saving and loans provision for all books of accounts at group, cluster & federation levels tracks borrowings from commercial banks with calculation of interest payable to borrowers validate complete process of loan application, sanction, disbursement and collection of loan repayment.
Slide No. 13/17
IT vendors and their products for Financial
Inclusion
Name of Organization : Coromandel Infotech India Limited ,Chennai
Product Name : Smart Connect
Software & Hardware Requirements : Java as the front end and MySQL as database, Jasper reporting tool is used for reports , Struts , Hibernate , Hand Held Terminals, Smart CardsKey Features : Smart Connect provides an efficient vehicle to reach the unreached to achieve the goal of financial inclusion Three types of backup of data incremental ,differential & full full backup of data stores all files and folders, frequent full backups result in faster &simpler restore operations uses finnacle for core banking operations prints receipt for every transaction executed at the field authenticates clients using smart cards
Slide No. 14/17
IT vendors and their products for Financial
Inclusion
Name of Organization : A Little World ,MumbaiProduct Name : Zero Software & Hardware Requirements : Nokia (NFC mobile) , NXP Semiconductors (RFID), Sagem Securite (Biometrics), SmartTrust (WIB application)Key Features : voice prompts during enrolment and transactions printout of each transaction using a thermal printer bluetooth connectivity used for connecting the field devices with mobile at field Mobile phone used for opening accounts on-the-spot by local CSP, accounting & portfolio tracking integrated
Name of Organization : Eko India Financial Services Pvt. Ltd , New DelhiProduct Name : SimpliBank Banking Platform Software & Hardware Requirements : Built using J2EE , MySQL, Linux Servers
Slide No. 15/17
IT vendors and their products for Financial
Inclusion
Key Features : backup levels RAID 1 weekly full and daily incremental EOD reconciliation with the Core Banking platform of the bank accounting and portfolio tracking
Name of Organization : FINO, MumbaiProduct Name : Biometric Enabled Multi- Application Smart CardsSoftware & Hardware Requirements : Biometric Cards , customized terminal application Key Features : Supports savings, fixed deposit, remittances, loans & recurring deposits Built around cutting edge Core Banking Solution (CBS)
Slide No. 16/17
IT vendors and their products for Financial
Inclusion
Key Features :
Smart Cards holds transaction history
Requires only a smart card reading device and a fingerprint sensor at any point of transaction.
Supports both online & offline transactions
Slide No. 17/17
Reporting Tools
Crystal Reports
business intelligence application used to design and generate reports
from a wide range of data sources
use it to select specific rows and columns from a table of compatible data
data sources include Sybase ,IBM DB2, MS Access,SQL server, Oracle,MySQL,XML & text files
easily access, analyze and generate reports from data gathered
lowers the ongoing cost for IT support required
Easy to learn & implement.
Slide No. 18/17
Reporting Tools
Oracle 9i Discoverer
provides flexible access to business information, helping companies satisfying their organization's ever evolving reporting needs
use it to select specific rows and columns from a table of compatible data
Knowledge of SQL for creating and maintaing database objects and to
store,retrieve, and manipulate data
Slide No. 19/17
Reporting Tools
Jasper Reports
Open source reporting library that can be embedded into any Java application.
Supports many chart layouts, such as Pie, Bar, Stacked Bar, Line, Area, Scatter Plot, Bubble, and Time series.
Additional data sources can be added using pluggings-JRQueyExecutor
No license fee
Java & SQL training is required
Used in Java-enabled applications, including J2EE or Web applications
Slide No. 20/17
Reporting Tools
PINPOINT report
Integrated suite of Data Warehouse, Decision Support, Reporting & Report Distribution software
"Drill down" analysis can be performed at any time without constraint
Non-technical users can easily access, analyze and generate reports
Easily access, analyze and generate reports from data gathered
Lowers the ongoing cost for IT support required
Deployed on Unix, Linux and Windows servers using thin client or web
access using desktop, laptop or hand held computers
Slide No. 21/17
Thank you very muchfor your attention
Upendra Singh , Sa-Dhan