Open to opportunities

Dilek Potur

@dilekpotur

Message

Senior Business Intelligence Specialist with extensive data analysis experience.

Turkey

Message

What I'm looking for

I am looking for a role that challenges me and fosters professional growth.

I am a Senior Business Intelligence Specialist with a robust background in data analysis and reporting. My journey in the field began with a degree in Statistics from Kırıkkale University, and I have since honed my skills through various roles in leading companies. My experience includes working on complex data warehousing projects and developing insightful reports that drive business decisions.

At DIGITALLENCY, I lead the development of reporting solutions for Garanti Bank's investment banking data, utilizing ETL processes and Oracle Analytics Server. My previous roles at SMARTMIND and QUARK PARTNERS involved optimizing reporting systems and creating data visualizations that enhanced operational efficiency. I am passionate about leveraging data to solve business challenges and improve processes.

Throughout my career, I have consistently delivered high-quality results and have been recognized for my ability to collaborate with cross-functional teams. I am eager to continue growing in a dynamic environment where I can contribute my expertise in business intelligence and data analytics.

Experience

Work history, roles, and key accomplishments

Current

Senior Business Intelligence Specialist

Current

Digitallency Danışmanlık A.Ş

Aug 2024 - Present (11 months)

Led the Garanti Bank, Investment Banking DWH and OAS reporting project, developing ETL processes for investment banking data from various sources. Modeled tables in RPD and developed OAS reports to meet project requirements.

ETL DWH OAS Reporting Data Modeling Reporting Investment Banking Data Integration

Current

Kıdemli İş Zekası Uzmanı

Current

Digitallency Danışmanlık A.Ş

Aug 2024 - Present (11 months)

ETL DWH OAS Reporting Data Modeling Investment Banking Data Warehousing Reporting

Senior Business Intelligence Specialist

Smartmind Danışmanlık A.Ş

May 2022 - Present (3 years 2 months)

Resolved systemic issues and developed new reports on OAS and DV for ODEABANK, including re-installing OAS due to lack of cluster structure. Performed ETL developments on ODI for HDI Sigorta, modeled DWH tables in RPD, and developed reports on OAS and Microstrategy. Optimized Oracle BI and Discoverer reports for TURKCELL, integrating with OAS and improving performance by disabling database views.

OAS Reporting Data Visualization ODI ETL DWH Microstrategy Performance Optimization

Kıdemli İş Zekası Uzmanı

Smartmind Danışmanlık A.Ş

May 2022 - Aug 2024 (2 years 3 months)

Resolved systemic issues and developed new reports for ODEABANK's OAS environments, including new report analysis and development on OAS and DV. Performed OAS reinstallation due to lack of cluster structure on existing servers. Developed DWH models and OAS/Microstrategy reports for HDI Sigorta, including ODI ETL developments and RPD modeling. Optimized Turkcell's OBIEE by integrating OAS, improvin

OAS Reporting Data Visualization ODI ETL DWH Microstrategy Performance Optimization Data Modeling Reporting

Senior Business Intelligence Specialist

Quark Partners

Aug 2021 - Present (3 years 11 months)

Collaborated with business units to create analysis documents and Oracle database models for Turk Telekom. Wrote queries for ETL and developed dashboards using Qlik Sense.

Oracle Qlik ETL Data Modeling Business Analysis SQL Dashboard Development

Kıdemli İş Zekası Uzmanı

Quark Partners

Aug 2021 - May 2022 (9 months)

Created analysis documents by consulting with business units based on project scales and developed Oracle database table models. Wrote queries for ETL units and created dashboards using Qlik Sense.

Oracle Qlik ETL Data Modeling Business Analysis SQL Dashboarding Data Warehousing

İş Zekası Uzmanı

Jforce Bilişim

Mar 2021 - Aug 2021 (5 months)

Worked on the Avivasa Cep Project, focusing on generating JSON data from Oracle database and optimizing daily data transfer performance with ETL (Datastage). Modeled Oracle database tables for the IBAR Project (Azerbaijan Bank) and prepared daily, weekly, and monthly Credit Utilization reports in Tableau. Ensured data cleansing for data science projects using Knime. Modeled and performed ETL (Data

Oracle JSON ETL DataStage Tableau KNIME Data Modeling Data Visualization Jira

Business Intelligence Specialist

Jforce Bilişim

Mar 2021 - Present (4 years 4 months)

Generated JSON data on Oracle database for Avivasa Cep Project, focusing on daily data transfer performance and ETL processes using Datastage. Modeled Oracle database tables for IBAR Project (Azerbaijan Bank) and prepared daily, weekly, and monthly Credit Utilization reports in Tableau. Ensured data cleansing for Knime workflows in a data science project. Modeled and performed ETL (Datastage) for

Oracle JSON ETL DataStage Tableau KNIME Data Modeling SQL

Business Intelligence Specialist

Birevim

Mar 2020 - Present (5 years 4 months)

Visualized daily, monthly, and yearly reports for Finance, Human Resources, and Management units using data marts created in MS SQL. Utilized Tableau and Qlik Sense for report visualization, meeting the needs of all relevant departments.

SQL Tableau Qlik Data Marts Financial Reporting

İş Zekası Uzmanı

Birevim

Mar 2020 - Mar 2021 (1 year)

Visualized daily, monthly, and yearly reports for Finance, Human Resources, and Management units using data marts created in MS SQL database. Utilized Tableau and Qlik Sense business intelligence tools to meet the reporting needs of all relevant departments.

SQL Tableau Qlik Data Marts Business Intelligence Financial Reporting Data Visualization

İş Zekası Uzmanı

Online Grup Teknoloji

Feb 2017 - Mar 2020 (3 years 1 month)

Prepared daily, monthly, and yearly reports for Finance, Call Center, and Management units using MS SQL database tables, embedding queries into Excel with Access and creating reports via Power Pivot. Visualized reports using data marts created on the database and presented them to all relevant departments.

SQL Access Excel Power Pivot Data Marts Reporting Data Visualization Financial Reporting

Business Intelligence Specialist

Online Grup Teknoloji

Feb 2017 - Present (8 years 5 months)

Prepared daily, monthly, and yearly reports for Finance, Call Center, and Management units using MS SQL tables, embedding queries in Excel with Access and creating reports via Power Pivot. Visualized reports using created data marts and presented them to all relevant departments.

SQL Access Excel Power Pivot Data Marts Financial Reporting

AÜ

Veri Analiz Uzmanı

Alke Sağlık Ürünleri

Nov 2015 - Feb 2017 (1 year 3 months)

Prepared sales and marketing reports from Alke web platform and MySQL database using Excel Power Pivot, Power Query, and Power BI. Performed statistical analysis of reports using SPSS and presented the outputs.

MySQL Power Query Power BI SPSS Statistical Analysis Sales Reporting Marketing Analytics Data Analysis

AÜ

Data Analysis Specialist

Alke Sağlık Ürünleri

Nov 2015 - Present (9 years 8 months)

Prepared sales and marketing reports from Alke web platform and MySQL database using Excel Power Pivot, Power Query, and Power BI. Conducted statistical analysis of reports with SPSS and presented the outputs.

MySQL Power Query Power BI SPSS Statistical Analysis Sales Reporting Marketing Analytics

Education

Degrees, certifications, and relevant coursework

KÜ

Kırıkkale Üniversitesi

Lisans, İstatistik

Activities and societies: Completed a graduation project on the statistical analysis of Kırıkkale University students' knowledge and attitudes about AIDS.

Studied Statistics at Kırıkkale University, Faculty of Arts and Sciences, from 2009 to 2013. Completed a graduation project on the statistical analysis of Kırıkkale University students' knowledge and attitudes about AIDS.

Bafra Kızılırmak Lisesi

High School Diploma

Attended Bafra Kızılırmak Lisesi in Samsun from 2005 to 2009.

Kırıkkale Üniversitesi Fen-Edebiyat Fakültesi

Lisans, İstatistik

Activities and societies: Completed a graduation project on the statistical analysis of Kırıkkale University students' knowledge and attitudes regarding AIDS.

Studied Statistics at Kırıkkale University, focusing on statistical analysis and data interpretation. Completed a graduation project on the statistical analysis of Kırıkkale University students' knowledge and attitudes regarding AIDS.