We provide IT Staff Augmentation Services!

Senior Oracle Business Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • More than 13 years of extensive experience in gathering requirements, analysis, design, development, testing, support and tuning of Oracle Financials, Manufacturing and HR modules.
  • Experience also includes full life cycle implementation of Oracle HR, Payables, Receivables, General Ledger, Assets and Oracle Projects.
  • Profound knowledge of business process flow, operations and control
  • Training users on Application functionality and usage
  • Implementation of 11.0.3 AR, AP, GL, HR, PA, OTL, iprocurement, iexpense
  • Experience in 11.0.3 to 11.5.10 upgrade
  • Writing MD50’s(FD) and user training documents.
  • Gathering requirements and design of Revenue Recognition (Revpro Tool)
  • Experience in covering gaps from FD to TD
  • Experience in writing UT cases.
  • Working closely with for issues and drive them to closure.
  • Good Communication, Writing, Presentation, Workforce Management, Interpersonal and Analytical skills, along with the ability to work on multiple projects and prioritize workload
  • Managed resources for project related activities.

TECHNICAL SKILLS:

Oracle Applications: Technical Oracle Alerts, XML Publisher and AOL versions 11.0.2, 11.0.3, and 11i. Oracle Discoverer 3.2/10g.

Software: Oracle Forms 4.5/ 6i, Oracle Reports 2.5/6i, PL/SQL, SQL*Plus, and SQL* Loader.

Databases: Oracle 8i and10g

WORK EXPERIENCE:

Confidential

Senior Oracle Business Analyst

Responsibilities:

  • Streamline Financials business processes and enhance Project Accounting (Costing and Management) features for NetApp Professional Services.
  • Accruals and Deferrals Solution for Professional Services Automation(PSA)
  • LOE automation for PSA .
  • Time Card Integrity for correct capturing of billable and non - billable time.
  • Gathering requirements and design of Rev Pro (Revenue Recognition Tool) to identify items as 97-2 and 08-1.

Confidential, San Francisco, CA

Senior Oracle Business Analyst

Responsibilities:

  • Gathered requirements and setup Oracle Time and Labor for Projects.
  • Designed solution for project based services delivery which includes Oracle Project Suite of modules (Oracle Project Management, Oracle Resource Management, Project Billing and Project Costing).
  • Written functional design documents for various interfaces and client extensions to Oracle projects.
  • Integrated iexpenses, iprocurement with oracle projects.
  • Lead 11.03 to 11i upgrade efforts such as gap analysis, project planning and training.
  • Collected requirements and involved in business decisions for back-office inbound /outbound interfaces for AP, AR, GL and HR.
  • Performed requirement analysis and setup formats for Receipts.
  • Designed Multi-Org business process with multiple currencies for global implementation
  • Gathered requirements and Implemented Oracle HR. Migrated employees, assignments, benefits, addresses, contacts and salary from legacy application.
  • Design and Implemented ADP Payroll interface to Oracle HR and GL.
  • Designed, implemented and maintaining SOX controls for Oracle Financial processes.
  • Performed requirements analysis, setup and support of Discoverer Business Areas and Workbooks.
  • Gathered requirements and developed Financial Data Warehouse schema.
  • Gathered requirements for Purchase Orders and PO approval hierarchy.
  • Designed and developed profitability and other reports in Microstrategy.
  • Owned/managed payment processing gateway (Live Processor).
  • Gathered requirements and developed Financial Statement Generator
  • Developed reports in Payables and Receivables.
  • Designed and developed various custom process for reconciling payments and cash.
  • Knowledge of R12.

Environment: Windows 98/2000/NT, Sun Solaris, Oracle 8.x /8i/10g, Applications 11.0.3/11i, Forms 4.5/6i, Reports 2.5/6i, AP, AR, PO, FA, GL, HR, Discoverer 3.1.36/10g.

Confidential, Walnut Creek, CA

Applications Analyst

Responsibilities:

  • Implemented Oracle projects Billing and Costing modules
  • Converted Purchase Orders and Invoices, and Items from Legacy systems to Oracle Applications
  • Implemented Payables Inbound Interface and Order Import Inbound Interface.
  • Implemented Oracle General Ledger Inbound and Out-Bound Interface.
  • Developed Alerts for General Ledger.
  • Developed reports in Payables and Project Accounting.

Environment: Windows 95, Oracle 8.x, Applications 11.0.3, Forms 4.5, Reports 2.5, OE, INV, AP, PA, GL, PO, AOL, Self Service, Workflow.

Confidential

Software Programmer

Responsibilities:

  • Worked on various projects such as Purchasing and Inventory, Materials & Requirements Planning (Mineral Ore), Financial Accounting & Check Tracking system to automate Financial Accounting, Purchases, Payroll & Check Tracking, Customer Support and Order Entry System.

Environment: ORACLE 6/7.x, Forms 4.5, Reports 2.5, Power Builder 3.0, UNIX ORACLE 7.1, Forms 4.5, Reports 2.5, HP 9000, Windows 95

We'd love your feedback!