Data warehouse Architect
CIB Bank
Total des années d'expérience :16 years, 8 Mois
Core Banking System Data Warehousing : T24 to Teradata Datawarehouse
Doing Impact Analysis Document
• Apply All changes required for the ETLs
• T24 Modules (Accounts, Securities, Interest Rate Swap IRS, Options, Syndicated Loans, Mortgage, Forex, Ledger)
Oracle Financial Services Analytical Application (OFSAA)
Building all ETLs required for OFSAA system to provide CIB senior management with profitability reports on a daily basis to serve the MIS as well as Liquidity/Reprising/Interest Income simulation scenarios
OFSAA Covered below banking modules :
Demand Deposit Account (DDA)
Investments ( Bills, Bonds, Shares)
Commercial Loans
Syndicated Loans
Consumer Loans
All Financial and Non-Financial Transactions from ( Fund Transfer FT, Teller TT, IVR, Mutual Funds, ATM, POS, Internet Banking, ...etc)
Wholesale Sale Funding.
General Ledger (GL).
Data warehouse Business intelligent and Database developer and Admin working at Microsoft BI SSAS /SSRS /SSIS for supporting Nissan USA
• Design and document database architecture. Data Modeling.
• Design Data Warehousing
• Build database scheme, tables, procedures and permissions
• Develop database utilities
• Restore and recover corrupted databases
• Install and test upgrades and patches
A Database Administrator and Data warehouse /BI Developer (
SSAS/SSIS/SSRS)
Development Reporting By Oracle and SAS
BI / Data Warehouse / Database admin and development Courses
• ETL tools (INFORMATICA, SSIS) and Third party tools
• Data Warehouse Designer (Microsoft DW, TeraData DW)
• Microsoft BI (SSAS, OLAP, SSRS, SSIS)
• Data mining: TERADATA MINIER
• Microsoft Reporting service, Business Object
• Data Modeling Administrating and BI (OLAP Analysis)
• OLAP Designer, MDX for Modeling and Cubes Query
• SQL Server / Teradata / Oracle / MYSQL
• Toad and third party SQL Tuning and administration
Database developer and Administration
• Design and document database architecture. Data Modeling.
• Design Data Warehousing
• Build database scheme, tables, procedures and permissions
• Develop database utilities
• Restore and recover corrupted databases
• Install and test upgrades and patches
Database Development & Admin & analysis & Tuning Admin: SQL Server 2008 R2 / Teradata / Oracle 11g/ MYSQL Big Data Systems like MongoDB DB Developer (Procedures ,Function ,Trigger ), PL/SQL Database Modeling, Architects Toad, Data Modeler and third party Query Tuning , Performance Monitor Replication Technologies ,Backup, Restoring Data Recovery Solutions Data Warehouse, BI, ETL ETL tools (INFORMATICA, SSIS),Third party tools Good information at Data Stage Data Warehouse Designer Snowflake, Star Schema (Microsoft DW , Teradata DW) Microsoft BI (SSAS , OLAP, SSRS , SSIS) Data mining: TERADATA MINIER, Microsoft Excel Data mining Operating Systems Microsoft (Operating Systems) o 2003 /2008 server o XP / Vista / Seven Linux / Ubuntu / Solaris Programming C / C++ / Visual C# / VBA Shell script Network CCNA / MCSE Certificates MCITP: Database Administrator on Microsoft ®SQL Server® 2008. Oracle Database 11g Administrator Certified. MCTS: SQL Server 2008. MCTS: SQL Server® 2005. Local TOEFL. ICDL.