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

Show More

Portfolio Projects

Owings Mills

Company

Owings Mills

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

Skills

Oracle SQL

Maestro

Company

Maestro

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

Skills

PL/SQL

ECSS

Company

ECSS

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

Skills

Oracle

Oracle Implementation Project

Company

Oracle Implementation Project

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

Skills

Oracle
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Native/Bilingual

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]