Jay Frederick Email & Phone Number

Las Colinas, Tx

Provide expertise in the use, development, support and integration of accounting applications used by Pioneer. Act as a liaison between the accounting business teams that use these applications and 3rd party providers. Identify and resolve issues that occur in these systems. Coordinate testing and migration activities for break-fix changes and scheduled releases.Primarily responsible for Quorum Upstream application modules - Revenue Accounting, Cost Accounting and Division OrdersAlso assist with Oracle EBS support as it is heavily integrated with Quorum Upstream

Dallas/Fort Worth Area

Provide consulting services for various clients as part of the Global Oracle Practice at DXC Technology.• Led project to create a Linux/Python broker application that converted serial-based water meter usage radio messages to integrate with a custom Oracle database application using custom tables, triggers and packages at a municipal water wholesaler - also responsible for Oracle DB development on the project• Created help desk case management dashboards using Tableau at a petroleum refining company that improved visibility into performance and reduced outstanding desktop cases by 65%, also created views in SQL Server to use for live updates with the help desk dashboard• Project Lead and Functional Lead for Oracle Fixed Assets module implementation at a rural utilities company that migrated more than 40,000 assets from a legacy AS/400 system• Developed custom FA member depreciation tracking extension as part of this FA implementation• EAM module lead for production support team at a rural utilities company• Implemented an equipment inspection process for high-pressure valve parts using Receiving Inspection and Quality Plan functionality in Oracle Procurement • Responsible for EAM and Inventory module remediation and regression testing for multiple Oracle EBS upgrades (EBS 12.1.3, DB 11g and DB 12c) at a rural utilities company

Dallas/Fort Worth Area

Performed technical leadership role for the production support team for retail client consisting of 8-14 team members (both on-shore and off-shore) for 10+ Oracle ERP 11.5.10.2 modules including HR/Payroll, GL, AP, FA, PO, iProcurement, iSupplier, Project Costing, OTL. Manage team efforts to resolve production support incidents and complete minor enhancement requests, providing technical direction as needed.• Given additional leadership responsibilities with minor enhancement development which included assigning work, status reporting to business groups and adjustment of priorities• Managed project to support integration effort for OTL implementationusing 15 people in the US, Brazil and India covering 4 different applications• Established monthly process to collect support metrics for account contract management for more than 20 modules using SQL and Unix Shell scripts• Provided key direction in high-level design for new custom process to group and sort payable check documents which replaced a third-party check print application with a BI publisher based solution and reduced licensing costs by $30,000

Dallas/Fort Worth Area

Provided technical expertise to Oracle ERP implementations, upgrades and production support for a retail client. Assigned additional leadership responsibilities due to level of respect attained with multiple client business process owners, co-workers and HP account management.• Managed team cutover activities for outages (1-5 days) from multiple upgrade projects (11.5.10.2, ATG RUP5, 10g database, OATM)• Provided technical direction in high-level design of custom extension incorporating the use of parent values in code combinations on Cross Validation rules • Focused on run-time improvement activities for Oracle processes for a gain from 46% to 85%• Worked with client and third party consultants to prepare for production support of new HR/Payroll module and performed lead technical role for HR/Payroll production support issues after go-live• Completed impact analysis and code remediation for custom AP, PO and Project Costing reports and interfaces for the 11i upgrade

Provided technical expertise to Oracle ERP implementation projects, consulting engagements and production support for multiple clients. • Worked as a technical analyst on a production support team for Oracle 10.7 installation for a retail client which included AP, GL, PO and Project Costing - covering incident resolution, on-call support and minor enhancements.• Led team of 4 people to analyze legacy systems, develop solutions to meet business requirements, and complete system/UAT test pahses on Oracle 10.7 PO andProject Costing implementation for a retail client• Was a team member on an Oracle 10.6 AP and GL implementation for a specialty chemicals client and was responsible for developing an AP payment extract process

• Provided technical expertise with third party package Financial and HR/Payroll applications (Dun and Bradstreet, Lawson) for production support and consulting engagements.

Flint And Troy Area, Michigan

• Completed System Engineer Development program• Provided business and technical support for custom-developed automotive service mainframe applications