P aul Capetola
*** ********* **., ***********, ** 19335
*************@*****.***
SUMMARY
More than 20 years of programming and application development experience.
COMPUTER SKILLS
Hardware
IBM mainframes, AS400
Languages
•
Proficient in: COBOL II, COBOL, uScript
•
Familiar with: RPG II
Software
•
VSAM,IDMS,ADSO,CICS,IMS,TOTAL,ADABAS,NATURAL,SQL,FTP,JCL,IBM Utilities, TSO/ISPF,
•
ABEND AID, MS WORD, MS EXCEL, MS ACCESS
Platforms: Microsoft Windows ® 2000, Microsoft Windows XP, OS, DOS, Unix
EXPERIENCE
Consultant, Senior Programmer
1997 Present
Analyst
P SC INC.
Off loaded data from AS/400 using RPG II for use in new Mental Health software package CMHC
•
Installed software at 15 locations within the U.S.
•
Developed and tested new financial reports using proprietary language uScript
•
Developed and tested new billing reports using proprietary language uScript
•
Developed and tested new client demographic reports using proprietary language uScript
•
Developed and tested GUI screens for state forms for ease of use and to be stored and retrieved
•
Developed and tested GUI screens for data entry of client information
•
Created night time batch jobs with software scheduler within Unix
•
Utilized MS Word and Excel to document testing i.e. test data, test conditions, test cycles, test plans, expected
•
results, and problems encountered.
Downloaded NetSmart data using proprietary language uScript into MS Excel and used MS ACCESS to clean the
•
data prior to importing into new software Unicare
Converted Education application from previous software vendor into NetSmart software that included all state
•
reporting and all data entry functions.
Created process for Education department to write IEP report
•
Created process for Education department to write ER/RR report
•
Created process for Education department to write goals and objective for clients
•
Created process for Education department to write template letters to school district and parents in state/federal
•
form format
Automated 270/271 billing process
•
Converted 837I and 837P 4010 format to 5010 version
•
Maintained Philadelphia SEEDS program for all federal and state reporting by extracting data from software using
their proprietary software and putting data in MS EXCEL and sending it through Unix email process
Utilized MS Word and Excel to document testing i.e. test data, test conditions, test cycles, test plans, expected
•
results, and problems encountered.
Lead 1992 1997
Programmer/Analyst
Provident Mutual
Created Automated Pension Group system from the ground up in helping with the design and wrote the
•
application using IDMS database and ADSO for the online application
Maintained the pension group system on line and night time batch processes
•
Wrote specifications for enhancements for the pension system, meeting with end users, testing and
•
implementing the new processes into production
Wrote COBOL program with HTML code to upload to web site to display the current rates for market
•
portfolios
•
•
Consultant 1981 1992
•
Multiple locations
•
Maintained COBOL IMS and OS JCL for Bethlehem and Lukens Steel
•
Part of team that develop order entry system using IDMS and CICS
•
Part of team that maintained manufacturing system using ADABAS and Natural
•
Develop order entry system for major company using COBOL, IDMS/ADSO and CICS. OS JCL used to
•
develop batch jobs
•
•
EDUCATION
Eastern College 1981
St. Davids, PA
B.S., Accounting
•
B.A., Business
•