TECHNICAL SKILLS

ADABAS Databases, COBOL, DB2, DYL280, CICS On - line processing, Familiar with LAN

Environment, Used WORD, EXCEL, and PROJECT WORKBENCH, HYPERSTATION, IBM

Utilities, IMS DC/DB (BMP-MPP), ISPF, Micro Focus COBOL, VSAM, ZOS-JCL, TSO, SQL

Station, TOTAL database, SYNCSORT, SMARTTEST, InterTest, XPEDITOR, Oracle

Interfaces,SQL access

SUMMARY

• My objective is to leverage my years of experience in IT to provide good solid solutions for IT tasks/projects. I have several years of experience in taking strong asset for any IT team. I have designed/supported many systems and applications with emphasis on interfaces between systems, databases and on-line screens.

PROFESSIONAL EXPERIENCE

Consult Net

Confidential, Utah

• I maintained the Zions Banks Batch and CICS systems.
• I updated the Zions Zip Codes system (CODE1) every month with data files received from the United States Postal Service (USPS). Every year we needed to update the shipping files to receive discounts from USPS.
• I maintained the Deposit Systems to receive daily files from the Banks Branches. Also, updated the CICS programs to use these updated file.
• This assignment was on an IBM ZOS operating system.
• I helped changed the mainframe programs to the new BANCs system being developed. This involved the Affinity, and Kiting Banks systems.

ITSource

Confidential, CA

• I maintained the Raleys Food Stores Batch systems.
• We converted mainframe systems into the Internet Access System using MicroFocus COBOL to replace the mainframe.
• Used Rational Design system to convert and debug changed programs.
• This assignment was on an IBM ZOS operating system.
• Unpacked mainframe files into PC readable files delimited.

PLUSH PUPPY

Confidential, UT

• Wife and I ran our own business selling Plush Puppy products at AKC Dog Shows.
• We learned INTUIT Point of Sale system and we processed our own inventory. We created Purchase Order (POs), and invoices for billing clients.
• We used Quickbooks for our accounting and payroll systems.

Robert Half Technologies

Confidential, Utah

• I maintained the America First Credit Union On-line systems.
• I updated several COBOL programs which were updated. I enhanced the processing of these programs.
• I wrote several programs which extracted stop payments records and created a delimited file for downloading into an Oracle data base. Same program used UPSI switches to control the type of file created and the processing options.
• This assignment was on an IBM VSE operating system.
• Created a download files using COBOL to be loaded into an UNIX system.
• Unpacked mainframe files into PC readable files delimited.

PLUSH PUPPY

Confidential, CA

• Wife and I started our own business selling Plush Puppy products at AKC Dog Shows.
• We learned INTUIT Point of Sale system and we processed our own inventory. We created Purchase Order (POs), and invoices for billing clients.

System Development Specialist

Confidential, CA

• Support mainframe State Health Care System (CA-MMIS).
• Developed many ADHOC reports for DHCS team. These reports involved the creation of reports using COBOL programs for the extracts. New development for the California Health Systems.
• Converted Mainframe files into a PC readable format for Fraud Detection. Claims involved Outpatient billing, Medical billing, Crossover Inpatient and Crossover Outpatient. This project involved outside vendors that I had to ship drives. I wrote COBOL and SYNCSORT reports to unpacked, delimited, and convert to a fixed length file from a variable length files. These files were used to be loaded into an UNIX system. We would take COBOL programs from mainframe environment and load into a Micro Focus COBOL for testing.
• Designed ADHOC reports for CA-MMIS Accounts Payable Cash Management Department. This reporting saved the department 16 hours every week in research time. I did the design, development, and implementation of a COBOL process to read VSAM file and extract weekly information for the users.
• Modified several DYL280 selection criteria for more claim types. In Patient and Out Patient claims were added to the selection criteria.
• Created Collections report to identify the monthly collections and the balances owing. My team was newly formed team which took over support of many IBM projects. I created a basic extract system using COBOL and Assembler programs.
• Created SQL extract calls to the DB2 data bases.

IT Specialist

Confidential, CA

• Support mainframe State Health Care System (CA-MMIS).
• Helped implement the Inmate Eligibility Program for the State of California. I updated many COBOL programs to handle the new aid codes created by the Inmate system.
• Flowcharted the path of a Health Care Claim from receiving to the sending of the request for Warrant (Check) from the State of California. This project involved researching COBOL programs and determine the data flow from one program to the next.
• Did analysis on Claims Processing changes necessary for the new HIPAA requirements. This included the pricing of a claim. Claim types are Pharmacy, Long Term Care, Inpatient, Outpatient, Medical, Crossover, and Vision. This project required researching the claims system COBOL programs and mainframe jobs. I had to do the analysis to determine the changes required.
• Created SQL extract calls to the DB2 data bases.

PLUSH PUPPY

Confidential, UT

• We learned INTUIT Point of Sale system and we processed our own inventory. We created Purchase Order (POs), and invoices for billing clients.
• Wife and I started our own business selling Plush Puppy products at AKC Dog Shows.

Confidential, Minneapolis, MN

Senior Consultant

• Support mainframe feeds from payroll systems to security databases, maintaining schedules and updating processes as populations change. I designed, develop, and implemented a conversion process that involved 20-30 COBOL programs. Some of these programs were IDMS ADO screens.
• Converted key populations (~39,000 employees) from legacy PeopleSoft 3.2 and Acme payroll systems to Albertsons AHRIS payroll system. I had to change the output formats and route the changed files to new Payroll System. These were COBOL programs.
• Created PC readable file from the mainframe VSAM files. This involved converting packed fields into PC formatted files.
• Developed/ran audit queries for validation of data conversions from DB2 to Oracle databases.
• Supported the CICS/VSAM and ADSO/IDMS payroll screens for processing of rate schedules, garnishments, benefit updates, W2s and driver mileage. These CICS/VSAM screens were COBOL programs
• Monitored and updated system tables for store records when new stores are opened in order for the stores to be recognized by payroll.
• Created SQL scripts to go up against the Oracle PEOPLESOFT applications.

Confidential, Minneapolis, MN

Senior Software Engineer,

• Supports full package for receipt of Time and Attendance data from stores, distribution centers/warehouses, and offices. Rebuilt system to receive data, reformat it per specifications, and transmitted it to multiple payroll systems (AHRIS, PeopleSoft, ADSI EIS, Acme EIS).
• Supports litigation requests involving time data. Generate audit queries to support litigation requests from internal/external legal departments.
• Support mainframe feeds from payroll systems to security databases, maintaining schedules and updating processes as populations change.
• Used Micro Focus COBOL to update source modules and testing on our PCs before moving back into the production environment.
• Converted key populations (~39,000 employees) from legacy PeopleSoft 3.2 and Acme payroll systems to Albertsons AHRIS payroll system.
• Developed/ran audit queries for validation of data conversions from DB2 to Oracle databases.
• Supported the CICS/VSAM and ADSO/IDMS payroll screens for processing of rate schedules, garnishments, benefit updates, W2s and driver mileage.
• Monitored and updated system tables for store records when new stores are opened in order for the stores to be recognized by payroll.
• Created several DYL280 selection processes for the different stores and different store companies.
• Created SQL scripts to go up against the Oracle PEOPLESOFT applications.

Confidential, Denver, CO

Principal Consultant

• Acted as Team Leader over 15 individuals to update the Price Maintenance system to be Y2K compatible. The project included work in COBOL, IMS DC/DB, CICS, PLI, and BAL.
• Controlled the IMS DC portion of the Y2K project containing 40 on-line HYPERSTATION scripts, and 110 individual programs.
• Convert SQL scripts for the year 2000 changes.
• Ran several DYL280 extracts for determining which programs needed to be changed for the year 2000 compliance.
• Created the tools and methods necessary to successfully test Y2K programs within the target amount of time allotted.
• Supported all of the converted applications for Confidential in the various Y2K projects completed by the company for American Stores. Selected as the representative to represent Confidential at the end of the project to support the warranty on the changes that were implemented by Confidential .

Lead Programmer/Analyst

Confidential, UT

• Led the Y2K project for 3 key systems and met target deadlines to ensure timely compliance.
• Led various teams on Y2K projects. Led teams ranging in size from 5 to 7 team members for these implementations. Key tasks for these implementations were updating the databases and file formats to transition from the 2 digit year to the 4 digit year. I converted several IMS DB extracts from IMS into DB2 using SQL extracts and updates.
• Used Micro Focus COBOL to update source modules and testing on our PCs before moving back into the production environment.
• Mastered the use of JCL, SORT and control cards to reformat data in the batch processing.
• Restructured systems for easier screen processing in CICS, and IMS DC.
• Converted several IEBGENERs to DYL280 extracts and be able to get counts of records instead of END OF DATA messages.
• Converted mainframe DOS systems to OS systems.