San Francisco, CA
Over 30 years of total IT 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, requirements analysis and realization using Use Cases, deriving testable functional / non-functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical teams from conception through deployment.
RPG, COBOL, POWERHOUSE, PDL, QDD, QUTIL, QDESIGN, QUICK, QTP, QUIZ, SQL, PL/SQL, SUPRTOOL, EDI, GENTRAN, JCL, RPGII, FTP, RCL, EMAIL, ORACLE, TOAD, JAVA, C, ASSEMBLER, SQR, PASCAL, FORTRAN, TURBOIMAGE, RDBMS, DB2, VI, KSAM, IMSAM, MPEX, MPE, DCL, REFLECTIONS, COGNOS, PHP, ADAGER, DBGENRL, INFORMIX, 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, MICROFOCUS COBOL, CHANGEMAN, REMEDY, LOTUS NOTES
Forge/IRA Services Trust – San Carlos, CA Senior Programmer 01/2020 – 03/2020
●Maintain and Support 30 year old core legacy investment financial services system using RPG/JCL/KSAM/MINISOFT & WS92 SCRIPTS/QUAD/QUERY/XSORT on an HP3000.
●Studied all jobs/programs to learn our system and shadowed retiring CIO to takeover his duties.
●Wrote several programs in RPG including a fun one that parsed out randomly entered name1/name2/addr into proper fields and format first/mid/last/suffix/title/addr1/addr2/altaddr.
●Made ENVIRONMENT files and manipulated them to be letters sent to certain customers and/or mass mailings 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 reports 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 EDI 834, 835, 837, etc and Support Amisys System on an HP9000 with ORACLE databases through Microsoft Windows.
●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 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 process I/O with Firstdata.
●Maintain and Support 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
Marsh - Des Moines, IA
●Enhanced and Maintained Insurance core processes using COBOL, SUPRTOOL, SQL and JCL in HP3000/HP9000 environment.
●Handled many Projects and Client requests through Lotus Notes including many EDI problems.
Centene Corp. - Chesterfield, MO
●Maintained 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/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.
●Handled all EDI.
●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.
●Programmed tax compliance issues for 1099’s and K1’s.
●Handled many EDI projects with COBOL, CICS, AS400, VAX, JCL, SQL, VSAM, TPF MQSeries 6.0.
●Updated the tax fax system that involved downloading from the mainframe to a certain PC then using 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 to be re-written in ORACLE, PL/SQL and 4D.
●Converted all COBOL/UNISYS to UNIX/ORACLE, PL/SQL and 4D.
●Worked with 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 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 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 a mainframe to SQR/UNIX/ORACLE 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 bottleneck.
●Created and maintained the 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 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.
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 on HP3000.
●Created several new bonus types and a system to maintain and fold them into the present processes.
Partnership HealthPlan of California, Suisun City, CA
●Converted Treatment Authorization Request (TAR) process from several ACCESS databases into AMISYS.
●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 EDI.
●This process also read a flat file (EDI) 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 and HP3000 mainframes.
Diamond Walnuts, Stockton, CA
●Handled all the difficult problems that arose while we fixed the Y2K bug in over 3000 programs on UNIX/SQL/POWERHOUSE/Qdesign/Quiz/QTP/JCL/TPF.
●Handled all EDI problems.
●Changed the record structure and processing of the Quality Management module.
Norcal, San Francisco, CA
●Responsibilities included Y2K analysis and modification as well as enhancements to insurance endorsement letters.
InfoHealth, Santa Rosa, CA
●Supported and maintained core healthcare system and helped the company migrate to the AMISYS system on a VAX /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.
●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.
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.
●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/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/POWERHOUSE/Qdesign/Quiz/QTP/TURBOIMAGE/KSAM
●Developed an Intermodal system to handle and track container movement throughout the United States using EDI.
●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 an HP3000 and a PC for the Pricing/Sales staff that gave them an edge on their competitors worldwide.
●Developed a Service Request system.
●Enhance/Maintain/Support core AS400 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 load data. This was 200+ terminals with phone headsets hooked to a 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 duties.
Systems Tax Service, Fountain Valley, CA - Lead Programmer 05/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.
●Saved the company over $2,000,000 in fines and fees.
●Enhanced and maintained a return automation system that relied heavily on EDI.
●Converted all COBOL programs from IMERGE to JFMERGE.
●Developed a job tracking system.