SUMMARY:

• Oracle Apps Analyst with extensive experience as Business analyst Oracle Applications R12/11i.
• Experienced in gathering customer requirement by organizing brainstorming sessions, Joint Application Discussions (JAD), and meeting with the end - user, stake holder and SME’s.
• Experience of working on all phases of implementation projects including Definition, Operations Analysis, Gap Analysis, and Design, Build, Transition, Production cutover and maintenance of Oracle applications.
• Good understanding of SCM, CRM and Oracle Service Cloud modules.
• Good understanding of Oracle APIs/Open Interfaces and the underlying data model of Oracle Applications.
• Good hands on experience of SQL, PL SQL features with ability to extract and analyze PL SQL reports.
• Excellent project management, leadership, communication, client facing and presentation skills.

TECHNICAL SKILLS:

ERP: Oracle Applications R12/11i, Order Management (OM), Install base (IB), Quoting, Customer (TCA), Purchasing, iSupplier, iProcurement, Accounts Payable (AP), Accounts Receivable (AR), Pricing, Depot Repair, Field Service, Service Contracts (SC), Service Cloud(OSC), Field Service Cloud(OFSC), Mobile Service Cloud (OMCS), Inventory (INV), AME, OIC, Open Interfaces, Workflow, Sales Online, Sales Force.Com (SFDC).

Tools: & Utilities:

TOAD, Data Loader, Visio, Tableau, HP: QC, HPSM, Service now, SharePoint, SBM, PVCS, Kintana.

PROFESSIONAL EXPERIENCE:

Lead Business Analyst

Confidential, Austin, TX

• Provide Oracle R12 EBS application functional support on Oracle modules such as Service Contracts, Field Service, Depot Repair, Install Base, OM, PO, AR, AP, GL, Adv. pricing, Inventory, Sales Online, AME, Quote, and OIC
• Gained proficiency in full OTC, P2P and Financial process.
• Actively involved in all phases of R12 implementation and worked closely with developers and testing team.
• Actively involved in all phases of Oracle Service Cloud implementation and worked closely with developers and testing team and involved in WCC to Service Cloud bi-directional integration.
• Active participant in functional setups in different instance (DEV, QA, Stage, finally into the PROD).
• Responsible for resolving CRM and SCM module issues and provide RCA for major production issues
• Managed and trained off shore team and provided KTs on CRM modules to team members.
• Review/Analyze existing test cases in HP-OC, identified gaps, reviewed with functional lead and documented missing use cases.
• Presided weekly status update meetings with support manager to review escalated issues and pending issues.
• Support integrations between Oracle EBS and CRMOD application platforms
• Conduct meetings with business to help/explain issues and build good relationships to provide exceptional support to business users.
• Managed off-shore team and support escalated business critical scenarios.
• Responsible for handling month end close, quarter end and year end issues.
• Resolved issues in CRP, UAT, SIT during huge R12 upgrade and actively involved in mock testing.
• Involved in setup changes and follow RFC process to migrate changes from Dev to PROD instance.
• Extensively used HPSM, Service now for defect tracking and Kintana for code migration.
• Engaged with CTS team on providing end to end business flow for preparing test scripts.
• Gained proficiency in PL/SQL worked on resolving oracle custom reports.

Oracle Apps IT Business Analyst

Confidential, Palo Alto, CA

• Primary Oracle modules: Pricing, Service Contracts (OKS), Accounts Receivables (AR), Accounts Payable (AP), Customer (TCA), Install Base (IB/CSI), Quoting and Order Management (OM).
• Gathered user and business requirement through meetings, brainstorming and JAD session with the business users, Stake holders and end users.
• Involved in translating the business requirement into business requirements documents and functional specification.
• Document FRD and Conducted design review sessions and worked on getting Sign off from business.
• AS IS and TO BE analysis and provided solution design (GAP Analysis and RICE identification).
• Conducted FRD walkthrough meeting with Dev and QA.
• Participated in doing functional setups in different instance (DEV, Functional QA, Automation QA, Performance QA, Stage, finally into the PROD).
• Reviewed test plans and test scripts for UAT and QA, provided inputs for the missing corner scenarios.
• Involved in analyzing and finding the root cause for defects raised during CRP and UAT.
• Worked on subscription initial order, redemption, renewal orders and recurring billing orders.
• Designed changes to the existing oracle application R11i system as per the requirement gathered from the Business users and its related systems (including salesforce.com and a custom quoting system).
• Designed Interface between the Sales opportunities from Salesforce.com to Oracle EBS service Contract where the Quotes are created which are due to expire.
• Supported QA during the functional testing and participated in UAT defect resolution.
• Participated in Data validation during all testing phases (SFDC-EBS partner integration)
• Documented configuration and setup for release management and conducted KT sessions for support team before going live.

Oracle Apps Systems Business Analyst

Confidential, Sunnyvale, CA

• Coordinated requirements gathering sessions, design review sessions and worked with onsite/offshore teams.
• Setup, configured and defined the following in Order Management and Service contracts - Defined descriptive flex fields, Profiles, Order Import sources, Price lists, processing Constraints, Defaulting rules, credit checking, Holds, Process definition, QA checks, lookups, value sets, submit requests.
• Document FRD and conducted design review sessions and worked on getting Sign off from business.
• Setup changes for EBS email notifications for Order Management and Service Contracts.
• Conducted gap analysis between requirements and Oracle applications and determined alternatives and recommendations and documented Request for Changes (RFC) for gaps identified.
• Developed test scenarios, test scripts and performed end-to-end functional testing.
• Coordinated CRP and UAT testing of different track specific test cases.
• Worked with upstream and downstream application teams to execute E2E test cases.
• Worked closely with offshore development team on defect resolution and testing.
• Documented process flow diagrams and developed user training.
• Provided post production support and did a knowledge transfer to on-site and off- shore support resources.

Oracle Apps Business Analyst

Confidential, Mountain View, CA

• Conducted workshops to define business requirements and documented RD050.
• Documented BR100 and performed Order management, Advanced Pricing and Service contracts setups.
• Enabled, defined and tested multi-currency price lists functionality.
• Defined Pricing Modifiers to allow discounts based on product and product type with customer/customer class as the qualifier.
• Performed gap analysis and identified necessary customizations.
• Defined Modifiers, Qualifiers and Price Agreements.
• Extensively followed AIM methodology throughout the project.
• Setup currency for quotes in third party tool, Enabling Price Tables for new currency, setting up List price new currency with new Price Table
• Setting up Business Rules to be configured in third party application to apply the appropriate channel discounts for distribution quotes created for new channel distributors
• Setup new currency in SFDC and Validate new currency in currency LOV of opportunities in SFDC.
• Discoverer report for Price Book Generation has separate tabs for GEOs Price tab to be added as per the Business requirements.
• Performed Data loading activities for Bulk loading in EBS.
• Responsible for setups like OM lookups, AOL lookups, pricelist, modifiers, Qualifiers and Link with Modifiers.
• Documented functional use cases which can be leveraged to create QA Test cases and BA Unit Test cases.
• Conducted CRPs testing and UAT testing sessions with the business users.
• Developed and maintain test scenarios for project team and end users to validate upgrade.
• Provided post production support and did a knowledge transfer to on-site resources.

Oracle Applications Functional/Support Analyst

Confidential, Plantation, FL

• Responsible for Order Management setups - Defined key & descriptive flex fields, Profiles, OM Parameters, Header & Line process flows for various fulfillment flows, Order Import sources, Price lists, processing Constraints, Defaulting rules, credit checking holds.
• Functional design for EDI order validation and interfacing the same to order import interface.
• Defined and documented cancel order process, manufacturing and shipping systems are non-oracle systems this makes the process very complex.
• Performed Inventory setups - Defined Inventory Orgs, UOM, Items, Item categories, Item Templates.
• Designed and implemented Consignment Process (Pay on Pick), goods are received in to a SOI sub-inventory location and when it is picked and moved to MOI sub-inventory location pay the supplier. This drastically cut down the cost of inventory required to meet the customer SLA requirements.
• Designed the interface between Oracle PO and Atlas (WMS), for sharing open PO’s and material receipts. Sub-inventory transfers are done in Atlas and are fed back to Oracle to reflect accurate on hand balance. Transactions are batched by item, transaction type and sub-inventory locations.
• Documented cash application process, applying, un-applying, re-applying and reversing cash receipts.
• Responsible for performing gap analysis, and documenting alternative workaround/solutions, involved in functional design of extensions.
• Designed, prepared and conducted workshops and training sessions for end-users.
• Designed initial data conversions, converted customers, suppliers, item master, open orders, open Account Payables, Account Receivables and Inventory transactions.
• Post-production troubleshooting and analysis of Order Management, PO, Inventory and AR modules.
• Implemented and configured Logical Apps to meet SOX internal controls requirements.
• Defined appropriate roles and responsibilities in accordance with Sarbanes - Oxley IT controls.
• Gathered requirements and performed business requirements mapping using AIM processes and templates.
• Designed various return order flows - Return for credit (No repair or replacement), Return for Credit Only (No material return), Return for replacement, Return for repair.
• Developed and maintained detailed project plans and managed tasks and phases of projects.