SUMMARY

• Around 10 years of experience as a consultant in Oracle ERP Implementations, upgrades and support mainly inGeneral Ledger, Human Resource Management System (HRMS) Procure to Pay (P2P), Order to cash (O2C), Account Payables, Account Receivables, Fixed Assets, Cash Management, Purchasing (PO), Inventory (INV) and Order Management (OM) and Advanced supply Chain Management (ASCP)modules. Well experienced in identifying Gaps & developing Custom components as per business requirements.
• Extensive experience in design, development, implementation, customization and production support of ERP system for advanced GL, ASCP, P2P, O2C, OM, CM, FA etc.
• Two full lifecycle Implementations R12 wif GL, AP, AR, FA, CE, iProcurement, iReceivables, iExpenses, E - business tax and Sub ledger Accounting(SLA) .
• Solid understanding of integration of Oracle Applications modules,Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.
• Good Exposure to Reconciliation of Sub-Ledger modules wif GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Designed process flows for each functional area during teh implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Expertise in AIM Methodology to enrich project management and documentation processes.
• Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay (P2P), Assets to GL, Inventory, Credit Card Transactions, GL Accounting processes.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.
• Designed teh Functional solutions to teh Key Gaps through Interface, Extension, Customization, Reports.
• Collaboration wif teh Business users during teh various stages of project lifecycle.
• Wide experience in requirement analysis, GAP analysis, Design teh ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system).
• Expertise in post implementation support, prepared training manuals and also trained end users.
• Well experienced wif Application Tools TOAD, SQL Developer, Data loader, ADI & Web ADI.
• Good Technical Knowledge on SQL, PL/SQL, Forms and Reports using for Inbound, Outbound, Extensions and Reports.
• Strong project management skills which include balancing multiple priorities wif aggressive time lines and budget initiatives.
• Ability to work in a team, worked TEMPeffectively in a multi-cultural environment and good at learning and teaching others.
• Excellent process orientation wif analytical thinking and problem solving skills.
• Ability to prioritize and execute tasks in a high-pressure environment.
• Interpersonal skills, self-motivation, and quick adaption to new applications and technologies.

TECHNICAL SKILLS

ERP: Oracle EBS R12, Oracle EBS 11i SLA, E- Business Tax, Alerts and Report Manage

Operating Systems: Windows 7, Vista, XP, Linux

Office Applications: MS Outlook, Visio, MS Office, MS Project

Database Tools: TOAD, SQL Loader, Data Loader

Languages: SQL, PL/SQL, C, XML.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Financial Functional Consultant

Responsibilities:

• Implemented a Highly Automated Financial processing system using Oracle EBS.
• Configured Accounting Flexfield, Account Maintenance, CVR's, Calendars, Currencies, Journal Controls, Journal Approvals, Ledger and Legal Entity Setups, Secondary Ledgers, Data Access Sets, Document Sequences, GL Profile options and Transactions Processing.
• Configured Mass Allocations, AGIS Setups in GL to Process teh Intercompany Transactions using Invocies.
• Multi Org set-up - Responsible for implementing teh multi-org set up wif multiple operating and inventory orgs.
• Implemented Revenue Recognition program to generate teh revenue distribution records for invoices and credit memos using Invoicing and Accounting Rules.
• Configured Invoicing Rule: Bill In Advance for Software Services.
• Configured Invoice Lines Accounting Rule: Duration, Rule Start and End Date.
• Implemented Fixed Assets Management: physical upkeep, asset tracking and financial administration.
• Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
• Automated teh AP Payment Process by using teh Electronic Fund Transfer (ACH) to reduce teh load on Check Payment Process.
• Configured Approvals Management (AME) for AP Invoice Approval and Hold Notifications.
• Configured teh Regime to Rate flow in EB-Tax to calculate teh Tax for AP Invoices.
• Customized SLA (Sub-ledger Accounting) functionality in R12 to provide Multi-period Accounting for Deferred Expenses.

Oracle Financials Consultant

Responsibilities:

• Act as teh IT subject matter expert for Spares Inventory accounting set up for Cisco acquisitions.
• Support Service Supply Chain Finance team to reconcile global spares inventory and reserves accounting balances.
• Partner wif Services Operations and Transfer Pricing Tax teams to define new spares inventory accounting for new entities and design IT solutions.
• Calculate, analyze and provide recommendations relating to reserves, FX, and asset recovery analytics. Assisted Finance team to stabilize huge swings in reserve variances plaguing teh Services organization for over four years.
• Perform fixed asset accounting ensuring accurate asset codes, depreciation method, etc.
• Monitored Standard Cost Update program in inventory organizations.
• Analyze spares inventory, reserves, revenue, COGS, and intercompany variances and provide recommendations.
• Creation of Functional Design Document, Technical Design Document
• Provide End User Training, Support to Finance, IT and Operations teams.

Confidential, Sunnyvale, CA

Oracle Functional Consultant

Responsibilities:

• Involved in implementation and testing ofOracle Applications FinancialR12 GL, AP,AR and CMmodules
• Involved in requirement gathering and analysis and design of teh application.
• Worked wif teh client team to understand teh current Business Process.
• Developed test plans and scripts and conducted testing for quality assurance.
• ConfiguredGL, AP modules in R12Environment.
• TEMPPrincipal lead for General Ledger Multi-org on an R12 implementation through initial
• Worked on requirements gathering, gap mappings, and various functionalities in General Ledger.
• Working on Payables and Cash Management setups and issues.
• Determined business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Worked on Setting Instances for new acquisitions.
• Working on post upgrade support and interacting wif Business users on Issue resolutions.
• Working wif teh developers on developing conversions, interfaces, reports
• Prepared Module design (MD050) Documents for Customizations.
• Worked on Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• DevelopedFSG Reports in GLlike (Income statement, Dept. Expenses, Inter Company Summary).
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
• Created and maintained User Menu objects.
• Created responsibilities assigned to users and set profile option

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management and Fixed Assets.

Confidential, San Antonio, TX

ERP Functional Consultant

Responsibilities:

• Interacted wif teh Business users for understanding teh Requirements and subsequently developed teh functional design to meet teh client requirement.
• Responsible for gathering Business Requirements (RD 020), Identifying Gaps & Fit Gap analysis (BR 010).
• Designed & implemented a Customization on “Refund process” (wif teh help of Technical team) to refund teh amount to teh Customer by cutting a check in AP.
• Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits teh Customer to avoid manual intervention.
• Evaluating teh Reports and testing them for teh desired outputs after development as Per teh Business requirements.
• Responsible for Baseline configurations for Accounts Payables, Accounts Receivables & Cash Management
• Providing solution for Revenue Recognition for Pacific Bio Sciences orders in AR.
• Helping technical team develop a customized Revenue Recognition program in AR
• Developed and executed test scripts and drove resolution of fixes to teh system prior To User Acceptance Test.
• Responsible for end to end testing on Accounts Payables.
• Testing teh entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
• Set up of Desktop ADI and test teh creation of Journals along wif WEB ADI.
• Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.
• Played significant role in system Integration testing.

Confidential, Chicago, IL

Oracle Functional Consultant

Responsibilities:

• Worked wif a team to implement teh Oracle financial modules for US and international operations
• Worked wif teh functional department to design and implement new business processes around requirements.
• Participated in providingProcure-to-Pay (P2P)life cycle support.
• Setup and ConfiguredGL, HRMS, AR, AP, FA, PO, CM, ADI, version R11i.
• Enhancements to Internet Expenses functionality.
• Implemented Oracle Cash Management for bank reconciliation
• Set up new account combinations and cost centers in teh Oracle application.
• Developed teh new chart of accounts.
• Performed hands on configuration setups forGL and AP, including budgets, multi-org & multi reporting currency.
• Participated in setting up ofMulti-Orgfor 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 teh profile options for GL.

Environment: R12- General Ledger, AP, AR, FA, CE, Alerts, Order Managerment, Report Manager, iProcurement & iExpenses.

Confidential, Austin, TX

Oracle Financials Functional Analyst lead

Responsibilities:

• Worked as Functional Analyst for Oracle Purchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets.
• Studied and evaluated functionalities of various modules.
• Defined Set of books, accounting flex field structure.
• Prepared Setup documents (BR100) for Accounts payables & Accounts Receivable.
• Created Responsibilities wif menu exclusions as part of SOD & tested all teh menus & functions.
• Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Prepared functional Design Documents for application extensions and conversions (MD.050).
• Prepared Test Scripts for Integration Testing (TE040).
• Handled post go-live user support.
• Developed teh training material for teh users.

Environment: Ledger, R12- General AP, AR, FA, INV, OM, iProcurement.

Confidential, Woburn, MA

ERP Functional Consultant

Responsibilities:

• Gather Business requirements and worked wif End-users on Issues resolution
• Study of teh current Business Process, Suggestion of future Processes andGAP Analysisusing AIM documents
• Preparation ofBR100, Common Set-ups doc, Sys Admin Set-ups documents
• System configurations and Set-ups configuration in teh new environment
• Resolved Client/User issues during Testing Phase
• Prepared and Executed Financials Test scripts
• Interacted wif End-users on day to day business operations.
• Worked on Reports Development.
• Validation of Data Migration and data loading
• Preparation of training materials
• Trained End user on Oracle Financials.

Environment: GL, AP, AR, FA, CE, PO & iExpenses