Oracle Global Systems Manager

Location: Greenville, SC
Job Description:
Manage and provide direction for global AVX Oracle systems to include implementations and installation of new Oracle projects. Manage the conversion of legacy systems worldwide to the AVX Corporate Global Oracle system. Responsible for managing the Corporate chart of accounts, legacy interface mapping to Oracle and mapping to Cognos. AVX modules include General Ledger, Accounts Payable, Accounts Receivable, Cash Management, Fixed Assets, Raw Material Inventory, Purchasing and Capital Projects Accounting Modules.
Reports To:
Global IT Director
Duties and Responsibilities:
  • Manage the global Oracle system for all installed modules in each AVX region in coordination with the IT groups, Corporate Accounting and third party consultants.
  • Perform analysis and direct activities for modification and daily functional support of the Oracle E-Business Suite.
  • Manage Global Chart of Accounts. Example of duties to be managed:
    • Adding new account segment values and ensure new values are appropriate in keeping with AVX standard.
    • Adding new product lines and assign PL Centers as needed.
    • Inserting new values into parent/child relationships for summary (roll-up) reporting and ensure new values are mapped appropriately from individual company ledgers to Consolidated Ledger for Global reporting.
    • Maintaining Cross-Validation Rules to ensure data integrity and preventing incorrect Account Code Combinations from being entered in the system.
    • Disabling obsolete Account Segment Values and Code Combinations.
    • Communicating Chart of Accounts changes and rationale to local accounting staff members.
    • Assessing impact of Chart of Account changes and make recommendations to Management on proposed changes.
    • Assisting staff accountants in creating re-class journals when balances must be moved from incorrect/obsolete code combinations to new combinations.
  • Assist staff accountants in Financial Statement Generator (FSG) report development.
  • Assist AVX Oracle Users with standard, Polaris RWB, ad hoc, or other custom reporting applications.
  • Assist in user training of reporting applications.
  • Assist with Monthly Oracle financial close for all locations as needed.
  • Manage Interface Mapping Files.
    • Review mapping files from legacy payroll, sales, and manufacturing systems to ensure journals are posted to correct Code Combinations. Coordinate updates as needed.
    • Review mapping file requirements as new Code Combinations are created or retired. Coordinate updates as needed.
  • Assist staff accountants in reconciliation and troubleshooting interface reconciliation issues.
  • Manage Cognos Mapping requirements
    • Assist staff responsible for Cognos reporting on interface/extract definition.
    • Communicate Chart of Account changes to Cognos staff.
    • Work with Corporate Accounting to ensure Cognos reporting rollups are correct.
  • Global Oracle Implementation.
    • Will act as overall Project Manager and liaison between AVX site project managers and consultants
    • Assist local accounting staff in mapping legacy Chart of Accounts to AVX Global Chart of Accounts when legacy systems are converted to Oracle.
    • Assist local accounting staff in reconciliation of data conversions.
    • Assist in training new Oracle users in Oracle R12 functionality.
Job Requirements:
  • B/S in Finance, Accounting/Business Administration or IT
  • Knowledge of Oracle financial systems/modules and sub-ledger accounting
  • Minimum of 5 years of overall business experience preferably with 3 years of Oracle eBusiness Suite
  • Functional business experience in a user capacity
  • Will require travel to AVX locations throughout U.S., Latin America, Europe, and Asia to assist with Global Oracle Implementation projects and perform training
  • Strong understanding of financial systems
  • Ability to manage several tasks at one time
  • Ability to build relationships with people at all levels, including executive management.
  • Strong interpersonal skills
  • Ability to think analytically and be a problem solver
  • Manage and train people
  • Unrestricted travel
  • Ability to work under minimal supervision
  • Strong analytical skills with heightened problem solving ability
  • Very detail oriented with strong follow-up skills
  • Excellent Communication Skills, both verbal and written
  • Proficiency in Microsoft Office Suite products
  • SQL, PL/SQL familiarity desirable
Submit Resume