Oracle Fusion Saas Cloud Functional Consultant Resume
SUMMARY
- 9+ years of Functional experience in Oracle Fusion Financials and Oracle ERP (Finance - GL, SLA, AP and Cash Management).
- 7+ years of experience in providing cost effective solutions by using Oracle ERP (E-Business Suite), the experience spreads across Implementations, Version upgrades, data conversions, data Migrations, Customization of Reports Interfaces in Oracle Financials along with Oracle Forms and Reports.
- Techno-Functional experience in Oracle Financial Cloud Service (GL). Designed and implemented accounting principles as per client requirements.
- HRMS- Payroll, Oracle Advanced benefits, Core HR and Self-Service HR.
- Strong Functional knowledge in Oracle EBS/Fusion Financials implementation.
- Extensively worked with Oracle 12c/11g/10g/9i/8i, SQL, PL/SQL, TOAD, Discoverer (10g /4i), XML/BI Publisher, SQL*Loader, WebADI, Forms 6i/10g, Reports 6i/10g, OBIEE
- Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications.
- Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes and Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
- Strong working knowledge on the design and configuration of Chart of Accounts (COA), Multi Org Access Control (MOAC), GL Accounting Cycle and GL Work Flow.
- Extensive experience in all phases of full life-cycle Oracle Applications implementation i.e. Requirements Gathering, Analysis, Application Configuration, Development, Testing, Implementation, Post Go-Live Support, Production support, User Training and Documentation
- Expertise in writing Fast Formulas for Oracle HRMS (OAB) and Compensation Work Bench (CWB).
- Functional & Technical Expertise in OAB Open enrolment processes.
- Prepared Functional (MD50), Technical (MD70), Conversion (CV40/60) and Business Requirement/Mapping (BR100) documents using AIM methodology.
- Very strong development experience in Reports, Interfaces, conversions, and extension (RICE) components in Oracle Applications.
- Strong knowledge in creating RTF templates in MS Word by connecting to XML and BI Publisher, and publish these templates for the reports to view data in OBIEE BI Publisher
- Experienced in developing Conversion Programs, Inbound and Outbound Interface, Forms Customization, and Oracle Alerts.
- Exposure to OFSAA and participated in multiple Oracle apps r12 implementations in multi org/multi-currency scenarios.
TECHNICAL SKILLS
Languages: PL/SQL, UNIX
Primary Skills: Oracle Fusion Financials (GL, AP, AR, SLA, Purchasing, SCM) R12 General Ledger, Sub Ledger Accounting, Finance Accounting Hub (FAH), Oracle Fusion Accounting Hub, Oracle Reports & Forms, XML Publisher, Core HR, Oracle Advanced Benefits, Financial Accounting Hub. Oracle Applications 11i (Core HRMS, Oracle Advanced Benefits (OAB), Oracle Reports and XML.
Operating Systems: MS Windows 98/NT/2000/XP, Windows Server 2003
Development tools: TOAD, SQL*Plus Navigator Oracle Forms & Reports 6i and Oracle Discoverer (3i and 10i)
Databases: Oracle 8i /9i/10g/11g/12c
ERP: Oracle Applications E-Business Suite 11i & R12, Oracle Fusion.
Oracle: Fusion Financials, Fusion SAAS Implementation.
PROFESSIONAL EXPERIENCE
Confidential
Oracle Fusion SaaS Cloud Functional Consultant
Responsibilities:
- Designed and implemented the Oracle GL and FAH in the SaaS cloud.
- Designed and configured the Event model in the Financial Accounting Hub,
- Designed and developed OTBI Reports as per the business requirements.
- Designed the solution for customizing the data validations in the PaaS integration services.
- Configured all the custom roles in the SaaS cloud (OIM and APM).
- Partnered with developers to automate manual processes, saving time and money while decreasing errors. Credited as a primary driving force behind a 5% increase in margins this fiscal year.
- Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.
- Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for up to 12,000 global users.
- Define, plan, coordinate and obtain information requirements to implement the Oracle Fusion AP in the SaaS cloud.
- Coordinate with multiple resources efficiently and effectively throughout the development lifecycle so as to ensure that the projects are completed on time, meet requirements, are implemented accurately and the full impact is understood by the business owner.
- Interface with internal business users as well as various IT development groups so the needs can be clearly understood, expectations managed and change initiated.
- Analyzed, designed and executed the data migration successfully into the Oracle Fusion SaaS Cloud.
Confidential, San Antonio, TX
Fusion Functional Consultant
Responsibilities:
- The project involved installation, development, planning, design and coding of various custom solutions as well as new enhancements and taking care of the release of custom code for Fusion Financials Module.
- Designed and implemented a couple of Oracle Procurement tasks, Order to Cash, Supplier Qualification Management, Procurement Contracts, Procure-to-Pay (P2P) and Self-Service Procurement.
- Designed and developed OTBI Reports.
- Provided executives with analytics and decision-support tools for the automation strategies.
- Configured a custom program for sending email notifications to the users when any of the program completed with error.
- Developed Custom wrapper program for automating the jobs with Control M scheduler.
- Developed a custom solution using post Accounting hook for Accrual reversal for the journals passed through FAH.
- Involved in the Fusion version 10 upgrade and customized the Manual journal upload in the XLA tables. Also installed a fully customized workflow for the same using the SOA services in the Fusion middle ware
- Involved in the implementation of Master Chart of accounts and implemented code combination rules.
- Customized the application roles in OIM (Oracle Identity Management) and designed Custom roles for enabling read only option for the users.
- Developed a customized code for the foreign ledger configuration and accounting rules set up.
- Forms Personalization for accommodating business rules for rate calculations.
- Custom Roles for enabling the differentiating the access the business and implementation user.
- Analyzed, designed and built the Order to Cash for the client as well as involved in its related data migration.
Confidential, Denver, CO
Oracle Functional Consultant
Responsibilities:
- The project involved ERP development, planning, design and coding of various custom solutions as well as new enhancements and taking care of the Release of custom code for Oracle Financial Cloud Service (GL).
- Configured and customized multiple accounting principles as per the client requirements.
- Customize and convert existing ODBI and RDF reports that will run compatible as per the new multi-org structure and user requirement. Delivered multiple reports using the FR studio.
- Integrated data from Fusion Cloud to the client customized database for reporting purpose.
- Develop PL/SQL program that extracts and generate a flat file with the client information from Automate the data load process by scheduling PL/SQL packaged procedure as a concurrent program
- Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
- Involved in the Personalization of the custom international budget form so as to fit the US requirements.
- Created custom Shell scripts to handle the loading the data file into the custom tables.
- Extensively resolved issues in GL Accounting Cycle (Revaluation, Translation and Conversion), Designed and developed GL Work Flows.
- Designed and developed the Events Model by interacting with the client and configured the Account Derivation rules, Mapping sets, Journal line types.
- Designed and developed reports using Oracle 10g and XML Publisher.
- Designed and configured the Flex field and segment qualifier as a part of COA Set up. Included the secondary tracking segment as a part of R12 upgrade.
- Performed Forms Customizations based on business requirements.
Confidential
Oracle Finance Techno-Functional Consultant
Responsibilities:
- Implementation and configuration of Financials Accounting Hub from scratch and transfer the journals to PeopleSoft
- Configured and implemented the Chart of Accounts (COA).
- Designed and developed the interface, custom validation program and RDF reports as a part of the FAH implementation.
- Designed and developed the Events Model by interacting with the client and configured the Account Derivation rules, Mapping sets, Journal line types.
- Developed a Custom Validation program, involving XLA tables for journal validation using Pl/Sql and optimized performance (Bulk Collects, Collections, and Ref Cursors).
- Developed the inbound interface to validate and post the journals in an external system.
- Developed a new inbound interface for importing all inventory adjustments from legacy system to oracle base tables.
- Developed the Reports using BI publisher (OBIEEE), ODBI and Oracle Reports 10g.
- Developed Security rules and cross validation program.
- Used the tools like Explain Plan, SQL*Trace and TKPROF for high efficiency.
- Involved user meetings for Gap Analysis and legacy field mapping.
- Created intercompany Transaction, Consolidation, Elimination entries setups and configuration for user. The use of ADI wizards like Budget wizard, Journal wizard, report wizard simplified work with general ledger
- Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types for HRMS module and mapping of Costing fields with Oracle financials.