Beyza Cinar
Summary
Accomplished Senior Business Intelligence and SQL Developer with over 7 years of experience in information technology, delivering data-driven solutions for global clients such as KPMG, Unilever, and Aytemiz. Proficient in SQL Server, Oracle, MySQL, and PostgreSQL databases, with extensive expertise in ETL processes, Azure Data Factory, and BI tools including PowerBI, Tableau, and IBM Cognos. Skilled in SSRS, AAS, SSIS, Python, and data modeling, with a strong track record of optimizing workflows and providing actionable insights to stakeholders.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Business Intelligence Developer
Victoria PLC
05.2024 - Current
- Develop SQL Server jobs, views, and procedures to enhance database performance.
- Create PostgreSQL and MySQL views and procedures to support diverse data needs.
- Design and implement ETL processes using SSIS and Azure Data Factory (ADF) pipelines for efficient data integration.
- Build Azure Functions to automate data workflows and improve operational efficiency.
- Manage data ingestion from multiple sources to first landing zone, staging, and Common Data Model (CDM) structures.
- Utilize Azure Analysis Services (AAS) to develop advanced analytical models.
- Contribute to data warehouse development for scalable and reliable storage solutions.
- Optimize SQL queries to ensure high system performance.
- Produce comprehensive PowerBI reports and dashboards to meet stakeholder demands.
- Collaborate on machine learning (ML) projects to enhance predictive analytics capabilities.
Senior SQL Developer
Trive
11.2022 - 05.2024
- Created PostgreSQL views and procedures for efficient data handling.
- Built MySQL views and procedures to support diverse reporting needs.
- Designed AWS PostgreSQL views and procedures, streamlining cloud-based operations.
- Engineered ETL processes using SSIS for seamless data integration.
- Contributed to data warehouse development, ensuring robust data storage solutions.
- Optimized SQL queries to boost performance across systems.
- Produced comprehensive reports to meet stakeholder requirements.
Business Intelligence Consultant
TCM Bilişim
11.2021 - 11.2022
- Developed SQL Server jobs, views, and procedures for reliable data processing.
- Created PL-SQL scripts in Oracle to support complex data workflows.
- Designed ETL processes with SSIS to facilitate efficient data movement.
- Built tabular models and MOLAP structures using SSAS for advanced analytics.
- Generated SSRS reports and PowerBI dashboards for actionable client insights.
- Managed staging environments to ensure data integrity.
- Contributed to data warehouse development for scalable solutions.
- Performed data modeling to align with business needs.
- Utilized Google Big Query for large-scale data analysis.
- Applied DAX for enhanced BI reporting capabilities.
- Optimized SQL queries to improve system efficiency.
Business Intelligence Developer/Senior Data Analyst
Turkish Red Crescent
04.2020 - 11.2021
- Developed PL-SQL scripts to streamline data operations.
- Created PowerBI dashboards and Tableau visualizations to support decision-making.
- Produced detailed reports to communicate key findings.
- Leveraged Python for data analysis and forecasting tasks.
- Utilized Excel for in-depth data exploration.
- Optimized SQL queries to enhance performance and accuracy.
Business Intelligence Specialist
Proda Bilişim
02.2018 - 04.2020
- Developed SQL Server jobs, views, and procedures for efficient data management.
- Generated SSRS reports to deliver actionable business insights.
- Built IBM Cognos reports to meet stakeholder expectations.
- Designed ETL processes to ensure smooth data flow.
- Optimized SQL queries to improve reporting speed and reliability.
Education
Bachelor of Science - Statistics
Ankara Universty
Turkey06-2015
Skills
- Databases Developer
- BI Tools
- ETL & Analytics
- Tabular Model
- C#
- LLAMA
- Cloud & Automation
Certification
- https://coursera.org/share/a88b24414cce2877658fc411919f21b2
- https://coursera.org/share/70d435be9677357d29997c31b42b1620
- https://coursera.org/share/128d0a6ec8daeab903216d32ce6b124e
References
Phil Sage - Transformation Director from Victoria PLC
phil.sage@victoriaplc.com
Ozan Sertkaya- Data Team Lead from Victoria PLC
ozan.sertkaya@victoriaplc.com
Esra Dakak - Senior Database Administrator from
Timeline
Senior Business Intelligence Developer
Victoria PLC
05.2024 - Current
Senior SQL Developer
Trive
11.2022 - 05.2024
Business Intelligence Consultant
TCM Bilişim
11.2021 - 11.2022
Business Intelligence Developer/Senior Data Analyst
Turkish Red Crescent
04.2020 - 11.2021
Business Intelligence Specialist
Proda Bilişim
02.2018 - 04.2020
Bachelor of Science - Statistics
Ankara Universty