Naveen Venkata

518-***-****

abhhxw@r.postjobfree.com

SUMMARY:

1. IBM Certified Database Administrator with 10 Years of specialized

experience on DB2 Mainframe environment.

Experience on the DB2 DBA tools of BMC Software, CA, IBM and Compuware

products.

Performed system administration activities both in OS/390 and z/OS

environment.

Proficient in running utilities like COPY, LOAD, IMPORT, EXPORT, REORG,

RUNSTATS,

REBIND, REORGCHK and Setting constraints.

Provided guidance and assistance to the Application team in terms of

performance tuning

And trouble shooting.

Worked in all tools under CA-Platinum ( RC-Query, RC-Update, RC-Migrate,

Log Analyzer,

Strobe Monitor, Database Detector, RI Manager, Partition Expert,

Recovery Expert, Fast

Load, Fast Unload

Strong knowledge in Database Security Administration.

Strong knowledge in DB2 database logical / physical design, data

migration, Query

Optimization using DB2 Explain tools, performance & tuning of the

DB2 Subsystem and

good understanding of the Oracle database, related utilities and

tools.

Involved in Migration of DB2 version 7 to version 8

Strong experience Database design, Development and data modeling using IBM

DB2.

Expert in BMC DB2 TOOLS (MAINVIEW), CA DB2 Tools, DB2-QMF, IBM DB2I TOOLS,

DB2 SQL, SPUFI, PLATINUM, BIND/REBIND/FREE Package, RACF, IBM

Catalog Systems

Tables, IBM DB2 COMMANDS, IBM UTILITIES.

Excellent Domain knowledge in Healthcare, Automotive and Logistics industry

business

Processes

Expertise in Writing PL/SQL using routines, Procedures, Functions,

Packages, Database

Triggers, Cursors, Views and Creating Database Objects as per the

requirements.

Sound Knowledge of DB2 UDB database features, including Snapshots, lock

monitors,

db2pd, and other db2 utilities.

Experienced using DB2 query profiles.

Excellent experience in Relational Databases (RDBMS) Like Oracle, DB2, SQL

Server,

Teradata, and MS Access.

Excellent knowledge in mainframe (COBOL, REXX, DB2, IMSDB/DC, CICS, VSAM,

JCL,

EZYTRIEVE, JAVA, VB, ASP.NET, SAS and MQ Series) and distributed

technologies

Recognition & Certifications:

. IBM SOA Certification as on FEB 2011

. Oracle SQL Certification program 1Z-051 on Jan 2010

. IBM DB2 UDB Z/OS Database Administrator (IBM DB2 702) on 2009

. IBM DB2 UDB LINUX,UNIX & WINDOWS (IBM DB2 701) on 2009

. IBM DB2 UDB Family Fundamental (IBM DB2 700) on 2008

. IBM DB2 UDB Application Development (IBM DB2 703) on 2008

. Microsoft Certified Application Developer as on FEB 2006

. Microsoft Certified Professional as on 2006

. Best Project Award in Healthcare Domain

. German Language

Achievements:

. Introduced many template spreadsheets and documents which improved the

efficiency of onsite-offshore communication process and slashed error

rate

. Reduced overall CPU and cost by rescheduling/balancing expensive batch

jobs, tuned the SQL's to make use of right indexes.

EDUCATION

Bachelor of Engineering, Madurai kamaraj University, India

TECHNICAL SKILLS:

Languages : SQL, PL/SQL, REXX, COBOL, JCL, UNIX Shell

Script, C#

Tools/Utilities : DB2 Connect, Mainstar, Change Manager,

Main View, SQL*

Loader, TOAD, SPUFI, QMF,

Omegamon, STROBE, TMON,

Platinum,

PL/SQL Developer,

DB2 Utilities, Detector, Syncsort,

Xpeditor,

Fileaid, Panvalet, Changeman, SDSF

Data Modeling : Erwin and Visio 2007

GUI : Command Line, Control Center, Configuration Assistant,

Task Center

Databases : DB2, Oracle, SQL Server, MS

Access, DB2 stored Procedure,

IMS DB

Operating System : Windows XP/2000/2003, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Humana Inc, Louisville, KY

Sep '07-Till Date

PROJECT: Automated Enrollment

DB2 DBA

Description:

Over time, Humana purchased other healthcare companies with high member

volumes. A new system was needed to efficiently manage the data and

incorporate it into the CI (Customer Interface) system. The AE system was

implemented for this data conversion. It was designed to be efficient,

handle a high volume, and also maintain historical data. Customers submit

their enrollment information through multiple channels including tapes,

electronic file transfers, disks, and document scanners.

Roles and Responsibilities:

. Logical and physical database design.

. Altered tables and added check constraints and referential integrity.

. Created and maintained databases, tablespaces, tables, views and

indexes.

. Interact with business team and development teams for incorporating

new functionality.

. Participated in enterprise-wide application and database production

releases.

. Documented plans and procedures in terms of backups, restores and

disaster recovery.

. Data maintenance activities like REORG, RUNSTATS, LOAD, COPY etc..

. Tuning application queries, databases and systems for best

performance.

. DB2 Monitoring using BMC Utilities.

. 24x7 Production support.

. Database Security Administration

. On Call support for the production environment..

. Backup & Restoration of the databases.

. Performance & Tuning of the databases.

. Build Unload and Load utilities jobs, to populate test databases with

production data and using image copy.

. Supporting with Database Partitioning Feature (DPF)

. Query optimization and tuning

. Altering DB Objects.

. Troubleshooting scheduled batch jobs failures in production.

. Code migration, database change management and data management through

the various stages of the development life cycle.

Environment:

DB2V8,TMON,EXPLAIN,STROBE,REXX,PLATINUM,DETECTOR,SPUFI,QMF,JCL,ERWIN

PS Technology Inc Boulder, CO

May'07 - Aug'07

PROJECT: Crew Management and Timekeeping system (CMTS)

Sr. Database Administrator

Description:

PS Technology has developed the product Crew Management and Timekeeping

system (CMTS) which is customized for each client (Railroad Organizations).

This software is implemented for 13 clients out of which 6 are large

installations (UP, NS, CP, CN, CSX, KSC), 5 medium (MNO, NJT, LIRR, MET,

VIA) and 2 small installations (RBC, TRRA). This application will help

clients to manage crew management, dynamic scheduling, and timekeeping and

workforce interaction in one single application.

Roles and Responsibilities:

. On call support for the production environment..

. Database Administration.

. Database Security access

. Creation of new database environment.

. SQL Performance and Tuning, Creating/Altering DB2 Database objects

such as Databases, Tablespaces, Tables, Index, View, etc. Routine work

includes Repartitioning, Backup/Recovery, Load/Unload, Reorg/Runstat,

Bind Plan/Packages, SQL Tuning, and attend performance meeting

. Participated in enterprise-wide application and database production

releases.

. Documented plans and procedures in terms of backups, restores and

disaster recovery.

. Data maintenance activities like REORG, RUNSTATS, LOAD, COPY etc..

. Tuning application queries, databases and systems for best

performance.

. DB2 Monitoring using BMC Utilities.

. 24x7 Production support.

. On Call support for the production environment..

. Supporting with Database Partitioning Feature (DPF)

. Troubleshooting scheduled batch jobs failures in production.

. Code migration, database change management and data management through

the various stages of the development life cycle.

Environment:

DB2V8, Stored Procedure, Strobe, Endevor, JCL, DB2 Utilities, SPUFI, QMF,

Detector, REXX

Cigna Corporation Chattanooga, TN

Jul'06 - Apr'07

PROJECT: PPO Proclaim

DB2 Database Administrator

Description:

PROCLAIM is the sole claim processing system for CIGNA's PPO and

Indemnity products. PROCLAIM allows CIGNA HealthCare to improve customer

and provider services, alleviate internal inconsistencies, and position for

the e-Commerce revolution. The system includes a high degree of automation

in the claim loads and benefit calculation processes, resulting in high

auto-adjudication rates.

Roles and Responsibilities:

.

. Maintaining Logical/Physical data model, Creating DB2 Database objects

such as Databases, Table spaces, Tables, Index, View, etc. Creating

Stored Procedure. Routine work includes using DB2 utilities to

Backup/Recovery, Load/Unload, Reorg, Runstat and Bind Plan/Packages.

Possessing special expertise in SQL Tuning, Application Design/Data

model walk-thru, Trouble shooting, and application performance tuning.

. Responsible for performing object migration between database

environments, (e.g., Development, Test, Production).

. SQL programming and providing guidance to developers on writing

efficient SQL.

. Establish and enforce policies and procedures pertaining to database

security, maintenance, and use.

. Assist the Developers in reengineering the native IO to SQL IO

. Cloning production databases for testing/ stress testing / patch

management/ upgrades etc.

. Troubleshooting application level performance and optimize database/

application performance.

Environment:

DB2 V7.1, OS - Z/OS V1R4 Environment, BMC Tools Suite, JCL, Strobe,

Detector, OMEGAMON

FORD Motor Company, Chennai, India

Aug'05 - Jun'06

PROJECT: Order Edit and Translation Master

DB2 Database Administrator

Description:

Order Edit Translation Master (OETM) application is developed for Marketing

and Sales division of FORD Motor Company. Order Edit Translation Master is

a web and SAP application designed to synchronize product definitions

between Ford, International and Autodata (CTT). OETM is a web-enabled

interface to maintain the mappings between the Ford sales codes and

International Feature codes.

Roles and Responsibilities:

. Administrating, Maintaining and Implementing policies and procedures

for ensuring the availability, security and integrity of the Mainframe

DB2 databases.

. Assist application developers.

. Data Modeling Tool Erwin used for Logical and Physical Database

design.

. Creation of Databases and Database Objects.

. Running the REORGCHK, REORG, AND RUNSTATS utilities.

. Performance Monitoring and Tuning for DB2 databases.

. Developed PL/SQL packages, procedures, functions and database triggers

. Query Optimization using DB2 Explain Tools.

Environment:

DB2 V6.1, OS - OS/390 V2R9, CICS, DB2 Explain Tools, JCL, REXX

Cigna Corporation Hyderabad, India

Jun'04 - Jul'05

PROJECT: EPOCHS & MEMMS, National Systems

DB2 Database Administrator

Description:

CIGNA - Connecticut General Life Insurance Company is one of the largest

healthcare providers in the United States, providing managed, medical,

dental care products, group indemnity health insurance and related

services. CIGNA Health Care (CHC) is the largest line of business within

CIGNA

. Create and Modify Database Objects.

. Provide Production Support (24x7) in ABEND fixing using DBA utilities

and help application teams in problem resolution.

. Recovery of Table spaces using IBM DB2 utilities

. DASD & Storage Analysis for both Production and Test Environment.

. Definition of VSAM DB2 data sets using IDCAM utilities.

. Creation of Storage groups using DASD volumes.

. Performance & Tuning of DB2 Subsystem at System level

. Access provision on Database Objects using Secondary Authorization

ID's.

. Major Conversion process from BMC Utilities jobs to IBM Utilities jobs

has been carried out successfully before the accepted time-frame.

. Usage of BMC DBA tools and OMEGA MON tools in day-to-day operations.

. Build new Image Copy, Reorg (Online & Offline), Runstats, Modify

utilities using DB2 V7.1

Environment

DB2 V7.1, OS - Z/OS V1R4 Environment, BMC Tools Suite, ERWIN, JCL

Guardian Life Insurance Company Chennai, India

Dec'03 - May'04

Junior DB2 DBA

Environment:

DB2 V6.1, OS - OS/390 V2R9, SPUFI, QMF, JCL

Electrical Equipment Inc Chennai, India

Apr'02 - Nov'03

Junior DB2 DBA

Environment:

DB2 V6.1, OS - OS/390, B2 Explain Tools, JCL, REXX

Mileage Collection System Hyderabad, India

May'01 - Mar'02

Application Developer

Environment:

COBOL, DB2, CICS, JCL, VSAM

[pic]

Contact this candidate