SUMMARY:

• 6 Years of expertise in the functional and technical aspects of Oracle E - Business Suite/ Applications R-12, 9i, 10g and 11i deployment Requirements, Customizations and Functional User Training.
• Extensive exposure in preparation of AIM methodology documents such as BR100, MD50 MD70, MD120 and end user manuals.
• Well versed with R12 architecture concept with detailed hands-on experience as part of implementation team in various Oracle EBS modules like Inventory Management, Order management, Shipping, Work in Process, Oracle Costing and Advanced Pricing.
• Expertise in modules such as General Ledger(GL), AGIS, Account Payables(AP), Account Receivables (AR),Advanced Collections, Cash Management (CM), Fixed Assets (FA), E-Business Tax (EB Tax), Purchasing (PO), I Procurement (IPROC), Sub Ledger Accounting, Project Accounting (PA), Iexpenses, Oracle Time and Labor (OTL), Financial Accounting Hub(FAH) and System Administration (SA)
• Competent in understanding the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• End to End Implementation, Customization, Conversion, Interface, Extension, Production support and Testing in Oracle E-Business Suite (EBS) 11i and R12.
• Experience as SCM (O2C) and Oracle Procurement (P2P) Functional consultant in implementing Oracle Applications during the different phases of the implementation life cycle, Upgrades, roll outs and Production support.
• Expertise in providing end-to-end business intelligence solution by building Analytics Repository, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using Oracle Business Intelligence (OBI) EE.
• Extensive technical and business experience in Procure-to-pay (P2P) , Order-to-cash(O2C), Quote to Cash and Assets to GL Record to Report .
• Experienced in RICE (Report, Interfaces, Conversions, Extensions) customizations. Customized Oracle forms (6i/10g), Oracle Reports(6i/10g), Oracle Workflow using Oracle database 10g/11g, PL/SQL, XML Publisher/BI Publisher, Custom pll and Forms Personalization.
• Skilled in maintaining data integrity, consistency and improving business process workflows in different HRIS environments.
• Hands on experience setup of Application Object Libraries ( AOL ), Object Menus & Functions, Oracle E-business Suite Responsibilities, Concurrent programs, User Setup.
• Exposure in R12 Financial Modules and SLA , MOAC , TCA , E-BUSINESS TAX .
• Expertise in development tools such as Oracle Forms, Oracle Reports, PL/SQL, SQL*PLUS, UNIX Shell Scripts.
• Experience of setup and configuration of i Expense module.
• Knowledge of AIM (Application Implementation Methodology) and OUM (Oracle Unified Methodology).
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle.
• Extensive experience in Functional Analysis, Application Implementation and Upgrades Including understanding Business Process reviews and Requirement Definition, Gap Analysis, Customization Analysis, Preparation of Training Material, Data Conversion, Pilot Planning, Preparation of Test Strategies and Test Plans, Training and Post Implementation Support.
• Good functional knowledge in Oracle Finance Modules (GL,AP, AR), Advanced procurement (Sourcing, iSupplier, iProcurement) and Oracle CRM Modules (CRM Foundation, Installed Base, Field Service, Depot Repair, Service Contracts).
• Proficient with agile engineering practices such as TDD, BDD and continues integration.
• Strong technical command of management tools; Jira, Rally and TFS.
• Experience in Requirement Analysis, JAD sessions, Requirements Interviews, Brainstorming, Running Scrum Meetings, Sprint review, Business and Systems reviews and working sessions to communicate with the team and to ensure the understanding of the requirements and system design.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Worked in Waterfall and Agile-scrum environment.
• Extremely experienced in building and creating business requirements documents (BRD), functional requirements documents (FRD), and corresponding nonfunctional requirements documents (NFRD).
• Strong experience in understanding business applications, business data flow and conducting JAD sessions, interviews with clients and stakeholders to gather requirements.
• Strong knowledge in creating UML Diagrams including use cases, activity charts, and sequence diagrams in MS Visio and Power Point.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle EBS Business Analyst

Responsibilities:

• Implemented Oracle Inventory to our warehouses, introducing physical inventory processes, improved shipment time, accuracy improvement for shipping product.
• Involved in planning and delivering GL, and Phase I Reporting module which includes defining calendar, defining security rules, account aliases, roll-up group, journal sources, journal categories
• Used ADI (general ledger desktop integrator) to integrate the GL module to the excel sheet, designing and developing FSG reports such as Balance Sheet, P& L Accounts and other management reports.
• Configured the setup for multi currency invoices and payments in Payables
• Develop and manage the integration of various ERP systems with Oracle EBS.
• Primary responsibilities included functional and technical support for Oracle GL, PA, AR, AP, Inventory, Discoverer Administration, Fixed Assets, and Cash Management.
• Involved in pre-post upgrade Production validation testing during 11.5.10 upgrade for modules AR, OD, Inventive compensation and service contract.
• Involved with Unit testing, Integration testing for different AP/AR /PO process
• Customized the AR Lockbox process.
• Worked on open interfaces for Oracle GL, AP suppliers, invoices, AR invoices, and AR receipts.
• Designed, developed and implemented GL code combination and Balance conversion programs and converted new division's legacy data into Oracle EBS's GL module
• Developed the RPD and publishing Subject Areas using OBIEE Administrator tool.
• Implemented PO Category restructure from one-segment to three-segment structure.
• Re-Structured new stores for iProcurement that made requisition creation processes more efficient and user friendly.
• Successfully designed, developed, tested ETL code and implemented on 9 US and 5 International facilities into Oracle EBS.
• Created pre-implementation training material with consultants to train A/R, A/P and GL Accounting staff on Cash Forecasting and bank reconciliation capabilities.
• Designed, tested and implemented within existing set of books new operating units encompassing GL, AR, AP, PA, Purchasing, iExpense, Purchasing, EBTax, iProcurement, Inventory, and Oracle Time and Labor in Oracle ERP system. Provided post implementation support for new operating units in the US.
• Use SQL and PL/SQL to update Oracle Packages for various manuals for Fidelity customers.
• Oracle EBS suite support, OTC, EBTax, P2P, Lead SME for system and end-user errors and issue that arise from day to day activities.
• Performed Implementations for Order to Cash (OTC) and Procure to Pay (P2P) and Inventory modules.
• Successfully implemented a new interface system for autolockbox for creating receipts in AR to adhere the new standards of the European banks (Camt.054 XML).
• Authored numerous SOW, BRD, FRD, FSD and TSP documents for existing and prospective clients.
• Conducted GAP analysis, cost benefit analysis, and ROI analysis.

Oracle EBS Business Analyst

Responsibilities:

• Primary responsibilities included functional/technical support of Oracle GL, PA, AR, AP, Inventory, Discoverer Admin, Fixed Assets, Cash Management, and Cognos administration.
• Worked as a super user with OAL (Oracle Application Lab) team to analyze fix the bug & applications based issues in production.
• Hands on PL/SQL, Oracle8i, 9i, 10g, Forms4.5,6i, Workflow2.6, VB, Excel Macro, ASP, SQL Server, Manual testing, preparing test plan and test cases using QC.
• Provided Top Tier Support to Business Users for all Order to Cash (Oracle 11i) support calls.
• Involved with External Interface Testing during the Red Prairie warehouse implementation. This interaction consisted of mass sales orders and shipments that were exchanged from Oracle OTC Enabling and testing eBTax setups and functionality per business needs. modules.
• Led improvements for implementing our Vertex taxing software engine, enabling proper tax collecting, reporting and order placement.
• Administered, Installed and configured Oracle 9i and 10g instances in both standalone and virtual machine.
• Worked on errors faced in GL cross validation rules used in requisition account generator validation process .
• Helped Implementation team to test and approve CRP deliverables and facilitate migration path to Production environment.
• Setup of On Demand Invoicing features, Configuration and implementation of fixed assets, XML Gateway transmissions in Oracle AP.
• Designed custom interfaces, process and reports to meet client’s requirements in General Ledger, OM.
• Techno-functional liaison between users and technical team during development of RICE components.
• Experience in Debugging, Optimizing and Performance Tuning of Oracle BI Analytical Dashboards / Reports.
• Functioned as AR/AP/GL modules functional lead, I gathered business requirements, set up modules, conducted CRP and UAT sessions, trained new users and created functional documents .
• Worked on a full life cycle project of WCMS (integration between Oracle GL/PO modules and a third- party shipping application).
• Provide support for and maintaining Oracle GL, AP, AR, FA, OLM and PO Modules.
• Facilitated Backlog Grooming, Scrum Planning, Daily Scrum, Sprint Review and Retrospective meetings.
• Responsible for gathering Business requirements & preparing Business Requirement Document (BRD) and then translating into functional specifications.
• Create SQL for new customer manuals and verify SQL output based on customer change requests.

Oracle EBS Business Analyst

Responsibilities:

• Defining Supply chain business process (Order to Cash, procure to pay Manufacturing, Logistics, supply and demand planning).
• Tasks also included logging TARS (Technical Assistance Requests) for Oracle bugs found for Oracle to Cash (Oracle 11i) modules.
• Developed Technical design documents (MD-120, MD-070 and CV-060) based on functional design document ( MD-050, BR-100, CV-40 ) using Application Implementation Methodology ( AIM V.3.0 ).
• Created AIM based documents like BRD100, MD050, and MD070 etc for various customization .
• Worked on data conversion in AR, which includes mapping the data from legacy system to Oracle using the Loader and interface programs.
• Master Conversion and Conversion of Open AR Invoice program to load data into Oracle.
• Tested the functionality of auto-invoicing, Auto lockbox and Credit Card processing.
• Involved with Unit testing, Integration testing for different AP/AR /PO process .
• Conduct a study of the current GE’s applications and GE’s customer specific business rules and practices, user requirements and preparing specifications in the area of integrated General ledger
• Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Collaborated extensively with development team on development and customization of Oracle RICE (Reports, Interfaces, Conversions and Extensions) components as per business requirements .
• Maintained HRIS and participated in regular system updates as well as provided data integrity and functionality in a global HRIS environment.
• Prepared mass updates using the Enterprise Information Builder (EIB) tool.
• Responsible for documentation of all HRIS processes.
• Extracted data from HRIS system using a variety of reporting tools to provide support for corporate and management initiatives.
• P2P and D2B subject matter expert implementation Lead.
• Configured localization setups for AP, AR, EBTax applications for EMEA countries.
• Enabling and testing eBTax setups and functionality per business needs.
• Created Security Design documents for various Oracle Supply Chain Management modules.
• Study existing and upcoming change management artifacts, analyze associated risks, and plan ways to mitigate them.
• Facilitated Agile Transformation at financial services client, helped develop Scrum Master training materials and artifacts.
• Preparing Business Requirement document for High Net worth individual and corporate customers.

Business analyst

Responsibilities:

• Interacted with Business users and the client for providing testing and Production Support as Techno Functional Consultant after GO Live .
• Conducted CRP Presentations for User Community .
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL procedures, reports as concurrent programs.
• Involved in AP open invoices conversion from legacy to Oracle Payables.
• Developed Various Reports in PO and AR Modules and customized them using XML Publisher.
• GAP Analysis, process mapping, training of end users and setting up new business processes in Oracle.
• Complete product configuration and setup, unit and integration testing, define test scripts, defect resolutions, process flows and end user training.
• Prototyped the necessary requirements by conducting CRP sessions with stake holders and super users for the business.
• Coordinated operations and analyzed Change Requests (CR) made by client for implementation and testing.
• Created customized reports for audit purposes using SQL database queries.
• Served as a liaison between the business and IT to provide Oracle functional and technical business solutions that meets needs of client managers and other stake holders.
• Gathered requirements for various RICE elements from the Business users.
• Core team member supporting implementation of Oracle ERP system.
• Reviewed test scripts for each EBS module and make improvement for better test experience .
• Partner with business sponsors by facilitating daily alignment meetings to engage stakeholders and execute change management plans.
• Carry out BPR (Business Process Review) to understand the current processes of Client.
• Reviewing, updating and closing queries created by end users in Oracle Siebel CRM.
• Introduced agile scrum and test-driven development practices; prioritized stories into 2 week sprints.
• Performed GAP analysis of business rules, business and system process flows, user administration to be used for the new migration platform.
• Responsible for preparing user stories (BRD) and then translating functional requirement into technical specifications.