Ceyhun Ergün

SAP BW & HANA Projects:

• Lead and participate in SAP BW on HANA-based projects, leveraging advanced data models to meet business reporting needs.
• Perform data modeling tasks using SAP BW tools, including Composite Providers and Multi Providers.
• Design and implement HANA-based data flows, ensuring scalability and optimized performance for large datasets.
• Develop custom reports and dashboards using SAP BO (Business Objects) to meet business requirements.

Web Service Development:

• Write and maintain ABAP classes for web services, focusing on performance optimization and seamless integration with SAP systems via SPROXY.
• Ensure efficient real-time data exchange between SAP systems and external systems, contributing to system automation and performance improvements.

System Integration & Optimization:

• Collaborate with cross-functional teams to ensure successful system integrations and smooth data flow between SAP modules (BW, HANA).
• Optimize data processing pipelines, improving system performance, query times, and data reliability.
• Perform root-cause analysis for performance bottlenecks and implement solutions to enhance system efficiency.

Business Intelligence Solutions:

• Contribute to the development and refinement of business intelligence solutions, using SAP BW, BO, and HANA, ensuring accurate, timely, and insightful reporting.
• Continuously monitor business intelligence systems, analyzing data integrity and resolving any inconsistencies to maintain high-quality reporting.

Cross-Departmental Collaboration:

• Work closely with business stakeholders to ensure technical solutions meet evolving business requirements, with a focus on flexibility and scalability.
• Provide technical leadership in SAP BW, BO, and HANA, guiding team members through project tasks and ensuring adherence to best practices.

Support for Business Continuity:

• Support the ongoing development of the company’s SAP landscape, providing technical solutions for evolving business needs and ensuring system uptime.
• Address business continuity needs through the design and implementation of robust and scalable solutions.

• Team Leadership: Managed the Data Engineering team, including both SAS BI and SAP BI teams, ensuring optimal performance and alignment with business objectives.
• Strategic Planning & Execution: Led the strategic planning and execution of data engineering initiatives, aligning them with company objectives and driving business value through data solutions.
• Data Platform Management: Managed key data platforms, including SAP BW on HANA / SAP BW4HANA, SAP HANA, SAP Business Objects, Qlik Sense, PowerBI, SAS 9.4, and Apache Airflow, ensuring optimal performance, scalability, and integration.
• Data Architecture & Pipeline Optimization: Led the design and development of scalable, high-performance data architectures for large-scale systems, optimizing data pipelines for efficiency and reduced latency.
• Business Requirements Analysis: Analyzed business data requirements and designed robust, scalable solutions to meet current and future needs.
• Business Intelligence Contribution: Contributed to business intelligence and analytics processes, providing actionable insights to support strategic decision-making.
• Data-Driven Culture: Promoted a data-driven decision-making culture, encouraging best practices in data usage, analytics, and reporting.
• Regulatory Compliance: Ensured compliance with data regulations (GDPR, CCPA, KVKK, etc.) to meet legal and organizational requirements.
• Cross-functional Collaboration: Collaborated with stakeholders (business, developers, analysts) to align technical solutions with business goals.
• Data Roadmap & Architecture: Developed and presented data roadmaps and architectural recommendations to guide scalability, system improvements, and business growth.
• Data Integration Projects: Managed complex data integration projects, ensuring smooth data flow between systems, business units, and external partners.
• Data Platform Migrations: Successfully managed data platform migrations: SAP BW on HANA → BW/4HANA, Qlik Sense → Power BI, SAS 9.4 → SAS Viya.
• Project Management: Ensured project delivery on time, within scope, and on budget, while maintaining high data integrity, performance, and alignment with business goals.
• Monitoring & Optimization: Implemented monitoring systems to track data platform performance, proactively resolving issues to improve system efficiency.
• Crisis Management: Led crisis resolution efforts for critical data system failures, minimizing operational disruption and ensuring continuity.
• Team Mentoring: Provided technical guidance and mentorship to team members, improving team performance and fostering continuous learning.
• Collaboration with Data Science: Worked closely with Data Science teams to build and maintain data pipelines for advanced analytics, machine learning, and AI projects.
• Risk Management: Implemented strategies to address risks related to timelines, budgets, and technical issues, ensuring smooth project execution.

• SAS Optimization Project: Led the optimization of SAS data pipelines and jobs to enhance system performance.
• Job Migration to Apache Airflow: Migrated jobs to Apache Airflow, improving automation and scheduling.
• Performance & Code Optimization: Improved extraction performance and developed a Code Optimization Tool to streamline workflows.
• System Stability Improvements: Worked on system stability improvements to ensure uninterrupted operations across SAS platforms.
• Environment Manager Tool: Led the development of an Environment Manager Tool to optimize data environment configurations.
• Storage & Availability Optimizations: Focused on disk usage and SAS availability optimizations to improve system reliability and reduce costs.
• Data Exploration: Performed data exploration to identify optimization opportunities and provide insights for better decision-making.

• Master Plan Projects: Managed and delivered Master Plan Projects and Support initiatives, ensuring successful project completion.
• Real-Time Dashboards: Led the development of Near Real-Time Financial, Operational, CRM, and Sales Dashboards to provide actionable business insights.
• Customer Satisfaction & Sales Reports: Delivered Near Real-Time Customer Satisfaction Scores and Sales Reports to empower decision-makers.
• SAP BW and HANA Upgrades: Managed the upgrade of BW 7.4 on HANA to BW/4HANA, ensuring a seamless transition.
• HANA & BO Upgrades: Oversaw the HANA 1.2 to 2.0 upgrade and the BO 4.1 to 4.2 upgrade projects, improving performance and security.

Technologies: SAP BW on HANA, SAP HANA, SAP BO, ABAP, SQL, SAP Landscape Transformation (SLT), HANA XS Jobs, Lumira Designer .

Data Availability & Reliability:
Ensured the reliability and availability of data in SAP BI systems, enabling seamless data access for business-critical operations. Optimized data flow and data models, improving system performance, query times, and data accuracy post-migration.

Team Efficiency Improvement:
Streamlined development processes to improve team efficiency, enabling faster delivery of customer-tailored solutions.

Data Migration Leadership:
Led the migration of over 50 billion data records and successfully managed the redesign of data models during the unbundling project at EnerjiSA. Ensured data integrity, system scalability, and alignment with evolving business requirements. Provided leadership to ensure that migration processes adhered to industry standards, minimizing data loss and downtime.

Architectural Model Design:
Collaborated with cross-functional teams to define and implement new architectural models, aligning them with business processes while ensuring system flexibility for future growth. Delivered end-to-end SAP Business Warehouse (BW) structures, including:

• Activating standard data sources and, when necessary, developing user exits or new BADI structures using ABAP programming language.
• Generating data sources with programs or function modules.
• Generating SAP Landscape Transformation (SLT) data sources for BW databases.
• Creating transformation rules and routines for data flow between data sources and DSOs (targets).
• Data modeling using composite providers and multi-providers.
• Setting up process chains to automate data flow.
• Designing reports for end users using BEx Analyzer.

Stakeholder Collaboration:
Worked closely with stakeholders to ensure technical solutions addressed customer needs, focusing on flexibility, scalability, and performance.

Migration Process Leadership:
Led the design and development of SAP HANA structures for real-time reporting, including:

• Designing graphical views and SQL script views on HANA Studio.
• Developing SQL Stored Procedures and functions.
• Setting up HANA XS Jobs.

System Optimization:
Optimized data flow and data models, leading to improved system performance, faster query times, and enhanced data accuracy post-migration.

Cross-Functional Problem-Solving:
Facilitated technical problem-solving across teams, identifying issues and implementing solutions to meet customer needs and improve operational efficiency.

Integration of New and Existing Models:
Ensured seamless integration of new and existing data models, accommodating changes during the unbundling process without compromising on system performance or data reliability.

Support for Business Intelligence:
Supported business intelligence initiatives by delivering reliable, scalable, and secure data architectures, enabling data-driven decision-making across the organization.

Best Practices for Data Migration:
Championed the adoption of best practices for data migration and architecture redesign, ensuring sustainability and long-term success of the solution.

Strategic Planning:
Contributed to the strategic planning and execution of future data architecture projects, providing insights that align technology investments with business objectives.

Key Project :

Enerjisa Retail-Distribution Companies System Unbundling Project at Enerjisa, 06/2014 – 11/2016:

• Led the re-design of all data models for sales and distribution companies with the SAP BI team.
• Transformed all data from legacy SAP BW to retail and distribution companies’ SAP BW systems.
• Managed the work of the team as a team leader, providing technical leadership in projects and fostering an atmosphere of increased team interaction through information sharing.
• Performed system monitoring, optimizing performance, analyzing system trace logs, and developing programs for alert mechanisms, housekeeping, and partitioning BW tables.
• Researched new technologies and methodologies and simulated developments to improve system performance and capabilities.
• Provided ongoing support for the changing and dynamic business needs of the company.

• Worked extensively on SAP BW on HANA to optimize and manage ETL processes, ensuring seamless data integration and improved reporting efficiency.
• Designed and developed BEx Queries for the FI-CA and Legal modules, enabling streamlined data access and reporting for business users.
• Enhanced the BW team's ABAP skills, providing guidance and mentoring to improve their proficiency in developing ABAP-based solutions within the SAP BW environment.
• Redesigned and optimized process chains, ABAP codes, and data models to improve system performance, ensuring faster and more efficient data processing.
• Collaborated closely with the Basis team to implement system optimizations, ensuring the smooth operation of the SAP BW on HANA platform and its integration with other business systems.
• Led the BW team and maintained close communication with business units to ensure that data solutions aligned with business requirements and provided value to stakeholders.
• Implemented SLT (SAP Landscape Transformation) for near real-time reporting, working alongside the Basis team to enable data synchronization and reporting with BusinessObjects (BO).
• Coordinated with business units to understand data needs and ensure that SAP BW solutions were developed and refined to support business intelligence and analytics goals.

• Started as an ABAP Developer, focusing on data governance for the INCI project, which involved the migration from a legacy system to SAP IS-U, ensuring smooth data transfer and system integration.
• Collaborated on the migration project to ensure the accurate mapping and transition of data from the legacy system to SAP IS-U, maintaining data integrity throughout the process.
• Worked as a Functional Consultant and ABAP Developer to optimize and design processes for the Legal module, ensuring seamless integration and efficient system performance.
• Developed and deployed custom ABAP codes using SCASE for the Legal module, enabling business users to achieve optimal functionality and streamlined workflows.
• Provided development support for IS-U modules, ensuring the successful implementation and maintenance of core functionalities within SAP IS-U to support business operations.
• Worked closely with business stakeholders to understand process requirements and implement technical solutions that aligned with organizational goals.

• Worked as an SAP ABAP Developer on the Turkish Airforce Information System Project, focusing on ERP modules such as MM, PM, and PP.
• Developed ABAP programs and objects to enhance the functionality of SAP ERP modules, ensuring seamless integration and optimal performance .
• Designed and implemented complete add-ons to SAP, including dialogue screens, tables, reports, and BAPIs, to meet the specific needs of the organization.
• Developed and customized SmartForms for reporting purposes, improving user experience and enabling efficient data presentation.
• Created ALV Reports to deliver critical information in an easily accessible format for business users and decision-makers.
• Utilized user-exits, including function user-exits, BADI, and Open FI, to extend SAP functionality and integrate with external systems or custom processes.