Software Developer Oracle

Ronald E. Whited

*** ***** **., *******, ** *****

816-***-**** (office) 816-***-**** (cell)

*******@***********.***

SUMMARY

I am looking for software contracts for work in Client/Server, Web or RDBMS areas. Locations outside my commute area will require additional compensation for lodging. This may include activity in development, administration, training and consultation. Personal objective is to build upon the expertise I have gained over the years in enterprise-wide databases, development, administration and training arenas; to enhance projects with a team focus and strong work ethic; and provide financial resources to move into retirement. Payments are best via C2C or 1099, to enhance flexibility and tax planning for both parties. No benefits are required. Willing to work from virtual office, traveling when necessary.

SKILLS

Front-End Development 10 years PL/SQL, ColdFusion, Transact SQL, Oracle SQL, AJAX, DOM, CSS, Javascript, Java, Oracle Forms, Reports, HTML/DB, Application Express

Middleware Development 10 years PL/SQL, ColdFusion, Oracle Forms 4.5, Reports 2.5/3.0, HTML/DB, Application Express, Java, Eclipse Application Servers

Back-End Development 20 years PL/SQL, Pro*C, C, Java, UNIX Shell, Oracle SPU's and Triggers

Database 20 years Oracle 7.x, 8.x, 9i, 9i PE, 10g, 11g, MS SQL Server, MySQL

Oracle Programming 20 years PL/SQL (packages, procedures, functions, triggers), SQL, data

modeling, data conversion, SQL*Loader, Import/Export

Others 30 years UNIX/Linux, shell scripting, Windows 95+, DOS, C Language, Javascript, CSS, AJAX, Transact SQL, DOM, ColdFusion, awk, Eclipse IDE, vi, TOAD, SQL Developer, Oracle database tuning, SQL application tuning

Business Areas Telecommunications, Engineering, Manufacturing, Health Care, Government, Retail, Financial, Consulting, Energy

PROFESSIONAL EXPERIENCE

1994 to Present

ObjectSense, Owner/President (Liberty, MO)

Manage software development company and affiliates to profitability.

Direct sales and marketing activities, securing most business personally.

Deliver many customer and professional presentations.

Performed systems analysis, systems design, data modeling and tuning for several projects.

Configure, administer, and maintain several Oracle instances on Linux platforms.

Developed software for a substantial portion of our projects.

Instructed high-end software courses regularly (UNIX, Oracle, languages).

Authored four Oracle courses, producing, selling and delivering their courseware.

October 2015 to February 2016

Software Developer for Pioneer Financial Services

Provide software development services on Oracle 11g RDBMS, using ColdFusion, Javascript, AJAX, DOM, and CSS, on a variety of in-house applications, written to facilitate loans to individual, especially those in the military.

Assist in writing ColdFusion modules, components, and functions.

Code PL/SQL SPU's (packages, procedures, functions, triggers) and SQL scripts.

Map business requirements to data model entities.

Use Acrobat, Subversion, Eclipse, TOAD, ServiceNow, Sharepoint, Outlook and Lync.

August 2014 – April 2015

Software Developer for Kansas City Power & Light

Provided software development services on Microsoft SQL Server, using ColdFusion, Javascript, AJAX, DOM, and CSS, on Identity & Access Management application, for protecting critical assets.

Assisted in writing ColdFusion modules, components, and functions.

Coded Transact SQL stored procedures and scripts.

Mapped business requirements to data model entities.

Used Oracle Business Intelligence to provide a wide variety of reports.

Given some exposure to Oracle Data Integration (ETL).

March 2013 – January 2014

Software Developer for Siemens Energy

Provided software development services on Oracle APEX 4.2 application, Product Manager, mainstream application for field and marketing personnel.

Primary architect for iPIP, an interface using PL/SQL, HTML, XSL-FO and Java Stored Procedure to provide highly customized product information to Siemens personnel and clients.

Coded SQL, PL/SQL, Javascript, CSS, HTML, Dynamic Actions on front-end APEX pages.

Coded SQL, PL/SQL, Java in back-end Oracle 11g database.

Data validations performed in the front-end and the database.

Made use of collections when needed to process data in memory.

2006 to 2012

Centralized Metropolitan Physical Therapy Application

Personally developed a completely new application in Application Express (APEX), an Oracle Middleware product, on Oracle 11G database, for 25 Physical Therapy clinics with over 100 clinicians. Modules included administration, scheduling, billing, and electronic medical records.

Designed architecture, data layout, screens, logic and interfaces for entire system.

Created schemas, tables, queries and reports for entire system, loading data into schemas.

Solution was highly customized with extensive PL/SQL, Javascript, CSS, AJAX and back-end UNIX software.

Data validations performed in the front-end and the database.

Provided operating system, database and application tuning. For example, converted slower PL/SQL procedural logic to complex SQL query with multiple set operations and sped up response time by a factor of 10.

Automated complete backup, both physical and logical; and disaster recovery.

1995 to 2012

Instructor-Led and Virtual Training Delivery

Instructed over 55 high-end software courses in Oracle, UNIX, and languages areas.

Partners includes ObjectSense, ProTech Training, ExecuTrain and Step One.

Customers included companies across a wide spectrum, including government, services, retail, manufacturing, financial; such as Wal-Mart corporate and IT, U.S. Marine Corps, Boeing, Hallmark, NAIC, Bank of America; to name only a few.

2003 to 2006

Telecom Revenue Assurance Application

Managed project and coded back-end logic for a significant data warehouse application owned by Engel Consulting, Inc.

System was built on Linux and Oracle RDBMS and included redundant Sun servers with a large SAN for storage.

Principal architect in system, data and logical design.

Configured, administered, and maintained middle-tier application server and middleware software.

Millions of telephone call records and billions of bytes of data, from multiple telephone companies, were aggregated daily into the warehouse for decision support. By tuning both UNIX processes and Oracle DML statements, we were able to insert a million rows in less than five minutes.

Automation was performed using UNIX shell scripts and Oracle tools.

Back-end ETL processes where done via awk, C language, and PL/SQL.

Front-end was Oracle Application Express (APEX).

2002 to 2003

Oracle Database Administration

Provided end-to-end DBA support for all Oracle instances of the city of Kansas City, Missouri. Most were large IBM AIX instances; duties included configuration and administration of these.

Created schemas and tables into which data was loaded.

Interviewed and trained all new employees for their Oracle DBA position.

Tuned Oracle instances and recommended SQL changes for faster application responses.

Provided for physical and logical backup; and hot standby systems

1996 to 1999

Shipyard Scheduling Application

Developed a scheduling application on Oracle HTML/DB (forerunner of APEX, an Oracle Middleware product) for the Norfolk, Virginia shipyards

Partner was Computer Instruments, Inc.

Wrote most of the code.

1994 to 1996

Other Activities

Internal product for ObjectSense, CardShoppe; an electronic shopping mall. (1996)

Internal product for ObjectSense, CardSense; a high-transaction credit card engine (1995)

Developed SQL, PL/SQL, DBA, Developer/2000 ObjectSense courseware (1995+)

Managed an Oracle Forms application for an engineering firm (1994)

Built and managed Sense companies websites, back-end in UNIX shell and C (1994+)

Started computer business and led technical support for AT&T Computer Systems (1984+)

EDUCATION

William Jewell University at Liberty, Missouri

Bachelor of Science in Business Administration, Management - 1988

Contact this candidate