Mert Demirel

BI Tool Implementation: Developed 500+ MicroStrategy reports and interactive dashboards for 1000+ users by creating semantic layer elements such as Attributes, metrics, filters and then datasets. BI Project Management: Led cross-functional collaboration with various departments for requirements gathering, planning, execution, and delivery, ensuring projects meet business needs and deadlines. Data Science: Developed predictive and interactive reports such as customer behavior analysis and revenue projections using neural network models in Python (Scikit, TensorFlow, XGBoost, Streamlit) Data Warehouse Design: Created 1000+ logical and lookup tables, fact tables, and pipelines to populate data to be transformed into the semantic layer as attributes, and metrics. Database Migration: Managed migration from SAP BW to DBT with Snowflake at the pipeline and OLAP BI tool levels. ETL: Implemented data ingestion from multiple sources using Snowpipe, orchestrated pipelines with Airflow into Snowflake, and developed data models with dbt, including testing and participation in CI job implementation. Optimization: Performed SQL optimizations to maximize performance on both cloud and on-premise servers. Support for Analysts: Debugged errors and collaborated with analysts for their Self BI consumption.

Consulting mission - Led full lifecycle Business Intelligence projects in collaboration with cross-functional teams, using MicroStrategy and SAP HANA. - Designed and delivered 100+ interactive BI dashboards focused on pricing analysis to support supplier negotiation strategies for finance teams. - Executed BI engineering tasks ensuring accurate data flows from SAP BW/ECC to SAP HANA, validating data quality directly with business stakeholders.

Consulting mission - Designed and developed 300+ operational dashboards used daily by over 500 internal users across operations and support teams. - Spearheaded the migration of the core BI platform from QlikSense to MicroStrategy, ensuring business continuity and data integrity. - Engineered robust data pipelines for daily ingestion of 1M+ parcel records, enabling real-time data access through a cube caching system. - Created scalable datamarts and view tables in Dremio, integrating big data from Hadoop via Talend ETL workflows.

Consulting mission - Built and deployed customized dashboards for pharmaceutical R&D and commercial teams, enhancing data visibility and strategic planning. - Developed semantic layers and data models using MicroStrategy and Microsoft SQL Server, improving data governance and consistency. - Developed BI ipad apps, mobile apps and intranet interfaces

Consulting mission - Designed and developed a mobile BI application for store managers, enabling faster operational decision-making through real-time analysis of sales and key performance indicators. - Contributed to all phases of the project, from requirements gathering to delivery, collaborating with business (MOA) and technical project managers to ensure data reliability and strong user adoption.

- Preparation of detailed data analysis reportings for the East Asian market researches - Participation in data-driven decisions concerning the financial performance of the Renault Trafic series - Participation in the development of monthly forecast updates with data scientists - Development of partnerships and project implementation in regards to international trade policies - Consulting on the VTC market, carpooling, and autonomous vehicles for Marcel

- Monthly preparation of the P&L statements for startups that are in the incubation phase - Performance monitoring and analysis of each startup based on their KPIs for their Angel Investor Meetings - B2B and B2C business plan preparation for 12 startups - Market researches for each startup and their own industry

Project management of aircraft interior cabins and maintenance in accordance with Boeing standards