Patricia Montanaro

*** ***** ***

Hagaman, NY ***86

Phone: 214-***-**** (cell)

Email: ad4z96@r.postjobfree.com

Education:

Oracle Training – Oracle General Ledger, Financial System Administrator, SQL*Forms, Oracle*Reports, Performance Tuning, Database Administration, Relational Design, OBIEE, Oracle Workflow, Oracle Order Management, Oracle Financials, Agile PLM, Cognos, Java, Project Management

Kansas State University – Bachelor of Science in Information Systems

Technical Summary: APPLICATIONS: ORACLE Financials and Manufacturing Applications Release 9, 10, 11 & 12 Modules (OM, GL, INV, PO, WIP, Project, BOM, AR, ENG, AP, Pricing, EAM, OPM, Workflow, XML), EDI RDBMS: ORACLE V5 – 19c

Database Tools: Oracle*Forms 6/4.5/3.0/2.3; Oracle*Reports 6i/3.0/2.5; SQL*Plus, PL/SQL, TOAD, SQL*Loader, TKPROF, OBIEE, APEX, SQL Server

OTHER: TOAD, SQL*Developer, Business Objects, Microsoft Office, IDEF

OPER. SYS: AIX, DG AViiON, VMS, RMS, UNIX, Red Hat Linux, Windows 10

HARDWARE: Datapoint, DEC/VAX, DG, Harris, IBM RS6000, Silcon Graphics

Industry Experience: Healthcare, Manufacturing, Insurance, Retail, Defense, Property Management

EXPERIENCE:

Fluor Marine - IT Principal Software Developer April 2019 – Current

IT Lead on project to implement Oracle Fusion Cloud. responsibilities include development of setup and transactional data conversions (FBDI and HDL format) / ETL. Data Modeling, Requirements gathering, design and implementation of integrations of OFC to other applications (e.g. Concur, Remedy and other custom applications). Knowledge transfer of how Oracle ERP system is designed and functions, industry best practices in the area of training, testing and system maintenance. Technical Analysis and Review of Third Party Contractor Implementation.

Production Support of Oracle Financials and Manufacturing Application.

Support and development of Oracle Databases; Data Analytics and APEX Applications; Development of Database Training Material primarily focused on Data Analytics.

Liggett - Senior Software Developer Sept. 2018 - March 2019

Supported corporate computer systems which included resolution of operational issues and new development using Oracle and SQL Server applications.

New York State ITS – Database Specialist Contractor (OPWDD, DOH) May 2014 - Sept. 2018

‘ Analyzed and Documented existing applications written in Oracle*Forms, Oracle*Reports, PRO*Cobol and PL/SQL on VMS and LINUX operating systems

‘Programmed minor changes to OPWDD Applications (Oracle*Forms) required for resolution of User request.

‘ Converted PRO*Cobol programs to PL/SQL and/or SQL*Plus.

‘ Developed custom schemas, stored procedures, functions and database triggers using PL/SQL for the backend of a Java Application. This application (NYSECON Regional Office) tracked the approval of New York State Health Care facilities.

New York Independent System Operator Senior Oracle Application Analyst Nov 2013 – May 2014

‘ Overseeing/reviewing the upgrade of Oracle Financials (GL, AP, AR, PO) from R11 to R12 by an outside consulting company. Identified and documented existing R11 CEMLI. Worked with DBA, Users, Other IT personnel and Oracle Support Services to identify and resolve day-to-day and upgrade Oracle Application issues.

Orange County Container Group Sr Oracle Application Developer (Paper Manufacture) July 2011 – Oct 2013

‘ Developed custom application to record receipt of raw material used in the manufacturing operation. This application interfaces with Oracle Purchasing and Accounts Payables using the standard APIs.

‘ Developed the initial version of a custom application that records the receipt of waste material from the companies multiple (7) collection centers. This includes the use of Oracle AP and AR APIs.

‘ Oracle Application Support Specialist – Original position was in a help desk / user support role.

Promoted July 2012 Support of WIP, BOM, AR, ENG, AP, GL, EAM, OM, INV, PO, Pricing, OPM)

MMC (Contracting Corporation) March 2011 – June 2011 Position: Oracle Analyst Contractor at a Manufacturing Company

Development and Installation of AP and Cash Management Interface to Wells Fargo Bank

Application enhancements using Oracle*Forms, Oracle*Reports, PL/Sql, SQL*Loader, BI Publisher

Orthofix Inc. (Medical Device Manufacturer and Supplier) 2002 - 2010 Lead (Hands on) Business Process Group / Application Support Specialist

Provided production support for Oracle Applications (OM, Pricing, GL, INV, ENG, PO, WIP, BOM, and AP) and an extensive custom Oracle application. Custom Oracle Applications are primarily used for Customer Management, Revenue, Billing and Collections. These applications interface with the standard Oracle Application modules thru APIs.

Continuous requirements gathering, analysis of business process as the business changes (e.g. integration of recently purchased company’s legacy systems) and implementation of changes within Oracle modules. Database design (logical and physical), application development, testing, documenting, integration and support of new sub-modules when they are not able to be supported by the base Oracle Modules. Projects/development task typically include the use of Oracle*Forms, Oracle*Reports, Sql*Plus, PL/Sql, Business Objects, triggers, packages, procedures, functions, Toad, performance tuning, SQL*Loader, ODBC. Task of Data mapping, modeling, extracting, transform, load (ETL), code optimization, user training was also performed when warranted.

Arias Corporation (Consulting Corporation) 1999 - 2001 Position: Senior Data Architect

Development of Outbound Calling System and enhancements to custom application using Oracle*Forms, Oracle*Reports, Sql*Plus, PL/Sql, Business Objects, triggers, packages, procedures, functions, Toad, performance tuning, optimization, ETL, SQL*Loader.

Production Support

Quality Technical Consulting - Cellular Phone Manufacture 1998 - 1999 Position: Senior Consultant - Nokia

Lead a team of developers that provided 7/24 support for production manufacturing operation. This included Oracle Modules (OM, GL, INV, GL, PO, WIP, AR, BOM, and AP) and third party Warehouse Management and Electronic Data Interchange (EDI) system. Creation of packages, procedures, functions; performance tuning, optimization, ETL.

Computer Systems Authority (Consulting Company) 1995 – 1998 Position: Systems Consultant

Custom Modifications of ORACLE Applications

Integration of Legacy System (process and data) into Oracle Applications

Provide systems consultant services for client companies

QSE 1994 – 1995 Position: Project Leader / Database Administrator

Project: PAS (Insurance Industry)

Responsibilities include Database Administration

Project Lead for US Production Support of ORACLE Applications modules (GL, AP, AR, FA) and custom developed applications.

Project: MCI Planners (Promotional Rewards Management Company)

Development of a Promotional Sales System using SQL*Forms, SQL*ReportWriter, SQL*Report

Zale Corporation (Retail Company) 1993 - 1994 Position: Senior Business Analyst

Installation of ORACLE General Ledger (GL) Application, on a Vax VMS operating system

Initial set-up of GL (setting up accounting books, loading historical data),

Created programs which automatically loaded data from non-ORACLE applications into GL.

Creation of various reports and new forms to meet those user requirements which were not addressed within the Oracle GL module.

Assisted the DBA with daily DBA activities.

Performed GL System Administration activities and provide user support in a retail environment.

Prentiss Properties (Real Estate Management Company) 1992 - 1993 Position: Programmer/Analyst

Responsibilities included definitions and development of user requirements / enhancements of existing application and new application features to a Real Estate Management Application

DBA Duties

Dallas Nephrology Associates (Medical Care Provider) 1991 – 1992 Position: ORACLE Analyst

Design and development of a Medical Information System

Responsibilities included determination of user requirements (generate of user requirements documentation), table design, design, development and testing of database applications on a Datapoint using SQL*Forms (2.3 & 3.0), SQL*ReportWriter, SQL*Report, SQL*Plus, PL/SQL and SQL*Loader

User support in a Medical Clinic Environment

Bell Helicopter Textron (Defense Manufacture) 1985 - 1991 Position: Sr. Computing Engineer

Leader of a project to develop an Automated Software Configuration Management System with ADA Oracle’s RDBMS tools and DEC’s Code Management System product and a project to produce software development policy. SQL*Forms, SQL*Plus and SQL*ReportWriter was used on a VMS operating system.

Developed graphics software in a UNIX/C environment and performed various product evaluations.

Contact this candidate