Oracle Developer

Warrenton Hinton Jr.

***** ********* ***,

Orlando FL 32828

Home Phone: 407-***-**** Cell Phone: 702-***-****

Skillset

Operating Systems Microsoft Windows 3.1, 95, 98, NT 4

Workstation, 2000 Professional, Microsoft Windows

NT Server 4, Hp-Unix, Solaris, AIX, Digital Unix,

VMS, XP Professional

Languages PowerBuilder 6.0, Oracle Forms/Reports 6i, Java,

Informix, PL/SQL, SQL*Plus, C++, Discoverer,

Pro*C, Progress 4GL, Cobol, Ingress, Pascal, Ansi

C

RDBMS Oracle DBMS, Access, Sybase System10, DB2, Informix

7x, Progress

Development Tools Oracle Developer (Forms 6i, Reports 6i,

Designer, Discoverer), Erwin, Jdeveloper, Micro

Strategy 7i, Borland C++

Application Servers Micro Strategy, Oracle Financials, Oracle

Ebusiness Delivery Return Modules, Source

Modules, Finance Modules, IMail Server, Crystal

Reports 8, Retek Merchandising, Retek Data

Warehouse, Retek forecasting, Retek Distribution

Web Servers Internet Information Server 6, Apache Web server

Internet Technologies Active Server Pages / ASP.NET, JavaScript,

JSP, MTS, COM+, COM, ADO, ADSI, OLDEB, ODBC

Scripting Languages Java Script, Shell Scripting, Windows

Scripting

Versioning Tools Continuous, PVCS, Dimensions, ClearCase,

ClearQuest

Server Mgmt Tools IpMonitor, SecureCopy, SecurityExplorer,

WebTrends, IIS Export Utility

Protocols TCP/IP, SNMP, SMTP, FTP, X.25,

PPP, WWW

Qualification Summary:

Extensive experience with ERP and RICE development

Several years experience with Governmental and DOD programs

Extensive experience with Oracle Financial Applications

Experienced with Oracle 11i implementation, Oracle 12i Implementation

Experienced with Oracle AIM Methodology

Education-

BS Computer Science, American Sentinel University

Technical Diploma, Computer Science, Commonwealth College

Minor Computer Science, Tidewater Community College

Security Clearance: Active Secret Clearance

Experience:

CACI March 2008 -

Present

Senior Oracle 12i Oracle Ebusiness Consultant/Lead: Experience and

Technical knowledge of Oracle Development tools including

Experience with the Oracle technology stack (Oracle RDBMS, Oracle

Developer, Oracle JDeveloper, PL/SQL development, Oracle Forms, Oracle

Reports)

Experience working with application design principles and product

configurations

Experience with a multi-vendor, best-of-breed application solution

Excellent written and verbal communication skills.

Experience and Technical knowledge of Oracle Development tools

including

o Oracle Developer

o Oracle Forms

o Oracle Discover

o Oracle Workflow

o Oracle BPEL-PM

Experience with establishing and adhering to technical development

standards

Good analytical, prioritizing, forecasting and problem solving

skills.

Experience and knowledgeable of Oracle AIM documentation -

specifically MD.020, MD.050, MD.070

Excellent interpersonal skills to interact harmoniously with client

customers and team members.

Experience working with appropriate programming languages,

operating systems, hardware and software

Ability to work in a team environment

Principal Duties and Essential Functions:

Lead Development team in Technical Designs and Development

Directly responsible for 16 Developers and technical designers

Design and development of RICE standards

Developing and documenting technical procedures for installing

and executing RICE objects

Participates in business process solution development workshops

to gain understanding of solution requirements

Analysis of ECSS requirements to establish RICE development

requirements

Designing the technical RICE specification to meet the business

process requirements of the ECSS solution

Developing RICE objects to meet the business process requirements

of the ECSS solution

Support and participation in Solution Design/Development Labs as

necessary

Coordination and support of program testing requirements

Developing and documenting technical specifications (MD.070)

Assisting Functional consultants with documenting RICE functional

specifications (MD.050)

Work with Functional Team to define RICE functional requirements.

CNSI

May 2007-March 2008

Sr Oracle Consultant: U.S. Census Bureau: As Sr. Oracle BPEL SOA Developer

defined requirements and developed documentation and training materials for

in-house bpel developers. Assisted, trained and provided support to in-

house developers on BPEL related issues and development. Results include:

Setup for Database Alerts; defining Data Architecture for Data Loads and

updates; developing BPEL interfaces using oracle BPEL Adapters such as

Oracle advance queues, FTP file Adapter, Database Adapter and File Adapter;

Setup and configured Client Link and Partner links; defined BPEL

Activities, such as Assign, Reply, Invoke, Receive, Sequences, Switch,

Otherwise and Fault handlers; used Oracle BPEL console and Process Manager

for monitoring processes. Modified; and also troubleshot BPEL XML to meet

business requirements for BPEL processes.

Mastech Inc.

Mar 2007-May 2007

Sr Oracle 12i Ebusiness Consultant: Oracle Corp: project GCSS-MC for U.S

Marine Corps in Quantico. Functioned as Sr. Oracle (11i) Applications

Developer (Interfaces, Extensions Team), defining requirements for

developing extensions to enhance the functionality and meet GCSS-MC

requirements. Defined/Mapped requirements for development of Interface

extensions from Legacy System to Oracle Applications. Toad, PL/SQL, Oracle

Aim Methodology, Oracle Work Flow, Oracle Warehouse Builder

Abacus Solutions

Nov 2006-Mar 2007

Sr Oracle 11i Ebusiness Consultant: U.S Air Force: Functioned as Sr. Oracle

Financials Developer. Developed financial reports in Oracle; Developed

Stored Procedures, Functions, Operating Statements, Balance Sheet, GL

Detail Report, and Prepaid Report: and developed Extensions; Used TOAD;

and worked with end user defining requirements. Designed custom

responsibilities and menus, and partnered with DBA to set up web server for

self-service applications.

Keane Inc. Mar

2005- Nov 2006

Oracle 11i Ebusiness Consultant - Zachry Construction Corp. Functioned as a

SR oracle developer/lead, Production Support in an Oracle Applications

environment. This role encompassed full life-cycle development including

CMMI Level II, requirements gathering, development, and migration to

production. This role also encompasses training other developers in PL/SQL,

Forms, and Reports, working with Keane offshore in India in coordinating

projects, projects requirements and testing. Also provided support for

some Data Base Administration Functions.

Oracle application development consisted of (Forms/Reports 6i) for 11i

applications and Inventory Management. Also conducted Oracle Workflow

customization, workflow builder. Toad, SqlPlus, Enterprise Manager,

SQL*Loader. Held weekly meetings with Keane India to discuss project

requirements, project status and completion and coordination of

on-shore testing.

Software Development and application support modules consisted of

Manufacturing (WIP, BOM, Inventory, MRP), Procurement (PO, ICX), Finance

(AP, GL, AR), Quality (QA) and Project Control (PJM, PA). Discreet

Manufacturing and Kintana source control. Support also consisted of

multiple 3rd party applications.

Unisys Corp (Las Vegas, Nevada)

Nov 2003- Mar 2005

Sr. Oracle Ebusiness Consultant: This project involved Developing Software

Systems, Supporting Oracle Financials 11i, Stored Procedures, Forms

Customization, Reports Customization, Triggers, End User Support,

IntegrationTesting

Technology: Oracle 9i DBMs, Maximo, Oracle Financials 11i, MicroStrategy,

PL/SQL, Discoverer and Oracle forms/Reports 9i & 6i.

Responsibilities:

. Involved in managing, architecting, testing, deployment, and monitoring

of the software projects

. Managed and Developed Oracle Reports, Stored Procedures, Oracle PL/SQL,

Oracle forms/reports, Visual Basic, Access, and Micro Strategy Reports

. Designed Oracle Financials 11i reports for Accounts Payables and

Receivables

. Developed Process Flow Diagrams and Data Flow Diagrams using Oracle

Designer

. Created Database tables, Logical/Physical model, ERD Diagrams

. Developed Monthly and Yearly accounting reports using MicroStrategy and

Discoverer

. Responsible for the management and training of developers

. Managed Development of new Systems using Oracle forms/reports 9i,

Discoverer

. Lead Architect and Developer implementing Oracle Financials 11i

. Capability Maturity Model Integration

. Developed Equipment Maintenance reports using Maximo's Actuate language

Nexcom (Naval Exchange Service Command)

May 2001-Dec 2003

Sr. Data Architect/Oracle Retail:

This project involved building and managing a data warehouse. The data

warehouse will provide a means of inventory movement, inventory

replenishment, vendor performance, and inventory visibility in the

warehouses. All programs were fully documented and Oracle Designer was

used as a data dictionary.

Technology: Oracle Forms 6i, Oracle Reports 6i, Erwin, SQL*Loader, PL/SQL,

Shell Scripting, Enterprise Manager, HP-UX, Micro Strategy.

Responsibilities:

. Was responsible for the lead development in a Data Warehouse environment.

. Lead Developers, DBAs, System Administrators and Network Administrators

. Designed Logical and Physical model for Data Warehouse

. Designed federated Data Marts for performance enhancement

. Used Oracle Designer as Information Repository

. Developed MicroStrategy and Oracle reports

. Developed PL/SQL data load programs for cleansing and loading data from

Legacy Systems

. Developed Shell Scripts for execution of nightly batch processes

. Used Oracle Explain Plan for tuning SQL Statements

. Was responsible for developing coding standards and interface standards

for all systems

. Was responsible for overseeing all database changes and architectural

changes for all Enterprise Systems

Intecs International (Newport News, VA)

Nov 1999-May 2001

Sr. Oracle Consultant Oracle/C++ Developer: This project involved

developing a Data Mart used for decision support to monitor and track

shipping of equipment, and the time it takes to deliver equipment to it's

destination to determine where improvements need to be made. Developed a

transactional system used for data entry of equipment, input equipment

dimensions, and inventory tracking. Oracle Replication was used to

replicate data to a remote data warehouse. Approximately 30 oracle forms

were developed, approximately 20 oracle reports were developed, and 40 C++

programs. Erwin was used for Data Modeling. Weekly meetings, with upper

level management personnel attending, were conducted to discuss progress of

project, and to review methodologies. Met weekly with users to review

functionality issues.

Technology: Oracle Forms 6i, Oracle Reports 6i, Apache Web Server, Erwin,

Oracle Enterprise Manager, PL/SQL, Borland C++, SQL*Plus, Windows NT Job

Scheduling, Microsoft Project

Responsibilities:

. Responsible for architecting, testing, deploying of equipment tracking

system and data mart

. Developed Oracle forms/Reports, Stored Procedures, Functions, Triggers

and PL/SQL Programs

. Developed Data Model and ERD Diagrams using Erwin

. Developed Fact Tables, Dimension Tables, Staging tables, C++ programs,

and Stored Procedures for data mart

. Developed Oracle Forms/Reports 6i, and data model for transaction system

. Developed ETL process using C++

. Created staging tables for data cleansing

. Created tables, table spaces, indexes, primary keys and foreign keys

. Installed and configured Oracle Replication Manager

. Provided documentation and training to users

. Solved all database issues and hardware issues

. Authored the methodology and development process for the Data Mart and

transactional system

. Was sole developer on this project and provided training, development,

data modeling, oracle database administration, project tracking,

configuration and documentation for both the data mart and the

transactional system

Canon Virginia Inc. (Newport News, VA)

Nov 1998-Jan 2000

Sr. Oracle Ebusiness Developer/Project Lead: This project involved

migrating from a legacy system developed in RPG IV running on an AS400 to

Oracle Financials, Oracle Manufacturing NCAA version 10.7, I2 Supply Chain

Management and EDI report development using Optio. Customized existing

modules (i.e., Accounts Payables, Receivables, Fixed Assets, BOM,

Inventory, and Work in progress) and developed new modules. Developed

stored procedures; did Oracle forms/reports; and was responsible for the

management and administration of I2 Supply Chain Management Software.

Worked with Accountants to define new functionality.

Technology: Oracle Forms, Oracle Reports, Oracle Financials, Oracle

Manufacturing, Oracle Discoverer, Optio, Supply Chain Management

Responsibilities:

. Customization of Oracle Manufacturing and development of extensions to

Oracle Manufacturing

. Customization of Oracle Financials and development of extensions to

Oracle Financials

. Administration of I2 Supply Chain Management

. Development of Oracle forms/reports

. Development of Oracle Discoverer reports

. Development of EDI documents using Optio Software

. Development of Stored procedures and triggers using PL/SQL

. Created tables, indexes, primary keys, and foreign keys

. Provided technical leadership to junior developers

. Converted legacy system processes to oracle

. Tracked projects using Microsoft project

. Documented processes

. Was Sr. Developer/Project Lead implementing Oracle Applications for Canon

Inc. Migrated from a Legacy application written in RPG IV running on an

AS400 to Oracle Applications on a HP-UX System.

Other Projects May 1984-Oct

1998

Sr. Developer/Lead Computer, Hight-Tech Mgmt, VA Beach, VA. (06/98 to

10/98)

Sr. Software Eng/Lead, PowerBuilder 6.0 Oracle DBMS, Cendant Corp, Phoenix,

AZ (07/97 to 06/98)

Sr. Systems Engineer, PowerBuilder 3.0 &4.0 Sybase DBMS, Chrylser Corp,

Whittman, AZ, Contract work, (10/96 - 07/97)

Sr. Software Engineer/Project lead, C#, Informix 4Gl, Informix DBMS, AT&T,

Phoenix, AZ, Contract work ( 09/95 - 09/96)

Sr. Programmer /Analyst, Unisys Corporation, McLean, VA, Contract work,

(07/87 - 09/95)

Programmer Analyst, Uhaul International, Phoenix, AZ, (06/86 - 06/87)

Sr. Network Specialist, Uhaul International, Phoenix, AZ, (05/84 -

06/86)[pic]

Contact this candidate