SUMMARY:

DB2 and IMS Database Administrator Lead Developer, DBA, Project Manager International and multicultural work experience (USA and France) Architect of several Information Systems from scratch Willing to relocate and travel anywhere US Green Card Holder

PROFESSIONAL EXPERIENCE:

Confidential

DB2 Database Administrator III

Converted all tablespaces to Universal Tablespaces for compatibility with DB2 Z/OS V11 Implemented MQT tables and views to speed performances of Data Warehouse project In charge of all test and Production databases Trained and assisted new DBA’s on DB2 Mainframe Enhanced Platinum and IBM Utilities using Listdef option and Templates Involved in migration to DB2 V11

Tools: DB2 Z/OS V10 and V11, DB2 UDB V9.7, SQL Server 2015, CICS, PlATINUM, JCL, IBM Utilities

Confidential

DB2 Database Administrator

Optimized SQL queries and monitored databases performances of Data warehouse Created and administrated DB2 test and production databases (DB2 and Teradata) In charge of data migration from DB2 to TERADATA Assisted ETL Datastage team on DB2 and Teradata Managed different tasks outsourced to India and other locations

Tools: DB2 UDB V9.7, DB2 Z/OS V9.1, AIX, SQL, UNIX, ETL, MEGA, DATASTAGE, IBM Utilities, TERADATA V14

Confidential, New York

DB2 Senior DBA and Project Leader

In charge of the DBA team Managed all production and test databases on Mainframe and Unix/Aix servers Monitored and improved performance of multidimensional and partitioned Tables for the Data Warehouse project

Performed upgrades of DB2 Z/OS mainframe to V9.1 and DB2 servers to V9.7 Assisted Application Programmers on issues related to DB2, JCL and CICS Set up data replication and federation between different environments via DRDA Performed and implemented DB2 Disaster Recovery technical procedures for IBM mainframe Z/OS Written several Perl scripts to collect data from other agencies Migrated several production databases to other locations Optimized several stored procedures and created clob, xml DB2 objects

Tools: DB2 Z/OS V9.1, DB2 UDB V9.7, Unix/Aix, IBM Utilities, Rational, Cobol, Perl, Confidential, JCL, SQL Server 2008, ITIL, Prince 2, Cobol, CICS, Cognos

Confidential

DB2 and ORACLE System DBA

Installed Oracle 9i OSDI databases (over 150 terabytes) on MVS Mainframe Upgraded and applied different patches Maintenance of Oracle 8i production databases on HP UNIX Creation database Links between Oracle Databases on MVS and Oracle Databases on UNIX Support for developers on MVS and Unix issues Implemented Disaster Recovery of Oracle production databases on IBM mainframe Performed regular DB2 DBA tasks for different projects

Tools: UNIX, ORACLE 8i and 9i, OS390/ZOS, PL/SQL, Precise, IBM utilities, DB2 UDB V7

Confidential, Louisiana

DB2 DBA Lead

Responsible for DB2 administration of all DB2 OS/390 Z/OS Production and test databases

Designed, created, maintained and optimized DB2 databases in 6 subsystems Created several tools in REXX allowing customers to overlay and run all IBM DB2 utilities and commands by themselves in all DB2 OS/390 subsystems Implemented off - site Disaster Recovery In charge of all DB2 Production and test databases Fully re-trained on Oracle 8i DBA for Data warehouse development

Tools: DB2 V7 OS390 Z/OS, DB2 UDB V8.1, CICS, IMS, OS390/ZOS, PLATINUM, SQL, ORACLE 8i, Enterprise Manager, DBArtisan/ TOAD, IBM Utilities, UNIX, WINDOWS NT, ERWIN, REXX / CLIST. Cobol, BMC Mainview/ Bool & Babagge, SCLM

Confidential, South Carolina

IMS DB2 Consultant and Y2K Project manager

Coordinated all BCBS-SC tests related to Y2K (15,000 programs, 15 project leaders ) Created a standard and lawful Test Plan used by all projects Developed Methods to track and report of last results and validated compliant systems Initialized the Testing Environment on the new Y2K mainframe Evaluated and Selected Tools to assist in Testing DB2 objects creation and design (Databases, tablespaces, views, tables..) Creation of packages and plans for programmers Optimization of SQL queries using Explain Set up DL/I Access subprograms to be used by IMS applications Maintained and coded several Cobol IMS,and CICS DB2 programs

Tools: IMS 5.0 DB/DC, DB2 6.0 OS/390, CICS V4.1, OS/390, ENDEVOR 3.7, PLATINUMEXPEDITER 7.0, MS PROJECT, Cobol, DFSMSDSS

Confidential, Florida

IMS and DB2 Database Analyst

Study of Feasibility and System Analysis of “Child Support Enforcement” project Generated DBDs and PSBs of some HDAM and HIDAM databases Added Secondary Indexes to existing IMS databases Normalization JCL Utilities for IMS databases (load, copy, reorgs..) Enhanced and created some DB2 tablespaces Maintained and coded Cobol IMS DB2 programs

Tools: IMS DB/DC, DB2, MVS, PROJECT 4, TELON, ENDEVOR, EXPEDITER. IMS EXPERT, Cobol

Confidential

DB2 / ORACLE Senior DBA

Administration and tuning of all DB2 production databases Responsible for the Reorganizations, Image Copies, loads, DB2 PM and all IBM utilities Administration of RACF security software Implementation of new DB2 releases with SMP/E DB2 PM monitoring Participation in the the design and Implementation of the new architecture systems Generated DDLs to create all Oracle objects (instances, databases, tables, indexes, views..,) In charge of technical support of the department (50 persons) Peoplesoft 7.5 training and implementation (configuration, Peopletools, SQR)

Tools: DB2 MVS, DB2 UDB, REXX, CLIST, DIALOG MANAGER, PLATINUM, SQL, UNIX, ORACLE, PL/SQL, QMF,CLIST, CICS, CANDLE tools, IBM DB2 utilities, Cobol

Confidential

Project Manager

Managed a team of five professional and technical staff Supervised the work of analyst/programmers assigned to the development and maintenance of applications software (Payables and electronic Billing) Quality assurance study (ISO 9000) Project Control and databases administration Maintained and coded many IMS and CICS programs

Tools: VM ESA, CSP,COBOL,PROJECT, IMS DL1, MERISE, UNIX, RACINES, CICS

Confidential

Technical and Global Manager

In charge of the payroll, billing, sales and contact with customers Managed a team of ten professional and technical staff In charge of the recruitment of technical staff and their training in accordance with the market Worked as a Technical advisor on the behalf of different banks and insurance companies

Tools: MVS, DB2, DL1, COBOL, IMS, CICS, PL1, MS PROJECT

Confidential

DB2 Data Base Administrator

Managed a team of fifteen professional and technical staff Technical advice and audit of LESSEPS Securities project Administration and measure performance of DB2 databases Definition and implementation of acceptance and test environments

Tools: MVS, IMS, DB2 MVS, Confidential, COBOL 2, AXIAL, MERISE, PROJECT, ADFSQL,TELON

Confidential

Organization engineer

Participated in the production of user requirements and software requirements in conjunction with the corresponding users about Visa cards Performed the validation, test and control quality of vendors

Tools: CICS, DB2, IMS, MVS, COBOL

Confidential

Project leader

Managed a team of six professional and technical staff In charge of the new project "Formule Club: Consumer group behavior and trends of purchase for Visa Cards Designed a Marketing Database for Data Mining System analysis, implementation and control of all system documentation Performed Data modeling and Databases Design Maintained and coded Cobol MS DB2 and CICS VSAM programs

Tools: CICS, DL1, VSAM, PL1, COBOL, AXIAL, MVS, IMS, DB2

Confidential

Project leader

Management of a team of seven professional and technical staff Project leader of CRM and General Ledger project System analysis, implementation and control Maintained and coded many CICS COBOL VSAM programs

Tools: CICS, VSAM, SQL/DS, COBOL, MERISE, PROJECT, RACINES,VM CMS, DL1

Confidential

DB2 IMS Database administrator

Managed a team of two professional and technical staff In charge of database administration (the Stock Exchange) Participated in DB2 installation and created DB2 sample objects Set up IMSGEN, PSBs, DBDs, ACBs, IBM utilities (reorg, HD unload, HD reload..) Data Modeling and creation HIDAM, HDAM and DEDB databases Written many Cobol programs for developers

Tools: IMS DB/DC, VSAM, COBOL, DB2, DL1, AXIAL, MVS, DB2