Data Entry
Resume:
PATRICK SEERY
***** ***** ***** #*** ******, TX *5252
SYNOPSIS
Eleven years of MVS analysis and application programming. Internet Developer certificate.
OPERATING SYSTEMS AND SOFTWARE
OS/MVS COBOL ICCF
OS/JCL RPGII CEDF
DB2/SQL ABENDAID
Command Level CICS FILE-AID
CICS/COBOLII PANVALET
BMS EYEWITNESS
VSAM INTERTEST
SYNCSORT XPEDITOR MVS/TSO GAMMA, a 4GL/CASE tool VOLLIE VIASOFT SMARTEST MOVE FOR DB2 Gupta SQLWindows LIBRARIAN
File Aid for DB2 C#
PLATINUM FOR DB2 XML
EASYTEST on-line PHP
ASP.NET ORACLE database
Java 2.0 XHTML
Drupal
HARDWARE
IBM 30XX, AMDAHL 30xx clone, HITACHI 30xx clone, IBM MVS 9672
APPLICATIONS
Manufacturing On-line order entry
Healthcare Supplies Production Reporting
Data Entry Order Processing
Auto Insurance Accounts Payable
Healthcare Insurance Financial Markets
Data Base Loading Highway Inventory
Child Support Highway Bridge Data
Student Loans Sales forecasting Claims Processing DOT bridge data
Financial market Standard Portfolio Analysis of Risk
Highway location conversion 401K Trust Funds
Healthcare claims adjudication
EXPERIENCE SUMMARY
Programmer analyst. Working from the Business Requirement Document, perform the system analysis, document the system, code the program changes, set up test data, code the test JCL, and execute the unit test. Move the test results into the appropriate documentation folder.
Project administration. User contact, requirement determination, system design, writing system test scripts
and system testing.
Team leadership. Responsible for menu driven data entry system design, spec writing, estimating, coding, and testing my and other on-line CICS VSAM programs.
Client/server system quality assurance and performance testing.
Gupta SQLWindows client/server system debugging.
Batch and on-line DB2 processing using my own table space. This required defining and maintaining all my own tables, indexes, and data.
CICS COBOLII on-line and batch order entry system support.
CICS COBOLII systems allowing ad hoc report tailoring and job submission via transient data to the internal JCL reader.
CICS COBOLII DB2 data entry systems.
CICS COBOLII utilizing alternate indexes.
CICS COBOLII DB2 account queries selected on-line by the user which utilize: control break data organization, writing the resulting data to temporary storage, on-line temporary storage browse, user 'page' or control break select.
CICS COBOLII insurance claims processing in the ‘background’. Claims are written to transient data queues. Automatic transaction initiators with a trigger level of one start CICS transactions to further edit the claim.
Batch COBOLII DB2 database loading and maintenance.
CICS COBOLII loading VSAM files into main memory, then browsing and maintaining the data in main memory.
Data base loading system development. Designed coded and tested location conversion system, data load system, and data base maintenance system.
EXPERIENCE
February 2010 – July 2011. For CrossUSA and Emblem Health in New York City joined team of approximately 50 programmer analysts, team leads, and system analysts maintaining the healthcare claims processing systems. Independently analysed, designed, coded, and tested a new CICS VSAM system for claim history browse. The system consisted of three new programs and a PFkey jump off the main claim browse system. Worked on a team correcting online problems for the new APR DRG system which expanded fields throughout the VSAM CICS system. Worked to reduce turnaround times on reported problems to as little as 45 minutes. Worked independenty on a project to allow an additional code on dental claims. Analyzed and documented the online and batch dental claim systems, coded the program changes, set up test data, coded the test JCL, and executed the unit test. Moved the test results into the appropriate documentation folder.
June 2008 – June 2009. For the WI Department of Transportation was responsible for the detail design, coding, and testing of substantial changes to the COBOLII, CICS, DB2 bridge data system. New data reflects vibrations, damage assessment, design expectations, new composite materials, and additional defense data. All Metric data was deleted from the data base, online, and batch process, because the feds no longer require it and the state of Wisconsin does not use it. The new data was worked through the entire online, and batch systems. Extensive edits and data validation were added to help insure the accuracy of the input. Over 50 programs were modified. Environment: AMDAHL and HITACHI 30XX clones, OS MVS/XA, MVS JCL, VSAM, TSO, ISPF, COBOLII, CICS, DB2.
August 2005 – May 2008. Web, programming student and tutor at Madison Area Technical College. Tutored students in mainframe and web programming. Classes listed at the end of the resume.
September 2005-July 2005. For Seery Consulting worked the following assignments.
May 2005 – July 2005. For Computer Sciences Corporation and USAA, was part of the programming team maintaining and debugging automobile insurance software. The system consisted of a Gupta SQLWindows client/server front end, IBM mainframe edits, and a DB2 database. The client/server code made extensive use of handle objects to refer to the data residing on the DB2 database. Environment: Gupta SQLWindows client/server, IBM mainframe COBOLII, DB2.
September 2004 – March 2005. For American Family Insurance participated in the quality control, system, and performance testing of the new client/server Agency Data System. Used SQABasic scripting to performance test applications, database modifications, and local area network configurations in a simulated insurance agency.
Environment: Delphi client/server, Paradox, NT Server.
April 2004 – July 2004. For Lands’ End was part of the support team for the CICS and batch VSAM COBOLII order entry systems. Performed analysis, coded, tested, and documented maintenance to the above systems, which are the heart of Lands Ends’ operations. Wrote the users’ security manual for the on-line order entry system.
Environment: IBM 3090, OS/MVS/XA, MVS JCL, COBOLII, Command level CICS, PANVALET, TSO, CEDF, CHANGEMAN, XPEDITOR.
September 2003 – January 2004.
For Wisconsin Physician Service performed maintenance on the on-line claims processing system. On-line claims are written to transient data queues. An automatic transaction initiator with a trigger level of one starts a transaction to edit the claim in the transient data queue. Once the transaction is complete the claim is written to a different transient data queue, and a different transaction to continue editing the data is started. In order to check claims history this system makes extensive use of temporary storage and VSAM.
For this client I was also responsible for developing new batch enrollment-reporting systems. Five small systems were coded from specs. The systems involved reproducing KSDS master files as SAM files, reading the SAM file sequentially, looking up corresponding data on the master file, and writing a flat work file. The work file gets a JCL sort in a separate job step. The sorted work file is input to the report program. The report programs are typical control break programs using Julian date calculations for the report headings.
Environment: AMDAHL and HITACHI 30XX clones, OS/MVS/XA, MVS JCL, COBOLII, CICS, PANVALET, TSO, CEDF, XPEDITOR batch, VIASOFT SMARTEST on-line.
August 2001-July 2003. For Copps Consulting in Hudson, Wisconsin, worked the following assignments.
December 2002 - July 2003. For the WI Department of Employee Trust Funds, was responsible for the coding, and testing of a batch and on-line CICS, DB2, COBOLII system for SSN deletion.
The on-line program writes to the system-wide data entry DB2 table. The daily batch portion sorts and downloads the data entry table to a flat file. A COBOLII DB2 program performs extensive edits, prefixes the bad SSN’s with a ‘D’, writes a report, and writes extensive reconciliation entries to the existing reconciliation system. The annual COBOLII DB2 portion performs edits to insure all amounts have been rolled over to zeros, and deletes the ‘D’ ssn’s from the database.
The DB2 portion was performed in my own table space. I defined my own table space, tables, and indexes, and loaded my own tables from production. Approximately 50 tables were edited and modified by this system. Environment: AMDAHL AND HITACHI 3090 clones, OS/MVS/XA, MVS JCL, COBOLII, DB2, Command level CICS, PANVALET, TSO, CEDF, PLATINUM TOOLS for DB2, VIASOFT SMARTEST.
December 2001 – December 2002. For the WI Department of Transportation, was responsible for the detail design, coding, and testing for the addition of Metric data to the CICS, COBOLII, DB2, and batch COBOLII DB2 bridge data systems.
The data entry portion of the on-line was converted to Metric input, with the maintenance of English data transparent to the user. Edits were added to keep both the metric and English data within their respective ranges on the database. Both the English and the metric data will be maintained on the database. The inquiry portion of the on-line was modified to display the data as either metric or English, with PF6 used as a toggle. The batch reporting system now offers the option of English or Metric units of measure, with the option entered as a JCL symbolic parameter. Thirty three on-line programs and four batch programs were modified to handle metric data.
Viasoft Smartest on-line was used to locate and correct existing problems in the systems as well.
Environment: AMDAHL AND HITACHI 3090 clones, OS/MVS/XA, MVS JCL, COBOLII, DB2, Command level CICS, PANVALET, TSO, CEDF, VIASOFT SMARTEST.
September 2001 – December 2001. For the WI Department of Administration was responsible for the detail design, coding and testing of CICS, COBOLII, VSAM systems for small file maintenance.
Because of the small size of the files, they are loaded into main memory at user log-on time using the CICS LOAD PROGRAM () SET ADDRESS OF () command, thus establishing addressability through the linkage section. Files are read from main memory, get updated as VSAM, and then the VSAM data gets re-loaded into the main memory program locations. Three on-line systems comprised of two programs each were developed.
Environment: AMDAHL AND HITACHI 3090 clones, OS/MVS/XA, MVS JCL, COBOLII, Command level CICS, PANVALET, TSO, CEDF, VIASOFT SMARTEST.
June 2001 – August 2001. For SPR consulting and Great Lakes Higher Education, was responsible for the detail design, coding, and testing of a CICS, COBOLII, DB2, program for student account inquiry. The program allows the user to select: the account, account variables, control break criteria, data format, and browse 'page'.
The program code: validates the user input, moves the user input to a screen 'shadow area' in the commarea, queries the data base according to the select criteria, dynamically calls several subroutines, calculates screen information, and writes the screen information to Temporary Storage queue pages. Commarea data, TS Queue data, and internal program logic allow the user to skip directly to either the desired control break or the desired TS 'page' of data. Environment: IBM 3090, CICS, DB2, COBOLII, OS/MVS, TSO, PANVALET, CEDF, VIASOFT SMARTEST, FILE-AID for DB2, SPUFI.
January 1999-June 2001. For Cap Gemini Consulting worked the following assignments.
June 2000 - June 2001. For the WI Department of Health and Social Services, was part of the KIDS development administration team, and also the programming team responsible for extracting the child support and related data from an IMS database, and reformatting the data for the new DB2 database.
Was individually responsible for the detail design, coding and testing of a COBOLII system for matching child support related debts to the proper debtors and time periods, amortizing debts and interest, and reformatting the data. The program code loads SAM records into numerous tables, performs inter-related table look ups, amortizes old debts and interest, and reformats the data into the format needed to load the 'KIDS' DB2 data base tables.
Prior to joining the conversion team, was part of the administrative and QA/QC team overseeing the design and function of the KIDS system.
Environment: AMDAHL and HITACHI 3090 clones, OS/MVS XA, MVS JCL, VSAM, TSO, PANVALET, COBOLII, ABENDAID.
June 1999 – June 2000. For the WI Department of Transportation was responsible for the detail design, coding, and testing of COBOLII systems for loading and maintaining the new highway inventory DB2 database. Was also responsible for the analysis, design, coding, testing, and implementation of the COBOLII DB2 dynamically called subroutine for the conversion of highway segment location data from the visual to the new GIS location system.
Control break COBOLII, DB2 programs assemble highway inventory data. At control break time the COBOLII DB2 subroutine gets called to convert the highway segment from the visual to the GUI location system. The inventory and location data are then used to build the DB2 database tables.
The highway maintenance system uses QSAM input to update, and sometimes move inventory data from the old highway segment (DB2 table rows) to the new.
Environment: AMDAHL and HITACHI 3090 clones, OS MVS/XA, MVS JCL, VSAM, TSO, ISPF, COBOL, COBOLII.
January 1999 – June 1999. For the WI Department of Industry, Labor, and Human Relations, was responsible for the design, coding, testing, user sign-off, and implementation of a CICS, COBOLII, VSAM system for on-line financial account browse and update. The system allows the user to browse financial accounts, and set flags on individual records. The flags trigger dunning letters in the batch system. Environment: AMDAHL and HITACHI 3090 clones, OS MVS/XA, RACF, MVS JCL, VSAM, TSO, ISPF, COBOL, COBOLII, CICS.
September 1998 – December 1998. For the Chicago Board of Trade Clearing Corporation, was responsible for the developement of a new CICS financial transaction browse and allocation system. This CICS system allows brokers to select, browse, verify, and further allocate recent trades.
Rewrote the margin calculation program. The margin calculation program makes extensive use of tables. Standard Portfolio Analysis of Risk parameters are read from two files into seven tables. The day's trades are read into a different table, with control breaks on firm/account/origin. Margins are calculated after looking up the SPAR parameters and considering all possible hedging.
Margin requirement data is summarized by exchange, commodity, financial group, inter-commodity spreads, inter-month spreads, and firm portfolio, in summary tables. The summary data is then written to an output file which interfaces with the margin reporting system.
The margin calculation program is largely responsible for over $200 million nightly in margin requirements. The overnight interest from the margins held accounted for approximately half the CBOTCC’s operating revenue.
Environment: IBM 3090, OS MVS/XA, RACF, MVS JCL, VSAM, TSO, ISPF, COBOLII, CEDF, and ABENDAID.
May 1998 - August 1998. For ISSC, a health care insurance software provider, joined the programming team responsible for converting an on-line claims handling system to accept batch claims submission via tapes, from two outside sources. For this client wrote a COBOL sort/merge program of incoming files, report program of new claims to be viewed on-line, and produced production JCL for the next release of the software.
Environment: IBM 3090, OS/MVS, COBOL, TSO, ISPF, IDCAMS, FILE-AID, INTERTEST, PANVALET libraries.
November 1997 – March 1998. For Philip Morris/Kraft/General Foods, was responsible for the detail design, coding, testing, and documentation of new promotional coupon processing reports and forecasts. The programs validated user variables entered in the JCL, and used the variables and COBOL internal sorts to produce control break reports and forecasts, according to user request. The forecasts were calculated from existing data in the coupon history system, and were used to predict sales and redemptions as a result of coupon promotions on food products such as Jello. Maintenance was also performed on the existing report and forecasting systems. Environment: IBM 3090, batch COBOL.
March 1996 - October 1997. For Hartmarx Specialty Stores Inc., a national clothing manufacturer and retailer, was responsible for the user contact, requirement determination, analysis, design, coding, testing, implementation, documentation, and maintenance of a new month-end reporting system. The system reports sales, discounts, expenses, freight, and profitability by department, store, and company. COBOLII batch programs write entries to a new KSDS file, and also interface the entries with a McCormack and Dodge general ledger system. Menu-driven on-line programs browse the new data.
CICS programs were developed to submit MVS JCL which calls jobs to direct detailed hard copy reports to the user's remote printer. The CICS programs were used to accept variable input from the user and start up ad-hoc batch reports.
Was also responsible for the user contact, requirement determination, analysis, design, coding, testing, implementation, documentation, and maintenance of new systems for: Aging Accounts Payable report, Duplicate Invoice reports, and Payment History report. New batch COBOLII programs and MVS JCL produce and maintain data for the Payment History system in a generation data group. Via CICS programs, users can customize their reports, select printers, and submit the report jobs, unassisted. The CICS programs validate and pass the user variables as JCL symbolic parameters to the MVS internal JCL reader, via a Transient Data queue. Batch COBOLII programs access the parameters via the LINKAGE SECTION, and pass needed parameters on as JCL condition codes. JCL condition code testing determines which steps of the reporting job stream execute.
These programs were the first COBOL and CICS programs written for the Accounts Payable system, and served as skeletons for future development. The remainder of the Accounts Payable system is written in Gamma, a 4GL CASE tool. Light maintenance was also performed on RPGII programs residing outside the Accounts Payable group.
Environment: IBM 3090, OS MVS/XA, RACF, MVS JCL, VSAM, TSO, ISPF, Gamma, COBOLII, CICS, CEDF, ABENDAID, INTERTEST, XPEDITOR, and FILE-AID.
September 1995 – March 1995. For Neosynetics, an IBM business partner conversion specialist, and a national insurance company, was responsible for the design, coding, testing, implementation, and modification of IBM on-line data entry systems. Three menu-driven Command Level COBOLII CICS systems were developed and later implemented on the target IBM MVS mainframe. The data entry programs validate, add, insert, update, delete, and browse data entry records using either a primary key or an alternate KSDS index. The systems comprised the majority of the data entry for a newly acquired subsidiary. The systems covered auto, health, life, premiums, claims, payments, and reinsurance. Other responsibilities included developing and testing production MVS JCL job streams up to 45 steps in length.
Environment: IBM 3090, OS MVS, COBOLII and CICS, MVS COBOLII, BMS, MVS JCL, VSAM, TSO, ISPF, CICS, CEDF, ABENDAID.
December 1994 – August 1995. As a programmer/analyst for Medline, a healthcare supplies company, was part of a production support team that maintained the on-line order entry, batch order processing, picking tickets, billing, invoicing, inventory slot, accrued interest, salesman commission, production reporting, and special forms applications.
The production support team worked closely and meticulously on a major project which expanded the customer purchase-order number throughout the entire DP system. This was accomplished without the assistance of a DBMS. The conversion was implemented by the team between Friday midnight and 5:00 P.M. Saturday.
While on the product support team we also developed a new system for an on-line substitute items browse.
Independently, was responsible for the user contact, requirements definition, analysis, design, coding, testing, implementation, documentation, and maintenance of new systems for salesman price lists, and item gross profit listings.
Environment: IBM 3090, OS/MVS, OS JCL, VSAM, COBOLII, CICS, and CEDF.
EDUCATION
University of Wisconsin Bachelors of Science, Psychology Major, plus 23 credits of Business Administration
College of Lake County A. A., Data Processing
Computer Task Group Relational database concepts. DB2/SQL. 3.5 credits.
ACI VSAM
SRA COBOLII
Cap Gemini America Estimating. Advanced DB2.
New Resources Corporation New Methodology
Computer Sciences Corp. Gupta SQLWindows.
Madison Area Technical College
Web programming certificate earned May, 2008. GPA for certificate: 4.0/4.0. C#, ASP.Net using C#, 3 semesters of Java, Web Page coding using XHTML XML and client side Java scripting, Perl, XML, C#, PHP, ASP.NET, PHP, and Object Oriented Analysis and Design. Overall GPA 3.85/4.0.
Contact this candidate