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...vice, and financial applications with a wide variety of proven technical talents including programming and database design. Highly analytical and curious with demonstrated expertise identifying opportunities for improvement and fearlessly resolving complex issues as well as providing teams with advanced level development and support. Leverages expertise in Oracle Applications and familiarity with hundreds of existing APIs and Interfaces as well as basic Java development in JSP, J2SE, and J2EE. Consistently recognized for excellent communication and presentation skills, leveraged to establish strong relationships with customers, teams, and stakeholders.
Show MorePortfolio Projects
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 LessDescription
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 LessDescription
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 LessDescription
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 LessDescription
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 LessDescription
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 LessDescription
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 LessDescription
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 LessDescription
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.
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.
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.