PROFESSIONAL SUMMARY

• Seasoned, versatile, highly motivated IT professional with about Eleven 11 years of IT experience. Extensive experience on NATURAL/ADABAS/DB2 RDBMS as Programmer/Analyst working with Entertainment, Manufacturing, Financial, Health care and Insurance clients like DHCS, UCLA Health Care, MetLife Inc, Fidelity Investments and GECFS. Role player in designing, deploy, Support and maintaining large scale Onsite- Offshore modules on Z/OS ADABAS/DB2 . Extensive experience in database installation, ADABAS/DB2 ORACLE database management at On-site client locations. All projects made use of z/OS, ADABAS V8.x, DB2 V7 to V10, ISPF, TSO, CICS, SMP/e, JCL, NATURAL, COBOL, CICS, IBM BMC suite, reporting tools in Multi Tier VLDB environment. IBM Certified Database Administrator.
• Excellent communication and Team Lead skills.
• Extensive Knowledge on SAP basis.

Core Competencies

• Project/Application/ Database Management: Assigned tasks and timely deliveries to various teams to meet end customer requirements design and implement blueprints of service delivery interface.
• Customer Relationship Management: Day to day interactions with On-site clients by being the SPOC for projects directly handled under my supervision.
• People Management: Ensured optimum utilization of resources. Coached and mentored teams to ascertain delivery and develop team member's skills for progression.

TECHNICAL SKILLS

Languages : COBOL, CICS, Natural, JCL, VSAM, SAS, XML.

Databases : DB2, ADABAS, ORACLE, IDMS, SQL2k5.

Tools : Predict, Adabas Online Services, Natural One, Entire X, APAS/Review, TSO/ISPF, SPUFI, Platinum, SMP/e, CA-Insight QMF, File-Aid, ABEND Aid, SDSF, JSCAN/JEM, MQ Series, SQL, BMC suite, Informatica, OEM, Data guard, MS-Office, MS- Project, ERWIN, IBM RDA, OMEGAMON, SQL Server management Studio, Stats-Pack, IBM DB2 Admin suite.

Debugging Tools : Expeditor, InterTest, and Smarttest.

Job Schedulers : Control-M, OPC, CA7.

Operating Systems : MVS, Z/OS, OS/390, Windows, AIX.

PROFESSIONAL EXPERIENCE

Confiidential

Role:

Systems Program Analyst

Responsibilities:

• Strong data analysis and problem solving skills with proficiency in MS Office tools.
• Responsible to attend Concept scoping sessions, Impact matrix walkthroughs as SME for my block and provide signoffs for the same.
• Conduct partnership meetings for Business User Centric applications.
• Active participation in business proposals, budget estimation and work estimation for multiple projects and cost benefit analysis.
• Strong knowledge of Project life cycle, SDLC lifecycle and key performer in Pre and Post implementation activities.
• Analyzing, Coding of NATURAL programs and documenting on existing ADABAS SAF-RACF security profiles setup and installation on the PASRR systems.
• COBOL CICS Front end design and maintenance in Test, Staging and Production region.
• Directly interacted and managed day to day requirements of clients by being the SPOC for projects directly handled under my supervision and coordination between ONSITE OFFSHORE teams.
• To maintain ADABAS/NATURAL applications programs, data structures like Files, FDT's, DDM's, Map's, Modules. Batch programming using Entire-X.
• To maintain NATURAL Security setup.
• To coordinate and test ADABAS and NATURAL upgrades to V824 and V823 respectively. Also plan and coordinate ADABAS DR with OTech. Troubleshooting job abends.
• Schedule Online Reorg for Test, QA and Production databases.
• User management, space and security management.
• To install and maintain ADABAS/NATURAL tools like PREDICT, ADABAS ONLINE SERVICE, NATURAL ONE, REVIEW SQL Gateway in coordination with the Systems Analysts at OTech.
• To cross-train other Team members on ADABAS/NATURAL database maintenance and database tools.
• ORACLE 10g installation and database setup from Public health division to Healthcare Dept.
• To support ORACLE applications on MS-Windows environment, User management and take backup and maintain DB using OEM.
• DB2 database applications ongoing support and managing upgrades to V10 support.
• To assist in migration of ADASBAS to DB2 databases.

Environment:

IBM z/OS, MS-Windows

Tools : Software Ag PREDICT, Adabas Online Services, NATURAL-One, Review, IBM tools, Visual Explain, CA-Tools, Log Master, CICS Expeditor, Entire-X.

Others : ESP scheduler, SQL Gateway, ISPF, DSMON, ERWIN, RACF, TSO, OMEGAMON, Log Analyzer, Data Studio, QMF, MS-Office tools.

Database : ADABAS, Oracle 10g, DB2 V9/10.

Language/ ERPs : SQL, XML, COBOL, SAg-Natural.

Confiidential

Role:

Worked as Application Analysts ADABAS /IDMS and DB2 .

Responsibilities:

• Duties included working as Programmer / DBA / Onsite Coordinator on WB International Television Distribution systems application- Database Design. And Migration, Application ERD Design and Implementation.
• Day to-day Client Interactions and People Management ensuring optimum utilization of resources at Onsite and Off-site.
• Systems support for new ADABAS, DB2 version installation, and amendments, applying maintenance patches, zparms changes, DR tests.
• Application support w.r.t: DCLGEN, EXPLAIN on SQL queries for tuning, Data compression,
• Schedule SQL 2K5 database backup using litespeed backups.
• Maintenance and Space, Security SAF management.
• Maintaining ADABAS FDT's, Files, DDM's in Test, Systest and Production regions.
• ADABAS On-line and Batch utilities using Natural programming and JCLs.
• Schedule Online Reorg for Test, Systest and Production databases.
• Involved in all phases of migration using Process Management tools.
• Coordination with application team for DB requirement gathering.
• Monitoring , Data Replication, Migration and Refresh from Production to Test Environments.
• Checked for Database performance like event monitors, Problem resolution using Snapshots, db2explain, Performance Tuning, Registers, applying DDL's, DASD management.
• Assistance in Resolving Job abends.
• Schedule Online Reorg for Test, Systest and Production databases.
• Handled 24 7 on-call responsibilities on a Weekly basis.

Environment:

IBM DB2 , SAG-ADABAS , IDMS on Z/OS.

Tools : BMC tools, D-PROP Tool, Visual Explain, DB2 Control Center, DMLO , IDD, DMCT commands, IBM RDA-data modeler, ERWIN, Software Ag- Predict , Entire-X, Adabas Online Services, CONNX, NATURAL-ONE.

Others : DPF, ISPF, DSMON, RACFRW, OMEGAMON, IBM Q-replication, LiteSpeed, SQL Server Management Studio Express, NMON, TMON, DBA SAP ECC 6.0.

ZSeries Software: DB2 V9.1, ADABAS v7, Omegamon, ISMF, Netview, Compuware tools,

SMP/E, DB2 Backup System, FRBackup for back up.

pSeries Software: DB2 UDB V9.5 fp1, AIX5.3 TL08 SP4, HADR, SA MP,HACMP.

Third Party tools: Omegamon, Neon, MS-Office tools.

Database : DB2 V8 V9, ADABAS v8.0.4, SQL 2K5, IDMS.

Language : SQL, XML, COBOL, JCL, Natural.

Confiidential

Role:

Working as SAP DB2 / ADABAS systems Programmer

Responsibilities:

• Duties included working as On-Site Program Coordinator/DBA on Large and Very Large DB VLDB applications on DB2 and ADABAS databases.
• Daily, weekly and monthly basis Client and Offshore interactions and coordination activities.
• Transport management for indexes.
• Applying OSS notes for special projects like Unicode migration.
• Archiving Support and administration.
• SAP performance tuning, special parameter settings for BW APO landscapes.
• Opening SAP messages for issues and also opening connections for SAP, IBM PMR's etc.
• Partitioning very large tables - ICNV and also offline partitioning.
• Reorg System enhancements, scheduling drain, partitioned table reorgs.
• DB2 backup system native FRBACKUP utility for backing up SAP systems.
• Executing offline backups of SAP systems and restore system for db refresh.
• Co-ordinate Storage tasks for MOD54 migration, FDRMOVE and FDRRPAS.
• New System builds - prework and refresh related Onsite- Offshore Coordination
• R3trans setup and also troubleshooting connectivity problems.
• Adding and re-balancing table space containers and auto-resize on tablespaces.
• Extending file systems, working with storage to add disks to volume groups.
• Restoring system to backup sync points for test systems on weekly basis.
• Check on IBM License Management Tool Installation.
• Taking special backups and also scheduling special backups.

Environment:

IBM DB2 v9, v10 , AG-ADABAS V8 on Z/OS v9.7 AIX 6.1.6.

SAP : SAP ECC 6.0.

ZSeries Software: DB2 V9.1, Omegamon, Natural -1, SYSAOS, PREDICT, APAS, BMC products CAT manager Mainview, ISMF, Active Datasharing, Netview, SMP/E, DB2 Backup System, FRBackup for back up

DB2 UDB V9.5 fp1, AIX5.3, MS-Project, MS Office.

Third Party tools: Omegamon, Neon.

Confiidential

Role:

Working as DB2 /Oracle - Database Administrator /Programmer.

Responsibilities:

• Duties included working as Analysts on DB2 and ORACLE based Medical systems application- iCAP Image Capturing and Processing system Database Design. And Migration, Application ERD Design and Implementation to include Pure XML.
• Database Design, Modeling, ERD creation, Logical design, Physical design and Implementation, enforcing Database standards, Bufferpool management, DASD Management, support for integrating Database with web applications.
• Application support w.r.t: DCLGEN, EXPLAIN on SQL queries for tuning, Data compression, Plans and Packages Bind and rebind on OLTP and VLDB's, Change Controlling using Endeavor.
• Analysis and Documentation of current SQL stored Procedures on DB2 V9.x and SQL2k.
• Generate and execute System Backup and Restore Services for disaster recovery.
• Forward engineer the Erwin data model into a DDL structured word document and edited the DDL script to include the self-designed tablespace names and indexspace names, indexes, triggers and stored procedures and implemented into the Development, QA and Production environment.
• Reversed engineering from the Database on a periodic basis as per the frequency of the production deployments or changes to keep the Erwin Data Model in Sync with the production. Synchronized 30 above test, Systest to Production Databases.
• Support for ETL applications handling reporting using Informatica for Extracting and Loading into ORACLE databases using Data guard, OEM.
• Schedule Online Reorg for Test, Systest and Production databases.
• Involved in all phases of migration using Process Management tools.
• Coordination with application team for DB requirement gathering and XML coding.
• Data Replication, Migration and Refresh from Production to Test Environments.
• Removing pending status by running DB2 Utilities Load, REORG, REPAIR, Import, IMAGECOPY, RECOVERY, Explain, and Runstats .
• Checked for Database performance like event monitors, Problem resolution using Snapshots, db2explain, Performance Tuning , Registers, applying DDL's, DASD management.
• Resolving Job abends.
• Schedule Online Reorg for Test, Systest and Production databases.
• Handled 24 7 on-call responsibilities on a Weekly basis.
• Query tuning and Package approvals using IBM PA.
• Database Stress testing using Open source tool J-meter.
• Performing Health checks.

Environment:

IBM DB2 ON Z/OS, SuSe 10

DB2 Tools : SPUFI, QMF, BMC tools, Endeavor, Visual Explain, IBM RDA-data modeler. ERWIN, OEM, statspack, data guard, Recovery Expert, and Visual Explain.

Others : COBOLII, TSO/ISPF, DSMON, RACFRW, CLIST, OMEGAMON, DPROP, ABENDAID, DFDSS/ ABARS, VSAM, DB2 Connect, SQL2k, OLTP - CICS , Reporting tools, MS-Office tools .

Database : DB2 V.9.x, ORACLE 9i.

Language : SQL, XML, JCL, COBOL.

Confiidential

Role:

Worked as a Systems DBA/Team Lead /Programmer for Development, Production, and QA environment.

Responsibilities:

• Duties included working as Programmer/DBA on Large and Very Large DB VLDB applications on DB2 and ADABAS databases.
• Handled offshore Systems support for new ADABAS V8.x, NATURAL V4.x installation, amendments, applying maintenance patches, zparms changes, DR tests.
• Participant in QA COBOL II Program Walkthroughs, Efficiency of COBOL Code SQL .
• Involved in all phases of DB2 V8 migration including Process Management activities.
• Data Replication, Migration and Refresh from Production to Test Environments, DB2 to Oracle using Federated Q rep setup.
• Addressed Serviceability such as with enhancements to column types, and lengths, Add, Rotate or Rebalance Partitions dynamically, adding a column to an index, Changing Partitioning and cluster of application tables, Data Partition Secondary Indexes, Faster Recovery with System Level Point In Time Recovery. Improvement to DB2 utilities REORG, CHECK INDEX, LOAD/UNOAD, RUNSTATS, Auto Restart. ADABAS utilities like Unload , Load , FDT setup, Checkpoints usage, ADB utilities etc.
• Process management, Space management and User / SAF Security management.
• Handled 24 7 on-call responsibilities on a Weekly basis.
• Performance tuning in terms of query tuning by capturing the dynamic SQLs from Snapshots using IBM PA, BMC Mainview installation, CA-INSIGHT and OMEGAMON . On LUW AIX applications like event monitors, Problem resolution using Snapshots, db2explain, Performance Tuning used NMON tools.
• Package approvals.
• Creation of Remedy Tickets.
• Performing Health checks.
• Resolving Job abends.
• Good Bufferpool memory management.
• Periodic snapshots on a daily basis and archiving them for maintaining repository kind of environment.
• SDLC Project Methodology approached was used in all cases.
• Modified NATURAL, COBOL programs, and static SQL as needed.
• Developed and enhanced DB2 Store Procedures and UDF's as per to request.
• Provided status to managements on the status, changes, Scheduling issue as it relates to resources.
• Involved in Cost Benefit Analysis.
• Used NATURAL scripting for automated ADALOAD and Unload process and querying Catalog tables.
• Supported the application on data sharing architecture for varied production and test LPARS including Online regions .
• Analyses on migration of DB2 V8 to V9 features and enhancements.

Environment:

IBM MAINFRAMES ON Z/OS, OS/390, LUW

DB2 Tools : SPUFI, QMF, BMC CHANGE MANAGER, Mainview, CATALOG MANAGER, ERWIN, IBM ADMIN Tool for Security, Recovery Expert, Visual Explain, Endeavor.

Others : COBOLII, TSO/ISPF, DSMON, RACFRW, OMEGAMON, ABENDAID, NMON,VSAM, ERWIN, DB2 Connect, OLTP CICS , MS-Office tools.

Database : DB2 V.8.1, ADABAS V8. , ORACLE 10g.

Language : Natural, JCL, SQL.,REXX.

Confiidential

Role:

DBA TEAM LEAD / DA

Role Expertise on:

• Gained functional knowledge on the Loans calculation, Market value calculation at Fund level, Retirement Investments returns calculations etc.

Responsibilities:

• DB2 /ORACLE -DBA support for User and Space Management. COBOL, DB2, JCL, CICS, MQ-series Code development and Modules interlinking, Report analysis using Eztrieve.
• Team Lead role for smooth task allocation and project execution handled the team of 6 members at offshore for 1yr .
• Change control versioning and admin using DB2 Admin and Endeavor.
• Optimize the Existing SQL queries to Improve Performance. Loading Unloading of Tables from Production to Test region, Q-replication via MQ series.
• Binding and Rebinding of the Packages for Testing.
• Creating Storage Groups, Databases, Table spaces Tables for DB2 Objects.
• Running DB2 Utilities like Load, Unload, Re-org, Repair, Rebuild.
• Removing pending status by running DB2 Utilities Load, REORG, REPAIR, IMAGECOPY, RECOVERY , Bufferpool management, LOG Analyser.
• Promotion of the Packages to Production and comparisons using IBM Path Checker.
• Data Import Export and User management for Oracle DB.
• Optimize the Existing SQL queries to Improve Performance.
• SAS Analysis on ORACLE databases.
• Estimation Project Schedule creation.
• Unit testing using SMARTTEST INTERTEST tools as well.
• Updating the technical and Functional documents as required.
• Participating in Review and QC processes.
• Modifications to existing CICS programs.
• Allocate the work to team members.
• Logical Designing For SAS converted Data tables using ERWIN.
• Actively involved in the Technical requirement gathering, test case preparation and coding, testing and document phases of the task.

Environment:

IBM Mainframes on OS/390.

DB2 Tools :SPUFI, QMF, BMC CHANGE MANAGER, CATALOG MANAGER, Recovery Manager, Endeavor, DB2 Log Analyser.

OTHERS :COBOLII, TSO/ISPF, Platinum, Expeditor, SMARTEST, INTERTEST, Q-Replication, File-Aid, MQ-Series, CICS, JCL, SAS, SQL, Control M, IDCAMS, SORT utils, Data pump, Eztrieve, ERWIN

Database : DB2 V.8.1, ORACLE 8i.

Confiidential

Role:

DBA Team member first level support

Responsibilities:

• Data refresh from Production to TEST.
• Granting privilege for test region.
• JCL scheduling in production using CA7 , OPC.
• Analysis of the existing system. Prepare analysis document.
• Ensure all the quality aspects.
• Analysis of programs, copybooks.
• Preparation of Test cases.
• Coding of COBOL/VSAM/IDMS/ADSO/DB2/CICS programs.
• Data Creation using RC Query, RC-Edit tools and comparison of Data in different Testing Regions using Compare tool.
• Unit testing of components through Expeditor.
• Solved issues raised in various levels of testing.
• Testing documentation of changes.
• QC activity- MCR, UTC Code Review and Unit Testing.
• Status updating.

Environment:

IBM Mainframes on OS/390, AS/400.

Others : COBOLII, TSO/ISPF, Expeditor, File-Aid, CICS, JCL, IDMS, SQL, CA7 tools. Platinum/QMF.

Database : IDMS, DB2, VSAM files.

Confiidential

Role:

Monitoring team member

Responsibilities:

• Level 1 Technical support to corporate clients.
• Trouble shooting to dialup network subscribers, SAP CRM used with Oracle data base for support.
• Oracle 10g Installation support on UNIX/ Windows.
• User Management, Process management.
• Team Monitoring for the resolution to the queries related to corporate services offered by VSNL like International Private Leased Circuit, Virtual Private Network, Web Hosting, Internet Leased Line, and INMARSAT etc.

Environment:

Type : Technical Support

Platform : Oracle Db 9i, UNIX based, SAP

Tools : Stats-pack, CRM, Data pump.

Confiidential

Responsibilities:

• Provided level 1 support to corporate clients.
• Responsible for troubleshooting to Blood diagnostic systems software used with Oracle data base for support.
• Oracle 10g Installation support on UNIX/ Windows.
• User Management and Process Management.
• HIS installation and management.

Environment: Type: Technical Support Platform: Oracle 9i, HIS Maintenance.

Confiidential

Implant Engineer/Team Member

Responsibilities:

• Provided level 1 support to Hospital departments.
• Responsible for troubleshooting diagnostic systems and software used for medical systems across departments.
• Responsible for management/process management on SQL server and on Windows-NT.

Environment: Platform : SQL server, HIS Maintenance.

Confiidential

Trainee Computer associate

Responsibilities:

• Computer operation associate working on Auditing, Editing , Generating new client cases.
• Office Assistant for day to day client services, accounting and Tally services..

Environment: Windows'98, DOS, Tally , Pro-Data m .