Job Description :
Oracle OFSAA Consultant (Business Analyst Role)
West Chester, PA
6-12 Months contract




Job Description:-

Must have (Technical)
Configuration of the OFSAA solution.
Understand business requirements and implement technical solution within OFSAA in an efficient way
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/ Costing applications in financial and banking domain.
Expert of Oracle Financial Services Analytical Application toolset.
Recommend enhancements in Oracle DB and tool based on implementation experience.
Experienced in all phases of Software Development Life Cycle
knowledge of Oracle 11g, SQL, PL SQL, Data Architecture, Unix Shell Scripting, advanced Performance tuning
Experienced in OFSAA Data Foundation and GL Reconciliation Modules
Experience in Unified Metadata Manager
o Import Model
o Data Management Tools: like T2Ts, File Extracts, Data Quality Framework
o Data Entry Forms and Queries; Excel uploads; Atomic Schema Uploads
o Business Metadata Management
o Metadata Archive/Restore
Rules Framework; Configure Business rules in OFSAA.
Metadata Browser
Should have worked on sourcing data from multiple source systems using ODI/ Informatica/ OWB or other major ETL/ ELT tools.
Exposure to DIH would be good to have
Must have (Operational)
Production support of OFSAA, this includes batch runs and development requests to fix defects as required.
Designs technology solutions by modeling requirements and applying standard application methodology best practices
Thorough understanding of key business processes and ability to communicate and translate those needs to technical solutions
Work closely with internal and external clients, technical resources and executives (Application Managers, Business Analysts, System Analysts and Development / Quality teams)
Evaluate the risks and solutions before taking action, so that action plans are timely, realistic and positive
Promote a collaborative Team environment that fosters creativity, innovation and high performance
Responsible for meeting company’s customer advocacy & satisfaction objectives
Who is our ideal candidate? • 3-5+ years of Hands-on experience in OFSAA modules.
3+ years of expertise in developing forms with the help of OFSAA forms framework.
6+ years of experience writing and debugging complex SQL queries and Stored Procedures in Oracle database.
6+ years of experience working in the financial industry
Excellent understanding of BFSI - Banking and Insurance domain
Experience in Metadata browser, Rules Framework, data management tools.
Expertise in configuring Business rules in OFSAA Modules.
Expertise in building T2T (Table to Table) transformations in OFSAA.
In-depth understanding of Dimensions, hierarchies and attributes as it applies to OFSAA profitability modules.
In-depth understanding of Data Warehousing concepts and dimensional modeling.
Strong analytical and troubleshooting skills.


Thanks and Regards
Himani Dureja
Gemini Consulting & Services LLC
Email ID: