Sahat Hutauruk

Savings and Loan Cooperative System

Created a Savings and Loan Cooperative System all module until to accounting/general ladger



Client :

Permata Bank Medan

Website : permatabank.com

Size : 300+

Date : 2013 - 2014

Work :

  • Visited to location/company to do survey and collect data, conduct interviews with users, how SOP manual users during this time is. Come to location(6+ times)
  • Analyze data & create erd, dfd, database relation, flowchat, use case, class diagram, etc, analyze users level/access module every users level, develop, socialization, maintenance system
  • Setup & install project to LAN (Local Area Network)
  • Teams With Me : Accountant | Tester | Networking
  • Tech : PHP | Mysql | Networking | Jquery

Data Flow Diagram :

  • Entity consist of(member, items, coa)
  • Members registration of cooperative members
  • Saving proccess : After registration, members will continue to payment. Which consists of : principal savings, mandatory savings, voluntary savings
  • Loans proccess : In this process, the amount of the members loan will be adjusted to the amount of the members savings and to get interest loan member, it's depends of loan type members
  • Installments proccess : In this process, record member loan installment payments and automatically, system will display (installment amount, installment period and late charge the members - readonly)
  • Accounting proccess : consist of COA, journaling, daily journal reports, general ledger, trial balance, profit and loss, posting (close balance)
  • Buying and selling cooperative goods proccess
  • Reporting that needed management in pdf format

The Results :

Tables
56
Number of database tables
Duration
3+ Month
Development Time Until GoLive
Maintenance
6+ Month
System Warranty - Maintenance Extension
Average Records
25+
Average records incoming per day

Want me to help with your project?

If you take on freelance work, you can use this section to prompt any potential clients to get in touch with you with their project requirements.

Choose Colour