SUMMARY:

• Around 8.5 years of experience in IT industry as Oracle Apps Functional Consultant with exposure to Oracle Financial Functional Modules (AR, AP, GL, FA, Cash Management, SLA, E - Business Tax) Have closely worked with Financial Functional Users and Implementation teams in successfully translating business requirements into functional specifications and deliverables.
• Results driven software professional with an excellent record of delivering complex technology and creative solution by using a practical, pattern-based approach to achieve stated objectives within limits of time, budget and client’s satisfaction.
• Expertise in Oracle Applications 11i and R12 modules Finance Purchasing (PO), Accounts Payable (AP), General Ledger (GL), AGIS, Order Management (OM), Shipping (WSH), Inventory (INV), Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), I procurement, I expenses and I receivables.
• Extensive experience with Oracle e-Business Tax module and integration with Tax Software Vertex and Sabrix
• Currently working in the R12 module: 12.1.3 for GL, AP, AR, PO, FA.
• Excellent Knowledge of Oracle E-Business, OBIEE (OBIA), Tableau Platform, Informatica and their underlying architecture & data model.
• 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.
• 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.
• 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.
• Strong analytical ability in GL Allocation and Creating Mass Batches.
• 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.
• Demonstrated knowledge of Oracle R12 EBS Financial Models: GL, AGIS, FA, AP, AR, CE, OM and PO.
• Extensive experience in preparing Requirement Analysis Documentation, Training scripts, Functional Requirements.
• 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

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, San Ramon, CA

Oracle Financials Functional

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.
• Worked on the Revenue Recognition process in AR including setting up the deferred revenue rules.
• Performed all the setups for Finance modules including Account Payable, Cash Management, Advance Collections, Order Management
• Worked on the setups of Approval Management Engine (AME) - defining approval workflows, setting up parallel approval, defining attributes, rules, approval limits, etc.
• Worked on configuring AR and AP modules for reading tax information from Oracle e-Business Tax
• Worked on Order Management module - defined the Standard Order Cycle, Back to Back Order Process, Drop Ship Process, RMA Process, IRISO Process.
• Cash Management - Worked on the configurations of Cash Management module - defined the profile options, system parameters, Bank Transaction codes, bank statement open interface, reconciliation open interface, cash forecasting templates, etc.
• Business Requirement, Scope Management Documents Preparation
• Fit Gap Analysis for GL, FA, e-Business Tax, Advance Collections, Order Management, AR, AP and i-Expense & preparation for Fit Gap Document
• To Be High Level & Detail Documents Preparation
• Module Configuration Documents Preparation GL, Order Management, Advance Collections, AR and AP modules setup
• Testing and Preparation of the instance as a part of CRP1, CRP2, CRP3
• Data Migration requirement gathering for (BOM, Routings, Items, Open PO, Suppliers)
• Data Migration functional specification documents creation
• Design Creation & Validations

Confidential, Atlanta, GA

Oracle Financials Functional Consultant

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.
• 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 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, Oakland, CA

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.
• 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
• 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 Canada
• 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, Load Runner, Win Runner, Quality Center, Vertex Tax Software, QTP, Windows XP, UNIX, MS-Office

Confidential, Springfield, MA

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.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & RBC.
• 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, Bloomfield, CT

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.
• 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, Canada, 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 UK & IRELAND.
• Worked extensively with Oracle Meta link to resolve Production issues.
• Tested functionality after patches or configuration changes and conduct CRP Tests