Tanvir,

Pls give the following:

Project title:

Introduce the project to the class. Include:
  • main outputs
  • how data will be collected and input
  • users
  • geographical area covered by project
  • how important it is for the client to have the project properly implemented?

Select and write below your documentation areas. Mention the techniques that you will use in each of the FOUR documentation areas to make your documentation effective.

1.Techniques
Tools & techniques

  • Scrum

2.Time and Budget
Tools & techniques

  • Gantt Chart

3.Process
Tools & techniques

  • Building Custom Components
  • Data cleansing and migration
  • Building Interface
  • Unit Testing
  • Integrated testing
  • Pilot Implementation
  • User Acceptance Testing

4.Implementation

Tools & techniques


  • Server:Microsoft Windows Server 2008
  • Client:Microsoft Windows XP SP2
  • Database Server:Microsoft SQL Server 2008
  • Teminos T24(T24) Banking Software



Add tools and techniques you wish to use for each section.

Name: Chowdhury Tanvir Jalil
ID No:092-25-129

Project Title: Implementation of New Core Banking Software
Introduction:
My bank is going to implement a new banking software to enhance it’s banking service. As a IT officer I am involved in this project. In this situation my bank is acting as my client and I am acting as a Software Project Manager. I have chosen to make document of my project in four areas which are Techniques, Time and Budget, Process and lastly Implementation.
Big job!
Output:
o Improved software performance.
o Introduces New Modules. Example: E-commerce, Internet Banking.
o More user Friendly.
o Includes various reports of General Banking. Example: CL and SBS report.
o Rich audit report
o Enhanced User ID and password management module.
Data will be collection method and input : A third party data migration tool will be used for data collection form the old software and exported to the new software automatically as input.
Mind map what data and how various users will use the software.


Ans:




data3.jpg
Mind Map of Data Type



The list users who will use those data is given below:

  • Data code,Branch Information is used by IT division users.
  • General Ledger Data and Account information is used by,Credit,Deposit,Foreign Exchange,Account Opening,Cash and FCAD department users.
  • Remitance data is used by remitance department users.
  • Customer information is user by Account Opening Department users.

User: About 1000 bank employees will use this software.

Geographical area covered by project : This project will cover 45 branches all over Bangladesh.

Importance to the client to have the project properly implemented: It will definitely improve the efficiency of the employees. It will reduce the complexity in banking operation and save time. Finally the bank will generate more profit.




MindMapper_Applications2.jpg
Mind Map of Process




=
Name:Aliullah Bhuiyan shaem.ID:093-25-138
:
Question: If a employee go back from that work(like mid position) what shorts of changes needed in your system?Answerd by :Chowdhury Tanvir Jalil.Id092-25-129
Ans: I will ask my mangement to recruit more experianced and quatified person than the employee who left the project at the mid position so that he could handle situation and cope up with the project very quickly and efficiently.
=


1.Process
Introduction: Upgrading core banking systems is vital to supporting the drivers of sustainable competitive edge. It helps a bank to deliver its strategy to its customer. The benefits will be huge. The banks will be able to meet the growing customer expectations in a seamless manner. They will be able to provide a wide variety of products and personalized customer centric service delivery across multiple channels. There will be a significant improvement in service quality including better customer segmentation.



The steps of implementation process of replacing the existing core banking system with new one are as follows:

    • Initiation
    • Detailed system study
    • Core Team Training
    • Business Process Definition
    • Building Custom Components
    • Infrastucture: Data Center,Hardware and Network installation
    • Data cleansing and migration
    • Building Interface
    • Unit Testing
    • Integrated testing
    • End User training
    • Pilot Implementation
    • Effectivenes review
    • Roll out
    • Mistakes made and lessons learned
    • Results and level of satisfaction
    • Timescale and budget challenges
    • Outcomes and advice based on practical experience

Other Vital processes are given below:
Current System Study
In order to ascertain the finer aspects of my bank’s business, a current system study will be done at the our bank’s site. At the end of the current system study, a detailed document of the gaps needs to be prepared and submitted to us. Objective of current system study is to understand Bank’s existing business practice, Accounting principles, functional requirements arising out of different banking products offered to customers, Audit and Control needs, reporting needs, User expectations, country’s Central Bank regulations etc. The project team comprising of representative from the vendors side as well as the our bank’s side decide on an action plan to address the gaps identified in the process.
Business Process Re-engineering
This process enables the bank to re-look at its age old practices and try to adapt to new methodology in order to bring in efficiencies in the system.
Business Process Definition
The objective of this process is to map the business processes closely to the system. This is where generally the chart of accounts, GL structures etc, product definitions are crystallised.
Data Migration
Data Migration is a very critical activity in the Implementation process. This basically means transferring of the data from the old system to the new system seamlessly with the least possible disruptions in the day-to-day business of the bank. The success or failure of data migration can make the difference between the success and failure of the entire Implementation.
System Integrated Testing
System integration is a systematic approach to build the complete software structure along with the interfaces as specified in the design from unit-tested (modules. While doing system integration testing, tests are conducted to find defects associated with interfacing. The purpose here is to ensure than all modules which may be customised to meet the bank’s requirement work in a complete unison in an integrated scenario. The system testing environment needs the appropriate hardware, system software and any other software to support the integration as in a live environment. The objective is to do the system test on an environment that is as close to the production environment as possible.
UAT
User Acceptance Testing is a functionality test to validate the software product against the requirements specification by testing the entire system. It tries to show discrepancies between a product's attributes and the requirement. Generally the Core team from the bank’s side undertakes User Acceptance testing. This is usually done on the migrated data.
Pilot implementation
This will be done by implementing one branch or identified set of pilot branches and then rollover of branches . The objective of pilot implementation is to have proof of concept for all modules.

Conclusion: Core banking system replacement is by far one of the most important decisions for any bank today, as it is very specific to a bank’s unique business strategy. However, the replacement process is
not as straightforward as it looks. Given the considerably varied views on what defines a core
banking system and also how a successful roadmap.

2.Implementation



Introduction: Implementation phase is the back bone of the software project management job. The success or failure of software project management depends on the how a project manger implement the software. There is no hard and fast rule to implement a software project successfully. In implementation phase a project manger may face an unexpected and new type of problem, then he has act quickly and come up with a new innovative idea to solve that specific problem.



In our bank we have planned to follow the following steps to implement the new core banking software. The steps are given below:

1) Building a project team and assigning project manger and team leaders.
2) Invitation will be send to different software companies to show a presentation on their banking software.
3) Software analysis and comparison by experts.
4) Final software selection.
5) Procurement of servers and hardware.
6) Signing of service level agreement with the software company.
7) Testing the software in the IT division.
8) Training program will be arranged by the software company to train the project team members.
9) Network set up in all 50 branches of my bank.
10) Server and hardware setup in all branches of the bank.
11) Core banking software installation.
12) Data Migration from old software to new software.
13) Error checking of the migrated data by the respective branch’s financial control and appliance department.
14) Error correction of the migrated data by software engineers and project team members.
15) On job training to the branch employees by the project team members.
16) Parallel running of two softwares for one month to check whether the new software is working properly.
17) Executing a day process only in the new software after giving posting of all the daily transactions and discard the old banking software.


Conclusion: The implementation phase may not be always as simple as I have described here.There are high risks in involved in implementing the new software. The new software may not work properly in the live scenario, then the steps may be different. I have highlighted the major steps which I have observed previously and observing in implementing the new software in my bank.



3.Time and Budget

Gantt chart of what ech person will do for implementation step,time required and their cost
Steps of work
Time Duration in Days
Manpower
Cost(Time x Mampower x Rate per day)
Designation
Observing Demo Presentations form different software companies
30







20
30 x 20 x1000=60000
System Analyst ,Chartered accountant, Executives from different department of the Bank
Analyzing and comparing the feature of different softwares and submitting a report to the management

7






20
7x20x1000=14000
System Analyst ,Chartered accountant
Selection of software by the management


2





5
2 x 5 x 3000=30000
Management(Director,MD,DMD)
Testing



15




3
15 x 3 x 600=27000
Tester
Training




15



3
15 x 3 x 600=27000
Network Setup





15


3
15 x 3x 700=31500
Network Engineer
Hardware Setup





15


3
15 x 3 x 600=27000
Hardware Engineer
Data Migration and Core banking Software set up






15

3
15 x 3 x 850=38250
Software Engineer
Error correction and Modification







18
5
18 x 3 x 850=45900
Expertise from different department of the Bank, Software Engineer


Total Cost
=Tk 300650

Table of qualifiaction and experience needed for each type of person needed to implement the software and their rate
Designation
Qualification
Rate (per day) Tk
Management(Director,MD,DMD)
Minimum 30 years of Experience in Banking Sector
3000
Chartered accountant
Minimum 7 years experience in Finance and compliance
1000
Executives from different department of the Bank
Minimum 7 years experience in different departments of the bank
1000
Expertise from different department of the Bank
Graduate in any discipline,Minimum 6 years experience in Banking
850
System Analyst
Minimum 10 years of experience as Core Banking System Analyst
1000
Tester
BSc in CSE ,Minimum 5 years experience in core banking software testing
600
Network Engineer
Bsc in CSE/EEE/ETE/Applied Physics,Minimum 5 years of Experience in WAN set up and troubleshooting with CCNA and CCNP certification
700
Hardware Engineer
BSc in CSE/EEE ,Minimum 5 years of Experience in Hardware set up and troubleshooting with A++ certification
600
Software Engineer
Bsc in CSE ,Minimum 5 years of Experience in core banking software database management and troubleshooting with OCP certification
8500
Trainer
Minimum 7 years of experience in Core Banking Training
600
Specifiation table of each type of hardware to be used and their cost estimation
Hardware Name
Configuration
Number
Cost(Tk)
Dell Server
Dell optiplex 755,Intel® Core 2 Due 2.0 GHz Processor,800 MHz FSB,2MB L2cache,Intel Q 35 Express Chipset, RAM:512MB Dual Channel DDR2, Hard Drives:80GB Serial ATA(7200RPM)CD/DVD Rom Drive,9 USB I/O ports,Integrated Intel GMA 3000 Grahics Utlizing upto256 MB,Drive Bays:2 internal 3.5”,1 external 3.5”,2 external 5.25”,NICCard:Integrated Broadcom 5754 gigabit Ethernet 10/100/1000,
Chasis :H:16.10” W:7.36” D:17.52”,Power:305
2
2 x250000=500000
Router
Cisco 3600,4port
46
46 x100000=4600000
Switch
Cisco Catalyst 2950,2940
92
92x 40000=3680000
Work Stations
Intel(R) Core(TM) 2 DUO CPU,E7500@2.93GHz,2 GB RAM
1000
800 x 50000=4000000
Online UPS
2 KVA with 2 hours back up
47
46 x 50000=2300000
Offline UPS
1KVA with 1 hour back up
1000
800 x 6000=4800000


Total Cost
=Tk19880000

Specifiation table of each type of software to be used and their cost estimation
Software Name
Number of Users
Cost(Tk)
Microsoft Windows Server 2008
1000
1000 x 4000=4000000
Microsoft XP SP2 Windows
1000
1000 x 7500=7500000
Microsoft SQL Server 2008
1000
1000 x 3000=3000000
T24 Banking Software
1000
30000000

Total Cost
Tk=44500000

4.Techniques:

  • Initiation:At first the core banking software system analyst chartered accountants and Top executives will observe demo presentation form different software companies.
· Detailed system study: In order to ascertain the finer aspects of my bank’s business, a current system study will be done at the our bank’s site. At the end of the current system study, a detailed document of the gaps needs to be prepared and submitted to us. Objective of current system study is to understand Bank’s existing business practice, Accounting principles, functional requirements arising out of different banking products offered to customers, Audit and Control needs, reporting needs, User expectations, country’s Central Bank regulations etc. The project team comprising of representative from the vendors side as well as the our bank’s side decide on an action plan to address the gaps identified in the process.
  • Core Team Training: A training session will be arranged by the software company to train the project team members of our bank.
· Business Process Definition: The objective of this process is to map the business processes closely to the system. This is where generally the chart of accounts, GL structures etc, product definitions are crystallized. This will be done by the member of financial and control department of our bank.
  • Testing :Testing will be done by the testers of our bank.At first they set up para meters of the software.Then give dummy posings to different accounts ,open dummy deposit/loan accounts,issue payorder/DD ect.Then they run day end,month end,half year end and year end one by one.Finally they look and verify whether all the reports are accurate.
  • Data Center,Hardware and Network installation:It will be done by hardware and network engineers of our bank by visiting and branches of our bank.
  • Data migration and software installation: Data Migration is a very critical activity in the Implementation process. This basically means transferring of the data from the old system to the new system seamlessly with the least possible disruptions in the day-to-day business of the bank. The success or failure of data migration can make the difference between the success and failure of the entire Implementation. This will be done by the software engineers of our bank. After data migration is completed the core banking software is installed.
  • End User training :It is an on job training which will be given by the trainer of our bank to all employees.
  • Error Detection,Corection and Modification: Error checking of the migrated data will be done by the respective branch’s financial control and appliance department. Error correction of the migrated data by software engineers.

Core banking software installation:

The core bankng prototype is burned to DVD disks and send to branches by courier service:
  1. At first we have to install microsoft windows server 2008.
  2. Then install microsoft SQL server 2008. Migrate data to new database.
  3. Copy the DVD disk to a specific location.
  4. Then run the seup .exe file from the copied installtion folder.
  5. There is a linking file in the folder of the core banking software. We will put the main database name there.Thus the installtion process is completed.We will need sofware engineers from software company and our bank.


  1. Gantt Chart of Harware purchaseand installation,software purchase,installation,testing and UAT approval


Time required(in days)
1 .
Invitation of tender for hardware purchase
2





2.
Invitation of tender for software purchase
2





3.
Analyzing and comparing the price quotation and features of different hardware dealer company and submitting a comparison report to management

7




4.
Analyzing and comparing price quotation and features of different softwares and submitting a comparison report to management

7




5.
Final selection of hardware and software vendor by mangement


5



6.
Testing of the core banking software



15


7.
Installation of software and hardware in 3 branches at a time by hardware and software engineers of our bank




15

8.
UAT approval will be given by branch mangers





30