Onat Gegeoglu
Krakow
Summary
A seasoned data specialist with extensive experience across all aspects of data, including visualization, reporting, data modeling, ETL, and business intelligence. Experienced in backend and microservices development. Business-oriented with a strong focus on delivering robust solutions that meet business needs. Committed to applying best practices in development by leveraging all available resources. Highly adaptable to new technologies and work environments.
Overview
13
13
years of professional experience
Work History
ETL Developer | Data Engineer
Brown Brothers Harriman
05.2021 - Current
- Developed ETL pipelines using ODI, PL/SQL, and shell scripts to collect internal and external data, including global holiday calendars.
- Designed database objects in Oracle to support ETL processes and optimize source usage.
- Performance-tuned various processes, achieving an average speed improvement of 3x.
- Contributed to Java Spring-based backend development by designing REST APIs to connect Informatica MDM with web applications.
- Automated approximately 20 man-hours of work per month through various projects, increasing productivity and minimizing error rates by 90%
Senior Business Intelligence Analyst
Vivid Games
08.2020 - 05.2021
- Designed and developed marketing dashboards in Qlik Sense to track ad performance and user engagement.
- Analyzed mobile advertising KPIs to optimize campaign effectiveness.
- Integrated external ad data (pricing, impressions) into internal analytics systems.
- Analyzed user game logs containing billions of rows using Google BigQuery and Amazon Redshift to extract insights on player behavior and engagement.
Business Intelligence Consultant
Brown Brothers Harriman (Contractor Via Sii)
08.2019 - 08.2020
- Designed audit reports for fund commission transactions using IBM Cognos.
- Customized IBM Cognos UI to align with business requirements.
- Worked with Oracle DB to extract and process financial data.
Senior Business Intelligence & ETL Developer
BNP Paribas Cardif
04.2016 - 08.2019
- Developed ETL workflows using Informatica to support data warehousing and analytics by integrating insurance and private pension data from two different core systems into a single data warehouse.
- Designed fact and dimension tables (star schema), optimizing data models for financial and insurance reporting.
- Designed a marketing data model leveraging client insights for personalized targeting, covering over a million clients.
- Created BI reports and dashboards using IBM Cognos to provide business insights.
Data Analyst
Koton
01.2015 - 04.2016
- Analyzed procurement data to support financial planning and currency risk management.
Business Analyst
Garanti Emeklilik
04.2012 - 05.2014
- Analyzed insurance data with millions of policies and customers to improve retention.
- Forecasted insurance renewals, contributing to premium optimization.
Education
Master of Arts - Marketing
Beykent University
Istanbul05.2014
Bachelor of Arts - Business Administration
Istanbul University
Istanbul05.2011
Skills
- ETL & Data Warehousing: ODI, Informatica, SQL, Oracle PL/SQL
- Cloud Database: Amazon Redshift, Google BigQuery
- Business Intelligence: IBM Cognos, Qlik Sense
- Programming & Scripting: Java, Shell Scripting
- Tools & Platforms: Jenkins, Git, Unix/Linux
Timeline
ETL Developer | Data Engineer
Brown Brothers Harriman
05.2021 - Current
Senior Business Intelligence Analyst
Vivid Games
08.2020 - 05.2021
Business Intelligence Consultant
Brown Brothers Harriman (Contractor Via Sii)
08.2019 - 08.2020
Senior Business Intelligence & ETL Developer
BNP Paribas Cardif
04.2016 - 08.2019
Data Analyst
Koton
01.2015 - 04.2016
Business Analyst
Garanti Emeklilik
04.2012 - 05.2014
Master of Arts - Marketing
Beykent University
Bachelor of Arts - Business Administration
Istanbul University
Additional Information
- Languages: English (C1), Polish (A1), Turkish (Native)
- Work Authorization: Eligible to work in Poland and in EU without a work permit (residency based on Polish spouse).
Similar Profiles
Jennah KellieJennah Kellie
Senior Client Management Representative at Brown Brothers HarrimanSenior Client Management Representative at Brown Brothers Harriman
Maksym NesterenkoMaksym Nesterenko
Junior Transfer Agency Trailer Fees Representative at Brown Brothers HarrimanJunior Transfer Agency Trailer Fees Representative at Brown Brothers Harriman
Lacy J. HeitmannLacy J. Heitmann
Ops Section Mgr I FT Comm, Assistant Vice President – Funds Transfer at Brown Brothers Harriman and Company (BBH)Ops Section Mgr I FT Comm, Assistant Vice President – Funds Transfer at Brown Brothers Harriman and Company (BBH)