Ozgur Akduran Email & Phone Number

New York, Ny, Us

Architected ETL infrastructure and CI/CD with monitoring, built data warehouses/lakes and pipelines, migrated data to Databricks and Snowflake, created views and dashboards to serve insights to stakeholders.• Architected Airflow infrastructure on kubernetes and created various DAGs for ETL purposes.• Created CI/CD using CircleCI for Airflow development.• Developed cloudformation scripts to have consistent architecture during kubernetes migrations.• Created Kinesis event streaming pipeline to gather KPIs on user behaviors, exported data to s3, migrated to Databricks, separated it to different layers via views, and built Tableau dashboards.• Created EMR jobs to run daily data migrations, collected Spark metrics on DataDog.• Designed a new data warehouse on Redshift and developed ETL jobs to load data. • Created external tables to run Athena queries to leverage NoETL approach as feeding data directly from s3.• Created logical replication slots on RDS and Kafka connectors to consume updated data on the database, migrated pipelines from Fivetran to a Kafka. Created a script for historical resyncing Kafka CDC pipelines.• Developed BE Java microservices and maintained deployments for separate environments on EKS.• Created cron jobs for testing micro service, deployed micro services on kubernetes pods, built VPC peering between clusters, set proper security group inbound access and developed services and new features.• Updated Kubernetes cluster version on EKS worker nodes, updated certs on service configmap.Automated alerting and Slack messaging on failures during Kafka connector and Airflow DAG operations.

New York, Us

• Setup Airflow workflow management system on a docker container• Build DAGs on Airflow to streamline ETL workflow• Created views on Snowflake, parsed json data

Basking Ridge, Nj, Us

• Developed ETL pipelines using SSIS/SSRS and AWS services like EC2, S3, Redshift• Created CI infrastructure via Jenkins jobs to provide AWS services using cloud formation scripts

New York, Ny, Us

• Migrated data warehouse from MySQL to Oracle database• Created new data marts using dimensional modelling techniques and implemented ETL processes using Pentaho• Scheduled ETL jobs over Linux server• Managed Tableau server, set up row-level security structure• Created visualizations and built dashboards

Parsippany, Nj, Us

• Analyzed data management and reporting life-cycle • Automated various roles like data extraction, pivot table/dashboard creation and sending reports to involving parties using VBA and Java coding.

İstanbul, Tr

• Created a new Data Warehouse (DWH) for Bank’s decision making needs• Achieved to build more than 100 financial reports in 6 months• Managed outsource employees, analysts and international vendor teams for various projects• Developed ETL packages and functions• Created customized Data Marts and OLAP cubes for operations, sales, marketing, human resources, risk management departments for budgeting, forecasting and financial reporting needs• Developed Basel II reporting according to the risk and capital management requirements of the bank

• Composed analysis, reports, scorecards, KPIs and dashboards for Telecom Companies• Performed core banking system analysis for DWH creation in financial sector

• Managed electronic counter-measures and electronic attacks that includes identifying radar-infrared-optical guided missiles, radar jamming, firing chaff/flares to deceive or eliminate potential threats.

• Designed and developed a new GUI template for the GENESIS (Combat Management System) project as a part of a team.

Istanbul, Tr

• On behalf of Turkish Navy, I was a grad student and later a researcher on the wireless sensor networks domain at Network Labs of computer engineering department.

• Head officer of the the frigate's electronics department between 2005-2006 (Rank: Lieutenant Junior Grade). • Managed 14 petty officers (20 to 36 years old) including payroll, training, performance management, work-flow assignment and attended multiple international/NATO related exercises.• Managed the maintenance and performance control of the Command&Control, Communication, Radar Surveillance, Missile&Torpedo Launching systems.• Managed the integration of X-Band satellite communication system during FAT, HAT and SAT phases.

• Managed the maintenance and performance control of all on-board communication devices.

Master Of Business Analytics And Project Management

M.S., Computer Engineering

B.S., Computer Engineering