Ahmet Kuzucuoglu, Developer in Ankara, Turkey
Ahmet is available for hire
Hire Ahmet

Ahmet Kuzucuoglu

Verified Expert  in Engineering

Database Developer

Location
Ankara, Turkey
Toptal Member Since
July 20, 2021

Ahmet is a database and SQL developer and business intelligence expert with more than eight years of experience. He excels at data modeling, analytics, and reporting. Ahmet is also a domain expert in supply chain and production environments as well as eCommerce, backed by degrees in industrial engineering and information systems. He enjoys working with Agile and Waterfall methodologies.

Data AnalysisData AnalyticsSQLPL/SQLOracleOracle PL/SQLTableauBusiness Intelligence (BI)Data VisualizationOracle FormsETLPythonAgileMicrosoft Power BIData ModelingOracle PrimaveraOracle OBIEEOracle Workflow

Portfolio

PepsiCo Global - Main
SQL, Tableau, Data Build Tool (dbt), Python 3, APIs, Snowflake...
Roketsan
Databases, Business Intelligence (BI), Agile, Web Services, Oracle Forms...
Roketsan
SQL, PL/SQL, Oracle Forms, Oracle Workflow...

Experience

SQL - 8 yearsTableau - 6 yearsBusiness Intelligence (BI) - 6 yearsData Visualization - 5 yearsPython - 4 yearsPostgreSQL - 3 yearsData Build Tool (dbt) - 2 yearsSnowflake - 2 years

Availability

Part-time

Preferred Environment

Tableau, PostgreSQL, APIs, Business Intelligence (BI), Snowflake, Databases, Oracle, Data Build Tool (dbt), GitHub

The most amazing...

...app I built is a 2-way, database-level web service integration software using PL/SQL and APIs to connect two apps and save $1 million by replacing 3P software.

Work Experience

Data Engineer (Tableau)

2021 - PRESENT
PepsiCo Global - Main
  • Designed and developed multiple dashboards for PepsiCo's leadership team to help KPI-tracking and comparing metrics (i.e. sales share, oos, marketing metrics, and more) across customers using Tableau and SQL.
  • Created, validated, and maintained ETL pipelines and data models to comply with requirements for ongoing cloud migration process using Amazon S3, dbt, and Snowflake.
  • Designed and developed multiple operational dashboards (fill rate, sales, share, oos, and more) for business partners enabling data-driven decision-making and performance-tracking in a convenient way.
  • Conducted ad-hoc data analysis using Python and APIs to discover data from 3rd party providers and defined appropriate KPIs and metrics so that new data sources could be enabled.
  • Created internal dashboards (eg., product mapping) and alerts to compare data sources against a source of truth, surfacing and resolving underlying modeling issues using Tableau, SQL, Snowflake, and Monte Carlo.
  • Resolved anticipated bugs in existing dashboards as well as upgraded them with outstanding enhancements reported in Jira boards. Implemented a standard dashboard template so that UX is enhanced.
  • Implemented standardized documentation for the existing model and dashboard portfolio that consists of explaining data sources, fields, filters, calculations as well as specific quirks so that the hand-off process is smooth.
Technologies: SQL, Tableau, Data Build Tool (dbt), Python 3, APIs, Snowflake, Amazon S3 (AWS S3), Python, Unix Shell Scripting, JSON, AWS Cloud Architecture

Enterprise Data Applications Lead

2017 - 2021
Roketsan
  • Designed and implemented data models and workflows for new enterprise applications in order to digitalize supply chain business processes requiring collaboration and communication with hundreds of suppliers and the company.
  • Developed data pipelines and ETL applications for the company data warehouse and data visualization solutions for mid-level managers to monitor the production environment with real-time data.
  • Took part in positioning Tableau within the corporate information system: democratized data by making it accessible to 300+ end users in a standardized and reliable fashion and created countless fancy dashboards to popularize the product.
  • Developed a web service client application, implemented directly on Oracle Database, to integrate a third-party project management app with the corporate ERP, saving at least $1 million in licensing costs per year.
Technologies: Databases, Business Intelligence (BI), Agile, Web Services, Oracle Forms, Tableau, PL/SQL, SQL, Dashboards, Oracle Database, ETL, Data Modeling, Data Pipelines, Data Warehouse Design, Data Visualization, Oracle, Python, Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, JSON, XML

ERP Application Developer and Analyst

2013 - 2017
Roketsan
  • Gathered and analyzed customer requirements and built customized applications (data entry forms, workflows, reports, and dashboards) within Oracle frameworks, including SQL, PL/SQL, Forms, Workflow, Discoverer, and OBIEE.
  • Maintained standard Oracle EBS R12 modules related to supply chain, including INV, PO, WIP, BOM, and ASCP. Fixed bugs and developed customizations, personalization, and extensions.
  • Replaced standard modules with custom applications by using available APIs, thus avoiding substantial licensing costs and delivering user-friendly applications.
Technologies: SQL, PL/SQL, Oracle Forms, Oracle Workflow, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Data Integrator (ODI), Repository Management, Oracle, Dashboards, APIs, Oracle Database, Python, Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, JSON, XML, Oracle Primavera

Web Service Application for Integrating Oracle EBS with Oracle Primavera

A two-way client application on Oracle Enterprise Database with PL/SQL and Web Services for 35+ endpoints hosted on Primavera Database. I developed this application, which included designing and implementing the data model and data pipeline with incremental and full refresh options. The application saved approximately $1 million per year by avoiding outsourced software.

Replacing Outsourced Applications of Oracle MES Module with In-house MES Applications

In-house data entry web applications to be used by blue-collar technicians and reports to replace outsourced applications that were not easy to use, not applicable, or obsolete. While working in a Scrum team to develop these applications, I designed the data model and data flow and integrated it with other manufacturing modules in terms of business rules and data integrity. The application saved annual licensing costs of $500,000 and achieved an ROI in just six months!

Implementation of Tableau Server

Played a pivotal role in positioning and promoting Tableau within a corporate information system.

Key Activities
• Democratized data by making it accessible to 300+ end users and content creators in a standardized and reliable fashion.
• Monitored and managed the background jobs as a server administrator.
• Provided security for the created content in terms of required business rules.
• Created countless fancy dashboards with sophisticated reports to popularize the product within the company.
• Organized hands-on workshops to train new functional users as content developers within the company.

Languages

SQL, Python, Python 3, XML, Snowflake

Tools

Tableau, Oracle Forms, Microsoft Power BI, Looker, Tableau Desktop Pro, Spyder, Oracle Workflow, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Tabcmd, GitHub

Paradigms

Business Intelligence (BI), Agile, ETL, Data Science, Scrum

Platforms

Oracle Database, Oracle, Windows, Oracle Data Integrator (ODI), Linux

Storage

PL/SQL, Oracle PL/SQL, Databases, PostgreSQL, JSON, XML Publisher, Data Pipelines, Amazon S3 (AWS S3)

Other

Tableau Server, Data Modeling, Data Analytics, Data Analysis, Web Services, Data Visualization, PL/SQL Tuning, Linear Optimization, Scheduling, Data Mining, Software Engineering, Social Network Analysis, Big Data, Operations Research, Optimization, Statistics, Management Information Systems (MIS), LookML, Oracle Application R12 EBS, APIs, Back-end Development, SOAP, Dashboards, Data Warehouse Design, Data Flows, Data Build Tool (dbt), Repository Management, Unix Shell Scripting, AWS Cloud Architecture, Oracle Primavera

Frameworks

Spark

2014 - 2018

Master's Degree in Information Systems

Middle East Technical University - Ankara, Turkey

2008 - 2013

Bachelor's Degree in Industrial Engineering

Middle East Technical University - Ankara, Turkey

MAY 2023 - PRESENT

The Complete dbt (Data Build Tool) Bootcamp

Udemy

FEBRUARY 2021 - PRESENT

Mastering LookML: Looker's Modeling Language

Udemy

OCTOBER 2020 - PRESENT

Tableau Desktop Specialist

Tableau

OCTOBER 2015 - PRESENT

Internationally Certified Agile and Scrum

Scrum Inc.

OCTOBER 2014 - PRESENT

Oracle SQL Tuning for Developers (Workshop)

Oracle

OCTOBER 2013 - PRESENT

Oracle Database: SQL and PL/SQL Fundamentals

Oracle

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring