SUMMARY:

Nearly forty years of professional experience in Information Technology and IT Consulting for the weather, utility, telecommunications, healthcare and fulfillment/repair industries, 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 IFS, Oracle Financial Applications, 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, Financials 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: Oracle 6, 7, 8, 8i, 9i, 10g, 11g, 12c, Oracle Designer, Oracle Enterprise Manager, PL/SQL, Oracle Discoverer, EBS 11i and R12, SQL*Plus, SQL*NET, Oracle Forms, Oracle Reports, Oracle 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

Confidential

Responsibilities:

• Develop and customize Finance Applications used to monitor project and funding at numerous Confidential 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

Confidential

Responsibilities:

• 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

Confidential, Roseville, CA

Responsibilities:

• 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

Confidential, Folsom/Rancho Cordova, CA

Responsibilities:

• Primary responsibility for design, coding, testing and operational implementation of payment interfaces, statement generation, 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 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

Confidential, Vancouver, WA

Responsibilities:

• 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

Confidential, Vancouver, WA

Responsibilities:

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

Senior Principal Consultant

Confidential, Las Vegas, NV

Responsibilities:

• Design and coordinate data conversion and interface activities with customer technical staff.
• 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

Confidential, Los Angeles, CA

Responsibilities:

• Develop PL/SQL interfaces for loading legacy data into online billing system.
• 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

Confidential, San Francisco, CA

Responsibilities:

• 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.