About
I am a certified Data & Business Intelligence Analyst with 7+ years of experience in the IT sector. My core focus is on designing end-to-end Business Intelligence solutions and acting as an internal consultant to bridge the gap between business requirements and technical data strategies.
Currently, at Mega Metal, I lead the development of scalable DataMarts and complex reporting architectures, leveraging Microsoft Fabric, MS SQL Server, and extensive data extraction from SAP S/4HANA. My previous roles at Vitabiotics and Woongjin involved automating data pipelines using Python and SQL, creating advanced DAX measures, and delivering data-driven insights that significantly optimized workflows and reduced organizational costs.
I built my foundational problem-solving skills with a Bachelor's degree in Systems Engineering and am currently pursuing an MSc in Big Data and Business Analytics at Istanbul Technical University. To ensure I bring the highest standards to my architecture designs, I have also earned Microsoft certifications as a Fabric Analytics Engineer and Power BI Data Analyst.
Data & BI Analyst
- Linkedin: linkedin.com/in/firatolcum
- GitHub: https://github.com/firatolcum
- Medium: https://medium.com/@firatolcum
- Email: firatolcum@gmail.com
- Degree: MSc, Big Data & Business Analytics
- University: Istanbul Technical University
- City: Istanbul,Turkey
- Experience: 7+ Years
Skills
Resume
Summary
Fırat Olçum
A certified Data & Business Intelligence Analyst with 7+ years specializing in Power BI and end-to-end Business Intelligence solutions. Proven ability to act as an internal consultant, partnering directly with business units to challenge requirements, guide data strategies, and deliver strategic insights. Highly skilled in navigating SAP GUIto identify core tables, extracting complex datasets, and building scalable DataMarts using SQL Server and Microsoft Fabric. Able to translate results into understandable terms for the success of the organization and business decisions. Adept at transforming business needs into reporting architectures that drive organizational growth. 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.
Bachelor of Systems Engineering
2010 - 2014
Ankara 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.
Current Role & Contributions
Data & Business Intelligence Analyst
2025 - Present
Mega Metal, Istanbul
- Acted as the primary point of contact for business units, proactively questioning reporting requests, guiding end-users, and consulting on optimal data solutions.
- Engineered a multi-level Profitability Report leveraging SAP KE24N extracts, providing flexible slice-and-dice margin analysis by customer, product, product group, and order number, while precisely mapping parallel production costs.
- Navigated SAP GUI to identify and extract core system tables (e.g., VBAK, VBAP), successfully architecting a comprehensive Sales DataMart and Order Premium Report.
- Developed an end-to-end Delivery Performance Report by integrating S/4HANA inventory and goods issue tables (MATDOC) with sales data, providing logistics and sales teams with actionable insights into delivery SLA adherence and lead times.
- Architected an end-to-end Procurement Lifecycle Report in Power BI, integrating diverse SAP tables (e.g., EBAN, EKPO, and RSEG) to provide comprehensive visibility into the entire procurement lifecycle, from initial requisitions and orders to goods receipts and invoices.
- Developed supplier performance and quality scoring systems in Power BI using custom, complex DAX metrics.
- Leveraged Microsoft Fabric and Power Query to clean, transform, and orchestrate complex datasets, ensuring scalable BI architectures.
- Implemented a comprehensive Power BI Audit Report to track tenant-wide metrics, including user interactions, refresh schedules, and permissions, optimizing overall BI administration.
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.
Locating Trends and Patterns in Datasets
Once I mine and clean information, I use it to identify potentially useful consumer trends and patterns.
Generating Data Reports
Clear and accurate data reporting is an essential part of the data science profession. Data reporting can identify critical questions and pinpoint important items of concern.
Visualizing Data
I can make interactive dashboards using PowerBI and Tableau so that you can better understand the data.
Creating or Maintaining Databases
I have an understanding of the principles that underlie database management. I am able to understand the information I receive, identify issues and problems, and make previously unnoted connections.
Contact
Location:
Acibadem, Kadikoy, Istanbul
Email:
firatolcum@gmail.com
Call:
Please use the message option on the right.