Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

Aykut Cura

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Maple Drapery & Carpet
12.2020 - Current
  • Creating Power BI dashboards which are interactive, set up to evaluate sales performance according to product category, region and customer segment. This has helps the sales team identify opportunities for cross-selling and up selling hence increased the average order value.
  • Optimizing inventory management by using SQL queries that analyze historical sales data as well as forecast demand.
  • Conducting market research through excel pivot tables, functions on curtain materials and carpet industry to discover trends, gaps for product expansion.
  • Collaborating with cross-functional teams including sales, marketing, and operations to analyze customer feedback data and identify trends, leading to the development of targeted marketing campaigns and product improvements.

Data Analyst

RenasTech Academy
04.2022 - 01.2024
  • Implemented an automated ETL process Extract, Transform, Load using SQL and Excel macros to save data processing time, and prepared data streams for reporting those optimized reports data integration processes with no chance of data corruption.
  • Developed Power BI dashboards to track student enrollment trends, course completion percentages, and academic performance data to provide school administration with the actionable insights.
  • Implemented forecasting by using SQL based on a predictive modeling methodology to predict the number of students in the following semesters reduced course overbooking to 20%.


Junior Data Analyst

Document Direction Limited
09.2019 - 12.2020
  • Developed and implemented a predictive maintenance model for printers, resulting in a 20% time saving and a 15% decrease in maintenance costs.
  • Conducted comprehensive data analysis on customer repair requests to identify recurring issues and implemented targeted solutions, resulting in decrease of repeated repairs.
  • Created interactive dashboards and reports to provide real-time insights into inventory levels, enabling more accurate forecasting and reducing excess inventory.

Education

Associate of Science - Mechanical Engineering Technology

George Brown College
Toronto, ON
06.2019

Bachelor of Science - Naval Architecture And Marine Engineering

Yildiz Technical University
Istanbul, Turkey
06.2015

Skills

  • Data Visualization and Presentations
  • Excel Functions
  • Database Programming and SQL
  • Data Cleaning
  • Statistical Analysis
  • ETL processes
  • Project Management
  • Report Writing
  • Google Analytics
  • Documentation
  • KPI Tracking
  • Attention to Detail

Certification

  • Google Data Analytics Professional Certificate, Toronto, ON
  • NPower Canada - Junior IT Analyst Stream Certificate, Toronto, ON

Projects

  • Coffee House Sales Analysis, Led a successful project analyzing yearly sales data for a multi-location coffee house chain, integrating employee performance metrics to propose rewarding strategies for top performers. Employed SQL for data extraction and transformation, Excel for thorough data cleansing, and Power BI for intuitive visualization and dashboard creation for non-technical users. Identified key sales trends and performance metrics by using KPI methods, presenting actionable insights to stakeholders. Demonstrated strong analytical skills in interpreting complex datasets and communicating with each location's findings effectively to increase accuracy on the dataset. Contributed to enhancing business performance through informed decision-making and employee motivation strategies.
  • Maple Drapery Revenue Analysis, Successfully spearheaded a project analyzing sales data and managing vendor relationships, employing Power BI for visualization, complex SQL queries, and Excel formulas for ETL processes. Presented insightful monthly and quarterly sales reports to stakeholders, facilitating informed decision-making. Implemented cross-functional communication strategies to ensure data accuracy and collaborated closely with vendors to negotiate advantageous terms and prices for supply products. By leveraging advanced data analysis techniques and effective negotiation skills, I contributed to cost savings and operational efficiency.

Timeline

Data Analyst

RenasTech Academy
04.2022 - 01.2024

Data Analyst

Maple Drapery & Carpet
12.2020 - Current

Junior Data Analyst

Document Direction Limited
09.2019 - 12.2020

Associate of Science - Mechanical Engineering Technology

George Brown College

Bachelor of Science - Naval Architecture And Marine Engineering

Yildiz Technical University
Aykut Cura