OVERVIEW:

35+ years of experience in a wide variety of applications and industries as an analyst, developer, technical team lead, manager, and tester.

EXPERIENCE SUMMARY:

• 30+ years of experience with relational databases (DB2), 40+ years of COBOL programming, 15+ years of hierarchical databases (IMS), 10+ years of inverted file databases (Datacom), 5+ years of network databases (IDMS), and 25+ years of CICS.
• 15+ years of experience with systems with web facing clients, 2+ years of M/S SQL Server 2008, and extensive experience with VSAM files.
• 10+ years of IBM M - queue experience, and 3 types of EDI experience (SWIFT - financial - ISO 8583 - financial, and REN - Rail Exchange Network.
• 3+ years of experience doing Business Intelligence work (data mining), currently studying for the CAPM exam.

TECHNOLOGIES:

Development Methodologies: Enterprise Architecture and Enterprise Service Bus, Agile (JIRA), Service Oriented Architecture (SOA), IBM Rational Unified Process (RUP), IEF Case, Yourdan’s Structured Methodology, Extreme Programming, traditional waterfall.

Programming Languages: COBOL, COBOL II, SQL, FORTRAN, HPS, Autocoder, Easycoder, Eztrieve, DYL-260, DYL-280, SAS, FOCUS, Mark IV.

Database/Transaction Managers/Access Methods: DB2, Microsoft Visual Studio 2008, CICS, IMS DB/DC, Datacom, IDMS, VSAM, Oracle SQL Developer.

Project Tools/Utilities: IBM ClearCase/ClearQuest, JCL/utilities, SPUFI, QMF, Forms, DB2 stored procedures, TSO/ISPF, SoftBase, UML, Rational Rose, BMC Utilities, APS COBOL, Micro Focus COBOL Workbench, ChangeMan, Panvalet, CA Endevor, Expediter, FileAID, AbendAID, Clists, COMPAREX, Star-Tools, CA7, UCC10, UCC11, IDCAMS, Outlook, Word, Visio, PowerPoint, Excel, MS Project.

Communications/Messaging Protocol/Middleware: Websphere/MQ, BizTalk, WSDL, XML, NDM, FTP, ISO 8583, SWIFT, and REN EDI.

Operating Systems: IBM z/OS, MVS/ESA, OS/390, OS/360. DEC RSX-11M, CDC NOS.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Designer

Responsibilities:

• Datacom to ORACLE conversion project using Agile (JIRA) methodology.
• The environment was Oracle/IBM MVS/CICS/VSAM/Datacom.
• Provided mainframe to distributed systems conversion expertise.
• Provided Datacom DBMS expertise.
• Provided testing methodology experience.
• Provided test data analysis expertise.
• Designed and implemented multiple test tools, all of which were COBOL based. This included the creation of a COBOL program generator that utilized a skeleton COBOL program, control cards, database definitions, and a master COBOL generator program to create programs that did field level validation for the Datacom and Oracle tables.

Confidential

Business Analyst/proof reader

Responsibilities:

• Analyzed and wrote functional requirements.
• Created and reviewed use cases.
• Built/updated data dictionary.
• Proofed wire frames and system flow.

Confidential, Sacramento, CA

Test Data Manager

Responsibilities:

• For the Continued Claims rewrite, analyzed the business requirements to determine the data required for regression, system integration, and user acceptance testing.
• Coded and executed SQL data mining queries against the DB2 and MS SQL databases.
• Performed gap and impact analysis of the COBOL programs that were being modified for the new front end (CCR).
• Created multiple COBOL based test tools for data extraction and validation.
• Developed automated COBOL programs for the extracts and data comparisons for the DB2 and MS databases.
• Provided environment support for the IDMS/CICS/VSAM based test environments (transaction failure analysis, configuration control, and VSAM file management).
• For the IDMS to DB2 conversion project, created specifications and developed the data mining processes using COBOL and Eztrieve programs for the IDMS databases, and SQL queries for the DB2 and the MS databases. This was a rapid prototyping environment with 350+ COBOL and Eztrieve programs written in a single year.
• Developed reporting and data interpretation tools, many of which were COBOL based.
• Coordinated the efforts for the archive and restore testing, the web based DB2 employer wages inquiry sub - system testing, and the testing of the flow of data from SCDB to the Identity Management system.

Confidential, San Francisco, CA

Manager, Technical Team Lead, Developer

Responsibilities:

• Rewrote the Schwab bank/brokerage interface and eliminated the out-of- balance conditions and the frequent timeout conditions plaguing the ISO 8583 EDI-standard MQ-based process, which was written in COBOL.
• Analyzed, designed, coded, and tested the new SIM (Schwab Investment Manager) to Cashiering interface, which notified the investment managers of scheduled SIM batch transactions, and potential failure points. This was one of Schwab’s most profitable initiatives, and was written in COBOL.
• Led the analysis, testing, design, and coding in COBOL of the Cashiering daily batch extract process, which provided daily activity feeds to seven downstream systems, including the Data Warehouse and employee fraud detection system.
• Led the analysis, design, and coding of the Cashiering backup and purge processing, which archived and purged transactions from the DB2 Cashiering tables, and was written in COBOL. This effort reduced the amount of storage required for the primary tables, and reduced processing costs significantly.
• Led the analysis, design, and coding of the ESPP (Employee Stock Purchase Plan) batch system, which created of Cashiering tax reporting records from external feeds, which was written in COBOL.
• Led the conversion of the remaining IDMS based Legacy Cashiering functions to COBOL DB2 based processes, thus eliminating the overhead of the IDMS license fees.
• Led the shifting of the Legacy tax event bridge (a system written in COBOL) to a direct update of the Cashiering DB2 tables using COBOL programs and the removal of the IRA Datacom table reverse bridge, with the deactivation of the IRA Datacom table, thus simplifying the Cashiering environment.
• Led the ongoing maintenance, enhancement, testing, and production support of the Legacy systems, which were COBOL/CICS/VSAM/Batch/Datacom/IDMS based.
• Led the r etirement account regulatory rule modifications and corresponding data conversion changes for both the COBOL DB2 and COBOL Legacy Datacom systems.
• Led the maintenance and enhancement of the COBOL based MoneyLink (ACH) system.
• Led the rewrite of the batch interface between Cashiering and General Ledger systems, both of which were written in COBOL.
• Participated in the design of the Wires processing, which was COBOL based and interfaced with the SWIFT financial EDI exchange.
• Led the analysis, design, and implementation of the recurring request and daily event processing batch drivers, which were written in COBOL and were the batch controllers for the daily processing of the cash and stock journals and wires transactions.
• Led the analysis, design, and coding of the pending reason processing, which was written in COBOL and determined user capabilities based upon user job roles, and the creation of the associated DB2 risk rule tables.
• Led the rewrite of the recurring request scheduler function, which was a critical COBOL based process that determined the next execution date for the recurring cashiering requests.
• Participated in the analysis, modeling, and implementation of a set of DB2 tables for a new suite of API based multi-tier SOA-based cashiering products that included cash journals, stock journals, checks, wires, and deposits, which were all written in COBOL.
• Led the creation of the COBOL based Cashiering transaction M-queue posting bridge to the books and records system.
• Led the rewrite of the system that interfaced with the NSCC (National Securities Clearing Corp), which was written in COBOL and controlled the transfers of assets between brokerage firms.
• Participated in the analysis of the replacement for the Dividends Distribution System.