N10K



Hi,
This was my Final Year Project for Bachelor of Engineering(Computers). It was an outhouse project for IDBI Intech, the IT arm of the nationalized bank Industrial Development Bank Of India.
Till date , this has been the most complex and informative project I have worked with.

The project completion certificate has been uploaded HERE.

Title:

IMPLEMENTATION OF RBI GUIDELINES ON BASEL 2 (Automated Data Extraction)

Abstract:

As per RBIs direction, compliance with Basel II norms is mandatory for the banks. This paper proposes an IT solution that could be offered by IT companies to help banks, adhere to Basel II norms.

Problem:

Critical Success Factors for the banks are:

But banks find compliance to Basel II norms in the above areas difficult, due to increasing number of customer base of the banks, absence of effective risk management solution and absence of system interfaces between the existing stand alone applications of the banks.

Proposed Solution:

Midsized IT (Information Technology) companies could offer an End to End Risk Management Solution to the banks which will identify measure, mitigate credit risk, market risk and operational risk and also suggest real time capital allocation for each of the above risks. The element of the proposed solution consists of following applications:

Key Benefits: In a Nut Shell:
This is how it looks like!

Data from different sources, are extracted and populated into data repository, which serves as input engine for risk measurement module. The following table represents the details.



There are complex forumlas which are used to measure the varioud types of risks(Market risk, Credit risk, Operational Risk) .

THE UML DIAGRAM FOR THIS PROJECT :

(Only the essential features have been represented. The complexity of the project renders several components beyond the scope of this document)

Activity Diagram:

Component Diagram:

Class Diagram:

Context Level Diagram:

Flow Chart:

Level 0 Data Flow Diagram:

Object Diagram:

Sequence Diagram:

Use Case Diagram:

IMPLEMENTATION DETAILS

The project was very vast and could not have been completed in a short duration of time. Hence, the objective was to complete a small module of the project. The module given to my group was automated data extraction using GUI and this was successfully completed. I was activeley involved in the development phase and testing phase.

FRONT END:

BACK END:

The back end consisted of 2 databases:

A JDBC connection was used to establish a connection with both the databases.

Here is a sample query from the project:

ADDENDUM:

A late requirement by the project leader stated that the project had to be made available via a web browser rather by installing a client on every machine. This predicament was solved by installing a software called Ajax Swing on the server which produced HTML pages on the fly from the jar client.

Do have a look at the link to know more about this wonderful tool.