Berk Urkmez

Designed and maintained the data architecture across 12+ source systems (Oracle, SQL Server, CRM, Finance, Operations). Developed optimized ETL pipelines in SQL and Python, ensuring data quality and consistency. Built executive-level dashboards in Power BI and MicroStrategy, enabling data-driven decisions. Performed statistical and customer behavior analyses to generate actionable insights. Integrated CRM Dynamics into the analytics ecosystem, supporting segmentation and performance tracking. Developed data-driven solutions that enhanced customer experience, optimized operational processes, and increased revenue opportunities across lounge access, Fast Track systems, loyalty programs, and CRM-integrated lead generation. Consolidated financial data into a unified ODS/DWH, enabling product-level profitability and EBITDA reporting. Delivered real-time case management dashboards, improving lounge issue resolution efficiency. Optimized workforce planning using hourly lounge and call-center data, reducing operational costs.

Developed and implemented end-to-end data analytics strategies, delivering dashboards and analytical reports via MicroStrategy for multiple product teams. Managed the full data lifecycle—from collection and cleansing to modeling and analysis—ensuring high data integrity and reliable insights. Performed statistical and exploratory analyses to identify trends, performance gaps, and opportunities supporting data-driven decision-making. Designed clear, compelling data visualizations to translate complex findings into actionable insights for stakeholders across the organization.

Managed a global energy consumption portfolio for 8 key clients across 1,100+ sites, ensuring accurate monitoring and performance oversight. Conducted advanced energy data analysis and visualization to identify consumption patterns, inefficiencies, and optimization opportunities. Delivered weekly and monthly B2B reports and insights to clients, supporting strategic decision-making and operational planning. Evaluated and enhanced internal processes and digital applications to improve workflow efficiency and data quality. Applied clustering and segmentation models to large-scale energy datasets, contributing to measurable cost savings and improved energy management strategies.

Project Title: Emerging Technologies and Sustainable Development Goals Project Supervisor: Dr. Sinan Kufeoglu, Oxford University As a Research Assistant and Sub-Team Leader, I manage a work package with a team of 7 research interns. Our focus is on two Sustainable Development Goals (SDGs): SDG 7: Ensure access to affordable, reliable, sustainable, and modern energy for all. SDG 13: Take urgent action to combat climate change and its impacts. For more information, please visit the book link: https://link.springer.com/book/10.1007/978-3-031-07127-0

Project Title: Digitalisation in the Energy Sector: Digital Solutions and New Business Models Project Supervisor: Dr. Sinan Kufeoglu, Oxford University In this role, I contributed to various aspects of energy generation and sustainable technologies, including: - Photovoltaic (PV) Installation - Small Wind Turbine Installation - Small-Scale Biomass Plants - Battery Technologies (Li-Ion and saltwater battery research) Our objective was to develop Turkey’s first fully smart, digitized, and self-sustaining compound: the Open Digital Innovation House. Additionally, our findings are featured in the book The Home of the Future, available on Springer: https://www.springer.com/gp/book/9783030750923

Performed comprehensive data analysis on Solar Power Plant (SPP) performance and measurement data to identify efficiency trends and operational issues. Designed and managed SPP layouts and feasibility studies using Helioscope, optimizing system configuration and energy output. Prepared in-depth reports on electricity market regulations in Turkey and international markets, providing actionable insights for compliance and strategic planning.

Led the active sales and distribution of Abax and Huawei inverters, expanding market reach and supporting product adoption. Collaborated with global partners through technical and commercial meetings, strengthening business relationships and driving joint sales initiatives.