I'm working for the +4 years with the Oracle Financial Services Analytical Applications (OFSAA).
o Configuring, implementing and supporting the OFSAA FTP & PFT modules.
o Building Allocation rules, SQL Rules, Batches, Filters, Hierarchies and Static tables.
o Develop PL/SQL scripts used for OFSAA staging, ledger and instrument tables data loading processes.
o Develop highly-optimized complex PL/SQL Stored Procedures, Functions, Packages and Triggers.
o Customization of the OFSAA Data Models through Erwin data modeler.
o Develop and Test Physical Layer, Business Layer and Presentation Layer of OBIEE Admin Tool.
o Perform migration and merging of RPD’s in OBIEE.
o Design Schema/Diagrams using Fact, Dimensions, Physical, Alias and Logical tables.
o Create Drill down Hierarchies and implemented Business Logics for Facts.
o Develop Financial Reports, Filters, and Prompts using Oracle BI Answers.
o Manage Security privileges for each Subject area and Dashboards according to user requirements.
o Design ETL (Extract Transformation Load) Maps/Workflow for loading data from Bank OLTP Systems to a unified staging area and Data Warehouse.