We provide IT Staff Augmentation Services!

Oracle Business Analyst Resume

4.00/5 (Submit Your Rating)

San Francisco, CA

SUMMARY:

  • Having 8+ Years of experience, in Oracle EBS Financial Release 12 Consultant, Experience in Full Life - cycle implementations, and Support of Oracle E-Business Suite
  • Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, FA, PO and IPROC modules.
  • Worked on preparing BR 100, BP-80, and MD-50, RD20, and TE40 documents. business requirement gathering, GAP Analysis including SQL database queries and components documentation and configuration of financials modules.
  • Prepared Functional design documents for customizations/conversions using AIM methodology.
  • Prepared training documents for CRP (conference room pilot), UAT (user acceptance test).
  • Functional knowledge on other modules like Oracle Internet expenses and Reporting tools like BI (GL AP AR and FA).
  • Worked on various implementation and transformation projects which involve Multi-org, Multi-Currency configurations.
  • Extensive experience working in Finance Modules (AP, FA, GL, IEXP, PA, AR, OTL, OPM and iProcurement).
  • Excellent understanding of business process flow in Procure to Pay (P2P), Order to Cash (O2C).
  • Worked extensively in oracle application module like GL, AP, AR and FA.
  • Interacted with Oracle support to resolve application issues, bugs, and SR management.
  • Experienced in all phases of the system implementation life-cycle such as As-is/To-be process definition, requirement analysis, map and gap identification, system configuration, implementation, and post implementation support.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12.1.3, 12.2.2

Programming Languages: SQL, PLSQL, HTML, XML

ERP Functional Modules: PO, AP,GL,CM,FA & E business-Tax

Databases: Oracle 8i/9i/10g and 11g

Oracle Tech Stack: Web- Adi, XML Publisher 5.6.2

Operating Systems: Windows and UNIX

WORK EXPERIENCE:

Confidential, San Francisco, CA

Oracle Business Analyst

Responsibilities:

  • Working as a Business Analyst for Q3FY14 Russia release from offshore Team In USA
  • Upgrade Assessment of current business process in R12
  • Business process Mapping with all standard and customized modules
  • Design Test scenarios and test scripts of all process identified in assessment phase.
  • Full UAT testing Cycles, with issue trackers and SME’s sign of.
  • Analyzing user needs, conferring with users to improve procedures, and identifying and solving problems
  • Study of Current business processes, future business flow & identification of GAP/Workaround to provide an integrated information system solution to meet the business needs of the company
  • Studied & Prepared As-Is and To-Be documents as per client requirements and prepared high-level end to end test scenarios.
  • Taken care of O2C test scenarios and test cases review and providing sign off. Co-ordinate with QACC and as well as Business
  • Involved In UAT/BAT
  • Prepared User training materials (SOP) with screenshots for each module.
  • Participated in Order Creation
  • Handling the defects and coordinating with IT team to resolve the high priority defects.

Environment: Oracle Application R12, SCM (AP, AR, GL, PO, INV, OM, iExpense, iProcurement, FAH/SLA), SQL, PL/SQL, TOAD, EIS Reporting, Workflow Administrator, SVN

Confidential, Sunnyvale, CA

Oracle Financial Consultant

Responsibilities:

  • Involved in the configuration of the system in CRP2 and UAT environments for GL, AP, AR, FA, CM
  • Conducted UAT at Onsite
  • Prepared BR100 documents for All modules
  • Tested Process flows in application.
  • Preparation of all documents like MD-050,TE-040 and users Training Manuals
  • Involved in Customizations to provide functional specifications to technical team
  • Worked on Testing Business specific customizations for all modules of EBS.
  • Worked on issues and raised Service Request for issues solutions
  • Interacting with the users for Issues resolution
  • Defining setups as per the support requests
  • Taking ownership of cases and resolving the cases logged by end user
  • Involved in month end closing activities
  • Interacted with key users to identify critical business issues and Resolving period end closure issues
  • Raising Service Requests (SR) to Oracle Global Support
  • Scheduling the requests on daily basis

Environment: Oracle Application R12, (UMX, AOL, GL, FA, AP, iExpense, XLA, CM, PO, iProcurement, iSupplier, Sourcing, Contracts, AR, Inventory, FAH), Oracle 11g Database, HP Quality Center, TOAD.

Confidential, Oakland, CA

ERP Consultant

Responsibilities:

  • Involved in the configuration of the system in CRP2 and UAT environments for GL, AP, AR, FA, CM
  • Implemented Sub ledger accounting for journal entry descriptions for all modules of Finance.
  • Implemented Multi-Period Accounting
  • Implemented E-Business Tax.
  • Tested Process flows in application.
  • Preparation of all documents like MD-050,TE-040 and users Training Manuals
  • Involved in Customizations to provide functional specifications to technical team
  • Worked on Testing Business specific customizations for all modules of EBS and Discoverer reports
  • Worked on issues and raised Service Request for issues solutions

Environment: Oracle Application R12.1.3 (AP, AR, PO, INV, OM, GL), Reports Builder 10g, SQL, PLSQL, TOAD, AIM, JIRA, OAF Personalization's.

Confidential, San Francisco, CA

Oracle EBS Analyst

Responsibilities:

  • Performing Business Requirement Study in Financials Modules
  • Preparation of all required documents like RD020, BR100, TE040 (Test Scripts) and End User Training Manuals.
  • Done the entire setups in Test, Development, and Production Environments for General Ledger, Oracle Payables, Fixed Assets and Cash Management as per the client needs.
  • Done the Application Testing with the help of Test Scripts.
  • Conducting CRP, UAT and User Training for Implementations.
  • Reporting to Project Manager/TL about the status of task which is assigned to me, and getting sign off from client side team for each and every task in each phase of implementation.
  • Attending meetings with Team members and TL/Manager to discuss about project scope and project planning.
  • Planning and finalizing Chart of as per client reporting requirements.

Environment: Oracle Application R12 (AP, AR, GL, PO, INV, OM), TOAD, SQL Developer

Confidential

Oracle Financial Consultant

Responsibilities:

  • Work on solving End-User Critical Problems and providing the necessary course of precautions.
  • Provide the full-fledged Production support for Oracle General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets and Cash Management.
  • Responsible to create the TAR with Oracle team to resolve the issues discussed with Oracle team.
  • Responsible to attend weekly calls for updates to users on open issues.
  • Managing Finance track Month End Closing.
  • Managing 24/7 supports for issues.
  • Responsible to do the required changes in set-ups based on the client requirement in Production instance.
  • Production Support for GL, AP, AR, CM and FA Processes
  • Resolving the issues addressed by the business users.
  • Raising the SR’s to Oracle Metalink team
  • Reporting to Manager/Team Lead

Environment: Oracle Application r12 (INV, PO, iProcurement, AR, GL, AOL), TOAD, SQL, PLSQL, Service Now.

Confidential

Associate Financial Trainee

Responsibilities:

  • Involved in 12.1.3 Upgrade from 11i
  • Involved in setting up custom Edit Rules based on Segment values, Journal Categories and Responsibility.
  • Provided operational training to users for GL, Web ADI, AR, FA and Custom Reports.
  • Provided Production support for GL, AR, FA, CE, Web ADI, and Reports in multi-currencies environment.
  • Configured/setup AR, AP, i-Expenses and CE for one of the Operating Unit.

We'd love your feedback!