SUMMARY:

• Around 8+ years of experience in ERP Implementation and support in Oracle E - Business Suite Oracle Applications 11i and R12.Knowledge in
• Oracle Rapid Planning. Proficient in functional aspects of Oracle Modules General Ledger (GL), Accounts Payables (AP), Accounts
• Receivables (AR), Cash Management (CE), Fixed Assets (FA), Purchase Order (PO), System Administrator, iExpense and iProcurement, iReceivables, iSupplier. Experience in creating and designing the model for iReceivables and provide for the end users.

TECHNICAL SKILLS:

Languages: Oracle Applications 11i (11.5.10/11.5.9/11.5.6 ), 11.0.3 and R12 and Tally 7.1Modules: Inventory, Purchasing, Order Management, Fixed Assets, Cash Management, Account Receivables, Account Payables and General Ledger.

Methodology: Oracle E-Business Suite Application Implementation Methodology (AIM)

Operating Systems: WINDOWS XP/2000/NT/9x, UNIX, Windows 2003 server.

Interface Tools: Forms 6i/4.5, Reports 6i/4, Data Loader, MS Office. CCW invoice tool

Applications: Citrix, Formscape, MS Outlook and Toad

Statistical Tools: SPSS, Microsoft Excel and Discoverer, Remedy, HP Clarity PPM, HPQC

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, California.

Functional Analyst

Responsibilities:

• As part of Twitter upgrade project I was part of upgrade project for P2P module
• Pre upgrade testing and Post upgrade production live support.
• Handled a team of 5 members to perform the deliverables on time.
• Part of Purchase Order clean-up process.
• Changes in the workflow procedures
• Re-construction of PO categories.
• Helped the business Streamlining Payment Process.
• Assisted/reviewed Payables and Cash Management.
• Performed Accounts Payable and Purchase Order Reconciliation
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in Accounts Payable.
• Corrected customer Profile class setup & statement to avoid multilingual statement printing.
• Configured and scheduled Standard Request Submission for standard APIs wherever required.
• Configured the setups for prepayment to employees and defined employee expense report.
• Helped the technical team in the supplier conversion, Open Accounts Payable invoices and payments conversion.
• Rectified Payment Options, Payment terms, Distribution Set, Payment format, Internal Banks in Accounts Payable
• Assisted and helped the supplier set up team.
• Provide post upgrade support.
• Resolving day to day activities of end users relating to Accounts Payable & iProcurement.

Environment: Oracle Applications R12 Accounts Payables & iProcurement.

Confidential, San Jose, CA

Techno- Functional consultant

Responsibilities:

• Customization and support of Accounts receivables module.
• Implementation of credit check on Return orders.
• Performed all the set ups relating to Cash management, credit management and Lockbox.s
• Created new version of API for R12 orders which will perform credit check.
• Implemented logic to send notifications when credit check fails.
• Customized the print output file in Oracle based on the customer requirement
• Prepared MD 50 for credit check on return orders, print invoice template and also wrote MD 50 for restocking fees.
• Customized Pre & post Auto interface program based on the requirements.
• Implemented changes in CCW invoice tool.
• Conducted meetings with cross flow teams to decide the impact and provide solution for the same.
• Support given during day to day activities during month end activities
• Implemented both debit line and credit line in a RMA credit
• Worked on setting up the Approval Hierarchies in Accounts Receivables Module.
• 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.
• Worked on the Auto Lock Box process in AR.
• Analyze and Design the model for Receivables and collections for intercompany transactions as first wave of the Project.
• Just design the new model for intercompany transactions as first project wave with AR and Advanced Collections and for the second wave, let the model for commercial operation.

Environment: Oracle Applications R12 Accounts Receivable Customization projects.

Confidential, Atlanta, GA

Financial Consultant

Responsibilities:

• Implementation and support of Accounts Receivables and Account Payable Modules.
• Implementation of iExpenses Module.
• Created a base template to gather country specific localization requirements.
• Managed team in India to implement the P2P Business flows including GL, FA, iProcurement, PO, AP, iExpense, EB-Tax modules, Cash Management and Bank Integration.
• User and CRP, SIT, UAT successfully.
• Configurations and setups for Ledger, Legal Entity, Operating Unit and Locations for new countries.
• Worked on setting up the new tax rates including VAT and withholding taxes as localization requirements, iExpense templates (parking, per diem, corporate cell phone and mileage rates), Approval Hierarchies in Purchasing Module, and Fixed Asset Books and Categories.
• Procurement/Purchasing: Setup the approval hierarchy, approval groups and approver assignment and designed workflow customization. Prepared the custom PO Print Program - MD050 and worked on custom PO Detail Report.
• Involved in the Item Master Setups in Inventory module including setting up of Item templates.
• Defining item attributes, enabling the items in various orgs and adding items to the Catalog in iProcurement.
• Worked on Romania bank integration - ability to make payment from OFA to Deutsche Bank (DBI) Online system.
• Conducted meetings with AP and Treasury to decide the payment methods and further, prepared MD050 and payment generation files for Domestic and International Wire payment methods.
• Also completed Mexico bank integration with HSBC for ACH and WIRE payment methods.
• Conducted Regression testing and Negative testing.
• Prepared the CRP plan, conducted kick off meetings, and created testing trackers and metadata for .
• Provided Post-production live support.
• In Advance Pricing, Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• 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.
• Worked on the Auto Lock Box process in AR. iProcurement: Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment.
• Support Production issues on a day to day basis including month end closure P1 issues.

Environment: Global Expansion Rollout Project (GL, FA, EB- Tax, iExpense, iProcurement, Purchasing, AP, Sub Ledger Accounting, Bank integration).Oracle Application R12 (AP, AR, GL, FA, CE)

Confidential

Finance Functional Consultant

Responsibilities:

• Worked with a team to implement the Oracle financial modules for US and international operations.
• Worked with the functional department to design and implement new business processes around requirements.
• Participated in providing Procure-to-Pay (P2P) life cycle support.
• Setup and Configured GL, AR, AP, FA, PO, CM, ADI, version R11i.
• Enhancements to Internet Expenses functionality.
• Implemented Oracle Cash Management for bank reconciliation.
• Set up cash management for automatic loading and auto reconciliation of all the bank statements.
• Developed interfaces for Bank Reconciliation and Positive Pay transactions.
• Setup Cash Management to use with Oracle General Ledger, Payables and Receivables.
• Set up a Bank reconciliation process in Oracle Cash Management and Accounts Payable.
• Set up bank transaction codes for the bank accounts for BAI and NSF files and assigned GL Accounts to the bank accounts.
• Setup Currencies, Exchange Rates, Organizations, Set of Books, Bank Accounts.
• Setup all the banks, bank branches and bank account for all the countries.
• Set up new account combinations and cost centers in the Oracle application.
• Developed the new chart of accounts.
• Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
• Participated in setting up of Multi-Org for managing multi-org setups.
• Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
• Defined Sub Ledger Accounting Methods.
• Responsible for full cycle accounts payable; review of internal travel and expense reports.
• Defined currency translation, conversion, revaluation and set the profile options for GL.
• Defined GL budgets and budget organization.
• Defined the approval limit for new employees.
• Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances.
• Developed the customer invoice, statements and dunning letters.
• Maintained cash and bank records, bank deposits and reconciliation.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Setting up FSG reports and custom views.
• Participated in interacting with all concerned end users to achieve proper guidance to design customized forms, reports and to perform interfacing.
• End user .

Environment: Oracle Applications R12 Implementation (Cash management)

Confidential, Seattle, WA

Oracle Financial Analyst

Responsibilities:

• Oracle Applications Functional consultant for Oracle R12 implementation and Production support project.
• Involved as a team member that upgraded the existing system from version 11i to R12 and later implemented the Oracle GL,AP, AR, FAmodules in R12.
• Pre upgrade testing and Post upgrade production live support.
• Account Payables: Functional analysis and setup of AP. Defined Financial and Payable options, Defined descriptive flex fields for additional information for vendor’s details and invoice transactions and provided solutions for invoice matching. Defined Vendors, Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and schedule recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, invoice distributions, invoice validations and holds, Recurring Invoices, invoice aging report formats. Set the profile options for AP.
• Defined the Funds Disbursement Setup to process the ACH payments.
• Helped the technical team in the supplier conversion, Open AP invoices and payments conversion.
• Helped the business in the month end closing process.
• Helped the business to close the periods and open the new periods.
• Initiated project for Reducing Interface Failure for invoices.
• Conducting Team Huddles and reporting issues to the management
• Involved in requirements gathering, configuration, documentation and testing for business roll out across new circles and warehouses in India. Configuration and management of Oracle Payables for new circles.
• Standardizations of operating procedures and reducing non-value added time in process by automating A/P Process.
• 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.
• 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.
• Prepared complete functional and technical documentation using Oracle AIM methodology and Order Management.
• Handling reconciliation of trade receivables and credit card receivables.
• Working with Bank Reconciliations team to work on the imbalances in Accounts Receivables process.
• Worked as an AR Lead.
• Headed a team of five members and monitored, improved and controlled the Accounts Receivables Reconciliation of ‘Hyatt’ group of hotels using Lean initiatives.
• Established and maintained strong relationship with Hyatt Financial Shared Service Centre (client) through daily communication discussing process status and improvement.
• Identified and instituted changes which improved the process metrics from about 80% to over 94% produced a cost benefit of 3 FTE.
• Daily reconciliation of Accounts Receivables clearing account and ensuring no imbalances exists by the end of the day.
• 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 account.
• Knowledge of Credit Applications.
• 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.
• General Ledger: 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 s to other teams as well as Refresher s to own team members on monthly basis.
• Inventory configuration for warehouses.
• UAT support for AP, AR and GL transactions testing.
• Able to lead 8 members of invoice processing team within a short span of time.
• Download inflow and assigning daily targets to team.
• Clearing critical invoices without missing Turnaround time (Tat).
• Handling escalation e-mails and calls.
• new joiners according to process learning path and responsible for person dependency of the process.
• Management reporting through Dashboard and production call with US client.
• Other activities such as planning & assigning work, driving leans &quality projects etc...
• 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.
• As an Admin. Of EDI-IN application take cares of SOX audit every quarter.
• Coordinating with the business users for their required enhancements.
• Stored, documented work by creating various folders for easy in GE Libraries.
• 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.
• Preparing Dashboards using the forecast methodologies and uploading to GE libraries. Prepared defect forecast and trend lines on data, prepared charts and pie graphs for presentation of data.
• Meeting Customer Critical To Quality’s / Service Level Agreement’s
• Ensuring quality deliverables on time.
• Preparation of materials

Environment: Upgrade from Oracle 11i to R12 and Implementation of R12 (Accounts Receivable, Account Payable and General Ledger, Cash Management, Fixed Assets).

Confidential, San Diego, CA

Functional Consultant

Responsibilities:

• Involved in Implementation and testing of Oracle Financial R12 GL, AP, AR and CM modules.
• Requirements gathering, Analysis, Design, Solution, Testing and Delivery.
• Managing Pre-Project, Mid Project and Post Project review with Oracle Partners and Clients.
• Upgrade from R12.0.5 to R12.1.2 version of Oracle Applications.
• In corporation of US specific new business functions in to the solution with the help of RCDs during upgrade.
• A2FR (Accounting to Financial Reports) solution for United States General Business with Accounts Payable, Accounts Receivable, General Ledger, Cash Management and Fixed Assets.
• Implemented US taxation for General Business through E-Business Tax.
• Design and Implementation of MOAC (Multi-Org Access Control) for General Business.
• Analysis of Localization and Business specific requirements and functionalities
• Design and QA of the following business flows
• Supplier Invoices to Payments (AP, Oracle Payment)
• Customer Invoice to Receipt (AR)
• Bank Statement to Cash Reconciliation (CM)
• Receipts to Asset (Fixed Assets)
• Assets to Depreciation (Fixed Assets)
• Subledger Journals to Post (GL)
• Period End close to Financial reports (GL)
• Preparation of Test Scripts (TE 040) for the above business flows to test the General Business US solution.
• Preparation of MD 50 and review of MD 70 documents Conversions, Interfaces and Extracts.
• Preparation of Post Install setup document and Functionality overview document.

Environment: Oracle Application 12.1.2, GL, AP, AR, CM, E-Business Tax, SLAM (Sub ledger Accounting Method), Payment Administrator, Multi-Org Access Control

Confidential

 Oracle Functional Financial Analyst/Production Support

Responsibilities:

• Analyzed the business processes, requirements, mapped with Oracle features, done the Gap Analysis.
• Worked with a team to implement the Oracle financial modules for US and international operations.
• Worked with the functional department to design and implement new business processes around requirements.
• Participated in providing Procure-to-Pay (P2P) life cycle support.
• Setup and Configured GL, AR, AP, FA, PO, CM, ADI, version R11i.
• Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
• General Ledger (GL): 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.
• 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.
• 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.
• Accounts Payable (AP) Functional analysis and setup of AP in 11i (11.5.4). Defined Financial and Payable options, Defined descriptive flex fields for additional information for vendor’s details and invoice transactions and provided solutions for invoice matching. Defined Vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and schedule recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, invoice distributions, invoice validations and holds, Recurring Invoices, invoice aging report formats. Set the profile options for AP.
• Enhancements to Internet Expenses functionality.
• Responsible for full cycle accounts payable; review of internal travel and expense reports.
• Defined the approval limit for new employees.
• Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances.
• Developed the customer invoice, statements and dunning letters.
• Account Receivables(AR): Setups for TCA Architecture, DQM, Customer Profiles, System Options, TAX Codes, Sales Tax rates, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Collectors, Aging Buckets. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
• Cash Management (CE): Cash forecasting & Cash positioning with bank wise details. Define System Parameters, Bank Transaction Codes, Forecast Templates, Bank Statement mapping.
• Integrated Vertex tax engine with oracle application for US and Global tax calculations.
• Implemented Oracle Cash Management for bank reconciliation.
• Maintained cash and bank records, bank deposits and reconciliation.
• Fixed Assets (FA): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL., Define Asset Categories, Location & Key Flexfields, Depreciation Methods, Corporate books, Tax Books, Security By Book feature etc.,
• Defined the Functional specifications for set ups and reports and transformed the specifications to the Technical Team.
• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Was responsible for functional setups in a complete Procure-to-Pay cycle for some worldwide instances.
• Maintained the regular interaction with the Client, End users, Technical team, participated in the meetings on regular basis and followed up the progress of work.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new Reports and Customizing the existing Reports.
• to super users and users.
• Coordinated Set up activities in UAT and Production Environment of all the modules.
• Supported the Team as Subject Matter Specialist in Financial Modules and business Process.
• Participated in interacting with all concerned end users to achieve proper guidance to design customized forms, reports and to perform interfacing.
• End user .

Environment: Oracle Application 11.5.9, GL, AP, AR, CE, FA, PO and Inventory, Procure to Pay, Oracle Applications Implementation 11i (GL, AP, AR, CE, FA)