Learn Data Skills
Beta
Oğuz Özcan

Oğuz Özcan

Data Analyst

ING Hubs PL | Katowice

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

Insights curator, unlocking the power of data for strategic advantage.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

ING Hubs Poland | Aug 2024 - Present

Cyber Security Analyst

Analyze security logs in SIEM environments using Elasticsearch and Microsoft Sentinel, improving real-time threat detection and system performance monitoring. Develop and optimize Cassandra databases using CQL (Cassandra Query Language) for scalable and high-performance data storage. Manage IAM (Identity and Access Management) and access control policies, ensuring secure authentication and authorization for enterprise clients. Automate security reporting by developing custom RaaS (Reporting as a Service) solutions, leveraging Python and SQL for data-driven decision-making. Build ETL pipelines using Scala and Apache Spark, integrating real-time data ingestion and processing to enhance global security operations.
Show More

ING Hubs Poland | Nov 2023 - Aug 2024

Data Security Analyst

Monitored logs in Microsoft Sentinel SIEM to detect and prevent data leakage and security threats. Conducted security log analysis and threat investigation in a SIEM environment using KQL (Kusto Query Language) to identify anomalies. Automated security monitoring workflows in Microsoft Sentinel, improving incident detection and response efficiency.

freelance | May 2023 - Nov 2023

Social Media Analyst

- Analyzed YouTube channel data, resulting in achieving over 1.2 million public Shortsviews. - Successfully reached a milestone of over 1500 subscribers through strategic content andengagement efforts. - Analyzed TikTok channel data, leading to a remarkable growth of 83.4K followers and 1.7million likes.

freelance | Feb 2023 - Apr 2023

Database Developer

-Proficiently utilized SQL to perform table alterations, updates, and complex queries,contributing to data manipulation and management. -Employed SQL queries to extract data, generate graphs, and produce insightful metrics fordata visualization and analysis purposes. -Designed and implemented Azure ETL pipelines, incorporating parquet and columnarstorage techniques to enhance data processing efficiency and optimize storage.

freelance | Oct 2022 - Jan 2023

Ecommerce Analyst

-Analyzed 1.5 years of E-Commerce sales data, identifying trends and creating visual dashboards. -Utilized Excel queries and pivot tables for comprehensive data analysis and monthly trend visualization over 1.5 years. -Created interactive Tableau dashboards to visualize sales performance metrics and support cross-functional collaboration.

My Education

Take a look at my formal education

Master of Engineering - MEng, Power Engineering  · (February 2022 - JulyWroclaw University of Science and Technology | 2023
Bachelor of Engineering - BE, Mechanical Engineering  · (March 2017 - JuneFMV Işık Üniversitesi | 2021
High School Diploma FMV Işık Okulları | 2017

About Me

Oğuz Özcan

Oğuz hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free