Directors Dealings

Sync of data changes/events from the new system to the old system.

Functions:

• Synchronize master data
• Synchronize sales, registration, warranty, etc.
• Lock out users from the old system
• Synchronize various statuses (stolen, destroyed, move inventory, move dealers and reverse these processes)
• Add support function to the old system
• Various database changes to make the system compatible
• Event-driven synchronization

Technical aspects:

• Repository management (Git) with Microsoft Azure DevOps
• Agile project with Azure DevOps
• ASP.NET MVC
• SQL Server
• Azure Service Bus
• Hangfire
• NHibernate

Functions:

• Microsoft Dynamics CRM 365
• Online shop integrated with CRM
• Email sending with template editing
• User management
• Microservices
• Handling user inquiries
• EasyM user tracking (affiliate links)

Technical aspects:

• Microsoft Dynamics CRM 365
• SQL Server
• Microservices
• Azure DevOps
• Azure hosting
• CRM connection
• Power Apps for Dynamics

Ongoing support

Functions:

• Convert reporting data from Excel to XBRL (XML)
• Store data in Oracle DB
• Data transfer via SFTP
• Display reports with status and upload corrections

Technical aspects:

• Oracle DB
• ASP.NET MVC and REST API
• XBRL
• Filesystem and SFTP
• JavaScript, jQuery

Functions:

• Load and consolidate data for Intrastat export for Austria, Hungary, and Slovenia
• Display data and allow entry of missing data

Technical aspects:

• WinForms
• SQL (DataSet, ADO.NET)
• XML and CSV export

Development of PCM.Connector

Functions:

• Generic copying from one table to other tables
• Configuration and extension via app settings

Technical aspects:

• ADO.NET for MS SQL Server
• SQL Bulk Copy (direct copying between SQL Servers)
• Temporary tables
• Archiving data (from cache table to permanent table) (generic)

Design and development of Hilo

Functions:

• Create promotions
• Assign products
• Import master data and transaction data (e.g., product master data, sales figures)
• Calculate how many units should be allocated to a promotion based on historical data (excluding holidays and past promotions)
• Create multiple promotion scenarios per product
• Quick and easy overview of promotion costs
• Multiple user-specific approval steps
• Automatic email sending based on templates created by admin
• Generate various Excel reports (campaign planning, approval, analysis, branch report)
• Track and display who made changes and when
• Research overview of product, category, and historical promotion sales rates
• Reconcile planned quantities with actual sales to continuously improve the process

Technical aspects:

• Repository management with Microsoft Azure DevOps
• Agile project with Azure DevOps
• Backend Web API .NET Core
• SQL Server with EF Core Code First
• SQL Server temporal tables
• Excel reporting with EPPlus
• Angular frontend
• Active Directory access
• Unit tests with xUnit, FluentAssertions, Coverlet

Development of CPRS (Swiss Customs)

Functions:

• Retrieve master data
• Create tariffing (product plus customs data)
• Import and display orders
• Combine orders by product and create import data for Mercurio PowerSuite
• Import exports from PowerSuite for reconciliation

Technical aspects:

• Server via .NET Remoting
• WinForms
• ComponentOne WinForms
• SQL Server (DataSet and ADO.NET)

Development of VSI (Variant Stock Information)

Functions:

• Consolidate product inventory from various branches
• Real-time stock via movement data (sales figures, deliveries)
• Provide variant stock details (e.g., shirt 5 units (3 gray, 2 white))
• Reconcile with branch inventories
• Integrate various interfaces
• Provide REST endpoints

Technical aspects:

• Console application
• Generic table access via Entity Framework and ZZZ Project
• Web API with ASP.NET MVC
• Processing of large data volumes
• Entity Framework 6 and ZZZ Project extensions
• Monitoring and error tracking via Dynatrace

Development of BakeMan (calculation for bakebox)

Functions:

• Import master data (product, branches, price)
• Create instructions on how many units of each product should be prepared in the bakebox at what time
• Calculation based on historical data (excluding holidays and promotions)
• Instructions are branch-specific and calculated one week in advance
• Configure how the oven should be loaded based on product types (e.g., pretzels, pastries, bread, etc.)
• Import sales figures into a database (performance optimization)

Technical aspects:

• WPF application
• Three-tier architecture
• WCF service backend
• SQL Server backend (T-SQL)
• Entity Framework 6
• WiX installer
• Active Directory access
• Unit tests with NUnit
• Import of large data sets and temporary storage of branch sales figures

Functions:

• Fill out questionnaires
• Assign a quality seal (1–3) based on selected answers
• Authorize schools based on specific school codes and federal states
• After completion, send email with PDF attachment showing the achieved quality seal
• Admin area for management (option to download reports)

Technical aspects:

• Entity Framework 6 Code First
• SQL Server
• ASP.NET MVC + JavaScript
• iTextSharp