SUMMARY

• Over 8 years of experience in Oracle Applications as Functional consultant with hands - on Functional implementation/support experience.
• Extensive Knowledge of using Oracle AIM methodology for the project Implementation.
• Expert in Requirement Analysis, module setup, writing training documents, end user and production support.
• Work experience in all phases of software development life cycle including requirements gathering, analysis, design, configuration, testing, defect tracking, maintenance and reporting.
• Extensive experience in Oracle Applications R12/11i various modules (GL, PO, AP, FA, iProcurement, iExpense, INV, CM, AOL, AR).
• Hands on experience in implementing Rice.
• Formulated solution design and implementation strategy based on client requirements
• Trained the client’s super users on the application
• Involved in setup for Payables, receivables, General Ledger based on deep understanding of the functional processes
• Proficient in implementing Multi Organizational Setups (MOAC) in Accounts Receivables (AR).
• Participated with Business / Functional users in set-ups.
• Defining system parameters for Cash management with the default set of books and other information
• Design the new model for intercompany transactions as first project wave with AR and Advanced Collections and for the second wave.
• Worked in Oracle end user team to again a full knowledge of end to end process in both Accounts payable as well as Accounts receivable, which indeed termed as Due To (DT) and Due from (DF) Process.
• Excellent in various order types with the approval hierarchy in Order Management (OM) module
• Experience in the option classes in the Bill of Materials Application for the service items selection in the Order Management (OM).
• Proficient in analyzing Software Requirements specification and Functional Design Documents
• Excellent in analysis of current business processes, application configuration, managerial reports, and information processing
• Proficient team player with incomparable interactive skills and demonstrated ability to overcome complex problems
• Successfully led implementation of new Release 12 functionality for all functional areas as well as leading the design and implementation of modifications/customizations to the E-Business Suite.
• Preparing functional spec for GL, FA, CM and costing applications
• Experience in Application System Administration activities like managing concurrent managers, application user set up, defining responsibilities, value sets, flex fields, registering menus, reports in general ledger.
• Managed Oracle R12 Upgrade for Consumer Products Organization by leading Change Management meetings, developing project plan, managing internal and external resources, and communicating with appropriate departmental leadership and project steering committees.
• Proven Team Leadership and Project Management Experience.
• Experience on importing data from Sub-Ledger Modules (AR, & AP).
• Knowledge in oracle application views, base tables and workflow used for troubleshooting and resolution of production issues.
• Excellent presentation skills, analytical skills, problem solving capability and ability to communicate at different levels within the organization.
• Set up security rules to restrict user access for particular responsibilities.
• Conducted Oracle Application knowledge sharing sessions in financial modules AP, AR, band CM.
• Responsible for various phases of Oracle Applications like Functional Design and Development, Testing, Documentation, post implementation support.
• Working with Bank Reconciliations team to work on the imbalances in Accounts Receivables process.

TECHNICAL SKILLS

ERP Systems: Oracle Application 11i, R12

Modules: GL, AR, AP, FA, CM, AOL, TCA, PO, WIP, OM, INV, CRM, System Administration, EBS, SLA

Self Service Applications: iExpense, iProcurement, iSuppliers, iAssests, iReceivables

Platforms: Windows XP, MS-Word, MS-Excel, MS-PowerPoint.

Language: SQL. SQL, PL/SQL, XML

Data Bases: Oracle 8i/9i/10g

Web Technologies: JAVA, HTMLOther tools Toad, SQL Navigator, Data Load, Oracle Web ADI, Microsoft SQL Server 2010MS Access, SQL Discover, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle Financial Consultant

Responsibilities:

• Coordinated and documented detailed gap analysis between client requirements and Oracle R12 functionality.
• Documented the complete end-to-end process for GL, AP modules. Incorporated all the business scenarios in CRP demonstration documents for R12. Demonstrated the CRP to client for R12 Upgrade project.
• Conducted CRP, EP demonstration sessions, gather requirements (AIM methodology), prepared (AP and GL) Business process flowcharts.
• Involved in designing, setup and configuration of Organization structure with chart of accounts, calendar and currency, SLA
• Helped in Inventory 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 cost group. Supporting users after going live on all financial modules.
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application
• Troubleshooting and fixing the issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization issues
• Implemented Oracle Cash Management for Bank reconciliation. Integrating Bank accounts from AP, AR and Payroll
• Setup of Account Receivables, Account Payable, Payments and General ledger.
• Defined Period Types, Accounting Calendar, Special Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Creating Customers, Profile Classes & Bank information.
• Defining Application Rule Sets, Auto Accounting Rules.
• Used accounting setup manager for implementation Intercompany multi-organization framework on GL, AP
• Have done Setup for Consolidation, Conversion, Allocation In General Ledger
• Created MRC(Multi Currencies) having Multi Organization, Running FSG Reports and Sub-ledger Level reporting
• Configured Ledger Sets in GL and Sub-ledger Accounting (SLA) for AP Module.
• Did GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, SOB, Profile Options, Journal Sources, Consolidation Setups, Calendar.
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Defined GL budgets and budget organization.
• Reviews all invoices for appropriate documentation and approval prior to payment.
• Prints and obtains signatures on all accounts payable checks.
• Answers all vendor inquiries.
• Maintains all accounts payable reports, spreadsheets and corporate accounts payable files.
• Assists the Accounting staff and Headquarters’ personnel as necessary.
• Assists in monthly closings.
• Responsible for credit collections in account receivables by contacting the customer by phone, e-mail and written correspondence. Preparing and maintaining customer’s monthly reconciliation schedules.
• Process and issued credit memo after research has been completed.
• Assisting the company’s controller with any projects as assigned.
• Prepares analysis of accounts, as required.
• Participated in setting up of Multi-Org for managing multi-org setups.
• Set up new account combinations and cost centers in the Oracle application.
• Developed the new chart of accounts.
• Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
• Worked on Planning and Replenishment Inventory management tools like Cycle Counting, Physical Inventory ABC Analysis, and Max-Min Planning as part Inventory Optimization.
• As part of AIM Methodology implementation, provide client with Functional design (MD050), Unit Test Script (TE: 20), System Test Script (TE: 40), and User guide (DO070).
• Prepared Mapping document BR.030 and setup document BR.100 for Purchasing and Payables module’s
• Involved in application support, Identify issues and reach to solutions relating to customization as well as standard functionality for modules like GL, AP, i-Procurement and FA

Environment: Oracle applications 11.5.10.2 (Technology: GL, AP, AR, Cash Management, Fixed Assets, Advance Collections, Advance Pricing, OM, INV and PO), Oracle database 11g, 10.g, SQL, PL/SQL, TOAD

Confidential, Chicago, IL

Oracle Financial functional consultant

Responsibilities:

• Reviewed and analyzed the business requirements and functional specification documents.
• Setups meeting with business analysts and developers to clarify the design, flow and functionality of application.
• Keeping Track of all cash receipts and disbursements on a daily basis in cash management
• Preparing and recording journal entries in CM
• Created various order types with the approval hierarchy in Order Management (OM) module
• Worked on Quote Management in OM including creation of versions for the Quotes
• Prepared a user guide to explain the different set-up requirements to implement Web ADI.
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules
• Maintaining account reconciliation spreadsheets
• Conference Room Pilot (CRP1, CRP2, CRP3) execution according with Oracle’s AIM.
• Defined Sub Ledger Accounting Methods.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Setting up FSG reports and custom views.
• Validation of Clearing Account balances and Sub ledger to General Ledger balances and Closing the books in Oracle.
• Accurately process AP data (invoices and expense reimbursement requests)
• Conduct weekly AP check run
• Prepare reports and supporting documentation for AP audits
• Design & Develop FSG reports in GL
• Set up AP bank accounts, bank documents, bank codes and expense report templates
• Defined profile options to specify certain implementation parameters
• Set up Recurring journals template, recurring journals and Auto-reversal in GL
• Procure to Pay process improvements for Purchasing, Payables and A/P Accruals
• Prepared technical design and implementation documents.
• Responsible for processing credit reports in AR for verification of references, and establishing validity of information provided.
• Accountable for performing credit collections on accounts in account receivables .Pursued payment in the form of collection correspondence, delinquent statements, and phone calls.
• Worked on identifying customizations for theR12 upgrade.
• Reviews payable invoices for accuracy. Matches purchase order to receiving report to vendor bill.
• Communicates with vendors when necessary to correct or resolve invoice/payment issues.
• Processes purchase orders, invoices, checks, accounts payable reports and other verifications for owner.
• Prepared test scripts, test scenarios and regression testing objectives for Applications Integration Testing, User acceptance testing of module functionality after patch Application and after Applying customization releases.
• Used Discoverer to set-up ad-hoc queries and reports.

Environment: Oracle applications R12 (Technology: GL, i-Expense, Procurement Contracts, AP, AR, Cash Management, Fixed Assets, Sub Ledger Accounting, e-Business Tax, OM, INV and PO), Oracle database 10.g, SQL, PL/SQL, TOAD

Confidential, San Diego, CA

Oracle Financial Functional consultant

Responsibilities:

• Interacted with Business users in understanding the complexity of requirements as well as identifying Requirement gaps.
• Deliver required process and training documentation with regard to the P2P activities.
• Work with project team to implement new required modifications, mapping, integration and time and expense related tasks.
• Designed and Created Customers, Profile Classes & Bank information and General Ledger Accounts.
• Worked on Allocation, Revaluation and Conversion on GL
• Involved in month end processes for journals, SLA, Recurring and Reports with subsequent accounting
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO
• Understanding the business process and mapping it to the application.
• Created scenarios and test cases for enhanced scripting and testing.
• Customized ORACLE workflow process according to the business requirement
• Test integrity of customizations to ensure no overrides due to R12 implementation
• Created and executed test cases based on high-level and detailed designs documents for Procure to pay process, Invoice approval process for different customers in AP.
• Wrote and executed test cases and developed /maintained test scripts for both manual and automated testing for Payments made to different customer after claiming the insurance amount in Oracle Account Payables.
• Daily reconciliation of Accounts Receivables clearing account and ensuring no imbalances exists by the end of the day.
• Wrote and executed manual and automated test cases and test scripts for payment Invoices to customer, invoice by customer for claim, Quick invoice process, Invoice overview and withhold amount in oracle receivables and invoicing.
• Executed AD-Hoc queries to retrieve the data from different tables using TOAD.
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on OM, Advanced Pricing module
• Created user defined functions and used library functions for easier maintenance of script.
• Performed Functional, Regression, Ad hoc, and Smoke testing on various parts of claims application such as Pricing UI, Underwriting decision results UI, Stipulations UI, etc.
• Prepared first-rate Test Scripts to capture complete requirements and keep track of executed Test results in Test Director.

Environment: Oracle e-Business suite 11.5.5 GL, AP, AR, Cash Management, Fixed Assets

Confidential, Palo Alto, CA

Senior Oracle Financial Functional consultant

Responsibilities:

• Account Receivables: Created solution to perform AR API and Open Interface transactions for multiple invoice, debit memo, credit memo, and on-account application using a single receipt.
• Configured AR System Options, Customer Profiles, Transaction Types, Payment Terms, Tax Rules, Auto Accounting Rules, Transaction Batch Sources, Distribution Sets, Transaction Activities, Auto Cash Rule Sets, Receipt Sources, Profile Classes, and Lockboxes
• Created solution to send payment reminders from Receivables to past due customers.
• Created Oracle reports to provide full visibility of Receivables transactions performed by the interface.
• Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups according to the business needs in Order Management module with the SOX approval
• Worked on Shipping Tolerances at Customer level in Order Management Application
• Understand business process architecture for Order to Cash, Make to Stock, Procure to Pay of Taiping Carpets entities for business operations and re-engineered current business process during the upgrade to R12.
• Working with Bank Reconciliations team to work on the imbalances in Accounts Receivables process.
• Worked as an AR Lead.
• Identified and instituted changes which improved the process metrics from about 80% to over 94% produced a cost benefit of 3 FTE.
• Submission of all the Accounts Receivables reconciliations in Recon tool.
• Verification of General Ledger and Sub ledger balances for all AR related accounts and correcting, if any imbalance exists.
• Updating Management with daily report on high risk accounts.
• Responsible for opening of books (Period for Accounts Receivables) during the beginning of the month.
• Responsible for Accounts Receivables month end close and pre close on weekly basis.
• Updating management with un-posted items status of AR on weekly basis and resolving them.
• Supported and modified existing purchasing and receiving interfaces in PO and Auto Invoice in AR.
• Modified PO requisition workflow, AR notification workflow as per business requirement.

Environment: Oracle Apps 11.5.8, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, TOAD, Discoverer, SQL*Developer, WINDOWS XP.

Confidential

Senior Oracle Functional consultant

Responsibilities:

• Wrote and executed test cases and developed /maintained test scripts for both manual and automated testing for Payments made to different customer after claiming the insurance amount in Oracle Account Payables.
• Defined Sub Ledger Accounting Methods.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Validation of Clearing Account balances and Sub ledger to General Ledger balances and Closing the books in Oracle.
• Making rectification entries for any unresolved variances post period close.
• Conducting Cross Trainings to other teams as well as Refresher Trainings to own team members on monthly basis.
• Inventory configuration for warehouses.
• UAT support GL transactions testing.
• Clearing critical invoices without missing Turnaround time (Tat).
• Completed the learning path in 3 weeks and gained customers confidence and was the first one to perform the process activities live in production module on site.
• Updated Item categories, loaded new Items by using Oracle standard API’s. Added new product line/models for Inventory items.
• Involved in setup of WIP for outside processing items.
• Created multiple Oracle alerts.

Environment: Oracle Application 9i General Ledger, Fixed Assets, Sub Ledger Accounting, e-Business Tax, OM, INV and PO

Confidential

Accountants Executive

Responsibilities:

• Managed accounting and finance functions of the company.
• Preparing Income and expenses statements.
• Monitoring and Vouching Cash and bank accounts and transactions.
• Verification of Bank Reconciliation statement.
• Maintain customer records Reconciliation statements etc.
• Monitoring the day to day accounts payable and accounts receivable.
• Maintenance of accounts (manually and through tally) and Cash books.
• Ensure compliance with relevant legislation.
• Adept at determining requirements by interviewing client personnel, reviewing documentation and facilitating working sessions.
• Adept at creating business process models based on the requirements.
• Adept at mapping industry trends and best practices to the client's unique requirements and processes to determine applicable fit.
• Capable of defining, architecting and re-engineering business processes.
• Able to present solutions described above to senior client management via whiteboard and PowerPoint.
• Knowledgeable about the Oracle applications functionality, tools, templates and method and able to setup the system to meet the desired business process and requirements.
• Adept at working with clients to develop testing scenarios and test scripts and leading teams in unit, integration and acceptance testing.

Environment: Oracle Applications 9i Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV.