My Portfolio Page

About

I worked as a Project Manager between 2014-2017. The skills I gained during this 3-year period are Designing and Implementing Systems, Assessing Resources to Meet Organizational Needs, Automating Tasks, Data Analysis, Crisis Management, Problem-solving, Adaptability, Collaboration, Time Management, and Multitasking.

Between 2017-2021 I became interested in the field of justice and got good grades in university exams and earned law school. Due to the coronavirus, I took a break from my education.

At the end of 2021, I decided to enter the field of information technologies, which I have been interested in since my childhood and where merit is at the forefront, where knowledge and skills find the value they deserve.

In November 2022, I graduated from the US-based bootcamp, which is a pioneer in the IT sector, as Data Scientist. The skills I gained during the course are Machine Learning, Deep Learning, Natural Language Processing, Data Analysis, Data Visualization, Statistical Analysis, Power BI, Python, SQL, Git/GitHub, HTML, CSS, Agile Methodology, Teamwork, Collaboration, Problem-solving, and Critical Thinking.

I am currently working as a Data Analyst at Vitabiotics and I am studying for a master's degree in Big Data and Business Analytics at Istanbul Technical University. I love reading books, doing sports, learning new things every day, seeing natural beauties, and helping people.

Data Analyst

Birthday: 8 Oct 1991
Linkedin: linkedin.com/in/firatolcum
GitHub: https://github.com/firatolcum
City: Istanbul,Turkey

Age: 33
Degree: Master's Degree
Email: firatolcum@gmail.com
Freelance: Not available

Skills

Machine Learning / Deep Learning

Python

SQL

Probability / Statistics

Power BI

Git / Github

Cloud Computing

Microsoft Excel

SDLC / DevOps

Agile / Jira

Resume

Sumary

Fırat Olçum

A certified Data Analyst and Project Manager with 4+ years of experience in IT,Strong track record of computational skills, data analysis, data manipulation, data visualization, predictive modeling, statistical analysis, machine learning, and business intelligence. Performed data extraction and analysis with Python libraries like BeautifulSoup, NumPy, Pandas, Scikit-Learn, SciPy, Matplotlib, Seaborn, and Plotly. Experienced in SQL, Database Modeling, Database Management System (DBMS), and Power BI. Able to translate results into understandable terms for the success of the organization and business decisions. Developed the Basic Performance Indicators to monitor the physical performance of the personnel and increased their performance by 41% in 2 months by analyzing their physical characteristics.
Click and download my resume.

Education

Master of Big Data & Business Analytics

2024 - Present

Istanbul Technical University, Istanbul

Acquired in-depth knowledge and hands-on experience in managing, analyzing, and interpreting large datasets to support strategic business decisions. Developed expertise in advanced analytics, data visualization, predictive modeling, and machine learning applications. Collaborated on projects involving real-world business challenges, utilizing tools like Python, SQL, and Power BI to deliver actionable insights.

Associate of Web Design & Coding

2020 - 2022

Anadolu University, Eskisehir

Gained proficiency in front-end technologies such as HTML and CSS. Completed hands-on projects, including coding websites from concept to deployment, ensuring cross-platform compatibility and accessibility.

Bachelor of Systems Engineering

2010 - 2014

National Defense University, Ankara

Focused on designing, analyzing, and optimizing complex systems across various domains, including technology, manufacturing, and operations. Gained a solid foundation in systems modeling, project management, and process optimization, with coursework in programming, systems design, and data analysis.

Professional Experience

Data Analyst

2024 - Present

Vitabiotics, Istanbul

Managing daily, weekly, and monthly sales and visit performance reports for a team of 20 sales personnel using SQL Server, Python, and Excel.
Calculating monthly bonus entitlements based on performance metrics and automated reporting processes using Power Query in Excel.
Streamlined data processing by optimizing SQL Server Integration Services(SSIS) workflows, resulting in a 40% reduction in data loading times.
Conducted data modeling and visualization in Power BI, enabling managers to monitor key performance indicators (KPIs) in real-time.

Data Analyst

2022 - 2024

Woongjin, Istanbul

Extracted, processed, and analyzed complex datasets using visualization, and analytics tools.
Collected and cleaned data with MS SQL Server using advanced queries and processed large datasets with Python.
Reduced company expenses by 21% as a result of the analyzes carried out.
Implemented a new CRM with reporting capabilities. Cut costs by 15% and improved efficiency.

Project Manager

2014 - 2017

The Ministry of National Defense, Ankara

Worked as a Project Manager between 2014 and 2017, at institutions affiliated with the Ministry of National Defense.
Developed the Basic Performance Indicators to monitor the physical performance of the personnel and increased their performance by 41% in 2 months by analyzing their physical characteristics.
The skills gained in this 3-year period are data analysis, leadership, crisis management, problem-solving, adaptability, collaboration, time management, and multitasking.

Services

Mining Data

Just as miners sift through soil and rock to find gold and other useful minerals, I can sort through the "mountains" of pure data in the hopes of uncovering useful information.

Cleaning Data

Not all data offers readily reliable information. Before I can conduct meaningful analysis, I need to clean your data. During this process, I strive to correct data marred by spelling or syntax errors, bring in information from a different or previous model, and correct duplicated or missing information.