PROFESSIONAL SUMMARY:

• Over 9+ years of experience in implementation, support and upgrade projects on Oracle Applications. Worked extensively as Oracle Apps Functional Consultant in modules like Oracle General Ledger (GL), Accounts Payables (AP),I - procurement, Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), Order Management (OM) and Purchase Orders (PO) and I expenses, CRM(Service and Contract). Experience in ERP Oracle Application E-Business suite on 11i and R12.
• Comprehensive knowledge of AIM (Application Implementation Methodology) and business flows like P2P and O2C.
• Experience with end-to-end complete ERP implementation and support. Very strong Business/Functional knowledge, experience. Multiple full life cycle implementations of Oracle Applications.
• Expertise in Requirements Gathering, GAP Analysis, Business Process Re-Engineering, Functional Design, Modeling Business Structures, Configuration, Testing, User Training, User Manual and Production Support.
• Implementation experience in General Ledger, Purchasing, Accounts Payables, Account Receivables, Fixed Assets, Multi-Org, Sub Ledger Accounting, Order Management, Inventory, Web ADI.
• Experience in Implementation of Procure to Pay process and Order to Cash Process, training users on ORACLE Applications from 11i to R12 version.
• ERP Fusion HCM Application Release 9, 8, 7 5 SaaS/Cloud, On Premise On Demand Models - Workforce Deployment, Profile Management, Talent Review, Workforce Directory, Succession Planning, Performance Management and Goal Management.
• Fusion Middleware   Oracle SOA 10g, Web Services, BPEL, ESB, XSLT, JDeveloper, Cloud Control Enterprise Manager 12c, Page Compose
• Got a hand on experience/training in Fusion HCM working on Core HR and have little exposure in Succession Management.
• Experience in various stages of SDLC, including end-to-end system testing, defining testing strategy, test scenarios and managed team for complete testing cycle.
• Expertise in interacting with customers at multiple levels in a variety of industries & business segments.
• Self-motivated with the ability to effectively manage time and multiple projects.
• Used Application Implementation Methodology for documentation purposes. Worked closely with Oracle Support and logged several Tars.
• Structural and methodical in approaching a problem resolution.
• Strong analytical and communication skills.
• Coordinated with stakeholders, business users and technical teams, designed ERP systems, decision support system that enhanced performance and increased revenues.
• Worked with cross-functional teams, re-engineered and synchronized business processes, transformed business problems into IT solutions.

TECHNICAL SKILLS:

ERP Skills: Financials (GL, AP, AR, FA, CM, PO), iExpenses, Project Costing and Report Manager

ERP Methodology: AIM

Oracle Applications: Versions R12/11i (11.5.10/11.5.9/11.5.8 ).

Databases: Oracle RDBMS (Oracle 10g/9i/8i/8/7).

Utility tools: SQL Developer, OBIEE

Programming Languages: SQL, PL/SQL.

Hardware/OS: Linux, Sun Solaris 5.5, Windows.

Project Management Tools: Microsoft Projects, MS Office & Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential

Sr Functional Consultant- Financial

Responsibilities:

• Gathered Business Requirement analysis using MD50, update the design team if it was a new requirement or an existing enhancement request.
• Trained new team members of existing CITI Process.
• Performed SME testing and manage the workflow for SME for Buying Desk (Customized Smart form for Raising Requisition)
• Performed Semi-Annual patch testing along India offshore IBM team in UATTEC instance when New patch (Oracle Recommended) was applied using TE40 and report the issues to development team.
• Manage production support for the IPPO team by maintaining INC tickets, talking to Business Users to understand the issues raised and then testing the same issue to replicate it and resolving it.
• Interact with Cross Fun Cross-functional team collaboration with Legal, Asset Management, and Finance. Assisted them in Making MD50 and testing as they were involved with testing the mobile application
• Facilitated Super User training and User Acceptance Testing (UAT).
• Managed Internal and Oracle Service requests (SR’s) for resolution.
• Resolved issues cross the Global Citi Bank teams by doing live session with them

Confidential, Miami

Functional Consultant - Financials

Responsibilities:

• Gathered and documented the business process in 11.5.
• Worked on customizing iProcurement Requisition and Receiving pages.
• Prepared GAP analysis and Functional Design documents for iExpenses and Accounts Payables.
• Prepared Project Plan for iExpenses and AP(p2p Project)
• Prepared Functional design documents for iExpenses Reports
• Prepared new features assessment in iExpenses module
• Import spreadsheet expenses to iExpenses
• Set up iProcurement , Train, Troubleshoot and debug iProcuremen t Modules. Load Items, Set-up and Maintain Punch-out sites.
• Provide solutions for reporting in OTBI Dashboards, use security to enforce specific business requirements, innovative solution for add participant functionality in Release 9.
• Conducted Unit Testing, Functional Testing and Integrated Testing on the upgraded environment for modules GL, FAH, AP, AR, PO, SLA, Iprocurement.
• Developed a custom program to update the B2B Purchase Orders and PO Requisitions as soon as the Sales Order is updated.
• Understanding the Business requirements to be a part of the FUD (Functional Upgrade Doc), and FDD (Functional Design Doc)
• Works with cloud operations team for patching, advanced diagnostics to solve complex issues
• Organized sessions to explain the interface table changes for GL, AP and AR.
• Implemented Report Manager Module to store the financial reports in the centralized repository.
• Customized standard PO Approval workflow to send user notifications for PO approvals based on preset the approval limits
• Conducted various UAT sessions to explain the upgrade changes to end users and made sure they were comfortable with the upgraded environment.
• Project Deliverables, Functional Design Documents and Application Setup document for Report Manager Module.
• Coordinated with high-level and end users to resolve issues in the Production environment for Projects module like period closing issues, accounting issues, account generator workflow issues.
• Worked on Reconciliation issues post upgrade and got them resolved with the help of Oracle Support.

Confidential, FL

Oracle iProcurement Functional Consultant

Responsibilities:

• Monitored business procedures and implemented system capabilities.
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Took part in implementation of Punchout for the organization.
• Worked on customizing iProcurement Requisition and Receiving pages.
• Assisted in identifying appropriate reports in Oracle mapping to current reports in legacy systems arriving at custom report requirements.
• Personalized iProcurement Preferences page, Requisition Summary display page and Requisition Checkout page .
• Worked on Unit/Functional Test of iProcurement Requisition and Receiving pages while developing the customized pages. The pages involving functional test would be creating iProcurement Requisitions based on different test scripts scenarios.
• Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle Apps. The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for EDI Vendors', 'Outbound interface for EFL Customers' etc.

Confidential, GA

Sr. Functional Consultant Modules (OM, AP, GL, AR)

Responsibilities:

• Requirements gathering, analysis, estimation, interacting with technical developers, system implementation, testing, third party client support.
• Functional Specifications, BR100 Documents, Test Cases and GAP-MAP documents
• Setting up of complete Order 2 Cash setup cycle.
• Assisted in configuration of Price List Setup, Qualifiers, Static and Dynamic formulas for pricing.
• Helped managing Stocked up items and non stock items by using BPA (Blanket Purchase Agreement) and Blanket Releases.
• Worked on Fixed Assets, which includes Asset Category Flex field, designing FA calendar etc.
• Involved in Account Payables Invoices and Payments Setups.
• Performed required steps in generating invoices in AR using Auto Invoice import program.
• Set up Vendors, Payment Terms, Quick Codes, Bank Accounts, and Interest Rates in AP
• Set up the Journal Batches, Creating Account Flex Fields, Web ADI, Creating COA (Chart Of Accounts) in GL
• Worked on iexpenses and configurations
• Involved in designing the functional specifications
• Developed of functional specifications for customer import program which runs daily to add the new customers from legacy systems and to update the customer profile classes / collectors, etc.
• Troubleshooting the auto-invoice program when auto-invoice program uses different ship to /bill to addresses than those attached to the customer.
• Developed of Auto-invoice program including development of templates for developers, specifications, configuring the functional set ups required for Auto-invoice, testing discoverer reports, customer interface program including template development.
• Training the users month end process for AP, AR and PO.
• Defined the Organization calendars, Item attribute controls, Interclass conversions, Sub-inventories, Category, Category sets, Cross references, Cost types.
• Identified and documented the business issues to be considered before entering Lead for setting up Multiple Sets of Books, Chart of Accounts, Calendars, creating Users, User Responsibilities, Journal Approval, Journal Batches Approval, Batch Periods, and Recurring Journals.
• Trained users entering Journals, creating Journal Batches, entering Journal lines, entering Foreign Currency Journals and Statistical Journals.
• Training supervisors for Posting Journals and Journal Batches.

Confidential, Framingham, MA

Functional Consultant

Responsibilities:

• Performed setups for General Ledger, Accounts Payables, and Purchasing modules
• Studied the user requirements and prepared Requirement Definition Document
• Analyzed legacy systems for potential implementation with release 11i.
• Involved in requirement gathering and analysis and design of the application.
• Mapped business requirements, created Set of Books, defined Cross Validation Rules, Security Rules, created Responsibilities and Application Users.
• System setup and design for its two Purchasing locations
• Defined Payment Options, Payment terms, Distribution Set, Payment format, and Internal Banks in AP
• Created end user training manuals and perform end-user training.
• Involved in documentation and testing as an Implementation team member
• Configured the set ups for PO and AP (Purchasing options, Financial options, Payables options)
• Helped with Month end closing process - Create Accounting entries, print month end reports, Transfer accounting to General Ledger.
• Helped in the consolidation process by Revaluation and Translation of foreign currency transactions and creating consolidation sets and transferring the balances to consolidation ledger.
• Configured all the Receivable options in AR.
• Thorough understanding of Multi organization access control allowing the users to submit requests, enter, view and access data of different operating units without having to switch between responsibilities.

Confidential, New York

Functional Consultant

Responsibilities:

• Overall Project management, scope management, project execution and control as per the Project Plan.
• Requirements gathering, requirement analysis, business process mapping and preparation of RD010, RD-050 and BP-080 documents.
• Performed the fit-gap analysis and identified the estimated efforts for customization/interfaces.
• Involved in the preparation of Functional designs for interfaces and other extensions for the client.
• Preparation of application configuration documents (BR100) for AP, AR, FA, PA and iExpense modules.
• Conversion strategy formulation and data conversion for historical fixed asset data and open AR invoices.
• Responsible as part of the team in the rollout of Oracle AME for AP Invoice approvals.
• Worked on the Electronic Funds Transfer (EFT) file layout with Bank of America and CIBC.
• Developed the UAT Test scripts for expense, Fixed Assets and Accounts Payables.
• Conducted the User acceptance testing.
• Quality Assurance Testing
• Troubleshot issues during the course of implementation.
• Provided post production support.

Confidential, Washington

Functional Consultant

Responsibilities:

• Involved in the analysis, design and implementation of i-procurement, purchasing and payables module. Confidential Life will be using the Local Catalogues as well as Vendor punch-out.
• Prepared the functional specifications for various P2P reports covering SLF sourceable spend.
• Designed the testing strategy document, test plan and approach, UAT test scripts for iprocurement, purchasing and payables.
• Performed configuration of iexpense module as per the client requirements. Configured rules, policies, and schedules setups. Configured the approvals, expense templates, integration of iexpense with payables.
• Worked as a business analyst to phase-out Oracle Financial Analyzer(OFA) and implement Oracle Hyperion Essbase and Planning and Hyperion Financial Reporting. Involved in the design and testing of the application purely from the Oracle Integration perspective.
• Implemented, as part of the team Hyperion Essbase Planning and Hyperion Financial Reporting at the client.
• Conducted the requirement analysis, prepared requirement documentation for P-card roll-out at Confidential .
• Conducted user acceptance testing with the business and got the sign-off.
• Data conversion and cut-over planning.
• Provides support for the Oracle Financials and Oracle procurement modules.
• Implemented the AP electronic invoice interface to bring in electronic invoices from vendors into Oracle AP
• Acted as an IT Lead in the design and implementation of Spend Analytics tool.