SUMMARY

• Over 20 years of experience in IT industry.
• Worked on various hardware areas including ES9000, IBM 390, IBM 370, RS 6000, AS/400, AIX, Solaris, Unix, HP Unix, Windows 2000 Server, Professional and Millennium edition and software areas including UDBDB2, DB2, Oracle, CICS, UNIX, UNIFY, JAVA, EJB and COBOL.
• Has extensive experience in Data Base Administration, data modeling, analysis, design and development in mainframe and Client Server.
• Has worked as Data Base Administrator, DWA on UDB 6.x, 7.x AND 8.x.
• Has 8 yrs+ experience as UDB DBA, Developer, FDA and DWA.
• More than 4 yrs of Data modeling using ERWIN, Designer 2000.
• 3 Yrs of Mainframe COBOL, DB2 and CICS Developer.
• Has been 6 Yrs on UNIX as Administrator and COBOL developer.
• Experience in all phases of Software Development Life Cycle.
• Acted as consultant to large projects involving debugging of code written in COBOL, COBOL II, DB2, UDBDB2 (LUW), Oracle and Software Installation.

TECHNICAL SKILLS

Hardware: IBM ES9000, IBM 390, IBM 370, AS/400, PDP 1170, Magnum, DEC, HP, RS6000, AIX, Solaris

OS: MVS/ESA,UNIX, LINUX, Solaris 2.x/7/8, HP UX, Windows

Databases: UDB DB2 (LUW) 8.x, 7.x,6.x (EE,EEE,ESE), DB2 Connect, Personal Edition, OLAP Server, Federated Database, Oracle, SYBASE (12.5), SQLSERVER, UNIFY, Access

UDB TOOLS: Control Center, CLP, Script Center, Alert Center, Event Monitors, Snapshot monitor, PM tools, Visual Explain, Visual Warehouse, Essbase Cube, Data ware House Center, DJRA,SPB, Health Manager

Languages: COBOL, COBOLII, MF COBOL, SQL, ESQL, PL/SQL, C++, PRO*C

ETL Tools: Data Junction, Informatica

CASE Tools: Designer 2000, ERWIN, BACHMAN,VISIO, Yurdon, ADW, Studio ER/Studio, Embercadero,DB Artisan, Rapid SQL, WIN SQL and Change Manager

Mainframe Tools: JCL, ISPF, MAX, Infoman, Easytrieve, FileAid, QMF

Oracle Tools: Developer 2000, Forms 4.5/3.0, Reports 2.5/1.1

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Creating performance monitoring tools for DB2UDB 9.0 using PHP.
• Mentoring other DBA’s for SQL writing and migrating DB2 data from version 8 to version 9.
• Created web site using PHP and MYSQL.
• Did production support for web based MYSQL database.
• Converted data from SYBASE, VM VSE to DB2 UDB 9.5
• Set up unidirectional and bi direction Q replication
• Wrote monitoring stored procedures for replication
• Performed performance monitoring for COGNOS
• Set HADR on Redhat Linux for DB2 UDB 9.7
• Wrote SP for settlement of trade and journals.
• Wrote maintenance Procedures for The Db.
• Did the Performance tuning of the SQL and SP for developers.
• Optimized the DB on SOLARIS and WINDOWS.
• Wrote UNIX Scripts to run the SP. USED MTK to convert the SYBASE Procedure to UDBDB2

Environment: UDBDB2 8.2, 8.2.5, 9.0, 9.1, 9.5, 9.7, MYSQL, PHP, XML, Linux, Windows. UDBDB2 ESE 8.2/9.2, Sybase ASE 12.5, AIX, COGNOS, KORN Shell, C Shell, UDB MTK

Confidential

Sr. DBA

Responsibilities:

• Working as a senior DBA for Anti Money Laundering project.
• Supporting 20 Developers for their DB2 Z/OS data conversion to DB2UDB using SAS on 8.x and 7.x.
• Was involved in Physical and logical design of Database 500 GB to 1.2 TB Size. Created databases, table spaces, table’s indexes.
• Set the instance and database parameters for optimizations.
• Ran design advisor and dynamic explains for SQL optimizations. Wrote store procedure, triggers.
• Cronedrunstats and reorg scripts. Took online and offline backups. Restored the data from offline and file system backups.
• Migrated 7.2 to UDB 8.2 ESE. Converted SYBASE store proc using BCp to DB2 EXPORT / LOAD.

Environment: UDB 7.2, 8.1, 8.2 Korn Shell, Perl. SPB, AIX and Solaris

Confidential

DBA

Responsibilities:

• Optimized instance and database parameters. Ran explain, DB2advisor on SQL to create indexes in test, QA and Production.
• AS SAP reports creates SQLS with redundant joins, doesn’t create right inner outer joins, looked through the explain to correct the join criteria, removed redundant joins and columns.
• Took the snapshot of database for applications, created and initialized event monitors for Production, QA and Test.
• Set the different isolation levels for SAP Optimizer, ran SAP explain, used SAP transaction code for data administration and report creation .
• Worked as DBA/Programmer Analyst. Loaded 10 GB of data in TEST, QA and Production.
• Guided the team to write SQL's for loads. Interacted with the client to take requirements for the project.
• Ran explain, did the SQL optimization. Tuned the database as the remote team was running load scripts.
• Helped the team in running shell scripts for UNIX. Wrote stored procedure using SQL language.
• Used Erwin for data modeling. InstalledConfigured, Clustered DB2 on AIX, Windows 2000 and NT Platform.
• Created Schemas, Database, Table Spaces, Tables and Indexes for DB2.Worked with Visual Data warehouse and Stored Procedure.
• Converted data from FoxPro to DB2.
• Replicated data from Oracle, Sybase to UDBDB2.
• Created stored procedure using Visual Basic 6.0.Designed the ETL layers, cleansed and imported the data using DATA JUNCTION.
• Used STAR and SNOW FLAKE schemas and Build Cubes and AST Tables.
• Used OLAP server to build the multidimensional schema. Designed the processes for ETL.
• Used Excel as add in configuration for data mining. Integrated diverse databases. Migrated UDB 6.1 to 7.2.

Environment: UDB 7.1,EEE, EE,LINUX, Autoloader, LOAD, IMPORT, EXPORT, Java 1.2, VB (6.0), ERWIN, SQL STORED PROCEDURES, OLAP, ESSBASE HYPERION, DPROP, Relational Connect, DB2 connect, HA clusters, Replication Center, DJRA, ERWIN, Federated DATABASE, Visual warehouse manger, ER/Studio, DBARTISAN, Rapid SQL, ORACLE, SYSBASE, DATA JUNCTION, WAREHOUSE Control MANAGEMENT, Information CATALOG Manager and Change Manager,Kornabd C shell, Solaris, Windows NT, OS 390( Z/OS)

Confidential

DBA /DEVELOPER

Responsibilities:

• Generated reports using DB2 and QMF.
• Created tables, views, indexes for user using DB2.
• Worked on SQL to improve performance by rewriting them . Read explain and created indexes .
• Tuned SQL statements enforced standards. Gave application support to developers.
• Ensured integrity and provided ongoing monitoring tuning of application database environment.
• Performed backup and recovery procedure. Provided assistance to end user SQL Requests.
• Wrote the detailed program specification for conversion programs, DB2 Batch programs and reports.
• Coded program using DB2, UDB COBOLII and JCL. Converted Approx. 64000 customers to the running and implemented system.
• Wrote customized reports for Confidential and Supplier using Easytrieve.

Environment: IBM 370, Cobol II, AIX, Windows NT, SQL, Windows 95, DB2, MVS,QMF, UDBDB2, CA - Easytrieve Plus, Infoman, MAXEnvironment: MVS/ESA, TSO/ISPF,SPUFI, COBOL II, CICS, DB2, QMF, File aid and MVS/JCL