Mainframe Application Developer With Cobol, Idms, Adso,, Vsam, Jcl

D. Charles Wong

P. O. Box 38-763-***-****

St. Michael, MN 55376 **********@*****.***

Experienced, result oriented programmer analyst professional with 10+ years of experience in mainframe application coding, and offering dependable and motivated individual that is detail oriented and excellent organizational abilities.

DATA PROCESSING SKILLS

TSO ISPF/SPF OS/V S2 MVS/XA JCL COBOL, COBOL II

CICS VSAM IDCAMS

CULPRIT EZYTRIEVE ENDEVOR

SYNCSORT FILE, FILE AID EXPEDITOR

SCRATCH RECORDS ABEND-AID PEREGRINE

IDMS (14.0) ADSO (14.0) ADSA, ADSG, MAPC

DMLO, OLQ, IDD ADSALIVE TPX - HSL

TIVOLI TPSORT CHANGEMAN

Atomic UC4

EXPERIENCE

Ecolab, St Paul, MN 2019 - 2020

NorthShore Resources - Contract Programmer

Assisted on various projects by creating/modifying ADSO screens, and COBOL batch programs.

Data Retention Project – Due to Ecolab going off the mainframe in 2020, certain data must be retained for a given period. Requests by Ecolab personnel or auditors for the data may occur. Used ICETOOL on yearend files to extract data fields to create reports. Jobs are set up based on the file generation that needs to be extracted.

Deactivating Plant Locations and Division – Plant locations and divisions that have been transferred to SAP no longer needed in JCL jobs and COBOL programs. For ADSO screens, a new IDMS database record TBLENTRY was created to contain divisions that have been migrated to SAP. Screens modified to check for the division in TBLENTRY. If found, error message displayed indicating division has been migrated to SAP. This prevents users from doing any add, modify, or delete in CAS or ECL systems. Divisions are added to database record based on the wave time frame when they are installed into SAP.

Deactivating CA7 Jobs – With most business being done in SAP, most mainframe jobs no longer needed to run. Deactivated CA7 interface jobs and UC4 Atomic jobs between mainframe and SAP. Deactivated OE and GL yearly, monthly, weekly, and daily CA7 jobs.

Ecolab, St Paul, MN 2015 - 2018

Wong Consulting Contract Programmer

Assisted on various projects by creating/modifying ADSO screens, and COBOL batch programs.

Ecolab Canada Catalyst Order Interface – Created, modified, tested Cobol batch programs, JCL jobs, UC4 events/jobs, and Proterm scripts to receive net requirements from Canada SAP system that are used to create transfer orders on CAS mainframe system. Created audit report sent to supply chain users of new transfer orders created. Created new SSCC bar code shipping label when Ecolab Canada orders and receives raw materials, packaging materials and finished goods from Ecolab US.

Terra Project – Ecolab will be using Terra Technologies Demand Sensing (DS) and Multi-Enterprise Inventory Optimization (MIO) solutions, instead of ASI (American Software, Inc.) on CAS manufacturing system for Demand Planning (forecasting) to do eight weeks of forecasting on manufactured parts that includes chemical, dish machines, and equipment. Created daily CA7 job to extract open orders that will be sent thru UC4 job plan to Terra Technologies. Created Wednesday CA7 job and Friday CA7 job to extract shipping history that will be sent to Terra Technologies using UC4 job plan. Created and scheduled new edit program to receive file from Terra for the eight weeks of forecasting. Created and scheduled new IDMS program to update the first eight weeks of requirements on Ecolab part numbers that are service forecast type.

Purge records – Created on demand CA7 job to erase database records ECO-INVBIN for specific plant locations. Created quarterly CA7 job to execute on Sunday of second week for months March, June, September, and December to erase database records ECO-ASSOCIATION for specific extracted plant locations.

Kay to Mainframe Bridge – Modified parm member to include new Canadian customer prefix 8 with USA division 080. Modify COBOL program to write out USA division 080 for Canadian customer prefix 13.

US Catalyst Order to Cash (OTC) – Ecolab implementing SAP application in 2018. Interface jobs created to send data to SAP and receive data from SAP:

Order Creation Interface ECL to SAP ECC – Created CA7 hourly job to extract orders from CAS system to be sent to SAP. Orders extracted from new database SAPQUE records that are displayed on new ADSO screen SAPQ.

Order Confirmation Interface: SAP ECC to ECL – Created new CA7 daily job to receive confirmation that orders have been received into SAP. Sales order from SAP will be updated on the database SAPQUE records.

Customer Confirmation Process – Created new hourly CA7 job to create file containing records to create fax, order, and email confirmations. Job will execute new Proterm script SAPOCON to send out customer’s order confirmation thru EDI, Email, or Fax.

Purge SAPQUE records – Created daily CA7 job to purge records older than 3 months from today’s date.

Release for BPO (Blanket Purchase Order) SAP EBS to CAS – Created hourly CA7 job to process SAP Sales Order file where a release against the BPO in CAS will occur against the warehouse and product item number. Job will execute new Proterm script RLSEBPO, which will process the SAP file. The output file from the script will contain the SAP sales order and new release number against the BPO from CAS.

D. Charles Wong **********@*****.*** Page 2 of 3

Country Financial, Arden Hills, MN 2006 - 2015

Application Developer

Following projects involved creating or modifying CICS programs, COBOL programs, and utilizing VSAM files.

Policy Administration Conversion involved converting mainframe auto policies to new web-based auto policy system. Updated various application systems’ CICS screens with a new policy flag to indicate when the policy will begin migration to new auto system. And, added new transaction code to indicate policy has been converted to new auto system.

Updated Coverage screen and unit tested new Low Mileage Discount date and mileage fields to allow auto policy customers a discount on vehicles that are driven less than 7,500 miles per year.

Increased CBR field from current one-character code to two-character code, on Coverage screen, to spread out CBR scores, which allows more wide ranges of auto premiums.

Added new field Occupation Discount, on Coverage screen, to give certain professional occupations a discount on auto premium, which became a selling feature for new customers, and to retain current customers.

Designed, wrote, tested Low Mileage Discount screen to show policy’s vehicle VIN, Low Mileage Discount code and discount start date from VSAM file which allows field agents to see which policies have the discount.

Wrote and tested COBOL batch extract program for GEICS (Georgia Electronics Insurance Compliance System) to extract Georgia auto policies to be sent down to Cotton States regional office. Cotton States runs their nightly batch job to process the file, and sends an updated file to Georgia DMVS to update GEICS database. Project is to cut down the rate of uninsured motorists. When requested by police, GEICS is now the only valid proof of insurance for Georgia drivers stopped in Georgia. The rate of uninsured motorists went from 15% down to 7%.

Ran acceptance batch cycle jobs for various projects to process data entry from updated online screens, and test updated batch programs to verify data has been edited correctly and processed correctly to files.

Jostens Inc., Bloomington, MN 2004 - 005

Sr. Programmer/Analyst

Assisted on various order processing projects by modifying ADSO online screens, and updated COBOL batch programs, and JCL jobs.

Modified and unit tested programs to add new and remove discontinued rings or accessories for the Annual Summer Jewelry project.

Added and tested payment options to programs for the Payment Plan project.

Researched and tested encryption/decryption software for VISA compliance.

D. Charles Wong **********@*****.*** Page 3 of 3

EDUCATION

Electronic Data Processing Certification

St. Cloud Technical College, St. Cloud, MN

Bachelor of Science, Physical Education

St. Cloud State University, St. Cloud, MN

PROFESSIONAL EDUCATION

Oracle — University of MN Continuing Education

IDMS, COBOL, ADSO, JCL, TSO - Electronic Data Systems, Dallas, Texas

Contact this candidate