“DCB Bank Innovation Hackathon”
9th - 10th September, 2017
Pranay Likhitkar (18537) of IT Departmentfrom Dronacharya College of Engineering, Gurgaon along with his teammates of team Division - 42 attended 30 hours DCB Bank Innovation Carnival and Fintech hackathon hosted by DCB and Dev Accelarators, at Incuspaze Solutions Private Limited on 9th - 10th September,2017. There were about 25 – 30 Teams working in pairs of 4 to 5 members each.
DCB Innovation Carnival was looking for new innovation in Finance Technology. The main objective of the event was to bring in ideas for future of payments, loans and taxation.
Division 42 team had an idea giving loan and automatic support to customers based on their transactions in the past 12 months through a given set of rules. These transactions will be showcased to make sure that the future goals of the customer are met. These will enable the bank to keep an eye for potential SMEs.
The product works with a Bank’s past 12 month transaction history of a bank and crosschecks eKYC documents of the customer. Once 5W4Hthe raw data in .json format is taken from the client. The data is then converted to .sql. After which file's extension is changed from .json to .sql with the help of a python script then data is sent send the data to our MySQL server. Where once import is completed the same script sends the data to Blobcity where it is visualized for patterns.
The new pattern is observed by taking account to his transaction history in past 12 months. With help of some previous behavior we will be able to give predictions whether the customer will be able to pay back the loan.
For execution following resources were used:
- API: Used Aadhar APIs for eKYC in Sandbox, BHIM API for Payments in Sandbox, Blobcity API for Data visualization.
- Languages: Python, SQL, PHP, JSON, XML.
- Raw Data: For data Restful APIs used.
- Services: Apache 2.4.18 for HTML queries, MySQL 14.14 for Database.
- Frameworks: Blobcity.
- Virtual Machine: Amazon EC2 with Container.
The team had taken help from the mentor Sanket Sarang and Karishma Kunder. They were able to help the team in Visualization. Also Prasanna Lohar the Chief Innovation Officer of DCB Bank had also approached the team for future hackathons.
Students were able to understand Patterns in Big Data and learned to create services and data patterns on VMS and successfully execute them.