SUMMARY:

• Functional Consultant with 8.9 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, Rev Pro, 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, Rev Pro, 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.
• Worked on Localizations for Latin America (Brazil, Argentina), Canada, Europe (NL and Belgium)
• Extensive experience with the Invoicing and Revenue Recognition process in the AR Module.
• 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,andFAmodules.
• 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 preparingRD020, BP040, BP080, BR100, MD050andTE020document.
• Experience in Data mapping the external source files with oracle columns inOracle Accounts Receivables, Accounts PayablesandFixed Assetsmodules.
• 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, Rev Pro, 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.

TECHNICAL SKILLS:

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 ANGELS, CA

Financials Functional

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, Rev Pro, 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.
• Implementing Revenue application Revpro 2.4 for revenue recognition.
• 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.
• E-Business Tax - Worked on the oracle e-Business Tax setups like setting up the rates, regimes, tax codes, rate to regime flows, setting up e-business tax for sales and use tax as well as VAT Tax.
• E-Business Tax - Worked on the integration of Vertex Q Series with Oracle e-Business Tax
• E-Business Tax - Defined tax rules for exemptions and exceptions in Oracle e-Business Tax module
• Worked with the Invoicing process in Oracle Receivables to import invoices from an external system into Oracle.
• 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 Latin American Localizations for Brazil - setting up Setting up Tax Codes, setting up ICMS Tax Rates, Setting IPI Tax Rates, Transaction Nature, Next Number - Nota Fiscal, Next Number - Fiscal Books,
• 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, Burlington, MA

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 Auto Invoice process in AR to handle invoicing process in AR
• Worked on the Worked with the Invoicing process in Oracle Receivables to import invoices from a Legacy team.
• 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, Seattle, WA

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 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 the configurations of Oracle e-Business Tax module - defining the rates, regimes, rate to regime flow, tax rates, tax codes, exemptions, exceptions, tax rules etc.
• Worked on the integration of Oracle e-Business Tax with Sabrix Tax Ware.
• Worked on Setting up Auto Lock Box in AR.
• Worked on the Auto Invoice process in Oracle 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 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, SFO, CA

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 gap 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, San Francisco, CA

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.