René P.
New development of a component-based complete solution for efficient workflows in municipal institutions
Experience
New development of a component-based complete solution for efficient workflows in municipal institutions
PROSOZ Herten GmbH
Development of several components using an in-house .NET framework in the “VB6 to C#/WPF Port” project.
Achievements:
- Requirements and code analysis
- 1:1 frontend replacement from VB6 to C#/WPF
- Implementation of backend components and applications in C# and T-SQL (MS SQL Server)
- Creation of regression tests with 90–100% code coverage
Tools, methods, libraries:
- .NET Framework 4.8, NUnit
- Visual Studio 2022
- ReSharper 2024.2.7, PostSharp, FluentValidation, MS SQL Server Management Studio
DevOps:
- SVN, Mantis, TeamCity
Maintenance and further development of a software package for processing health measures in rehab and prevention
clics – feine Software Manufaktur
Maintenance and further development of a client-server application with DevExpress WPF controls; see next position.
Tools, methods:
- .NET Core 8, C#, WPF with MVVM, Entity Framework Core, DevExpress Controls, DevExpress Xtra Reports, MS SQL Server, T-SQL, unit tests with xUnit
- Visual Studio 2022
DevOps:
- Jira, Jenkins, Nexus, Git, Gogs, Gitea
Industry: Healthcare provider for statutory health insurance
New development of a software system for processing health measures in rehab and prevention
clics – feine Software Manufaktur
Migration of outdated software packages for managing health measures through integrated redevelopment using modern technologies. Designed the data model, built and programmed the MS SQL Server database, implemented a client-server application with DevExpress WPF controls. Created NuGet packages for recurring standard tasks. Letter generator for mail (letters, fax, email) to health insurers, clinics, insured persons using Xtra Reports.
Activities:
- Analysis, design, development
- Documentation and testing
- Database design and development
- CI/CD with Jenkins pipelines
Tools, methods:
- .NET Core 5–8, C#, WPF with MVVM, IoC, Unity, Entity Framework Core, DevExpress Controls, DevExpress Xtra Reports, MS SQL Server, T-SQL, unit tests with xUnit
- Visual Studio 2019–2022
- Automated email delivery to health insurers, clinics, and other stakeholders
- Interfaces for data import/export from external systems via Web API, REST
DevOps:
- Jira, Jenkins, Nexus, Git, Gogs, Gitea
Industry: Healthcare provider for statutory health insurance
Maintenance and further development of a software package for processing health measures in rehab and prevention
clics – feine Software Manufaktur
Took over maintenance of a monolithic system consisting of 24 applications, over 2,400 VB.NET source files, and more than 1.5 million lines of code.
Activities:
- Analysis, design, development
- Documentation and testing
- Database development
Tools, methods:
- .NET Framework 3.x, 4.x, MS SQL Server, Visual Studio, VB.NET, Git
DevOps:
- Jira, Jenkins, Nexus, Git, Gogs, Gitea
Industry: Healthcare provider for statutory health insurance
Creation and further development of applications for managing and analyzing rehabilitation payment transactions
clics – feine Software Manufaktur
Enhanced several online applications for handling and analyzing rehabilitation payments, developed automated batch processes.
Activities:
- Analysis, design, development, documentation and testing
- Database development
- Creation and maintenance of Crystal Reports
Tools, methods:
- Oracle SQL, MS Access, Visual Studio, C#, WPF, XML, VBA, MS Office, Git
Industry: Pension insurance, supplementary pension fund, public law institution
Design and implementation of intranet applications for order management, financial and investment planning
clics – feine Software Manufaktur
Implemented interfaces to Atlassian JIRA in C# .NET. Designed and programmed several ASP WebForms applications for processing and analyzing IT orders with integration to JIRA Kanban boards for status tracking. Contributed to drafting a policy for IDV and UDV, and designed and implemented a compliant software register.
Activities:
- Analysis, design, development
- Documentation and testing
- Database development
Tools, methods:
- .NET Framework 4.7, MS SQL Server, Visual Studio, C#, ASP WebForms, unit tests, Git
DevOps:
- Jira, Jenkins, Nexus, Git, Gogs
Industry: Pension insurance, supplementary pension fund, public law institution
New development of a customer relationship system
clics – feine Software Manufaktur
- Requirements analysis
- Programming
- Testing
- Support
Database:
- MS Access
Industry: Financial services
Application review of an existing portfolio management software
clics – feine Software Manufaktur
Evaluation of maintainability, configurability, reliability, future viability, extensibility, and reusability.
Assessed aspects:
- Modularization/layering and application architecture
- Database structure and implementation
- Used languages, development environment, components, third-party software
- Communication with other systems (interfaces)
- Level of documentation
Industry: Direct insurance
New development of a subscription management and billing system
clics – feine Software Manufaktur
- Requirements analysis
- Programming
- Legacy data migration
- Testing
- Support
Database:
- MS Access, VBA
Industry: Publishing, magazines
Consulting and support in database-driven direct marketing and address and data quality management
clics – feine Software Manufaktur
Located and fixed errors in the client’s data and application systems. Implemented patches and corrected and enriched data sets. Supported licensing, maintenance, and administration of SSIS components.
Database:
- MS SQL Server, SQL Server Integration Services (SSIS)
Industry: Dialog marketing
CIO
clics – feine Software Manufaktur
- Software development
- Team leadership
- Project management
Further development of an insurance agency system
clics – feine Software Manufaktur
Enhanced and maintained a complex agency system for an insurance company including rate calculators for auto, property, commercial, and legal protection lines. Implemented business requirements in about seven release cycles per year. Developed various interface components.
Activities:
- Analysis, design, development, documentation and testing
- Resource planning, QA
- 3rd level support
- Led a 4-member developer team
- Project coordination
Tools, methods:
- Oracle SQL, MS Access, Visual Studio, C#, VB6, Java, WCF/SOAP/REST web services, OOA, OOD
DevOps:
- PVCS, in-house tools
Industry: Composite / property & casualty insurance
Software for analyzing and preparing revenues
- Requirements analysis
- Concept
- Project management
Database:
- MS SQL Server, MS Access, SSIS, DTS
Industry: Energy services provider
Software for accounting special advance payments
- Requirements analysis
- Concept
- Implementation in VB.NET
Database:
- MS SQL Server, XML
Industry: Energy services provider
Software to identify contracts for automatic price adjustment
- Requirements analysis
- Specification document
- Implementation in C#
- Created SQL queries in views and stored procedures
- User training
Database:
- MS SQL Server
Industry: Energy services provider
Further development of a CRM solution; customer and contract management
Programming in VB and T-SQL, identified and resolved performance issues caused by inefficient SQL queries and database modeling.
Database:
- MS SQL Server
Industry: Energy services provider
Senior software developer
TelDaFax SERVICES GmbH
- Address and contract management
- Customer relationship management (CRM)
- Tools, interfaces
Quick address entry
Design and implementation with Visual Basic 2005, programming T-SQL statements.
Database:
- MS SQL Server 2005
Industry: IT service provider
Data import interface from Excel to SQL Server
Design and implementation with Visual C# 2005, programming T-SQL statements.
Database:
- MS SQL Server 2005 / MS Excel 2007
Industry: IT service provider
Expansion of the online portal to run a writing contest
TUIfly.com
Development for WordPress in PHP and JavaScript.
Database:
- MySQL
Industry: Tour operator
Cashbook with fixed assets and asset management, cost center accounting, and integrated address management
Enhancements, programming in Visual Basic 6, SQL.
Database:
- MS Access 2000–2003
Industry: Political party
Order and file management including date and deadline tracking, registry, interface to address management and MS
Design and programming in Visual Basic 6, programming T-SQL statements.
Database:
- MS SQL Server 2000/2005, MS Access
Industry: Law firms
Launch/relaunch of multiple online portals (13)
Design and implementation with WordPress, PHP, and CSS.
Database:
- MySQL
Industry: Various
Graphical display and editing of the organizational structure of a corporate group
Design, programming in Visual Basic 6, programming T-SQL statements.
Database:
- MS SQL Server 2000
Industry: Cooperative association
Marketing system
Design, programming in Visual Basic 6, programming T-SQL statements.
Database:
- MS SQL Server 2000
Industry: Tax consultants, auditors
Incoming mail and case processing with integrated order management, travel expenses, dates and deadlines
Partial design, programming in Visual Basic 6, programming T-SQL statements.
Database:
- MS SQL Server 2000/2005, MS Access
Industry: Service association
Address management with mail merge for MS Office and OpenOffice.org
- Design
- Project management
- Programming in Visual Basic 6
- Programming T-SQL statements
Database:
- MS Access
Industry: Parties, associations, organizations
Optimization of internal reporting, consolidation hierarchy, utilization statistics, unbilled services, vacation
- Design
- Project management
- Programming in Visual Basic 6 and Crystal Reports
- Programming T-SQL statements
Database:
- MS Access, MS SQL Server
Industry: Law firm
Launch/relaunch of several online portals (3)
Design, implementation in HTML, CSS, PHP, Mambo and Joomla.
Industry: Various
Product database and catalog generation as print and online medium, DATANORM and BMEcat interfaces
- Design
- Programming in Visual Basic 6
- Programming T-SQL statements
- EPS/PostScript output
Database:
- MS SQL Server, MS Access, Oracle
Industry: Catalog publisher, wholesale association
System administration
- Design
- Administration
Technology:
- TCP/IP networks, Windows clients and servers
Industry: Medical center
Order and file management
- Design
- Programming in Visual Basic 4
- Programming T-SQL statements
Database:
- MS SQL Server, MS Access, Oracle
Industry: Tax consultants, lawyers
Time tracking, invoicing
- Design
- Programming in Visual Basic 4
- Programming T-SQL statements
Database:
- MS SQL Server, MS Access, Oracle
Industry: Lawyers, auditors, law firms
Cash management and address management
- Design
- Project management
- Programming under DOS/Windows in MicroFocus COBOL
Industry: Parties, associations, organizations
Various in-house projects
- Design
- Project management
- Programming in WANG VS COBOL
Industry: Automotive group
Self-employed software developer and IT consultant
- Development of custom and standard software solutions in technical and commercial environments for MS Windows and WANG operating systems
- Creation of online presences, web design, CMS
- Programming of SQL database applications
- Time and performance tracking and billing, time reports
- Address and order management, CRM
- Accounting software, profit and loss statements
Languages
Certifications & licenses
Certified C# Software Developer
Fernakademie für Erwachsenenbildung
Certified Java Programmer
ILS
ITIL® v3 Foundation Certification
APMG
Trainer according to AEVO regulation for IT specialists in application development
Cert. IT Business Manager
CCI
Certified IT Project Manager
IHK
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.