Projects

HALA
ELKHOLY
Senior Software Developer
.NET · Backend · Automation
Project 01

Enhancement and Stabilization of Production-Critical Applications for the Airbus Kit Factory

CEVA Logistics · Aviation Sector | Client: Airbus

Initial situation

Production-critical applications and dashboards supported daily production and logistics work at the Airbus Kit Factory by providing tasks, priorities, deadlines, and operational performance data.

The application landscape combined SAP-based data extraction with C#/.NET processing, database storage, and dashboard presentation. Changes in source data and operational requirements required reliable, timely adjustments.

Solution

Continuous enhancement and stabilization of the C#/.NET application and dashboard environment, with a focus on reliable data processing, monitoring, traceability, and continuity of operations.

My contribution

  • Maintained, stabilized, and enhanced production-critical C#/.NET applications and dashboards used by production and logistics teams.
  • Developed and troubleshot SAP-based data extraction and processing of operational delivery and performance data.
  • Investigated issues across application processing, data storage, and dashboard presentation.
  • Improved application and file-processing logic to reduce delays, prevent access conflicts, and increase reliability.
  • Strengthened monitoring and traceability through Hangfire background processing and Serilog-based structured logging.
  • Maintained the SQLite data layer and supported JSON-based visualization with Vue.js.
  • Documented application dependencies and collaborated with operational teams and Airbus contacts on changes, troubleshooting, and production support.

Technologies

C#.NETSAP GUI ScriptingSQLite HangfireJSONVue.jsSerilog Structured LoggingMonitoringGitLab
Project 02

Excel Decommissioning and Redevelopment of the Ready-for-Kitting Application

CEVA Logistics · Aviation Sector | Client: Airbus

Initial situation

Several production processes at the Airbus Kit Factory relied on an Excel-based process layer connected to SAP and existing operational applications. Its planned decommissioning required careful analysis of dependencies, business logic, and operational requirements.

Working with the team, I helped define the migration approach. Ready for Kitting was identified as a production-critical function that required redevelopment to preserve continuity of operations.

Solution

Analysis and migration planning for Excel-dependent processes, followed by end-to-end redevelopment of Ready for Kitting as a maintainable C#/.NET desktop application.

My contribution

  • Analyzed legacy applications, Excel-based workflows, scripts, SAP integration, and technical dependencies.
  • Collaborated with the team on migration planning and documented existing calculation rules and process dependencies.
  • Reconstructed the Ready-for-Kitting workflow, preserving essential business logic, process accuracy, and familiar user interactions.
  • Designed and implemented the replacement application end to end, including SAP GUI automation and generation of production-relevant component lists.
  • Developed an integrated HTML/CSS display, integrated a dedicated printing library, and implemented PDF generation.
  • Implemented validation, configurable settings, centralized logging, operational history, and installer-based deployment.
  • Improved usability while maintaining continuity for existing users and production processes.
  • Coordinated reviews and UAT with Airbus contacts and operational teams, and supported on-site troubleshooting and the production rollout.

Technologies

C#.NETWinFormsSAP GUI Scripting HTMLCSSEmbedded BrowserPrinting Integration PDF GenerationCentralized LoggingApplication Configuration Installer DeploymentGitLabExcel/VBA Analysis
Project 03

Redevelopment of Customs Management Software and Development of a Knowledge Base REST API

Developed at Porath Customs Agents, Hamburg (acquired by Customs Support)

Overview

Analysis and complete redevelopment of an internal customs and business-management application for customer data, customs processes, and statistical reporting. Business workflows and requirements were reconstructed from the legacy application in close collaboration with users.

My contribution

  • Analyzed the legacy application, reconstructed its business rules, and validated requirements directly with users.
  • Designed and completely redeveloped the Windows application with VB.NET, DevExpress, and SQL Server.
  • Implemented user interfaces, business logic, reusable libraries, and a multi-level roles and permissions model.
  • Designed and optimized the SQL Server database and its data-access functionality.
  • Developed a REST API secured with access tokens using C# and ASP.NET Core 2 for controlled integration with an external web application.
  • Created XML reporting tools for Intrastat submissions and maintained related internal applications.

Technologies

VB.NETC#ASP.NET Core 2REST API DevExpressADO.NETEntity FrameworkSQL Server T-SQLXMLAccess TokensTFS
Project 04

Redevelopment and Modernization of the PressePlus E-Commerce Portal

Developed at Skill Networks for PressePlus, Hamburg

Initial situation

An existing JavaScript-based portal for selling and managing magazine subscriptions was analyzed and gradually migrated into a structured ASP.NET MVC application. Its business functionality was reconstructed from the existing object-oriented JavaScript code and reimplemented within a modern full-stack architecture.

My contribution

  • Analyzed the object-oriented JavaScript legacy code, reconstructed its business logic, and migrated functionality into a structured ASP.NET MVC architecture.
  • Delivered full-stack functionality with C#, Razor, JavaScript, Entity Framework, and SQL Server.
  • Integrated two SQL Server databases and an Azure web service, and implemented session management and dependency injection.
  • Integrated a payment-provider API for PayPal, credit cards, and bank payment methods and coordinated technical troubleshooting with the provider.
  • Implemented responsive, search-engine-friendly interfaces and continuously enhanced the portal through project completion.
  • Provided technical guidance to a junior developer and coordinated shared development tasks.

Technologies

C#.NET FrameworkASP.NET MVCRazor JavaScript (Object-Oriented)Entity FrameworkDependency Injection REST/API IntegrationPayment API IntegrationPayPal SQL ServerAzure Web ServiceHTML5CSS3 Responsive DesignSEO
Project 05

Enterprise Automation and Administration Solutions for Axel Springer

Employer: dtc delphi technology consulting GmbH · On-site project assignment at Axel Springer, Hamburg

Designed and developed .NET applications, Windows Services, and automation tools for infrastructure, migration, identity administration, reporting, document automation, and secure data transfer. Requirements were gathered with specialist and infrastructure teams, and solutions were implemented largely independently.

Selected Solutions and Contributions

  • Secure File Transfer: Windows application and coordinated Windows services for configurable FTP/SFTP transfers with detailed logging.
  • Site and Infrastructure Migration: Applications that consolidated directory, messaging, database, and infrastructure data into operational reports and Excel exports.
  • Internal Cost Allocation: Continued development of a .NET Windows application for automated data collection across distributed systems, SQL Server storage, and preparation for downstream SAP processing.
  • Identity and Directory Object Recovery: Independently researched and developed Windows applications supporting recovery of Active Directory objects and associated Exchange mailboxes.
  • Role-Based Administration and Analysis Solutions: ASP.NET administration views and tools for role-based access, infrastructure analysis, and operational reporting.
  • Document and Office Automation: Automated Word and Excel processing and document generation using templates and dynamic placeholders.

Working Approach

Independently researched implementation approaches and translated requirements into production-ready solutions in collaboration with Axel Springer teams and dtc delphi developers, including testing, troubleshooting, documentation, and continued development.

Technologies

VB.NETASP.NETWindows FormsWindows Services ADO.NETWCFSQL ServerActive Directory LDAPWMIExchangeWindows API FTPSFTPScheduled TasksSAP Data Provisioning Microsoft Office AutomationWord and Excel TemplatesHTMLLoggingUML
Project 06

Enterprise and Client Projects at Fujitsu Services

Fujitsu Services Limited – formerly ICL, Cairo

Overview

Long-term work at an international IT services provider, progressing from junior to senior level. Development of web, database, publishing, and presentation solutions and direct collaboration with major public- and private-sector clients.

My contribution

  • Developed web and information solutions for the Egyptian State Information Service and other major clients.
  • Built and maintained static and database-driven applications for publishing editorial and multimedia content.
  • Designed a dynamic SQL-based prototype that supported a successful customer decision in favor of Fujitsu.
  • Gathered functional requirements directly with clients and key stakeholders.
  • Trained users and supported the onboarding and technical development of newly hired colleagues.
  • Contributed to company web projects, presentations, marketing activities, and customer-facing events while progressing from Junior to Senior Web Developer.

Technologies

VB6ASPSQL ServerT-SQL JavaScriptHTMLCSSAdobe PhotoshopMultimedia Web Technologies

Further Selected Projects

LichtBlick Schwarmstrom Portal for Decentralized Energy Systems

Developed at 7P Consulting & Solutions for LichtBlick, Hamburg

Contributed within a .NET development team to the redevelopment of the LichtBlick Schwarmstrom Portal from initial implementation through completion and handover. Independently implemented assigned portal functionality, integrated existing WCF services, developed interactive and responsive interfaces, and contributed to integration and troubleshooting.

  • Developed assigned portal functionality with C#, .NET, ASP.NET MVC, JavaScript, and jQuery.
  • Integrated WCF services and presented backend data through responsive interfaces.
  • Implemented AJAX-based interactions using DataTables, Bootstrap, and CSS.
  • Contributed through Git-based collaboration, integration, troubleshooting, completion, and customer handover.
C#.NETASP.NET MVC 4WCF Service IntegrationJavaScriptjQueryAJAXDataTablesBootstrapCSSGit

Supporting .NET Applications and Automation Tools for guenstiger.de

Developed at guenstiger.de GmbH, Hamburg

Developed and maintained internal .NET applications and automation tools supporting the price-comparison platform and related data-processing workflows.

  • Automated geographic-data collection for local price comparison and processing of undeliverable newsletter emails.
  • Created a JSON editor with Excel import.
  • Developed SQL Server structures and data-access functionality.
  • Maintained web and Windows applications, including FTP/SFTP file transfer.
VB.NETADO.NETSQL ServerWCFJSONExcel IntegrationFTPSFTPUML

Heart-J Medical Journal and Content Management Portal

Freelance project for the Cardiology Institute of Cairo University

Took primary responsibility for the design, development, and maintenance of a medical journal portal comprising a public website, a SQL Server database, custom content-management and administration functions, statistical reporting, user training, and continued technical support.

  • Analyzed requirements and planned the complete web solution.
  • Designed the application architecture and SQL Server database.
  • Developed the public website, dynamic backend, and custom content-management and administration functions.
  • Implemented the user interface and provided training, maintenance, and continued support.
ASPSQL ServerT-SQLJavaScriptHTMLCSSCustom Content Management