PL/SQL Developer

Vernon L. Jones

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

Dallas, TX 75218

Cell: 214-***-****

E-mail: **************@*****.***

LinkedIn: Vernon Jones using **************@*****.***

Technical Knowledge Summary

Oracle RDBMS (20+ years)

Oracle Pro*C

Versions 6, 7, 8, 9, 10, 11, 12

Oracle Reports

Oracle 10g, 11g, 12c RAC/ASM

Oracle Forms 3.0, 4.5, 5.0

Oracle PL/SQL

Oracle Designer

Oracle SQL*Plus

Cobol (various versions)

Oracle SQL*Loader

TOAD

PVCS

UTPLSQL

Manhattan Associates WMS, MIF, EEM, SCI

UNIX/LINUX (various platforms)

MS Office

PL/SQL Developer

Clear Case

Experience

Over 20 years experience as a Software Engineer and Senior Software Engineer.

Over 4 years experience with Distribution Centers and Warehouse Management Systems, specifically Manhattan WMS (version 2015), including pre-implementation research, implementation and production support of the WMS applications. For Integration platforms, used the Manhattan MIF application to translation and modification of xml files and web messages into and out of the Manhattan WMS application (Webmethods). Also worked with Java front end applications.

Oct 2015 –

May 2020

Nov 2014 – May 2015

Tuesday Morning

Dallas, Texas

PL/SQL Developer

Created, updated and supported Tuesday Morning’s Distribution Centers using Oracle 12. Supported the Manhattan Warehouse Management System, also wrote and maintained Cognos reports. Worked with other business units and the QA team to implement updates and upgrades to the applications.

Matrix (ETCC)

Dallas, Texas

PL/SQL Developer III

Created and updated PL/SQL packages, procedures, functions and other database objects for the ETCC application code. Also performed unit testing and functional testing of the ETCC application. Coordinated with the QA team and management for delivery of projects.

Feb 2005 – May 2014

ppoONE (United Health Group / Optum Insight)

Dallas, Texas

Lead PL/SQL Developer / DBA / DBA Manager

Designed, created, maintained and supported PL/SQL code for the ppoONE application, including performance tuning and security management. Also reviewed PL/SQL code written by other developers for correctness.

Manage a team of three Database Administrators and also perform database administration of all ppoONE external client production and test databases, and all internal development, QA and marketing databases. This encompasses as many as 80 databases in 2 physical co-locations. To insure the databases are available 24x7 each production database has a standby database in a separate co-location.

Managed and converted Oracle database upgrades to Oracle 9, Oracle 10g and Oracle 11g.

Managed conversion and maintenance on Oracle RAC/ASM environments.

Assist in the development of interfaces and extracts to and from ppoONE clients including a complete data warehouse extract.

Manage and perform releases from the development phase to final implementation for United Health Group and ppoONE clients in accordance with all SOX regulations. This includes 8 major releases (4 integrated and 4 non-integrated) per year. Additionally there are multiple patch releases per year.

Assist in the United Healthcare annual audits, providing documentation and evidence for deployment and release activities.

Apr 2001 – Feb 2005

ppoONE (Avidyn, Fiserv)

Dallas, Texas

Senior PL/SQL Software Engineer / Database Administrator

Wrote software for health insurance claims processing. Managed other developers in creating new and enhanced versions of the ppoONE repricing application.

May 1993 – Apr 2001

QuadraMed Corporation

Irving, Texas

(formerly Integrated Medical Networks)

Senior PL/SQL Developer / Technical Manager

Performed as manager of various areas over time for the design, implementation, and support (full life-cycle) of business office software applications for hospitals and integrated delivery networks (IDN). Managed groups of employees ranging in size from 1 to more than 10. Participated in and/or managed implementation of programming and development standards and implementation of release control. When not responsible for development projects, responsible for managing support. Utilized Oracle tools almost exclusively. Utilized PVCS for version control/release control.

Business Domain Knowledge Summary

Accounts Payable

FLEX Benefits

Warehouse Management

Accounts Receivable

Human Resources

Notes Payable/Receivable

Commercial

Materials Management

Order Entry

Healthcare

Inventory Control

Sales Order Processing

General Ledger

Physical Inventory

Payroll

Bill of Materials

Purchasing

Point of Sale

Forecasting/Scheduling

Serial Inventory

Time Billing

Invoicing/Billing

Warranty Service

HealthCare Applications

Other

Graduated High School – South Side High School Memphis TN

Attended Memphis State University (University of Memphis). Major was Mathematics and Minor in Physics. Did not receive a degree. GPA 2.5

Vietnam era veteran

Contact this candidate