Reinhold Schätz-Senior Software Developer
Check rate
Experience
Senior Software Developer
Hitachi Energy
- Support and further development of the Leegoo Builder
- Handling ad hoc requests
- Definition of rules/attributes and their rules
- Optimizing and managing SQL queries
Service BI Specialist
Canon Switzerland
- Data evaluations and analyses to support the business efficiently
- Ad hoc analyses
- Data quality management & testing
- Optimization of tools (Power BI / dashboards and OAS dashboards)
- Support for SQL data management – SQL Management Studio
Data Analytics / Software Architect / Developer / Admin
IBM / Kyndryl
Setup/administration of a dashboard for various KPIs from the incident/change/problem ticket system
Creation of the ETL infrastructure (T-SQL) → datamarts → layer system
Splitting the data into facts (KPI calculations) and dimensions (data itself) via SQL views and stored procedures
Presentation/visualization via Power BI
Setting up the data gateway → Azure
Migration of the dashboard from on-premise → Azure
Building a banking environment in Azure: installation via PowerShell/AZ CLI, Azure Bastion for RDP access, Azure Storage Explorer for files on-premise → Azure, testing SHP → Azure Active Directory & ADDS, connection SHP → Okta/OneID – SSO, migration of all apps (VB6/C#) → Azure, .NET Framework (Net Core, ASP.NET MVC)
Installation/configuration of Power BI/SSRS Server, creation of dashboards/paginated reports and SSRS reports, creation of SSAS cubes, development of Power BI dashboards (data modeling), datamarts + dashboard, ETL frameworks, data models, database design development, data mining, databases (SQL)
SharePoint 2019 admin/developer: installation/configuration, Health Services, logging, auditing, security NTLM/LDAP, migration from SP2010 → SP2019, development of LDAP and SQL membership providers, migration of farm solutions (8 projects)
Blazor app framework evaluation: DevExpress UI components, component structure, dependency injection and data access, authentication with OWIN (OpenID Connect/SSO), routing, editing and validation, JavaScript interop, Blazor Server ↔ Blazor WebAssembly
Building a DWH / SQL Server (>2012): setup of DWH server, preparation for reporting, KPI calculation based on configuration, layering/datamarts, table sizing, layer concept with dynamic SQL
SharePoint 2016 admin/developer: installation/configuration, search service, Health Services, logging, auditing, security NTLM/LDAP via PowerShell
SharePoint 2013 Foundation admin/developer: installation/configuration, search service, Nintex workflows incl. security, own membership providers, Health Services, logging, auditing, security NTLM via PowerShell
Creation of web applications: architecture and design, maintenance and further development, integration into the IT landscape, continuous integration with SVN/GIT and Jenkins, UI via WPF, technologies: Visual Studio, C#, HTML, XSLT, XML, JavaScript, jQuery, JSON, Subversion, T-SQL, LINQ, Entity Framework, WCF services, Web API, MVC
Further development of Shared Cockpit Tool: generic web framework based on Entity Framework, OOP in C#, implementation via ASCX, role delegation, dynamic input forms, continuous integration with SVN and Jenkins
Creation of VisualBoard in SharePoint 2010: display of KPIs, management of issues/tasks/logs, overview of health index of 35 pools, role-based security concept, administrative management via application pages, web parts for pool structure and problem overview, dashboard data model, SSRS reporting, T-SQL processing for KPI calculation
Migration SharePoint 2007 → SharePoint 2010: planning, concepts, documentation, introduction of SP2010, FBA login via LDAP, programming of application pages, BCS integration, enterprise search, web parts, Subversion, Nintex workflows
Reporting Resolution customer project: setup of DWH with data modeling and documentation, automatic import interfaces via SSIS/email, data loader with logging and restarts, SSRS reports and integration in SharePoint 2007 MOSS/2010, stored procedures and T-SQL optimization
Software Architect and Developer
Abel ReTec GmbH & Co. KG
- Development of a database for managing sales and support data of biogas plants
- Data modeling based on SQL Server 2008
- Optimization of data access via T-SQL and creation of .NET functions on the SQL Server
- Implementation of interfaces to laboratory data based on XML
- GUI display via Access 2007
- Reporting using SSRS via intranet
Programmer / Architect / Oracle DWH Engineer
AXA IT Group Solutions
Project SAP@AM: processing delivered data from custody accounts in file format and creation of MT535 SWIFT messages under SOX compliance, documentation and test cases, technology: Excel VBA
Project Old/New VB to .NET: evaluation of existing VB applications, shared database and data modeling, OOP/OAD documentation, implementation in C#/.NET, 3-tier application with a small Oracle 10g DWH
Migration Oracle 8i → Oracle 10g: evaluation and documentation of dependencies, testing, adjustment of PL/SQL statements, on-time coordination and handover via SQL script
Project FXPMS/FIDB: maintenance and testing of existing VB applications for trade processing (Bloomberg), ETL with Oracle Warehouse Builder, automation via Redwood Cronacle, extension of PL/SQL procedures and Redwood chains, adjustment of the database and UI, semi-annual Telekurs releases, SOX compliance and testing
Project MCD/FDR to OPDP: data extraction via SQLLDR, transformation and loading into reporting tables, focus on data modeling, ADO, PL/SQL, OWB, BI with SSIS+SSRS
Programmer / Architect / Oracle Engineer
Winterthur
Project FXPMS: expansion of GUI and Oracle Server Objects for trading data via Bloomberg, adjustment of Oracle Warehouse Builder objects for new mappings, GUI enhancements for sorting, optimization of hedge/trade capture, reporting via Crystal Reports and Office Automation
Project PAM/FOM: GUI for flat file data in asset management, mutation and transformation triggers, output to SAP ESB bus (FI, CO, AR, AP), full documentation (UML), data model, OOP/OAD design, tools: Visual Studio, VB6, ADO, PL/SQL
Software Architect / Programmer
Schmack Biogas AG
- Creation of a sales database for the construction of biogas plants with Access frontend and SQL Server 2000
- Recording of appointments/contacts and report creation
- Management and maintenance of the plants, operations log with charts for analysis
Consultant and Programmer
Abel Mobilfunk
- Development of a SQL database with Access frontend for construction and scheduling management of telecom towers
- Interface development, including post-calculation from ERP system
- Continuous adaptation to customer requirements and order processing
Software Architect
Jobscout24
- Analysis of the existing architecture of the business logic (COM components) and database architecture
- Development of a concept for further architecture development with a view to MTS use
- Design for MS Classic technology with future .NET integration
- Support for software product development
Architect / Programming
Vibru med
- Development of a complete OOP framework with interfaces for mainframe communication with external DLLs
- Medical field: billing software for doctors and SPZ (02/05–08/05), service recording and patient registration via chip card
- Programming language: VB/.NET, framework: Visual Studio, MS SQL Server
- Creation of the framework architecture and private billing module
Programmer
Abel Mobilfunk
- Development of an interface for printing documents from a SQL Server database
- Generation of Word or Excel sheets based on metadata
Programmer / Subproject Manager
Micom
- Migration of a VB6 application to .NET for hospital administration (KISS system) with 1200 tables
- Implementation of the data access layer based on OO patterns with TableGateway in C# in a classic 3-tier model
- Development of web and WinForms GUIs, communication via SOAP and DataSets
- Lead of a 5-person data access team, automation of table code generation via a pre-deployment add-in
Programmer / Project Manager
SAG Abel
- Development of software for managing and analyzing data for the construction of mobile phone masts (T-Mobile, E-Plus, Vodafone, O2)
- Input and analysis of schedule plans and acquisition reports
- Programming language: VB, framework: Visual Studio, database: SQL Server
Project Manager / Programmer
Airbus AG
- Implementation of the Template Navigator add-in for opening templates according to CI/CD standards with multilingual support and dynamic DIN A4/Letter creation
- Installation on more than 40,000 clients, standard compliance at Airbus
- Extensions for connection to content management systems based on Oracle and SQL Server
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology, Energy, Insurance, Healthcare, Aerospace and Defense, and Telecommunication.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Product Development, Quality Assurance, Project Management, and Sales.
Summary
Getting familiar with existing source code is one of my strengths. Whether it is T-SQL or programming languages like C#/VB.NET/jQuery/JavaScript, I feel at home. Through the introduction of the GDF framework (implementation of SharePoint and its enhancements/programming/WebParts) within IBM, the related meetings required quick understanding of the customer side and what could be implemented. Still, I never lost sight of the final picture of the software.
Personally, I am a calm person, but still with a positive presence. When problems come up, I look for solutions and always see every problem, whether big or small, as a positive experience. Hey, I was able to learn from it. I want to understand people from other cultures and languages, and open discussions, no matter the topic, interest me.
Skills
Operating Systems
- Windows All Versions > 10 Years, Expert, Last Used In 2024
- Os/2 > 1 Years, Beginner, Last Used In 2002
Programming Languages
- Ms Visual Basic > 10 Years, Expert, Last Used In 2022
- Ms Visual Basic For Applications (Vba) > 10 Years, Expert, Last Used In 2022
- Sql > 10 Years, Expert, Last Used In 2024
- C# > 10 Years, Expert, Last Used In 2024
- Html > 10 Years, Expert, Last Used In 2024
- Vb.Net > 10 Years, Expert, Last Used In 2024
- Javascript / React > 5 Years, In Depth, Last Used In 2024
- Java < 1 Years, Beginner, Last Used In 2002
- Pl-Sql > 5 Years, In Depth, Last Used In 2009
- Xml > 10 Years, Expert, Last Used In 2024
- Xsl > 10 Years, Expert, Last Used In 2024
- Xslt > 10 Years, Expert, Last Used In 2024
- T-Sql > 10 Years, Expert, Last Used In 2024
Databases
- Ms Access All Versions > 10 Years, Expert, Last Used In 2024
- Oracle From Version 8i > 5 Years, In Depth, Last Used In 2024
- Ms Sql Server From Version 7.0 > 10 Years, Expert, Last Used In 2024
- B-Trieve < 1 Years, Beginner, Last Used In 2001
Tools/Methods
- Ms Office All Versions > 10 Years, Expert, Last Used In 2024
- Ado > 10 Years, Expert, Last Used In 2024
- Activex / External Dlls > 10 Years, Expert, Last Used In 2009
- Crystal Reports > 5 Years, In Depth, Last Used In 2011
- Ms Visual Studio > 10 Years, Expert, Last Used In 2024
- Odbc > 10 Years, Expert, Last Used In 2024
- Ole > 7 Years, In Depth, Last Used In 2009
- .Net > 2.0 > 10 Years, Expert, Last Used In 2024
- Lotus Smart Suite / Symphony > 3 Years, Advanced, Last Used In 1996
- Ms Visio > 10 Years, Expert, Last Used In 2024
- Ms Visual Source Safe > 5 Years, In Depth, Last Used In 2010
- Oo Analysis > 10 Years, Expert, Last Used In 2024
- Oo Design > 10 Years, Expert, Last Used In 2024
- Oo Programming > 10 Years, Expert, Last Used In 2024
- Eclipse > 1 Years, Beginner, Last Used In 2001
- Swing > 1 Years, Beginner, Last Used In 2002
- Ado.Net > 10 Years, Expert, Last Used In 2024
- Oracle Warehouse Builder > 3 Years, Advanced, Last Used In 2009
- Soap > 10 Years, Expert, Last Used In 2024
- Ssrs / Ssis > 10 Years, Expert, Last Used In 2024
- Subversion > 3 Years, Advanced, Last Used In 2024
- Hp Quality Center < 1 Years, Beginner, Last Used In 2009
Languages
Certifications & licenses
MCP
Statistics
Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Senior Software Developer
Nearby freelancers
Professionals working in or nearby Risch-Rotkreuz, Switzerland
