Rss

Patrick S

Datawarehouse Designer - 10 Years of Experience - Near 53955

Occupation:

Datawarehouse Designer

Location:

Poynette, WI

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

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. Programmer analyst. Work 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. 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.

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom