TECHNICAL SKILLS:

Open Distributed Systems: (AIX, Unix, Windows, Sun, HP, Hadoop/AWS, Solaris & Linux) and the Mainframe (OS/390, zSeries, zLinux, Unix System Services) environments. This includes conversions, migrations, rehosting and replatforming enterprise wide applications.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, TX

Responsibilities:

• This required that I monitor, review, test, and perform CICS/Datacom database operation support and system installs, upgrades and apply maintenance (patches/fixes/etc.)
• Provide 24X7 on - call or level 3 support to Datacom production systems
• Initiate recovery/restore/backups of CICS/Datacaom databases in the event of data loss. To include creation of procedures and documents to support business continuity.
• Perform Datacom database systems and application troubleshooting. Advise programmer analysts on the design and use of logical and physical database structure.
• Create a DB2 Data Base Management system & infrastructure to migrate CICS/Datacom data from.
• Load data (first test, then production) in stages subject to application systems meeting service level agreements on the distributed platform.
• Provide the exact same services to Unikix/DB2 on this platform similar to the Datacom environment: Backups, Tuning, Recoveries, Patches, upgrades, & documentation.

Confidential - Monterey, CA

Responsibilities:

• Developed additional ad hoc Business Intelligence programs & Reports to augment existing applications using Spark, Impala, Oracle, SAS, MS SQL Server from the Mainframe to Multi Node Cassandra Distributed environments. (Where required).
• Developed Business Intelligence/Data Warehousing models to include data modeling (using Erwin), ETL (DataStage) script development & processing environments setups.
• Developed and/or converted Financial Analysis scripts or Assembler programs to perform SQL access against Hive to generate reports to users, end users, managers and operations.

Confidential, Trenton, NJ

Responsibilities:

• Convert VSAM data sets & load to Cassandra.
• Convert IMS/DB COBOL VS II applications to Microfocus COBOL.
• Convert Assembler language utilities to equivalent C or C++ distributive programs.
• Convert JCL to Shell Scripts (Korne shell) on Linux.
• Perform Unit, System & Regression test on IMS Legacy applications to meet or exceed z/OS SLA.
• Setup all necessary processes such as: Backups, Recoveries, Configurations, Logging, Work Load management, job submissions, source code storage, etc.

Confidential, Torrance, CA

Responsibilities:

• Consolidate and Migrate the excessive number of mainframe DB2 Operational Data Stores, Data Marts and Data Warehouses while still maintaining existing SLA’s to the user/using community.
• Identify & Analyze Data Bases for migration to DB2 or conversion to Oracle on the new Platforms (AIX, UNIX).
• Decentralize identified mainframe Data Bases (OLTP & OLAP), Data Warehouses & Data Repositories through re-platforming (modernizing) to UNIX, AIX server platforms.
• Migrate DB2 and/or convert assigned data bases to Oracle or MS SQL servers on new platforms.
• Develop ETL processes (Using Infosphere/Federated DataStage) to mitigate future man made or natural disaster impact to production.

Confidential, Phoenix, AZ

Responsibilities:

• Installation, implementation and support of CICS, IMS, DB2 V9, MQ, with maintenance of overall z/OS Operating System environment. Primary responsibilities include installing, maintaining, & monitoring, of z/OS DBMS (DB2 & IMS) subsystems and all associated ISV software (i.e. CA & BMC, program products, etc.). This includes the Server Environments supporting AIX. Maintenance & heavy use of z/OS file structures; ICF Catalogs, VSAM thru IDCAMS, HFS, and storage management (e.g. SMS). Maintain DB2 Data Sharing in a z/OS Parallel Sysplex environment. Provided leadership & direction in all areas of DB2, Assembler Routines, MVS COBOL and online support. Responsible for backup & technical support for: MQ, Unix System Services, zLinux and CICS subsystems.

Confidential, Phoenix, AZ

Responsibilities:

• Maintain all Water Department, MVS COBOL & Assembler based Enterprise Wide Applications Systems & procedures (tuning, backups, recoveries, upgrades, etc.) as they apply to the DB2 Data Bases on the z/OS mainframe. (DB2 Systems Programming & DBA)
• Architecting new platform data requirements through Meta Data Development, Data Dictionaries specifying and/or creating ETL scripts, Stored Procedures to support the developers in the new Oracle Distributed Server environment.
• Performing Gap Analysis & implementation (conversion/migration/re-platforming) of BI/OLAP/DW/DS applications from the mainframe to MicroFocus COBOL or C/C++ on the Oracle Servers.

Confidential, Phoenix, AZ

Data Base Application Migration Lead

Responsibilities:

• Applications written for/in: CICS, IMS, COBOL, PL/1, Assembler, REXX, VSAM, DB2, Oracle, MQ series, JCL & ISPF were to be re-hosted to Open Systems such as: AIX, UNIX, Windows, Solaris, Linux or to zLinux using VM or Unix System Services. This project encompassed all Data Bases (OLTP & OLAP) moved and/or converted to the new platforms.