PNB e-HR
Overview
Country or Region: India
Industry: Banking
Customer Profile
The Organization
- Madhya Bihar Gramin Bank, Patna.
- Haryana Gramin Bank, Rohtak
- Himachal Pradesh Gramin Bank, Mandi.
- Punjab Gramin Bank, Kapurthala.
- Sarva UP Gramin Bank, Meerut.
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
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.
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
- Application server reside on militarized zone and not accessible from outside.
- All the Ports are restricted on firewall except required secured ports
Technologies used
Software development and deployment:
- Asp .Net , C#, java script , jQuery
- Sql Server
- HTML, Bootstrap
- SSIS ,SSAS,SSRS
- IIS, Application Request Routing, URL Rewrite
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
