Personal details

Kadir A. - Remote

Kadir A.

Timezone: Istanbul (UTC+3)

Summary

Hello Everybody,

I graduated from İstanbul Technical University in 2014. I studied Management Engineering there. After graduation, I started working in the field of data warehouse and business intelligence. I have about 5 years of experience in this field. I first started working as a business intelligence specialist at Garanti BBVA. Our main job was to prepare top management reports. I used technologies at Garanti such as power bi, sql server, oracle, sap bo, ssis, ssrs. After this team, I worked as a data analyst in the internal control team at Garanti. Then I started to work as a DWH&BI specialist at PayCore. Here, I used tools such as SQL server, ssis and sap bo. After this experience, I started working as a DWH&BI consultant at Digitallency. I got involved in the ongoing datamart consolidation project at Akbank. Within the scope of this project, we were modeling data marts for business units. We use sap power designer for our data warehouse conceptual model, Oracle for our physical model, and Informatica for our etl flows.

Work Experience

DWH&BI Consultant
Digitallency | Dec 2020 - Present
Oracle
Informatica
Data Warehouse
I am working in the data mart team of Data Warehouse Directorate. In this team, we were modelling the data marts based on dimensional modelling (like star schema) standarts and designing the ETL flows. We used Oracle DB to hold data warehouse and data marts, used Informatica for ETL processes, SAP Power Designer for modelling. After finished this project we started to new data mart project for call center of Akbank. We gathered the needs of the call center and we analyzed these needs. After that, we started to build the model and design etl flows.
DWH%BI Specialist
Paycore | Sep 2020 - Dec 2020
Oracle
SSIS (SQL Server Integration Services)
Microsoft SQL Server
I was working in DWH team as a Business Intellience specialist. I am responsible for the following tasks ; 1- Data transfers from Main Frame to DWH system. For this purpose we are using SSIS tool. 2- Performing performance studies on the existing DWH system. 3- We are trying to meet the reporting needs of other departments. We are using SQP BO tool for this purpose.

Personal Projects

MERCHANT REPORT AUTOMATION
2019
Excel
Excel VBA
This report, which was made manually in Excel, was developed and redesigned to be completely automatic. The query required for the data of the report was embedded in Excel and the data was started to be obtained with this method. The necessary arrangements for the creation of the report were also made thanks to Excel VBA codes. Then, the report was automatically sent to the relevant team on a weekly basis using the Task Scheduler, a Windows 10 feature.
CUSTOMER EXPERIENCE JOURNEY PROJECT
2019
SQL
SSIS (SQL Server Integration Services)
This project was realized as a requirement of the Customer Experience Department. For the experience journey with many different scenarios, a data model has been developed to suit these scenarios. The report was designed to work only on official working days, at the request of the business department . A package was created on SSIS for data transfers.