PROFESSIONAL SUMMARY

• Over 8 years experience as an Oracle Functional analyst in Oracle E-Business Suite with exposure to Implementation, Support, Upgrade and testing of Oracle Applications.
• Extensive work experience on Oracle Apps Modules which include Account Receivables, Advance Collections, I-Receivables, Accounts Payables, I-Expense, Purchasing , I-Procurement ,I-Payments, General Ledger , HRMS ,Trade Management and E-Commerce Gateway.
• Experience and Expertise includes Business Requirement Gathering, Requirement Mapping, GAP analysis, Functional architecture, CRP Conference Room Piloting , Solution Design, Proof of Concept, Unit Testing, UAT and User Training.
• Experience in Oracle 8i/9i, PLSQL, SQL PLUS, Oracle Reports, Forms, Discoverer 3i/10G , XML Publisher 5.6.3 and Oracle Workflow.
• Module implementation for Oracle E-Business 11i 11.5.10.2 and R12 12.1.3 for Financial Modules.
• Excellent knowledge on Functional Analysis and Implementation, Training the client's super users and users on the application and conducted pilot testing, integrated testing, design validation and setups.
• Experience with Other Utilities: TOAD, SQL Loader.
• Expertise in configuring, using administrating version control systems like Visual SourceSafe VSS , CVS and PVCS.
• A good team player with excellent technical, communication interpersonal skills.
• Motivated and determined to deliver high quality deliverables within deadlines with minimal supervision.

FUNCTIONAL SKILLS

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Financial Consultant

Environment: Applications EBS 12.1.3, Oracle 11g, Oracle Developer 11g, Oracle XML/BI Publisher

Roles Responsibilities:

• Study the Current State Functionality for AP, AR, FA and GL Modules.
• Present the Changed Architecture and new Features that R12 offers.
• Conduct discussion on Conversion Strategies for Financial Modules.
• Prepare the Future State Design Document across Financial Modules.
• Conduct CRP Sessions to test the System Functionality.
• Preparation of Functional design documents for new Customizations.
• Design of End to End Test Plan for the go-live of Oracle Systems
• Work Closely with Other Module Leads to define the dependency on each Modules.
• Provided End user Trainings for new Functionality in R12

Confidential

Oracle EBS Financial Consultant

Environment: Applications EBS 12.1.3, Oracle 11g, Oracle Developer 11g, Oracle XML/BI Publisher

Roles Responsibilities:

• Design of new Budget Structure in GL based on State allocated Appropriations and Segregations.
• Modification of Entire Rollup Structure for Chart of Accounts and definition of new Summary Templates.
• POC and Implementation of Encumbrance Accounting for the New Budget setup.
• Modification of Check Printing Templates in Payables.
• POC for AP/AR Netting which was over looked during the Upgrade to R12.
• Handling of other Functional issues across financial modules on a needy basis Receivables ,Payables, ,Purchasing, I-Expense and General Ledger .
• Preparation of Functional design documents for new Customizations.
• Involved in the design of End to End Test Plan for the go-live of Statewide Financial Systems
• Provided End User Trainings to understand standard ERP business definitions.
• Involved in the design of End to End Test Plan for the go-live of Statewide Financial Systems.
• Involved in unit testing, module testing and integration testing.
• Handled Statewide Agency Meetings on a weekly Basis for Go-Live Readiness.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.

Confidential

Role : Oracle Financial Consultant - Implementation

Environment: Oracle Applications EBS 12.1.3, Oracle 11g, Oracle Developer 11g, Oracle XML/BI Publisher, Oracle Discoverer

Roles Responsibilities:

• Single point of contact for the Business System Analysts and End users for gathering all requirements for Canadian Implementation of Oracle EBS AR,AP,I-Procurement and I-Receivables .
• Performed fit/gap analysis, pre-production business testing, conference room pilot support, interface/conversion mapping, and related documentation including BRD and BR100s for financial modules AR and AP.
• Modification of XML Templates for Netting Reports and Check Printing Formats.
• Functional Design for Customization of I-Procurement/I-Receivables Pages and End to End Testing.
• Customization of Refunds Functionality in AR
• Implementation of Lockboxes with RBC Bank via EDI.
• Provided assistance in EDI Implementation of Vendor Payments.
• Segregation of transactions into a Separate legal entity, operating unit and inventory organization.
• Design and Unit testing of Oracle Discoverer Reports for new entity.
• Modification of customer facing documentation to show Canadian subsidiary name, currency, logo, and addresses.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.

Confidential

Techno Functional Financial Consultant

Environment: Oracle 11.5.10.2, Database Oracle 10G, Windows XP professional, CVS, Oracle Report Builder 6i, Workflow Builder.

Roles Responsibilities:

• Handling of Functional and Technical Support issues across financial modules AR, Advance Collections, AP, GL, Purchasing, FA ,Trade Management and 'I' modules from very high to low severity.

• Involved in assisting Business with Period Close Issues and Reconciliation.
• Provided Functional assistance in the Implementation of I-Receivables and Advance Collections.
• Implemented Lockboxes in AR with Chase Bank which reduced a lot of manual effort in applying Cash in AR.
• Implemented I-Payment for Credit Card Processing of Financial Transactions. This enabled credit card payment of Invoices and Orders by external customers via I-Modules.
• Implementation of Deductions in Trade Management.
• Customization of Check Printing and Remittance Advice Processes in Payables.
• Encryption of Bank Accounts from Database Tables
• Developed Outbound Interfaces to Banks to send Financial Transactions from Oracle via EDI.
• Involved in making necessary research and resolving outstanding functionality issues via periodic patch updates from Oracle.
• Increased customer/end-user satisfaction by developing programs which helped in automation of Business processes.
• Provided End User trainings and transition on newly implemented business processes. Also provided assistance in helping user to understand standard ERP business definitions.
• Actively involved in executing technical design and sizing on proposed enhancements. Also involved in scoping and designing of the project from the scratch.
• Coordinated and performed code review of deliveries from offshore team.
• Involved in Source Code Management using CVS.
• Responsible for executing projects though complete project lifecycle of requirement definition till go-live. Managing schedules, resources for the project and interacting with end users and other stakeholders for project delivery.
• Involved in unit testing, module testing and integration testing. Handled Customer teleconference pertained to Oracle TAR Technical Assistance Request support and Status review meetings.