PROFESSIONAL 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.
• 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, Itasca, IL

Oracle Financials Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, AP, Advance Collections, Deductions Settlement, e-Business Tax, GL, i-Expense modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, Fixed Assets, 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.
• 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 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.

Environment: Oracle Apps Release 12.2.3/11.5.10 e-Business suite (AR, AR, Deductions Settlement, AP, i-Expense, Fixed Assets, e-Business Tax, Sub Ledger Accounting, e-Business Tax, Project Costing, Project Billing, Oracle Time and Labor, GL, OM, INV, Shipping and Advance Pricing SQL*Loader, Data Loader, file loader, Toad, Windows NT, HP UNIX.

Confidential, Atlanta, GA

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.
• 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.
• 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, Omaha, NE

Oracle Finance Functional Consultant

Responsibilities:

• Have Created GL Allocation Entries and performed varieties of GL Allocation entries as following.
• Net Allocations
• Step Down Allocations
• Rate Based Allocations
• Usage Based Allocations.
• Application Consultant in Oracle Financial R12 modules, involved in the implementation and customization of Oracle Applications for client.
• Extensively involved in set-up and customization of Oracle General Ledger, AGIS, Account Payable, e-Business Tax, Cash Management, Fixed Assets, Purchasing, and Order to Cash Management.
• Configured all the General Ledger, AGIS, Fixed Assets, Payables, Fixed Assets and I-Expense set-ups in the test instance.
• Worked on the setups of the Corporate Book and Tax Book in oracle Fixed Assets.
• Worked on the Mass Additions and Depreciation process in oracle Fixed Assets.
• Worked on the Mass Copy process in Oracle Fixed Assets
• Worked on the depreciation rollback process in Oracle Fixed Assets
• Worked on the Retirement process in oracle Fixed Assets.
• Worked on the Credit Card Integration to accept credit card payments, integrated with Verisign Credit Card Gateway.
• Design and create metadata and ETL solutions to aid the reporting process across the enterprise in Oracle OBIEE
• Troubleshoot all issues and figure out the root cause/s of those issues in relation to OBIEE reports
• Standardize and improvise data quality through periodical data cleansing and auditing process for OBIEE Reports
• Created calculated fields using OBIEE reports for implementation of color coding and proper aggregations
• Highly experienced in working with OBIEE Answers, OBIEE Dashboards, BI Publisher and OBIEE Delivers.
• Created New Sales and Supply Chain OBIEE Reports as per the requirement
• Created extensive joins for data blending from several different data sources
• Worked on the setups of the Oracle e-Business Tax module - setting up rates, regimes, rate to regime flows, tax rules, tax exemptions, tax exceptions, etc.
• Participated in discussions with the client and cross-functional groups regarding the business process and requirements, performing Fit-Gap analysis, proposed solution and design for customization and the migration strategy, Preparation of Setup Documents, Design Document & Test cases using AIM methodology.
• Involved in setting up Chart of Accounts, Reporting Currency, Legal Entity, Ledgers, and Sub-ledgers.
• Worked on creating the Items for the Inventory set up for R12.
• Setup of Payable and Financial Options for Oracle Payable, System Options for Receivables, Setups for Transactions for Payables and Receivables, Bank Account setups
• Involved in the set up of purchasing option, receiving option, Position hierarchies, Approval hierarchies, control groups, Approved Suppliers List, Sourcing Rules.
• Developed specs for custom AR aging reports, workflow notifications to respective users as per the aging due dates from respective vendors.
• Have write, validate and execute the test scripts.
• Worked on configuring the production Environment.
• Studied current business processes, future business flow and identification of gap / workaround in order to provide an integrated order to cash business flow to meet the business needs of the group.
• Prepared Mapping document BR030 and setup document BR100 for AP and PO modules
• Handled the application of Oracle Financials that automated accounts payable, accounts receivables, fixed assets and cash management.
• Creating and Updating Functional Design Specification documents (MD60/ MD65) based on BR100 on payroll.
• Participated in the design of Chart of Accounts and did the Set up of Recurring Journals, Stat Journals &Mass Allocation Journals. Trained end users in Financial AR, AP, GL, FA and CE and HRMS (Employee and Payroll) also created detailed user manual.
• Assisted users in month end closing process, reconciliation, generating month end reports.
• Designed & developed training material and undertook training for all levels of users on new functionalities configured.

Confidential

Oracle Financials Functional

Responsibilities:

• As a Functional Consultant implemented the following modules: AP, AR, AGIS, GL, FA, Cash Management modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, FA, AGIS, Cash Management and GL modules.
• I-Procurement - Worked on the Configuration of i-Procurement module including the setups of the requisition templates, setting up the Item Catalogs and Categories, Account Generator, etc.
• 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.
• Configured Oracle GL, Cash Management, AP, AR, AGIS, OM and PO from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure by creating new Business Group, Legal Entity, Ledgers (primary and secondary) and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AP, AGIS, FA, Cash Management, INV and PO Modules.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential, CT

Oracle e-Business Suite Implementation of 11.5.10.2

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, e-Business Tax, GL, Fixed Assets, AP and CM
• I-Expense - Setup i-Expense for Connected and Disconnected expense reporting including setting of several expense reporting templates, setting up the Credit Card interface, implementing P-Card functionality in i-Expense, setting up of Per Diem and Mileage, setting up i-Expense to support Multi Currency, setting up Audit Automation, Setting up of Expense Report Summary client extension, etc.
• Worked on the Functional mapping of data Conversions & Enhancements AR, GL, e-Business Tax, Fixed Assets, AP and CM 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.
• Configured Oracle GL, e-Business Tax, AP, AR from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for ACG by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AP, and AR Modules.
• Created FSG Financial Reports critical to company’s business process.
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential

Financials Functional

Responsibilities:

• Requirements gathering from end users, Requirement analysis.
• Performed all of the setups required for AP, GL, AR, OM and INV.
• Understand Division-specific business processes from the end users and implement the same.
• Developed several enhancements to the Business Processes on the Procure to Pay side.
• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & p erformed prototyping of “To be” business process flows.
• Worked on the Sabrix Tax Engine integration with Oracle ERP.
• Developed the Functional Specification Document (FSD) and Business Requirement Documents (BRD) for all of the OM and PO customizations
• Worked on the GL Setups including the Ledger Setup, Ledger Sets, Legal Entities, Operating Units, Cross Validation Rules and Security Rules
• Performed all the setups required for automatic procurement from suppliers by defining approved supplier lists (ASL), sourcing rules (SR) and assignment sets. Defined Pay on Receipt setups.
• Defined various positional Approval hierarchies and Approval limits.
• Documented the new business processes & functional requirements & also provided with training materials to the business users.
• Provided onsite training to the business users about the new procedure developed for the business transformation phase in AR, GL and AP.
• Executed production cutover simulation task on a 24x7 calendar.
• Provided user support in the live phase.