Post Job Free

Resume

Sign in

Sr. Oracle Developer

Location:
Huntsville, AL
Salary:
140,000
Posted:
September 30, 2020

Contact this candidate

Resume:

Thomas M. Pluth

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

Huntsville, AL 35802

256-***-****

adgjak@r.postjobfree.com

QUALIFICATIONS SUMMARY

Nearly forty years of professional experience in Information Technology and IT Consulting for the weather, utility, telecommunications, healthcare, fulfillment/repair and space industries and finance disciplines, with experience in all phases of the software development lifecycle, from requirements gathering through post-production support and operations. Extensive experience with data conversions, system interfaces, capacity planning, performance analysis and improvement, and database and system administration of mission critical systems. Over 15 years of experience working with Oracle EBS Financial Applications, IFS, Oracle RDBMS versions 7 through 12, Oracle APEX, Oracle Designer, Oracle Developer Forms and Reports versions 4 through 10g, and Oracle Database Administration.

SKILLS HIGHLIGHTS

Methods &Techniques: ERP (Oracle EBS and IFS), Financial Applications, Supply Chain, Project Management, Data Modeling, Applications Development, Data Conversion, System Interfaces, Applications Implementation, Process Re-engineering, Software Development Lifecycle, System Administration (Unix, Windows & MacOS), Light Database Administration

Oracle Products: EBS 11i and R12 (AR, AR, CM, GL), Oracle 6, 7, 8, 8i, 9i, 10g, 11g, 12c, Designer, Enterprise Manager, PL/SQL, Oracle Discoverer,, SQL*Plus, SQL*NET, Forms, Reports, JDeveloper, APEX

Microsoft Products: SQL Server 2005/2008, Visual Studio, TFS, SSMS, SSIS, Word, Excel, Visio, Project, Powerpoint

Other Products: Crystal Reports, IFS 2003, Pentaho Kettle, PL/SQL Developer, TOAD, SVN, JIRA

Operating Systems: Sun Solaris, Windows (All versions), UNIX, IBM, AIX, Linux, Compaq Tru64 Unix, OS X, MacOS, iOS

Languages: PL/SQL, Java, Fortran, PERL PRO*C, C/C++, UNIX shell scripting (bash,sh,ksh), Several assemblers

Other Proficiencies: Performance Analysis, Capacity Planning, Utility Industry, TCP/IP Networking, Data Warehousing, Billing Systems, Payment Processing, Version Control, Issue Tracking, Finance

WORK HISTORY AND PROJECT EXPERIENCE

Oracle APEX Developer

Bay Systems Consulting, Inc. at NASA Marshall Space Flight Center

September 2019 to March 2020

Develop and customize Finance Applications used to monitor project and funding at numerous NASA facilities. Work consisted of Oracle APEX modifications and SQL & PL/SQL development, including packages, triggers and DDL, plus modification and development of Crystal Reports.

Principal

Tom’s Macintosh Store

September 2016 to September 2019

Online and in-person sales and configuration of refurbished Apple Macintosh computers, including Mac Pro, Macbook Pro, iMac and Mac Mini. Performed evaluation of used systems, remediated any problems, installed value added upgrades (CPU, RAM, SSD Hard Drives and graphics processors). Installed and configured software. Marketed systems on several online websites. Performed after sale customer service and support. Online feedback rating of 100% over more than two years and over 60 systems sold.

Senior Oracle Application Developer

Teleplan, Inc. Roseville, CA

April 2014 to August 2016

Develop custom IFS ERP applications for large, distributed Inventory and Shop Floor systems. Develop Custom Reports, procedures and triggers for integration with Biztalk. Experience developing, maintaining and deploying UDSP, UDP, QRN and IAL objects in a multi-program, multi-site environment. Work with large internationally distributed team using Agile project management methods.

Senior Application Developer

Maximus, Inc, Folsom/Rancho Cordova, CA

September 2003 to November 2013

Development and implementation of Billing and Payment Processing system for the State of California Healthy Families Children’s Health Insurance Program (SCHIP) utilizing Oracle EBS 11i AR, AP, CM and GL modules. Primary responsibility for design, coding, testing and operational implementation of AR payment interfaces, AR statement generation, AP refund processing, and customer data conversion. Provide system support, upgrade and enhancement as required. Development of banking interfaces for payments, receipts and reconciliation. Assist cutover of state Division of Recycling ERP system on EBS R12 and provide support as required. Assist cutover of state HCO system and perform performance analysis and improvement. Implemented letter processing improvements using SSIS.

Independent Consultant

Bonneville Power Administration, Vancouver, WA

June 2002 to April 2003

Development and enhancement of Meter Data Management system to support new billing system. Work included development of PL/SQL procedures, data modeling in Oracle Designer, development of Oracle Forms and Reports, work process re-engineering, database and application performance evaluation and tuning, data quality improvement and bug identification and correction. Developed critical solutions which allowed the customer to have an on-time Go-Live of new billing system for wholesale power sales.

Senior Principal Consultant

Oracle Corporation, Americas Communications Practice, Bonneville Power Administration, Vancouver, WA

December 2001

Design and build Oracle Forms and PL/SQL for job processing and monitoring on billing proof of concept project.

Senior Principal Consultant

Oracle Corporation, Americas Communications Practice, Southwest Gas Corporation, Las Vegas, NV

May 2001 to November 2001

Design and coordinate data conversion and interface activities with customer technical staff for Oracle EBS R11 Finance and Supply Chain implementation. Provide technical support to Oracle functional staff for interfaces, conversions and HRMS application extensions. Assist in Gap analysis between core Oracle product and customer requirements. Research and design customizations to HRMS, Payroll and Benefits applications, Check writer, ADE and other HRMS/payroll utilities. Coordinate conversion and interface related AIM deliverable production. Mentor customer technical staff on AIM methodology and interfaces.

Senior Principal Consultant

Oracle Corporation, Americas Communications Practice, Health Net, Los Angeles, CA

July 2000 to May 2001

Develop PL/SQL interfaces for loading legacy data into online billing system based on Oracle EBS 11i. Develop rating engine for online bill adjustment and payment application. Design and maintain Data Model for custom billing application in Oracle Designer. Assist HTML developers with PL/SQL coding techniques. Assist customer with identification of data requirements and definitions. Contribute to AIM deliverable development. Develop Concurrent Manager Mechanisms for automating interface execution.

Database Architect and Developer

Pacific Gas & Electric, San Francisco, CA

October 1996 to March 2000

Develop and administered an Oracle based Data Warehouse for real-time Energy Telemetry data used for load analysis and system planning. Develop real-time data interfaces to legacy systems using ICCP/MMS protocol as part of California power deregulation infrastructure upgrade. Develop data warehouse interface programs in Visual C/C++. Develop Energy Accounting/Hourly Load Log system for verifying NERC/FERC compliance and auditing real-time energy interchange balances. Plan and implement Windows NT server infrastructure. Support legacy Real-time Energy Control Systems on NOS 2.5. Develop and administer several Oracle 7.3 databases used to support grid operations. Provided 24/7 support of mission critical power control systems, databases and Windows NT file/print servers.

Database Architect and Developer

Siemens Power Systems Controls/Control Data

August 1987 to September 1996

Develop, administer and provide training for an Object based meta-database product, used to maintain consistent power grid definition data for mainframes and workstation systems. Develop custom mainframe applications for real-time energy control. Administer and customize mainframe DBMS server. Support and customize operating system and subsystems on mainframe system. Provide 24/7 support of mission critical power grid control systems and databases. Assume client operations responsibilities during reconstruction of Florida power grid following destruction caused by Hurricane Andrew (August, 1992).

Independent Consultant

Self-Employed

June 1986 to July 1987

Develop custom communications protocols for mainframe system for Continental Airlines used to provide weather and flight planning information to dispatchers.

Supervisor

Global Weather Dynamics

September 1981 to May 1986

Supervise computer operations for real-time weather operations system used by airlines. Maintained virtually 100% uptime of mission critical flight weather data systems. Responsibilities included staff of eight technicians, six different computer systems and global communications system. Train operators and programmers in administration and development of systems. Develop custom interfaces between mini-computers and mainframes. Administer mini-computer and mainframe systems in Saudi Arabia as part of the global weather data communications system.

TRAINING AND ACHIEVEMENTS

Oracle training: Introduction to Oracle – 1992

Forms Development – 1992

Oracle Designer – June 2000

Java/JDeveloper – June 2000

Java Database Connectivity – February 2001

EBS HRMS and Payroll Implementation – Nov 2001

Honors/Awards: Great Performer Award – 1988 – Control Data Corp. EMSD

Telecommunications/Utilities 100% Club Q4 FY01 – Oracle Corp.

Employee of the Month – Maximus, Inc. – Healthy Families Program – July 2008



Contact this candidate