SUMMARY:

• 9 years of experience as an Oracle Apps Financial Functional which includes Implementation, upgrades, Testing and Production support on Oracle Apps 11i, R12.
• Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Purchasing, Cash Management, Fixed Assets, E - Business Tax, Inventory, TCA, iSupplier and iExpense .
• Experienced in Supply chain modules implementing and supporting Order Management, shipping, Pricing, Purchasing and Inventory modules.
• Excellent configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support .
• Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user training sessions.
• Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
• Special expertise in implementation of self-service modules including, Internet Expenses, iSupplier, iReceivables and iProcurement.
• Implemented Financial Analysis Reporting by defining FSG Reports and Oracle Discoverer Business Areas and Workbooks.
• Proficient working with Oracle Support, creating and following up on SRs . Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports
• Experience testing Conversions, Interfaces, Data Migration and various custom RICE components.
• Good Team player and leading key business scenarios meetings with coordinating and getting signoff from business for the proposed business scenarios.
• Worked in Onsite and Offshore model projects, coordinating and leading offshore team
• Maintained configuration documents and compared against Business Requirement and made recommendations as necessary.
• Worked extensively with development team members in resolving issues by creating SR(s) and resolving issues while using METALINK (Oracle Support).
• Extensively used AIM methodology for designing standard documents (MD50, BR100, and CV10 & CV40).
• Thoroughly involved in creating Test Scripts TE040 and end to end testing TE060 cross modules.
• Good understanding of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL, PLSQL, TOAD etc.
• Proficient is documenting Specifications following AIM Methodology. Authored MD50, MD120, BR100, CV40 documents.

TECHNICAL SKILLS:

ERP Systems: Oracle Application R12 (12.1.3, 12.0.6, 12.0.4), 11i (11.5.10.2, 11.5.9)

Application Modulation: GL, AP, AR, PO, OM, Payments, iExpenses, iProcurement, iSupplier, Inventory, SLA/FAH, EB Tax, AGIS, Sourcing, AOL, Diagnostics, CM, FA, OSN, MDH, MDM, etc.Languages: HTML, XML, Java, SQL, PL/SQL.

Operating Systems: UNIX, Windows NT, Windows XP, Windows Server 2003, Sun Solaris.

Oracle Tools: FSG (Financial Statement Generator), TOAD, SQL Loader and Discoverer, Workflow, Reports, Forms, ADI

PROFESSIONAL EXPERIENCE:

Confidential, Framingham, MA

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 12.1.3 Production Support (Financials, P2P, O2C) (AP, AR, GL,FA, PO, iProcurement, OSN, EB Tax, SLA/FAH, AOL, RBAC, ADI, FSG, CM, iExpenses), AIM documentation, Workflow Administrator, XML Publisher Administrator, Microsoft Tools, HP Service Manager, HP Quality Center.

Responsibilities:

• Maintained Bank account signing authorities, managing Bank account statements in Cash Management.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Customized the ADI template to be Compatible with new Environment to upload Journal Entries.
• Reviewed assets and assisted business team reallocated, retired, move to one company or another.
• Worked on gathering the data cleansing requirements for Projects, AP, GL, and FA.
• Considered each element with regards to legal, competitive requirements and additionally reviewed the company’s record retention requirements and made recommendations for data clean-up.
• Identified all the data elements across the financial modules that needs clean up (either masking, purging or deletion),
• Resolved issues related to the P2P cycle before and after monthly, Quarterly and yearly releases.
• Tested End to End flow of PO’s created in Third party interface tool to R12 application.
• Participating/Coordinating with Business/Functional users in Application Configuration Set-ups.
• Interacting with the client on various forums to discuss the status of the task/issues, clarify any queries regarding the functionality/business requirement.
• Testing and debugging application and automation of manual day to day activates using Concurrent programs
• Functional setup for new Change Control's, Customer requirement, New Client setup for receivables and general ledger
• Worked in a SOX compliance environment
• Supported EDI transactions interfaced with EBS
• Supported EBS database upgrade from 11.2.0.3 to 11.2.0.4
• Worked on multiple deployments of projects into production based on business requirement.
• Supported custom integration in Oracle EBS with Concur on Travel and expense reports.
• Hands on experience on HP Service Now change management system which consists of tickets and project status.
• Actively worked with off shore EBS team and all the other application teams who has integrations with EBS .
• Improved application performance ( Oracle Purge automation with custom business requirement, Concurrent manager optimization)
• Troubleshoot/Fixed issues with Concur travel and expense reports both in USA and CANADA.
• Supported multiple production activities like environment clones, patch analysis, licensing, certificate updates etc.,
• Maintained more than 50 custom interfaces in EBS application, which has the following modules mentioned in environment section.

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 12.2.5 implementation (SCM and Financials) (PO, iProcurement, iSupplier, AP, AR, GL, EB Tax, OM, INV, QP, AOL, RBAC, ADI, FSG, CM, iExpenses), OIM, AIM documentation, Microsoft Tools.

Responsibilities:

• Understanding current business which is spread across multiple applications such as Biceps, Mainframe, RDS etc and with various stake holders such as C&S, ES3 and Ahold
• Coordinating Conference Room Pilot - CRP1, CRP2 and CRP3 sessions, logged issues and worked toward quick resolution of the help desk tickets.
• Coordinating with decision makers, systems owners, and end users to define the future system.
• Understanding the Gaps and developing the solution to custom approaches using R12 extensions.
• Preparing functional documents including BRD’s and MD50’s for customizations to fill the Gaps.
• Worked on Oracle implementation of iProcurement for the client’s strategic sourcing team
• Worked with Technical developer and modify workflow for Purchase order requisition.
• Created Global BPA for suppliers, Sourcing Rules and Approved Supplier Lists to enable automatic generation of purchase releases when a requisition is created to reduce labor intensive work.
• Provided service PO approval suppress solution to eliminate unnecessary service related PO approvals when PO was created from an approved requisition in Oracle Purchasing
• Custom approaches designed and implemented in current R12 system: Purchase Order interfaces, PO pricing process customized to use the Advanced Pricing modules to price the items in Purchase Orders.
• Worked on customizations in Purchase Order Form to provide more information to the users on the PO that matches the information in the Biceps system.
• Worked on Customizations in Purchase Order process to have multiple PO numbers from different sources in Oracle forms and use these PO numbers at matching processes at Receipt level and invoice level
• Worked on customization of several reports to provide the appropriate information to the business users
• Integration process among different applications to and from Oracle EBS using SOA layer
• Creating optimal custom responsibilities as per business need. Creating login rules: Responsibility owners and Approvers.
• Mass user on boarding from legacy system to R12-Responsibilities. Data migration strategy and Data migration planning.
• Set Price list, Qualifier and Modifiers and Formulas for Advanced Pricing (AP).
• Perform testing/retrofitting of RICE components.
• Performed functional testing and SIT and assisted the business users in UAT in both the release by preparing test scenarios and guiding the testing team.
• Tracking defects and issues during UAT (User Acceptance Testing) using RQM(Rational Quality Manager)
• Providing Training documents for business training and helping in business training.
• Working on post production/go-live support, working with cross-function teams in identifying and resolving post production issues.
• Working/Training Production Support team for future production support.

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 12.1.3 Upgrade (SCM and Financials) (AP, AR, GL, EB Tax, SLA/FAH, AOL, RBAC, ADI, FSG, CM, iExpenses), OIM, AIM documentation, Workflow Administrator, XML Publisher Administrator, Microsoft Tools.

Responsibilities:

• Involved in the upgrade of Oracle Modules GL, FA and CE from 11.5.8 to R 12.1.3
• Creation of Requirement gathering document (BR 035), Solution Design (BR 010) Specs for the financial modules.
• Prepared Mapping and Gapping Specifications.
• Defined the setups for integrating Oracle Projects into Fixed assets.
• Complete Setup that must be completed before setting up Internet Procurement.
• Customized various rules in Sub ledger Accounting module for deriving Tax and discount accounts on AP invoices.
• Integrated various third party applications into Oracle GL by integrating through Financial Accounting Hub (FAH) for maintain thin GL.
• Configured Application Accounting Definitions (AAD), by defining complex mapping rules and account derivation rules in FAH for integrating third party applications.
• Define AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options
• Presentation of Financial Consolidation system to the Management.
• Involved in Month-end support for close and reconciliation for AP and AR modules.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Setup Cash Management including bank account security.
• Maintained Bank account signing authorities, managing Bank account statements in Cash Management.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Customized the ADI template to be Compatible with new Environment to upload Journal Entries.
• Implemented parent child roll ups and updated Mass Allocation Setups.
• Assisted business team to zero out the balance sheet and P&L accounts for new company.
• Reviewed assets and assisted business team reallocated, retired, move to one company or another.
• Worked on gathering the data cleansing requirements, post production support for Projects, AP, GL, and FA.
• Considered each element with regards to legal, competitive requirements and additionally reviewed the company’s record retention requirements and made recommendations for data clean-up.
• Assisted in Cleansing customers, projects, project expenditures and project budgets one from the other company after the legal day1 of both the companies.
• Identified all the data elements across the financial modules that needs clean up (either masking, purging or deletion),
• Major interest in this project is the company split, provided functional review &impact analysis on proposed changes with the existing functionality and prepared MD-50 for the proposed modifications related to this company split scenario.
• Resolved issues related to the P2P cycle before and after monthly, Quarterly and yearly releases.
• Tested End to End flow of PO’s created in Third party interface tool to R12 application.
• Participating/Coordinating with Business/Functional users in Application Configuration Set-ups.
• The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 12.1.3 Implementation, (GL, AP, PO, AR, CM, EB Tax, FAH, AOL, iExpenses, iProcurement, OM, Inventory, Shipping, iSupplier, Advanced Pricing, FA), OBIEE, WINDOWS 7, SQL, TOAD.

Responsibilities:

• Identified Business Requirements & detailed Solution Design for GL, AP and Purchasing Modules.
• Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle GL & AP configuration (12.1.3).
• Creation of Requirement gathering document (BR 035), Solution Design (BR 010) Specs for the financial modules.
• Prepared Mapping and Gapping Specifications.
• Oracle Functional Financial lead for multiple roll outs and Functional Support
• Responsible for break-fix support of Oracle Finance and Projects modules.
• Responsible to perform root cause analysis of reported issues and problems
• Resolved issues related to FAH integrations from People Soft Payroll and Treasury applications into Oracle GL.
• Responsible to follow defined escalation paths in order to ensure appropriate focus and attention is placed on high priority issues affecting critical business functions.
• Responsible to perform system maintenance and support application and database patching activities
• Worked on the various Incidents (Tickets) that are logged in everyday by the users from different countries such as Australia, New Zealand, South Africa, Hungary and Romania.
• Worked on the setup & administration of iExpenses with Credit card functionality and AME.
• Worked on iExpenses incident Tickets to provide the resolutions for the issues logged by Users.
• Configured intercompany (AGIS) setups
• Worked on Reconciliation process to close the accounts as per month end.
• Tested end to end flow of Order to Cash cycle (O2C) and Procure to Pay Cycle (P2P).
• Identify the patches that need to be applied to prepare the Release 12.1.3 environment for implementing Oracle Internet Procurement.
• Raised SR’s with Oracle Support to resolve the issues which were part of Oracle Bug and provided necessary information as required
• Worked on RFC’s and PBI’s as per the user’s requirements.
• Documented Functional Specifications, Business Requirements and Business Rules to Prepare Test Schedules.
• Involved in Test Requirements/Scenarios,
• Designed Test Cases, Test Scripts, Test Data and Test Plans.
• Worked on various Configuration Setups in all the financial Modules.
• Provided resolutions to the issues logged by users through Remedy and HP QC.
• Defined the setups for integrating Oracle Projects into Fixed assets.
• Complete Setup that must be completed before setting up Internet Procurement.
• Customized various rules in Subledger Accounting module for deriving Tax and discount accounts on AP invoices.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Setup Cash Management including bank account security.
• Maintained Bank account signing authorities, managing Bank account statements in Cash Management.
• Configured Security and Cross validation rules to restrict the usage of departments and companies belonging to one Company by the other in sub ledger transactions.
• Customized the ADI template to be Compatible with new Environment to upload Journal Entries.
• Implemented parent child roll ups and updated Mass Allocation Setups.
• Assisted business team to zero out the balance sheet and P&L accounts for new company.
• Reviewed assets and assisted business team reallocated, retired, move to one company or another.
• Worked on gathering the data cleansing requirements, post production support for Projects, AP, GL, and FA.
• Considered each element with regards to legal, competitive requirements and additionally reviewed the company’s record retention requirements and made recommendations for data clean-up.
• Assisted in Cleansing customers, projects, project expenditures and project budgets one from the other company after the legal day1 of both the companies.
• Drafted extensive set of requirements, questionnaire and gap analysis.
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data.
• Involved in Configuration of Oracle I-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items.
• Developed Functional design documents to support to-be business processes.

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 12.0.6 Support/12.1.3 Upgrade, (AP, AR, GL, EB Tax, FA, iExpenses, Cash Management)

Responsibilities:

• Implemented the following modules: AR, AP, GL, FA, Cash Management, i-Expense, e-Business Tax, Sub Ledger Accounting, Oracle Payments
• Worked on the Functional mapping of data Conversions & Enhancements AR, AP, GL, i-Expense, SLA modules
• Analysis of client's requirements & designing the solution.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• 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.
• Pre upgrade testing and Post upgrade production live support.
• Involved in testing and validating the logic of Customizations, Form Personalization & Reports.
• Performed end to end testing and validation of the reports in CRP and UAT instance.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.
• Involved in complete end to end business solutions designing BF045, RD 20 for their legacy for the rollout project.
• Performed effort estimation for design and development for custom reports and GAP's.
• Conducted CRP and given hands on system trainings to business users.
• Involved in designing the financial reports and budgeting reporting.
• Managed technical team and testing team for delivering the custom components and various budget reports.
• Involved in migrating open transaction and supplier conversion process.
• Worked on setting up GL module - defining the Ledgers (primary and secondary), Ledger sets, data access sets, translation, revaluation, consolidation options, etc.
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Involved in design and configuration of chart of accounts, calendar and currency.
• Set up Suppliers, created Purchase requisitions, Purchase orders in Oracle Purchasing.
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds, etc.
• Developed new FSG reports and customized various standard FSG reports.
• Interacted and worked with the development team to solve the problems faced in the test scenario run.
• Worked on the AP Module setups - defining the Payment manager options, payment process profiles, payment process requests, payment formats, etc.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 12.0.6 Implementation (GL, AP, AR, PO, AOL, AME, EB Tax, Oracle Payments, SLA )

Responsibilities:

• Responsible for End-to-end Oracle Applications (GL, AP, AR, PO) implementation project from assessment to production support as a Functional Analyst.
• Study of the current Business Process and GAP Analysis using AIM documents,
• Created and Executed Test Plan and Test Strategy document and defined testing scenarios.
• Developed and Executed the Test cases & scripts for Smoke, Functional, System, Regression, Integration, Performance and UAT.
• Analyze and Design the model for Receivables and collections for intercompany transactions as first wave of the Project
• Delivered of BR100, Common Set-ups doc, Sys Admin Set-ups documents, Involved in the production support of AP and AR modules and worked closely with end users in resolving their issues.
• Produced technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
• Gathered application requirements and provided design recommendations.
• Helped design custom data models that integrated with Oracle Applications.
• Set up suppliers, supplier sites and payable options in E-Business Suite.
• Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
• Worked on setups of AME roles.
• Setup Receipt Classes, Receipts Sources and Payment Methods.
• Defined Quick codes for Employees and Purchasing.
• Configured the setups of tax users and profile option values in EB Tax.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Involved in regression testing and UAT.
• Configured the setup for raising Batch invoices and Batch payments.
• Configured the setups for prepayments and adjustment to payment to suppliers
• Coordinated and monitored Month End Closing process.
• Defined Payment process profiles in Oracle Payments.
• Generated various reports like GL, AP and SLA.
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules.
• Analyzed the support incidents logged in the remedy system and suggested as well implemented solutions.
• Involved in direct interaction with the business users and collecting information required for resolving support incidents.
• Conducted knowledge sharing sessions for the team members in the functional areas of known modules
• The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
• Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified the asset balances, maintained the books for a number of periods and transitioned the books to the users for maintenance.
• Performed functional analysis which implemented gathering user requirements accounts receivable system. Implementation included defining the System and Profile Options, define receivables lookups, define payment terms, defining transaction types and sources, define receipt classes and payment methods, and define Customer.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period. Setup Auto Accounting to recognize revenue based on Sales Order line.
• Provided functional review & impact analysis on proposed changes with the existing functionality and prepare MD-50 for the module extensions.
• Coordinated the rest of team members in identify and test interfaces between AP, PO and FA modules.

Confidential

Sr Oracle Applications Functional Consultant

Environment: Oracle Application 11.5.10.2 Support/ iExpense Implementation, (AP, AR, GL, iExpenses, ADI, PO, OM ), SQL, PLSQL, Reports, Forms, Discoverer.

Responsibilities:

• Worked as member of Support Team for modules GL, AP, AR and CM
• Reviewed daily support SR’s, co-coordinated with users and resolved issues
• Identified SR’s as GAP’s that needed customization and reviewed with management with GAP analysis document
• Developed functional documents for technical customizations in OM, INV, PO and AR modules.
• Implemented and delivered new Oracle functionalities with user interaction, performing systems and unit testing.
• Updated Value sets’ values for COA. Defined cross validation rules & security rules
• Designed Financial Reports using Financial Statement Generator (FSG) tool
• Set up of Parent & Child relations, Rollup Groups and summary templates
• Workflow Purchasing integrates with Oracle Workflow technology to create standard purchase orders or blanket releases automatically from Approved requisition lines.
• PO matching options, invoice tolerances, distribution options, terms, holds, etc.
• PO setup and matching options with invoices.
• Defined the Aliases, Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Helped in Inventory management module for costing problem. Inventory valuation report was not tying with General Ledger Inventory account. Cost group was the problem and physical inventory was not updating the quantity in the right