Kadir Alnak

• Optimized insurance quote data for auto, home, traffic, and health sectors, improving the speed and accuracy of reporting.
• Developed a segment model for year-end performance rewards for agents, creating dashboards and KPIs to monitor their performance.
• Modeled health data in the H4All system and integrated it into the DWH environment.
• Managed accounting reconciliation processes and ensured the correct execution of operational jobs.
• Contributed to system improvements, enhancing flexibility and performance.

Flo DWH Migration Project

ETL Developer

• Facilitated the migration of all DWH tables, including dimension and fact tables, as well as data marts, to the cloud using Azure Synapse.
• Took necessary steps to ensure data integrity and security, enhancing system performance and accessibility.

Mapfre Insurance
Motor Control Processes ETL Developer
(2018 - 2020)

• Designed and implemented ETL processes for data integration, providing high-quality data for reporting and analysis.
• Increased process transparency by monitoring payment amounts and pending files related to claims.

Agency Portal Data Transfer Implementation
(2018 - 2020)

• Prepared data for the agency web interface in the DWH environment by extracting required KPI data based on established rules.

EPİAŞ - EXIST | Corporate Data Warehouse Project for Natural Gas Market Platform
July 2018 - November 2018

• Contributed to the development of a comprehensive Data Warehouse (DWH) and Business Intelligence (BI) system for EPİAŞ new Natural Gas Market Platform.
• Developed BI reports and analytical models using OBIEE 12c to support data-driven decision-making processes.
• Assisted in creating and maintaining daily operational reports via BI Publisher, ensuring seamless operational processes.
• Utilized advanced tools like DATASTAGE 15.5 and Oracle 12c to successfully ensure system performance and data integrity.

EPİAŞ - EXIST | Corporate Data Warehouse Project
October 2017 - June 2018

• Analyzed EPİAŞ core OLTP (Online Transaction Processing) system and identified reporting requirements.
• Designed ETL processes and optimized data flow by improving existing ETL operations, including the transition to Oracle 12c.
• Contributed to project processes using DATASTAGE 11.5.02, Oracle 11g (source and target databases), and OBIEE 11g - 12c tools.

• Developed skills in Oracle BI (Business Intelligence) and conducted various analyses and reporting activities in this field.
• Worked on data integration, creating business intelligence reports, and data modeling using Oracle BI tools.
• Contributed to data interpretation and business analytics processes necessary for decision support systems.
• Facilitated knowledge transfer among team members by leading training sessions on new tools, techniques, or industry best practices relevant to the role of Technical Consultant.
• Enhanced system performance by identifying and resolving technical issues through troubleshooting and root cause analysis.