Senior Oracle Business Analyst Resume
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
