SUMMARY:

• Systems Programmer & DBA with over 25 years of progressive mainframe, Client Server, and desktop systems, database and application experience.
• Related experience in application development in Assembler, Cobol, ADS/O, Culprit SQL, and software engineering encompassing all SDLC phases surrounding database administration, system analysis and design, software design, implementation, integration, conversion, system/unit/QA testing, support and documentation for online and batch systems.
• Environments include CA - IDMS, DB2 on z/Series OS and AIX/UNIX with Oracle.
• Have performed hundreds of software upgrades; performance tuning and level II technical support.
• Performance of related technical studies, requirements gathering, logical and physical data modeling.
• Design and modification of database structures, system catalog, and data dictionary.
• Definition of users, resources to security systems; monitor/control of resource usage and user access.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Responsibilities:

• Prosecuted information technology patent applications on a part time basis (between database consulting projects) for software and microprocessor inventions.
• One example “Big Data” patent recently issued Trademark Office is attached.

Database Consultant

Confidential, New York Life

Responsibilities:

• Performed R19 CA-IDMS upgrade testing & DBA activities including database and application migrations with Endevor, restructures, reorgs, etc. Sole DBA for 20 IDMS CVs.

Confidential

Responsibilities:

• Prepared two affidavits (over 100 pages A4 containing the results of 100s of Assemblies of Confidential Macro Assembler

Database Consultant

Confidential, Horsham, PA

Responsibilities:

• Systems Administration, Maintenance and 24/7 support for CA IDMS R16.x and third party vendor products.
• Providing backup and recovery procedures to minimize data loss and maximize database availability.
• Verification of ZOS Upgrade compatibility.
• Monitoring, Tailoring, Performance & Tuning
• Maintaining, & Upgrading database software to meet business needs when required.
• Upgraded CA-TOOLS & CA-IDMS Rel. 14.1 to 16.0 SP3 and documented a procedural upgrade plan to get the release into production.

Database Consultant

Confidential, Livingston, NJ

Responsibilities:

• Supported corporate systems programming group in the application of frequent maintenance to DB2 under z/OS, monitored and documented CA-IDMS production systems, performed testing of cloned Confidential at offsite disaster recovery data center.

Database Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Performed Database Administration tasks for a major new release, down to adding the elements with comments and some data modeling; Applications Programming and testing for CA-IDMS Rel. 16.x on the mainframe and Oracle 9i on a Sun Solaris network.
• Worked a little bit with Confidential .
• Prepared a Data Base Network diagram for distribution throughout IT for the software release enhancement.
• Worked with Oracle Enterprise Manager (OEM), SQL Navigator and the SQL Option, TCP/IP, JDBC and Quick Bridge CA-IDMS products on the mainframe.

Database Consultant

Confidential, Dallas, Texas

Responsibilities:

• Performed Systems Programming, Database Administration, Applications Programming and Project Management for CA-IDMS, DB2, and Oracle database systems in all operating environments (i.e. z/OS/390/MVS/ESA and AIX/UNIX) and under all major security environments (i.e. ACF/2/RACF/Top Secret).
• DB2 Family Fundamentals; DB2 for OS/390 Database Administration; DB2 for OS/390 System Administration; SMPE Fundamentals; DB2 for OS/390 System Recovery. (Read DB2/UDB for UNIX Certification Guide. Read DB2 for z/OS Developer’s Guide 5th Ed. which covers DB2 V7 & V8)

Confidential, Las Colinas, Texas

Responsibilities:

• Performed 24 x 7 IDMS DBA support functions including unload/reloads of 55 Customer Accounts databases, disaster recovery, applying database changes to support development utilizing most all IDMS utilities.

Confidential, Dallas, Texas

Responsibilities:

• Converted all Fast Dump Restore JCL to Confidential, maintained COBOL and ADS/O code and performed routine DBA functions.
• Used Batch Cobol/IDMS and Culprit to Extract and Reformat IDMS mainframe data into flat files for transport and loading into Sybase UNIX databases.

Confidential, Indianapolis, Indiana

Responsibilities:

• Unloaded/Reloaded mega IDMS segmented databases, performed routine DBA functions for 24 x 7 on call support and database changes.

Confidential, Dallas, Texas

Responsibilities:

• Installed and upgraded several IDMS Confidential 's using SMP/E, including all interfaces to Tact Software, CICS, DB2 and mainframe Oracle, applied APARS as needed.

Confidential, Dallas, Texas

Responsibilities:

• Upgraded several IDMS CVs and supported an IDMS CAS Manufacturing Conversion to the latest release level.

Confidential, Ft. Wayne, Indiana

Principal Oracle DBA

Responsibilities:

• Converted all 6 byte IDMS CAS Manufacturing dates to 8 bytes for Confidential compliance using IDMS Restructure and Unlo/Relo utilities, corrected errant COBOL application code which was filling up database areas, trained new Oracle DBA.
• Performed Oracle DBA functions on eight Shop Floor RS/6000 AIX systems which continuously extracted data from mainframe OS/390 IDMS databases using MQ Series. Wrote PL/SQL code, supported the development code written in MF/Cobol, and tuned the various systems manually, and with the help of Oracle Enterprise Manager.

Confidential, Stamford, Connecticut

Responsibilities:

• Upgraded over 70 IDMS Confidential 's from Release 10.xx to Release 12.xx for Confidential compliance, including security.
• Ensured appropriate APARS were applied using SMP/E to resolve storage violations.
• Worked with applications people and Confidential Global Services to migrate data across mainframes using Confidential and to ensure that IDMS was installed properly under SMP/E.