SUMMARY

• Possess more than 8+ years of professional experience in software industry with comprehensive knowledge through all phases of software development.
• Worked on modules like GL, AP, AR, SLA and CE in eBusiness Suite R12 as Oracle Apps implementation specialist.
• Excellent R12 Oracle Functional knowledge with Sub - Ledger Accounting, E-Business Tax, Multi Org Access Control and TCA. Worked with Tax ware integration to derive the 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 knowledge 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, Oracle data integration, 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 the 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 ADF, PL/SQL, SQL*Loader, TOAD and SQL Plus.
• Goodexperience in costing and inventory modules
• Thorough experience in Kronos Workforce Central (version 6.7) suite application
• Functional Knowledge and implementation experience in industries like Telecom, Finance, Manufacturing and Distribution industries. Defined data migration templates to collect the 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 the application related issues. Involved in Information Security and Business Continuity Plan related activities and coordinated the project level audits.

TECHNICAL SKILLS

Oracle Applications: GL, AP, AR,OM,PO,PPM, FA,PA,CE, INV, HR, IB, SC, ADF Payroll EB-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, ODI, OAF,OBIEE, TOAD, ALM, Discoverer, QA, PL/SQL,OA Framework, OTBI, 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, Boston MA

Oracle Financial Functional consultant

Responsibilities:

• Implemented Oracle eBusiness Suite that 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 for Supplier invoices on the 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
• Performed loading item costs using data loader
• Evaluated material transactions and item costs through Cost account Manager responsibility
• Checked for interface errors related to item costs and worked with business users to update accordingly
• Executed end-end system integration testing for EDI solutions.
• Experience with QA processes and testing tools (QC, Quick Test Professional) and deep knowledge of SQL queries
• Implementation and testing of Order to cash and procure to pay modules.
• Suggested improvements for business tasks utilizing Order to Cash apps.
• Part of a team implementing Order to Cash process which included Oracle Order Management, Quoting, Inventory, Bills of Material and Advanced Pricing modules.
• Responsible for gathering Business Requirements, Solution Design, Gap Resolution, Application set-up and functional specifications for RICE components for financial modules.
• Implemented the 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 the technical team with Conversions.
• Created test plan and detailed test cases using ALM.
• Implementing and rolling out the developed solutions in Oracle ERP based environment.
• Developed solution designs for financial related customization and reports including SLA modifications and TCA setup
• Troubleshooted modify review programs for EDI solution on ERP Systems.
• 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.
• Worked on AR interfaces & discoverer reports of Disgorgements and Outstanding Receivables
• Involve in pay roll management through Kronos Application.
• 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 the process for sending PO and receiving cXML Invoices using OSN.
• Designed and Implemented End-End process of iSupplier module for client.
• Designed conversion strategy for conversion of Fixed Assets from legacy system into Oracle Assets, carried out conversion, verified the asset balances, maintained the books for a number of periods and transitioned the books to the users for maintenance.

Confidential, Santa Clara, CA

Oracle Financial Consultant

Responsibilities:

• Responsible for reviewing and understanding the 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 the current use of Oracle applications and the mapping of new features and functionality of 11.5.10 to the functionality required in the present company environment.
• Responsible for providing identification, analysis, documentation, configuration and testing for procure to pay process of the project.
• Enhanced Lease Expiration Letter program to work with the OLFM module
• Enabled the attachments on sales order header to be displayed on associated OLFM Contract header on lease center form
• Performed enhancement to suppress the OLFM Rebook adjustments and raise Credits and Rebills as per the business requirement
• OLFM, FA,AR,SLA setups are documented and understood very well
• Perform Quality Assurance testing, verification, monitoring, and review of Oracle Upgrade
• Highlighted Impact analysis in current business process due to upgrade changes/enhancements.
• Involved in preparing test cases as per the 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 the 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 the asset balances, maintained the books for a number of periods and transitioned the books to the 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 the 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 the process of reconciliation between the payable and Receivable modules with the General Ledger
• Updated the documents that have been changed - core business processes, organizational impacts, roles and responsibilities.
• Involved in testing iProcurement, iSupplier and iExpenses
• Tested iProcurement, iSupplier, iExpenses, PO, AP, AR, GL, OM, INV, ASCP Modules.
• Worked with feeds team to import the 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 the 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 the 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 the legacy data to the Oracle tables.
• Designed multiple extensions to fill the gaps (an extension on Auto invoicing, Lock box and COGS accounting and revenue recognition)
• Designed a custom process for to Update Customer Balance (Daily), that extracts all transactions specific to each customer and updates the balances of the 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 the Invoice data from the legacy system into Oracle AR.
• Gathered the custom Report requirements mapped the 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 the organization in order to help 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 the modules
• Extensively involved in defining the organizational structure in the 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.