Nour A.

Bangladesh Bank EDW Project (IT-7) with Basel-II implementation. Technology: Oracle EXADATA, OracleDI, OWB, OBIEE, Oracle10g Developer Suite. .Basel II Business requirements – Source system (GL) To Basel Data Warehouse .Business Analysis . Credit Risk, Market Risk & Operational Risk calculation & reporting .Basel II Business requirements - Data warehouse to Risk Engine .Settings for the Risk Calculation engine .Risk Engine Results layer to Basel II reporting layer .Solution for National Discretion (Central bank Reporting) .ALCO reporting through IFRS9 .Data Modeling (LDM & PDM) .Developed standard SQL, PL/SQL code for ELT purpose. * Design and created ETL standards and procedures * Architecture design of new data warehouse and ETL process * Designed and installed test scripts for ETL code * Created OWB (Oracle Warehouse Builder) and ODI (Oracle Data Integrator) ETL code from functional and technical specs * Developed Oracle Procedures, Functions and Packages and Syntax. * Design and created FTP scripts for moving source and target files * Tuned SQL and PL/SQL statements for end users creating custom reports * Worked on all phases of data warehouse development life-cycle, from gathering requirements to testing, implementation, and support. * Demonstrated expertise utilizing ETL tools, including Oracle Warehouse Builder, OracleDI ETL package design, and RDBM systems like SQL Servers, Oracle. * Architecting/designing the application accessing multiple type of data stores (Data warehouses, Datamarts, ODS, OLTP) and design of logical/physical data model. Also responsible for defining standards for database design and data modeling. * Created a number of cubes, dimensions and business critical KPIs using Oracle Analytical Workspace Manager and BI Server in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. * Dash-board design. * Design and develop test plans.