We provide IT Staff Augmentation Services!

Oracle Ebs Functional Consultant Resume

San Diego, CA

SUMMARY:

  • Over seven years of experience in Implementation/Upgrade/Support of Oracle ERP applications of Quote to order, Procurement, manufacturing, Logistics, Supply and demand planning.
  • Professional expertise in Designing, Implementation, Customization and Testing in Oracle Financials module which include General Ledger (GL), Account Payables (AP) and Project Accounting (PA).
  • Well versed with understanding of HR business domain, strategy, planning, business roadmap and industry best practices.
  • Accomplished SAP Confidential / Sabrix Tax Consultant with a strong affinity for technology and acute business sense for the application of emerging technologies to add value and expand markets.
  • Worked extensively on Supply Chain Modules in Order Management (OM), Configurator(CZ), purchasing (PO), Shipping, Receiving, Sourcing, Inventory (INV), Advanced Supply Chain Planning (ASCP), Global Order promising (GOP), Collaborative Planning (CP), EDI and Demantra.
  • Relevant experience as an Oracle Financial Functional which includes Implementation, Upgrade, Testing and Production support on Oracle E - Business Suite R12 and 11i.
  • Defining Supply chain business processes like Order to Cash (O2C), procure to pay (P2P), Manufacturing, Logistics, supply and demand planning
  • End to End Implementation, Customization, Conversion, Interface, Extension, Development, Production support and Testing in Oracle E-Business Suite (EBS) 11i and R12.
  • Strong experience in various rounds of System Testing, Functional Testing, Integration Testing and User Acceptance Testing.
  • Extensive experience in Performing Gap Analysis, Conduct CRPs, Coordinate Business User Interaction, implementation approaches and develop support plan.
  • Expertise in business Analyst role to understand the HR business needs, requirements and convert them into Oracle HCM product solution and liaison between technical solution team and Business team.
  • Strong experience in Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance. Good experience in engaging Oracle team on SR's and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions
  • Experience in Requirement Analysis, JAD sessions, Requirements Interviews, Brainstorming, Running Scrum Meetings, Sprint review, Business and Systems reviews and working sessions to communicate with the team and to ensure the understanding of the requirements and system design.
  • Strong experience in Oracle Fusion HCM - Functional Setup Manager, Enterprise structure configuration, Employment model, Workforce structures, Personalization, OTBI reports.
  • Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.
  • Extensive experience in holding the primary accountability of supporting the design, planning, development, testing, documentation and maintenance of best-in-class Business Intelligence capabilities, including data architecture/warehousing, ETL, data governance, advanced analytics, and reporting.
  • Exclusive experience with Fusion HCM - Workforce lifecycle, Talent management - End to end Goal management and Performance Management life cycle and Fusion Benefits.
  • Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).
  • Good Experience with Workflows, Web ADI, Discoverer & XML Reports, Oracle Business Intelligence (OBIEE).
  • Experience in integrating third party distribution centers (3PL), field inventory systems, master data management (MDM), Manufacturing Execution System (MES), Financial & CRM systems to Oracle ERP.
  • Extensive experience in OBIEE Administration including Migration, Debugging, Optimizing, Performance Tuning and Production Support.
  • Extensive experience in Working on functional design documents for Oracle interfaces like Purchasing/ Requisitions interface, API, EDI Orders, Order Import, BOM Interfaces, Purchasing and Fixed asset workflows, Auto Invoice, Customer interface, Lockbox, Supplier Interface, Payable Import, Journal Import, Project interfaces, project extensions, Employee load data.
  • Very good Experience on Procure to SQL Pay, Order to Cash, Record to Report and Assets to GL Cycle's Using Multi-Org.
  • Documenting, Enhancing and Testing OM to PA existing interface changes to create Projects, task, Agreement, Funding and Budget.
  • Expertise in using PL/SQL API's, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter.
  • Extensive experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
  • Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, cut off, Go-live and Post-Implementation Support.
  • Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG's) as per Business Requirement.
  • Trained the client's business users on using the application, conducted conference room pilot testing (CRP), system integration testing (SIT), user acceptance testing (UAT), design validations and setups of the distributed ERP applications.

TECHNICAL SKILLS:

ERP: Oracle EBS (R12 - 12.1.3) /11i (11.5.8, 11.5.9, 11.510.2) /11.0.3

Domain Expertise: (GL, AP, AR, CE, FA), Supply Chain - (INV, PO, OM), Manufacturing - (BOM, WIP), CRM, ASCP, iProcurement, iExpenses, Service Contracts, Teleservice, iSupport, Business intelligence, HCM, OBIEE, Exadata, EBTax, Confidential Tax

Tools: Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data Loader, BI/XML Publisher, Load Runner

GUI: Developer 6i, Developer 2000, Forms 6i/10g, Reports 6i/10g

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting

Databases: Oracle 11g/10g/9i/8i, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow builder

Operating Systems: Windows 98/2000/NT/XP/7/8, Unix (Solaris, HP-UX), Linux.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Oracle EBS Functional Consultant

Responsibilities:

  • Developed and managed the integration of various ERP systems with Oracle EBS. 
  • Collaborated with the client team in understanding the business processes to prepare the business requirements definition documents. Designed and implemented AP and EBTAX modules as per requirements.
  • Created Oracle BI Analytics Financial Reports focusing on homes at risk of foreclosure. 
  • Responsible for managing Fusion HCM Consulting, Support and maintenance of the project and Leading the team. 
  • Involved in designing & implementation of automated use tax calculation EBTAX solution for iSupplier / B2B invoices.
  • Provided setup and support advanced supply chain planning (ASCP), Collaboration planning (CP), isupplier and iprocurement modules.
  • Configured Rules for the Confidential Tax Decision Maker (TDM) to handle Customer Tax Exceptions, Product Tax Exceptions and Jurisdiction Exceptions.
  • Involved in solution designing and development of the Oracle eBusiness Suite Application (GL, P2P, O2C and R2R), Sub Ledger Accounting, FA and conducted workshop on new functionalities of Release 12 for different modules so that the business is aware of the functionalities. 
  • Managed Oracle Applications DBA, successfully implemented all phases of new R12.1.3+ Financials, HRMS, Purchasing and Discrete Manufacturing modules.
  • Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions between eBS and Retail Pro and Trading Partners. 
  • Enabled new orgs in ASCP plan options and collections and Disabling old org and sales order conversion from Old shipping warehouse to new warehouse and Scheduling and rescheduling new sales order and converted orders. 
  • Involved in Cash Management Bank Reconciliation setup for Payroll to automating the process for greater time productivity in reconciliation.
  • Manage reporting migration from massive third-party partner payment processor, and manage readiness / change management ecosystem for an adoption of new BI (Business intelligence) strategy and tactical solution.
  • Worked on the defining the transaction types, financial options, tax rules in Oracle AP module.
  • Prepared CRP test plans and work with end users to test module configurations and custom objects in the Oracle EBS R12 instance.
  • Successfully completed Integration testing with the client to make sure that the new Hardware (Exadata) is coupled flawless for ACH Wire payments, Positive pay and Check clearing (For Cash Management). 
  • Conducted requirement-gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD) using Rational Requisite Pro.
  • Maintained user access and privileges within Oracle Agile PLM application, creating documents and associated components as required and adjustments to existing objects, lists, searches, and workflows at user request. 
  • Involved into design & solution discussion with Middleware (SOA), MDM systems and third party vendors for Field Inventory/Regional Distribution systems.
  • Integrated GL Segment Hierarchy from HFM into OBIEE to be used in all OBIEE reports combining seeded and non-seeded data - using Informatica mapping and Repository data modeling. 
  • Performed End to End Regression testing on Fusion Core HR, Talent management module such as Goal management and Performance management and Fusion Benefits modules on every patch bundle application and new Releases.
  • Setup and configuration of Fusion HCM Workforce deployment - Core HR and workforce development modules like Performance, Goal management and Benefits.
  • Studying current process for interfaces GL Wand for financial reporting. Interacted with business users to map the business requirements to application capabilities.
  • Developing the functional Design documents for the Expense Feed Transactions Out bound Interface from Oracle r12 to SAP .
  • Involved in Set-ups of payables, Cash Management & Fixed Assets for the New Legal Entities as part of Integration between oracle-R12 -SAP .
  • Conducted daily scrum meetings to coach and mentor the self-organized, cross-functional Agile Project team on key principles of Scaled Agile (SAFe) competencies & practices including team ownership, commitment, effective user stories, agile estimation, and transparency.
  • Managed the implementation of HTP module and its integration with other GL and Tax Cube. 
  • Run standard and custom GL, AR and AP setup report and concurrent programs for data analysis.
  • Worked on setting up of accounting method builder (AMB), SLA for Financial accounting hub, provided production support of Oracle financials, including following up SR's with Oracle.
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. 

Confidential, St. Louis, MO

Oracle Financials Consultant

Responsibilities:

  • Provided Functional support for all Oracle EBS modules.
  • Involved in HCM-Payroll QA and integration testing after splitting into two instances.
  • Collaborated extensively with development team on development and customization of Oracle RICE (Reports, Interfaces, Conversions and Extensions) components as per business requirements. 
  • Conducted User Acceptance Testing (UAT) and collaborated with the client stakeholders and QA team to develop the test plans, use cases and test data to be used in testing.
  • Worked with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.
  • Redirected SD (Order-to-Cash/Quote to Cash) and MM-PU (Purchase-to-Pay/Order to Pay) master data links to Confidential . 
  • Performed reconciliation from the Confidential Tax journal to the SAP GL.
  • Configured and maintained the following servers: Oracle BI Analytics Server, Oracle BI Analytics Web Server, and Oracle BI Analytics Scheduler. 
  • Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio, MS Word and MS Excel.
  • Worked in the environment involving Agile PLM (Product lifecycle management) Administration and configuration and customization, this includes the discussion and understanding the customer issues and defining the Agile Users/ Workflows/ Roles and Privileges.
  • Supported the production issues occurring in Order Entry & Shipping, Receiving and associated with number of small enhancements called as Micro Projects. 
  • Work with end users to validate configured SLA entries in the GL. Resolve issues arising from these entries.
  • Highly conversant with various modules of Oracle Financials (GL, AP, AR), Manufacturing/Supply Chain/Distribution (INV, PO, BOM, OM, eAM), MDM (CDH (Customer Data Hub) and SDH (Supplier Data Hub)), System Administration and AOL.
  • Discussed and finalized the Master data migration - Vendors, Customers, and Fixed Assets and GL Historical data. 
  • Setting up Global consolidation & multi reporting currency & developed FSG Reports for customized Financial Statements. 
  • Work with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.
  • Identified customizations and integration points that are impacted due to Split of CS and HCM, and documented new designs for technical team on new customizations and new integrations.
  • Prepared functional design document (MD050) to extract data from external system to custom revenue sub ledger and then to Oracle GL interface table and then to post to GL. 
  • Coordinated daily team activities (SCRUM) to ensure project schedule remained on target.
  • Trained users on how to enter maintain and perform actions on invoices in AP.
  • Performed data mapping between Oracle EBS R12 and legacy systems.
  • Work with Oracle Support to resolve bugs in the Oracle R12 test and production instances. Raise and follow through on SR's raised with Oracle Support.
  • Integrated Exchange Rate conversion from HFM into OBIEE to be used in all OBIEE reports combining seeded and non-seeded data - using Informatica mapping and Repository data modeling.
  • Worked with global process owners to develop a global process template for the following modules: GL, SLA, FAH and AGIS. The global Chart of Accounts was also developed as part of this global process template. 
  • Assisted DBA and technical team with upgrade of E-Business Configurator instances to R12.1.3.
  • Worked with global process owners to develop a global process template for the following modules: GL, SLA, FAH and AGIS. The global Chart of Accounts was also developed as part of this global process template. 
  • Resolved failed tax documents that did not update the Confidential Tax ledger due to consistency failures.
  • Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
  • Ran payroll, Pre-Payments, Costing, Quick Pay, Retro Pay, Retro Pay by Element, Retro Costing, Import payroll transactions from HRMS. 
  • Worked with subledger leads to test SLA and FAH entries in the GL and resolve issues from subledger postings.
  • Documented the Business Requirement Document to get a better understanding of client's business processes of both the projects using the Agile methodology. 
  • Involved in the Configuration of AP, AR, GL, Advanced Collections, and FA Modules in Multi-Org Environment as part of project.

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

  • Ensured that new implementations met SOX requirements.
  • Primary responsibilities included functional/technical support of Oracle GL, PA, AR, AP, Inventory, Discoverer Admin, Fixed Assets, Cash Management, and Cognos administration.
  • Team member on a project implementing Oracle Financial Modules like AR, AP, PO, FA, CM, EB Tax, Advanced Collections, GL and AGIS modules in Multi-Org Environment.
  • Developed the functional plan for this R12 EBS implementation. Provided weekly status reports to the Project Manager and managed the functional team. 
  • Assisted Tax department in customization of Confidential Sales Tax Returns (STR) towards auditor and IRS requirements. 
  • Attended business unit project meetings to identify and capture the support needs of the business unit from the dedicated OTS DBA team. 
  • Manual set up through Functional Set up manager for the common, HCM common, workforce deployment, workforce development. 
  • Prepared business requirement documents for the GL, AR, TCA and SLA piece of the implementation.
  • Wrote requirements, interact daily and test our Oracle Exadata database. 
  • Worked with the technical team for the conversions of GL balances, open items, vendors, customers in the conversion and production instances.
  • Worked with the complete SDLC, elicit, analyze and define requirements. Executed Agile SDLC project using offshore and onshore managed service model.
  • Created custom SQL reports listing accounting details of Balance Sheet and Profit and Loss activity for internal and external audit support. 
  • Captured functional and technical requirements. Mapped requirements to the standard Oracle R12 functionality and identified the gaps. Provided solutions to the identified gaps. 
  • Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes.
  • Involved in setups financials and payables options, payment system, payment profiles, payments templates options including all key configurations in AP. 
  • Attended divisional project meetings as an Oracle Technical Services resource to identify and capture the support needs of the division from EPM DBAs.
  • Tested various custom reports (GL, FA, AP and PO) for reconciliation issues and helped fixing bugs detected. 
  • Created Data extracts for reconciliation of SAP General Ledger and Confidential Tax Journal.
  • Involved in data conversion from Legacy to Oracle HRMS.
  • Implemented custom Web ADI templates for GL and FA to load transactions into the system as per requirements
  • Worked in an AGILE/SCRUM environment which poses initiating several workshop sessions and active interaction with business, technical and engineering teams. 

Confidential, Berwyn, PA

Business Analyst

Responsibilities:

  • Managed Oracle FSG reports for Balance Sheet, Profit & Loss and department spending reporting.
  • Supported Accounting and Finance Department as the Oracle Discoverer System Administrator. 
  • Worked with the financial controller to define and map requirements to the standard Oracle Payables functionality. Identified gaps and proposed solutions to the gaps identified.
  • Assisted with troubleshooting of production issues, generating post production reports requested by user using SQL queries.
  • Studied the requirements for SCM modules and Analyze business requirements and convert into technical requirements
  • Worked with the technical team for the conversions of GL balances, open assets, vendors in the conversion and production instances.
  • Assisted with the analysis, configuration and testing of PO, AP and CM. 
  • Provided functional support to end-users for Oracle GL, AP, Fixed Assets and Cash Management.
  • Reconciled GL data in Oracle Financials with the data warehouse using a variety of methods (Sql plus, Discoverer, Toad and ADI).
  • Coordinated all onboarding efforts including pre-employment drug screening, background checks, and entry to payroll.
  • Assisted in setting up the environment for Fusion HCM Global HR entities. 
  • Assisted in creating Business Requirement Document (BRD) and Functional Document based on Business Requirements Document. 
  • Participated in CRP and UAT, supporting the users to create business test scripts and help resolution and review of defects reported along with triaging the defects.
  • Developed validation procedures for legacy system data converted to Oracle GL. Identified and reconciled differences between legacy systems data and Oracle GL.

Hire Now