The resume has not yet been entered.

 Paste Your Resume goes here. -->
<
             PATRICK SEERY    (608) 221-9309               
                      
SYNOPSIS
Ten years of MVS analysis and application programming. Client/server education plus light experience. Internet Developer Certificate, May, 2001.  Curriculum includes Java, Web Programming using XHTML, XML, and Java scripting,  Advanced Visual Basic, and Active Server Pages.  

OPERATING SYSTEMS AND SOFTWARE
OS/MVS			COBOL					ICCF
OS/JCL			RPGII					CEDF
DOS				DB2/SQL				ABENDAID
DOS/VSE			CICS COMMAND LEVEL		FILE-AID
DOS/JCL			REALIA CICS/COBOLII		PANVALET
VM/CMS 			BMS					EYEWITNESS	
MS-DO	S			VSAM					INTERTEST WINDOWS 98			SYNCSORT               	XPEDITOR       MVS/TSO			GAMMA, a 4GL/CASE tool 	RACF							VIASOFT SMARTEST       	VOLLIE						Gupta SQLWindows        	DADS
				File Aid for DB2		MOVE FOR DB2 
                   	PLATINUM FOR DB2        	LIBRARIAN
			     EASYTEST on-line	   	VISUAL BASIC
				POWERBUILDER			ORACLE
				Active Server Pages		HTML
				J++ Java				IIS

HARDWARE
IBM  30XX      		IBM 40XX  				IBM PS/2       AMDAHL 30xx clones  	HITACHI 30xx clones		IBM 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   GUI conversion						DOT bridge data 	
Financial market Standard Portfolio Analysis of Risk 
Highway location conversion 
Employee Benefit Funds
Claims Processing

EXPERIENCE SUMMARY

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
September 1997-July 1999.  For Seery Consulting worked the following assignments.

May 1999 – July 1999.  For Computer Sciences Corporation, 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 1998 – March 1999.  For American Family Insurance participated in quality control, system, and performance testing 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 1998 – July 1998.  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 version 3.1.2, PANVALET, TSO, CEDF, CHANGEMAN, XPEDITOR. 

September 1994-September 1997.  For Copps Consulting in Hudson, Wisconsin, worked the following assignments.

     September 1997 – January 1998.  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 3090 clones, OS/MVS/XA, MVS JCL, COBOLII, Command level CICS version 3.1.2, PANVALET, TSO, CEDF, XPEDITOR batch, VIASOFT SMARTEST on-line. 

      December 1996 - July 1997.  For the WI Department of Employee Trust Funds, I 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 down loads 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 version 3.1.1, PANVALET, TSO, CEDF, PLATINUM TOOLS for DB2, VIASOFT SMARTEST.
 
     December 1995 – December 1996.  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.  
     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 version 3.1.1, PANVALET, TSO, CEDF, VIASOFT SMARTEST.

       September 1994 – December 1994.  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 version 3.1.1, PANVALET, TSO, CEDF, VIASOFT SMARTEST.

     June 1994 – August 1994.  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 information.  Environment:  IBM 3090, COMMAND LEVEL CICS 3.1.1, DB2, COBOLII, OS/MVS, TSO, PANVALET, CEDF, VIASOFT SMARTEST, FILE-AID for DB2, SPUFI. 
 



January 1992-June 1994.  For Cap Gemini Consulting worked the following assignments.

     June 1993 - June 1994.  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 QSAM 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 1992 – June 1993.  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 1992 – June 1992.  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.  Also converted numerous programs from COBOL to COBOLII.  
Environment: AMDAHL and HITACHI 3090 clones, OS MVS/XA, RACF, MVS JCL, VSAM, TSO, ISPF, COBOL, COBOLII, Command Level CICS 3.1.1, CEDF, and ABENDAID.       

     September 1991 – December 1991.  For the Chicago Board of Trade Clearing Corporation, was responsible for the new development of a CICS financial transaction browse and allocation system, and the current margin calculation program.  The CICS system allows brokers to select, browse, verify, and further allocate recent trades. 
     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.  
Environment: IBM 3090, OS MVS/XA, RACF, MVS JCL, VSAM, TSO, ISPF, COBOLII, Command Level CICS 2.1, CEDF, and ABENDAID.   

     May 1991 - August 1991.  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 9021 OS/MVS/ESA, COBOL, TSO, ISPF, IDCAMS, FILE-AID, INTERTEST, PANVALET libraries.  

       November 1990 – March 1991.  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.  Maintenance was also performed on the existing report and forecasting systems.    
Environment:  IBM 3084, DOS/VSE, VOLLIE, COBOL.
   
     March 1989 - October 1990.  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 interfaces the entries with a McCormack and Dodge general ledger system.  Menu-driven on-line programs browse the new data.  The CICS programs can also submit MVS JCL which calls jobs to direct detailed hard copy reports to the user's remote printer.
     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 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 3084, OS MVS/XA, 3390 DASD, RACF, MVS JCL, VSAM, TSO, ISPF, Gamma, COBOLII, Command Level CICS 2.1, RPGII, CEDF, ABENDAID, INTERTEST, XPEDITOR, and FILE-AID.    

	

September 1988 – March 1989.  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 on an IBM PS/2 workstation, using REALIA CICS and COBOLII, 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.  The systems replaced Honeywell card data input.
     Other responsibilities included developing and testing production MVS JCL job streams up to 45 steps in length, for the converted Honeywell batch COBOL systems. 
Environment: IBM PS/2, and IBM 3084, OS MVS, MS-DOS, REALIA 
COBOLII and CICS, MVS COBOLII, BMS, MVS JCL, VSAM, TSO, ISPF, CICS 2.1, CEDF, ABENDAID, EYEWITNESS, and PIE.  Realia CICS and COBOLII is a PC workstation tool similar to Microfocus CICS and DB2.     


     December 1987 – August 1988.  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 4381, DOS/VSE, 3350 DASD, DOS JCL, VSAM, VM/CMS, RPGII, COBOL, Command Level CICS 1.7, 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 Corporation Gupta SQLWindows.

Madison Area Technical School 	Web programming certificate    earned May, 2001.  GPA for    certificate was 4.0/4.0.      POWERBUILDER, 3 semesters of  VISUAL BASIC, XML, ORACLE,    J++ JAVA, MVS JCL, Web Page   coding using XHTML XML and    client side JAVA scripting,   Active Server Pages using     server side Java              scripting. Overall GPA        3.89/4.0.