Directors Dealings

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

Functions:

• Sync master data
• Sync sales, registration, warranty, etc.
• Lock users out of the old system
• Sync various statuses (stolen, destroyed, move inventory, move dealer, and revert these processes)
• Add support function to the old system
• Various database changes to make the system compatible
• Event-based 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 with CRM
• Email sending with template editing
• User management
• Microservices
• Responding to 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 missing data to be added

Technical aspects:

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

Development of PCM.Connector

Functions:

• Generic copying from one table to another
• Configure and extend via app settings

Technical aspects:

• ADO.NET for MS SQL Server
• SQL Bulk Copy (direct copying from SQL Server to another SQL Server)
• Temporary tables
• Data archiving (from cache table to permanent table) (generic)

Functions:

• Create campaigns
• Assign products
• Import master and transaction data (e.g. product master data, sales figures)
• Calculate how many units should be planned in a campaign based on historical data (excluding holidays and past campaigns)
• Create multiple campaign scenarios per product
• Quick and easy overview of campaign costs
• Multiple user-specific approval steps
• Automatic email sending using admin-created templates
• Generate various Excel reports (promotion planning, approval, evaluation, branch report)
• Log and display who made changes and when
• Analytics on product, category, and historical campaign sales rates
• Compare planned volume with actual sales to 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 reports with EPPlus
• Angular frontend
• Active Directory access
• Unit tests with Xunit, FluentAssertions, Coverlet

Functions:

• Retrieve master data
• Create tariffing (product plus customs data)
• Import orders (and display)
• Combine product orders 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)

Functions:

• Consolidate product stocks from different branches
• Real-time stock by processing movement data (sales, deliveries)
• Provide variant stocks (e.g. shirt 5 pcs (3 gray, 2 white))
• Reconcile with branch stocks
• Integrate various interfaces
• Provide REST interfaces

Technical aspects:

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

Functions:

• Import master data (product, branches, price)
• Create instructions on how many units of each product to prepare in the back box at what time
• Calculate based on historical data (with exceptions for holidays and promotions)
• Instructions are branch-specific and planned a full week ahead
• Configure how the oven should be loaded, based on product types (e.g. pretzels, pastries, bread, etc.)
• Import sales figures into a database (for performance improvement)

Technical aspects:

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

Functions:

• Fill out questionnaire
• Assign a quality seal (1-3) based on selected answers
• Authorize schools based on school code and federal state
• After completion, send email with PDF attachment of the awarded quality seal
• Admin area for management (option to download reports)

Technical aspects:

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