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

Oracle EBS Functional Lead

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
• Functionalsetup 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 withEBS
• SupportedEBSdatabase upgrade from 11.2.0.3 to 11.2.0.4
• Worked on multiple deployments of projects intoproductionbased on business requirement.
• Supported custom integration inOracleEBSwith 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 shoreEBSteam and all the other application teams who has integrations withEBS.
• Improved application performance (OraclePurge automation with custom business requirement, Concurrent manager optimization)
• Troubleshoot/Fixed issues with Concur travel and expense reports both in USA and CANADA.
• Supported multipleproductionactivities like environment clones, patch analysis, licensing, certificate updates etc.,
• Maintained more than 50 custom interfaces inEBSapplication, which has the following modules mentioned in environment section.

Confidential, CA

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,iReceivables), 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.
• Preparingfunctionaldocuments including BRD’s and MD50’s for customizations to fill the Gaps.
• Worked onOracleimplementation of iProcurement for the client’s strategic sourcing team
• Personalized theiReceivableshomepage and defined bank for new payment methods.
• 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 inOraclePurchasing
• 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 inOracleforms 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 fromOracleEBSusing 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.
• Performedfunctionaltesting 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 postproduction/go-livesupport, working with cross-function teams in identifying and resolving postproductionissues.
• Working/TrainingProductionSupportteam for futureproductionsupport.

Confidential, CA

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.
• Was involved in implementation ofiReceivableswith integration to Receivables.
• 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 Indexed the customer database to make customers available iniReceivables.
• 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.
• Assistedbusiness team to zero out the balance sheet and P&L accountsfor 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.

Confidential, MI

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 rand 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.
• Assistedbusiness team to zero out the balance sheet and P&L accountsfor 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.

Confidential, MN

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.

Confidential, WI

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.