JOHN A.

JOHN A.

Senior Oracle Technical Consultant

Grass Valley , United States

Experience: 18 Years

JOHN

Grass Valley , United States

Senior Oracle Technical Consultant

156000 USD / Year

  • Immediate: Available

18 Years

Now you can Instantly Chat with JOHN!

About Me

Motivated and results-oriented USAF Veteran and professional with more than 30 years of comprehensive experience enhancing manufacturing, customer service, and financial applications with a wide variety of proven technical talents including programmi...

Show More

Portfolio Projects

Description

Utilized Oracle database 11.2 and Oracle 12i applications including HR, OTL, and EAM. Responsible for creating and unit testing custom program interfacing external HR and Timecard Contingent Worker data to EAM for costing to appropriate Work Orders.

Show More Show Less

Description

Utilized Oracle database 11.2 and Oracle 12i applications including HR, OTL, Projects, Financials and TCA. Responsible for updating and unit testing of various custom interfaces. Created and corrected PL/SQL code in several custom programs interfacing HR and Payroll data to and from ADP Created and corrected PL/SQL code in several Alerts, Workflows, Fast Formulas, and WEB ADI packages Responsible for correcting and updating BI Publisher Reports using Excel and Word Templates Participated on Upgrade team that upgraded Oracle 11.3 to 12.2.6.

Show More Show Less

Description

Utilized Oracle database 11.2 and Oracle 12i applications including Costing, HR, Order Management, and Inventory. Responsible for updating and unit testing of various custom interfaces. Created personalization on several custom and standard Oracle forms, various Alerts for email notifications, and a custom Costing interface to handle zero cost items. Responsible for correcting and updating BI Publisher Reports using Excel and Word Templates Successfully worked with support personnel to research and create correction scripts for Orders, Receivables, and AR transactions.

Show More Show Less

Description

Utilized Oracle database 11.2. Successfully improved performance and tuning issues with billion-row tables accessed via Oracle PL/SQL and SQL generated by Groovy Scripts.

Show More Show Less

Description

Utilized Oracle database 11.2 and Oracle 12i applications including HRMS. Shared documentation in SharePoint and utilized Subversion as versioning tool. Conducted unit testing of various custom interfaces as well as coordination of testing and validation for offshore teams. Created and executed UNIX test scripts for installation of program components including packages, concurrent programs, profile options, and lookup tables using LDTs. Created custom interfaces to support data migration and management of HRMS, payroll, pension, and benefits processing within ADP, SumTotal, AON Hewitt, TALX, Fidelity, and other external applications. Created and corrected PL/SQL code in several Alerts, Workflows, Fast Formulas, and WEB ADI packages Launched analysis to compare data from ADP database to Oracle database, controlled by customer table in order to provide field-by-field audit documentation and optimized decision making.

Show More Show Less

Description

Utilized Oracle database 11.2. Drafted estimations of all technical tasks and drafted pertinent documentation, including R1 Edit Matrix, R3 Edit Matrix, Impact Analysis, and Migration Plan documents. Solicited responses from potential vendors for upgrade planning from Release 1 to Release 3. Conducted in-depth gap analysis and review of technical audit documentation in Migration Analysis.

Show More Show Less

Description

Utilized Oracle database 11.2 and Oracle 12i applications including AR/AP/GL, Federal Financials, and BI Publisher. Completed upgrade of Oracle applications from 11.5.10 to 12.1.3 with minimal downtime. Planned and executed comprehensive updates of various customer packages and procedures including AP Invoice Interface, Supplier Interface, PO Interface, and PA Funds Interface. Coordinated updates of XML and RTF files, various custom forms, and custom reports. Designed and executed various Unit Test scripts, System Integration Test Scrips, and Implementation Scripts including LDTs and LCTs.

Show More Show Less

Description

Utilized Oracle 12i applications including AR/AP/GL, Inventory, Order Management, and iSetup. Developed configuration process of OBIEE application. Personally designed and developed entire Configuration Management process and iSetup process to effectively automate movement of configuration information into various environments. Completed updates of BR100s and pertinent documentation to ensure accurate analysis of configuration.

Show More Show Less

Description

Utilized Oracle 11i applications including AR/AP/GL, Inventory, Order Management, and Lease Management. Utilized Oracle Lease Management to gather customer, contract, and payment information needed for update of secondary reporting systems.

Show More Show Less

Description

Utilized Oracle 11i applications including AR/AP/GL, Inventory, and Order Management. Completed in-depth estimates of scope and cost for all technical tasks in conversion of data from existing system into Oracle. Created entire project plan to upgrade from 11.5.8 to 11.5.10, including risk identification and management as well as billion entry tables.

Show More Show Less

Description

Utilized Oracle 11i applications including AR/AP/GL, Inventory, and Order Management. Participated in initial implementation of iPayment module. Designed seamless interfaces between Clippership shipping system and Oracle Order Management in order to effectively track shipping labels and counts.

Show More Show Less

Description

Utilized Oracle database 11.2.
 Successfully improved performance and tuning issues with billion-row tables accessed via Oracle PL/SQL and SQL generated by Groovy Scripts.

Show More Show Less

Description

Utilized Oracle database 11.2 and Oracle 12i applications including HRMS. Shared documentation in SharePoint and utilized Subversion as versioning tool. Conducted unit testing of various custom interfaces as well as coordination of testing and validation for offshore teams. Created and executed UNIX test scripts for installation of program components including packages, concurrent programs, profile options, and lookup tables using LDT’s.
• Created custom interfaces to support data migration and management of HRMS, payroll, pension, and benefits processing within ADP, SumTotal, AON Hewitt, TALX, Fidelity, and other external applications.
• Created and corrected PL/SQL code in several Alerts, Workflows, Fast Formulas, and WEB ADI packages
• Launched analysis to compare data from ADP database to Oracle database, controlled by customer table in order to provide field-by-field audit documentation and optimized decision making.

Show More Show Less

Description

Utilized Oracle 12i applications including AR/AP/GL, Inventory, Order Management, and iSetup. Developed configuration process of OBIEE application.
• Personally designed and developed entire Configuration Management process and iSetup process to effectively automate movement of configuration information into various environments.
• Completed updates of BR100s and pertinent documentation to ensure accurate analysis of configuration.

Show More Show Less

Description

Oracle Implementation Project
Utilized Oracle 11i applications including AR/AP/GL, Inventory, Order Management, and Learning Management. Completed estimates of all technical tasks pertinent to data conversion from existing SalesLogix system into Oracle applications.
• Planned, developed, and implemented scripts and packages for Customer, Contact, Attachment, and Notes data conversions.

Show More Show Less