PROFESSIONAL SUMMARY:

Highly motivated results oriented IT professional with strong technical and analytical skills. Works well independently, or in a sharing environment. Extreme adaptability as evidenced by successful movement between applications while member of two SWAT teams. Works well in a telecommuting environment. Vast experience utilizing new software features to automate complex solutions for developers, testers, and the end user community. Client/Server/distributed development and debugging experience.

TECHNICAL SKILLS:

Languages: COBOL, COBOL II, PL/I, PLS, REXX, JCL, Assembler, MicroFocus COBOL, SAS, Easytrieve, Natural, Korn Shell Scripting, HTML

Databases: DB2, DB2/2, Oracle, ADABAS, VSAM

Tools: TSO/ISPF, File - Aid, File-Aid DB2, ADS, Intertest, XPEDITER, QMF, PRO/Edit, DB2 Interactive, Strobe, Golden, TOAD, Confidential, SYNCSORT, MQ Series, CA-7/11, Control-M, ESP, FTP,NDM, IAM, TRX, REXXTOOLS, SMS, TestPro

Operating Systems: z/OS, OS/390, MVS/ESA, MVS/XA, VM, Unix, CICS, OS2, Windows Vista/XP/NT/98/95, DOS

EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

• Maintained an internally developed tool primarily used by testing services to capture production data and refresh selected test environments.
• This tool utilized REXX execs and other ISPF dialog components.
• Test environments were populated using SAS routines.
• Participated in weekly planning and design sessions with the user community as well as development team members to define requirements for the enhancements to the upcoming release of the data refresh tool.
• Met regularly with the user group responsible for data integrity to define requirements for a specific set of utilities.
• These utilities were designed to work alone or in conjunction with the capture/refresh tool.
• Designed and developed a REXX utility to parse COBOL/CICS source code and identify/create copybooks contained within as well as individual field locations/lengths.
• The user group could then take advantage of these utilities to subset and obfuscate production data and load DB2 tables and/or other files into test environments.
• Once defined, solutions were implemented and tested with the user community to gain sign off.

Confidential

Manager

Responsibilities:

• Responsible for all facets of successful business operation.
• Daily duties included to project solicitation, initial client meeting, specification gathering, estimate submission, scheduling, installation, client approval, and maintenance.
• Developed website detailing services offered as well as benefits to potential clients using HTML.

Confidential

Senior Software Consultant

Responsibilities:

• Modified host COBOL modules during a Bin/PEC/DC conversion to shift inventory and sales quantities to the appropriate entity.
• Converted legacy COBOL reporting modules to SAS
• Monitored redemption of refunds to merchants for various promotions. Produced notifications of pending redemptions and letters of escheatment on a monthly basis.
• Designed and developed an automated process to delete rows from a DB2/2 table based on a date range parameter.
• Gathered user requirements for a REXX script that could be run on demand to glean specified data at a given location. The data was extracted using dynamic SQL, transferred via FTP to the host, and loaded into various DB2 tables.
• Implemented a strategy to alleviate a performance bottleneck when loading sales data into forecast datasets.
• Created an ITE environment to mirror production. Once defined, exported data using QMF procs from production and imported them into the ITE environment. This environment was then used to do 53rd week testing for planning purposes.
• Researched incorrect report output using Golden to access Oracle data. Also verified that Informatica mappings and FTP data transfers were working as designed.
• Modified and tested numerous host programs requiring table sizes to be increased. Along with the table size increases, the MQ Series message lengths were also increased. Test cases were developed to verify the messages published were identical in environments using different COBOL compilers.
• Converted a legacy COBOL system to take advantage of new COBOL and DB2 features. These modules retrieved data from host DB2 tables, logically bundled the data and then wrote the output to message queues (MQ Series). The conversion utilized the Enterprise COBOL compiler. During the conversion process, it was found that there existed hundreds of lines of code which could never be executed. The legacy code identified was removed from all modules.
• Researched hundreds of COBOL modules to determine the impact of a sales geography realignment. This research identified many instances where values were hard coded and data was not current. Once identified, user groups were apprised and corrections were made to the reports still viewed as viable.
• Implemented calculation changes to reports due to changes in the method sales and stales were viewed.
• Set up batch test cycles for three applications where they did not exist.
• Modified year end SAS processing to use dynamic SQL and take advantage of parameter passing rather than having values hard coded.
• Worked with DBA team to evaluate and implement DB2 stored procedures in an effort to improve performance and reduce code maintenance.
• Analyzed and modified COBOL and MicroFocus COBOL subroutines which were called to access DB2 on the host and DB2/2 in the distributed environment. These modifications came in conjunction with the line item expansion project that doubled the number of items a sales representative could place on an individual order. Once implemented, test scenarios were executed to validate the data returned to all calling modules.
• Distributed modifications were made in an effort to reconcile two accounting systems. These modifications included both Microfocus COBOL changes as well as COBOL modules and REXX execs on the host.
• In - depth analysis of a Local Processor System. Identification of the components to be modified for the implementation of a new business unit were done. This included review of command scripts on both the Client and Server for numerous applications.
• Utilized TELNET to track the application flow through the local processor on domestic nodes. Conducted impact analysis of converting C and MicroFocus COBOL routines to 32-bit and moving them from the client to the server.

Confidential

Senior Software Consultant

Responsibilities:

• Independently developed an automated COBOL/CICS system to submit selected reports utilizing transient data queues to submit JCL through the MVS internal reader.
• Developed and maintained the Child Support System for the state of Wisconsin (Telon/CICS).
• Worked with DBA and systems programmers to improve DB2 performance using Confidential, Strobe and QMF Procs.
• Worked as a team lead on a year long project enabling a new development environment at a different physical location.

Confidential

Consultant

Responsibilities:

• Supported existing international inventory management system running on over fifty nodes in a Client/Server environment.
• Coded REXX scripts containing dynamic SQL to report on database activities at various nodes.
• Wrote ISPF/Dialogs to generate weekly batch cycles based on data received from each of the international nodes.
• Worked with DB2/2 DBA to reduce run time for various international resource planning functions.

Confidential

Consultant

Responsibilities:

• Converted a programmers workbench comprised of CLISTs, ISPF tables, PL/I and Assembler code.
• The new workbench utilized REXX execs and VSAM datasets.
• Performance improvements of 150% were attained within the new workbench.
• Technical team lead responsible for all DB2 components supported under the workbench ( ProEdit, QMF, Telon, DBMAUI, FileAid DB2, FileAid RDX, and DB2I) .
• Identified COBOL modules containing Report Writer and converted these modules to SAS.