Project Developer

Satyender Kumar Contact # 360-***-****

Email: *********.*@*****.***

Professional Summary

. An IT professional with 9 years of experience in system and software

analysis, design, development, maintenance including around 5+

years of experience as DB2 DBA.

. Strong background in DB2 Database administration on Mainframes and

Windows

. Proactive maintenance.

. Providing 24 7 DB2 Support for Production.

. Regular backups / Image Copies.

. Performance Tuning using DB2PM

. Weekly/Monthly production staging/migration.

. Worked on updated versions of mainframes version 7, version 8.1 and

version 9.1

. SQL performance Tuning

. Develop and execute appropriate Data Definition Language (DDL) to

support projects.

. Maintaining the databases environments for Production and Test

regions.

. Troubleshooting database problems encountered in normal day to day

running of a production database within stipulated times as defined

SLAs.

. Altering the tables, schedule Backups and REORG's, depending on

their growth, create new databases as required and help users to

design applications.

. Extensively used Utilities like LOAD, UNLOAD and RUNSTATS

. Extensively used Utilities like DSNTIAUL, DSNUPROC for refreshing

the Test Environments

. Automated the process of Creating and Altering database objects

using DB2 scripts

. Designing the database using ERWIN.

. Generating DDL using reverse engineering of ERWIN

. Dropping the databases as per the request.

. Extensively worked on BMC tools.

. Knowledge in DB2 Connect

. Knowledge in DB2 administration on Unix

. Proven leadership, mentoring skills and consistent track record of

building good rapport with customer, end users, team members and

management in a short span of time.

. A follower of continuous learning, knowledge sharing and result

oriented approach to make significant contributions to the top and

bottom line of an organization.

. Good analytical, problem determination, customer interaction and

interpersonal skills.

Skills

Databases : DB2

Hardware : Mainframes

IBM Technology : VS COBOL II, JCL, VSAM, CICS

Operating Systems : MVS, Windows NT/95, Z/OS & DOS.

Tools :BMC tools, CA Platinum Tools R/C Query, DB2PM, ERWIN,

INTERTEST, FILE-AID, CHANGEMAN, STROBE, DB2PM,

ENDEVOR, SPUFI, SDSF and QMF.

Domain Knowledge : Auto Insurance and Life Insurance.

Certifications

IBM Certified Database Administrator DB2 Universal Database V8.1 for Z/OS

Awards

Received outstanding performance award from CSC for the year 2007

Received Certificate of Achievement from CSC.

Received few cash awards from CSC.

Education

M.C.A from Osmania University, Hyderabad, India

Professional Experience

Jan 2009 - Till Date : Working as DB2 DBA for HP, Olympia, WA

July 2008 - Dec 2008 : Worked as a DB2 DBA on Mainframes for Toyota,

Torrance, LA

July 2004 - Feb 2008 : Worked as a DB2 DBA on Mainframes for CSC.

Jan 2001 - Jul 2004: Worked as a Programmer in Vision Technologies,

Hyderabad, India.

Project Profile

Project name : NGTS Conversion

Organization : Saber Corp (EDS)

Date : Jan 2009 to Till Date

Role : DB2 DBA on Z/OS and Windows

Environment : IBM Z/OS 1.7, ISPF 5.7 Mainframe, MVS, JCL, DB2 V8.1, DB2

V9.1, Windows, DB2 on Control Center

Tools: File-Aid

Utilities : IBM Utilities

Project Description: As part of conversion, the Data in a text file which

is extracted from SQL Server is loaded into DB2 on mainframes.

Responsibilities:

. Providing support to application team

. Preparing JCLs to LOAD the data into DB2 on Mainframes

. Performance Tuning (Both Database and SQL tuning)

. Develop and execute appropriate Data Definition Language (DDL) to

support the project

. Creating new Tablespaces and new tables.

. Maintaining the databases environment

. Creating Federated object likes Wrappers, Server Definitions and

Nicknames

. Troubleshooting database problems

Project name : NGTS DB

Organization : Saber Corp (EDS)

Date : Jan 2009 to Till Date

Role : DB2 DBA

Environment : IBM Z/OS 1.7, ISPF 5.7 Mainframe, MVS, JCL, DB2 V8.1, DB2

V9.1, Windows, DB2 on Control Center

Tools: File-Aid

Utilities: IBM Utilities

Project Description: Maintaining the application Data base on Windows and

Mainframes.

Responsibilities:

. Providing support to application team

. Preparing JCLs to LOAD the data into DB2 on Mainframes

. Performance Tuning (Both Database and SQL tuning)

. Develop and execute appropriate Data Definition Language (DDL) to

support the project

. Creating new Tablespaces and new tables.

. Creating new database environments.

. Maintaining the databases environment

. Troubleshooting database problems

Project name : Toyota Service History

Organization : Toyota Motor Sales Inc., Torrance, CA

Date : July 2008 to Dec 2008

Role : DB2 DBA

Environment : IBM Z/OS 1.7, ISPF 5.7 Mainframe, MVS, JCL, DB2 V8.1

Tools: File-Aid, R/C Query, STROBE, CHANGEMAN

Utilities : DSNTIAUL, DSNUPROC

Project Description: Toyota Service History (TSH) is a repository of all

dealer performed maintenance on vehicles. In addition to monitoring vehicle

maintenance it is also used to track associated dollar expenditures by

individuals. TSH is fed short by DMS system which feeds into dealer daily

which in turn feeds TSH.

Responsibilities:

. Providing support to Test applications

. Regular backups / Image Copies.

. Performance Tuning (Both Database and SQL tuning)

. Weekly/Monthly production staging/migration.

. Develop and execute appropriate Data Definition Language (DDL) to

support projects.

. Creating new Tablespaces and new tables.

. Using Changeman to move to Production

. Maintaining the databases environments for Production and Test

regions.

. Troubleshooting database problems

Project name : DNB - New York

Organization : COMPUTER SCIENCES CORPORATION

Role : DB2 DBA

Environment : IBM Z/OS Mainframe, MVS, JCL, DB2 V9, VSAM, BMC tools,

CA Tools

Project Description: DNB is the world's leading source of commercial

information and insight on businesses. D&B's global commercial database

contains more than 120 million business records. DNB provides customers

with Risk-management solutions, Sales & Marketing Solutions and e-business

solutions

Responsibilities:

. Providing support to both Test applications and Production

applications

. Providing 24 7 DB2 Support for Production.

. Regular backups / Image Copies.

. Performance Tuning (Both Database and SQL tuning)

. Weekly/Monthly production staging/migration.

. Develop and execute appropriate Data Definition Language (DDL) to

support projects.

. Maintaining the databases environments for Production and Test

regions.

. Troubleshooting database problems encountered in normal day to day

running of a production database within stipulated times as defined

SLAs.

. Upgrade mainframes from version 7.0 to 8.0

Project name : Zurich NA - Baltimore

Organization : COMPUTER SCIENCES CORPORATION.

Role : DB2 DBA

Environment : IBM Z/OS Mainframe, MVS, JCL, DB2, VSAM, BMC tools

Project Description: Zurich is a leading commercial property & casualty

insurer in the United States, serving a wide range of small and mid-sized

businesses, large domestic corporate and global multinationals. Zurich

focuses on similar markets in Canada. Zurich is also one of the leading

consumer property & casualty insurers in the United States serving more

than ten million households

Responsibilities:

. Proactive maintenance

. Weekly/Monthly production staging/migration

. Develop and execute appropriate Data Definition Language (DDL) to

support projects

. Maintaining the databases environments for Production and Test

regions

. Troubleshoot database problems encountered in normal day-to-day

running of a Production database

. Monitoring schedule Backups and Reorgs, create new tables as required

and help users to design applications

. Performance tuning, designing and implementing database related

solutions and controlling security

Project name : Zurich NA - Farmers Insurance Group

Organization : COMPUTER SCIENCES CORPORATION

Date: : Aug 2006 to Oct 2006

Role : DB2 DBA

Environment : IBM Z/OS Mainframe, MVS, JCL, DB2, VSAM, IBM Admin

Tools and BMC tools

Project Description: Zurich is a leading commercial property & casualty

insurer in the United States, serving a wide range of small and mid-sized

businesses, large domestic corporate and global multinationals. Zurich

focuses on similar markets in Canada. Zurich is also one of the leading

consumer property & casualty insurers in the United States serving more

than ten million households. The US consumer market is served primarily by

Farmers, the third largest personal lines property & casualty insurance

group in America, Founded in 1928, the Farmers Exchanges and their

subsidiaries, which Zurich manage but do not own, operate in 41 states

through a network of 17,000 exclusive and 1,100 independent agents

Responsibilities:

. Develop and execute appropriate Data Definition Language (DDL) to

support projects

. Maintaining the databases environments for Production and Test

regions

. Taking ownership of problems and troubleshooting issues related to DB2

within stipulated times as defined in the SLA

. Backups and Reorgs, perform Recovery if needed

. create new tables as required and help users to design applications

Project name : IASC Multi-car

Organization : COMPUTER SCIENCES CORPORATION

Role : DB2 DBA

Environment : IBM Z/OS Mainframe, MVS, COBOL, JCL, IBM Admin Tools,

DB2

Project Description: IASC project is an enhancement project for an auto

insurance company. The IASC Project is primarily to enhance the business

functionalities by introducing the multi car concept for Independent agents

in the FEO states of USA. This involves the development of several new

functionalities being added to the application.

Responsibilities:

. Providing support to the application team

. Weekly/Monthly production staging/migration

. Develop and execute appropriate Data Definition Language (DDL) to

support projects

. Maintaining the databases environments for Production and Test

regions

. Troubleshoot database problems encountered in normal day-to-day

running of a Production database

. Monitoring the Schedule Backups and REORGs

. Create new databases as required and help users to design applications

. Performance tuning

Project name : CA - AUTO

Organization : COMPUTER SCIENCES CORPORATION

Role : DB2 DBA

Environment : IBM Z/OS Mainframe, MVS, COBOL, JCL, DB2

Project Description: The CA Auto project was primarily to enhance the

business functionalities for the CA region. This involved the development

of several new functionalities being added to the application.

Responsibilities:

. Support to the application team

. Weekly/Monthly production staging/migration

. Develop and execute appropriate Data Definition Language (DDL) to

support projects

. Maintaining the databases environments for Production and Test

regions

. Troubleshoot database problems encountered in normal day-to-day

running of a Production database

. REORG done to improve the performance

. Performance tuning

Project name : e-Agent Performance Enhancement

Organization : COMPUTER SCIENCES CORPORATION

Role : Mainframe Developer

Environment : IBM Z/OS Mainframe, MVS, COBOL, JCL, DB2

Project Description: e-Agent Performance Enhancement project is an

enhancement project for an auto insurance company. The Project is primarily

to enhance the business functionalities as well making the end user to use

the front end screen thru internet easily. This involves the development of

several new functionalities being added to the application.

Responsibilities:

. Understanding the requirements provided by the clients and

understanding the Business Functionality

. Analysis of the programs which deals with the functionality.

. Preparation of Detail Design document

. Coding.

. Performed DBA activities to Load and Unload the data

. Binding the programs using SPUFI and BMC tools.

. Preparation of Unit Test Plans & Testing

. Defect fixing

Project name : New York Life Insurance (NYL)

Organization : COMPUTER SCIENCES CORPORATION

Role : Mainframe Developer

Environment : IBM Z/OS Mainframe, MVS, COBOL, JCL, DB2

Project Description: The NYL is completely maintenance of NYL insurance.

Responsibilities:

. Understanding the System Investigating Report, which contains the

requirements, and understanding the Business Functionality

. Analysis of the programs which deals with the functionality.

. Preparation of Detail Design document

. Coding.

. Performed DBA activities to Load and Unload the data

. Preparation of Unit Test Plans & Testing

. Defect fixing

Project name : FHIMS (Family Health and Information Monitoring

System)

Organization : VISION Technologies.

Role : Developer

Technology : VB 6.0, SQL, PL/SQL.

Database : Oracle 8i.

Project Description: FHIMS(Family Health and Information Monitoring System)

is based on a decentralized client-server architecture in order to

facilitate independent functioning of all the units of the department;

facilitating information flows from lower units to higher units and vice

versa. Senior officers consolidate information at higher units from time to

time, for analysis and decision-making. Pentium servers are located at the

district head office and the state head office. The grassroots level

operation is done on a Pentium processor client that runs in a Windows

environment, with Oracle as the database. The application is developed on

Microsoft Visual Basic.

Responsibilities:

. Design and Development of software

Project name : Computerization of all District Police Offices.

Organization : VISION Technologies.

Role : Developer

Technology : VB 6.0, Crystal Reports 6.0.

Database : Oracle 8i.

Project Description: This Project deals with Computerization of all

District Police Offices, City Police Offices and Police Stations. This

Project also includes Computerization of DGP Office. It also comprises of

Data Transfer between various levels. Weekly, Monthly and Yearly Crime

reports will be sent to their respective higher level authorities

Responsibilities:

. Performed detailed study of P&L, Budget, Stores and other sections at

DGP office

. Development of SRS (Software Requirements Specifications)

. Development of Flow Diagrams (DFDs)

. Interaction with the client for requirements study

Project name : PROMPT (Problem Recording Monitoring Planning &

Tracking System)

Organization : Vision technologies.

Role : Developer

Technology : Developer/2000(Forms 4.5, Reports 2.5).

Database : Oracle 8i.

Project Description: PROMPT (Problem Recording Monitoring Planning &

Tracking System) is a comprehensive package developed to keep track of

Manpower allocation, Expenses incurred, software related problems

registering of the product. This is being developed to help the management

for better planning, execution and utilization of project resources.

Further it keeps in track the details of problems registered from various

Client locations and subsequently giving the solutions for all these

problems, for this it has an exclusive module for importing the dumps of

problems from various client locations and exporting the solutions for the

subsequent problems.

Responsibilities:

. Development of screens in Developer/2000.

. Development of interfaces for exporting and importing the database.

. Development of reports for back end in inventory module.

. Creation of Oracle Database for Prompt application.

Contact this candidate