Gokhan Yavuzkendirci
Lead Data Engineer
Dubai
Summary
Experienced Senior Data\DW Engineer with more than 11 years of experience in BI Industry. Proactive and goal-oriented professional with excellent time management and problem-solving skills. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth.
Overview
11
11
years of professional experience
8
8
years of post-secondary education
2
2
Certificates
Work History
Lead Data Engineer
Solution BI
02.2024 - Current
- Lead Data Engineer on Reporting Factory Project for Danone France.
- Team Leadership: Managed and mentored a team of data engineers, assigning tasks, providing guidance, and fostering professional development. Oversaw the execution of project tasks and ensured adherence to project timelines and quality standards.
- Report Development: Led the design and implementation of multiple critical reports, including Profit and Loss (P&L), Topline, Manufacturing, Logistics, Cost of Goods Sold (COGS), Replenishment Order Point (ROP), Brand and Category, and Treasury reports. Utilized advanced Snowflake SQL and Informatica Intelligent Cloud Services (IICS) jobs to extract, transform, and load data efficiently.
- Parameterization: Implemented a robust parameterization strategy for report generation, leveraging multiple parameter tables to ensure the accuracy and reliability of financial data. Developed dynamic reporting frameworks that allowed for precise customization of reports based on specific requirements, including data range and key performance indicators (KPIs).
- Data Integrity and Accuracy: Ensured the integrity and accuracy of financial data by meticulously validating data to exact numbers on reports. Implemented rigorous quality assurance processes to validate report outputs against source data, identifying and resolving discrepancies promptly.
- Version Control and Documentation: Established comprehensive version control mechanisms using Git to track changes and updates to report templates and parameter files. Maintained detailed documentation outlining report specifications, parameter configurations, and extraction methodologies, ensuring transparency and repeatability in report generation processes.
- Task Management: Utilized Asana for task tracking and project management, assigning tasks to data engineers, organizing and prioritizing development tasks, and ensuring timely completion of deliverables. Facilitated seamless collaboration among team members and stakeholders, streamlining communication and workflow processes.
- Collaboration and Stakeholder Management: Collaborated closely with finance stakeholders to understand reporting requirements and translate them into actionable deliverables. Facilitated regular feedback sessions and status updates to ensure alignment with stakeholder expectations and project milestones.
Lead Data Engineer
Solution BI
09.2023 - 02.2024
- Lead Data Engineer on Migration Finance Project for Danone France.
- Automation Development: Developed and implemented robust automation Python programs to streamline the migration process. These programs efficiently generated detailed syntax comparisons between DB2 SQL and Snowflake SQL, identifying nuances and differences crucial for successful migration.
- Script Conversion: Led the conversion effort of DB2 scripts to Snowflake SQL, leveraging automation tools and custom scripts. This involved meticulously transforming complex DB2 scripts into compatible Snowflake SQL queries while ensuring data integrity and performance optimization.
- ETL Conversion: Oversaw the conversion of ETL processes from Informatica PowerCenter to Informatica Intelligent Cloud Services (IICS), ensuring compatibility and efficiency in data extraction, transformation, and loading activities. Collaborated with ETL developers to modify existing workflows and mappings, optimizing them for the new cloud-based environment. Stonebranch tool was used for scheduling.
- Object Mapping and Migration: Managed the mapping and migration of a diverse range of database objects from DB2 to Snowflake, including tables, views, stored procedures, and functions. Ensured accurate translation of database structures and functionalities to align with Snowflake's architecture.
- Collaboration and Communication: Worked closely with cross-functional teams, including database administrators, developers, and stakeholders, to coordinate migration activities and address technical challenges. Utilized project management tools such as Asana for task tracking and Git for version control. Communicated progress updates, identified potential risks, and provided strategic recommendations to ensure project success.
- Quality Assurance and Testing: Developed a comprehensive non-regression Python program to analyze and report data discrepancies between each environment, ensuring data consistency and integrity throughout the migration process. Conducted thorough quality assurance testing to validate the accuracy and reliability of migrated data and SQL scripts.
Lead Data Engineer
Solution BI
5 2022 - 09.2023
- Lead Data Engineer on Migration Project for Dubai Roads & Transport Authority.
- Developing and migrating PDW Data Warehouse of RTA Dubai to Cloudera Big Data Environment in RTA DW Migration Project
- Object analysis of existing PDW DW by using T-SQL
- PDW to Hive-Impala Object Conversion by creating a dynamic conversion script algorithm with HQL
- ETL- ELT Conversion SSIS to Informatica BDM
- Using SPARK Engine, Sqoop Connector, and parameters and fixing their issues (duplication, performance) in Informatica BDM
- Incremental structure, partitioned structure, parameterized workflow execution in Informatica BDM
- ETL workflow mapping-command task orchestration, log and alert structure on Informatica BDM
- Adapting traditional challenging SQL Code and Infrastructure to Hadoop Environment by using HQL, Python, PySpark, and Bash
- MSTR reporting query development by using Impala
Senior Data Engineer
Softtech – Is Bank
06.2021 - 05.2022
- Researched and implemented the latest technologies and tools in big data and data warehouse environments.
- Hadoop, Spark, Python, Sqoop, Hive, Impala and UNIX Shell Scripting was used in Cloudera Big Data Environment
- Utilized PySpark within the Cloudera ecosystem for ETL tasks, transforming raw data from various sources (files, APIs, and web services) into structured formats and integrating it into HDFS and Hive
- Designed scheduling mechanisms and data pipelines using Apache Oozie within the Cloudera environment for orchestrating complex data workflows.
- Informatica BDM and ODI ETL tools was used for ETL
- PL/SQL was used in Oracle data warehouse
- Was creating reports by using Qlik Sense
- Decided and developing the main data flow architecture of the bank
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
Senior ETL Developer
Yapi Kredi Bank
01.2019 - 05.2021
- Was ETL Development Lead in Yapi Kredi Financal Group HR Department
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations using Informatica PowerCenter
- Developed regarding reengineering and conversion of existing batch jobs to Informatica PowerCenter mappings
- Verified performance and reliability of development database transformation solutions via extensive simulation testing
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals
- Wrote and optimized in-application SQL statements using PLSQL on Oracle Data Warehouse
- Managed data quality issues during ETL processes and according to logical rules which gave from Business Unit by using Qlik Sense Dynamic Query Structure
- Developed application and web services to populate Data Warehouse or exporting data to another environments by using .NET and C#
- Generating custom reports by using Qlik View
- Validated warehouse data structure and accuracy
- Documented data warehouse architecture to guarantee capacity met current and forecasted needs
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows in Informatica PowerCenter
- Interpreted data models for conversion into ETL diagrams and code using Power Designer
- Worked with Agile methodology by using Jira
Senior ETL Developer
Intertech (Denizbank)
09.2016 - 12.2018
- Developed DW and ETL for various banks (HSBC, SberBank, BankAudi, Turkcell Financial Group Company) by using Informatica PowerCenter, ODI, SSIS ETL tools on Oracle and MSSQL environments
- Designed and developed DW in BankAudi DW reengineering project in Beirut, Lebanon by using ODI, MSSQL
- Participated in HSBC Bank GSIF development project by using Informatica PowerCenter, MSSQL
- Performance tuning and optimization
- Development version control by using Visual Studio TFS
Senior ETL Developer
Metric Consultancy (Is Bank)
01.2016 - 09.2016
- ETL Development of BDDK, and TMSF reports in IsBank DWH and Government Of Turkey Regulatory Reporting Project by using Oracle Data Integrator on Oracle Environment
- Participated in DB2 to Oracle Reengineering Project
- Improvement and adding new ODI ETL infrastructures (Log Alert Mechanism, Exporting Dynamic Reporting, Dynamic Data Quality Job)
- Performance tuning and optimization of old ETL processes
ETL Developer
I2I BI Consultancy (Turkcell)
09.2013 - 12.2015
- ETL Development at Turkcell Superonline DWH Development Roadmap Team by using Oracle Data Integrator and Ab-Initio ETL tools
- Performance tuning and optimization of ETL processes on Oracle database system
- Prod ODI Application Administrator
- Generated reports by using Business Object
- Participated in Oracle Exadata and ODI upgrade projects
- Development of Customer Segmentation Data Mining Project by using SAS
Education
Bachelor of Science - Computer Engineering
Harran University
Sanliurfa, Turkey 09.2009 - 07.2013
High School Diploma -
Izmir Atakent Anatolian High School
Izmir, Turkey 09.2003 - 06.2007
Skills
DATA: Cloudera, Hadoop, Hive, Impala, Spark, HDFS, Snowflake, PDW, Oracle, MSSQL, DB2
Certification
Informatica Data Engineering 10.2 Developer, Professional Certification
Timeline
Lead Data Engineer
Solution BI
02.2024 - Current
Lead Data Engineer
Solution BI
09.2023 - 02.2024
Cloud Data Integration Developer R41, Informatica Certified Professional
08-2023
Informatica Data Engineering 10.2 Developer, Professional Certification
12-2022
Senior Data Engineer
Softtech – Is Bank
06.2021 - 05.2022
Senior ETL Developer
Yapi Kredi Bank
01.2019 - 05.2021
Senior ETL Developer
Intertech (Denizbank)
09.2016 - 12.2018
Senior ETL Developer
Metric Consultancy (Is Bank)
01.2016 - 09.2016
ETL Developer
I2I BI Consultancy (Turkcell)
09.2013 - 12.2015
Bachelor of Science - Computer Engineering
Harran University
09.2009 - 07.2013
High School Diploma -
Izmir Atakent Anatolian High School
09.2003 - 06.2007
Lead Data Engineer
Solution BI
5 2022 - 09.2023
Similar Profiles
Thiago OliveiraThiago Oliveira
Senior Data Engineer at Solution BISenior Data Engineer at Solution BI
Mikhael LambertMikhael Lambert
Directeur De Pratique Oracle EPM Cloud / Hyperion at Solution BI CanadaDirecteur De Pratique Oracle EPM Cloud / Hyperion at Solution BI Canada
LaShayna AlexanderLaShayna Alexander
Receptionist at Bi City DUI SchoolReceptionist at Bi City DUI School