Sign in

Oracle Apex Database Developer

Warrington, Pennsylvania, 18976, United States
January 08, 2018

Contact this candidate

**** ********** *****

Warrington, PA *****



SUMMARY: More than twenty-seven years of experience in software engineering and systems analysis developing software for military and business applications. This includes simulation, real-time and RDBMS software involving communications, data reduction, command and control systems, prototyping, custom and interface development, data and software architecture, database analysis, ETL processing, data warehousing, application development, and report generation.

LAST POSITION: Ally Bank/Signature Consultants

Oracle APEX PL/SQL Developer (November 2016 to May 2017)

Enhanced multiple Oracle APEX applications for bank data warehouse processing. Added report pages as well as substantial back end enhancement for automatic exception handling. Made significant enhancements to negative balance processes.

Skills Utilized: Oracle 12c, PL/SQL, APEX web applications, Data Warehousing, Linux

PRIOR POSITION: United Healthcare Insurance Company

Oracle APEX Application Developer (February 2014 to September 2016)

Supported 12 APEX Oracle12c databases and an MS Access database with an Oracle back end. Successfully migrated several databases from Oracle 10g, APEX 3.0.1 to Oracle12c, APEX 4.2.6. Made several critical enhancements to the database applications to support business needs. Supported IT needs of 400 users by myself; and at the same time made enhancements and migrated multiple databases to newer environments.

Skills Utilized: Oracle 10g, 11g, 12c, PL/SQL, APEX web applications, Linux, XML, Oracle Server, Tomcat Server, MS Access


Senior Software/Database Developer (November 2007 to November 2013)

Developed application software to enhance internal enrollment application for a successful healthcare service provider and insurance company. Developed several key components of a reporting/business application utilized by all the departments of the company. This included developing software to automate the generation of all claims correspondence both electronically and via mail. Developed automated ETL database processes to handle import and export of critical data files from/to our major corporate clients. Managed the execution of critical database processes to maintain integrity of the data warehouse. Developed all database logic to provide reporting to state insurance commissions and underwriting companies. Handled all batch file transfers from/to our corporate partners. Provided all ad-hoc reporting required by every department in the company, creating quick turnaround data reports for clients, partners, and in-house analysis. This included crystal report generation and integration into existing applications. Troubleshot application software and data issues in production and warehouse databases.

Skills Utilized: Oracle 10g, 11g, PL/SQL,, Visual Studio 2008, Crystal Reports XI, Visual Basic 6, Linux Cron, DOS Batch, PSCP, Oracle Server


Senior Software Developer (August 2004 to July 2007)

Developed mortgage application software which originated and processed loans for a leading residential real estate finance company. Efforts included design, development and test of application enhancements and defect resolution. Provided production support by troubleshooting a variety of database, user interface, middle tier logic and data issues. Specialized in product and pricing functionality in Gallagher NetOxygen application and Microsoft Excel application utilizing Visual Basic for Applications. Provided technical input into all business decisions related to product and pricing component of the application.

Skills Utilized: Oracle 10g, VBScript, JavaScript, XML, N-tier architecture, Microsoft Excel Macros with VBA


Senior Software Engineer (July 2000 to July 2004)

Led effort to develop the means to target individual households which subscribe to a cable provider. Developed algorithms to perform targeting in the prototype applications, researching and evaluating consumer data requirements and sources, developing and testing various profiling methods to define the target audience, analyzing the data warehousing requirements, and creating database schema to prototype and optimize various targeting approaches. Led a design team which developed requirements and created a web interface for this Java application utilizing JDBC, SQL Server and MS Access. Developed overall back-end system design and requirements. Developed modules in C/C++ and SQL to handle back-end processes. Supported effort to convert legacy FOXPRO application to Visual C++ application utilizing Windows 32 API and MS SQL Server 2000. Designed, coded, tested, in and documented modules for a media broker application. Created and augmented SQL Server database utilizing DTS, stored procedures and triggers.

Skills Utilized: NT Workstation, Microsoft Access, MS SQL Server 2000, Java, JDBC, Visual C/C++, Windows

PRIOR POSITION: Astea International, Inc.

Senior Programmer/Analyst (October 1998 to June 2000)

Developed specifications and new code to provide customized functionality to customers utilizing a CRM application. Involved with issue resolution and customer support in various areas of the system. Efforts include database modification, application enhancement and interface development and support.

Skills Utilized: PROGRESS version 7 using UNIX on the PC hosting HP and IBM platforms.

PRIOR POSITION: Lockheed Martin Corporation

Software/Test Engineer (December 1996 to September 1998)

Developed and verified test criteria for evaluation of a real-time software segment.

Designed, developed, unit tested and integrated database initialization software used to

initialize software components of a large, real-time software project.

Skills Utilized: Programming in C/C++, PL/SQL, embedded ORACLE SQL, Sun UNIX, IBM AIX. Experience using IBM RISC 6000, Sun Interleaf.

PRIOR POSITION: Environmental Tectonics Corporation

Software Engineer (July 1996 to October 1996)

Resolved several software issues prior to shipment of training device which simulates gravitational forces on pilots. Analyzed and evaluated software requirements needed to drive centrifuge trainer.

Skills Utilized: Microsoft C, MS-DOS, Windows95, Silicon Graphics platforms, UNIX, C++ and X/Motif.

PRIOR POSITION: Computer Sciences Corporation

Senior Software Engineer (November 1992 to July 1996)

Designed, coded, integrated smaller, more efficient processes to replace the message management process, database, and communications management code. Successfully implemented packetization of large overlays in our Command and Control prototype. Supervised and was the team lead for the development of an interface between different Command and Control systems. Designed, developed, unit tested and integrated database interface software for USAF’s Airlift Mobility Command Information Processing System. Wrote numerous stored procedures and triggers using Sybase SQL for the ada application.

Skills Utilized: ALSYS and SCO Ada compilers, Sun workstations, VAX 4000 Workstations using DCL and VMS. Programming in C/UNIX, Sybase SQL and Ada, training in OSF/MOTIF

PRIOR POSITION: Intermetrics, Inc.

Programmer/Analyst (March 1986 to January 1990)

Designed, developed, unit tested and integrated embedded signal processing software for a US Navy submarine detection project. Enhanced post processing capabilities for Navy’s navigational simulator as part of duties for a joint USAF/Navy tactical information distribution project. The application was written in ada on a unix platform.

Skills Utilized: Sun UNIX, ADA, FORTRAN, ADADL, Teamwork.


MA in Mathematics, (January 1990 - May 1991) Villanova University, Villanova, PA.

Post Graduate Studies in Mathematics (September 1983 - May 1985) Temple University,

Philadelphia, PA 19122.

BA in Mathematics (September 1979 - May 1983) Temple University, Upper Dublin, PA.

Contact this candidate