SUMMARY

• Over 13 plus years of experience in Oracle Applications E - Business Suite as Functional Consultant, worked for multiple clients across multiple industries Manufacturing, Distribution and Telecom.
• Experience in Full Life Cycle Implementation projects which includes expertise from Requirement Gathering, GAP Analysis, Database & Application Design & Development, Implementation, Pilot Testing, Impact Analysis, User Training, Go-live & Production Support.
• Extensive experience in Oracle Application modules like General ledger(GL), Accounts Payables(AP), Accounts Receivables(AR), Advance Global Intercompany System (AGIS), Cash Management(CM), e-Business Tax and Vertex
• Hands on experience in supporting Oracle Application Modules Fixed Assets (FA), Purchasing Order (PO), Order Management (OM), Advance Collections.
• Good functional knowledge in "Procure to Pay” and “Order to Cash" business flows.
• Good understanding of (AIM and OUM) on documents: BP075, BR100, MD050, MD070, RD060etc.
• Specialized in Financial module, has effectively streamlined operations at various client locations (India and USA) and won several client recommendations.
• Supported the production system with day-to-day issues and worked with business users and Oracle Support as required.
• As Functional Consultant, worked efficiently with multi-national teams. Ability to interact with individuals at all levels and Accustomed to working under tight schedules.
• Excellent Functional skills in Financial Modules.
• Knowledge on Oracle Cloud on all Finance modules.

TECHNICAL SKILLS

ERP Products: Oracle Applications Version 11.5.9 / 11.5.10 / 12.1.1 / 12.1.3 GL, AP, AR, AGIS, E-Business Tax, Vertex, FA, CM, PO, OM, Alerts, ADI and Flex fields.

ERP Engagement Expertise: Oracle ERP Implementation, Upgrade, Onsite/Offshore, Production Support, User Training and Testing, Requirements Analysis, Business Process Study, SR/TAR Management

Other ERP/Related Skills: GAAP Accounting, Month End Close Process, COA Design, Multi-Org Design, IR/ISO, Intercompany Accounting, EbizTax-Vertex integration

Implementation Methodology: Oracle AIM, Oracle Fast Forward, Oracle OUM

Development Methodology: SDLC, E-R Modeling

Development Tools: Oracle Toad, SQL Developer, Oracle Developer, Discoverer 4.1, 10g, SQL*Loader, Data Loader Others Edit plus, FTP tools

Languages: SQL, SQL*Plus, PL/SQL

MS Products: MS Projects, Visio, Excel, Word, Power Point

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

Senior Oracle EBS Financials Functional Consultant

Responsibilities:

• End to end Implementation of module - AGIS (Advance Global Intercompany System) for APAC, EMEA and NALA regions.
• Worked with Oracle (on SR’s) closely, created 19 Service requests with oracle on various patches, bug fixes and enhancements requests with Oracle for AGIS.
• Worked with business users and IT on Requirement gathering for intercompany solutions (on 170 entities).
• Identified delta setups and Documented BR100, MD050, BP075
• Configured delta setups like organizations, security, system options, Transaction types, assignments, customer and supplier associations, customer and supplies along with their site creations etc.
• Tested the end-to-end process through WEBADI and normal AGIS process.
• Created new Legal entities, Legers and OU’s for APAC, EMEA and NALA Regions.
• Defined new secondary ledgers and their mapping for (12 countries).
• Defined document sequencing, Accounting sequencing and reporting sequencing for the secondary ledgers and tested end to end.
• Changed subledger accounting options from Detail to Summary for all Ledgers (65).
• Worked on FA Tax books conversion for the newly acquired acquisition assets (around 14000 assets).
• Provided the solution and converted tax book through FA TAX INTERFACE.
• Liaison as functional consultant with business users, OBIEE development team for the newly developed AGIS and GL custom reports (worked on Requirement gathering, MD050, testing etc.).
• Conducted CRP1, CRP2, SIT & User Acceptance Testing (UAT) and getting sign off.
• Resolving issues Go-Live and post production support.

Environment: Oracle Financials 12.1.1: AGIS, GL and FA.

Confidential, Schaumburg, IL

Senior Oracle EBS Financials Functional Consultant

Responsibilities:

• Worked with business users and IT on Requirement gathering for all the modules (GL, AP, AR, CM, AGIS, Web money and Ebiz Tax - Vertex).
• Identified delta setups and Documented BR100’s and getting business sign off before configuring.
• Configured the delta setups in system (end-to-end) for all the Modules.
• Worked exclusively on Vertex for configuring 2 new entities with Ebiz Tax for Ebiz Vertex Related Profile Options, P2P Enablement, Configuration Owner Tax Options, Tax Rules, Vertex-Org, Vertex Rules and testing.
• Identified and created User Acceptance Testing (UAT) scripts.
• Conducted User Acceptance Testing (UAT) and getting sign off.
• Single POC from the Project team to Release Management.
• Resolving issues, Cutover Activities, Go-Live and support.

Environment: Oracle Financials 12.1.3: GL, AP, AR, CM, AGIS, Webmoney and Ebiz Tax-Vertex.

Confidential, Schaumburg, IL

Senior Oracle EBS Financials Functional Consultant

Responsibilities:

• Collected Business requirements for all the modules in-accord with the business users and IT. (GL, AP, AGIS, AR, FA, CM and Ebiz Tax-Vertex)
• Worked closely with data conversion team and gathered requirement before configuring in system for their data conversion objects.
• Identified delta setups, Documenting BR100’s, MD050 for RICE components and getting sign off before configuring.
• Created 35 new Operating Units as part of disintegration for Confidential Tech. (Including subledger modules).
• Worked on mapping the new Confidential entity’s with MSI existing locations.
• Created intercompany solution for new entity’s products.
• Coordinated between on- offshore team for completing the configuration for Fixed Assets, AGIS, and Ebiz Tax modules.
• Worked with Data conversion team on conversions and clean-up activities.
• Identified and created CRP& UAT scripts.
• Conducted CRP & UAT and resolved issues that raised during testing
• Executed Cut- over plan activities, prepared a list of all the Pre-& Post Go- live tasks with the team and provided production support with any conversion related issues until the end of ECP.
• Go-Live and support.

Environment: Oracle Financials 12.1.3: GL, AP, AGIS, AR, FA, CM and Ebiz Tax-Vertex.

Confidential, Schaumburg, IL

Senior Oracle EBS Financials Functional Consultant

Responsibilities:

• As Business Analyst worked on mapping the new entity’s locations with MSI existing locations.
• Configured Advance Global intercompany system for new entities with the existing entities.
• Created new Ledgers & their Operating Units (15) and configurations for all Modules and get it ready for conversions.
• Worked on mapping of objects between Oracle and Legacy system.
• Worked on exclusively on AR new entities configuration of System options, Auto accounting, Remit to address, Transaction types, sources, Receipts methods, Activities, customers creation, Approval limits, Collectors creation, Lock box, Messages and statement cycle for the newly created entities.
• Exclusively worked on service contact testing for the new entities - right from order creation, interface, auto invoice, create accounting and transfer to GL.
• Worked on creating new Fixed Assets books, Asset categories and security by book for newly created books.
• Configured GL Security rules, Journal sources for data conversion entities, defined and assigned new document sequencing for Italy and Spain entities.
• Worked with Business users and gathered the requirement for new Responsibilities creation and assigning profile options for the responsibilities, documented and worked with system administrator for the creation of new responsibilities and assigning to users.
• Identified delta setups and documenting BR100’s.
• Identified and created CRP& UAT scripts.
• Conducted CRP & UAT, Resolving issues.
• Prepared cut-over activities, executed cut-over activities, Go-Live and support.

Environment: Oracle Financials 12.1.3: GL, AGIS, AP, AR, OM, Service Contracts and Ebiz Tax-Vertex.

Confidential, Dallas, TX

Oracle EBS Financials Functional Consultant

Responsibilities:

• Worked on Post Production Support & New Enhancements. Provided Functional & Technical Support, Requirement gathering from Business/Users.
• Setups and testing of functional components, Created various oracle standard documents - RD60, MD50, and MD70 & BR100.
• Developed data scripts according to the business requirements.
• Worked on resolving daily production support tickets and insure the production problems are resolved within SLA for the support project.
• Worked extensively on UAT and CAT testing for new functionality implementations. Worked on month end closing activities.
• Prepared and conducted weekly status reports with IT and business stake holders on the Support and Project Progress.
• Created and updated documentation logs for the resolved custom process issues as a sourced of reference
• Interacted with Oracle Support to resolve Critical issues by raising various level severity Service Requests.
• Trained the Super users, IT team and Users on the new functionality and setups maintenance.

Environment: Oracle E- Business Suite 11.5.10.2 and 12.1.2. GL, AP, AR, Advance collections and FA.

Confidential, TX

Oracle EBS Financials Functional Consultant

Responsibilities:

• As a Techno-Functional Consultant responsible for Implementation and support of GL, AP & AR modules.
• Requirement gathering, As-Is-Process and To-Be-Process, Functional Design, Configurations.
• Prepared functional Document like MD50, MD70, BR 100 and Training Guides.
• Coordinated with the technical team to create customized solutions for the gaps.
• Testing of overall Application for various phases of the project: CRP, UAT etc.
• Troubleshooting issues related to Procure to pay business cycle with more responsibility on AP module.
• Set-up Supplier, Supplier Sites and all additional vendor related information in Accounts Payables.
• Developed several Custom Reports and Customized Oracle Reports
• Defined Invoicing Information, Payment Terms, Receipt Classes, Collectors, Territories and Invoice Sources.
• Set-up Customers, Customer Profile class, Profile attributes, Customer relationships, Statement cycles.
• Defined System Options, Transaction types, Auto Cash Rule Sets, Remittance Banks, Bank Branches, Bank Accounts, Bank Documents, Distribution Sets and Payment Methods
• Worked on service requests and interacting with the Oracle Support using metalink.
• Established Best Practices” and plan for continuous improvement of processes.
• Trained the Super users, IT team and Users on the new functionality and setups maintenance

Environment: Oracle E- Business Suite 11.5.10.2: GL, AP, AR, OM, PO and Inventory