SUMMARY

• Having 14+ years of experience with End - to-End Implementation, Customization and Production Support Services.
• Provided consulting services delivering comprehensive set of value-added services for developing and implementing Oracle E-Business Applications.
• Proficient in functional aspects of Oracle Lease Management and Oracle Financial Modules General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CE), Purchase Order (PO), Sys Admin, iExpense and iProcurement.
• Extensive work experience on teh Full Life Cycle Implementation of Procure to Pay cycle (P2P) and Order to Cash cycle (O2C)
• Hands on experience with Oracle Fusion Financials, Oracle R12 and Oracle 11i Implementation.
• Experience in using Oracle AIM (V.3.0) of project implementation methodologies particularly Gather Business Requirements (BR.100), Solution Design (BR 010), Functional Documents (MD050) deliverables and Test Cases (TE030) for financial modules.
• Expertise in Oracle R12 Financial Modules and SLA, TCA, MOAC, EB TAX, Revenue Recognition, Oracle Payments and AGIS.
• Experience in User Requirement Analysis, Functional Specifications, Business Requirements, Business Rules to Prepare Test Schedules, Identify Test Requirements, Design Test Cases, Test Scripts, Test Data and Test Plans.
• Participated with Business / Functional users in set-ups and creating Job Aids.
• Proven Team Leadership and Project Management Experience.
• Collaborated closely with customer teams to accelerate teh speed of noledge transfer and drive teh highest value from teh successful deployment of teh Oracle E-Business Suite.
• Implemented Six Sigma Project involved in Defining and gathering requirements (DMAIC - Define, Measure, Analyst, Improve, Control), Root-Cause Analysis, Delphi Techniques, Lean Management and Calculating Sigma level.
• Personal Strengths include user interaction and Presentation skills.

TECHNICAL SKILLS

ERP and Applications: Oracle Applications 11i and R12 (GL, AP, AR, FA, PO, Cash Management, iExpense, iProcurement and iSupplier)

Operating Systems: UNIX, Windows NT / Windows 2000 / Windows XP / VISTA

Development Tools / Languages: UNIX, Windows, SQL and Knowledge on HTML.

Other Software/Testing Tools: MS-Office, MS Excel, MS-PowerPoint, MS-Project, Visio, SOX Compliance Testing Process, QC, QTP

Packages: Oracle E-Business Suite Applications 11i (11.5.9 and 11.5.10) and R12 (12.1.1 and 12.1.2)

Reporting Tool: Application Desktop Integrator (ADI), Financial Statement Generator (FSG).

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

Incident Management Tools: Remedy, HP Portfolio Project Management Tool

PROFESSIONAL EXPERIENCE

Confidential, Pennsylvania

Oracle Apps Solution Design Consultant

Responsibilities:

• Involved in enhancing and supporting Oracle Lease Management (OLM) and Oracle Financial Applications.
• Worked closely with Finance Controllers on resolving teh accounting issues related to US GAAP
• Worked on Compliance related projects.
• Experience in Mapping and gapping of teh requirements from 11i to R12
• Create and/or maintain a set of core system documentation to ensure teh governance of teh core ERP Solutions
• Performing project level design, debug and performance analysis
• Resolving core accounting reconciliation issues.
• Helped in formulating deployment strategies in teh ERP to ensure reliability and scalability for Confidential systems
• Investigating new technology solutions, performing product evaluations and build prototypes.
• Directly Involved in project plan, gathering business requirements, design, build and implement EBS Financial Suite including Oracle Lease Management, General Ledger, Payables, Receivables and Funds Disbursement/Capturing solutions

Environment: Oracle Application 11i and R12.1.2 (OLM, GL, AP, AR, PO, FA, CE)

Confidential, Michigan

Oracle Financials Functional Lead

Responsibilities:

• Providing Production Support and implementation Services for Australia/New Zealand/South Africa and responsibilities includes but not be limited to performing Analysis, Configuration, Design, Documentation, Functional Testing, Enhancements, Issue Resolution, Ticket Management, Root cause Analysis and Supporting Oracle Applications R12 Financial Modules include Accounts Receivables, Accounts Payables, General Ledger, Purchasing, Fixed Assets, Oracle Project Accounting and Cash Management.
• Involved in designing new custom tax reports for AU and NZ regions.
• Provides Month End Close support for all teh three regions for financial modules.
• Involved in teh monthly enhancements in all financial modules as requested by users.
• Participated in document creation for teh new enhancements include Requirement Gathering (RD 30), Functional Design (MD 50), Solution Design (BR 10), Test Case (TE 40), Test Plan and Test Results.
• Participated in User Training and Job Aid Creation.

Environment: Oracle Application R12.1.2 (GL, AP, AR, PA, FA, CE)

Confidential, Atlanta, Georgia

Oracle Functional (Consultant)

Responsibilities:

• Provided Production Support services for teh Financial Modules include General Ledger, Accounts Payables, Accounts Receivables and Cash Management.
• Involved in Incident management and Defect Management.
• Involved in teh enhancement of new functionalities as per teh user request.
• Period End Support/Monitoring for all financial Modules

Environment: Oracle Application R12.1.1 (GL, AP, AR, CE)

Confidential, Minneapolis, Minnesota

Oracle Functional (Consultant)

Responsibilities:

• Participated in teh re-implementation of Oracle Modules GL, FA and CE from 11.5.8 to R 12.1.1
• Creation of Requirement gathering document (BR 035), Solution Design (BR 010) Specs for teh financial modules.
• Prepared Mapping and Gapping Specifications.
• Defined teh setups for integrating Oracle Projects into Fixed assets.
• Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
• Setup Cash Management including bank account security.
• Participated in maintaining Bank account signing authorities, managing Bank account statements in Cash Management.

Environment: Oracle Application 11.5.8 and R12.1.1 (GL, FA, CE)

Confidential, San Francisco, California

Functional Consultant

Responsibilities:

• Participated in teh upgrade of Oracle EBS from 11. .1.2 for countries United States, Japan, Canada, United Kingdom, France and China.
• Prepared AIM documentations that include BR100, TE 040 (Test case Document) and process flow documents for financial modules.
• Lead teh requirements gathering sessions & assisted in teh design & setup effort for Financial modules
• Assisted in teh design of Barcode supported Supplier Kanban Labels and Manifest Printing extensions from iSupplier that is intended to replace legacy KDDI system generated Barcode labels.
• Performed System Administration tasks such as setting up custom responsibilities, function /menu exclusions, updating user profiles iSupplier & Core, setup DFFs/Value Sets/Values etc.
• Demonstrated key iSupplier Portal functionality such as Supplier access to PO information, change requests, work confirmations for Service POs ex: Barge cleaning etc, Invoice submission for completed services & to respond to RFQs submitted via Oracle Sourcing module.
• Used API’s in Data conversions/migrations following EBS coding standards.
• Participated in planning and delivering GL module which includes defining Ledgers, BSV’s, calendar, defining security rules, account aliases and used ADI (General Ledger Desktop Integrator) to integrate teh GL module to teh excel sheet) in Oracle E-Business Suite.
• Defined various Receivables and Payables lookups to meet teh detail level of reporting.
• Design new intercompany transaction model in AR. Improve Collection process for intercompany transactions using new features of Advanced Collections 12R and design a new model for Commercial Collections transaction.
• Setting up of AGIS functionality between Japanese Ledger and US Ledger.
• Defined Stores, Information Templates and Smart forms in iprocurement.
• Defined payment terms and set up teh discount policy for early payments.
• Defined banks, branches, bank account and payment documents for check, and wire and EFT payment methods for supplier’s payment disbursement.
• Monitored AP setups, especially supplier’s setup, invoice matching, payment setups and recurring invoicing setup.
• Setting up of Auto invoice Interfaces between AR, Billing System and Taxgen and interfacing bank files with Cash Management for automatic Bank Reconciliation, Interfacing Great Plains with Accounts Payable.
• Defined Sub Ledger Accounting Methods for US and Japanese instances.
• Participated in Auto Reconciliation setups in Cash Management.
• Setting up of Canadian Goods and Services Tax (GST) in EB TAX.
• Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Environment: Oracle Application 11.5.10.2 and R12.1.2 (GL, AP, AR) and I-Expenses.

Confidential, St. Petersburg, Florida

Functional Internship

Responsibilities:

• Study of teh current Business Process and GAP Analysis using AIM documents,
• Created Test Plan and Test Strategy document and defined testing scenarios.
• Developed and Executed teh Test cases & scripts for Smoke, Functional, System, Regression, Integration, Performance and UAT.
• Analyze and Design teh model for Receivables and collections for intercompany transactions as first wave of teh Project
• Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents, Involved in teh production support of AP and AR modules and worked closely with end users in resolving their issues.
• Write technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
• Gathered application requirements and provided design recommendations.
• Helped design custom data models that integrated with Oracle Applications.
• Involved in Sarbanes-Oxley (SOX) compliance testing process by including paper-based evidence, e.g., invoices, delivery receipts, purchase orders, bank statements and expense receipts
• Set up suppliers, supplier sites and payable options in E-Business Suite.
• Defined period types, calendars, Distribution sets, Tolerances, bank accounts payables documents, payment terms, approval groups and approval assignments.
• Participated in customization and personalization of iExpense pages.
• Participated in GL setups of Org Structure, Rollup groups and parent child accounts, cross validation rules and Value sets.
• Gathering requirements for lockbox interface, designing teh lockbox bank file format, setting up teh functional setup for lockbox, designing teh JP Morgan Chase interface validations for teh lockbox load.
• Responsible for Revenue Recognition Process.
• Defined mappings for Auto lockbox for JP Morgan Chase ACH payment gateway.
• Setup Receipt Classes, Receipts Sources and Payment Methods.
• Defined Quick codes for Employees and Purchasing.
• Defined Party/Party Sites in TCA.
• Defined catalog and non-catalog requisitions in iprocurement setups.
• Participated in setting up of tax users and profile option values in EB Tax.
• System Administrator skills - user creation, defining responsibilities, profile options and securities.
• Defined roll up groups to provide teh customize reports to teh top management with drill down features in ADI.
• Involved in regression testing and UAT.
• Involved in setting up of Tax Configurator in EB Tax.
• Configured teh setup for raising Batch invoices and Batch payments.
• Configured teh setups for prepayments and adjustment to payment to suppliers
• Coordinated and monitored Month End Closing process.
• Defined Payment process profiles in Oracle Payments.
• Generated various reports like GL, AP and SLA.
• Changed teh submission instructions on teh iExpense page.
• Established control over data access with creation of Menus and Responsibilities and by setting up flex field security rules.
• Participated in creating Expense Report Templates.

Environment: Oracle Application R12 (AP, GL and AR)

Confidential

Oracle Financials (Consultant)

Responsibilities:

• Worked with a team to implement teh Oracle financial modules for US and international operations
• Worked with teh 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 11i.
• 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.
• Implemented setups for checkout in iprocurement.
• Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
• Setting up of EDI Gate way for importing large volumes of invoices from legacy systems to oracle applications.
• Participated in Setting up Asset Key Flex fields, Asset Categories, Asset Locations, and Asset Calendar.
• 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.
• Defined GL budgets and budget organization.
• Defined teh approval limit for new employees.
• Configured teh setups for prepayment to employees and defined employee expense reports
• Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances.
• Developed teh customer invoice, statements and dunning letters.
• Maintained cash and bank records, bank deposits and reconciliation.
• 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.

Environment: Oracle Application 11.5.10 Multi Org Set up (AP and AR), GL, FA

Confidential

Oracle Financials Functional (Consultant)

Responsibilities:

• Implemented Oracle Applications 11.5.9.
• Handled Global Implementation of Oracle ERP (11i) for Optical Fiber Optics Division of Confidential Technologies.
• Directly responsible for teh configuration of Purchasing, Accounts Payables, i-Procurement, Inventory and worked with teh other team members on teh integration of Project Accounting, General Ledger and Account Receivables modules.
• Define Information Templates in iProcurement to pass necessary order processing information to suppliers.
• Implemented set of books (Chart of Accounts, Calendars and Currencies) in GL
• Defined Financials options, Payables Options and Payables System Setups to set control options and defaults values.
• Defined Accounting periods and Journal postings.
• Defined payment terms, tax code, aging periods, reporting tax entity, invoice hold and release names
• Defined various Purchasing and Payables lookups to meet teh detail level of reporting.
• Setting up of auto Bank Reconciliation process via CM (Cash Management) Module which provides for Automatic Generation of Reconciliation Accounting Entries, Automatic Recording of bank initiated activities, Automatic Reversal of rejected receipts, and teh ability to clear payments and receipts.
• Created organization structure, Sobs, GRE/Legal Entity, Operating Unit & Inventory Organization
• Participated in importing data to GL module through Journal Wizard.
• Experienced within Oracle Payables (AP), General Ledger (GL), and Oracle Receivables (AR).

Environment: Oracle Apps 11.5.9 (AP, AR and GL)