SUMMARY:

• Around 10+ Years of Oracle E - Business Suite experience in Full Life Cycle Implementation, roll out, Up gradation, Onsite Offshore Support, Integration, Instance merging, Problem Solving and expertise in General Ledger (GL) including AGIS (Advanced Global Intercompany System), Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets (FA), Cash Management (CM), Purchasing (PO), Order Management (OM), Credit Management, System Administration well versed with Procure to Pay (P2P), Order to Cash (O2C), Record to Report/Acquire to retire (R2R) Cycles.
• Extensive experience with Oracle e-Business Tax module and integration with Tax Software Vertex and Sabrix
• Oracle R12 experience in GL, AP, AR, CE and Assets modules with MOAC (Multi-Org Access Control), MRC (Multi Reporting Currency) including SLA (Sub-Ledger Accounting).
• Worked extensively on Global rollouts and different Localizations like Confidential, Confidential, Confidential and Confidential Localization as part of Implementation Process
• Excellent Knowledge of Oracle E-Business, OBIEE (OBIA), Tableau Platform, Informatica and their underlying architecture & data model.
• Exposure in preparation of functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Worked on the latest versions of OBIEE 11G (11.1.1.7.0 ) and (11.1.1.7.1 ).
• Competent in understanding the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Proficient in Advanced Collections Module. Also created the Interaction with the customer, Processing Transaction and created the Dunning Plans.
• Thorough knowledge of Inventory, Advanced pricing, Order Management, BOM, Quoting and installing the base.
• Developed forms and Reports using Oracle Forms/Reports
• Strong Exposure in preparation of High-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
• Experienced in validation and Solution. Also participated in Test Scripts and configuration of Production Environment.
• Familiar with tools used to support Oracle Applications development including PL/SQL, Forms, Reports, and XML Publisher.
• Expertise in the entire Oracle implementation cycle i.e. Baseline & Requirements analysis, solution design, system configuration & set-ups, data migration, pilot testing, trouble shooting, implementation, roll out, user training and post implementation support.
• Experience in complete software product development life cycle (SDLC): System Analysis, Design, Development, Testing and Deployment.
• Good understanding of Business flow and conversion of business process in to Oracle ERP functionalities.
• Extensive experience with leading Conference Room Pilots (CRPs) and User Acceptance Testing (UATs).
• Managed and supported the production cut-over for go live.
• Proficient in concepts of Multi Org, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
• Extensive experience with the Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Design validation & setup of GL, AP, AR, FA, CE, INV, OM, and Advanced Pricing PO, modules.
• Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration in Quoting, OM, Advance Pricing.
• Knowledgeable in Oracle table structures, schemas, APIs and open interfaces.
• Proficient in SQL to pull up the data and use these data for migration and configuration purposes
• Strong on Functional documentation for Configurations (Setups), User Training Documents and Customization Documents.
• Expertise on all design documents (CV 60/CV065/MD050/MD070/MD0120/TE020/MD 130/MD 200/CV80).

TECHNICAL SKILLS:

Domain: Financial, Supply Chain, Discrete Manufacturing

Oracle Apps Modules: Account Receivables, AGIS, e-Business Tax, Vertex, Account Payables, General Ledger, Inventory, Purchase Order, Order Management, AOL, Oracle Alerts, System Administrator, Application Developer, Fixed Assets, Pricing .

Databases: Oracle data base 8/9i/10g/11g/12g

Languages: Sql, Pl/Sql

Tools/Utilities: FSG, Web ADI, SQL * Loader, Data Loader, Oracle Work flow

Operating Systems: Sun Solaris, Windows, Unix, Linux

Business Skills: Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD Sessions, Gap Analysis, and Impact Analysis., Epicor experience.

Methodologies: OUM, AIM, Waterfall, Agile

Modeling & Designing Tools: Rational Rose and MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Oracle Functional Lead Consultant

Responsibilities:

• Interaction with business users as a part of as - Is Study for client’s legacy application Account Payable, Cash Management, Advance Collections, Order Management, e-Business Tax, SLA
• Setup the Advance Collections module - defined the collections questionnaire, collections task pages, operational data level, collection strategies, work queue nodes, metrics, customer status metrics, workflow for promise approval, etc.
• Designed and authored functional specifications for many OM reports like Pick Slip, Packing Slip, and Mailing Label for Shipping and Credit Order Detail, Orders by Item, Order Detail and Summary Reports.
• Implemented General Ledger, Account Payables, Credit Management, Advanced Collections and Order to Cash (O2C) modules: Order Management, Inventory, Warehouse, Purchasing, Receivables within Oracle EBS.
• Created accounting flex field segment values, creating Cross Validation rules and security rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Prepared BR100 Application setup for Payables, Receivables, Order Management, Payments and Ecommerce Gateway.
• Documented current state, designed future state to automate treasury functions including cash position, daily investing, cash forecasting, cash general ledger entries and debt facility accruals.
• Configured the Cash management module for GL Accounts Mapping, setting up transaction codes, BAI2 file upload, and customization of out file as per the bank requirements, automatic transmission and import of bank files.
• Configured banks, bank accounts and documents for different needs like AP processing.
• Configured the Sub ledger Accounting (SLA) rules to ensure new R12 process functionality was working by updating the SLA rules using accounting methods builder.
• Configured dunning plans in Advanced Collections.
• Defined new models pricing features by Advanced Pricing using Modifiers and Formulas.
• Responsible for the mapping of XML and EDI invoices to support the business requirements.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice
• Approval using Oracle Approval Management (AME) and configured action types, actions and set up the profile option to work for Payables only and also the required setup through Payables Options form.
• Worked on Vendor sourcing rules, Blanket Purchase Agreements and Purchase Order Release methods in Oracle Purchasing.
• Worked on WMS - Inbound, Outbound and Reverse Logistics, Stocking and Internal Inventory Movements.
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules.
• Worked on AP/AR Netting, ERS Transactions Setups and related issues.
• Designed and implemented Back to Back Sales Order Process, integrating with Purchasing and customizing various forms and interface process as per business requirement.
• Designed and configured Custom extension using Order Management processing constraints to restrict cancellation or updates of a Sales Order once the Purchase Order is created for a Back to Back process.
• Involved in defect fixing of custom workflows like OM export compliance, Return Merchandise notification and credit management.
• As per client's requirement developed reports like Sub Ledger Accounting Report (SLA) using XML Publisher.
• Resolved issues related to payment processing, payment authorization and suppliers.
• Resolved issues related to credit card refund, return, bills only, freight charge return, credit card authorization, consolidated invoicing and receivables.
• Defect resolution and End-to-End Functional testing of the Standard and customized processes in the Order Management module (Order to Cash Cycle).
• Successfully executed CRP1, CRP2, and UAT. Provided post production support for the end users after go-live.
• Helped facilitate UAT for Order to Cash (O2C) Process.
• Provided with useful training to the users in General Ledger, Account Receivables, Account Payables and Order Management Modules.

Confidential, San Jose, CA

SCM Business Analyst

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, AP, Advance Collections, Deductions Settlement, AGIS, e-Business Tax, GL, i-Expense modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, Fixed Assets, AGIS, e-Business Tax, i-Expense modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Developed, tested and executed SQL scripts and the PL/SQL blocks.
• Worked on OAF Form Personalization for adding extra fields in self-service pages.
• Worked on PL/SQL Procedures and Packages as part of Development.
• Used composite data types (PL/SQL tables and Nested tables) to improve functionality with in PL/SQL
• Created Control Files for SQL Loader to load data from Text Files.
• Worked on the setups of AGIS module - setting up the Intercompany Accounting Pages, Intercompany accounts pages, Transacting Legal Entity, Transacting Ledger, Transacting Balancing Segment Value, Trading Partner Legal Entity, Trading Partner Ledger, Intra company Balancing Rules Page, Intercompany Transacting Types pages, etc.
• E-Business Tax - Worked on the oracle e-Business Tax setups like setting up the rates, regimes, tax codes, rate to regime flows, setting up e-business tax for sales and use tax as well as VAT Tax.
• E-Business Tax - Worked on the integration of Vertex Q Series with Oracle e-Business Tax
• E-Business Tax - Defined tax rules for exemptions and exceptions in Oracle e-Business Tax module
• Worked on AR Deductions Settlement module including the setups for Implementing Claims like setting up system parameter defaults, setting up Trade Profiles, setting up Supplier Trade Profiles, Implementing Org Stripping on Claims.
• Worked on AR Deductions Settlement module defining the claim types, claim reasons, claim sources, Promotional Payment View, Mapping customer reason codes, setting up claim ownership and assignment, Implementing Claim Rese
• Worked on Latin American Localizations for Brazil - setting up Tax Codes, setting up ICMS Tax Rates, Setting IPI Tax Rates, Transaction Nature, Next Number - Nota Fiscal, Next Number - Fiscal Books
• Worked on the setups of the General Ledger module - defining the primary and secondary ledger, defined the chart of accounts, calendar, cross validation rules, security rules, consolidation, translation, revaluation, etc.
• Worked on conducting Conference Room Pilots (CRP), prepared the environment for CRPs, prepped the data for CRPs.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Supported the production cut-over for go live.
• Worked on the setups of Sub Ledger Accounting module - defining the Journal Line Sources, Events, SLA Rules, Account Derivation rules, etc.
• Worked on the e-Business Tax module setups - defining the tax codes, tax rates, exemptions, exceptions, regimes, rate to regime flows, etc.
• Configured Oracle AR - Including the setups of Revenue Recognition process, defining of Accounting and Invoicing rules.

Confidential, Boston, MA

Oracle Financial Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the business flows including AR, AGIS, e-Business Tax, AP, GL and Cash Management modules.
• Worked in the configuration of the AGIS modules.
• Performed Requirement and Gap analysis.
• Worked on the setups of e-Business Tax and Vertex module - including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
• Worked on the credit card integration to accept PayPal Payments and Visa Credit Card payments.
• Worked on the integration of Oracle e-Business Tax with Vertex module.
• Worked on the setups of AGIS module defining the Intercompany Accounting Pages, Intercompany accounts pages, Transacting Legal Entity, Transacting Ledger, Transacting Balancing Segment Value, etc.
• Worked on Oracle Application Framework (OAF) to develop Custom solutions for iProcurement.
• Configurations and Setups for AP, AR, GL and Cash Management modules
• Worked on the Mass Addition process in Oracle Fixed Assets.
• Worked on the Depreciation process in Oracle Fixed Assets
• Worked on all of the configurations of Oracle Fixed Assets.
• Worked on the setups of the Corporate Book and Tax Book in Fixed Assets
• Worked on the formula based depreciation in Fixed Assets
• Worked on the depreciation roll back process in Fixed Assets
• Worked on the Mass Copy functionality in Fixed Assets
• Generated various Analytics reports like Formulary Report and Direct Financials Report using global and local filters in Oracle OBIEE
• Configured and administered existing subject areas and created new subject areas as per the modified Star schema information in Oracle OBIEE
• Trained the end-users in developing their own ad-hoc reports using Financials Answers in Oracle OBIEE
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository in Oracle OBIEE
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Developed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins in Oracle OBIEE
• Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models
• Developed complex triggers in reports before/after for validation of user input on the application system.
• Developed UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Confidential
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Worked on conducting Conference Room Pilot’s (CRP), managed 3 CRPs for the client
• Worked on User Acceptance Testing (UAT) - supported the testing effort, managed and developed test scripts for testing, managed the defect to resolution process for UATs.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle E-Business Suite 11.5.5/12.1.3, Oracle DB 10.2.0.3.0, OAF, Load Runner, Win Runner, Quality Center, Vertex Tax Software, QTP, Windows XP, UNIX, MS-Office

Confidential, Chicago, IL

Oracle Functional Consultant

Responsibilities:

• As a Business Analyst Consultant in the Order to Cash business flows, implemented financial modules: OM, AR, INV, Shipping in Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on a deferred revenue customization using the Revenue Recognition process in AR.
• Prepared the Business Requirement Document (BRD) and Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Extensively used the advanced features of PL/SQL like Collections including Records, Tables, Object types and Dynamic SQL.
• Developed SQL*Loader files to load data from legacy system into the Payable and Receivables staging tables for importing Customer data
• Executing concurrent programs from PL/SQL
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Confidential .
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks Confidential & Confidential .
• Implemented VERTEX Quantum tax software and D&B integration with oracle.
• Developed different reports as per the client’s requirement.
• Prepared documentation to supplement the implementation Project Costing.
• Trained business owners and business end-users on Capital Projects Costing as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Environment: Oracle e-business suite 11.5.10.2

Confidential

Business Analyst/ Consultant Functional

Responsibilities:

• Worked on Implementation Integration ver. 11.5.10.2. Conducted the Release 12 Assessment and worked till the Unit test for Financials modules like GL, AP & CM.
• Worked on GL, AP and PO. Gathered requirements, understand clients business process, prepared flow charts prepared BR100, BP 80s, RD 20s, MD50s etc. Configured CM &AP, Financial Options Payable Options, Banks and Bank Accounts, Defined Tax Codes & Payable Documents, prepared BR100s. Daily Exchange rates Interfaces, Record Miscellaneous Bank Transactions, Reconcile Bank Statements & Bank Balances to GL.
• Designed POs Interface from Legacy to Oracle, AP Invoices information to Legacy. Worked with SMEs for required Set ups, Reports. Worked in Integration testing using QAD Manual Testing on RICE Designs. Tested functionality after patches or configuration changes.
• Configured and tested ‘Escheat Payment Process.’ Worked on post Production Support.

Confidential

Business Analyst

Responsibilities:

• Worked on Implementation & Production Support ver.11.5.10.2 & Database 10.g.
• Extensively work in Oracle SQL, Query performance tuning
• Resolved production issues pertaining to GL, AP, Tax Codes, Daily Exchange rates Interfaces, Load & Reconcile Bank Statements, built and run FSGs. Trial Balance, Profit and Loss and other Reports.
• Supported US, Confidential, Brazil, China and Turkey sites as SME.
• Went to Istanbul - Turkey for postproduction support with the support team.
• Set up BR100s for AP Module for Confidential & Confidential .
• Worked extensively with Oracle Meta link to resolve Production issues.
• Tested functionality after patches or configuration changes and conduct CRP Tests