PROFESSIONAL SUMMARY:

• Around 8+ years’ experience in Oracle Applications implementation, development, upgrading, supporting and involved in full life cycle implementations of several releases 11i/11.x/R12.
• Specialized in functional areas with an experience 2+ in General Ledger (GL), Oracle Supplier HUB, OPM, Account Payables (AP), Account Receivables (AR), Treasury, fixed assets (FA), E Business Tax (EB - Tax), SLA, Procurement, WMS, ODI and SOA.
• Proficient in working with ERP systems like AS400, Oracle E-Business .
• Configure Oracle R12 FA, AR, AP, ODI, SOA AND eBtax to include integration with Vertex and the TCA setups.
• Understands both the “Order to Cash” process as well as the “Procure to Pay” process.
• Conversant with Configuring Oracle Application modules as well as understands the underlying schema, which gives her a better insight into converting user requirements into functional specifications.
• Strong knowledge in tools such as Wand Products (GL Wand, Reports Wand and Budget Wand), Wizards from More4Apps, Web ADI, Reports Manager, Discoverer (11g), My Oracle Support (Metalink), Noetix Views, etc.
• Experience implementing and rolling out the developed solutions in Oracle ERP based environment.
• Experience in configuring Financials for Multi-Currency, Multi Operating Units and Multi Ledgers.
• Good Knowledge on preparing test cases and test plans and test scripts.
• Evaluated business needs, user requirements, and functional specifications, analyzed and understood client strategic direction, issues, and project goals in order to deliver exemplary customer service to clients.
• Have a good implementation and upgrade experience from Oracle 11i to R12.
• Have a good knowledge about OCR, workflow tools or ticketing systems.
• Functional experience with multiple Oracle Financial modules.
• Experience working with executive teams Confidential various levels.
• Ability to learn new things quickly and to work under pressure.
• Excellent communication, interpersonal skills, presentation skills and ability to interact with people Confidential all levels.
• Worked on Revenue Recognition and Deferred COGS functionality.
• Developed business process flows, identified risk points and suggested risk mitigating control measures.
• Good knowledge and understanding of general accounting principles “GAAP”.

SKILLS PROFILE:

Oracle R12 Procurement & Finance: AP, AR, GL, FA, Cash Management(CM), Business Process Management (BPM), Costing, PO, iSupplier, iExpenses, iPayments, Order Management, Inventory, Shipping

Programming Languages: C, SQL, PL/SQL, HTML, UNIX Shell Scripting, VB Script.

Databases: Oracle, TOAD, SQL Developer, and MS Access

QA Tools: QTP, Quality Center, Load Runner, Win Runner

Bug Tracking Tools: Quality Center and Bugzilla, Rational Requisite Pro

Web Technologies: ASP, VB 6.0, HTML, Dream Weaver, JSP

Operating Systems: Windows, Mac

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Financials Functional Consultant, San Francisco, CA

Responsibilities:

• Prepared and implemented project plans, held status update meetings with stakeholders.
• Managed internal project for Oracle e business suite enhancements and interfaces of Oracle EBS with other systems for distribution centers, EDI, point of sales system.
• Supervised functional and technical resources, held weekly status meetings with project resources to ensure project is on track and critical issues are being resolved in a timely manner.
• Managed implementation and enhancements to Business users for Oracle Financial application Modules, AR, FA, AP and Cash Management, ODI and SOA.
• Worked with Rimini Street for creating SR for applications related issues.
• Monitor remedy daily queue for Production support related issues.
• Worked with technical resources for fixing of production issues and development of custom reports and programs.
• Prepared complex level Multi-Org Structure.
• Well Knowledge and experience on SQL loader.
• Prepared complex personalized forms for client.
• Coordinated applications testing with business users.
• Prepared test scripts for oracle applications testing.
• Hold weekly meetings with Business users for production related issues.

Environment: ORACLE R12, AP, AR, GL, FA and Cash Management, ODI and SOA.

Confidential

Oracle Financials Functional Consultant, Dallas, TX

Responsibilities:

• As a Functional Consultant implemented the following modules: AR, AP, Advance Collections, Deductions Settlement, AGIS, e-Business Tax, GL, i-Expense modules.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP, Fixed Assets, AGIS, e-Business Tax, i-Expense modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on the setups of AGIS module - setting up the Intercompany Accounting Pages, Intercompany accounts pages, Transacting Legal Entity, Transacting Ledger, Transacting Balancing Segment Value, Trading Partner Legal Entity, Trading Partner Ledger, Intra company Balancing Rules Page, Intercompany Transacting Types pages, etc.
• E-Business Tax - Worked on the oracle e-Business Tax setups like setting up the rates, regimes, tax codes and 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 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 the General Ledger module - defining the primary and secondary ledger, defined the chart of accounts, calendar, cross validation rules, security rules, consolidation, translation, revaluation, etc.
• Worked on conducting Conference Room Pilots (CRP), prepared the environment for CRPs and prepped the data for CRPs.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• 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 E-Business Suite 11.5.10.2 to Release 12.2.4, AP, AR, FA, GL and VAT Tax, Win Runner, Quality Center, Vertex Tax Software, QTP, Windows XP, UNIX, MS-Office.

Confidential

Oracle Financial Functional Consultant, San Jose, CA

Responsibilities:

• As a Functional Consultant implemented the business flows including AR, AGIS, e-Business Tax, AP, GL and Cash Management modules.
• Worked in the configuration of the AGIS modules.
• Performed Requirement and Gap analysis.
• Worked on the setups of e-Business Tax and Vertex module - including the setups of Tax Rates, Tax Codes, Tax Regimes and Regime to Rate flow - for EMEA and US.
• Worked on the credit card integration to accept PayPal Payments and Visa Credit Card payments.
• Worked on the integration of Oracle e-Business Tax with Vertex module.
• Worked on the setups of AGIS module defining the Intercompany Accounting Pages, Intercompany accounts pages, Transacting Legal Entity, Transacting Ledger, Transacting Balancing Segment Value, etc.
• Configurations and Setups for AP, AR, GL and Cash Management modules.
• Worked on the Mass Addition process in Oracle Fixed Assets.
• Worked on the Depreciation process in Oracle Fixed Assets
• Worked on all of the configurations of Oracle Fixed Assets.
• Worked on the setups of the Corporate Book and Tax Book in Fixed Assets.
• Worked on the formula based depreciation in Fixed Assets.
• Worked on the depreciation roll back process in Fixed Assets.
• Worked on the Mass Copy functionality in Fixed Assets.
• Generated various Analytics reports like Formulary Report and Direct Financials Report using global and local filters in Oracle OBIEE.
• Configured and administered existing subject areas and created new subject areas as per the modified Star schema information in Oracle OBIEE.
• Trained the end-users in developing their own ad-hoc reports using Financials Answers in Oracle OBIE.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository in Oracle OBIEE.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Developed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins in Oracle OBIEE.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on setting up the Approval Hierarchies in Purchasing Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Worked on the Auto Lock Box process in AR.
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada.
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment.

Environment: Oracle E-Business Suite 11.5.5/12.1.3 , AP, AR, FA, GL and Cash Management, Load Runner, Win Runner, Quality Center, Vertex Tax Software, QTP, Windows XP, UNIX, MS-Office.

Confidential

Oracle Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the modules: Ebiz Tax, PO, AP, AR and GL in Multi-Org Environment.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle GL, AP, AR, Ebiz Tax and PO from scratch and simultaneously created BR100 documentation for the setups.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Configured COA structure, Currency, Calendar, Ledger and attached Standard Accrual method developed in SLA.
• Configured Auto Accounting for Order Management.
• Configured Rollup Groups, Summary Accounts, Recurring Journals, Auto Reversals, Mass Allocation, Mixed Journals.
• Defined CVR rule, Descriptive Flex Fields as per Business requirements.
• Configured Consolidation setups.
• Create and assigning respective responsibilities to Users.
• Configured GL, AP, AR Monthly Cycle setups.
• Setup of Vendors, Invoices, Banks, Recurring Invoice.
• Configured Desktop integrator using WEB ADI.
• Configured Pay run using payment profiles.
• Setup of Recurring Invoices.
• Implemented Auto Lock box Functionality, Auto Invoice, Auto Receipt in AR.
• Defined Financial system options, Financial options and Payable options, Payment Terms, supplier, Banks, Pay run, Document sequencing.
• Defined System options, Transaction types, Source types, and Payment terms, remit to Address, Auto Accounting, Distribution sets and customers in Receivables.
• Configured the Revenue Recognition Program.
• Defined Account Setups in Ebiz for AP, AR and GL, ODI and SOA.
• Knowledge and familiarity with Oracle R12 Multi-org Architecture
• Configured Regime to Rate Flow, Party and Reduced Tax Exemptions using Determination Rules.
• Configured INV ORG, Financial Options, Purchasing Options, UOM, JOBs, Employee, Buyers, Approval Groups and Categories.
• Configured three ways matching process.

Environment: Oracle Apps R12 (AP, AR, GL, PO, EBIZ TAX).

Confidential

Oracle Finance Functional Analyst

Responsibilities:

• Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
• Adept in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
• Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in purchasing module.
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Experience on building integrations on P2P, GL, Oracle Supplier HUB, OPM, WMS and other EBS modules.
• Worked with end users to document the business processes & functional requirements also providing them with materials.
• Worked very extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E-business suite 11.5.10. All the above bases business logic was captured in OA Framework code.
• Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines.
• Facilitated discussions with end-users / managers to gather functional requirements.
• Worked in parallel with the client is resolving the CRP 2 and post go-live testing issues with offshore support.
• Good knowledge of data models and interfaces.
• Defined Account Setups in Ebiz for AP, AR and GL, ODI and SOA.
• Good Knowledge with Oracle R12 Multi-org Architecture.
• Coordinated with client through Concalls and WEBEX sessions to get the requirements and also coordinating with the technical team for fixing the issues for proper deliverables to the client.
• Well Experienced in Oracle Forms Personalization.
• Provided KT sessions to the testing and the technical teams.

Environment: AR, AP, GL, FA, ODI and SOA Cash Management, SLA, E-Business Tax modules.