SUMMARY

• Highly experienced in ERP implementation and Support in Oracle E - Business Suite 11i and R12. Exceptional problem solving and analysis skills and a reputation for resolving particularly difficult and complex issues
• Experienced Oracle E-business suite functional consultant, working as an Oracle Private and Public Sector Functional consultant with an overall experience of 8+years
• Expertise in Oracle Applications Functional experience in multiple implementations, Version Upgrade and Post Production Support of Financials, Distribution and Manufacturing Modules in both R12&11i versions of Oracle E-Business Suite.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials (GL,AP, AR, FA, CE), E-Business Tax (E-B Tax), PO (Oracle Purchasing), OM (Order Management, Advanced Pricing), Service Contracts, Install Base, Manufacturing (INV, PO, OM, WIP, BOM), and Sys Admin.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).
• Involved in Month and close process and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
• Setup item cross references in inventory, modifiers, qualifiers and designed functional specs to send notifications when item attributes are changed .
• Proficient with the AIM Methodologies in documenting Business Requirement documents (BR 100, BR 30, MD70, MD120, CV040, CV060 ) and have some knowledge with OUM Methodologies.
• Good Knowledge on iExpenses, iprocurements, ireceivables, isuppliers and configured iprocurement punchout to external systems.
• Organized Conference Room Pilot (CRP), Business Requirement Work Shops, prepared Test Script / Test Scenarios, Conducted Application Unit Testing, Assembly Test, System Integration Test (SIT), User Acceptance test (UAT)/CAT.
• Experience and pertinent with technical tools like SQL, PL/SQL, Toad and Data loader.
• Extensively worked on Data conversion, Migrations, Interface programs and proficient knowledge on AGIS
• Developed and customized many complex reports for the analysis and diagnosis of data in oracle system according to the client’s business requirement, and also worked on form personalization.
• Tested end to end flow of order to cash and procure to pay after initial setups
• Customized standard workflows in the business cycles (P2P, O2C) and proficient knowledge on Trading Community Architecture (TCA).
• Proficient on new features of Release 12 (R12) of Oracle E-Business Tax (EB Tax), Sub-Ledger Accounting Method (SLAM), Multi-Org Access Control (MOAC)
• Recognized for excellent communication and business writing skills, people skills, project management capability, and the ability to work with the off-shore and on-shore team successfully influence and drive consensus across teams.
• Experience inSystem Administration tasksrelated to Menus/Functions, Responsibilities and Users
• Extensive knowledge on oracle application views, base tables, interface tables, oracle discoverer reports, XML publisher and workflow used for troubleshooting and resolution of production issues
• Conducted Training sessions in financial, Distribution modules( GL, AP, AR, FA, CM, OM) and FSG Reports
• Strong internal-consulting relationships with managers and end-users in functional and technical areas

TECHNICAL SKILLS

Enterprise Resource Planning: Oracle Applications R12, 11i

Oracle E-Business Suite/Modules: General Ledger, Accounts Payable, Accounts Receivables, Purchasing, Fixed Assets, Cash Management, Order Management, iProcurement, Inventory, sub-ledger accounting, iExpense

Technological Environments: Microsoft Windows, Macintosh, Linux and Unix

Database Tools: SQL, PLSQL, SQL Loader, Toad, Discoverer, XML reports, AOL, C, C++, Oracle databases

Database: Oracle8i/9i/10g, 11g

Office Applications: Microsoft Office Suite (MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook), Microsoft Visio, Apache Open Office

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Financial Functional Consultant

Responsibilities:

• Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents BR 100, BR 30, functional extension and design document MD 50 and identified GAPS.
• Carried out operational analysis (AS-IS), solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL (General Ledger), AP (Accounts Payable), CE ( Cash Management) and as a production support for Manufacturing Modules
• Coordinated CRP’s and was involved in Test Scripts preparation (TE 40), for GL & AP.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Training Super users & power users before start of CRP2.
• Involved in Period Closing & Reconciliation with GL
• Setting up Global consolidation & multi reporting currency & developed FSG Reports for customized Financial Statements.
• Trained users in FSG Reports and Created users and granted responsibilities to the defined users.
• Setting up legal entity, business group and operation unit.
• Setup AP payable system options, financial options, payable options, suppliers and operating units.
• Defined Invoice attributes, payment attributes - Approve, hold and release, special calendar, payment formats, pay group, payable document.
• Worked in Payment process profiles, defined banks, bank accounts & documents
• Worked on issuing payments for invoices in Accounts Payable module and approval hierarchies
• Created invoices with tax and recurring invoices in Account Payables and WEBADI additions in Accounts Payable Module
• Designed Auto Invoice Import process and documented the import process in AR
• Setting up and customizing dunning letter, statement cycle, advanced collectors and credit cards receipts in Accounts Receivable module
• Developed AR custom credit process where business uses a custom form to feed information and integrated with AR interface Process.
• Setup CE and created CE Responsibilities
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Conducted system study for Business Requirement and performed gap analysis for filling of gaps arising out of requirement mapping.
• Coordinated with Technical consultants for customization of various forms and reports.
• Worked with Technical Team for customization of Localization reports for AP & AR.
• Provided the post implementation support for financial modules, Inventory & PO module and resolving user queries.
• Providing post production support for Financial and Manufacturing modules (INV, PO, OM, WIP, BOM, Installed base).
• Configured 3-Way PO Invoice matching functionality to avoid discrepancies between Invoice, PO and receipts by amount and Quantity.
• Also involved in the Support role for Financial & Distribution modules and testing the integration of manufacturing modules with financial modules. i.e., procure to pay and Order to Cash and the transfer of the transactions there from to GL.

Environment: Oracle Applications EBS R12 (12.1.3) (GL, AP, PO, CE, OM, FAH, AOL), Oracle Database 11g, SQL, TOAD, Workflow, WEBADI, FSG Reporting, OBIEE, HFM, Windows XP/7.

Confidential, Long Island, NY

Sr.Oracle EBS Functional Consultant

Responsibilities:

• Implemented an Order to cash process which helped in capturing the accurate orders across multiple channels, seamless fulfillment and efficient shipping planning and confirmation.
• Provided a solution to get Automatic Defaulting information on the orders and validation of orders while entering the order, which reduced the data entry work and proceed to fulfillment without errors.
• Configured and supported Internal Order and Back to Back order process flows in a best possible way to prevent it causing any interruptions before fulfilled to meet customer needs.
• Gathered business requirement information from users to map them onto the Oracle application accordingly designed Functional specs for Order workflow modification’s as per business requirements to achieve business needs along with customer satisfaction.
• Designed and implemented Multi-Organization Access control (MOAC) across multiple operating units to enter transactions from single responsibility thereby enhancing user productivity.
• Provided an automated solution for shipping related process by enabling the auto-pick, auto pack and auto ship and provided the ability to automatically group the sales order to minimize the handling and shipping costs.
• Set up modifiers and qualifiers and implemented the customized workflows by analyzing the business scenario of the customer.
• Integrated Work-In-Process with purchasing which increased the collaboration with manufacturing partners for Outside Processing and also increased the ease in working with transactions related to the chargeable sub-contracting.
• Provided the production support for ongoing issues which are related to Order to cash like Order Import, booking, pick release, ship confirm, Customer invoice and intercompany invoice issues.
• Responsible for analysis/development of functionality integrating Oracle Order Management and Service Contracts
• Developed Auto lockbox Receipt Interface program to automate the receipt processing. Loaded the data into AR interface tables . Validated and imported the data into AR base tables
• Supported various scenarios that have encountered problems in order fulfillment, Pricing processes and solved them according to the business needs
• Another major functionality change from 11i to R12 was the move from customer/vendor data model to the TCA model. This involved major design changes and hence had a major impact on the upgrade activities. Hence this needed the usage of custom and TCA APIs to upload the new architecture data from previous version to the next version.
• Designed Customer interface to import customers from cloud systems
• Worked for R12 Upgrade of Financial modules and RICE Customization of Oracle Applications 12.1.3 and Release 12 modules such as AP, AR, GL, PO, I Procurement, I Suppliers and I Expenses.
• Prepared Functional Mappings for data conversion from 11i to R12 for all Financials modules.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, request groups, menus, responsibilities, and alerts between database instances.
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Migrated AP Invoice interface to load data from legacy system to AP interface tables.
• Involved in the development of interfaces/ Conversions to import the data from legacy system into oracle application base tables.
• Customized MODULES AP, AR & GL and FA in Multi - Org environment.
• Implemented full upgrade of FA from multiple legacy systems to oracle R12.1.3 and
• Partnered with business to gather requirements, designed new process end-to-end flows for the track and implemented the system in all the regions of the company.
• Loaded Assets through app load and reconciled the balances
• Worked on CV40 changes as per the requirements.
• Working experience in creating assets through Mass Additions and Copy the assets into Stat and TAX books and made adjustments accordingly
• Gathered the requirements from the users and performed full fixed assets setups for corporate, tax and Statutory books
• Document all the setups and updating the Tracker
• Performed security profiles setups based on organization hierarchy
• Created and maintained User Menu objects
• Created responsibilities assigned to users and set profile option
• Coordination with offshore team to enable them to understand the process and to familiarize them with the issues that normally generate and the probable ways of resolving them

Environment: ERP Applications Oracle EBS (12.1.3) /11i (11.5.9, 11.510.2), GL, AP, AR, FA, INV, Service contracts, OM, PO, iProcurement, iExpenses, iSupport, AIM, PL/SQL, OAF, Oracle 10g/9i, Reports 10g/6i, SQL*Loader, SQL*Plus, PVCS, Putty, Winscp.

Confidential, Troy, NY

Oracle Applications Functional Consultant

Responsibilities:

• Implemented Oracle Applications Financials R12 AR, EB-Tax and GL
• As an Oracle EBS Analyst Designed detailed Process Flow, establish Security And Control Requirements
• Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting
• Work with the developers to develop conversions, interfaces, reports (MD50’s)
• Worked on data mapping and documented all the data changes in CV 040's and submitted for approvals
• Whenever the SLA changes are made performed regression testing for all the events and make sure all the custom functionality is working as expected.
• Trained the users on month end activities, reconciliation and functionality of custom SLA
• Documented custom processes by using AIM Methodologies
• Involved in implementation of R12 EbTax, AR, AP, PO and some service modules (iProcurement, iExpenses)
• Configured Payables system options, and financial options and defined Payment terms, Payment set ups, and distribution sets
• Set up suppliers, supplier sites, bank accounts and process documents
• Led the requirements gathering and finalizing the process flow for distribution modules
• Responsible for the implementation of Receivables (AR) & E-Business Tax
• Set-up of invoices, debit and credit memos, guarantees, deposit transaction types, collectors, payment terms
• Configured transaction types, sources, receipt classes, banks and bank accounts
• Defined Tax Regimes, Taxes, Tax Status, Tax Jurisdictions, Tax Rates, Party Tax Profiles, Tax Zones in E-Business Tax (eB-Tax).
• Involved in analysis, design, and business process mappings for Integration project
• Collectively worked with other business analysts/consultants in development, testing and supporting activities with business for a streamlined flow of process in achieving company’s goals.
• Provided Support for Month End Closure, Conducted application patch Analysis, assisted application DBA in applying the patches and Conducted application regression testing.
• Production support for previous implementation and Provided support for AR and AP modules by resolving tickets
• Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management

Environment: Oracle Applications R12 (12.0.6/12.1.3 ) (AR, AP, PO, GL, AOL, OM, INV, QP,WSH, EB-TAX), Oracle Support, HP Service Center, HP Service Manager, Quality Center, Smile, TOAD.

Confidential, Webster NY

Oracle Functional Consultant

Responsibilities:

• Provided gap analysis, preparedprocess flow and system configuration/setup, Workshop, CRP1,CRP2, UAT, training documents and user training.
• Worked as a Functional Requirements Analyst & Application Tester and gathered information from Users and Business Analysts for setting up General Ledger and Payables Modules
• Prepared Impact analysis document for the upgrade of the financial modules from 11.5.10.2 to R12.1.3
• Conducted several user-training sessions on the system upgrade tasks- Trained in Sub Ledger Accounting, Budgets, Encumbrances and terminology changes from 11i to R12.
• Responsible for preparing upgrade plan for GL, AP, PO, AR, and I-Expenses with all customizations and form personalization.
• Define system options, Accounting Option, Lookups, Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types.
• Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable (AR) in Oracle cash management modules.
• Mapped the future state process requirements in AP and iExpense
• Defined Expense report templates in AP.
• Define suppliers, Payment Terms, collectors, customers Accounting rules and Receivables transaction source& types
• Worked on BR-100 documents for CRP/UAT and PROD for the AR & GL modules
• Conducted CRP and UAT sessions with business users in WAR room
• Involved in preparation of solution design documents, test scenarios, test cases and test results for the custom documents MD50
• Responsible for setting up the interfaces between legacy AR systems into the new Oracle R12 AR invoicing system.
• Setup purchasing for standard functionalities like converting purchase requisitions into standard purchase orders and blanket releases.
• Designed the solution in Oracle Apps R12 to interface the Customers data from Legacy system (MCKB) to Oracle.
• Execution of system setups for the above modules in the production environment.
• Configured auto Bank Reconciliation process via CE (Cash Management) module & Automatic Reversal of rejected receipts, and the ability to clear payments and receipts before Reconciliation with the bank.
• Responsible for setting up delta functional like MOAC, Data Access sets, Report Manager, Payment Process.
• Involved in Functional, Regression and UAT Testing.
• Responsible for coordinating the testing team to carry out the end to end functional flows across the Oracle Financial modules
• Involved in Regression testing of ONP Application (iProcurement).

Environment: Windows XP, Oracle Applications EBS 11i/R12 (11.5.10.2/12.1.3 ), (AR, AP, OM, CE, PO, INV, iExpense, iProcurement and GL), PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX Job Scheduling.

Confidential

Functional Consultant

Responsibilities:

• Responsibilities as a general accountant, fixed assets module, handling fixed assets additions, disposals and write offs journal entries, analysis ensuring the conformity to the agreed rules and regulations of the company.
• Reconcile and compare monthly fixed asset subsidiary ledger with general ledger, responsible for running the system monthly depreciation and ensure of the accuracy for the accounting entries per category before posting the system run.
• Contribute in the year end physical count committees for fixed and current assets in head office and site and resolve any resulting discrepancy discovered.
• Assist in managing debt obligations and lender relationships with the chief accountant, ensure treasury activities are in compliance with the group policies, accounting guidelines, internal controls and limits of authority, reviewing cash, checks transfer payments, deposits transactions and entries, revaluating all bank accounts in foreign currencies.
• Accounts payables module, review all invoices for appropriate documentation and approval prior to payment, entering vouchers using three way matching purchase orders contracts supplier invoices receiving report.
• Prioritize invoices according to cash payment terms process check requests, match invoices to checks, obtain all signatures for checks and distribute checks.
• Responds to all vendors and answers their inquiries, perform vendor analysis, aging reports and revaluation of payables in foreign currencies, inventory module, prepare and monitor all inventory transactions receiving issuance return disposal with a good knowledge of accounting inventory methods FIFO first in first out and weighted average, reconcile physical inventories to accounting record on a monthly basis and take the proper action regard any variances occur, compare inventory subsidiary ledger with general ledger on a monthly basis

Environment: Oracle Applications 11i (11.5.9) (GL, AP, AR, CM, FA, OM, AOL), TOAD, Service Manager

Confidential

Oracle Developer

Responsibilities:

• Performed daily monitoring of databases for availability and performance metrics
• Reviewed log files from overnight and batch processes for significant events
• Review SQL and PL/SQL for Production and sub-environments to ensure accuracy and optimization
• Manage and monitor failover/standby environments for the production system
• Designed, tuned and developed packages, procedures and functions to perform database activities
• Assisted in optimizing existing SQL/PLSQL packages
• Developed work flow diagrams, data flow diagrams and data mapping documents
• Assisted Database Administrators, Web Administrator, Release Manager, Quality Assurance Manager, and other ITO staff, as warranted to expedite software fixes that affect production, data quality, and access

Environment: Oracle Database 9i, TOAD, SQL*Developer, Reports6i, Forms6i, SQL/PLSQL, UNIX, HP Quality Center.