Sr. Oracle Developer
Resume:
Thomas M. Pluth
Huntsville, AL 35802
******@*******.***
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