We provide IT Staff Augmentation Services!

Oracle Financial Consultant Resume

0/5 (Submit Your Rating)

San Jose, CA

SUMMARY:

  • She has around 8+ years of experience in Oracle Applications package implementations, upgrades and roll - outs programs across various geographies - USA, UK, EMEA and India. She has worked on functional/Techno-functional on major financial areas.
  • She has extensive experience with business process improvement, Oracle Applications implementation and upgrade for high-tech, manufacturing and retail customers.
  • Performed Fit Gap Analysis, Requirements Design, Project Scope document, Production support, Testing and User sessions across multiple end to end Oracle implementations and maintenance project.
  • Strong functional working experience on Brazil Localization for R12 implementation and VSOE.
  • Expertise in knowledge over Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc.

TECHNICAL SKILLS:

Applications: Oracle Financials (General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, iPayment, iexpense, Cisco Services, VSOE, SLA)

Process Areas/Implementation Approaches: Quote to order, Order to Cash, Procure to Pay, Journal Entry and Posting Processes, Invoice Generation to distribution, Lockbox, SLA, ACH process, DQMOracle AIM methodology, CMMI, Six Sigma, Defect Prevention.

Technology Software, Tools & Languages Database/Operating systems/ Other: Oracle Applications 11.5.10.2, 12.0.6, 12.1.3, 12.2.4, Application Object Library (AOL), System Administrator, Oracle SQL*Plus, PL/SQLOracle RDBMS 9i, 10g, 11g, SQL Server 6.5, MS Access, HP-UNIX, Windows, PowerPoint, Excel, Word, Visio, MS Project, Visual Source Safe, Toad, Quality center, SharePoint

PROFESSIONAL EXPERIENCE:

Oracle Financial Consultant

Confidential

Responsibilities:

  • Responsible for fixing all the Upgrade issues related to AP, AR, GL, FA and CM modules.
  • Implementation of custom SLA for FA to derive accounts from asset categories.
  • Implementation and design of using New TAX book and custom SLA for France AX countries.
  • Responsible for solving all the period close issue for modules like AP, AR, FA, Tax, GL for almost 20+ countries.
  • Involved in analyzing all the period close related datafix before applying.
  • Responsible for documenting all the ME close procedure for AP, AR, FA, Inventory.
  • Involved in identifying and implementing many setups changes like Balancing segment setup, SLA setups, custom function for SLA view from inventory, primary to secondary mapping restriction for JE categories and source, Intracompany /intercompany setup, Sequence, Brazil and Portugal related setup.
  • Responsible for resolving many complex issues related to Brazil transaction numbering, Autoinvoice - tax issue, GL issues related to ledgers, BSV, Consolidation, Sequence, GL Drill down.
  • Involved in documenting Accrual Reconciliation R12 Process and also helping in reconciliation.
  • Worked on analyzing and justifying various audit issues related to data counts mismatch between R12 and 11i.
  • Worked proactively with oracle to resolve various bugs related to R12.2.4.
  • Involved in E2E testing of P2P and O2C cycle.

Oracle Financial Consultant

Confidential

Responsibilities:

  • Worked as Business analyst for various projects like LSS bundle 1,LSS Australia and UKH.
  • Wrote PSD (Project scope document) for overall services scope.
  • Interacted with multiple cross flow team for defining the scope.
  • Extensive knowledge on cisco services biz model.
  • Worked on modules like Order Management, AR, INV and Service

Business Analyst

Confidential, San Jose, CA

Responsibilities:

  • Worked in configuration/Oracle setup team for project CE ITALY and CE India.
  • Worked in enabling the OU’s for Italy and India.
  • Configured all the required AR, GL, OM, Collections, and Cash mgmt setups in R12 and 11i env.
  • Interacted with multiple cross flows team for setups requirement.
  • Automated almost 90% of all the module setups.
  • Supported QA and functional team for project execution.
  • Worked with oracle teams over standard oracle functionality issue.
  • Delivered high quality work with 0 issues.
  • Worked with user/biz to provide ERP access and worked on the solution for ERP responsibilities restriction.
  • Worked as a lead for offshore - onsite model.

Techno Functional/IT Analyst

Confidential, San Jose, CA

Responsibilities:

  • Working in the Client Engagement team for NGCCRM.
  • Understanding and also solutioning of the Business requirements related to Deferring and Releasing the revenue and showing the same in Reports.
  • Understanding existing system and mapping new requirements (solution) as per the existing design and constraints.
  • Providing performance testing considerations and baselines based on business SLA.
  • Reviewing test plan and scenarios from QA.
  • To improve Performance over large reports worked with Architect.
  • Wrote Functional Specification Document over reports requirement and non-buy sell entities, also presented to Business and Delivery team.
  • Involved actively with QA and Technical team to understand and root cause the bug.
  • Technical Impact analysis for the data sourcing for Reports columns and also to identify the defect root cause.
  • Wrote SIT test cases and also executed it.
  • Participated in smoke testing and tested the report functionality also raised defect in QC.
  • Providing War room support during test cycles for end-to-end functionality.
  • Provided solution for customized Revenue Tool.
  • Understanding the complete VSOE Process Flow and impacts.
  • Worked on the functional design of the Accounting scope API, Share hierarchy Changes, Residual Calculator, MDM changes, Export to excel changes, FV completeness Reports and various small change request (Itemflagging, accounting scope screen, UDID changes, Deal Level screen, element screen logic changes)
  • Worked on the functional solution for the correct Revenue recognition.
  • Worked with business team to understand and solution the problem.
  • Expertise knowledge gain over VSOE Process.
  • Execution of Solution for Complex logic related to Revenue and Revenue Calculator.
  • Worked on the functional design of FV Completeness and Rate setting Reports.
  • Worked extensively with Technical team in timely solving of Production bugs during Normalization phase.
  • Involved in Re testing the bugs once fixed and also technically debugging the bugs to fix the issue.
  • Involved in knowledge Transfer transition to Support team over the VSOE functionality.
  • Functional Knowledge over the design of the integration of various interfaces ( Corporate Booking, Revenue, EDW Time and Share hierarchy, Product Hierarchy, New Component Flagging, PND-CIBER List Prices Extract) with EDW-TERADATA and VSOE
  • Expertise over the TERADATA SQL Assistant tool for building SQL queries.
  • Analysis over the proper data flow of various interfaces from Teradata to VSOE system.
  • Worked on the functional Impact analysis over the variation in the data from Teradata to VSOE due to advance feature in Teradata.
  • Worked closely with cross-functional team (edw, Teradata, bids, pnd) for the extensively data testing and proper interfacing of data from Teradata to VSOE.
  • Provided Knowledge Transfer to support team over the functional analysis of VSOE (Teradata).

IT Analyst

Confidential

Responsibilities:

  • Understanding the Cisco 11i system and new R12 System and worked with the Cisco business to gather the business requirement and recommended for the new and missing requirements with respective Cisco localization implementation.
  • Worked with the Brazil business team and Citibank team to understand and design of the solution.
  • Designed functional documents in different areas (Boleto, GL Copy, Revenue Reports, Product to Service Revenue Transfer, Autoadjustment)
  • Functional Knowledge over the Auto Invoice, which includes pre, standard and post process.
  • Designed batch sources and Transaction types which required for the localization, especially to support for the Boleto, Product to Service Revenue Transfer.
  • Analyzed and recommended required DFF to support the Boleto, Product to Revenue Transfer and NFE Approval process.
  • Design the extensions that required for Boleto to handle Withholding tax.
  • Design the customized solution for GL Copy, Reports, Autoadjustment, P2S Rev Transfer and Boleto.
  • Work with the cross function support teams. Example with Auto lock box, create accounting, Revenue reorganization, Tax, EDW, VSOE, Credit check and collections, General ledger.
  • Worked on VSOE integration with CI analysis.
  • Worked with B2B and Citibank team for the Integration testing for Boleto and also worked with P2R team for Gl Copy testing.
  • Worked with Citibank team for the proper solution of the Boleto design.
  • Worked with the Customer TCA and HZ schema to maintain the Brazil customer data.
  • Involved in order creation to make sure that is creating properly as per the Auto invoice requirements and supports the Brazil legal requirements.
  • Worked with QA team on the various test Cycle execution.
  • Worked in the execution of complete workflow from order creation to payment through Boleto Brazil Localization.
  • Worked on all the Setup needed for the Boleto, Product to Revenue Transfer and GL Copy.
  • Worked with the Oracle team for the creation of SR for the Boleto solution clarity.
  • Expertise knowledge over R12 SLA functionality, Brazil Localization, Revenue Transfer, Boleto and also general ledger
  • Worked with Citibank and Synchro team for the proper and complete Boleto Process.
  • Provided inputs over the design for End-to-End business flow for supporting to complete project.
  • Effectively used Kintana Project Propel Management (PPM) tool in the development activity to get quick solution from internal, external and X functional teams.
  • Worked with the IBM offshore teams and sharing the knowledge in designing the solution documents.
  • Involved in the validation of functional setups and analyzing over the required functional setups for different functional areas.
  • Developed Functional specification documents (FSD) and Test Scripts.
  • Involved in different Test cycles to support the development activity.
  • Effectively used HP Quality centre tool to track and support the testing activity.

IT Analyst

Confidential

Responsibilities:

  • Undergone in-house on Oracle tools (SQL, PL/SQL and Oracle Applications Functional and Technical aspects (Financial modules, System administration and AOL).
  • Worked in in-house project involved the development, customization and implementation of custom Programs, Interfaces, and Custom Forms, Value sets in Oracle Application as per the business needs.
  • Imported lock box records through Auto Lockbox interface in AR Module
  • Worked on various TCA APIs and also have very good knowledge about AR APIs.
  • Setups for AME in Purchase Requisition approval and PO approval in Document Type of Purchasing module.
  • Created a PL/SQL package to validate and insert the data from custom Interface table into the base tables (PO Vendors, PO vendor sites all).
  • Set up Confidential Card program with AP and worked on creation and import of card data files and also on Expense Report.
  • Used AP CUST WEB DEFLX PKG for customizing Expense report pages to set Cost Center
  • Worked on various Software Change Request (SCR) and individually responsible for analysis, design, implementation, testing, and maintenance of SCRs.
  • Worked in different functional areas of POS related to tax exemption, gift cards, third party credit cards, receipts, pharmacy, and transactions.
  • Worked with Citrix Metaframe, Mercury Quality Center, PVCS dimension tools.

We'd love your feedback!