Career Focus
Information Technology specialist with established expertise in relational database design, database management systems, systems design, programming, and vendor applications with broad exposure to various hardware platforms and to various database products and software development tools.

Professional Experience:

• Provided programming and implementation support to the company’s Food Distribution clients in their use of the EAGLE system (Synergy/DE)

• Provided maintenance support of COBOL/390 programs comprising the insurer’s iSave DB2 application for Flexible Spending Accounts and Healthcare Savings Accounts.

• Designed, coded, and tested COBOL/390 program to purge member information for Asthma and Low Back Pain diseases from the DB2 Care Management database
• Coded and tested various DB2 stored procedures used to provide data from the Care Management database to a PC application written in Visual Basic V 6.0
• Developed, in conjunction with business partners, an improved data model of the Care Management database and a new Batch process that more efficiently supported the CIGNA Well Aware product
• Coded and tested complex COBOL/390 program to assign disease stratification level for Care Management members based on data content of Inpatient, Outpatient, and Pharmacy claims
• Prepared technical specifications for converting existing Managed Care DB2 database to a combined Managed Care/Self-Directed DB2 database

• Designed, coded, and tested COBOL II programs to convert data in AMBS DB2 tables to the proper format to interface with the TESSERACT human resource system. Modified and tested COBOL II programs using Dialog Manager to support the new DB2 data structure
• Designed, coded, and tested COBOL II programs that accessed IMS and DB2 data stores to provide accurate cost of sales information to the Cost Accounting users
• Designed, coded, and tested complex JCL stream executing COBOL II programs and DYL-280 programs accessing VSAM data stores to provide reports of sales and charge back data required for government compliance audits
• Coded, and tested various Oracle PL/SQL procedures to load/maintain a new Oracle business data warehouse using the CARS/IS system as the data source
• Designed, coded, and tested Medicaid reporting application using Visual Basic, ADO, Oracle, SQL*Plus, SQL*Loader and Crystal Reports
• Designed 15-table database in Microsoft Access as a data store to capture the annual budgeted expenses of all cost center managers
• Developed a Microsoft Access application to aid General Accounting in estimating its monthly liability accrual for rebate payments to customers
• Developed an Access/Excel application to assist the Cost Accounting department in meeting its deadline for the monthly reporting of Raw Material, Packaging and Finished Goods inventory
• Developed a Microsoft Access application to assist the Cost Accounting department in reporting monthly production volumes to upper management in both Finance and Manufacturing areas
• Designed, coded, and tested interface processes for transferring data to/from SAP and Hyperion financial reporting systems using Oracle PL/SQL procedures, functions, and packages, SQL *Plus and TOAD

• Designed, coded and tested changes to the IMS batch and IMS on-line COBOL programs supporting a Bill of Material interface from the mainframe to an AS/400 using IMS DB/DC, DB2 and MQ Series
• Designed, coded, and tested COBOL programs to convert IMS BOM data of various business entities for loading to JD Edwards
• Designed, coded, and tested COBOL program to load data of acquired business entity to in-house IMS Bill of Material database; designed, coded, and tested COBOL inquiry program providing the same business entity on-line access to BOM data under IMS/DC
• Designed, coded, and tested COBOL BMP and batch programs accessing DB2 and IMS data stores to update Inventory database to support implementation of the Standard Cost conversion project
• Modified and tested various Balance System COBOL batch and on-line DB2 programs in support of the ME Sustaining project
• Coordinated data cleansing of part number control (PCTL), ICON and PARS/PARC (BOM) databases; coded and tested COBOL programs to load cleansed data to MACPAC IMS database
• Tuned DB2 embedded SQL to reduce batch run times by 75 percent

• Converted claims system from DMS to CICS running under DL/I
• Developed a customer tracking system under CICS

• Performed programming duties using COBOL and IMS DB in support of changes required for Directory Assistance processing
• Developed a billing system using COBOL and IMS DB for the company's CONNET service
• Converted the company's intrastate customer history system from a flat-file system to an IMS database system
• Using Structured Methodology Design techniques, participated as a team member in the design and coding of a VSAM-based application written in COBOL for reporting information on the company's SELECT-A-CALL service plan

• Designed, coded and tested various COBOL programs required for the VSAM-based Production Accounting system implemented at the Greenwich, Dallas, and Seattle locations
• Designed and specified processes coded in COBOL that supported various business functions at the newly acquired Oconomoc location including product delivery ticket generation, customer statement generation, and integration of the billing system data with the Accounts Receivable system
• Designed and specified data entry RPG programs required to convert the Greenwich product delivery ticket application from a 3790-platform to an IBM 5280 platform

• Designed, coded and tested COBOL programs required to convert the Branford division payroll system executing on a Honeywell platform to the MSA packaged software executing on a Unisys Mainframe
• Designed, coded, and tested a complex COBOL program to properly allocate support department costs to appropriate manufacturing departments
• Designed, coded, and tested various COBOL programs to convert the Branford division chart of accounts to the MSA General Ledger system
• Designed, and specified data capture processes required for entering Kravex division journal entry information into the MSA General Ledger system; supported Kravex division IS and Accounting staff in the implementation of the MSA General Ledger system

• Maintained and supported Corporate WANG Payroll System
• Designed, coded and tested complex COBOL programs and report writer process required for the timely generation of vacation paychecks for 1000-plus factory workers
• Served as the primary IT liaison to the Corporate Tax and Accounting departments to support the implementation of the McCormick and Dodge Fixed Asset system.
• Modified COBOL programs accessing a TOTAL database to provide additional business functionality to the Canadian division’s order entry application

Technical Summary

Hardware

• Compaq, Gateway Intel Pentium 4, IBM PS/2, Pentium 4/Xeon Servers, IBM 3090, 3032, 308x

Operating Systems

• Windows (95, 98, XP, 2000 Pro, 2000 Server), OS/390, OS/MVS, OS/VS1, VM/CMS

Databases

• DB2, SQL SERVER 2000, ORACLE, Microsoft ACCESS (versions 8.0, 9.0, 10.0), IMS/VS

Languages

• COBOL/390, VS Cobol II, VS Cobol, CICS, Visual Basic 6.0, VB.NET, ORACLE PL/SQL, OS/MVS JCL, CLISTS, JAVA, C Language

Office Automation Software

• MS Office XP Professional

Internet and Intranet

• HTML, MS FrontPage 2000,2002

Utilities

• TSO, ISPF, QMF, SPUFI, SYNCSORT, VM/XEDIT, OS/MVS Utilities, VSAM & VSAM Utilities, Panvalet, Endevor, Librarian, PVCS, Abend-Aid, XPEDITER, File-Aid, Easytrieve, Visio, ODBC, SQL*Plus, SQL*Loader, TOAD, SQL Navigator, Crystal Reports

Education and Professional Development

• University of New Haven, MBA (Accounting Concentration)
• John Carroll University, Bachelor of Arts in Mathematics
• SQL Server 2000 Certified Developer (currently pursuing)
• VB.NET Programming Certification (currently pursuing)

Copyright(c) 1997 Raymond Juris and The Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257