Project Summary
To Develop an Integrated Core Banking Solution and Decision Support System as an Enterprise Resource Planning Suite. We have an aim and that is to have a Single Database and a single Application to access the same from any where as far as possible to manage all our activities. For a more detailed explanation please refer to the Product Features List.
Key Words
ERP, Core Banking Solution, Enterprise Resource Planning, Co-Operative Banks, Banks, Non Banking Financial Institutions, NBFC
Introduction
Setup a centralised Database that is robust enough to encompass the different activities of a Bank or Financial Institution of any Size in any Vertical. Have a simple and a robust Application that shall allow us to access this Database from any part of the World with Security measures incorporated and Access to the Specified Persons with functions specific to their activities. Related reports and information will be shared between Different Departments that are customised and are of a practical utility.
Origin Of Proposal
By Our Experience and Observation we have found that not many Applications are available that try to provide an End to End Solution for a Financial Organisation or Institution at least in India and even if they are available at present they are not a common feature in Souhards, Co-Operative Socities and some Private Institutions.
Problem Definition
To have a Common Standard for Database Architecture so that it can be Shared across many different Levels in the Organisation and the External Environment like Government, Funding Agencies, Tax Authorities etc. apart from Customers for Decision making and a General Harmonious and Higher Progress.
Work plan
We will be starting with MS SQL Server as a Database, C# as Code Behind language and MVC.net with HTML as the Front End to start with and Development on other Databases and other Languages at a later stage depending on the Demand and need of the Technology.
Project Information
Review and Status of Research and Development in the Subject
Project Features / Product Catalog
IT Admin
- Branch Counter Current Denomination Balances
- Branch Current Denomination Current Balances
- Branch Current Denomination Run Balances
- Branch Deposits With Other Bank
- Client Document Details
- Client Loan Insurance Details
- Contact Asset Income
- Contact Loan Expense
- Credit Note Charges
- Credit Notes
- Debit Notes
- Loan Type Insurance Premium
- Other Bank Client Employee Accounts
- Pigmy Current Denomination Current Bal
- Shelf
- Terms
Contact Management
- Contact Address
- Contact Category
- Contact Group
- Contact
- Contact Type
- Country
- District
- State
- City
- Register Approve Payee
- Client Document Details
General Administration
- Deposits Withdrawals Details
- Deposits
- Denomination
- Denomination Type
- Yearly List Of Holidays
- Opening Balances For Accounts and Stocks
- Document Type
- Duration
- Complaints
- Complaint Type
- Currency
- Cash Counter Type
- Application
- Application Type
- Application Document Requirements
Loan Section
- Client Loan Requirements Process Stage
- Loan Type Insurance Premium
- Client Loan Insurance Details
- Contact Asset Income
- Contact Loan Expense
- Insurance
- Insurance Type
- Loan Account Link
- Loan
- Loan Process
- Loan Type
- Client Loan Insurance
- Client Loan Requirements
New Accounts
- Debit Credit Card
- Account Type
Security
- Menu
- Menu Type
- Module
- Module Table Details
Bank / Branches
- Bank
- Branch
- Branch Type
- Account In Other Banks
- Account
- Account Open Balances
Bank Charges
- Bank Charges
- Bank Charges Type
- Client Bank Charges
Taxes Duties
- G S T Bifurcations
- Tax Duty
- Tax Type
- Tax Schedule
Transactions
- Other Bank Withdrawals Denomination Details
- Branch Counter Current Denomination Run Balances
- Transactions Type
- Instrument
- Transactions Denomination Details
- Pre Transactions Client
- Bank Current Denomination Run Balances
- Cash Counter
- Bank Transactions
- Branch Acct Deposits Withdrawals
- Current Rcpt Details
- Cheque Collection Center
- Cheque Collect Register
- Cheque Issue Register
Accounts
- Account Group
- Account Section
- Asset
- Asset Type
- Expense Ledger
- Expense
- Expense Type
- H S N Schedule
- Income Head
- Income Head Type
- Invoice Type
- Branch Deposits With Other Bank
- Other Bank Client Employee Acc
Deposits Section
- Locker Type
- Deposits
- Deposits Type
- Locker Allot
- Locker Log Details
- Locker
Client Related
- Client Document
- Account Transactions Limit
Cash Transfer Section
- Cash Transfer Parent
- Cash Transfer Type
Pigmy
- Pigmy Branch Account Details
- Pigmy Current Denomination Run Balances
- Pigmy Collect Denomination Details
- Pigmy Collections
- Pigmy Collector
Purchase
- Purchases
- Debit Note
- Quote Parent
- Payment Mode
- Party Terms
- Purchase Orders
Sales
- Sales Orders
- Sales Order Terms
- Terms
- Credit Note Charges
- Packing Lists
- Billing
- Bill Terms
- Enquiry
- Bill Details
- Bill G S T Details
- Bill Other Charges Details
Inventory
- Material Requirement Parent
- Item Sub Type
- Item Type
- Issue Parent
- Unit Of Measurement
- Item Category
- Item Group
- Item
- Item Store Shelf Stock
- Item Service Category
- Item Service Group
- Item Service
- Item Service Sub Type
- Item Service Type
- Shelf
- Receipt Details
- Receipt Parent
Payments
- Payment Issues
Payments Receipts
- Payment Receipts
Human Resource Development
- Employee Benefit
- Employee Benefit Type
- Employee Current Sal Comp
- Employee Current Sal Deduct
- Employee Deduct On Sal Comp Configuration
- Employee Deduct
- Employee Deduct Type
- Employee Group Benefit
- Employee Group Deduct
- Employee Group Leave Type
- Employee Group Sal Comp
- Employee Leave
- Employee Leave Open Bal
- Employee Leave Register
- Employee Leave Type
- Employee Loan Apply
- Employee Loan Disburse
- Employee Loan Purpose
- Employee Loan Recover Details
- Employee Log Details
- Employee Configuration
- Employee Contribute
- Employee Sal Advance
- Employee Sal Adv Recover
- Employee Sal Benefit Details
- Employee Sal Comp Details
- Employee Sal Comp
- Employee Sal Comp Type
- Employee Sal Deduct Details
- Employee Sal
- Employee Sal Parent
Shares Division
- Share Dividend
- Share Dividend Details
- Share Allot Issue
- Share Capital
User Management
- User Type
- User Type Privileges
- Multi User
Sample Entity Relationship Diagram
Sample Entity Relationship Diagram
Time Schedule of Work Plan
| Sl No | Broad Work Element | Time Estimates In Months |
| 1 | Developing a Core Team who can type in all Languages that are used in India, These people will be developing the Resources Files that will be necessary so that users are comfortable in using the Core Banking Solution ERP. | 2 |
| 2 | Developing a Simple call Center that can explain the process that is to be employed for running and using the ERP, the same team will train other Startups to make sure that they will lend support for Data Entry Operators and other users who will be given adquate support as and when necessary. | 3 |
| 3 | We will be further Developing and Implementing an application that is nearly ready along with Design Rights to modify the Database and Front End so that new Versions can be developed for different Types of Lending Institutions like Societies, Co-Operatives, Souhardh, Scheduled and Non Scheduled Banks in the near future. | 2 |
| 4 | We will need Data Entry Operators who can completely segregate the Data initially from different States or may be we will have to have a strategy to get all Software Providers at present with whom we can work out a plan so that seamless Implementation can be planned and executed, this is a massive work and may need more resources. | 3 |
| 5 | The next step will be to ensure that we will build a Question bank and an Answer Bank will get developed depending on the quality of the answers that are provided and preferably we should have an Ideal Answer. | 2 |
| 6 | In short the Application software must support all the Core Funcationalities that are necessary to Run a Financial Institution or an Organisation that can bring about a stability across our Nation to start with. | 1 |
| 7 | Prime Importance will be to Develop an Implementation Methodology for Each one of the Financial Institutes, for eg. One possiblity will be first to have a common Software with All Data Support and Language Support for all State Government Run Institutions so that Quality of Lending and Deposits imparted is uniform irrespective of their location. A suitable idea will be to get people who are already working on such software at present to move and get trained on this Application. | 2 |
Minimum Group Organisation
| Sl No | Group Code | Position Description | No Of Posts |
| 1 | 1 | Testing Administrator | 1 |
| 2 | 2 | Assistant DB Architect | 4 |
| 3 | 3 | Internal User Interface Administrator | 1 |
| 4 | 4 | Data Mapper Administrator | 2 |
| 5 | 5 | Process Experts | 2 |
| 6 | 6 | Programmers | 10 |
| 7 | 7 | Accountants | 1 |
| 8 | 8 | Process Designers | 2 |
| 9 | 9 | Internal Marketing Administrator | 1 |
| 10 | 10 | Internal Project Manager | 1 |
Suggested plan of action for utilization of Research Outcome Expected from the project
We are planning to Tie Up with Ramakrishna Mission Vivekananda Educational and Research Institute http://rkmvu.ac.in/ so that they can maintain the Entire Design, Source Code and Related Documentation necessary for it to Survive and Grow or Tie up with Microsoft Corporation / Microsoft Foundation so that A Team can be formed to Ensure that these Services and Upgrades are available to All Organisations in India freely to Develop and Enhance but not to Voilate the Set Statuatory and Predefined Standards.
Budget Estimates: Summary
| Item | BUDGET | (in Rupees) | |||
| 1st Year | 2nd Year | 3rd Year | Total | ||
| A. | Recurring | ||||
| Salary Expenses | 67500000 | 74250000 | 81675000 | 223425000 | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 | |
| Travelling Expenses | 2400000 | 2640000 | 2904000 | 7944000 | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 | |
| B. | Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
| Grand Total (A+B) | 72600000 | 79860000 | 87846000 | 240306000 |
Budget for Salaries/Wages
| Position Description | No Of Posts | Monthly Emoluments | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |||
| Testing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Assistant DB Architect | 4 | 250000 | 12000000 | 13200000 | 14520000 | 39720000 |
| Internal User Interface Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Data Mapper Administrator | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Process Experts | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Programmers | 10 | 200000 | 24000000 | 26400000 | 29040000 | 79440000 |
| Accountants | 1 | 125000 | 1500000 | 1650000 | 1815000 | 4965000 |
| Process Designers | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Internal Marketing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Internal Project Manager | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Totals | 67500000 | 74250000 | 81675000 | 223425000 |
Budget for Consumable Materials
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 |
Budget for Travelling Expences
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Travelling Expenses | 2400000 | 2640000 | 3630000 | 8670000 |
Budget for Other Expenditures
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 |
Budget for Equipment If Applicable
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
Infrastructural Facilities
| SrNo | Infrastructural Facility | Status |
| 1 | Workshop Facility | Yes – Sharing basis |
| 2 | Water & Electricity | Yes - Sharing basis |
| 3 | Laboratory Space/ Furniture | Yes - Sharing basis |
| 4 | Power Generator | No |
| 5 | AC Room or AC | No |
| 6 | Air Cooler If Tempratures are too High | Yes |
| 7 | Telecommunication including e-mail & fax | Yes |
| 8 | Transportation | Yes |
| 9 | Administrative/ Secretarial support | Yes – Sharing Basis |
| 10 | Information facilities like Internet/ Library | Yes – Sharing Basis |
| 11 | Computational facilities | Yes – Sharing Basis |
| 12 | Animal/ Glass House | No |
| 13 | Any other special facility being provided | Not Required |
Equipment available with the Institute/ Group/ Department/ Other Institutes for the project
| Sl No | Equipment Available | Generic Name Of Equipment | Qty Available | Model Make And Year Of Purchase | Remarks Including Accessories Available And Current Usage Of Equipment |
| 1 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 2 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 3 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
