James C. Abel
111 Lake Vista Drive
Hendersonville, TN  37075
Home:  [Send email to request phone number] 26-5658 
    Cell:  [Send email to request phone number] 60-9653  
        E-mail: [Send email using form at bottom]



SUMMARY	A Computer Systems Engineer with several years experience in the
Information Technology industry.  Possesses a strong background in Oracle
programming including PL/SQL packages and stored procedures development, quality
assurance testing, development, customer support, and some project lead
experience.  The most recent IT experience is in the healthcare industry.



CAREER EXPERIENCE

7/08 – 6/09	American HomePatient - Nashville, TN (contract assignment)  
http://www.ahom.com/

•	PL/SQL Developer in the Data Warehousing group using an Oracle 8i database
•	Responsible for writing ETL procedures for Accounts Receivable Journal
Entries, Doctor, Therapist, Referral, and Insurance data
•	Wrote PL/SQL procedures and packages mainly for conversion efforts and for
daily production processing; row sequences and triggers were used for updating
statistical data  
•	Automated several of the current manual processes using TOAD for the
development tool
•	Used WS_FTP Pro to transfer daily production files to an out of state vendor
for processing   
•	Wrote PL/SQL packages to process Pricing data, Convert to Purchase data,
Claims Management data, and Accounts Receivable Collections data
•	Documented EDI Claims information and assisted with programming functions  
•	Performed SQL tuning on several of the procedures to improve efficiency and
performance  
•	Added table indexes to help resolve data efficiency issues

12/06 – 6/08	Healthways - Nashville, TN (contract assignment)     
http://www.healthways.com/

•	Systems Tester in the Quality Assurance department 
•	Performed SQL queries, data mapping,  and setup test tables using TOAD
•	Worked with data analysts to assist in developing an automated testing process
for the 
Claims Utilization Processing System (CUPS) application written in PL/SQL on an
Oracle 9i database
•	Trained the data analysts on using SQL to allow them to locate different types
of data for their test cases/conditions setup  
•	Performed report and data analysis work on SQL Server 2002 and Oracle data
using TOAD
•	Developed several SQL queries for data and report validation efforts

12/05 – 12/06	Centerstone - Nashville, TN (contract assignment)    
http://centerstone.org/

•	Systems Analyst in the Client Information and Billing system
•	Developed and maintained PL/SQL procedures and functions against an Oracle 9i
database on a Unix platform
•	Handled client and therapist information using stored procedures which supply
HTML commands to process online screen data


1/01 – 11/05	Vanderbilt University - Nashville, TN (employee)   
http://www.vanderbilt.edu/

•	Systems Analyst/Developer in the MIS department
•	Wrote and maintained several SQR reports for the PeopleSoft HR/Benefits system
which contained many complex SQL queries along with extensive array processing
•	Responsible for some PeopleSoft menus, panels, panel group development and
testing  
•	Wrote SQRs for interfaces and updates / inserts into the Oracle/PeopleSoft
tables  
•	Developed Business Objects reports against an Oracle database
•	Used Business Objects Designer and developed/maintained Oracle PL/SQL Stored
Procedures
•	Involved in some Java/JSP/XML development

1/00 – 1/01	CNA Insurance - Nashville, TN (contract assignment)    
http://www.cna.com/portal/site/cna

•	Programmer/Analyst in the LifeCAD Investment Products division
•	Responsible for analysis, development, and maintenance of several monthly and
quarterly SQR reports which ran against an Oracle 7 database on a UNIX platform
•	Analyzed, developed, and maintained PL/SQL stored procedures interfaces which
processed deletions, inserts, extracts, and updates of the Oracle database
tables

6/98 - 1/00	Duke Energy - Charlotte, NC (contract assignment)     
http://www.duke-energy.com/North-Carolina.asp

•	Programmer/Analyst in the Human Resources Department for a PeopleSoft 7.5
upgrade project
•	Used PeopleSoft HRMS tables, panels, and SQR modules which ran against a DB2
database  
•	Analyzed, developed, and tested SQR modules using PeopleTools
•	Performed PeopleSoft 7.0 development, enhancement, and testing of COBOLII/DB2
and PL/I programs;  produced design packets for those programs
•	Used SQR Workbench to develop, test, and debug SQR reports running against an
Oracle 7 MAXIMO database
•	Wrote and tested PL/SQL stored procedures for producing files to be used for
SQR reporting
•	Developed and tested several Business Objects reports

4/97 - 6/98	Verizon (formerly GTE Wireless) - Atlanta, GA (contract assignment) 
    
http://www22.verizon.com/?CMP=KNC-CONSBRAND

•	Project Lead responsible for enhancements on a cellular billing system
•	Performed systems analysis using COBOL, COBOL II, and VSAM application
programs
•	Resolved PARs (problem analysis reports)
•	Learned and worked on the Rating portion of the billing system


EDUCATION	Associate of Science degree in Computer Science and Accounting.
		Erie Business Center - Erie, PA   http://www.eriebc.com/
		Career Training - C programming, DB2/SQL, SAS, PeopleSoft HR, Java,
		Business Objects Reporter.


REFERENCES	Available upon request.