TECHNICAL SKILLS

• Oracle RDBMS
• Oracle PL/SQL
• Pro*C
• Oracle PL/SQL Web Tool Kit
• Oracle eBusiness Suite 11i
• Oracle Forms - versions 2.5
• Oracle Reports - versions 2.5
• Oracle SQL Developer
• Oracle Datamodeler
• Oracle Weblogic Application Server
• Quest SQL Navigator
• Quest TOAD
• ERWin
• Oracle jDeveloper
• PVCS
• Subversion
• UNIX Operating Systems
• Sun Solaris
• IBM AIX
• HP/UX
• Compaq Tru64
• Redhat Linux
• Windows Server
• MS Word
• MS Excel
• MS PowerPoint
• MS Outlook
• MS Access
• MS Visio, MS

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Provide SQL Query Tuning support for the DNA Data Integration team.

Confidential, Chicago, IL

Senior Oracle Developer, Technical Lead

Responsibilities:

• Monitor system health and troubleshoot system issues in a multi-server (Hyper-V Terminal) with Windows 8 Server, Oracle databases (v12c) and Oracle Weblogic Application Server.
• Design and develop Oracle PL/SQL stored packages.
• Model, design and develop and create relational database tables and views in support of Portrait’s Electronic Records Management System.
• Performed DBA tasks including creating/cloning and manager pluggable databases (PDB), starting and shutting down PDBs, creating user accounts, assigning roles, performing Data Pump imports and exports.
• Performed management tasks in regards to the production and development Weblogic application server including starting and stopping the application server and application deployments.

Confidential, Jacksonville, FL

Senior Oracle PL/SQL Developer

Responsibilities:

• Participate in Agile team backlog grooming, design sessions and daily standup sessions.
• Design and develop relational database structures to include database tables, views, indexes and triggers in support of the Claims and Integrity and Analysis (CIA) group.
• Design and develop Oracle PL/SQL backend processing stored procedures and User Interface (UI) application interface components.
• Design and develop complex Oracle PL/SQL stored procedures to provide Application Programming Interfaces (APIs) between C# and MERN User Interface (UI) applications.

Confidential, Chicago, IL

Senior Oracle Developer, Technical Lead

Responsibilities:

• Oversee all design, development and maintenance for a financial data ETL engine and Electronic Record Management System.
• Perform relational data modelling, produce Entity Relationship Diagrams (ERDs) of database structures as well as Data Definition Language (DML) scripts to create database objects.
• Design and develop Oracle PL/SQL Stored Procedures, Functions and Packages.
• Perform analysis for new development of new software products to include a system to system interface exchanging XML via a secure third party interface called Connectware from Fidelity Information Systems (FIS)
• Performed DBA tasks including creating/cloning and manager pluggable databases (PDB), starting and shutting down PDBs, creating user accounts, assigning roles, performing Data Pump imports and exports.
• Performed management tasks in regards to the production and development Weblogic application server including starting and stopping the application server and application deployments.

Confidential, St Petersburg, FL

Senior Oracle Database Developer

Responsibilities:

• Design, Develop and Implement Oracle Database Solutions
• Member of a large team of database developers who work together to maintain and extend system features for the American Express Serve and Bluebird prepaid card system that utilizes an Oracle 11g database backend
• Responsible for providing database technical support for the Customer Service tool and to the Customer Service Technical Support Team
• Design and develop new features for the Customer Service Tool which can include database tables, editioning views, sequences, triggers and stored packages
• Perform software maintenance tasks (bug analysis and corrective coding) on existing software
• Coordinate with .Net developers who develop and maintain the service layer (mid-tier) and user interface

Confidential, Palm Coast, FL

Senior Oracle Database Developer

Responsibilities:

• Design, Develop and Implement Oracle Database Solutions
• Maintain seven (7) Oracle Forms used in a custom designed Oracle based client billing system
• Maintenance includes bug fixing as well as design and development of existing forms enhancements as well as new forms to extend current system functionality
• Maintain six (6) PL/SQL stored packages used in a custom designed Oracle based client billing system Maintenance includes bug fixing as well as design and development of existing package enhancements as well as new packages to extend current system functionality
• Design and develop new Oracle Forms and database objects to meet user needs and enhance system usability
• Maintain the master Entity Relationship Diagram (ERD) for the client billing system and coordinating changes to the database model by other development team members
• Respond to user issues and perform corrective action (production support)

Confidential, Jacksonville, FL

Senior Oracle Database Developer

Responsibilities:

• Design, Develop and Implement Oracle Database Solutions for Confidential Investments
• Manage all Oracle development to product code migrations for a team of Oracle database developers including an offshore team
• Designed, developed and implemented an Oracle PL/SQL stored package that accepts search criteria from a .Net portal application and executes queries based on that criteria and returns PL/SQL REF CURSOR record sets to the .Net portal/Electronic Records Management System.
• Designed, developed and implemented an Oracle PL/SQL stored package that runs as a batch procedure weekly to formulate raw weekly FA performance figures into week, month, quarter and year to date figures for all levels of the corporate Confidential FA hierarchy and stores the resulting data in database tables
• Designed, developed and implemented an Oracle database schema for a .Net portal to display Confidential Financial Analyst (FA) performance figures
• Oracle 10g, Quest TOAD, Oracle SQL Developer

Confidential, Fort Lauderdale, FL

Senior Oracle PL/SQL Developer

Responsibilities:

• Develop Oracle PL/SQL solutions for Confidential Dental
• Designed and developed Oracle PL/SQL stored packages to be used by a .Net front end to submit search criteria and return REF CURSOR record sets
• Provided Oracle PL/SQL mentoring junior developers
• Oracle 10g, Quest SQL Navigator

Confidential, Indianapolis, IN

Senior Oracle PL/SQL and Forms Developer

Responsibilities:

• Develop Oracle PL/SQL and Oracle Forms solutions for the DoD Defense Finance and Accounting Systems
• As a team lead designed, assisted with development and implementation of a reporting tool using PL/SQL stored packages and Oracle Forms that allows DoD employees to tailor report characteristics and generate reports against DoD Accounts Payable database
• As a senior level Oracle PL/SQL and Form developer provided extensive mentoring to 12 junior level developers
• Worked as a member of a team that was tasked with enhancing the DoD Electronic Funds Transfer system to allow the system to maintain a database of “miscellaneous vendors” or venders validated by the IRS as opposed to Dunns and Cage, and provide electronic payments to these vendors from the system
• Developed UNIX shell scripts for executing batch Oracle PL/SQL programs
• Oracle 10g, Oracle SQL Developer, Oracle Forms 9i.

Confidential, Jacksonville, FL

Oracle Financials Technical Support

Responsibilities:

• Support the HR, GL, AR, AP and FA modules of the Oracle 11i eBusiness Suite with a 250+ user base in the U.S. and Canada
• Implemented and customized Oracle Collections to replace a long standing, internal Microsoft Excel based collections system
• Designed, developed and implemented a PL/SQL interfaces between the 11i open interfaces and the Concur Expense reporting system processing 1,000+ expense reports weekly
• Research and resolve reported user interface issues and maintained current 11i patch levels
• Oracle 9i, Oracle 11i (11.5.10), Quest SQL Navigator, Oracle Forms 9i, Oracle Reports 9i.

Confidential, Jacksonville, FL

Oracle PL/SQL Developer/Analyst

Responsibilities:

• PL/SQL developer for Confidential Automotive Dealer Financial Services
• Coded numerous PL/SQL packages that were used by the Java user interface of the Automotive Dealer Inventory Flooring Finance System to interface with an Oracle database
• Designed a data archival and purge system using PL/SQL packages, database triggers and database links to extract code data from the online system and archive it in an offline system, then purging the data from the online system
• Oracle 8i, Quest SQL Navigator, PVCS

Confidential, Jacksonville, FL

Senior Oracle Programmer/Analyst

Responsibilities:

• Supported Bellsouth’s Network Operations web-based PORTAL and Electronic Records Management System.
• Created a proof of concept product, made presentation to users and management, obtained approval and implemented a web-based inventory control system for the Loop Electronics Barcode Inventory (LEBCI) using PL/SQL and Oracles Web Tool Kit
• Using the same methods employed for the LEBCI inventory control system developed an inventory control system for the emergency electrical generator tracking system used by Bellsouth to maintain phone service following natural disasters
• Developed UNIX shell scripts for pulling files via FTP from server to server within the Bellsouth network
• Oracle 8i, Oracle WebDB 2.0, Oracle SQL Developer

Confidential, Jacksonville, FL

Sr Oracle Consultant

Responsibilities:

• Oracle DBA to the Managed Applications division
• Installed 15 Oracle eBusiness Suite (11i) systems for the managed applications division of ADS in Sun Solaris, Compaq Tru64 and Linux environments using the Oracle Rapid Install utility
• Performed numerous 11i system upgrades from 11.5.2 to 11.5.10 using the Oracle AD Patch utility
• Supported the HR, GL, AP, AR, FA and Inventory and Warehousing modules.
• Utilized Oracle Enterprise Manager (OEM) to monitor multiple client 11i systems including Confidential Corp., Confidential, Confidential and Confidential
• Implemented a proof of concept installation of the SCT Banner Customer Interface System for Jacksonville Electric Authority (JEA) during their legacy billing system upgrade
• Designed and developed an interface between SCT Banner Oracle database and the legacy Customer Information System (CIS) using Oracle Pro*C
• Worked as a member of a development team tasked with designing a configurator system for the Confidential ballistic missile system maintenance project
• Conducted numerous user interview sessions to collect and document user requirement specifications for the ballistic missile configurator system
• Translated the documented user requirement specifications into the Oracle Designer2000 CAD system

Confidential, Jacksonville, FL

Oracle Consultant/Developer

Responsibilities:

• Modeled and develop relational databases to contain ocular clinical data from contact lens clinical studies using the ERWin data modeling tool
• Design and developed Oracle Forms applications used by clinical research personnel to collect contact lens clinical study data
• Developed UNIX shells scripts to perform mass text file manipulations using the SED editor

Confidential, Jacksonville, FL

Oracle Consultant/Developer

Responsibilities:

• Develop and maintain Oracle Forms for clients including Confidential & Confidential
• Develop and maintain Oracle Reports for clients including Confidential & Confidential
• Develop complex SQL queries based on business and technical requirements to be used in a Mortgage Loan processing system being developed for Confidential Mortgage Services.
• Consulted with Confidential of Florida on the development of processes to create and refresh test databases in support of a healthcare claim processing system.