SUMMARY:

• Over 20 years experience working with Oracle Financials and Project Accounting.
• Highly skilled at supporting clients with their ERP systems through periods of transition and sustainment.
• Adept at communicating with all levels of an organization and at delivering high quality solutions.

TECHNICALSKILLS:

• Oracle Financials R12
• 11i (GL
• AP
• AR
• FA)
• PO
• CE
• SLA
• iSupplier
• iExpenses
• Workflow
• AME
• Oracle Oracle Federal Financials R12
• Discoverer
• ADI
• SQL+
• Toad
• SQL Dev
• SQL Loader
• MS Office Data Loader
• Remedy
• Kintana
• Metalink
• Agile
• AIM
• OUM
• OBIEE
• BI Publisher
• Rally
• Sharepoint
• GL Wand

EXPERIENCE:

ORACLE SUPPORT ANALYST 

Confidential, Englewood, CO

• Provide user support and maintenance on Oracle R12 Financials system
• Troubleshoot issues relating to reporting, workflow, month - end close, interfaces, sys admin functions, etc
• Provide SQL workarounds for users
• Convert financial reports from Discoverer to GL Wand

ORACLE SUPPORT ANALYST

Confidential, Aurora, CO

• Responsible for iSupplier OFF R12 UAT and post go-live support
• Responsible for testing pharmacy interface and transferring monthly pharmacy receiving data to Oracle Federal Financials GL and to a custom AR module
• Responsible for UAT for Oracle and non-Oracle related support issues
• Write SQL queries in a custom, Oracle Federal Financials environment, as well as for 100% custom environment
• Create SQL reports/workarounds for users
• Create/Edit OBIEE reports as needed

ORACLE BUSINESS SYSTEMS ANALYST

Confidential, Denver, CO

• Met with users for requirements gathering sessions to asses reporting needs for OBIEE rollout
• Facilitated discussions between executives, sr. management, business owners and technical teams to assure all stakeholders were in alignment and product was delivered on time and within scope
• Utilized Rally for defect tracking, reporting analytics and metrics to assist PM with project tracking
• Created formal requirements documents including user stories, mockups & context diagrams via Case Complete tool
• Created test scripts, conducted unit testing and coordinated UAT with the business
• Created documentation and conducted user training sessions
• Mentored other team members

ORACLE FUNCTIONAL CONSULTANT 

Confidential, Monroe, NC 

• Gathered requirements for select reports and worked with development team for deployment
• Streamlined sales order data to display in a more effiecient and organized fashion for contractors working on Oracle SCM implementation
• Setup and troubleshot subledger accounting rules
• Developed SQL scripts in TOAD for backend analysis and troubleshooting
• Assisted Accounting/Finance with month-end close following go-live
• Developed initial GL, AR, AP, and Billings SQL reports so finance could close books following go-live and also to aid BI developers with subledger table mapping
• Assisted accounting users with business process improvement
• Assisted client with final acceptance testing and post implementation support issues

ORACLE SUPPORT ANALYST/SYS AMDIN 

Confidential, Broomfield, CO

• Acting liaison between the customer, Oracle Support and available technical resources, on and off-shore
• Provided project support for Oracle R12 upgrade through test and transition phases, as well as for post production support
• Gathered requirements and worked with technical team to provide the business with custom reporting solutions
• Created ad-hoc reports in Oracle Discoverer as needed
• Created documetation and training material
• Utilized Toad for SQL test scripts as needed

ORACLE BUSINESS ANALYST 

Confidential, Loveland, CO

• Responsible for creating use case model and for creating OUM requirements documents (RA-023; RA-024) for R12 implementation
• Translated business requirements documents into functional specifications
• Performed gap analysis
• Created Acceptance Test Plan (TE-082)
• Created UAT scripts and scenarios and coordinated UAT with the business
• Created documetation
• Conducted user training sessions
• Obtained user sign-offs
• Provided support to users

ORACLE ERP SUPPORT ANALYST 

Confidential, Englewood, CO

• 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, Projects, ADI, Discoverer and Workflow
• Acting liaison between the customer, Oracle Support and available technical resources, including utilizing offshore resources
• Aided users in performing UAT
• Validated UAT test scripts for R12 upgrade with users
• Create and test Oracle SQL+ scripts via SQL Developer and TOAD

FIXED ASSET SUPERVISOR 

Confidential, Denver, CO

• 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
• 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

SR PROPERTY ACCOUNTANT 

Confidential, Englewood, CO

• 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 training 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 Oracle Projects implementation