Project Management

Bhattarai, Sandesh Raj

B. E. (Computer Systems and Networks Hardware)

E-mail: *********@*****.***, *******.*********@*********.***

Mobile: (00977) 985**-*****

Date: 15th August, 2010

Professional Skills:

More than 12 years of experience in the field of application

development.

GUI: Oracle 10g/9i DS, MS Visual Basic 6.0, VB.NET

Database: Oracle 8i, Oracle 9i, Oracle 10g, MS Access, Dbase

Programming Language: PL/SQL, Basic, Dbase, PHP, Java

Working Experiences:

Position: MIS Officer

From Date: 29 January 2008 - to date

Responsibilities:

- Enhancement of Management Information System (MIS)

o Report Development

o Maintenance & Troubleshooting of existing reports

o Performance and Tuning of MIS reports

o Application and Report Server Maintenance

o Analysing requirements.

- Internet Banking: Maintenance and support

- Official web-site (www.nabilbank.com): Maintenance and

support

- Core Banking System (Finacle 7.0.18): Support

- Co-ordination with vendor for new product implementations

Database Oracle 9i/ Oracle 10g

Application Type Client-server/ Web-based

Programming PL/SQL, C#, VB

Language

Development Oracle 9i DS, .NET

Tools

Position: Team Leader (Level 4)

From Date: 15 April 2005 - 28 January, 2008

Responsibilities:

- Visiting client and studying the "As-Is" process.

- Development of the Process Flow Diagram of existing process.

- Suggestion for Policy Reform and Business Process

Reengineering if that is needed for the deployment of

information system to cope with the rapidly changing business

environment.

- Preparation of Data Flow Diagram and documenting the System

Analyst & Gap Analysis document.

- Designing Physical and Logical design of database, E-R

diagram and normalize the database.

- Timely upgrading of database and application as per the needs

of the model whether it is Spiral or Waterfall Model.

- Maintaining the centralized control over the database

development and administration for the software developers.

- Providing technical assistance to the developers for

designing functions, procedures, triggers and other schemas

and objects in the database.

- Involving in the project planning to discuss the project

schedules, milestones and other resource planning.

- Allocating the resources like programmers, developers, QA

experts, and implementation expert in respective phases of

the project deployment.

- Coordinating with the senior level managers and client

regarding the project progress and incorporating the

necessary suggestions for the project execution.

Project Information:

Project Endeavor Human Resource Management System Deployment

Project

Role/ Team Size Technical Team Leader / 20

Database Oracle 10g

Programming PHP, PL/SQL, Java Script, Basic

Language

Development Tool Macromedia Dreamweaver MX, Developer 2000, MS Visual Basic

6

Stake Holder Nepal Investment Bank Limited, Head Office, Durbar Marg

Information Nepal Investment Bank Limited (NIBL) is one of the leading

banking institutions of Nepal with couple of "Bank of the

Year" awards in its account. The bank has purchased the

license of "Endeavor Human Resources" that consists of the

following integrated modules.

(Recruitment Management System, Workforce Management

System, Personnel Information System, Payroll Management

System (Client-server), Training Management System,

Performance Evaluation System, Electronic Attendance

System, Self-service Portal)

Project Endeavor Human Resource Management System Deployment

Project

Role/ Team Size Project Manager/ 6

Database Oracle 9i

Application Type Client-server

Programming PL/SQL

Language

Development Developer 2000

Tools

Stake Holder Sunaulo Parivar Nepal, Dillibazar, Kathmandu

Information Since being established in 1994, Sunaulo Parivar Nepal

(SPN), the Marie Stopes International Partner in Nepal, has

been committed to meeting the reproductive health needs of

women and men in the country. It now operates 47

reproductive health centres across the country, all

providing fully integrated reproductive health care

services, as well as health services for babies and young

children.

The Project at SPN involves the deployment of "Personnel

Information" and "Payroll Management" modules of Endeavor

Human Resources. The organization has around 600 plus

employees scattered across the countries and they are paid

on project basis.

Project Implementation of Various Tailor Made Software Applications

Role/ Team Size Module Team Leader/ 9

Database Oracle 10g

Programming PL/SQL

Language

Development Tool Developer 2000

Stake Holder Government of Nepal, Ministry of Physical Planning and

Information Works, Department of Road, Babarmahal, Kathmandu

Department of Road (DoR) is the authorized government body

of Nepal which is responsible to develop and maintain the

road infrastructure throughout the country.

The project includes development of implementation of

various systems that are integrated with the each other in

order to automate the information system of Department of

Roads. The systems are categorized in two modules a. Core

Systems b. Endeavor Systems.

The "Core System" includes the application systems that are

the primary activities of DoR. The systems under this

module are: - i) Road Network Database Management System

(RNDMS); ii) Program & Budget Management System (PBMS);

iii) Division Activity Recording System (DARS); iv) Road

Related Law Database (RRLD); v) Land Compensation

Management System (LCMS); and vi) Dispute Resolution

Systems.

The "Endeavor Systems" includes the application systems

which are already developed by WorldLink Technologies under

the flagship corporate suite "Endeavor". WorldLink has to

customize the Endeavor Systems in order to fulfill the

requirements of DoR. The systems under this module are:-

i) HR System (Personnel Information System, PIS) ii) HR

System (Payroll Management System, PMS) iii) Financial

Management System (FMS) iv); Procurement Management System

(PrMS); v) Inventory Management System (IMS); vi) Asset

Management System (AMS); vii) Document Management &

Archiving System (DMS) viii) Document Tracking System (DTS)

and ix) Website Development & Intranet Development.

Project Human Resource Management Information System Deployment

Project

Role/ Team Size Software Development Team Leader/ 15

Database Oracle 10g

Programming PL/SQL

Language

Development Tool 10g Developer Suite, Developer 2000

Stake Holder Government of Orissa, India

Information Human Resource Management Information System (HRMIS)

implementation for the Government of Orissa is a part of

Orissa Public Sector Reform Program, supported by

Department for International Development (DFID) and Price

Waterhouse Coopers (PWC). The HRMIS system, customized

version of WorldLink's flagship product Endeavor HR, is a

module of Orissa Treasury Management System (OTMS)

developed by CMC Limited, Kolkata, India. HRMIS system

comprises of three different modules Personnel Information

Module (PIM), Post Management Module (PMM) and Payroll

Management Module (PMM).

Project Endeavor Human Resource Management

(Modules)

Role/ Team Size Team Leader/ 5

Database Oracle 9i

Programming PL/SQL

Language

Development Tool Developer 2000 / PHP

Stake Holder Himalayan Bank Limited, Head Office, Thamel, Kathmandu

Information Himalayan Bank Limited (HBL) is one of the leading banking

institutions of Nepal. WorldLink was awarded the contract

to be the development partner of HBL in HR reformation

process by computerizing all the manual procedures

regarding HRM. WorldLink deployed Endeavor Human Resources

(WorldLink's flagship product) in HBL. The modules deployed

were Personnel Information, Payroll management, Electronic

Attendance Processing System.

Position: Senior Software Engineer (Level 3)

From Date: 14 April 2004 - 14 April 2005

Responsibilities:

- Database Design as per the System Analysis Report

- Designing Application Flow Diagram

- Application Development

- Testing and support

Project Information:

Project Credit Information System, Financial Accounting and Human

Resource System

Role/ Team Size Senior Programmer/ DBA

Database Oracle 8i

Programming PL/SQL

Language

Development Tool Developer 2000, MS Visual Basic 6 (for offline data

capturing)

Stake Holder Credit Information Bureau, Kamaladi, Kathmandu

Information Credit Information Bureau is the independent organization

that was formed from the joint venture of Nepal Rastra Bank

(Central Bank) and Nepal Bankers Association. CIB keeps

track of the detail information about borrower, defaulters

and valuators of all the financial institutions in the

network thereby providing the required information to the

respective institutions. WorldLink has implemented its core

application "Credit Information System" as well as other

modules like "Financial Accounting System", "Inventory

Management System" and "Payroll Management System".

Project Electronic Attendance Processing System Deployment Project

Role/ Team Size Team Leader/ 6

Database Oracle 8i

Development Tool Developer 2000, MS Visual Basic 6 (Device Interface

Application)

Stake Holder Butwal Power Company Limited, Kathmandu, Nepal

Information Butwal Power Company (BPC) Limited is a leading hydropower

developer of Nepal. Butwal Power Company Limited became a

public company since February 1993 (registration No. Pa Li

No. 3 - 49/50). After privatization of the company in 2003

the principal shareholders of BPC are the Private

Shareholders (Shangri-la Energy Limited and Interkraft

Norway) and Ministry of Water Resources, HMG/N. BPC have

procured "Electronic Attendance Processing" system from

WorldLink Technologies Pvt. Ltd. to automate the attendance

processing through Radio Frequency Proximity Reader Card.

Position: Software Engineer

From Date: 16 January 2004 - 14 April 2004

Responsibilities:

- Analyzing the requirements

- Application development

- Testing

Project Information:

Project Personnel Information System, Payroll Management and

Pension Management

Role/ Team Size Sr. Programmer/ 5

Database Oracle 8i

Programming PL/SQL

Language

Development Tool Developer 2000

Stake Holder Government of Nepal, Ministry of General Administration,

Information Harihar Bhawan, Lalitpur

This project has been funded by Asian Development Bank

(ADB) under TA: 3622.

PIS system records information on personnel, monitors and

updates changes and developments in its profile, and

management, and statistical reports. It creates and

maintains a database on personnel information, service,

education, training, medical, leave, award, punishment etc

and provides reliable reports on personnel profile in

support of management planning and decision making.

Project IT Technical Assistant to Nepal Electricity Authority (AEAI

Project Number 2169)

Role Software Consultant

Duration December 2003 - January 2004

Responsibility - Support deployment, system startup troubleshooting, and

initial training of billing staff and transition operation

and maintenance support of the computerized billing system

to permanent NEA staff.

- Support and assist business and system knowledge transfer

to the newly hired staff computer engineers at NEA

About the MIS application enclose overall Management Information

Project: System of NEA comprising different systems such as Personal

Data Bank, Financial Accounting System, Inventory

Management System, Payroll Management System, Computerized

Billing System. Major responsibility in this project was to

analyze the whole managerial system of NEA and develop the

test plans, perform the testing of systems and coordinate

with development groups in order to redesign the MIS

applications.

NEA is the government owned institution in power sector that has been

undertaking the responsibility of generation, transmission and distribution

of power throughout the country. The organization had workforce of around

20 computer engineers who were deployed to develop the in-house software

application, implement the application procured by external vendors and

maintain the billing system of the organization through out the country.

Position: Computer Engineer

Project Information:

Project Customer Accounting and Inventory System (CAIS)

Role Database Administrator

Duration January 2002 - December 2003

Database Oracle 8i

Responsibility - Installation of Windows 2000 Server.

- Implementation in branches.

- Providing Training

- Modification in the source code as per the changing

business process

- Performance Tuning and database administration

- Development of new reports as per the requirement of

management level

About the This System was developed by WorldLink Technologies Pvt.

Project: Ltd. Supplement of CAIS is as a part of Corporate Strategic

movement targeting the reduction of production cost as well

as promotion of good governance through the efficient and

transparent flow of information throughout the

organization. CAIS has been designed as a complete

customized software which keeps track of financial

accounting & store accounting activities of all branches of

NEA thereby providing the concerned level required

information in consolidate / individual form. The

accounting module covers different voucher entries and

MIS/Financial report generation. Whereas the inventory

module covers various store activities and provides the

necessary information for the Supply Chain Management of

the organization.

Project Revenue Accounting and Auditing System (RAAS)

Role/ Team Size Computer Engineer/ 20

Duration June 2002 - December 2003

Database Oracle 8i, MS Access (Old version)

Responsibility - Implementation in branches.

- Providing Training

- Modification in the source code as per the requirement.

- Development of new reports.

- Performance Tuning

About the The RAAS is developed by Computer Interface, Nepal for

Project: Nepal Electricity Authority.

Nepal Electricity Authority had deployed RAAS for the

effective accounting of revenue and its proper auditing.

The Project aimed to create the accuracy in accounting

procedures of revenue which was very essential for overall

planning, budgeting and forecasting of revenue and

expenditure in the organization.

Modules Computerized Billing System (PSICOBS)

Role Computer Engineer

Duration December 2001 - December 2003

Database Dbase IV

Responsibility - Installation of Novell Server

- Implementation in branches.

- Providing Training

- Modification in the source code as per the requirement.

- Development of new reports as per management requirement.

About the The Computerized Billing System, developed by PSI Databank,

Project: India for NEA, is customer centric application which was

designed to keep track of all information of the customer.

It includes consumer registration and consumer care

management to enable the management for the effective and

prompt decision making through the up-to-date information.

The system also helps the policy makers to develop new

policy regarding the revenue, tariff, billing, and further

expansion of services in the countries. Its main features

are Application Processing, Rebate & Penalty calculation,

maintaining Consumer Ledger and Account processing.

Additional - The client side in cash counter had no real-time

responsibilities connectivity with the Server and data was previously

and tasks transferred using a floppy disk to the central server which

aligning with was unreliable. To simplify this process, a module was

the project. developed which migrated all the data to the central server

at the end of the day.

- Developed various supporting utilities for Computerized

Billing System (Dbase IV) such as adjustment of rebate for

minimum consumption, discounts, data migration to the

system etc as per the requirement.

-

IRAD is a consulting company led by a group of architect engineers and

computer engineers which basically focuses on the development of Road

Design and GIS based projects. To facilitate with the core activities of

Road Design and GIS, it has also established a software development unit to

develop the applications related to Road Design and GIS. The company not

only develops such application for itself but also markets such products

for other construction companies.

Position: Software Engineer

Responsibilities:

- System Analysis. Collecting Client's requirement

- Database designing

- Application Development

- Implementation and Support

- Database Tuning

- Providing Training

Project Information:

Project Optimum Road Design Module (ORDM)

Role/ Team Size Asst. Team Leader / 6

Database MS Access, Oracle 7

Programming PL/SQL, Basic

Language

Development Tool MS Visual Basic 6

About the To automate the road design, this application (ORDM) was

Project developed. The road surveyors gather data based on their

daily survey activities. These data are entered into an

excel file which is imported into ORDM after validating it.

The user can insert intersection points (IP), road

templates, wall templates etc on the design. In summary,

user can design, analyze and view the design as well as

estimate the cost through this application.

This product was sold to many road construction companies

in Kathmandu, Nepal.

Project Disaster Information System

Role/ Team Size Project Manager / 4

Database MS Access

Programming PL/SQL, Basic

Language

Development Tool MS Visual Basic 6

Stake Holder Department of Water Induced and Disaster Prevention,

Information Ministry of Water Resources, Pulchowk, Lalitpur

The disaster information system keeps track of Disaster

Information such as the number of persons killed or injured

during a disaster (Storm, landslide, flood, Fire etc), the

loss incurred during the disaster etc. Based on this

information, reports (normal & Graphical Charts) are

generated in Excel.

Project GIS based Mapping System

Role/ Team Size Developer / DBA

Database Dbase III

Programming Dbase III, Basic

Language

Development Tool MS Visual Basic 6, Arc View

Stake Holder Nepal Electricity Authority, Kalimati, Kathmandu

Information The information of the Power station, Grid, Feeder,

Transformer, Pole to consumer's house was traced in the

mapping system. This proved extremely handy to find out the

location of the transformer, pole as well as the location

of consumers for maintenance and meter reading purposes.

The database was designed and a tool for entering data into

the database was also developed. The code for sub-station,

transformer etc. was automatically generated by the tool

itself which was then entered for the object(Pole,

Transformers, Houses etc) in the map (for GIS).

Other completed Projects (Part Time):

Project Drinking Water Treatment Plant Design and Cost Estimation

Role/ Team Size Team Leader / 1

Database MS Access

Responsibility System Analysis

Database Designing

Application Development

Providing Training

Programming Basic

Language

Development Tool MS Visual Basic 6, Autocad

Stake Holder MULTI Software Pvt. Ltd., Pulchowk, Kathmandu for

Information Department of Water Supply and Sewerage, Panipokhari,

Kathmandu

The designed system recommends different types of filters

as well as process for purification of water based on the

laboratory report (Chemical, and Physical contents of water

such as Iron, ph-value, Arsenic, Water color etc). After

the data is entered in the system, one can generate the

cost estimation report which furnishes information on the

cost estimation (for Labors, Materials & Equipments) for

the entire plant design according to the rate entered.

Project Computerized Billing System

Role/ Team Size Team Leader (4)

Responsibility Database Designing

Application Development

Providing Training to the NOC Staffs

Database MS Access

Application Type Client-server

Programming Basic

Language

Development Tool MS Visual Basic 6

Stake Holder Nepal Oil Corporation (NOC), Babarmahal, Kathmandu

Information Nepal Oil Corporation Limited (NOC) is a state owned

trading enterprise to deal with the import, storage and

distribution of various Petroleum Products in the country.

All the processes such as the issuance of Product Delivery

Orders (PDO) till sales of the petroleum products,

transporter's information including vehicle information,

the loss calculation due to temperature, maintaining

dealer's account can be performed by the system. Based on

the information a credit/cash bill is generated by the

system in the Fuel Depot all over the main branches of NOC

in Nepal.

Academic Qualification:

Bachelor in Engineering (Computer Systems and Networks

Hardware)

(Distinction Division)

State Engineering University of Armenia,

Yerevan, Armenia (CIS)

Intermediate in Science (Physics)

(Second Division)

Mahendra Morang Adarsha Multiple Campus, Biratnagar

Morang, Nepal

School Leaving Certificate (Science)

(First Division)

Shri Pashupati Ma. Vi., Lahan

Siraha, Nepal

Training:

1. One week training on 'Data warehouse and Business Intelligence' at

National Institute of Banking Management (NIBM), Pune, India,

2. On the job training on 'Compaq Server and Novell Netware 5 for

System Administrators' at NEA, January 2002.

3. Oracle with Developer 2000, AIT Kathmandu, 2000

4. Visual Basic 5.0, College of Software Engineering, Kathmandu,

Nepal, 1998.

5. Three weeks on the job training on GIS (ARC/ INFO, ARC VIEW) at

IRAD, Kathmandu, 1999

6. One month on the job training on CREDO TER at IRAD, Kathmandu,

Nepal, 1998.

7. One month training on Dbase III+ at Dynamic Computer Institute,

Kathmandu, 1992.

8. One month training on Word Perfect at Dynamic Computer Institute,

Kathmandu, 1992.

9. One month training on Lotus 1-2-3 at Dynamic Computer Institute,

Kathmandu, 1992.

Personnel Details:

Date of Birth: 19 October, 1971

Nationality: Nepali

Marital Status: Married

Member: Nepal Engineering Council, Nepal

Nepal Engineers' Association, Nepal

Languages: English, Hindi and Russian (Written and spoken)

Address: 290/24 Adarsha Marga, Buddhanagar, Katmandu-10,

Nepal

Tel: (00977) - 1- 4782 628 (Res.)

Permanent Address: Madhesha - 9, Sunsari, Nepal.

-End-

WorldLink Technologies Pvt. Ltd., Pulchowk, Lalitpur

Kathmandu, Nepal

Duration: January 16, 2004 to January 28, 2008

Nepal Electricity Authority

Durbar Marga, Kathmandu, Nepal

Duration: December 15, 2001 to December 15, 2003

Integrated Research Application & Development (IRAD),

Dhobighat - 4, Laitpur

Duration: August 11, 1998 to December 15, 2001

Kurve International Inc.

Rockville, MD, USA 20850

Duration: December 15, 2003 to January 15, 2004

NABIL Bank Ltd., Kantipath

Kathmandu, Nepal

Duration: January 29, 2008 to date

Contact this candidate