Selim Çubuk Email & Phone Number

Istanbul, Turkey

Istanbul, Turkey

Creating executive dashboards and reports using Power BI for business units such as finance, retail banking, corporate banking, commercial banking, payment systems, treasury, etc.Managing development team, assigning tasks, organizing meetings.Training and giving continuous support to more than 200 power users so that they can develop their own reports using Power BI.

Istanbul, Turkey

Management of a team of 12 people giving Data Warehouse and Business Intelligence support to more than 25 customers, mostly financial institutionsDevelopment of the Inter-DWH data warehouse model, installation to new systems, performing gap analysis and development of requested changesDeveloping ETL processes on SSIS and Informatica, in order to feed the Inter-DWH data modelPreparing operational and head office reports requested by customers, feeding data sets for data integration with Third Party applications and developing ETL processes, such as:* Experian | Emerging Credit Score (SM)* Siron | Anti-Money Laundering (AML)* Siron | Know Your Customer (KYC)* RiskActive | Asset & Liability Management (ALM)

Modeling Ziraat Bank data warehouse from scratch based on Teradata's Financial Services Logical Data Model (FSLDM), within the scope of Data Warehouse project initiated by the bank in 2009The development, monitoring, and management of ETL processes using IBM DataStage in order to load data from source systems running on Oracle and SQL Server to Teradata data warehouseDevelopment of data marts in order to get the requested reports and analytical queries faster via TeradataUser creation, user authorization, database management, performance improvement, and user support in Teradata Production systemUniverse design, reporting, user creation, user authorization, and user support in Business Objects

Development of Foreign Trade and Treasury modules of FINART, which is the core banking application currently used in more than 1500 branches of Ziraat Bank, using C# and Oracle PL/SQLIn foreign trade module; export letter of credit, export customs declaration, export letter of guarantee, collateral security, file tracking, cash against documents, and correspondent bank limit processesIn treasury module; foreign exchange transactions, forward, options, futures, and swap transactions, SWIFT integration of treasury transactions, swap blotter and money market blotter processes