Custom Solutions, Endless Possibilities for Startups and Enterprises

PNB e-HR

Overview

Country or Region: India

Industry: Banking

Customer Profile

Punjab National Bank RRBs(PNB)

The Organization

Punjab National Bank (PNB) is one of the leading public sector banks in India. It has a large retail-banking network of over 6950 branches and service counters that spreads out into the far-flung and remote areas. It is one of the 500 largest banks in the world, and enjoys a rich history and heritage. Over a hundred and eleven years old, PNB was the first Indian bank to be started solely with Indian capital.
PNB has sponsored five Regional Rural Banks (RRBs) in order to mobilize financial resources from rural/ semi-urban areas and grant loans and advances mostly to small and marginal farmers, agricultural laborers and rural artisans. The area of operation of RRBs is limited to the area as notified by Government of India covering one or more districts in the state. The sponsored five RRB‟s are as under:
  1. Madhya Bihar Gramin Bank, Patna.
  2. Haryana Gramin Bank, Rohtak
  3. Himachal Pradesh Gramin Bank, Mandi.
  4. Punjab Gramin Bank, Kapurthala.
  5. Sarva UP Gramin Bank, Meerut.
Each of the RRB is having their separate banking system but each of the RRB is governed by PNB.
PNB RRB’s have their separate banking System, Banks were providing the manual solution to their HR related activities, which was quite time consuming and was more cumbersome. Payroll management, Leave management, Attendance Management etc. was not so easy to manage manually and later on the complete MIS reports for the same was not available.
They wants automate the HRMS Related activities for proposed RRBs on a single instance for the all RRBs , Also they wants that Master Data for ALL RRBs should be same.

One approach is to create separate application server and data base server for each RRBs with the separate web server.

Serval drawback in this architecture

  • In each installation have the independent application to each server instance for each RRBs
  • Each server instance has separate settings and each server instance runs in its settings. Costly
  • There are duplication of work for number of times and cause more manpower requirement and changes of human error
Bank people wants the various consolidated data on various attributes and it was very difficult to find the manual system all the manual entry need to be identified after that they find the data and analysis done . E Hr Solution overcome this problem with their Dash boards and MIS Reports
In the manual system for pay the employee salary bank people post the one by one voucher for all the employee it is very time consuming process , E Hr Solution cover come the problem

Business Situation

Bank wants automate the HRMS Related activities for proposed RRBs

They wants a single application server with separate Data base for the all RRBs with their separate banking system which can use by all the employees over the same network.

In the manual system data consolidation is very difficult to the bank people and manual voucher to post for the employee salary for all employee

Solution Process

e-Hr Solution has been designed to generate, manage and look after the Customer requirement, for this business need, we design the solution with following approach.

Approach is to create a single instance of web server in cluster mode, Single instance of application server in High availability mode with the single data base server in clustered mode, There are separate instance of the data base instance created on same DB server as per bank requirement. When the approx. 10,000 employee access to the application, request lands on web server identified the Application server instance and redirect the request appropriate instance of the application

The advantage of a single instance is that

  • It uses less resource to server the same requests as multiple instances
  • quite simplified and easily manageable
  • Reduced hardware cost
  • Reduced resource consumption
  • Reduced maintenance
  • Reduced physical space requirement
  • Application is deployed at single place, all instance are linked with same binaries , only configurations are different for each instances
  • HTTP based routing decisions built using rules that examine HTTP request information
  • Management and monitoring of all configuration settings and aggregated runtime statistics through IIS Manager interface
  • Intelligent live request routing

for redirect the request our approach is use to the ARR algorithm. The purpose is to attain optimal resource utilization, maximize request throughput, minimize response time, and avoid server overload

Application Request Routing (ARR) is a proxy-based routing module that uses HTTP headers, server variables, and load balance algorithms to determine how to forward requests to content servers. ARR leverages the URL Rewrite module to incoming requests which comes from RRBs web browser

ARR is able to cache on disk any HTTP traffic that passes through the server. By combining the disk caching capabilities along with a hierarchy of IIS Web servers running ARR

The solution consist of following major parts

  • Private cloud ( Intranet Zone)
  • Internet cloud (Employee using HRMS application through public network)
  • Firewall and routers
  • DMZ (consist of web server in load balance mode)
  • Militarized Zone

2) E Hr uses two key strategic enabling technologies that substantially improve the effectiveness of reporting solutions and enable institutions to achieve better results for senior management and employees

OLAP Technology – providing speed, easy to use and powerful analytics. Data is load with the various data transformation algorithm in the cube for showing the instantly data. Data cleaning is also applied on various attribute like Gender, special category etc., and gender the various MIS Reports for management purpose.

Dashboards – providing intuitive and simple access to key performance indicators, Scorecards, trends and key management information. Various dash boards like No of leaves ,Claim ,Travel etc. pending show on the employee login ,

In the manual system for pay the employee salary bank people post the one by one voucher or give the cheque for all employee it is very time consuming process, to overcome this problem, E Hr Solution offer the text file for region wise, branch wise, Head office wise which is instantly post the salary on the salary accounts, apart from the salary E Hr also post the every claim amount which was approved by the management is post the employee account.

  • Reduce technical complexities related to data
  • Single port enabled
  • Reduce the manual work

Silent Features

Secure System

  1. Application server reside on militarized zone and not accessible from outside.
  2. All the Ports are restricted on firewall except required secured ports

Technologies used

Software development and deployment:

  1. Asp .Net , C#, java script , jQuery
  2. Sql Server
  3. HTML, Bootstrap
  4. SSIS ,SSAS,SSRS
  5. IIS, Application Request Routing, URL Rewrite
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 Used

Option1 : Each RRB has their separate server for Application and DB i.e. 5 App server and 5 DB servers

Option 2: 5 Application instance would run on single APP server and 5 DB instance for each RRB would be created on single DB server