Altorfer Consulting

Software Development

Test-Automation

Our newest project
RECYCLING ENGINE

Reduction of the current nuclear waste of any active
nuclear power station down to about

5% of the original volume.

CH-Version

UAE-Version

US-Version

C# (.NET, .NET Core)

Project

Analysis, implementation, commissioning, and CSV (computer system verification) of an MSC (Medical Surface Center)

process control system with the following features:

Configurable process sequences

Monitoring of processes and personnel authorizations according to process sequences

Configurable, PLC-controlled processing stations

Reporting of all processes and customer orders

Archiving of all processing procedures

Integration of dynamically switchable user language (German, English, Chinese)

Support with certification (CSV)

Front end in VBA and C#

Back end and process processing with SqlServer 2016 AlwaysOn and T-Sql (Transact Sql)

Tools

SqlServer 2016 AlwaysOn, T-Sql, Access2010(VBA), C#, .Net 4.6, CLR-Interface

Project

Analysis, implementation, testing, and commissioning of components for an MES (Manufacturing Execution System) for the production of customer-specific sensors

MapSampleAutoGenerator:

A tool that automatically selects sensors from different process stages for test measurements

ReelApprovalTool:

A tool that verifies that all sensors selected for the reels (rolls equipped with sensors) are error-free.

ReelReportingTool:

A tool that generates a Q report for the reels in the final process.

Test chamber automation:

Creation of a DB client application for controlling, monitoring, and defining the parameters and test sequences of test chambers in which the sensors are measured during the production process.

Tools

C#, WinForms, LinqToSql, .Net 4.5, SqlServer 2008R2, T-Sql, Multithreading, SVN, CodeSmith, MES

Project

Analysis + implementation of an application for billing services + materials with variable detailed items and interfaces to the time recording system, accounting system (Abacus), and CRM system.

Tools

C#, WinForms, MVVM, .Net 4.61, SqlServer 2014

Project

Display of the order volume of a large production company in weekly and daily bar charts with configurable features:
Variable selection of the display area
Various filters for production groups
Display of the order number instead of the order value
Display of the customer name if there is space in the bar
Calculation of the minimum height of a bar with automatic scaling of all values
Color control of the bars based on the order status
Additional marking of the bar for fixed dates
Activation of a pop-up window via mouse event above the bar and display of detailed information

Tools

C#, WinForms, .Net 4.5, SqlServer 2008R2, MS-ChartControl

Project

Analysis of extensions and error messages, and correction and implementation of functions in accordance with JIRA entry
3D extension: Implementation of a new algorithm for marking 3D objects such as half-cylinder sections, half-sphere sections, truncated cones, inclined planes, and prisms

Tools

C++, Trumpf LaserCAD Libraries, TruMark7000 Serie, JIRA

VBA (MS Access, Excel)

Project

Generating orders from quotes with links to AVOR and SharePoint:
Analyzing data and interfaces
Implementing VBA functions
Testing interfaces together with the customer

Tools

Excel 365 (VBA)

Project

Analysis and implementation of an application for generating service invoices for a service provider in the security sector (access control) and key service.
Including component management.
Various reports.
Data transfer from a previous application.
Expansion with QR code.

Tools
MS-Access, Visual Basic (VBA)

Project

Automated plate ordering with Excel VBA with interface to the ERP system and generation of supplier orders
Analysis of data and interfaces
Implementation of VBA functions
Testing of interfaces together with the customer

Tools
Excel 365 (VBA)

Project

Analysis, implementation, and commissioning of a system for processing and managing quality inspections of gas turbine components, including preparation of reports and documents and publication on the Internet.
Analysis, data modeling, task descriptions, scheduling/resource planning, project monitoring, and team leadership
Design of various test scenarios, including data synchronization with Internet servers (data import/export), acceptance checklists (protocols), and test scripts
Conducting reviews and release approvals
Development of special functions (interfaces to Winword, document generation)
Porting to Winword2010
Algorithms for fast search mechanisms (SqlServer)
Performance improvements using stored procedures (SqlServer, T-Sql)
Support for SqlServer configuration (replication) and security aspects
Importing measurement data from Matlab
Evaluating measurement data (trend analysis with ExcelObject)
FTP server control for data transfer to Internet servers

Tools

MS Access (VBA), Excel (VBA), Winword 2010 (VBA), SqlServer, T-Sql, Replication, C/C++

Test-Automation

Project

Analysis + testing of the ByVisionRobot, ByVisionBending, and ByVisionRobotManager applications used to configure and operate the new machines
Creation of test scripts for manual and automated tests
Execution of tests according to test scripts
Consulting for the implementation of tests in test automation
Implementation of tests with test automation

Tools

Jira, Testrail, Confluence, Xml, Xray, SpecFlow, Gherkin, TeamCity

Project

Application for capturing, defining, managing, and monitoring automated tests in a test framework using a three-layer architecture (presentation layer, business layer, database layer)

Design and implementation of a configuration manager with which any configurations and combinations (embedded systems) can be managed, generated in XML format, and loaded into the test environment
Creation of templates for the professional use of the MVVM pattern
Expansion of the TestcaseManager application to integrate additional product lines.
Use of background worker threads for monitoring and direct execution of test cases.
Implementation of unit and integration tests, including expansion of interfaces to various test environments (embedded Linux via Telnet+SSH).
Use of Enterprise Architect for documentation and diagrams.

Tools:

C#, ORM (EntityFramework 4.1, EntityDeveloper DevArt), WPF + MVVM, SQLServer, T-SQL, Telnet, SSH, Python,
Multithreading, Shellscripting, Backgroundworker, EnterpriseArchitect

Know-how
Design-Methods	3-layer model (GUI, business layer, DB layer) State/event diagrams (real-time logs) Application design (top-down/bottom-up) TDD (test-driven development)
Programming languages	C# (Visual Studio 2022), C/C++ VBA (Visual Basic for Application) (MS-Access, Excel, Winword, Outlook) MVVM, WPF, WCF, ServiceBroker
Databasesystems	SQLServer 2008R2-2023 (TransactSql, StoredProcedures, ServiceBroker, SqlServer Agent), Oracle 9i
Operatingsystems	Windows NT, 2000, XP, 2010 (Server), Vista, Linux Server (Firewalls), Win7, Win10, Win11
Protocols	TCP/IP, ODBC
Tools	Microsoft Teamsystem, Visual Studio 2010-2023, MS Office, MS Project, Visio, Citrix Metaframe, Apache, SVN
Models	UML (Use Cases, State/Event-, Sequencediagram)
Working technique	3-layer model (presentationlayer, businesslayer, db-layer) TDD, top-down design, rough and detailed analysis Solution-oriented working methods, Scrum
Specialized knowledge	Project management Security/data encryption/internet security International management/coordination SQLServer optimization WPF, WCF, MVVM EWS (ExchangeServerWebServices)

References

Aeschbach Chocoladier AG

Anox AG

Bystronic Laser AG

Bühler AG

CodX Software AG

Detron AG

General Electric (Schweiz) GmbH (früher Alstom AG)

Grisard Avia AG

Integrate Informatik AG

KKS Ultraschall AG

Landis & Gyr AG

Migrol AG

Noser Engineering AG

Quick Schlüssel Service GmbH

RTM AG

SACAC AG

Siemens AG

Trumpf Schweiz AG

Valora AG

Xaver Meyer AG