Oracle Fusion Consultant Resume
NC
PROFESSIONAL SUMMARY:
- Over 11 years of hands on experience in the IT industry as an Oracle Financials Functional and Techno - functional consultant with expertise in Oracle Fusion Financials Rev13, Oracle EBS Financials Applications R12 & 11i.
- Experience in Implementations, Upgrade, Testing and Maintenance and Support projects, including multiple full life cycle implementations of Oracle Fusion Financials, EBS R12 and 11i.
- Expertise in core module setups and functionalities of GL (General Ledger), AP (Accounts Payable), Purchasing/ Procurement (i-Procurement), Oracle Payments and experience in CE (Cash Management), FA (Fixed Assets).
- Thorough knowledge of Procure to Pay (P2P) business cycles and the Integration functionality in Oracle.
- Created and reviewed Functional design documents, Business Requirement Definitions documents, validation of Oracle fusion application configuration/ setup documents. Created Fusion Test Plans, Test Strategy and Test cases documents.
- Experience in using Oracle Fusion Setup Manager (FSM) for defining Implementation Projects, Offerings, Features, Tasks and Setup Data Maintenance.
- Experience in creating Functional documents like MC050, AN100 and Testing Documents like TE40, TE60 etc.
- Proficient in mapping client business requirements to Oracle/ Fusion functionality and setup application in the Test, Development, Integration and Production environments.
- Expertise in reviewing and analyzing the 'As-Is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions.
- Highly Quality oriented, self-driven and motivated for timely target achievement, effective oral and written communication skills, presentation skills, strong analytical problem solving capabilities.
- Experienced lead with analytical and problem solving abilities.
- Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development Life Cycle (SDLC) which include Analysis, Design, Development and Testing.
TECHNICAL SKILLS:
Database: Oracle 12c/11g/10g/9i
GUI: Fusion, Forms and Report 10g, XMLP, Discoverer 10g
Tools: TOAD, SQL*Loader, PL/SQL Developer, SQL Developer, UTL FILE, Autosys iXP
Operating Systems: Linux, UNIX, Windows XP/7
PROFESSIONAL EXPERIENCE:
Confidential, NC
Oracle Fusion Consultant
Responsibilities:
- Implementation of Oracle Cloud Fusion Financials including Oracle Payables, Payments, General Ledger and Fixed Assets.
- Identifying the business requirement for Application specific configuration and converting them to MC050.
- Identifying the business requirement for Custom client specific process and converting them as High Level Functional document.
- Conversion of BAFF, UBAFF, ITAU and CITIBANK payment formats to ISO format.
- Configuring Payment files for ISO specific standard and also as per client specific customization in XSL.
- Mapping of Bank Management File to ISO Acknowledgement File.
- Configuring of Payment Acknowledgement process.
- Creation of AP to GL custom Intercompany Accounting Process specific to client requirement.
- Configuring and Creation of Custom Interface between Oracle 11i GL to Oracle Fusion GL due to delay in Oracle Fusion AP go-live.
- Bulk Supplier Loading, Invoice loading etc using FBDI process.
- Configuring custom Masking requirement to mask Confidential Data since Oracle Fusion does not provision the feature on DFF fields.
- Setting up of Procurement Agents.
- Configuring the Set ups and Business Units using FSM.
- Using combined effect of Agile and SDLC methodologies based on sub-Projects.
- Providing every day status report to Manager.
- Creation of High level design, Low level design documents, AN100, MC050, MD050, MD070, Unit Test Plan and Unit test scripts for the project.
- Creation of reports using Fusion Reports and Analytics.
- Highly potential and own the complex processes of Release and Change management which involves deploying and documenting various phases of the implementation.
Technical Environment: SQL developer, PL/SQL, Toad, Cloud Fusion R13, E-business suite 11i, Oracle 12c, Oracle 11g, SQL Plus, Linux, Autosys iXP, Microsoft Office Suite, Visio.
Confidential, FL
Oracle Financials Consultant
Responsibilities:
- Implementation of Purchasing and iProcurement modules for New Countries.
- Setting up the Account Standardization of the countries.
- Designed and Developed Xpress Order set up so that Purchase Requisition lesser than threshold limit are auto approved and Direct to Supplier Purchase Orders are created automatically.
- Deployed concurrent programs to analyze the statistics of the stuck workflows.
- Converting discoverer reports into BI Reports to provide Purchasing data to business in a much robust manner.
- Optimized the concurrent managers to use the concurrent process effectively thereby saving lot of performance time.
- Monitor and interact with the business daily to grab business opportunity and also gather various requirements to satisfy business need.
- Creation of High level design, Low level design documents, Unit Test Plan and Unit test scripts for the project.
- High experience in Month End processing which interacts and process with various applications of GL data to produce Monthly/Quarterly/Yearly management reports.
- Handling the customizations and Production support issues related to Oracle GL, Purchase, Payables and Assets.
- Effectively designed Oracle Alerts for various periodic and event notifications.
- Highly potential and own the complex processes of Release and Change management which involves deploying and documenting various phases of the implementation.
Technical Environment: SQL developer, PL/SQL, Toad, E-business suite R12, Oracle 11g, SQL Plus, Linux, Autosys iXP, Microsoft Office Suite, Visio
Business Environment: -Banking and Finance
Confidential, FL
Oracle E-Biz Consultant and Project Leader
Responsibilities:
- Managing a team of 10+ developers as a project leader and involved in all lead activities.
- Designed and developed Oracle EBS features such as Ledger Set, TCA, MOAC set up and many more.
- Managed a project in upgrading the Oracle Discoverer from 4i to 10g.
- Invented an idea of designing an automation which helps in identifying the inactive users, send reminders to login and disable the defaulters. This had greatly reduced the time of business by 99% in tracking the users manually.
- Designed the automation of Audit trail reports which helps in tracking the activities of the application and transmit thru email.
- Optimized the concurrent managers to use the concurrent process effectively thereby saving lot of performance time.
- Monitor and interact with the business daily to grab business opportunity and also gather various requirements to satisfy business need.
- Creation of High level design, Low level design documents, MD050, MD070, Unit Test Plan and Unit test scripts for the project.
- High experience in Month End processing which interacts and process with various applications of GL data to produce Monthly/Quarterly/Yearly management reports.
- Used software extension, CEMLI to create custom reports
- Leading the Technical team during the implementation and support phase.
- Handling the customizations and Production support issues related to Oracle GL, Purchase, Payables and Assets.
- Designed an Oracle form to reduce the amount of backend work on database which satisfied audit compliance.
- Effectively designed Oracle Alerts for various periodic and event notifications.
- Highly potential and own the complex processes of Release and Change management which involves deploying and documenting various phases of the implementation.
Technical Environment: SQL developer, PL/SQL, Toad, E-business suite R12, Oracle 11g, SQL Plus, Linux, Autosys iXP, Microsoft Office Suite, Visio
Business Environment:- Banking and Finance
Confidential, FL
Oracle E-Biz developer
Responsibilities:
- Have designed and developed the High level and low level technical documents like MD070.
- Have created an automation to create Suppliers in Oracle where the business can enter all the supplier details and press a single click. This has greatly reduced the amount of time used by the users in entering each AP form.
- Designed and developed various custom reports in Oracle reports 10g and XML publisher.
- Created new concurrent managers and modified all the concurrent managers for optimized processing of concurrent requests
- Extensively used Oracle Alerts to create periodic and event notifications which provided the flexible amendments of alerts as per the business need.
- Highly qualified in Month End processing which interacts and process with various applications of GL data to produce Monthly/Quarterly/Yearly management reports.
- Analyzed the bugs raised by the client and resolved instantly during the business days and much critical business close days.
- Customizing the forms using form personalization and also created various custom forms which standard forms could not afford.
- Have worked on the complex processes of Release and Change management which involves deploying and documenting various phases of the implementation. Prepared Component Integrated testing scripts for the project.
Technical Environment: SQL developer, PL/SQL, Toad, E-business suite 11i/R12, Oracle 10g, SQL Plus, Unix, Autosys iXP, Microsoft Office Suite, Visio
Business Environment: Banking and Finance
Confidential
Oracle E-Biz developer
Responsibilities:
- Designed Oracle D2K forms and reports to satisfy the business need of Pipeline Inspection application which standard Oracle forms were not able to compete.
- Developed Discoverer reports wherever it is possible to avoid the complex building of Oracle reports.
- Extensively used Oracle procedures, functions, packages, cursors and other Oracle objects to build the Oracle forms and reports.
- Created new concurrent managers and modified all the concurrent managers for optimized processing of concurrent requests.
- Extensively used Oracle Alerts to create periodic and event notifications which provided the flexible amendments of alerts as per the business need.
- Analysis of Functional Specifications and preparation of Technical Design Documents
- Enhancement and modification of existing Programs
- Up gradated & migrated legacy applications (like Forms 6i and Reports 2.5) into Forms and Reports 10g environment.
- Preparation of test scenarios and test cases in order to provide a no defect delivery in all the time.
- Preparation of the six-sigma project to implement the process in our application to provide no failures certification.
Technical Environment: SQL developer, PL/SQL, Toad, E-business suite 11i, Oracle 10g, SQL Plus, Unix, Autosys iXP, Microsoft Office Suite, Visio
Business Environment:- Energies and Utilities