Oracle Financial Specialist – Senior Position RoleRequired Experience 5+ Years Experience The candidate must be (60%) Technical and (40%) Functional and possess the following skill-sets:Well-versed with EBS modules - Inventory, Purchasing, Payables, Receivables, Sub-Ledger Accounting and General LedgerAn understanding on, how Oracle Grants/Projects works and its integration with other Oracle modules like Purchasing, Payables, Receivables and OTLBasics of Oracle HRMS, Oracle Time and LaborTechnically strong in R12.2.x architecture and tech-stackThe candidate must be technically strong in:Oracle Application Object LibraryOracle Forms and Reports Developer - 10gOracle WorkflowSQL, PL/SQLJava, J2EEOracle Applications FrameworkOracle Database 12c, 19cScripting (Unix Shell, SAMBA Client Scripting, JavaScript)XML Publisher ReportsOracle Business IntelligenceServers - Linux/UnixToadJDeveloperSQL DeveloperTest Plans and User GuidesOUM Documentation standardsOBIEE ReportsWeb Services DevelopmentAzure Devops for Source ControlScope of the Work Assisting the Existing Oracle Senior Financial Specialist and the Two Supporting Technical State Employees in supporting FMS for the Department. Currently 800+ employees are utilizing OTL. The proposed Scope of Work describes the tasks to be performed by the consultant on the Oracle R12 Financial Management System for the RIDOT in making improvements to the current R12 application.
The Scope is based on performance improvements to concurrent programs/functions and adding additional program functionalities, automating business processes, perform upgrades. All our modules have a great deal of customizations. From a reporting stand point, HR and OTL have the most custom reports.
Whereas Grants, OTL and AP have the most customizations impacting functionality. Candidates need to keep in mind this is for Public Sector and having a strong Technical background in the Core Modules of Oracle Financials is required. Having a strong technical background in Grants, OTL and HR are in need to support our Department.Scope of Services Oracle Financial Specialist – Senior Position Role: The consultant is responsible for:Supporting the business activities through active work on client engagements, understand our business model, business processes, suggest improvements and map the requirements for the Oracle EBS environmentSupport and assist the internal IT team with support issues and key development areasPrepare project plans, estimates and milestones, task plans, test plans and defect tracking mechanisms to deliver and manage projects, customizations & enhancementsHands-on experience in Oracle EBS R12.2.X implementations, upgrades and supportPossess sound knowledge of multiple Oracle EBS modules like HRMS, Time and Labor, Inventory, Purchasing, Payables, Grants, Subledger Accounting, and General LedgerAbility to design, develop and deliver high level custom solutions using SQL, PL-SQL, RICE Objects (Interfaces, Conversions, Integrations and Extracts), Oracle Application Object Library, Oracle Forms 10g, Reports (Oracle Reports 10g, Discoverer Reports 11g, XML and BI Publisher Reports, OBIEE Reports and Analytics), Workflows, Oracle Application Framework, Java, XML, Scripting (UNIX Shell, SAMBA Client, JavaScript), Oracle Database 19c, and Oracle tools (JDeveloper, SQL Developer)Perform gap fixes and performance tuning, support new implementations and upgrades, develop and deliver customizations and extensionsPerform unit testing and coordinate with users for integration and system testingManage and coordinate issue resolutions and escalationsCoordinate with Oracle on Product bugs, patches and Service Request resolutionsWork with the DBAsWeekly report on deliverables status and presentations with managementImplement and roll-out Projects RIDOT FMS has multiple projects in the pipeline to add values to their current business or process, lower their cost base, perform effective risk management, and automate third-party integrations etc.
The consultant’s role will be to:Examine and analyze the benefits, risks of up taking the project for the organizationDiscuss with key stakeholders and assist them in decision makingDefine project plans, estimates and milestonesImplement effective risk management strategiesDiscuss with users to gather requirements and inputsAnalyze the requirements in detail and map the requirements onto Oracle EBSDesign, develop and deliver the projects on-time with quality deliverablesDocument test plans and results, deployment plansUpdate project repository using industry documentation standardsReview projects and coordinate with the Lead ConsultantReview project status weekly or as needed with the Agency IT Manager