Kadir Atmaca
Mentor
Rising Codementor
US$15.00
For every 15 mins
ABOUT ME
Senior DWH&BI Consultant with 5 years of experience
Senior DWH&BI Consultant with 5 years of experience
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.
English
Istanbul (+03:00)
Joined June 2022
EXPERTISE
5 years experience
3 years experience
3 years experience
2 years experience
2 years experience
REVIEWS FROM CLIENTS
Kadir's profile has been carefully vetted and approved as a Codementor. Connect with Kadir now, and leave a review for them once you're done!
EMPLOYMENTS
DWH&BI Consultant
Digitallency
2020-12-01-Present
I am working in the data mart team of Data Warehouse Directorate. In this team, we were modelling the data marts based on dimensional mod...
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.
Oracle
Informatica
Data Warehouse
View more
Oracle
Informatica
Data Warehouse
View more
DWH%BI Specialist
Paycore
2020-09-01-2020-12-01
I was working in DWH team as a Business Intellience specialist. I am responsible for the following tasks ;
1- Data transfers from Main F...
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.
Oracle
SSIS (SQL Server Integration Services)
Microsoft SQL Server
View more
Oracle
SSIS (SQL Server Integration Services)
Microsoft SQL Server
View more
Business Intelligence Specialist
Garanti BBVA
2018-02-01-2020-09-01
I worked in the Business Intelligence team of the Financial Planning and Analysis Department. In general, we were preparing top managemen...
I worked in the Business Intelligence team of the Financial Planning and Analysis Department. In general, we were preparing top management reports and institutions’s reports such as BDDK or Central Bank in this team. We used different technologies while preparing the reports such as Excel , Power Bi, SAP BO and SSRS. Oracle, MS SQL Server and SSIS were the other technologies that we used.
In addition, we were trying to find solutions for the data needs of other units in the bank, which are necessary for their processes or reports.
Oracle
SSIS (SQL Server Integration Services)
Microsoft SQL Server
View more
Oracle
SSIS (SQL Server Integration Services)
Microsoft SQL Server
Microsoft Power BI
SAP BusinessObjects
View more
PROJECTS
MERCHANT REPORT AUTOMATION
Garanti
2019
This report, which was made manually in Excel, was developed and redesigned to be completely automatic. The query required for the data o...
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.
Excel
Excel VBA
View more
Excel
Excel VBA
View more
CUSTOMER EXPERIENCE JOURNEY PROJECT
Garanti
2019
This project was realized as a requirement of the Customer Experience Department. For the experience journey with many different scenario...
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.
SQL
SSIS (SQL Server Integration Services)
View more
SQL
SSIS (SQL Server Integration Services)
View more