Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
titlePage In Progress

The 2017 Google Summer of Code application period has opened. The Mifos Initiative will be applying as a mentoring organization and hopes to be selected once again in 2017. Applications are due by February 9 and accepted orgs will be announced by February 27. Subscribe to this page for the latest updates to project ideas and mentors assigned to projects.

...

We're looking forward to participating in Google Summer of Code for our fifth year. In 20142016, we successfully graduated seven six stellar interns from across the world who are continuing to make substantial contributions to our community. We hope to continue building our next generation of contributors who are joining in our movement to fight poverty through open source software. We want you to be part of our mission of creating a world of 3 Billion Maries.  

Students in 2016 2017 will have the option to work on a variety of projects related to our front-end Web App built on top of the AngularJS framework, and a variety of other apps including our Android-based field officer app and client banking app, and modules like our data import tool. 

...

We have a talented and passionate group of mentors from across our global community who are eager to help guide the next generation of HFOSS contributors. These mentors come from various backgrounds - partners deploying Mifos, financial institutions using Mifos, volunteers, and even former GSOC students but they all share a common goal of ending poverty one line of code at a time!

...

Mentor

Project

Location

Time Zone

User Profile
user557058:2babbedd-40a6-49ca-a275-eeea25a56fd5


IndiaIST (GMT +5:30)

User Profile
user557058:baa70ad7-a1b4-4b07-811f-3e00d46c5217


IndiaIST (GMT +5:30)

User Profile
user557058:0eefdc3c-e4d3-4b22-9ebb-955de4bfe289


CameroonWAT (GMT +1:00)

Avik Ganguly


IndiaIST (GMT +5:30)
User Profile
user557058:97f431bd-ba62-4425-98ec-3e2fef3d55ea

IndiaIST (GMT +5:30)
User Profile
user557058:59fb7242-26f4-4765-96bf-3dcaf1486cc8

IndiaIST (GMT +5:30)
User Profile
user557058:59a2f1c9-f496-449b-9ea9-9ab65b908d01
TentativeUSAPST (GMT-8:00)
User Profile
user557058:aa6d6a9e-ec9b-4c00-8ab1-726a8d728e8f
TentativeIndiaIST (GMT +5:30)
User Profile
user557058:aab98d2d-d423-4c6c-a0c7-8dbca28dbce1

USAEST (GMT -5:00)
User Profile
user557058:de8e1c9c-9812-4418-b305-e1dc99f00b07

PortugalWET (GMT)
User Profile
user557058:58b90ff8-2354-4efa-857a-e989b8cdea6b

KenyaEAT (GMT +3:00)
User Profile
user557058:926694e8-081e-4f88-856e-f4699dbd043e

IndiaIST (GMT +5:30)
User Profile
user557058:ffa4572c-9441-4cd3-8624-642afa343f90
TentativeIndia

IST (GMT +5:30)

User Profile
user557058:c2e8e137-24b0-4079-a016-1f060d3789c0

IndiaIST (GMT +5:30)

...

...

Mentors
Overview & Objectives

For this project, we require an intern who is qualified and willing to work core HTML5 offline functionality. If we able to add offline support in community-app then we can have same application working on all browsers with offline support and need of a desktop app will not be needed.

Description

The project will involve the following:

  • We can use IndexDB for storing data offline and once connected synchronize it, store actions that happened in same sequence and then fire against server.

  • We can store some data in JSONs as key-value pair and offer pre-sychronize which will fetch data as JSON for creating clients and other actions in offline mode.

  • Currently, HTML templates load from server everytime we refresh our application. As, discussed we should have some sort of template caching with expiry headers.

  • We can make some template made available offline using application cache.

  • With Template cache which is angular component. It looks for template in cache if not in the cache, it will load from server and then put in cache.

  • Mimic synchronization back and forth mimic how you store, how you date it out.
Helpful SkillsJavascript, CSS, HTML5. HTML5 Offline support knowledge i.e - Service workers, Sw-toolbox, IndexedDB wrappper - Dexie.js
ImpactOffline Functionality to Community App
Other ResourcesMore Information on Project

...

Mentors
Overview & Objectives

A crucial part of financial inclusion is micro-insurance and the ability for clients to safely manage risk in their lives. Mifos X will not fully handle the entire lifecycle of an insurance product but it should integrate with microinsurance system and track the key parts of the process that relate to the core banking system - collection and pass through of the premium and tracking claims and processing of these.

Description

This project would involve building out a separate module that tracks claims being made by a client, likely leveraging the CRM functionality being build to track activities. It will integrate with APIs to enable processing of the claim and tracking what proceeds must be paid out to the client.

It will involve creating a new module with data model, UI screens and business logic that leverages Mifos X APIs

Tasks involved include:

  1. Implementing a flag at the client level to denote if a person is deceased - if deceased, all loans would go into different status where all income, interest, fees, etc should stop accuring.
  2. Utilize Data Tables to enable a user to initiate an insurance claim with details of the cliam and corresponding updates to follow up on the claims process. Must limit this data table only to the clients with the corresponding flag so it's not displayed for all clients.
  3. Processing of Claims - the insurance claim can either go directly to the client or directly to the Financial Institution. If directly to the FI, the outstanding amonst should be offset by the claim - it could be automatically applied using a new different payment of insurance claim. Corresponding accounting entries need to get passed as well.
    1. If there is money to be refunded to customer, they must have a savings account as can''t like journal entry to customer directly.
  4. Closing of Account - once claim has been processed and outstanding balance settled, should implement a different status such as Closed - Deceased or Closed - Via Insurance Claim
Helpful SkillsHTML, Spring, Hibernate, REST, Java, AngularJS, SQL  
Impact

Clients are able to lower their risk and have a much larger safety net when they have affordable access to insurance policies.

Other Resources

See http://www.openunderwriter.com/

See Insurance Product

...

Extend Surveys & SPM Framework

This project is a continuation of the initial PayGoSol foundation that was led by 2014 GSOC intern, Antonio Carella.

  1. Create a pre-paid account mechanism as an account type or account option in Mifos (perhaps extending existing classes), zero fees.
  2. Create a new API for consuming pre-paid account balances.  
  3. Create a simple external model that mimics consumption by a household on a daily basis - imagined as a set of data received from solar panel (watts used, time of day, volts present).  
  4. Load up pre-paid account by account transfer in P2P interface (my phone to your account) or via trusted agent - i.e. trusted agent receives cash and loads account on Mifos.

Work in 2015 will include adding the following features to make it an out-of-the-box solution that any PAYG hardware provider could use:

  • Hardware Integration
    • Integration with SMS "kill signal" (sms outbound) 
    • Integration with unique "enabler code" for keycode entry and SMS outbound 
    • Per time period Charge and Pay per Kwh options (via control panel) 
  • Web App & Android Client
    • Better UIX and UI work 
  • Platform Work
    • Componentized PGS server (with Mifos X as dependent jar)

Mifos Android Client on MifosX

Mentors
Overview & Objectives

Pay-as-you-go mobile phones have revolutionized access to telecom, the same can be done with solar energy access. Off-grid installations of PVC panels and batteries can be pared with a mobile payment mechanism to allow clients to purchase power "as they use it". This functionality will allow organizations to become involved with 3rd party providers of solar systems.

Description
Helpful Skills SQL, Java, Javascript, Git, Web Services
Impact

Providers of pay-as-you-go solar can use MIFOS for their operations. MFIs can become such providers.

Other Resources

Extend Surveys & SPM Framework

We have the back-end in place for a surveys/social performance management framework that allows the import of XMLs for the PPI (progress out of poverty index) SPM scorecard. We need to implement a front-end UI for viewing and recording PPI surveys as well as a UI in which to create new surveys from scratch (similar to Question Groups in an older version of software).

1) Build out the UI for creating survey from available PPI scorecard
2) Capture/record surveys from a given entity in the web app
3) View recorded surveys from the web ap
4) Interface to create new surveys from scratch via the UI

See Resources below for specs/wireframes.

See
Mentors
Overview & Objectives

Financial Inclusion providers need a comprehensive view into the overall livelihood of their client both for better risk analysis, credit scoring, as well as social performance management.

Description
Helpful SkillsHTML, Spring, Hibernate, REST, Java, AngularJS, SQL  
Impact

Ability to measure social impact and have one single point of information on a client within the platform.

Other Resources

Financial Inclusion providers need a comprehensive view into the overall livelihood of their client both for better risk analysis, credit scoring, as well as social performance management.

Description

We have the back-end in place for a surveys/social performance management framework that allows the import of XMLs for the PPI (progress out of poverty index) SPM scorecard. We need to implement a front-end UI for viewing and recording PPI surveys as well as a UI in which to create new surveys from scratch (similar to Question Groups in an older version of software).


1) Build out the UI for creating survey from available PPI scorecard
2) Capture/record surveys from a given entity in the web app
3) View recorded surveys from the web ap
4) Interface to create new surveys from scratch via the UI

See Resources below for specs/wireframes.

Helpful SkillsHTML, Spring, Hibernate, REST, Java, AngularJS, SQL  
Impact

Ability to measure social impact and have one single point of information on a client within the platform.

Other Resources

Extend Mifos Data Import Tool

 Integration of Egalite Agent Banking App 

...

...

Agent Banking has become a key new delivery channel to increase reach, lower cost, and broaden the depth of services available. We will be taking over the Egalite codebase that's being donated to the Mifos Initiative by BFSI Consulting - it's a fully functional Android-based app for agents that works with any core banking system. This project would involved extending the application so it fully integrates with and works on top of the Mifos X platform

...

The current codebase is stand-alone and can integrate with any core banking system. This project will involve converting it to work on top of Mifos X by leveraging the Mifos X APIs for all functionalities that exist in Mifos X and adding in APIs for the functionalities that aren't present in Mifos X but in Egalite. The project will consist of the following:

1) Integrate the existing web service into Mifos X
2) Extend the webservice to use Mifos related data
3) Modernize the front end by using Material design

...

By enabling branchless banking, the costs of serving the poor are dramatically lowered, outreach can be extended to rural offerings, and brand new products and services that are more relevant can be delivered.

...

 Self-Service - USSD App Development

...

...

This has a dependency on the Self-Service backend API's being available 

...

Develop USSD App that allows clients to:

  • Login
  • View Own Accounts (deposits and loans)
  • View Own Accounts' Transactions (deposits and loans)
  • Initiate Transactions from own account (repayments, deposits, transfers)

1. Loans

  • Apply loans
  • Check loan balances
  • View summary of last few transactions

2. Savings

  • Check balance
  • Withdraw (To mobile money
  • Transfer

3. Other Services on the USSD menu

  • Can add the service that is useful to the mifos users/customers

...

Allows a member/client in having a self-service channel allowing them more direct control and visibility into their financial livelihood. Enable members of the society on-demand access to their.financial records even with basic mobile handset

...

 Mobile Money Integration - East Africa (In Progress)

...

...

Mobile money is rapidly transforming financial inclusion by providing more immediate, impactful, affordable, and secure financial services to the client. Mobile money platforms like M-Pesa offer the client unparalleled value in terms of convenience, security and the possibility of new services and products that are more in line with real-world financial habits.  For financial institutions and their clients to fully scale mobile money and leverage its potential, it needs to be fully integrated with their core-banking system.

...

Based on the extent of the APIs available through the various mobile money platforms, the level and seamlessness of integration can vary from real-time to end-of-day file-based integration.  This project would work to provide several file, message, and or API-based reference integrations with leading mobile money platforms, including

  • M-Pesa
    • File-based integration
    • API based integration
  • TigoCash
  • OrangeMoney
  • AirtelMoney

...

Great efficiency, reduced risk for clients, more impactful and relevant products & services.

...

Mobile Money Integration - South Africa

...

...

Mobile money is rapidly transforming financial inclusion by providing more immediate, impactful, affordable, and secure financial services to the client. Mobile money platforms like M-Pesa offer the client unparalleled value in terms of convenience, security and the possibility of new services and products that are more in line with real-world financial habits.  For financial institutions and their clients to fully scale mobile money and leverage its potential, it needs to be fully integrated with their core-banking system.

...

Based on the extent of the APIs available through the various mobile money platforms, the level and seamlessness of integration can vary from real-time to end-of-day file-based integration.  This project would work to provide several file, message, and or API-based reference integrations with leading mobile money platforms, including those from Zimbabwe and/or Zambia

...

Great efficiency, reduced risk for clients, more impactful and relevant products & services.

...

 Mobile Money Integration - West and Central Africa (In Progress)

...

...

Mobile money is rapidly transforming financial inclusion by providing more immediate, impactful, affordable, and secure financial services to the client. Mobile money platforms like Orange Money and MTN Mobile Money offer the client unparalleled value in terms of convenience, security and the possibility of new services and products that are more in line with real-world financial habits.  For financial institutions and their clients to fully scale mobile money and leverage its potential, it needs to be fully integrated with their core-banking system.

Hence integrating Mobile money and Orange money to Mifos X in Central and West Africa will give the MFI an edge over their competitors and assist the client to carry out secured distance transactions. The end product of this project should allow a client to save from his mobile money account to his MifosX account, request or withdraw money from his Mifos X account to his mobile money account using probably a small mobile application to carry out these transactions. The Client self service API will be used in its fullness to accomplish this Tasks. Other APIs could be developed and used if the present Client self service API are not able to this these.

...

Based on the extent of the APIs available through the various mobile money platforms, the level and seamlessness of integration can vary from real-time to end-of-day file-based integration.  This project would work to provide several file, message, and or API-based reference integrations with leading mobile money platforms, including

...

Great efficiency, reduced risk for clients, more impactful and relevant products & services.

...

Outbound and Inbound SMS Integration

...

...

In outbound SMS notification MFI decides when and what information need to be sent to client, but as part of client protection, client has complete rights to request for information about her/his account details(any time any where). Using inbound SMS client can query for her account details such loan amount, status of new loan application, outstanding loan amount.

This topic has traditionally been of interest to end-users, and one thing you could do is start an email thread on our Mifos end-user and developers mailing list, and perhaps on the chat room, to ask for input from others for Inbound SMS requirements, and add that to the Wiki, and then create a project proposal based on what you've learnt.

See https://goo.gl/1LrC9w for additional details on work in scope of Outbound SMS and Indbound SMS modules.

  • Outbound SMS
    • Event-based Messages
    • Reminders Campaigns
  • Inbound SMS
    • Send out information based on short code request from clients.

...

Transparency and client protection.

...

See SMS Integration and Outbound SMS

Client Impact Portal Phase 2

...

...

Microfinance institutions usually work with various external parties, such as funders or investors. Using the data that is available in MifosX we would like to offer those stakeholders a seperate portal showing accurate and high-level information about the institution that would otherwise be reported manually by the institution. This information helps them in their decision making processes, but also enables them to assess the broader impact they are having with their funding.

...

To develop a portal that aggregates information from different Mifos X deployments and report on predefined social and operational metrics

Objectives:

  • Implement back-end logic in MifosX required to make information available to the client impact portal
  • Implement UI and back-end logic of the Client impact portal

...

2014 GSOC Client Impact Portal Project

Vision for Generic SPM Framework for Mifos X (PPI)

Background on Client Impact Portal

Credit Bureau Integration Phase 2 

...

...

Because of regulatory reasons or to do background check of a client (risk management), MFIs depend on credit bureaus. As part of it, MFI must submit client details to credit bureau and also need to pull client information from credit bureau before approving any new loans to a client.Mifos X can be integrated with a popular CBs in India and from other regions (based on the demand).

...

During the 2016 Google Summer of Code, Nikhil Pawar, completed the credit bureau integration module with integrations for the major credit bureaus in India. This project will continue extending the functionality of the module and work on integrations with the major credit bureaus in Latin America and Sub-Saharan Africa.

The major functionality will be sending the data to CBs on regular intervals in the format CB expects. And option to pull the client’s information from CB whenever loan officer/branch manager/ user wants to view the information for a particular client.

...

The credit report shows account information such as repayment record, defaults, type of loan, amount of loan, etc. of the customer. This information facilitates prudent decision-making when the credit underwriter processes the loan application. This help MFI to reduce the risk of bad loans and reduces the multiple lendings to same person from different MFIs.

...

Clean Energy Integration

...

...

MFIs are interested in becoming a channel for clean energy products - such as solar home systems, water purifiers, or improved cookstoves. With international partners like barefoot power, dlight, or MicroEnergy Credits, or local partners like Grameen Greenway or HUL, MFIs need a way to take orders and hand off data to appropriate partners for order-fulfillment, warranty management, and after-sales service. Integrating a single customer view including their financing of specific clean energy products.

...

  1. Build a module that extends loan product definition to include specific physical product ordering - e.g. a clean energy loan associated with a specific solar product. Create a daily batch process to send data in JSON or XML to appropriate third party system (e.g. MEC Tracker). Extend this to include "down payments" on the product purchase - i.e. only partially financed.
  2. Build a supplier ordering/invoice & financial reconciliation process and transfer funds directly to "Supplier Account" upon fulfillment of order.
  3. Create reports on aging of orders, fulfillment timing, and geographic spread.

...

MFIs become more capable of integrating with third party systems for management of deliveries, after-sales service, and carbon tracking.

...

Mifos Based Social Enterprise

...

...

As financial inclusion evolves, complexity too, we will build an enterprise social driven platform which increases communication with focus on business and control on small but complex automation of tasks.

...

We have a complete specification in place and need a team to build out a new module on top of the platform that will driven by the concepts of social parameters like instant chat and message based data movement and total UI overhaul

...

Clients and Small Businesses are able to interact in a manner without making it complex.

...

ETL-Based Data Migration Tool for Loan Performer to Mifos X

...

...

Data migration can be one of the most challenging and time-consuming phases of an implementation of a core banking system. It's often a barrier to financial institutions moving on to new and better more modern systems. It's critical to cleanly migrate over the historical data of a client and their transactions. Often the legacy system data needs to be cleaned up and transformed before it can be migrated into Mifos X and is one of the most costly and time-consuming phases of a deployment. We have an existing data migration tool for migrating from Mifos 2 to Mifos X that utilizes the Pentaho Kettle ETL tool.

This project would extend the existing Mifos 2 to Mifos X Kettle-based migration tool to provide a standard migration tool from Loan Performer - a low-cost, widely adopted system in use by hundreds of microfinance institutions throughout Africa and Latin America. It would provide one standard tool that any partner or financial institution could use for migrating from that specific system - it wouldn't require new tools to be made each time a migration is done.

...

Extend the existing Kettle-based Mifos to Mifos X migration tool

  • Write ETL scripts to get data and transform data it from Mambu format to Mifos format

...

It has many impacts

  1. This drastically reduces the time to set up of initial configuration/data of Mifos X for organization adopting this system as MIS.
  2. It widely opens the market that Mifos X is applicable for as it lessens the burden of converting from Loan Performer - a system that is widely used but not as modern and sophisticated as Mifos X.
  3. It dramatically lowers the cost of implementing a system like Mifos X by reducing the complexity of the deployment
  4. It increases transparency by ensuring financial institutions using Mifos can retain the full history for their clients.

...

http://nayan.github.io/move-to-mifosx/

https://github.com/openMF/move-to-mifosx

Actionable notifications/alerts/status updates in Mifos X (Update)

...

...

For better usability system needs to have notifications to the logged in user about actions he/she needs to perform in the application.

...

Build near-real time notification system in the web application to notify the user about action she needs to take. For example, if a branch manager is logged in the application and a new loan is created and is pending for approval by her, then the system should notify her about the pending action.

This involves both invoking and triggering these notifications based on actions or activities in the server as well as the extension of the user interface to support the display of the notifications along with the ability of the user to take action upon the notifications.

Notes on the proposed approach to invoking and triggering these notification can be found at: https://goo.gl/SD0HgC

It outlines:

  1. Piggybacking on response header to send notifications
  2. Create a new set of database tables for notifications
  3. Implementing Queuing system like SpringXD for Notifications

...

Two-Factor Authentication

MentorsOverview & Objectives

For better usability system needs to have notifications to the logged in user about actions he/she needs to perform in the application.

Description

Build near-real time notification system in the web application to notify the user about action she needs to take. For example, if a branch manager is logged in the application and a new loan is created and is pending for approval by her, then the system should notify her about the pending action.

This involves both invoking and triggering these notifications based on actions or activities in the server as well as the extension of the user interface to support the display of the notifications along with the ability of the user to take action upon the notifications.

Notes on the proposed approach to invoking and triggering these notification can be found at: https://goo.gl/SD0HgC

It outlines:

  1. Piggybacking on response header to send notifications
  2. Create a new set of database tables for notifications
  3. Implementing Queuing system like SpringXD for Notifications
Helpful SkillsJava, Javascript, CSS, HTML5. Spring , Hibernate, AngularJS and Bootstrap (CSS framework) is a plusImpactBetter usability. Improve the productivity of users and actions will be taken on time.Other ResourcesUsability and Design
Mentors

 Nayan Ambali, Kyriakos Patsias

Overview & Objectives

Data migration can be one of the most challenging and time-consuming phases of an implementation of a core banking system. In 2013, GSOC intern, Avik Ganguly, built our data import tool for generating pre-configured Excel templates to migrate data into Mifos X. In 2014, Diunuge, extended this to other types of information in Mifos X along with integrating it from a stand-alone web app to a core part of the platform. The data import tool is now the foundation for all of our data migration tools.

It has become a critical part of independent and partner-led deployments

This project would continue to extend the data import tool with the following enhancements:

  • Integration into the Platform: Current implementation is stand-alone and user has to install separately from Fineract - has to be deployed, user downloads templates, adds data, uses remote call against Fineract REST API
  • Templates at Office/Staff Level: Currently all download templates try to fetch data for entire organization which becomes problematic when you have larger oganizations (10 branches/10000customers) - templates should be specific to office or given staff
  • Extend functional coverage of data import tool - Data import tool didn't cover all functionalities - want to upload bulk chart of accounts, data tables, etc.o new types of data and APIs that need to be imported, enabling office-level import, and continued integration into the platform.
  • Batch APIs - instead of single thread, make use of executing services and start configured thread - if hundred objects are created - JDBC template - batch APIs- some entities.
Description
  • Import for other types of data not currently supported
  • Integrate into platform
  • Populate date using bulk APIs
  • Enable office-level imports for larger organizations who find it too cumbersome to migrate an entire organizations worth of data at once

Helpful SkillsJava (Spring/JPA/Jersey), SQL , JavaScript , Git, Apache POI
Impact

It has many impacts

  1. This drastically reduces the time to set up of initial configuration/data of Mifos X for organization adopting this system as MIS.
  2. For data entry operator, this feature can be used as bulk creation option (such as import bulk loans, import clients)
  3. These templates can be used as offline store. And once user has internet connectivity can upload these templates with captured data.
Other Resources

2016 Design for Integration of Data Import Tool - https://cwiki.apache.org/confluence/display/FINERACT/

Social+Performance+Management+Framework

These are the legacy docs on the old question group functionality: https://mifosforge.jira.com/wiki/display/MIFOS/Question+Groups+and+PPI
and http://www.flossmanuals.net/mifos-user-manual/how-to-add-a-question-group/

Wireframes

Extend Mifos Data Import Tool

...

 Nayan Ambali, Kyriakos Patsias

...

Data migration can be one of the most challenging and time-consuming phases of an implementation of a core banking system. In 2013, GSOC intern, Avik Ganguly, built our data import tool for generating pre-configured Excel templates to migrate data into Mifos X. In 2014, Diunuge, extended this to other types of information in Mifos X along with integrating it from a stand-alone web app to a core part of the platform. The data import tool is now the foundation for all of our data migration tools.

It has become a critical part of independent and partner-led deployments

This project would continue to extend the data import tool with the following enhancements:

  • Integration into the Platform: Current implementation is stand-alone and user has to install separately from Fineract - has to be deployed, user downloads templates, adds data, uses remote call against Fineract REST API
  • Templates at Office/Staff Level: Currently all download templates try to fetch data for entire organization which becomes problematic when you have larger oganizations (10 branches/10000customers) - templates should be specific to office or given staff
  • Extend functional coverage of data import tool - Data import tool didn't cover all functionalities - want to upload bulk chart of accounts, data tables, etc.o new types of data and APIs that need to be imported, enabling office-level import, and continued integration into the platform.
  • Batch APIs - instead of single thread, make use of executing services and start configured thread - if hundred objects are created - JDBC template - batch APIs- some entities.

...

It has many impacts

  1. This drastically reduces the time to set up of initial configuration/data of Mifos X for organization adopting this system as MIS.
  2. For data entry operator, this feature can be used as bulk creation option (such as import bulk loans, import clients)
  3. These templates can be used as offline store. And once user has internet connectivity can upload these templates with captured data.

...

2016 Design for Integration of Data Import Tool - https://cwiki.apache.org/confluence/display/FINERACT/Bulkdata+Import

GSOC 2013 - Data Import Tool

GSoC 2014 - Data Import/Export feature

Front Desk Service Module / Experience Module

...

...

Before booking a loan the customer needs to require and assess the details of the loan he is enquiring for and there is no way to personally judge it, based on the parameters, Sales staff right now is using different external loan calculator and loan product schemes are not documentated we need a frontend experience service with personal match

...

https://docs.google.com/document/d/18rS0gVWkjQvNdRnNj40uKNl32zuTh-uuzNv161n6YrY/edit?usp=sharing

Front Desk Service Module / Experience Module

Mentors
Overview & Objectives

Before booking a loan the customer needs to require and assess the details of the loan he is enquiring for and there is no way to personally judge it, based on the parameters, Sales staff right now is using different external loan calculator and loan product schemes are not documentated we need a frontend experience service with personal match

DescriptionThe staff or customer should be able to enter thier requirements before applying for the loan , like Loan amount what kind of loan product he is interested in, and based on a questionaire he should be presented a view where loan products are personally matched based on recomendation engine and after setting basic loan parameters customer should be able to get a qoute and then will be transfered to CRM given by Ankit Sharma
Helpful SkillsANDROID UI, Integrating Backend Service,MIFOS X
ImpactStreamlined sales, Staff and Customer Better Interaction
Other Resources

https://docs.google.com/document/d/18rS0gVWkjQvNdRnNj40uKNl32zuTh-uuzNv161n6YrY/edit?usp=sharing

 Integration of Egalite Agent Banking App 

Mentors
Overview & Objectives

Agent Banking has become a key new delivery channel to increase reach, lower cost, and broaden the depth of services available. We will be taking over the Egalite codebase that's being donated to the Mifos Initiative by BFSI Consulting - it's a fully functional Android-based app for agents that works with any core banking system. This project would involved extending the application so it fully integrates with and works on top of the Mifos X platform

Description

The current codebase is stand-alone and can integrate with any core banking system. This project will involve converting it to work on top of Mifos X by leveraging the Mifos X APIs for all functionalities that exist in Mifos X and adding in APIs for the functionalities that aren't present in Mifos X but in Egalite. The project will consist of the following:


1) Integrate the existing web service into Mifos X
2) Extend the webservice to use Mifos related data
3) Modernize the front end by using Material design
Helpful SkillsAndroid, REST, Java
Impact

By enabling branchless banking, the costs of serving the poor are dramatically lowered, outreach can be extended to rural offerings, and brand new products and services that are more relevant can be delivered.

Other Resources

 Self-Service - USSD App Development

Mentors
Overview & Objectives

This has a dependency on the Self-Service backend API's being available 

Description

Develop USSD App that allows clients to:

  • Login
  • View Own Accounts (deposits and loans)
  • View Own Accounts' Transactions (deposits and loans)
  • Initiate Transactions from own account (repayments, deposits, transfers)

1. Loans

  • Apply loans
  • Check loan balances
  • View summary of last few transactions

2. Savings

  • Check balance
  • Withdraw (To mobile money
  • Transfer

3. Other Services on the USSD menu

  • Can add the service that is useful to the mifos users/customers


Helpful SkillsUSSD, Java, SQL, Finite State Machine (FSM)
Impact

Allows a member/client in having a self-service channel allowing them more direct control and visibility into their financial livelihood. Enable members of the society on-demand access to their.financial records even with basic mobile handset

Other Resourceshttp://mycloudcode.com/category/ussd/

 Mobile Money Integration Phase 2 - East Africa 

Mentors
Overview & Objectives

Mobile money is rapidly transforming financial inclusion by providing more immediate, impactful, affordable, and secure financial services to the client. Mobile money platforms like M-Pesa offer the client unparalleled value in terms of convenience, security and the possibility of new services and products that are more in line with real-world financial habits.  For financial institutions and their clients to fully scale mobile money and leverage its potential, it needs to be fully integrated with their core-banking system.

Description

In 2016, GSOC intern Daniel Carlson, built out an initial mobile money integration module which supports capturing in real-time the transactions that occur in the mobile money system via the APIs along with a web interface for initiating transactions to occur via mobile money.

This project would work extend upon this module to continue genericizing it to support the mobile money APis of other countries and to complete the integrations for mobile money systems or aggregators in East Africa from countries such as Kenya, Uganda, Tanzania, Rwanda s M-Pesa, TigoCash, MTN Money, AirtelMoney, Beyonic, etc.

Helpful SkillsWeb Services, Java, SQL , JavaScript , Git
Impact

Great efficiency, reduced risk for clients, more impactful and relevant products & services.

Other Resources

Mobile Money Integration - West and Central Africa 

Mentors
Overview & Objectives

Mobile money is rapidly transforming financial inclusion by providing more immediate, impactful, affordable, and secure financial services to the client. Mobile money platforms like Orange Money and MTN Mobile Money offer the client unparalleled value in terms of convenience, security and the possibility of new services and products that are more in line with real-world financial habits.  For financial institutions and their clients to fully scale mobile money and leverage its potential, it needs to be fully integrated with their core-banking system.

Hence integrating Mobile money and Orange money to Mifos X in Central and West Africa will give the MFI an edge over their competitors and assist the client to carry out secured distance transactions. The end product of this project should allow a client to save from his mobile money account to his MifosX account, request or withdraw money from his Mifos X account to his mobile money account using probably a small mobile application to carry out these transactions. The Client self service API will be used in its fullness to accomplish this Tasks. Other APIs could be developed and used if the present Client self service API are not able to this these.

Description

In 2016, GSOC intern Daniel Carlson, built out an initial mobile money integration module which supports capturing in real-time the transactions that occur in the mobile money system via the APIs along with a web interface for initiating transactions to occur via mobile money.

This project would work extend upon this module to continue genericizing it to support the mobile money APis of other countries and to complete the integrations for mobile money systems or aggregators in West and Central Africa from countries such as Cameroon, Ghana, Nigeria, Gambia, and Sierra Leone.


Helpful SkillsWeb Services, Java, SQL , JavaScript , Git
Impact

Great efficiency, reduced risk for clients, more impactful and relevant products & services.

Other Resources


Client Impact Portal Phase 2

Mentors
Overview & Objectives

Microfinance institutions usually work with various external parties, such as funders or investors. Using the data that is available in MifosX we would like to offer those stakeholders a seperate portal showing accurate and high-level information about the institution that would otherwise be reported manually by the institution. This information helps them in their decision making processes, but also enables them to assess the broader impact they are having with their funding.

Description

To develop a portal that aggregates information from different Mifos X deployments and report on predefined social and operational metrics

Objectives:

  • Implement back-end logic in MifosX required to make information available to the client impact portal
  • Implement UI and back-end logic of the Client impact portal
Helpful Skills SQL, Java, Javascript, Git, Web Services, Scripting (Bash/Perl/Ruby), Regexes & Parsing
ImpactFunders and investors are vital for almost all MFI's, providing them with accurate information on the impact they are making with each of their MFI's is something they highly value and that enables them to assess whether they want to further support the MFI's moving forward to enable growth of the MFI.
Other Resources

2014 GSOC Client Impact Portal Project

Vision for Generic SPM Framework for Mifos X (PPI)

Background on Client Impact Portal

Credit Bureau Integration Phase 2 

Mentors
Overview & Objectives

Because of regulatory reasons or to do background check of a client (risk management), MFIs depend on credit bureaus. As part of it, MFI must submit client details to credit bureau and also need to pull client information from credit bureau before approving any new loans to a client.Mifos X can be integrated with a popular CBs in India and from other regions (based on the demand).

Description

During the 2016 Google Summer of Code, Nikhil Pawar, completed the credit bureau integration module with integrations for the major credit bureaus in India. This project will continue extending the functionality of the module and work on integrations with the major credit bureaus in Latin America and Sub-Saharan Africa.

The major functionality will be sending the data to CBs on regular intervals in the format CB expects. And option to pull the client’s information from CB whenever loan officer/branch manager/ user wants to view the information for a particular client.

Helpful Skills SQL, Java, Javascript, Git, Web Services, Big Data (Hadoop, Hive)
Impact

The credit report shows account information such as repayment record, defaults, type of loan, amount of loan, etc. of the customer. This information facilitates prudent decision-making when the credit underwriter processes the loan application. This help MFI to reduce the risk of bad loans and reduces the multiple lendings to same person from different MFIs.

Other Resources

Detailed requirements https://goo.gl/aZWMZa

Mifos Credit bureau Integration. (Risk calibration Module -RCM)

Source Code: https://github.com/apache/incubator-fineract/pull/215

ETL-Based Data Migration Tool for Loan Performer to Mifos X

Mentors
Overview & Objectives

Data migration can be one of the most challenging and time-consuming phases of an implementation of a core banking system. It's often a barrier to financial institutions moving on to new and better more modern systems. It's critical to cleanly migrate over the historical data of a client and their transactions. Often the legacy system data needs to be cleaned up and transformed before it can be migrated into Mifos X and is one of the most costly and time-consuming phases of a deployment. We have an existing data migration tool for migrating from Mifos 2 to Mifos X that utilizes the Pentaho Kettle ETL tool.

This project would extend the existing Mifos 2 to Mifos X Kettle-based migration tool to provide a standard migration tool from Loan Performer - a low-cost, widely adopted system in use by hundreds of microfinance institutions throughout Africa and Latin America. It would provide one standard tool that any partner or financial institution could use for migrating from that specific system - it wouldn't require new tools to be made each time a migration is done.


Description

Extend the existing Kettle-based Mifos to Mifos X migration tool

  • Write ETL scripts to get data and transform data it from Mambu format to Mifos format
Helpful SkillsJava (Spring/JPA/Jersey), SQL , JavaScript , Git, Pentaho, Kettle,
Impact

It has many impacts

  1. This drastically reduces the time to set up of initial configuration/data of Mifos X for organization adopting this system as MIS.
  2. It widely opens the market that Mifos X is applicable for as it lessens the burden of converting from Loan Performer - a system that is widely used but not as modern and sophisticated as Mifos X.
  3. It dramatically lowers the cost of implementing a system like Mifos X by reducing the complexity of the deployment
  4. It increases transparency by ensuring financial institutions using Mifos can retain the full history for their clients.
Other Resources

http://nayan.github.io/move-to-mifosx/

https://github.com/openMF/move-to-mifosx

Actionable notifications/alerts/status updates in Mifos X (Update)

Mentors
Overview & Objectives

For better usability system needs to have notifications to the logged in user about actions he/she needs to perform in the application.

Description

Build near-real time notification system in the web application to notify the user about action she needs to take. For example, if a branch manager is logged in the application and a new loan is created and is pending for approval by her, then the system should notify her about the pending action.

This involves both invoking and triggering these notifications based on actions or activities in the server as well as the extension of the user interface to support the display of the notifications along with the ability of the user to take action upon the notifications.

Notes on the proposed approach to invoking and triggering these notification can be found at: https://goo.gl/SD0HgC

It outlines:

  1. Piggybacking on response header to send notifications
  2. Create a new set of database tables for notifications
  3. Implementing Queuing system like SpringXD for Notifications
Helpful SkillsJava, Javascript, CSS, HTML5. Spring , Hibernate, AngularJS and Bootstrap (CSS framework) is a plus
ImpactBetter usability. Improve the productivity of users and actions will be taken on time.
Other ResourcesUsability and Design

Two-Factor Authentication

Mentors
Overview & Objectives

The Mifos X platform is a cloud-based core banking system for delivering financial services to the poor. We provide a web and mobile interface, our AngularJS Web App and Android Field Officer App for the staff of a financial institution to manage their portfolio and service their clients. The security of their client’s financial data is paramount so we would like to add 2FA as another additional layer of security to the platform when staff are logging in via these apps. The most commons means of accessing Mifos X is via the Community App but we have a need for 2FA for the Android client as well.

The generation and sending of the verification code/one-time password will primarily be via SMS and/or email since that is the most user-friendly and most accessible given the equipment available to staff using Mifos X. However, we should aim to support configurability of other authentication methods via an app or virtual authentication device to generate the verification codes.

Description
  1. Stabilize the existing SMS integration in Mifos X

  2. Generate and store Verification Code/One-Time-Password (OTP) at Mifos

  3. Verification of OTP by Mifos X System

  4. Sending of OTP via SMS and/or Email

  5. Configuration of 2FA by System Administrator

  6. Input of the OTP

  7. OTP Verification and Expiration

    1. Configurability of Length of OTP

      1. Default should be six digits

    2. Configurability of Validity Period of OTP: How long the OTP will stay valid before it expires must be developed

      1. Default of 5 minutes (300 seconds)

    3. Configurability of Length of Remember Me Period: We will we allow an option for recognized devices to be remembered (not requiring 2FA if for a defined period of time)

      1. Default of 15 days

Helpful SkillsJava, Javascript, Spring, JAX-RS, JPA, AngularJS, Android
ImpactIncreased Security
Other Resources

Spec & Workflow - https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=67641984


Basic CRM Functionality - Inquiries/Complaints Module

Mentors
Overview & Objectives

Right now Mifos X contains core client management functionalities including tracking basic demographic information, know your customer information, document management, and survey collection through data tables. As financial institutions serving the poor begin to offer a more in-depth and diverse range of financial inclusion products, the need for more robust client management and in-depth client understanding has grows. Their core system needs to provide more and more CRM-type functionality that complement the portfolio management and financial/social reporting the Mifos X provides.

This project will work to deliver the initial set of customer relationship management functionalities including a module for tracking inquiries, complaints

Description

This module will have a request management functionality. A request can be of 2 types: Complaints and Service Requests. Each request must be against a customer and optionally against an account of the customer. Each request will go through a simple workflow.

Actions that can be performed on a request:

Assign -> will change status to "assigned"

Start Work --> will change status to "in progress"

Close --> will change status to "closed" (with a sub-reason code)

At each step user can enter comments.

The customer summary screen will have a link to view the requests of the customer - along with a summary and current status - with option to click-through to get the complete history of each request.

Helpful Skills
Impact

Deepening the client relationship and ensuring fair, responsible, and transparent financial services to the poor is a core piece of the industry's roadmap for financial inclusion. Providing customers the ability to voice their concerns and feedback about the services they're receiving provides a simple yet powerful tool to protect the client. Empowering the financial institution with the ability to track these inquiries and overall maintain a more holistic relationship tracking entire lifecycle of their clients gives them a much better ability to understand their clients and respond to their needs with appropriately designed services and products.

Other Resources 

JPOS Integration - Point of Sale Cash Out

Mentors
Overview & Objectives

Integrate MifosX with an opensource Point of Sale (POS) called JPOS.

Description

Use case would be to get a debit transaction (cash withdraw from checking account) thru the POS device /local runtime with 2FA.  In India, the ability to get cash out through a point of sale network is provided for under RBI regulations. In production there will likely need to be an intermediate "Merchant Acquisition" or "Payment Processor" in between a single POS and MifosX Instance, but this could be abstracted out as a payment gateway only (primarily data mapping). The implementation target is the ability to do a 2 factor authentication on a POS device running JPOS (emulator ok), input account number (via some simple method), then be able to do a (cash-out) account withdrawal in real time to the MifosX account. Additional use cases would be to implement a transaction for payment for goods. i.e. enter specific goods, then do payment from MifosX account to Merchant Account (probably also in Mifos).

Helpful Skills

Familiarity with API work. Understanding of transactional flows.

Java.

Two-factor authentication - see other project idea .


Impact
Other Resources

https://github.com/jpos/jPOS/

Security Penetration testing

MentorsMark Reynolds
Overview & Objectives

We believe the Mifos X platform is super secure and impenetrable. Your mission, should you choose to accept it, is to prove us wrong, and help close gaps you may find.

Description

Beyond a one time exercise, you should integrate (some of) the tools you've used into our build chain so that, even after you've gone, tools flag up future newly introduced potential vulnerabilities.

Helpful SkillsCandidates applying for this project would ideally have prior experience in penetration testing, and document this in their application.
ImpactRe-assuring the more Entreprise-y type Mifos clients that they can safely bet on Mifos X as an MFI platform.
Other Resources

https://www.owasp.org/index.php/Main_Page

https://code.google.com/p/zaproxy/

http://wapiti.sourceforge.net

Run FindBugs & related tools for some serious static code analysis

http://en.wikipedia.org/wiki/Penetration_test

...

Mentors
Overview & Objectives

Create a POC of a scalable MifosX implementation on OpenShift. Also publish a whitepaper with details of this set up.

Description

Mifos X was built to be cloud ready from the ground up. One of the most popular deployment environments for MifosX has been on Amazon EC2, however due to country specific regulation, many implementors are forced to seek alternative models that can scale as effectively. The aim of this project is two-fold:

  • Propose a scalable deployment model for Mifos on the OpenShift PaaS. Your application should highlight a starting point with some details of your planned deployment architecture, as Mentors would be not giving you step-by-step instructions in this project, just "nudge" you along; you would be expected to learn about how to deploy Mifos yourself and by autonomously using the documentation available and help from the public mailing list and IRC channel, and figure out the details of the Cloud deployment.

  • Propose how the above proposed model could be contributed to Mifos in the form of e.g. ready-to-run "configurations" etc. allowing ANYONE to deploy THE LATEST VERSION of Mifos in the Cloud themselves, and then implement this approach in practice. (Contrast this with a "one-off exercise", e.g. taking the current Mifos X WAR file, and UI, and manually making some changes to it, and then manually deploying that to some Cloud PaaS - this would not be sufficient for this project's expectations.)

  • Implement a Continuous Deployment "Devops" EXAMPLE instance of this scalable blueprint using the latest nightly Mifos build artifacts.

  • Publish a high level whitepaper of the same, which can be used as a reference for local implementors, who would additionally take care of provisioning their own hardware. This documentation should be ideally high-level, and what it described much be automated; only providing lengthy step-by-step manual instructions would not be sufficient for this project's expectations.

To prepare for this project, applying students must demonstrate at least that they have already successfully locally built and ran a Mifos X REST back-end server and UI, populated the database etc. as well as provided a simple pull request proposing some minimal deployment related improvement.

Note that we now believe that a Platform as a Service (PaaS) is a more suitable foundation for this project than a raw Cloud Infrastructure as a Service (IaaS) platform (such as Openstack, offered by public cloud provider such as e.g. Rackspace; or Azure, or raw Amazon EC2). This is because a PaaS, such OpenShift, already come with relevant features such as built-in, managed, supported and monitored HTTP load balancing (e.g. OpenShift comes with HAProxy).

We are aware that OpenShift out-of-the-box currently does not provide supported clustering for the MariaDB/mysql database used by Mifos (there is documentation for un-supported example based on an OpenShift template and suggested descriptions on blog posts, or also this one based on Severalnines.com; similarly one could deploy the commercial Percona XtraDB Cluster product ). However at this point we believe that this would not be required, and that proper configuration on OpenStack of the already existing cache facility (incl. distributed cache invalidation) available in Mifos X will add more value at signficantly less operational complexity.

You may need to develop some minor "adjustments" for Mifos X to work well in a PaaS. For example, writeable directories may be limited, and configuration changes may be needed to pick up allowed data directories from an environment variable configuration (but consider multi node distribution in this cluster setup!). Also a cloud PaaS like OpenShift may not support "always running" instances, and scheduled jobs may have to be configured to be kicked off via an explicit HTTP "wake up" request from a cron job.

While OpenShift should already take care of automatic distribution of Mifos code (WAR) updates among nodes in the cluster, you may also have to consider distributed configuration in a cluster. Normally all Mifos X configuration should reside 100% fully in the database only, and as such this may be a non-issue. If however there are any customized configuration files, then perhaps something like the Spring Cloud project could be of interest to ease distributed configuration management.

We are aware of other PaaS product similar to OpenShift, such as notably Cloud Foundry, or even Heroku (closed source..) but would suggest to use OpenShift.

Helpful SkillsContinous Integration, UNIX, OpenStack, experience with any public cloud (AWS etc) and Percona Server is a plus, plus some minor Java coding required to adapt Mifos code to be able to pick up the database configuration from the OpenStack provided environment variable (and possibly automated Cache configuration tuning on OpenStack).
ImpactImproves deployment options for Mifos. Would be very helpful for specialists in African countries who deal with strict regulatory controls in hosting data outside their region
Other Resources

OpenShift https://www.openshift.com

Old Mifos mailing list posts related to related things, search e.g. "mifos google app engine", and find as this one as well as this one.

...