SUMMARY:

• Functional Consultant with 9.1 years of IT experience and expertise in the implementation of Oracle Financial/System Administrator solutions for large organizations and complex business processes, background includes experience in implementation of projects for domestic and overseas clients.
• Expertise covers the requirements gathering and analysis, documentation of functional design, communication with key stakeholders including technical resources and users, the supervision of functional work, testing, change management, configuration, implementation and post implementation support.
• Extensively worked as an Oracle E - Business Suite R12 Oracle Financial Suite Expert.
• Extensive experience with the modules of AR, Advance Collections, e-Business Tax, Project Costing, Project Billing, Oracle Time and Labor, Deductions Settlement, AP, GL, Sub Ledger Accounting, Fixed Assets, Cash Management, i-Expense Modules
• Worked with clients in Manufacturing sectors, Telecommunications sectors and Service Industries Sector.
• Good insight to various complex business processes, accounting systems and practices.
• This has proven to be extremely advantageous in the work as Oracle Application Functional consultant by helping communicate with the Finance and accounting Stakeholders at the same wavelength.
• This experience has also been a good base to understand the integrations and relationships of the systems under implementation with the overall organizational Finance and accounting system.
• Strong knowledge in Oracle financial modules (i.e. AR, Deductions Settlement, e-Business Tax, AP, GL, Sub Ledger Accounting, Fixed Assets, Project Costing, Project Billing, Oracle Time and Labor, Cash Management, I-Expense) in R11i/R12 environment.
• Sound knowledge and experience on other modules like Purchasing, Inventory, Order Management and System Administration.
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) and FA to GL on Oracle e Business suite in R11i/R12.
• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i GL, e-Business Tax, Project Costing, Project Billing, e-Business tax, Oracle Time and Labor, AP, AR, CM, and FA modules.
• Participated in multiple Oracle apps 11i/R12 implementations in multi org/multi-currency scenarios, Order management and worked as areas involving Pricing, Purchasing, and Inventory.
• Expert in preparing RD020, BP040, BP080, BR100, MD050 and TE020 document.
• Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payables and Fixed Assets modules.
• Prepared Functional design documents for customizations/conversions using AIM methodology.
• Experience in all phases of the system development/implementation life cycle.
• Prepared the Test scripts for all financial modules i.e. FA, AP, e-Business Tax, Project Costing, Project Billing, Oracle Time and Labor, AR, GL and CM with all business scenarios to test in all phases i.e. CRP, SIT and UAT.
• Strong knowledge and working experience in end-to-end testing for all modules.
• Involved to conduct UAT session with Business user and prepared User documents for all financial modules.
• Co-coordinating and helping the Business user in executing the Business scenario in Oracle.
• Involved to provide USER Training to end user with the entire business scenario.
• Responsible for Fixed assets management like CAPEX and OPEX analysis, CAPEX viability (analysis of return on investment, net present value, lease/purchase, pay back) on Oracle fixed assets module.
• Ensure accuracy and discipline of accounting in O2C and P2P on a regular basis by running routine queries/checks.
• Has good experience in processing, maintaining and reconciling a high volume of O2C transactions on oracle financials modules Rel12 and Rel11i as per India/USA/Australia GAAP.
• Preparation of different FSG reports including Trial Balance, P & L A/c, Balance Sheets as per Australian and US GAAP.
• Responsible for Month-end close reporting, Variance Analysis, Trend Analysis, Quarterly and monthly forecasting and Forecast vs. actual comparison on oracle Hyperion financial Management tool.
• Debtors Management, Creditor management and providing all Oracle report for debtors and creditors management on a regular basis.
• Preparation of Balance Sheet, Intercompany and Fixed assets reconciliation reports.
• Various MIS reports as and when required for Cost control and performs root cause analysis.
• Prepared Tax Return of Individual, Partnerships, Sole traders and Companies.
• Involved in handling direct and indirect taxation matters including filing of returns, assessments and compliance related to employee and vendor TDS, Corporate Tax, Service Tax, Input and Output VAT etc.

IT EXPERTISE/CAPABILITIES:

Oracle E-Business Suite: Oracle Applications R12.1.3, 11.5.10.2, 11.5.8, 11.5.5 & 11i

Oracle ERP Modules: Extensive Experience: AR, Advance Collections, e-Business Tax, Deductions Settlement, AP, GL, Project Costing, Project Billing, Oracle Time and Labor, Sub Ledger Accounting, Fixed Assets, Cash Management, i-Expense

Oracle E-Business Components: Oracle Financial Statement Generator (FSG), Oracle Approval Manager (AME), Oracle Hyperion Finance Management and OBI.

Databases: Oracle 10g (10.2.0.4), Oracle 9iR2, Oracle 8/8i

Development Tools: Oracle SQL, PL/SQL

General Tools: Toad, Microsoft Office, MS Visio, MS Projects

OS Platforms: Sun Solaris, Oracle Linux, Windows NT/XP

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Financials Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, AP, Advance Collections, Deductions Settlement, e-Business Tax, GL, i-Expense modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, Fixed Assets, e-Business Tax, i-Expense modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on AR Deductions Settlement module including the setups for Implementing Claims like setting up system parameter defaults, setting up Trade Profiles, setting up Supplier Trade Profiles, Implementing Org Stripping on Claims.
• Worked on AR Deductions Settlement module defining the claim types, claim reasons, claim sources, Promotional Payment View, Mapping customer reason codes, setting up claim ownership and assignment, Implementing Claim Rese
• Worked on the setups of Sub Ledger Accounting module - defining the Journal Line Sources, Events, SLA Rules, Account Derivation rules, etc.
• Worked on the e-Business Tax module setups - defining the tax codes, tax rates, exemptions, exceptions, regimes, rate to regime flows, etc.
• Configured Oracle AR - Including the setups of Revenue Recognition process, defining of Accounting and Invoicing rules.

Environment: Oracle Apps Release 12.1.3/11.5.10 Family Pack G e-Business suite (AR, AR, Deductions Settlement, AP, i-Expense, Fixed Assets, e-Business Tax, Sub Ledger Accounting, e-Business Tax, Project Costing, Project Billing, Oracle Time and Labor, GL, OM, INV, Shipping and Advance Pricing SQL*Loader, Data Loader, file loader, Toad, Windows NT, HP UNIX.

Confidential, Pleasanton, CA

Financials Functional Consultant

Responsibilities:

• Implemented the following modules: OM, AR, e-Business Tax, AP, Advance Collections, i-Expense, Fixed Assets, GL modules
• Worked on the Functional mapping of data Conversions & Enhancements for OM, AR, i-Expense, AP, e-Business Tax, Fixed Assets, GL modules
• Worked on the e-Business Tax module setups for Sales, Use, VAT and CST
• Defined the rates, regimes, rate to regime flows for tax calculation I oracle e-business tax module.
• Configured all the General Ledger, e-Business Tax, i-Expense, Fixed Assets , Payables, Fixed Assets and I-Expense set-ups in the test instance.
• Worked on the setups of the Corporate Book and Tax Book in oracle Fixed Assets. e-Business Tax - Worked on the configurations of Oracle e-Business Tax modules, setting up rates, regimes, rate to regime flow, tax codes, tax rates, tax exemptions, exceptions, tax rules, etc.
• Worked on the Sub Ledger accounting module - defining the journal line sources, events, account derivation rules, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.

Confidential, Atlanta

Financials Functional Consultant

Responsibilities:

• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the functional design for customizations, in Processes, Programs, and Reports.
• Performed all of the setups and configurations for AR, AP, e-Business Tax, GL, i-Expense, Fixed Assets Modules.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary Training to User Leads and Users on Enhancements
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.
• Worked on Setting up Auto Lock Box in AR.
• Worked on rectifying error transactions in Auto Lock Box Interface Table.
• Designed the Chart of Accounts in GL and Accounting Flex Field.
• Developed test scripts for testing the order to cash process and also the AR to GL flow.
• Tested several patches that were applied to the R12 instance for functionality as well as performance.
• Worked on setting up multiple reporting currencies (MRC) in the Release 12 instance.

Confidential, Minneapolis, MN

Financials Functional

Responsibilities:

• Functional team member for supporting and managing the Oracle AR, AP, GL Project Costing, Project Billing, Oracle Time and Labor modules worldwide for 44 sites.
• Designing of functional and technical specs which included working with customer to set priorities and develop specifications for changes to the applications and reports
• Gathering business requirements and doing Confidential analysis
• Doing setups in oracle purchasing pertaining to operating unit and inventory organization level
• Inventory organization setup including average costing parameters, shipping networks, cycle and physical counting cycles, transaction types, sub inventories, catalogs and categories.
• Analyzing business requirement to setup receiving options and purchasing options
• Worked with development meet to upload items, shipping networks and resolve issues.

Confidential, Cary, North Carolina

Financials Functional Consultant

Responsibilities:

• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the customizations, in Processes, Programs, and Reports.
• Performed all of the setups and configurations for Oracle AR, AP, GL, Cash Management, Fixed Assets Modules.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary Training to User Leads and Users on Enhancements
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.
• Worked on Setting up Auto Lock Box in AR.
• Worked on rectifying error transactions in Auto Lock Box Interface Table.
• Designed the Chart of Accounts in GL and Accounting Flex Field.
• Developed test scripts for testing the order to cash process and also the AR to GL flow.
• Tested several patches that were applied to the 11.5.10 instance for functionality as well as performance.
• Worked on setting up multiple reporting currencies (MRC) in the 11.5.10 instance.