Previous Job
Previous
Oracle OFSAA Consultant
Ref No.: 18-64408
Location: Pittsburgh, PA, Pennsylvania
Position Type:Direct Placement
Experience Level: 11 Years
Start Date: 09/04/2018
  • Perform and lead workload and risk analysis related to OFSAA reporting solutions.
  • Lead the design of OFSAA financial data warehouse solutions based on the key business change requirements and deliverables.
  • Be involved in discussions with users, management, and other technical personnel to clarify requirements, identify problems, and suggest changes and/or best practices.
  • Design and develop software component within OFSAA platform including but not limited to: SCD, T2T, T2F, Batch, PLT, DQ.
  • Document technical specs of each OFSAA software component implementation.
  • Work side by side with other developers and database administrators to improve software performance of OFSAA.
  • Support, maintain and enhance existing financial software, and participate in user trainings
  • Develop and lead team developing data warehousing applications/ Costing applications in financial and banking domain.
  • Oracle SQL and PL/SQL Development
  • Recommend enhancements in Oracle DB and tool based on implementation experience.
  • Translate gathered business needs into technical requirements
  • Import Model
  • Data Management Tools
  • Data Ingestion

Required Skill:
  • Configuration of the OFSAA solution, 5+years of experience on OFSAA.
  • Research and solve the data related issues within the environment.
  • Advising other assets engaged in the project on OFSAA configuration details.
  • Experience in leading and developing data warehousing applications/ profitability applications in financial and banking domain.
  • Act as business analyst for gathering requirements
  • Recommend enhancements in Oracle DB and tool based on implementation experience.
  • Experienced in all phases of Software Development Life Cycle
  • Experienced in OFSAA Data Foundation Must have (Operational)
  • Designs technology solutions by modeling requirements and applying standard application methodology best practices

Technical Skill:
  • 5+ years Solution Architect-Solution Architecture or experience in implementing OFSAA v8.0 or higher
  • Strong Oracle database development experience
  • Configuration of the OFSAA solution, 3+years of experience on OFSAA.
  • Research and solve the data related issues within the environment.
  • Advising other assets engaged in the project on OFSAA configuration details.
  • Sound understanding of key processing dimensions, hierarchies and attributes within OFSAA solution.
  • Good knowledge of the end-to-end data flow and calculations within OFSAA solution.
  • Working knowledge of writing SQL queries and troubleshoot data related issues.
  • Flexible in managing competing priorities and objectives.