Cobol Edi

Adam Claybaugh

Cell: 660-***-****

Mesa, Arizona

*************@*****.***

SUMMARY:

** ***** ** ***** ** experience. Migration Specialist. Technical proficiency in Data Warehousing Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation. Proficiency in interviewing stakeholders, re- quirements analysis and realization using Use Cases, deriving testable functional / non-functional system require- ments, providing strategic and tactical inputs and coordinating with business functions and technical teams from conception through deployment.

TECHNICAL SKILLS:

RPG, COBOL, POWERHOUSE, PDL, QDD, QUTIL, QDESIGN, QUICK, QTP, QUIZ, SQL, PL/SQL, SUPRTOOL, PHP, EDI, GENTRAN, JCL, FTP, RCL, EMAIL, ORACLE, TOAD, JAVA, C, ASSEMBLER, SQR, PASCAL, FORTRAN, TURBOIMAGE, RDBMS, DB2, VI, KSAM, IMSAM, MPEX, MPE, DCL, REFLECTIONS, COGNOS, ADAGER, DBGENRL, INFORMIX, SqlDbx STATUS, MASTER, CICS, QEDIT, QUAD, LINUX, UNIX, AIX, KORN SHELL SCRIPTING, HP3000, HP9000, DEC/VAX, HTML, XML, ALPHA/VAX, AS400, IBM, LANSA, OMNIDEX, AMISYS, SORT, UNISYS, DATA WAREHOUSE, CLEANSING, MVS, MAPPING, COBOL74, API, COBOL85, MICRO FOCUS COBOL, CHANGEMAN, REMEDY, LOTUS NOTES, GitHub EXPERIENCE:

OpenGov – Senior Level Consultant (12/2024 – 12/2025)

● Maintained Legacy Financial system using POWERHOUSE QUIZ,QTP,QSEDIGN/SQL/DB2/PHP/Windows.

● Government Software written in an Agile environment.

● Oracle VirtualBox Manager/GitHub/Workday/Jira/1Password/OpenAI/AWS/Slack/SqlDbx/NotePad++/ZOOM Visual Studio Code/Atlassian Cloud.

Health New England/Emids – Senior Level Consultant (04/2023 – 03/2024)

● Upgraded from AMISYS 6.5 /POWERHOUSE QUIZ,QTP/SUPRTOOL/PLSQL/JCL on UNIX Mainframe to AMISYS 8.8 /ORACLE SQL/PLSQL/SUPRTOOL/JCL/SSIS on LINUX Mainframe.

● Another Agile environment on an AMISYS Healthcare System.

● Azure/DevOps

Centene – Senior Level Consultant (10/2021 – 09/2022)

● Supported AMISYS Healthcare System in an Agile environment using COBOL/UNIX/SQL/EDI.

● IBM Mainframe.

● Worked through Change Requests on the Claims/Payment Integration team. FM Global – Senior Level Consultant (06/2021 – 12/2021)

● Maintain and support legacy insurance system using POWERHOUSE 7.10 QDESIGN,QUIZ,QTP,PDL/JCL/ EDI/SQL/REFLECTIONS/RMS/RDB/ on an OpenVMS/VAX Mainframe.

● Document all work with HEAT/EXCEL/WORD/EMAIL for implementing into all environments. Bank of America – Developer (10/2020 – 10/2021)

● Document COBOL/CICS/EDI processes on z/OS IBM3278 Mainframe. IBM – Japan - Senior Software Consultant (09/2020 - 12/2020)

● Short Contract to Support HRAG Payroll application. AIX/VISUAL BASIC/LOTUS NOTES/COBOL.

● Translated documentation from Japanese to English. Forge/IRA Services Trust – San Carlos, CA Senior Software Engineer (01/2020 - 03/2020)

● Maintain and Support 30 year old core legacy investment financial services system using RPG/JCL/KSAM/EDI/MINISOFT & WS92 SCRIPTS/QUAD/QUERY/XSORT on an HP3000 Mainframe.

● Studied all jobs/programs to learn our system and shadowed retiring CIO to takeover his duties.

● Wrote several programs in RPG.

● Made ENVIRONMENT files and manipulated them to be letters sent to certain customers and/or mass mail- ings inserting name, address and other information from user requests using RPG.

● Prepared a simple course on RPG to teach our current programmers how to navigate the core legacy RPG programs.

● Created a complicated process in RPG/WS92 to convert spool files from HP3000 to PDF files in each users folder on our Intranet so everyone could work from home due to COVID19 and still be able to verify with re- ports that printed next to them at the office.

● Was in the middle of automating daily operator tasks when I was let go due to COVID19. Partnership HealthPlan of California - Fairfield, CA Senior Programmer (04/2014 - 12/2018)

● Re-wrote EDI 834 membership process to be HIPPA X12 compliant in UNIX, PL/SQL, Powerhouse Quiz/QTP and JCL from COBOL.

● On Call 24/7 to Maintain ETL/EDI 834, 835, 837, etc and Support Amisys System on an HP9000 Mainframe with ORACLE databases through Microsoft Windows.

● Handled MediCAL membership eligibility.

● Troubleshot and altered COBOL, PL/SQL, JCL and POWERHOUSE Quiz/QTP processes as needed.

● Document and VISIO Flowchart 100+ Transfer processes written in JCL, COBOL, SUPRTOOL, PL/SQL.

● Adhoc reporting and processing as needed.

● Regularly used Microsoft Office Tools: OUTLOOK, EXCEL, WORD and ACCESS.

● Programmer Studio, TOAD, Reflections, ActiveBatch, Workfront, Skype for Business. Shaklee Corporation - Pleasanton, CA Senior Level Consultant (08/2011 - 03/2014)

● Cleaned up and re-structured the daily process to run 3 hours faster.

● Support HP3000 Mainframe core COBOL, SUPRTOOL and Powerhouse Quiz system 24/7 on call.

● Changed all daily and monthly reports from paper to soft copies.

● Created Excel version of all reports.

● Re designed a system to drive from a 2 digit company code.

● Implemented Credit Card changes to the EDI/ETL process I/O with Firstdata.

● Maintain and Support ETL/EDI process between HP3000, AS400, and Web. AllStorm Professionals - Sedalia, MO Owner/CEO/CIO (07/2010 – 03/2014)

● Created Access system to track and report sales.

● Manage roofing crews and sales staff.

Adamant Consulting Senior Level consultant (02/2007 – 07/2010) Clients:

Marsh - Des Moines, IA

● Enhanced and Maintained Insurance core processes using COBOL, SUPRTOOL, SQL and JCL in HP3000/HP9000 Mainframe environments.

● Handled many Projects and Client requests through Lotus Notes including many EDI/ETL problems. Centene Corp. - Chesterfield, MO

● Maintained ETL/EDI 837’s & 835’s & in AMISYS using POWERHOUSE, COBOL, SUPRTOOL, SQL/TOAD/ORACLE and JCL in UNIX environment.

● Handled REMEDY and TeamTrack tickets daily.

● Worked on ICD-9 to ICD-10 conversion.

● Converted many processes from HP3000 Mainframe/COBOL/IMAGE to HIPPA X12 compliant UNIX/SQL/ORACLE.

● Replaced error reporting process using QDESIGN/QUICK screens, COBOL, SUPRTOOL and embedded SQL.

● Worked through large backlog of Customer Requests (CR’s). Administrative Systems Inc. - Sacramento, CA

● Added a new client to the core process by creating new COBOL and modifying existing COBOL.

● Used DBGENRL, SUPRTOOL and MPEX on an HP3000 Mainframe.

● Handled an EDI/ETL problem.

● Fixed long standing bug in the address manipulation process and altered the XL. Phoenix - San Rafael, CA

● Converted several jobs and all Powerhouse programs to run in version 8 on a VAX Mainframe.

● Programmed tax compliance issues for 1099’s and K1’s.

● Handled many EDI/ETL projects with COBOL, CICS, AS400 Mainframe, VAX Mainframe, JCL, SQL, VSAM, TPF MQSeries 6.0.

● Updated the tax fax system that involved downloading from the mainframe to a certain PC then us- ing word macros and visual basic to decide which client to fax which form.

● Streamlined several jobs to run faster and more efficiently.

● Maintained core financial investment system with millions of records written in KORN shell AIX/UNIX/SQL in an IBM mainframe environment.

● Manipulated data and created reports and files ad-hoc. AgriTech Analytics - Visalia, CA

● Federal Agency controlled data warehouse for quality control of cow and goat milk in the U.S.

● Wrote functional specifications from COBOL hidden all over a UNISYS Mainframe to be re-written in ORACLE, PL/SQL and 4D.

● Converted all COBOL/UNISYS to UNIX/ORACLE, PL/SQL and 4D.

● Worked with ETL/EDI team to fix some bugs.

● Modified ACCESS process to report more useful information for documentation.

● Mapped the data in thousands of flat files on the UNISYS Mainframe to a relational database.

● There are hundreds of records for every cow in the U.S. separated by farms, breed, county, state, etc.

AgilityWare - Tracy, CA Systems Analyst (04/2003 – 01/2007)

● Created a dynamic demo and the security needed to be accessed from our website.

● Maintained the website and made new pages when needed.

● Write and Maintain MICRO FOCUS COBOL and XML programs on WEB

● Worked with KORN shell AIX UNIX with IBM AS400 mainframe.

● Developed highly sophisticated software that analyzed projects applying algorithms that send out alerts when issues arise.

● Managed 20+ Linux, JAVA and WEB developers.

● Created all EDI/ETL plans and processes.

● Helped write and debug JAVA programs.

Longs Drug Stores - Walnut Creek, CA - Sr. Programmer Analyst (05/2001 – 03/2003)

● Supported Pharmacy applications.

● Created new reports and processes as needed.

● Converted many programs from COBOLII/MPE/IMAGE on an HP3000 mainframe to SQR/UNIX/ORACLE HP9000 Mainframe environment.

● Created SQR modules containing the special codes to control the printer so users could fit any size reports on local printers allowing many projects to finish and finally let go of the mainframe clearing a 6 month bot- tleneck.

● Created and maintained the ETL/EDI between stores and vendors.

● Implemented HIPPA X12 compliance issues.

Adamant Consulting Senior Level consultant (08/1995 – 10/2000) Jobs: BHP Coated Steal Corp., Kalama, WA

● Fixed problem with shipping coils that are incomplete or do not meet the customer specs.

● Fixed pack code validation process.

● Fixed many EDI/ETL processes.

● Combined the results of several reports into one small report.

● Changed hard coded company name and logo in system programs.

● Fixed several screens and reports for compliance issues.

● VAX, VSAM, COBOL, JCL, TPF, UNIX, ORACLE, SQL/ETL. George S. May Co., Chicago, IL

● Fixed severe Y2K problems in the Italy and U.S.A. systems.

● These systems included Payroll, Document Tracking, Employee Status, Bonus and Commissions.

● Much of the POWERHOUSE source code was lost so entire systems had to be re-written.

● Added EDI standards as I re-wrote system in POWERHOUSE/Qdesign/Quiz/QTP/ETL on an HP3000 Mainframe.

● Created several new bonus types and a system to maintain and fold them into the present process- es.

Partnership HealthPlan of California, Suisun City, CA

● Converted Treatment Authorization Request (TAR) process from several ACCESS databases into AMISYS using COBOL/POWERHOUSE/ETL on an HP9000 Mainframe.

● Developed and attached a HIPPA X12 compliant TAR tracking sub-system to AMISYS that uses the AMISYS System Security to restrict certain functions to managers and uses the CODE-DETAIL file to create dynamic reports and to help audit the TAR process.

● Wrote a TAR Manual with easy instructions explaining the entire Authorization process.

● Put all the TAR letters in the Correspondence Generator and taught the users how to use the AMISYS Letter Generating process.

● This project made me very familiar with several of the AMISYS sub-systems and gave me a complete understanding of the Switches, Codes and Keywords that Configure AMISYS.

● I also got to know the Databases, how they relate to each other and where to find things. PriceWaterhouseCoopers – Smurfit/Stone Container, Chicago, IL

● Created process to extrapolate data from an IMAGE database into a flat file for ETL/EDI.

● This process also read a flat file (EDI/ETL) and put the data into the MULTIVIEW screens using rapid fire processing.

● POWERHOUSE/Qdesign/Quiz/QTP/JCL/TPF/MQSeries 2.0

● These processes had to be dynamic enough to run from 98 plants on 60 AS400 Mainframe and HP3000 mainframe.

Diamond Walnuts, Stockton, CA

● Handled all the difficult problems that arose while we fixed the Y2K bug in over 3000 programs using UNIX/SQL/POWERHOUSE/Qdesign/Quiz/QTP/JCL/TPF/API/ETL on an HP9000 Mainframe.

● Handled all EDI problems.

● Changed the record structure and processing of the COBOL Quality Management module. Norcal, San Francisco, CA

● Responsibilities included Y2K analysis and modification as well as enhancements to insurance en- dorsement letters.

● HP9000 Mainframe/SQL/UNIX environment.

InfoHealth, Santa Rosa, CA

● Supported and maintained core healthcare system and helped the company migrate to the AMISYS system on a VAX Mainframe /JCL/TPF/ORACLE/SQL/UNIX/POWERHOUSE/Qdesign/Quiz/QTP.

● Regular duties were to create data files with specific Providers or Members for mailing labels or EDI.

● Other times it would require adhoc reporting or re-writes of screens or reports. Benefit Management Systems, San Francisco, CA

● Maintained core HMO system and completed the Y2K analysis and modifications on an HP3000 Mainframe.

● Increased the size of all amount fields in COBOL programs and adjust to stay on word boundaries. Hewlett Packard, Rohnert Park, CA

● Enhanced and maintained the TMO system that uploads MSACCESS requests for product structure from a PC to the mainframe and then back to the PC at several sites around the world.

● HP9000 Mainframe/SQL/UNIX/POWERHOUSE environment Redwood Health Services, Santa Rosa, CA

● Developed the Project Tracking/Billing System from several programs and processes written in PASCAL, ASSEMBLER, COBOL and FORTRAN that was also used for logging hours.

● Maintained and supported the core health care HMO system.

● Implemented HIPPA X12 compliant EDI and ICD-9 codes to communicate with hospitals and providers via ETL.

● Created a security system to limit the access or update capability by users.

● Created a Provider system to replace several PC based Provider databases spread throughout the company.

● Automated several tasks being handled by the IS department.

● Involved in conversion to an ORACLE/SQL/HP3000 Mainframe/ UNIX/POWERHOUSE/Qdesign/Quiz/QTP/JCL environment.

Trident InfoTech (NOL), Oakland, CA - Sr. Programmer Analyst (09/1992 – 10/1997)

● Converted or rewrote screens/jobs from an IBM AS400/RPG/API/JCL/VSAM/DB2/CICS to an HP3000 Mainframe/POWERHOUSE/Qdesign/Quiz/QTP/TURBOIMAGE/KSAM

● Developed an Intermodal system to handle and track container movement throughout the United States us- ing EDI/ETL.

● Worked with GENTRAN for some of the EDI using 900 series stantards.

● Created a complicated Rate Proposal Search system that utilized and integrated an AS400 Mainframe an HP3000 Mainframe and a PC for the Pricing/Sales staff that gave them an edge on their competitors.

● Developed a Service Request system in POWERHOUSE.

● Enhance/Maintain/Support core AS400 Mainframe system. Compucall, Los Angeles, CA - Contract (02/1992 – 07/1992)

● Wrote and maintained COBOL statistical programs and job streams for political campaigns, PBS TV, polls and other applications using EDI files to ETL data. This was 200+ terminals with phone headsets hooked to an HP3000 mainframe.

● The work stations would accept calls or call out depending on the client and show the script the user would say, and based on the answer, the user would hit the appropriate key (Yes/No/Maybe...) and this would prompt the next script and so on.

● We had 2 programmers and 0 operators to care for the entire system so I got to learn some operation du- ties.

Systems Tax Service, Fountain Valley, CA - Lead Programmer (03/1991 – 06/1992)

● Solely responsible for implementing compliance issues on tax forms from all state and local tax agencies nationwide in COBOL/POWERHOUSE/Qdesign/Quiz/QTP/JCL/HP3000 Mainframe.

● Saved the company over $2,000,000 in fines and fees.

● Enhanced and maintained a return automation system that relied heavily on ETL/EDI.

● Converted all COBOL programs from IMERGE to JFMERGE.

● Created a job tracking system in COBOL.

Jackrabbit Computer Systems, Anaheim, CA – Micro Focus Cobol Programmer (10/1990 – 02/1991)

● Owner called Computer Learning Center asking for a student that could handle COBOL and they sent me. His son saw my fixes in the programs he wrote and hired me at Systems Tax Service upon graduation.

● Combined and converted all printing into one module from several Micro Focus COBOL programs.

● Removed spelling and grammar errors on all screens and added user requested features.

● Added or changed color and/or flashing to existing fields to make screens consistent.

● This company had 500+ clients across the USA that used his Legacy Shoe Store POS/Inventory control sys- tem written in Micro Focus COBOL.

● Sent new versions and updates via snail mail on Floppy Disc so sometimes I licked stamps. Education:

Certified in Mainframe Programming at Computer Learning Center, Anaheim CA (08/1990 – 02/1991)

Contact this candidate