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.

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

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

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