HPSCB

HPSCB – BancMate Bilingual Core Banking Case Study

Overview : The Organization

Country / Region: India
Industry: Banking

HPSCB has contacted NSCS for providing the support on operational and technical issues. NSCS took over the latest source code available with them. NSCS has studied and understood the application with the help of banks business and technical team. In around 1 Months’ time period NSCS starts delivering the new enhancements along with existing bug fixing. From then NSCS has done following activities
1) Performance tuning for

Interest calculation of term deposit and advances
Interest posting of term deposit and advances
Day-end and Day-open operations
Bulk transaction upload received from DBT and HP Govt. employee salary
MIS and financial report generation

2) New Module development

AML (Anti Money Laundering)
Investment and Borrowings
eKYC
NEFT / RTGS / IMPS Implementation
PMJY, PMSBY and APY
PFMS
Mobile Banking
CIBIL and EXPERIAN DATA
cKYC (Centralized KYC)
Fixed Assets
AEPS

3) Oracle Portal Rollout
Himachal Pradesh has the distinction of having first Coop. Society Registered in India. Cooperative were primarily visualized as specialized agency for financing the credit requirement of rural people in the country particularly agriculture.
The Bank is extending banking facilities in 5 districts viz. KANGRA, KULLU, HAMIRPUR, LAHAUL & SPITI and UNA through our affiliated District Central Co-operative Banks.

Customer Profile

The Himachal Pradesh State Cooperative Bank Limited [HPSCB] is the Apex Bank of H.P state of India.

Business Situation

HPSCB has already implemented the CBS application of HCL. But from Aug. 2014 they have withdrawn their support and bank doesn’t have technical expertise even to support transactional / operational issues on daily basis.

Solution

A. Overall System Optimization Steps

Activity Identification
Java Application Profiling
Thread Dump Analysis
Monitoring Component Behavior
Identification of Contributing and Dependent Components
Query Categorization:
- Frequently executed queries with low execution time
- Occasionally executed queries with high execution time
Root Cause Analysis
Solution Implementation & Comparison with Previous Results

Database Side Changes

Date-wise Table Partitioning (Customer Balances)
Data Re-organization
Index Optimization
Query Optimization
Cache Implementation

Application Side Changes

Batch Processing
Parallel Execution
Case-Based Locking Mechanisms

B. New Developments

1. AML (Anti Money Laundering)

Modular design with support for simple to complex workflows
User-friendly interface with maker-checker system
Integrated KYC module
Comprehensive case management workflow
Predefined rule library (100+ rules)
Automated regulatory reports: CTR, STR, CCR (FIU format)
Customizable alerting system (Daily, Weekly, Monthly)

2. Investment and Borrowing Module

Management of FD, Loans, and Borrowings
Reverse calculation and validation of periodic returns

3. NEFT / RTGS Integration

Batch Application using IBM MQ
Handles inward and outward transactions

4. SMS and Notifications

Business-parameter-based alerts for customer transactions

5. eKYC Module

Customer eKYC via UIDAI
Supports account opening and government benefit access

6. MIS and Reporting

Implemented using SSIS and SSRS
Supports 150+ reports with drill-down capability

Security Implementation

o enhance the security of the core banking application we have implemented the following
SSL
MD5 hashing for sensitive fields like password, checksum generation
Added the HMAC concept for all delivery channels
All biometric are encrypted with session key (AES) and session key is encrypted with public key

Technology Used

HTML / JSP
Java Applets and Servlets
Struts framework
JavaScript, JQuery
Jersey
AJAX
JDK 1.6
Multi-DataSource with Failover/Load-Balancing Features
EJB (Entity ,Session – Stateful and Stateless and Message driven Bean)
JMS (for mail functionality and audit Trail Recording)
ANTS (For Application Deployment)
Log4J (Application logging)
JDBC
Stylepad
MSSQL Server 2008

Technology Stack

Looking for a solid software development partner?