SUMMARY:

• Over 17 years experience working with Oracle Financials and Project Accounting. Worked as ERP Functional Analyst/Consultant for last 8 years and in a business/accounting role for 9 years prior to that. Supported multiple upgrade and implementation projects.

TECHNICAL SKILLS:

Technology and Tools: Oracle Financials R12, 11.5.10.2 (AP, AR, PO, FA, PA, GL, CM), Inventory, Workflow, iProcurement, Oracle Projects, Oracle FSG Report Writer, Oracle 8.0/8i/10g, Oracle BI Discoverer 10g (10.1.2.3), ADI, SQL+, Toad, Sql Dev, SQL Loader, MS Office, MS Access, Noetix, Data Loader, Remedy, Kintana Mercury ITG, Metalink

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Oracle Financials Functional Consultant

Responsibilities:

• Set up and troubleshoot SLA rules
• Aid BI Developer in creating initial financial dashboard reports
• Installation, configuration and setup of web ADI for journal upload and FSG reports
• Work with users to document current business processes and map those findings against standard Oracle functionality
• Meet with business owners and IT managers to recommend business process improvements, customizations or extensions to optimize use of Oracle functionality

Confidential, Monroe, NC

Oracle Financials Functional Consultant

Responsibilities:

• Setup and troubleshot SLA accounting rules for errors
• Performed customizations and configuration changes in AP and PO modules for R12 Implementation
• Provided initial GL, AR, AP and Billings SQL reports for use with month - end close and table setup & structure to accounting and BI developers. SLA table joins included.
• Aided accounting with support in reconciliation and month-end close after Go-Live
• Provided post-production ERP support for Oracle Financials Modules and OM. Also supported Web ADI and Discoverer

Confidential, Broomfield, CO

Sr. Oracle ERP Functional Consultant

Responsibilities:

• Provided Tier III ERP Oracle Financials support for European, LATAM, APAC and US divisions
• Helped setup and configure AP, PO and GL modules
• Created customized responsibilities, menus and request groups either singularly or via Data Loader
• Setup functional and foreign currencies for EMEA, LATAM, APAC and US divisions
• Utilized Metalink and other online resources for research on open issues
• Acting liaison between the customer, Oracle Support and available technical resources, both stateside and offshore
• Developed SQL+ test scripts in TOAD as needed
• Developed testing scenarios and UAT scripts for upgrade project

Confidential, Loveland, CO

Oracle ERP Functional Consultant

Responsibilities:

• Performed fit-gap analyses, which included documenting and analyzing current-state business processes, mapping Client requirements against Oracle standard functionality, as well as leading business discussions and coordinating with technical resources to resolve gaps in Oracle Financials in GL, AP and PO modules
• Designed and developed FSG’s for various financial statements
• Created alerts to notify users on various business events
• Prepared BR100 documents
• Coordinated UAT and functional with users
• Provided post-production support

Confidential, Englewood, CO

Sr. Oracle ERP Functional Analyst

Responsibilities:

• Track and process Oracle Financials/Workflow related tickets via HP Open View in a timely manner.
• Resolve customer issues by developing and testing solutions within ERP group and/or with the aid of a Metalink analyst utilizing multiple test environments
• Troubleshoot user related issues from Oracle Financials, iProcurement, Cash Management, ADI, Discoverer and Workflow
• Create and test Oracle SQL+ scripts via SQL Developer and TOAD
• Perform GAP analysis
• Develop UAT plan with Business Technicians and Project Managers for upgrade to R12
• Assist in process redesign and documentation for Upgrade to R12

Confidential, Denver, CO

Fixed Asset Supervisor

Responsibilities:

• Managed and mentored a staff of 3 Accountants.
• Responsible for Fixed Asset rollforward schedules, as well as Gain/ Loss reconciliation, depreciation and reserve schedules
• Managed month-end and quarter-end processes in Oracle Fixed Assets
• Maintained Oracle FA system, including the addition of new locations, asset types and lives according to GAAP
• Coordinated ongoing projects with upper management
• Assisted with Oracle Fixed Assets upgrade project management
• Responsible for month-end, quarter-end and year end close processes, which included running depreciation, creating and posting entries to GL and work closely with IT staff to ensure timely & accurate close
• Responsible for coordination of IT related functional issues, including UAT

Confidential, Englewood,CO

Sr. Accountant

Responsibilities:

• Coordinated month-end close process, which included posting assets in FA, running depreciation and posting entries to General Ledger.
• Maintenance of Fixed Asset Accounting system, including setting up and maintaining locations and categories
• Proactive in addressing and identifying issues. Served as the “Go-To” person.
• Responsible for monthly upload of journal entries via Oracle’s Automated Desktop Integrator (ADI).
• Initiated physical inventory controls and methodology.
• Utilized Oracle Fixed Asset, Accounts Payable, Purchasing and Projects tables through setting up related Discoverer reports.
• Developed queries and maintained custom/ad hoc reports in Oracle Discoverer 2000 and SQL for AP, Purchasing and GL.
• Mentored team members, providing as needed.
• Served as liaison between FA and IT for database upgrade to 8i.
• Coordinated Fixed Asset requirements, processes and subsequent testing procedures with IT for Projects implementation