Kemal Güçhan Kar, Developer in Brussels, Belgium
Kemal is available for hire
Hire Kemal

Kemal Güçhan Kar

Verified Expert  in Engineering

Data Analyst and Developer

Location
Brussels, Belgium
Toptal Member Since
December 8, 2021

Kemal is a data analyst and BI developer with close to five years of experience. His SQL skills and experience with Looker are exceptional, and he has done end-to-end data analysis, including production and storage of raw data, ETL processes, storage of analytics, and data-based storytelling using several BI tools. He has also worked on data engineering within AWS. Kemal's database development experience is backed by a bachelor's degree in industrial engineering.

Data AnalysisData VisualizationData AnalyticsSQLPL/SQLBusiness Intelligence (BI)Relational DatabasesMicrosoft ExcelOracle PL/SQLToadOracle WorkflowData EngineeringData WarehousingData Warehouse DesignAmazon RDS

Portfolio

The Estee Lauder Companies Inc. - Main
Looker, Business Intelligence (BI), SQL, ETL, Data Pipelines, Google BigQuery...
Teamleader
Looker, SQL, PL/SQL, Redshift, Fivetran, Stitch Data, Jira, Agile...
Roketsan
Oracle EBS, SQL, Oracle PL/SQL, Tableau, Toad, Data Analysis, Oracle Forms...

Experience

Data Engineering - 4 yearsSQL - 4 yearsData Analysis - 4 yearsLooker - 3 yearsTableau - 3 yearsOracle PL/SQL - 3 yearsETL Tools - 2 yearsSegment.io - 2 years

Availability

Part-time

Preferred Environment

Looker, Tableau, SQL, PL/SQL, Redshift, Amazon Web Services (AWS), Product Analytics, Amplitude, ETL Tools, Fivetran

The most amazing...

...thing I developed was a data model attributing upsells (of a CRM tool) to product features based on usage, giving valuable insights on the role of features.

Work Experience

BI Data Developer

2022 - PRESENT
The Estee Lauder Companies Inc. - Main
  • Developed a data model to attribute revenue to virtual selling areas and created a dashboard that enables business users to make data-driven decisions.
  • Recreated old custom dashboards for eCommerce sales in Looker.
  • Created a very flexible data model for the calendar in LookML, which the company plans to use in its other projects as well.
Technologies: Looker, Business Intelligence (BI), SQL, ETL, Data Pipelines, Google BigQuery, Google Analytics, LivePerson, Appointment Booking, eCommerce, BigQuery

Product Data Analyst

2020 - PRESENT
Teamleader
  • Developed a complex data model in Looker to understand the ROI for product features and created dashboards based on the model. The product had 11,000+ customers and 50,000+ users.
  • Administrated a data analytics cluster, ETL tools (Fivetran and Stitch), Looker, Segment, and Amplitude.
  • Built custom ETLs between Amazon S3 and Redshift to copy and load data and developed scheduled procedures with PL/SQL.
  • Ran Python scripts in Redshift to transform the data for use in Looker.
  • Tracked 10+ new product releases, how the products were adopted by users, and their ROIs via Looker and Amplitude.
  • Created 5+ A/B tests to help product managers and teams make decisions on new releases via Looker and Amplitude.
  • Migrated from Amazon Redshift to Snowflake after comparing two warehouses in terms of cost and performance.
Technologies: Looker, SQL, PL/SQL, Redshift, Fivetran, Stitch Data, Jira, Agile, Amazon S3 (AWS S3), Amazon RDS, Data Modeling, Dashboards, ETL Tools, Segment, Amplitude, Amazon Web Services (AWS), Python, A/B Testing, Data Analytics, Business Intelligence (BI), Data Analysis, Attribution Modeling, Data Visualization, Relational Databases, APIs, ETL, Microsoft Excel, Data Engineering, Snowflake, Data Warehousing, Data Warehouse Design, Query Optimization

SQL Developer | Data Analyst

2017 - 2020
Roketsan
  • Developed data models for several custom Oracle EBS applications.
  • Built custom Oracle EBS applications with PL/SQL and Oracle Forms; for example, an application for tracking order shipments.
  • Developed a generic workflow with Oracle Workflow, which helped people build custom workflows in one-tenth of the time they were spending.
  • Wrote web services and PL/SQL to assist in integrating Primavera projects with Oracle EBS.
  • Developed several dashboards with Tableau based on PO and PA module data in Oracle.
Technologies: Oracle EBS, SQL, Oracle PL/SQL, Tableau, Toad, Data Analysis, Oracle Forms, Oracle Workflow, Data Analytics, Data Modeling, Business Intelligence (BI), Oracle Primavera, Dashboards, Oracle, Data Visualization, Relational Databases, ETL, User Experience (UX), Microsoft Excel, Data Engineering, Data Warehousing, Data Warehouse Design, Query Optimization

Upsell Attribution to Product Features

Customers of a CRM company with more than 11,000 customers and 50,000 users upgrade to higher packages around 100 to 150 times per month. I developed a data model and dashboards that assist the company in attributing these upgrades and the gained revenue from these upgrades to product features based on usage after the upgrades. This provided valuable insights on whether the investments in the features were worth it. The client has highly appreciated this project and commented that the CRM company was among the first to provide this kind of analysis.

User Sessions in a Web Application

A data model I created to help the CRM company understand what users' sessions look like based on in-app events that are triggered when a user takes an action. Grouping these events based on their time helped us understand the first and last things users are doing in their sessions, how long sessions last, and a lot of other metrics that provide insights on the user experience.

Virtual Selling Areas' Performance

A data model that helps compare different virtual selling areas such as online appointments, live videos, chat agents, and much more. This data model helps business users calculate return on investment (ROI) by seeing how these virtual selling areas affect average order value (AOV), revenue, new users, retention, and a couple more business metrics.

Languages

SQL, Snowflake, Python

Libraries/APIs

Segment.io

Tools

Looker, Toad, Oracle Workflow, Microsoft Excel, Tableau, Oracle Forms, Stitch Data, Jira, Google Analytics, BigQuery

Paradigms

Business Intelligence (BI), Agile, ETL

Storage

Oracle PL/SQL, PL/SQL, Relational Databases, Amazon S3 (AWS S3), Redshift, Data Pipelines

Other

Fivetran, Product Analytics, Data Analysis, Amplitude, Data Modeling, Dashboards, Segment, Data Analytics, Data Visualization, Amazon RDS, ETL Tools, Statistics, Oracle EBS, A/B Testing, Attribution Modeling, APIs, Data Engineering, Data Warehousing, Data Warehouse Design, Query Optimization, Oracle Primavera, User Experience (UX), Google BigQuery, LivePerson, Appointment Booking, eCommerce

Platforms

Oracle, Amazon Web Services (AWS)

2012 - 2017

Bachelor's Degree in Industrial Engineering

Middle East Technical University - Ankara, Turkey