Business Application Developer

James D. Shaner

*** ******* ***** ******, ** ****3 ********@*******.*** 724-***-****

________________________________________

Qualifications Profile

Motivated, results-driven technology professional with over fifteen years of experience in all aspects of software development including project estimating, requirements documentation and review, application architecture and design, unit testing, QA testing and user-acceptance testing.

• In depth knowledge of electronic claims submission (ECS) and adjudication.

• Effective troubleshooting skills and ability to efficiently implement solutions.

• Ability to keep pace with rapidly changing business environments and technologies.

• Highly skilled developer able to identify and implement business solutions.

• Experience using the agile software development methodology.

________________________________________

Technical Proficiencies

Languages: DIBOL (ISAM), SQL, PL/SQL, UNIX script, COBOL, FORTRAN, Pascal, ESQL/C

Databases: Oracle 10g, 9i, SQL Server, Informix

Operating Systems: UNIX, Solaris, Windows XP/Vista/7

Software: MS Word, Excel, Outlook, PowerPoint, Visio, PVCS Version Control

Development Tools: TOAD, SmarTerm, Oracle Reports, Oracle Forms, SQLLoader

________________________________________

Professional Experience

CVS Caremark Specialty Pharmacy, Monroeville, PA 6/2000 – Present

Business Applications Developer

• Modify stored procedures, reports and forms using Oracle development tools.

• Participate in all phases of software development, including requirements definition, application architecture, and testing.

• Design SQL scripts to create and modify Oracle tables, triggers and permissions.

• Develop UNIX scripts to execute and monitor batch processes.

• Develop SQL queries and PL/SQL code for use both in Oracle and DIBOL modules.

• Participate in on-call rotation and off-hours problem resolution.

• Provide technical leadership to junior developers.

• Make recommendations on coding standards.

• Provide time and cost estimates for several projects.

• Participate in code and design reviews for other developers.

• Examine all possible solutions for business problems and work with business partners to reach consensus on the best solution.

• Utilize source-level debugging tools to locate software defects.

• Ensure system stability by volume and load testing all software, including performance testing connections to remote Oracle databases.

• Worked with the networking group to reduce ECS costs by 10%.

• Designed and built ECS software for NCPDP versions 5.1 and D.0.

• Implemented electronic eligibility transactions for Medicare Part D.

• Key resource in a project to replace an outdated fulfillment system with a new McKesson solution utilizing the Omega Interface.

• Decreased days sales outstanding (DSO) by implementing coordination of benefits (COB) billing at time of dispense.

• Implemented national provider ID (NPI) for electronic claims.

Creehan, McHenry Inc., Pittsburgh, PA 11/1997 – 6/2000

IT Consultant

• Provided software support across several pharmacy systems including order entry, fulfillment, accounts receivable and billing.

• Acted as primary software support for an accounts receivable system for which vendor support was unavailable.

• Participated in a project to replace the existing accounts receivable system with a custom Oracle application.

• Interacted with users and IT liaisons to gather system/program specifications and requirements.

• Performed on-call software and system support.

• Coordinated new software releases and installations.

Stadtlanders Pharmacy, Pittsburgh, PA 1/1996 – 11/1997

Systems Analyst

• Handled software support requests.

• Provided off-hours problem resolution.

• Designed programs to enhance the existing accounts receivable package and order management system.

• Modified existing programs to meet changing business needs.

________________________________________

Education and Training

Bachelor of Science – Information Science

12/1995

University of Pittsburgh

Minor: Applied Mathematics

QPA: 3.59, QPA in major 3.85

Professional Development

Oracle Designer 2000, Oracle Reports, Business Communications for IT Professionals, Project Management for IT, Getting Started With Java

________________________________________

Honors

Appeared on Dean’s List 18 out of 22 terms

Member of Golden Key National Honor Society

Appeared in 1994 edition of All American Scholar

Contact this candidate