Data Software

RESUME: EARL C. EMERY

*** ********* ****

Londonderry, NH 03053 603-***-****

Email address ****.*****@*******.***

Executive Summary

EDUCATION: BOSTON UNIVERSITY B.A., M.A. Geology

M.S. Computer Science (p)

HARDWARE: IBM and Compatible Mainframes and Micros, WANG-VS

SOFTWARE: MVS, OS-JCL, VSE, ETL, ADABAS, NATURAL,REXX, MQ Series, SYNCHSORT, IDMS, ADSO, IDD, TSO, VSAM, CICS (Command/Macro.GDS), INTERTEST, ISPF, DOS-VSE, ASSEMBLER(Macros, Conditional), VTAM/BTAM Applications. "C" Language (PC & M/F), CROSSTALK, WANG Assembler, DYL-280, File-Aid, WORD, WORD PERFECT, Compilers, 3270 Data Streams, EZ-TREAVE, PANVALET, ENDEVOR, XML, VISIO, EXCELL, POWER-POINT, WAAPDSUT.

GENERAL: An experienced team-player with background as a DA, DBA, Systems Programmer, Software Engineer, System Conversions, Developer and Systems Analyst. able to work with minimal support and supervision to provide optimal solutions for construction, modification or analysis of complex real-time or batch systems in M/F or PC processors. I apply legacy and new technology quickly in complex situations to support business needs and software engineering requirements. I am comfortable working with development or QA personnel in remote locations. and have excellent written, verbal and presentation skills.

COBOL is used in batch and real-time applications with CICS, IDMS and ADABAS. Assembler language is used as needed. INTERTEST, EDF TSO-TEST, dump-reading and on-line dump facilities are used to debug problems SORT is used extensively as well as JCL, REXX and CLIST. Experience exceeds 10 years in all of these items.

SYSTEM ANALYSIS: Analysis, definition and design with document production for merging two very large, high use little-documented message processing systems, one in PL1 and produced by divergent corporate cultures into a single system written in "C". I dealt with run-time efficiency, data administration issues and project team members in different states.

PC-DEVELOPMENT / SOFTWARE ENGINEERING / CLIENT-SERVER:

Designed and coded a seamless integration of "C" language with ARBITER and CROSSTALK for a Municipal Bond Trading System. This product included the development of a unique Screen I/O Mapping Facility. Wrote CROSSTALK Scripts for Brigham & Women's' EDI Purchasing System.

• ADABAS-NATURAL - In this environment, held sole responsibility over a decade for a major activity system billing millions of dollars monthly to Domestic and Global Customers. I provided daily oversight and ran the monthly billing process. On the first business day of the month there was a 4 hour window to verify that all files were received and correct, that ancillary jobs had completed, to run the billing job and send files to the finance group so they could verify the consolidated financial data. I provided and tested extensions to the billing process. I provided modifications to the Check Processing system to convert from checks being printed and shipped by a vendor to doing it all in-house. The Software A.G. supplied assembler CICS/NATURAL Interface, critical to Bank Functionality, changed with CICS and vendor upgrades. I inserted bank custom code into the new source and verified its functionality. Upgraded a Treasury Work Station product to use HMAC and Triple DES for greater security. Supported domestic and global developers and QA activity. Recently, I spent 1 year training an associate to be my backup.

• IDMS SYSTEMS/DBA/Software Engineering - Installed CA-IDMS software, release modifications and tuning. Wrote user-exit code and DB Procedures. Installed 3rd party software interfaces to IDMS. Design and modification of user to meet user needs including IDD work, standards enforcement, SCHEMA, SUB-SCHEMA and DMCL Work. Changed active databases via PAGE-EXPAND, UNLOAD/RELOAD, RESTRUCTURES, DB-RECOVERY chain and record repairs.

• CICS/IDMS DEVELOPMENT and SYSTEMS -Design Coding and Testing programs in COBOL and Assembler (Command and Macro). Control Table Management, Basic Mapping and Native Mode terminal writes. CICS User exit programming. IDMS functionality in the same environments, plus ADSO and OLQ. Provided a utility that does concurrent multiple CV accesses from a single program.

• DATA-BASE PACKAGE DEVELOPMENT - Created three software packages. The first for IDMS Dictionary area auditing. The second to completely report on the complex structure of the DMCL Table. The third. an IDMS audit package uses only the set-name to derive, in batch, all information on files, areas, sets and records. It then sweeps the area using its own I/O and chain-management to verify pointer integrity and provide data for broken chain repair. Wrote the Lexical Scanner for OLQ (an English-like query language) at Cullinet Corp.

• TOOL-SMITH - A writer of utility routines to provide interfaces between incompatible systems to automate burdensome tasks and eliminate error. For example, a REXX routine to convert XML Data to data that would load into an ACCESS Database; routines to fulfill the requirement, "If we could only I wrote a set of MQ utilities to manage queue records and entities online and in batch. A REXX Exec allowed Financial Executives at BlueCross BlueShield to easily submit complex requests(some 2000 JCL statements) for revenue recovery reporting.

• TEACHING/COACHING -a provider of teaching and coaching in areas listed above under SOFTWARE. Trained other associates in Assembler Language.

EXPERIENCE:

JP MORGANCHASE: one year Contract, fifteen years Direct

COBOL, Assembler, CICS, ADABAS, NATURAL, REXX, ENDEVOR, MQ, MVS, XML

The NATURAL-CICS Interface is a large system-level Assembler program. It also contained "hooks" to interface with the extensive in-house application control system managing critical on-line services used by clients world-wide on a 24x7 basis. New releases of CICS/Natural/Adabas brought a new version of the interface from Software A.G. I had the task to transfer the JPMC code to the new source and see that it worked. I was the sole caretaker for years. Eventually they wanted backup so I trained two others in assembler language and the interface.

I provided changes to Assembler, NATURAL and COBOL programs to extend functionality. I modified a PC-M/F product to add HMAC compression and Triple DES Encryption Security to the communication links.

For twelve years I managed the CCAP Billing system written in NARURAL and COBOL and built upon ADABAS. As clients used functionality, activity records were created and sent batch to the M/F on a strict schedule such as daily, Monday to Friday, First or last day of the month. I monitored the arrival of some 50 files. I designed and built a number of extensions to the "daily" and monthly processing to eliminate frequent errors such as sending the same file twice. There were enough troubles that I wrote a system to remove the data in a file from the Billing Database. Any lateness was investigated and escalated until the file arrived. If the file was malformed, I pursued the data owners until it was corrected and transmitted properly, The Billing Programs ran on the first business day of the month at 5 A.M. If it could not complete by 9 AM upper management got involved. If the Service Agreements for the transmission of the files to the billing application were in question, very senior management was involved. In preparation for the Lowell Ma. facility closure, I trained teams in Chicago and Tampa to manage this billing processes. I worked with Business and QA personnel at home and abroad.

JPMC has a considerable business in sending payments as checks or advises to businesses or individuals. Clients send in files of data which we formatted and send to a Service Bureau for the printing and distribution of the checks and advises. Management decided to bring this operation in-house. I designed and wrote code and JCL to send individual customer's data to our in-house processing as soon as they were converted.

State of Massachusetts (Department of Transitional Assistance

MVS, REXX, Y2K, REVOLVE, COBOL, JCL,VSAM

Y2K conversions in batch COBOL and ADABAS/NATRUAL. Designed and wrote REXX Execs to move all components of an application into a set of libraries for REVOLVE Analysis and remediation. The activity is documented in a detailed report. It moves all JCL and PROC source, all source code for programs (excepting standard utilities) invoked in procs or JCL decks. For programs it moves all copy members, source reports NOTE and ENTRY statements and alters the internal name of the program to match the member name, if needed. All called subprogram source is processed in the same way. PARMLIB Members for every program are discovered and moved as well. A comma-delimited list of components moved and their type is provided for spread-sheet project control. A date compare EXEC determines if any of the elements were changed in production while the remediation was in progress. Installed the REVOLVE Package and did the set-up for analysis. Wrote specialized COBOL routines and provided technical liaison with the DTA Staff.

BANK of BOSTON: CICS, MVS, TSO, ENDEVOR, REXX, Y2K, VSAM

Y2K conversions of batch and O/L (CICS) programs, converting from COBOL to COBOL2. Made changes to code and report headings were required by the date routine Applied vendor changes to program modules. Wrote REXX routines to report step-names and executed programs for all members of a JCL PDS.

Paul Revere Insurance Company (Worcester):

CICS, MVS, TSO, PANVALET, REXX, Y2K, BAL\

Conversion of 20-year old undocumented CICS Macro Assembler programs to the Command Interface (still in assembler) wrote conversion-assist routines in REXX to provide assemble/compile without CICS from PANVALET or TSO libraries. A second routine scans TSO or PANVALET members for CICS Calls, ++INCLUDES and other features and places those lines in a new dataset for inspection. Name-masking provided to process programs in groups. Provided date routines for Y2K conversions and made changes to supporting assembler routines.

BAY BANK/BANK of BOSTON: IDMS, ADSO, CICS, COBOL, MVS, ENDEVOR

Design and coding of ADSO based interest rate management system. Modifications of CICS-IDMS COBIOL Programs to support the new system and convert to COBOL 2 for the merger.

Converse Rubber Company: DOS/VSE, IDMS, COBOL, ASSEMBLER

Maintenance programming in DOS environment and coding for conversion of IDMS records into a Client-Server Package.

GILLETTE: MVS, TCP/IP, BAL, IDMS/DC

Designed and coded a system to provide real-time transfer of the one or many user's print lines from within an IDMS region to the printer related to his remote PC. The PC was connected by dial-up. Required reading control blocks in another region and TCP/IP socket services without causing delay to the IDMS region or MVS as a whole.

Brigham and Women's Hospital: CROSSTALK

Wrote scripts for 2-way EDI data interchange for a purchase order system and a new wholesale supplier.

CITIBANK: MCS, CICS, NATURAL, BAL, CICS, COBOL/COBOL2

Provided a CICS Command Assembler Program to allow NATURAL Threads or other programs, running above or below the line to access and pass storage to a CICS Macro Assembler program running below the line. Migrated CICS-COBOL programs to COBOL2.

EDS: (Blue Cross Blue Shield) MVS, REXX, COBOL, BAL

I replaced a contractor who left a series of COBOL Report programs in various stages of completion. Working remotely as well as on-site, I cleaned up and debugged the reports. In conjunction with Corporate Management, created seven additional reports and brought all 20 reports to a standardized state to allow convenient modifications. Developed 12 thousand lines of REXX code and JCL procedures to dynamically build and submit JCL and Utility syntax to run, print and distribute this complex series of revenue recovery reports over remote or local printers. The EXEC [provides auto-documentation for submitted jobs. Wrote other EXECs to build the complex JCL streams, 2000-3000 cards, to extract data for the reports.

Wrote unusual "sort merge" routine to provide network transmission of claim files.

NYNEX: BAL, "C", PL1, MVS

Researched, designed and wrote a detailed design document for a project to recast two very large (undocumented) legacy M/F systems. One was in Assembler and the other in PL1 designed and written in two different corporate cultures, into a new system written in "C" Working remote and on site, managed and performed data administration for the project developers some of whom were in Boston and others in New York. Designed and wrote the conversion program, in "C", to convert and functionally extend a key PL1 control table for the system. The table managed the input conversion of over 100 record types for tens of millions of records per day.

HASBRO: MVS, CICS, COBOL

Working remotely and on-site in RI, modified CICS COBOL programs to place in operation functions included in the original install that never worked.

TSSG, BOSON GAS Company: MVS, IDMS, CICS, COBOL

Modification and Maintenance of COBOL Business systems.

ISI SYSTEMS: MVX, ENDEVOR, COBOL, BAL, IDMS, REXX

A major policy processor, manager and reporter of Massachusetts Auto Insurance Statistics. Wrote and modified CICS-IDMS based applications with minimal supervision. Provided technical assistance to other segments of the company to solve application integrity problems. Assisted in planning for the movement of large batch applications into ENDEVOR. Developed REXX routines to automate generation definitions from COBOL Layouts into IDD syntax for loading into IDD, the data dictionary. Modified a vendor's dynamic file allocation program to handle high-density cartridge tapes. Designed and wrote a COBOL utility program to transfer, in real time, Policy Data Structures from the Production to the Test System. This allowed rapid resolution of client issues without having to be in "their" databases. The utility was quick and simple to use and used minimal system resources.

NH Dept. Public Safety: DOS/VSE,VTAM, IDMS, CICS

Provided VTAM LU6.2 communications between IDMS and CICS in a DOS/VSE environment (the first known to the vendor) to support a nation-wide commercial driver licensing system (CDL). Provided the system table maintenance for VTAM, CICS and IDMSA to establish the environment. Installed and modified the 3rd party software, converting MVS JCL and Programs to DOS/VSE. Wrote custom code to initiate the M/F - M/F convwersations.

FIDELITY Systems: "C", COBOL, IDMS, ARBITER, CROSSTALK, CICS

Designed and created a large PC-based seamless integration of "C" programs, CROSSTALK and ARBITER to do real-time acquisition of Municipal Bond data from a financial service bureau with the updating of the M/F database. The code provides PC-based security for the application, audit trails, and user review and selection of CUSIPS prior to upload. The modular design ran easily in a 640K AT class machine. Designed and wrote a system in "C" to do PC screen I/O, driven by a control file (similar to CICS Basic Mapping Support), to easily serve this and any application requirement.

Design code and debug IDMS CICS COBOL Programs to load and maintain Customer information in a new Customer Information System.

GILLETTE: IDMS, CICS, BAL, MVS, COBOL, ACF2

Modified Vendor code in the IDMS interface for ACF2providing for greater ease of use and enhanced IDD security. Maintained test, development and production IDMS Environments, applied maintenance, resolved systems problems and assisted the user community. Did major migrations of the IDMS systems to new releases. Created assembler routines to write reports to a printer on a PC attached to an IBM-7171 protocol converter. Wrote an IDMS exit routine to force resource-intensive tasks to pause so other users may receive service. The management of the wait duration and triggering values are dynamically variable. A reporting system shows who is using how much of what resource.

CONVERSE RUBBER COMPANY: DOS/VSE, IDMS, CICS, COBOL

Database, data administration, program design and coding for a new Vendor order management, warehousing and order management System.

BANK of BOSTON and Shawmut Bank:

MVS, IDMS, BAL

Installed IDMS as a new product and assisted in the creation of the initial application system. This included all system software and DBA work, provision of support to the programmers, project leaders and vendor representatives. AD-hoc support to the user community at large.

AVCO Computer Systems: IDMS Systems Programming and application support

WANG Laboratories: IDMS Design and Programming and WANG/VS Support activities

CULLINET: MVS, BAL, IDMS

Compiler construction - wrote the lexical scanner for Cullinet's OLQ Rel. 2 Query Language. Also wrote the front-end interfaces for CICS, IDMS/DC and SHADOW along with the system installation JCL and instructions.

TRW-UNITED CARR: IDMS, CICS, COBOL, DOS/VSE

A principle in the for a shop-floor order processing system, wrote the CICS-IDMS O/L portion of the system which provided many of the features of AMAPS.

CAPTAIN, U,S. Army Engineers:

Eight years active service with assignments in command, teaching and Engineering Geology on the Panama Canal. A graduate of the Defense Language Institute in Arabic.

Contact this candidate