FUNCTIONAL CONSULTANT

Over 8 years of experience as consultant in Oracle ERP Implementations, Upgrades and Support mainly in General Ledger, Payables, Receivables, Purchasing, Inventory, Cash Management, Tax and Fixed Assets modules. Well experienced in implementation processes esp. Gap Analysis developing Custom components as per business requirements.

Experience Summary

• Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries like Banking, Pharmaceutical and Manufacturing.
• Designed process flows for each functional area during the implementation, Carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP's.
• Full life cycle Implementations and upgrades in 11, 11i and R12 with GL, AP, PO, AR, CM, FA, Inventory, iExpenses, EB-Tax, SLA.
• Designed solutions to enhance standard oracle processes - Order to Cash, Procure to Pay, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Proficiency in AIM Methodology to enrich project management and documentation processes.
• Expertise in preparing BP040, RD020, BR30, BR100, MD050, TE020 and TE040 documents.
• Proficient in analyzing the 'As-Is' Business Processes, Redesigning and Developing Business Process Flows.
• Wide experiences in requirement analysis, GAP analysis, design of the 'To-Be' process, Process Mapping, Data Conversion Management, Testing unit/integration/system .
• Collaboration with the Business users during the various stages of project lifecycle.
• Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization, and Reports.
• Good understanding in designing and requirements analysis for RICE Reports, Interfaces, Configuration, Enhancements Implementation, Conversion, Data Migration.
• Highly experienced in post implementation, support and training the end users.
• Good experience with Application Tools SQL DEVELOPER, TOAD, Data loader, ADI WebADI.
• Proficient Database Management understanding AR, AP, GL, CM tables predominantly.
• Interpersonal skills, self-motivation, communication and quick adaptation to new applications and technologies.
• Firm understanding of integration of Oracle Applications modules, Flexfields, MRC Setups, Multi Org, Revenue Recognition and AGIS.
• Experience with Approval Workflow AME configuration and customizations.
• Expertise in Reconciliation of Sub-Ledger modules with GL, R12 SLA, R12 Accounting Setup Manager, Inter Company Accounting and MOAC.
• Good experience with Oracle Business Intelligence Enterprise Edition.
• Proficient concept and implementation understanding of Multiple Reporting Currencies.
• Experience in Oracle Advanced Collections.
• Excellent communication skills.

Technical Skills

• ERP: Oracle EBS R12, Oracle EBS 11i
• Modules: General Ledger GL , Account payable AP , Purchasing PO , Account Receivable AR , Cash Management CM , Fixed Assets FA , Inventory INV and E-Business Tax.
• Operating Systems: Windows 7, Vista, XP
• Office Applications: MS Outlook, MS Visio, MS Project
• Database Tools: TOAD, SQL Loader, Data Loader, SQL Developer
• Reporting Tools: Discoverer, XML, Hyperion
• Processes: Order to Cash O2C , Procure to Pay P2P , Record to Report R2R

Confidential

Oracle Functional Consultant

• Key member in solving production issues and lead the Functional team.
• Worked on multiple enhancements for accommodating changes per the business requirements.
• Designed MD50s, Test Scripts for the enhancements and change requests.
• Demonstrated the impact of the enhancement to the business and users.
• Resolved issues with Customer Master, Invoice interface, Customer Interfaces.
• Desgined with MOAC Multi-Organization Access Control for the organization.
• Worked on Payment enhancements.
• Worked extensively on Order to Cash and Procure to Pay process.
• Customized Discount process in AP.
• Solved issues caused by the records being struck in the interface or staging tables.
• Trained, Conducted Practice Additional Business Requirements sessions.
• Have taken part actively in functional and regression testing.
• Supported production environments and users on daily basis by responding to emergency requests.
• Worked round the clock during AR, AP Period close process.
• Worked on several AP to GL reconciliation issues.
• Resolved issues during Payment Reconciliation with Cash Management.
• Customized Sub-ledger Accounting per the business requirements.
• Configured E-Biz Tax module for taxing information for AP.
• Worked on Order to Cash process.
• Designed, coordinated development and tested Customer Statements in AR to suit different business needs.
• Resolved issues during the statements generation process.
• Solved issues during AP Invoice and AR Invoice import, Customer and Supplier outbound.
• Worked on issues faced during custom Debit Memo process.
• Defined various classification lookups and mapping per the business need.
• Resolved issues encountered during Payment Manager i.e. batch payments of AP Invoices.
• Coordinated Functional testing, UAT testing.
• Coordinated with Oracle Support on a few critical issues.
• Designed interfaces to accommodate customer account for various business requirements.
• Quick in developing SQL queries inorder to fetch data per user's needs for analysis purposes.
• Worked on Custom reports massively inorder to accommodate different columns from customer accounts, customer transactions, receipt applications, tables etc.
• Have setup Transaction sources and types, Memo lines, Receipt Methods per business needs.
• Worked on Cash application customizations and enhancements in AR.
• Defined Cross Validation Rules and Security Rules.
• Resolved Lockbox, custom cash application, receipt netting, AP AR Netting issues.
• Designed Change Requests, Functional specs for any enhancement.
• Was extensively involved in decision making regarding the development needed to be done based on the business needs.
• Supported many implementation project teams with any information needed from AR.
• Worked on issues related to Balance Forward Billing.
• Was actively, Primary on-call contact for any issue.

Confidential

Oracle Functional Consultant

Contribution:

• Acted as key member in gathering and understanding business requirements.
• Lead of the team during implementation.
• Managed Chart of Accounts, segments and value sets.
• Managed various cross validation and security rules.
• Defined exchange rates as the implementation and business needs.
• Created and generated FSG Financial Statement Generator reports.
• Configured MRC for multiple countries in various instances.
• Prepared documentation for the business requirements, configuration, testing. Also consolidated issues for future troubleshooting.
• Actively participated in the decision-making activities with business inorder to determine the rates to be used for conversion.
• Customized GL Calendar inorder to make one fiscal year into two years.
• Create new asset books effective to the calendar change. Also, coordinated the FA calendar with GL calendar.
• Resolved reconciliation issues due to calendar change.
• Resolved issues encountered during GL balances conversion.
• Resolved issues during AP, AR, FA period close process.
• Defined Corporate rates for different currencies.
• Customized GL balances load and transactions loads as per business requirements for different periods.
• Assisted technical team in developing custom program that would meet with the business requirements.
• Resolved issues caused by customizations.
• Analyzed impacts of customizations in 11i for R12 upgrade and also ability to eliminate any of the customizations after R12 upgrade.
• Analyzed and documented user functionality changes like payments manager, supplier maintenance, and customer master maintenance.
• Proposed new functionalities in R12 for implementation after initial assessment for Customer Refunds, AP third party payments and AP-AR Netting.
• Analyzed and documented the usage of FSG reports in Client ADI and the need to migrate to Oracle Reports Manager and it new functionalities.
• Had worked on the Legal Entity Architecture, Multi-Org of R12 to accommodate the current structure in 11i.
• Analyzed the customer reports that may need to be changed due to table level changes.
• Efficiently communicated with business about the progress of the implementation.
• Trained business and users on MRC configuration and functionality.
• Effectively resolved issues at any point of day.
• Communicated with Oracle Support round the clock inorder to get the issues resolved quickly.

Confidential

Functional Consultant

Contribution:

• Acted as key member in R12 upgrade and thus played a significant role in stabilization of the application.
• Performed analysis on the impact from current version of 11.5.10.2 to R12 upgrade for General Ledger, Payables, Receivables and Collections, Inventory, Assets and Cash Management.
• Managed Chart of Accounts with various segments and enabled flexfield qualifiers as per the business need.
• Created FSG Financial Statement Generator reports for consolidation of multiple legal entities.
• Created numerous cross validation and security rules.
• Enabled and disabled rules as per the need.
• Good understanding of integration of various subledgers with General Ledger.
• Configured AutoAccounting setups to ensure error free interface process.
• Resolved issues in AR Interface during AutoInvoice process and Tested the functionality.
• Delivered documentation to gather the user requirements for new features. And developed detailed test scenarios and test scripts.
• Implemented new features in R12 Cash Management Module to use multiple sources for reconciliation of same BAI codes.
• Customized Sub-Ledger Accounting' accounting rules to meet the business requirements for Revenue Recognition.
• Provided online details for each customer group through advanced collections customizations and statements to customers.
• Assisted throughout during Record to Report process.
• Implemented Procure to Pay process, Order to Cash process.
• Customized standard XML reports.
• Coordinated with users in multiple locations for requirement gathering and user training.
• Implemented AME workflow for AP invoices in R12.
• Configured E-Business Tax in R12.
• Configurations of additional taxes in eBiz-Tax in R12 for Payables and Receivables.
• Implemented Balance forward billing and consolidated all of the customer's activity for a specific period.
• Configured and Maintained collections through Oracle Advanced Collections.
• Managed Dunning letters through Advanced collections.
• Managed disputes and claims more efficiently through Advanced Collections.
• Maintenance of Issue Logs for reporting the status of the issues and conducting issue status meetings on weekly basis.
• Follow up of team members for the completion of tasks.
• Prepared documentation for the custom reports.
• Implemented iProc and iExpenses as part of R12 upgrade to use new features.
• iExpenses setup with multi level approval and paperless streamlines process.
• iExpenses travel policy definition and audit procedures.
• Handled functional testing and regression testing.
• Coordinated UAT testing.
• Conducted CRP sessions with end users.

Confidential

Sr. Functional Consultant

Summary of Role: Confidential is to implement and support P2P, O2C, R2R and other financial modules, optimize the usage of ERP, introduce best practices and establish controls live on R12 using all financial and supply chain modules.

Contribution:

• I have been associated with the project from the inception, Preparation of client presentation, and Interacting with the client for various information requirements.
• Prepared AS-IS document and provided initial demo to the client/super users to gather system requirements for General Ledger, iExpenses, Purchasing and Inventory, Payables and Receivables modules.
• Understanding requirements for AS-IS document for eBiz tax for Payables and Receivables.
• Setting up the CRP instance for training/ demo as per the requirements gathered during the business process study. Demo to the customers on the flow of business process based on the TO BE scenarios presented.
• Analysis of the current system by interacting with business and cross-functional team.
• Mapped the Client requirements with Oracle standard functionality, found gaps, prepared setup Documents BR 100 and delivered the solutions in terms of Customizations, workarounds, re-engineering and form personalization.
• Writing/executing scripts using SQL Navigator, SQL Developer to perform various extracts from database.
• Data conversions for AR Customers Customer Interface , AR Invoices and Receipts Auto Invoice and Lockbox , Suppliers Master conversion and Vendor Invoices. Both open and closed invoices converted.
• Created the conversion document CV10 and assisted the technical team in developing the conversion and Interface program for GL and AR.
• Participated in the financial accounting Month-end close process to ensure financial sub-ledgers, Accounts Payable AP and Accounts Receivable AR close successfully covering the Procure to Pay and Order to Cash cycles.
• Created and managed Chart of Accounts as per the business need.
• Created FSG reports for consolidation of multiple legal entities.
• Resolved problems relating to the process of reconciliation of GL with AP and AR.
• Worked effectively throughout Record to Report process that includes importing accounting from Subledgers, consolidation, financial reporting.
• Designed interfaces between external system and Receivables, Payables.
• Worked closely with Business Users to identify right data for conversion. Helped the users in cleaning up the data and created policy documents for future maintenance of master data.
• Worked with extracts of data from legacy system and molded them according to the Oracle Apps requirements verifying the integrity prior to the load into Oracle.
• Experience with MOAC Multi-Organization Access Control.
• Advanced Experience with Deferred Revenue process.
• Worked with auto application of receipts.
• Worked on Balance forward billing by creating several billing cycles, assigning them to customer profiles and generating them time to time.
• Reconciliation between Oracle financials and External systems.
• Resolved issues raised during AP and AR interfaces.
• Designed and developed XML Publisher reports inorder to suit the business needs.
• Monitored inventory, item costs, work-in-process values, and accounting entries.
• Analyzed, simulated and forecasted product costs.
• Managed collections through Oracle Advanced Collections.
• Efficiently managed Dunning letters through Advanced collections.
• Setup of Policy schedules such as Accommodations, Meals and Entertainment, Rental Car, Airfare, Mileage, Relocation, other travel expenses as part of iExpenses roll out.
• Implemented iProcurement and enforced various purchasing policies.
• Implemented revenue recognition to recognize the revenue into various periods.
• Defined Accounting Rules in AR for quarterly, half yearly and yearly schedules, so that invoice amount was split into the various periods defined in the revenue recognition schedules.
• Configured AGIS for Intercompany billing.
• Developed/Updated Discoverer Reports for Month End Reports.
• Testing the functionality of new enhancements for new entitles in 11i.
• Full CRP1, CRP2, UAT1 and UAT2 testing cycles, with issue trackers and SME's sign of provided.
• Trained, Conducted Practice Additional Business Requirements sessions.
• Have taken part actively in functional and regression testing.
• Conducted CRP sessions with end users.
• Analyzed and tested Integration with 3rd Parties and legacy systems.
• Used SQL Loader for import into Interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Supported production environments and users on a daily basis by responding to emergency requests.

Confidential

Functional Consultant

Summary of Role: Confidential of the project was to support and upgrade the application version from 11.5.8 to 12i. I was responsible for all financial modules.

Contribution:

• Worked on R12 upgrade from 11.5.8 along with daily production support. Prepared financials module test scripts and tested the R12 upgraded system for setup and functionality. Tested custom programs, which are converted from 11.5.8 to R12.
• Implemented iExpenses to US operating unit.
• Designed and implemented the changes to the existing customizations GL daily rates load, GL data extract to ODS, GL data extract from Order to cash databases
• Prepared test cases for R12 upgrade testing and coordinated with QA team for test case execution
• Supported for iProcurement and iExpenses.
• Coordination with DBA team, offshore developers, cross-functional teams, release management team, performance tuning team, SOX compliance team, Org adoption team.
• Coordination with Oracle support for resolution of R12 bugs.
• Trained users on the new R12 new features especially new R12 modules.
• Suggested new period closing procedures because of R12 changes.
• Weekly status meetings to communicate progress on system support issues to management and user groups

Confidential

Functional Consultant

Confidential I implemented P2P, O2C, Inventory, and Costing Methods. Involved in identification of business process scenarios, gap analysis, configuration, Creation of test scripts, CRP testing and implementation.

Contribution:

• Functional Consultant for Purchasing PO , Payables AP , Receivables AR and Responsible for Supplier master modules.
• Gap Analysis and gap resolution for PO / AP / AR / INV.
• Involved in setting up meetings with Business users to gather requirements information.
• Followed AIM Implementation methodology.
• Gap and Fit analysis done based on the business requirements.
• Involved with Purchasing setups: Payment Terms , PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.
• Implemented Back-to-Back orders in Configured scenario where purchasing activity is involved.
• Implemented the pick sources using the global sourcing rules.
• Implemented the transit time calculation using internal locations, regions and zones.
• Working on issues related to Freight Charges from suppliers.
• Involved in setting up Cost types, Future, Engineering and additional Cost types, Defined material sub-elements, Defined Overheads, Material overhead defaults, Defined Category accounts, Associate WIP account class with Category accounts.
• Involved in the Creation of test script documents for CRP and UAT.
• Providing functional inputs to coordinate between client and Technical consultants related to application issues.
• Involved in setting up Out-Side processing flow.
• Captured the business processes in form of scenario matrix for testing various process alternatives followed as part of Bill of Material/Work in Progress/Costing/Quality and Planning.
• Designed and implemented a third party tool for handing massive intercompany transactions across multiple companies to handle 'Transfer pricing' and 'Cost plus' business functions.

Confidential

Production Support Analyst

Confidential ERP Applications P2P modules including AP, AR, PO, FA, GL, iExpenses. This was a 24x7 production support with users spread across different geographies and support personnel at onsite and offshore locations.

Contribution:

• Handled support for all financial modules as the first point of contact for P1 issues.
• Designed, implemented and supported integration of Oracle AR and AP with third party tax system Sabrix for US and EMEA entities.
• Responsible for Upgrade of Sabrix AR and AP connector for Version 5.3
• Coordination with Sabrix vendor for engagement in solution design.
• Worked with company architects to align Sabrix Architecture the company's Architecture strategy.
• Advisory role in gathering business requirements and in preparation of Functional Specifications.
• Ambiguity management and conflict resolution across cross-functional teams.
• Performed release management.
• Documentation of Setup Changes, Migration and bug Resolutions.
• Period closing support.
• User training and testing.
• Implemented Auto lock box in Oracle AR.
• Communicate progress on system support issues to management and user groups.