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.
TECHNICAL SKILL:
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
Responsibilities:
- 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
Responsibilities:
- 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
Responsibilities:
- 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 sessions
- Mentored other team members
ORACLE FUNCTIONAL CONSULTANT
Confidential, Monroe, NC
Responsibilities:
- 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
Responsibilities:
- 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 material
- Utilized Toad for SQL test scripts as needed
ORACLE BUSINESS ANALYST
Confidential, Loveland, CO
Responsibilities:
- 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 sessions
- Obtained user sign-offs
- Provided support to users
ORACLE ERP SUPPORT ANALYST
Confidential, Englewood, CO
Responsibilities:
- Track and process Oracle Financials/Workflow related tickets via Confidential 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
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
- 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
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 Oracle Projects implementation
