SUMMARY

• Possess more than 7+ years of professional experience in software industry with comprehensive noledge through all phases of software development.
• Worked on modules like GL, AP, AR, SLA and CE in R12 as Oracle Apps implementation specialist.
• Excellent R12 Oracle Functional noledge with Sub - Ledger Accounting, E-Business Tax, Multi Org Access Control and TCA. Worked with Tax ware integration to derive teh location specific taxes for shipments in US.
• Extensive Oracle financial experience in design, development and implementations, roll-outs, System Upgrades, integrations, process re-engineering, requirement gathering, gap analysis, system setups, interfaces, extensions, training & Support.
• Successfully implemented end-to-end life cycle projects in Oracle financials - GL, AR, AP, CE, PPM, FA and iExpenses, Advance Collections, Costing, WIP and Purchasing.
• Hand on experience with Procure to pay (P2P) and Order to Cash (O2C) lifecycle.
• Subject Matter Expert in Finance modules like General Ledger and Fixed Assets.
• Extensive noledge on Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration and AOL.
• Good understanding in various Oracle related products involving SQL,PL/SQL,OA Framework, Oracle Workflow, Form Builder, Report Builder, XML Reports/XSL Style sheets and Oracle Work flow Builder.
• Complete product life cycle experience starting from teh design phase till packaging and delivering, system testing, user training and also in burning support as post implementation support. Expertise in Oracle E-business Suite, CRM 11i applications, Oracle technologies PL/SQL, SQL*Loader, TOAD and SQL Plus.
• Functional Knowledge and implementation experience in industries like Telecom, Finance, Manufacturing and Distribution industries. Defined data migration templates to collect teh data for new deployment sites.
• Oracle forms application features. Worked as a finance track lead and co-ordinated with Off-shore during development. Performed functional and integration testing. Involved in all phases of SDLC - SRS (System Requirement Study), SDD (System Design and Development), UI (Unit Testing) and Implementation, IT (integration testing), Debugging, etc.
• Co-ordinated with Vendor and Client on all teh application related issues. Involved in Information Security and Business Continuity Plan related activities and coordinated teh project level audits.

TECHNICAL SKILLS

Oracle Applications: GL, AP, AR,OM,PO,PPM, FA,PA, CE, INV, HR, IB, SC, OTL, Payroll EB-Tax, I-Tax, i procurement, Trade Management, iReceivables, iExpense, Oracle Sourcing, Procurement Contracts, AME, TCA, Sysadmin.

Oracle GUI/Tools: Oracle Database 10g, 9i, 8i, 8, J Developer Suite 10g,SOA, BPEL, OAF,OBIEE, TOAD, Discoverer, PL/SQL,OA Framework, Oracle Workflow SQL*Loader, SQL,SQL*Plus, API’s, Oracle Reports/Forms 6i,Microsoft Visual Studio 6.0, J builder and Macromedia 7.0,Dreamweaver, Citrix

Systems: Windows NT/2000/XP, Linux, Unix and Main Frame.

Management Tools: MS-Project, Visio, MS-Office, Mind Manager, Rational Suit, HP Quality Center, Lotus Notes

Methodologies: Rational Unified Process, iterative, waterfall, TDM and Agile.

PROFESSIONAL EXPERIENCE

Confidential, East Greenville PA

Oracle Techno Functional Apps consultant

Responsibilities:

• Implemented Oracle eBusiness Suite dat included- General Ledger, Payables, Receivables and Cash Management.
• Also performed Purchasing and Order Management implementation.
• Testing and set up of tax calculation and rules in Eb-Tax& I-Tax for Supplier invoices on teh Procure to Pay flow including self-assessed tax functionality
• Led Chart of Account (COA) discussions with key stakeholders and Finance team and designed new COA structure based on business requirements.
• Possess Oracle Database 9i, SQL, PL/SQL, Oracle Forms/reports 6i, and Workflow, XML Publisher and Unix Scripting skills
• Involved in End-to-End Implementation, Upgradation, Customization and Production Support of Oracle
• Responsible for gathering Business Requirements, Solution Design, Gap Resolution, Application set-up and functional specifications for RICE components for financial modules.
• Implemented teh following business Flows using Oracle Business Flow Accelerator
• Supplier Invoice to Payment Customer Invoice to Receipt Bank Statement to Cash Reconciliation Sub ledger Journals to Post Period End to Close Financial Reports
• Supported teh technical team with Conversions.
• Implementing and rolling out teh developed solutions in Oracle ERP based environment.
• Developed solution designs for financial related customization and reports including SLA modifications and TCA setup
• Provided support to users and assist with troubleshooting issues and provide training
• Re-engineered complex RICE elements b/w oracle ERP and client’s Legacy system to ensure smooth business process.
• Performed Production Support activities for organization's internal customers
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups and MOAC security
• Performed functional designs driving towards simple, sustainable, and reusable solutions.
• Defined functional requirements and responsible for implementation of modules including IP/PO
• Knowledge in setting up AME rules specific to business.
• Created MD-50’s and TE-40 for several requirements ranging from Account Generator, iSupplier customizations, Requisition/Invoice workflow, PO output generator and several inbound/outbound interfaces with third party/legacy systems.
• Designed teh process for sending PO and receiving cXML Invoices using OSN.
• Designed and Implemented End-End process of iSupplier module for client.

Confidential, Santa Clara, CA

Oracle Financial Consultant.

Responsibilities:

• Responsible for reviewing and understanding teh business process. Prepared AS-understands document for AP, PO and AR modules.
• Assisted in business process reengineering, created TO-BE process document for AP, AR and Procure to Pay process module in Oracle Financial.
• Set-up of Chart of accounts structure, Segment, Values Sets, Flex fields and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar, Currencies, Set of Books, Assigning Set of Books to a Responsibility, setting up Standard Journals, Statistical Journals, Recurring Journals and Suspense Accounts and Mass Allocation, defining Financial Statement Generator, Creating Ad-hoc Reports, and Open and Close Accounting Periods.
• Provided Post Up gradation Support at Onsite with major responsibility to timely resolve production issues
• Prepared functional design document and Test case document for custom enhancements.
• Responsible for attending client meetings on giving project status, plan etc.
• Assessed teh current use of Oracle applications and teh mapping of new features and functionality of 11.5.10 to teh functionality required in teh present company environment.
• Responsible for providing identification, analysis, documentation, configuration and testing for procure to pay process of teh project.
• Highlighted Impact analysis in current business process due to upgrade changes/enhancements.
• Involved in preparing test cases as per teh requirement, testing all Configuration, Set up, end to end processes, interfaces, reports and conversion programs, coordinate with super user for testing.
• Participated in CRP, UAT, Go live activities and Post implementation support had extensive business user interaction during each phase of implementation.
• Also worked as a functional Lead for new 11i new invoice approval process using AIM and implemented successfully which has got high visibility in teh organization.
• Worked on all phases of implementation, involved in various stages of projects.
• Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified teh asset balances, maintained teh books for a number of periods and transitioned teh books to teh users for maintenance.

Confidential, Louisville KY

Oracle Functional consultant

Responsibilities:

• Performed Business Process Review (BPR) and GAP analysis to determine business requirements
• Designed FSG reports in General Ledger including Balance sheet, P&L, Cost Center related Management reports and SEC reporting
• Implemented Oracle Cash Management for bank Auto Reconciliation and integrating bank accounts from Payables and Receivables
• Provided Post-Production support after go-live for GL, AR and Cash Management Modules
• Revalued and Translated Foreign currency balances for Period closure and reporting
• Contributed for teh financial accounting Month-end and Year End close process to ensure financial sub-ledgers, Accounts Payable (AP) and Accounts Receivable (AR) close successfully
• Resolved problems relating to teh process of reconciliation between teh payable and Receivable modules with teh General Ledger
• Updated teh documents dat have been changed - core business processes, organizational impacts, roles and responsibilities.
• Worked with feeds team to import teh files from external systems to P2P system, process those files in P2P and send those data to respective legacy GLs.
• Worked on Data migration, Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Setting up UWQ in Advanced Collections to improve teh collection process to identify delinquent invoices and using dunning Plans to execute different Work items.
• Used seeded Scoring components, Custom Scoring Engines, Customer handling, Configuring tasks & work items, Handling of disputes, Promise-to-Pay, Strategies, Aging Buckets
• Worked on Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
• Implemented New AR 12.1 functionality of Late Charges, Bank Setups, and Tax Calculation functionality in AR.

Confidential

Oracle Consultant

Responsibilities:

• Business Study, Gap Analysis, Mapping and Demo teh POC.
• Prepared BR100 documents, SRD (Solution Requirement Documents) and test scripts.
• Defined Invoice attributes like payment terms
• Designed and implemented new functionality as well as customizations
• Interacted with end users for mapping teh legacy data to teh Oracle tables.
• Designed multiple extensions to fill teh gaps (an extension on Auto invoicing, Lock box and COGS accounting and revenue recognition)
• Designed a custom process for to Update Customer Balance (Daily), dat extracts all transactions specific to each customer and updates teh balances of teh customer in a custom form
• Prepared Test scenarios for SIT and UAT for all financial modules
• Designed open interface for invoices in AP to import pre-payment details.
• Designed purge process for pre-interface tables.
• Designed approach to bring teh Invoice data from teh legacy system into Oracle AR.
• Gatheird teh custom Report requirements mapped teh design using Reports6i and Oracle Discoverer 9i.
• Created Custom Responsibilities, Menus, and Functions.
• Designed new FSG Reports in GL to get balance sheet for each entity within teh organization in order to halp month-end reconciliation.
• Designed approach for month end AR period closing activities, assisted Super user to perform month end closing activities.
• Imparted training to end users and prepared training manuals for all processes around teh modules
• Extensively involved in defining teh organizational structure in teh multi-level Hierarchy.
• Provided analysis, design and rollout of General Ledger
• Setups included Multi-org, Multi-currency, Reporting Currencies
• Involved in, defining legal entities, ledgers, secondary ledgers, ledger sets, re-valuation setups and loaded segment values using data loader for wave 1 testing and prepared documentation on how to create legal entity and ledgers, ledger sets through accounting setup manager from GL responsibility.