Reinhold Schätz
Senior Software Developer
Senior Software Developer
Hitachi Energy
- Maintain and enhance the Leegoo Builder
- Handle ad-hoc requests
- Define rules/attributes and their logic
- Optimize and manage SQL queries
Service BI Specialist
Canon Schweiz
- Data analysis and reporting to support the business efficiently
- Ad-hoc analyses
- Data quality management & testing
- Optimize tools (Power BI / Dashboards and OAS Dashboards)
- Support SQL data management – SQL Management Studio
Data Analytics / Software Architect / Developer / Admin
IBM / Kyndryl
Data Analytics – Power BI – On-premises/Cloud
Build/administer dashboards for various KPIs from incident/change/problem ticket systems
Set up infrastructure from ETL (T-SQL) -> data marts -> layered system
Split data into FACTs (KPI calculations) and dimensions (raw data) via SQL views and stored procedures
Visualize with Power BI
Configure Data Gateway -> Azure
Migrate dashboards from on-premises to Azure
Set up a banking environment in Azure (architect/developer)
Installed via PowerShell/AZ CLI
Azure Bastion for RDP access
Azure Storage Explorer for file transfer on-premises -> Azure
Test SharePoint -> Azure Active Directory + ADDS for authentication
Connect SharePoint -> Okta/OneID – SSO
Migrate all apps (VB6/C#) -> Azure
.NET Framework (NET Core, ASP.NET MVC)
Tools: Visual Studio 2022
Develop Power BI / SSRS (data analytics)
Install/configure Power BI/SSRS servers
Create dashboards / paginated reports
Build SSRS reports from custom stored procedures (SQL Server)
Build SSAS cubes
Develop Power BI dashboards (data modeling)
Data marts + dashboards
ETL frameworks
Data models, database design, data mining
Databases (SQL etc.)
SharePoint 2019 (admin/developer)
Install/configure SharePoint 2019
Configure Health Services and logging
Configure auditing
Configure security NTLM/LDAP
Install via PowerShell
Migrate SP2010 -> SP2019
Develop LDAP membership provider (VS2019/C#)
Develop SQL membership provider (VS2019/C#)
Migrate farm solutions (8 projects) SP2010 -> SP2019 (farm features / lists / security)
Tools: VS2019 / C#
Blazor as app framework (developer)
Compare Blazor with previous JS frameworks for future projects
DevExpress UI components for Blazor
Component structure
Dependency injection and data access
Authentication with OWIN (OpenID Connect/SSO)
Routing, editing, and validation
JavaScript interop
Blazor Server <-> Blazor WebAssembly
Build DWH / SQL Server (>2012) (admin/developer)
Set up a DWH server
Prepare for reporting (standard reporting, framework for multiple clients, just onboarding needed)
KPI calculation based on configuration
Layer/data marts from tables
Dimension tables for BI prep
Layer concept (templates generating dynamic SQL)
SharePoint 2016 (admin/developer)
Install/configure SharePoint 2016
Configure Search Service (formerly FastTrack)
Configure Health Services and logging
Configure auditing
Configure security NTLM/LDAP
Install via PowerShell
SharePoint 2013 Foundation (admin/developer)
Install/configure SharePoint 2013
Configure Search Service (formerly FastTrack)
Configure Nintex workflows including security
Build custom membership provider
Configure Health Services and logging
Configure auditing
Configure security NTLM
Install via PowerShell
Develop web applications (software architect/developer)
Build applications of varying sizes per client requirements
Maintain and enhance existing applications
Architect and design applications
Integrate into IBM’s IT landscape
Continuous integration with SVN/Git + Jenkins
UI with WPF
Tech: Visual Studio 2010-2022, C#, HTML, XSLT, XML, JavaScript, jQuery, JSON, Subversion, T-SQL, LINQ, Entity Framework, WCF services, Web API, MVC
Enhance and maintain internal tool Shared Cockpit (software architect/developer)
Tool allows generic table management in the web using Entity Framework
Framework built in C#, OOP
Specialized features added via ascx or generic configurable modules
Example: role delegation
Dynamic input form generation
Continuous integration with SVN + Jenkins
Tech: Visual Studio 2010-2022, C#, XML, WCF, UI via jQuery, T-SQL
Create a VisualBoard in SharePoint 2010 (software architect/developer)
VisualBoard shows KPIs and manages issues/tasks/logs for GDF
Also tracks health index of each pool
Implemented for 35 pools
Use SharePoint’s role-based security
Admin via application pages in SharePoint
Data used for charts in GDF framework
Home page as web part page so each pool can arrange parts as needed
Web parts to display pool structure/members and issue overview
Database: MS SQL Server
Build data model for processing
KPI numbers via parametrized SSRS reports
Process large data with T-SQL for KPI business logic
Tech: Visual Studio 2010-2013, C#, HTML, XSLT, XML, JavaScript, jQuery, SharePoint features, SSRS, event receivers, Subversion, LINQ, Entity Framework, data lists, WCF, Web API
SharePoint 2007 -> 2010 migration (software architect/developer)
Plan, document, and execute migration
Introduce SharePoint 2010
Admin tasks – implement FBA login via LDAP
Program application pages in C# within SharePoint
Connect external data via BCS
Set up enterprise search environment
Develop web parts with C# and web part connectivity
Use Subversion for source control
Build workflows with Nintex Enterprise
Reporting solution
Built a complete DWH (data modeling) with reporting solution and documentation
Create automated import interfaces for DWH via email and direct import (SSIS)
Design a fully automated data loader with logging and restarts
Design/reports via SSRS and integrate into SharePoint 2007 MOSS/2010
Write and optimize stored procedures and T-SQL/SQL
Tech: SQL Server 2005/2008+R2, SSRS, SSIS, Subversion
General
Extended existing ASP.NET apps in VB.NET and C# using Dynamic Data in VS 2005-2017
Deep knowledge of LINQ & Entity Framework
Solid web fundamentals: HTML, XSLT, XML, JavaScript
Testing with NUnit
Scrum used as development framework.
Software Architect and Developer
Abel ReTec GmbH & Co. KG
- Abel ReTec sells and supports biogas plants
- I built a database to manage their data
- Strong data modeling on SQL Server 2008
- Optimized data access with T-SQL and .NET functions on SQL Server
- Implemented interfaces to lab data, using XML
- GUI built in Access 2007
- Reporting via SQL Server services (SSRS) shared with users over an intranet
Programmer / Architect / Oracle DWH Engineer
AXA IT Group Solutions
Project SAP@AM
Process delivered data from multiple custody accounts into file format for SAP@AM
Program reads input data and creates MT535 Swift messages
I handled complete implementation with SOX compliance
Documented requirements, implementation, and test cases
Tech: Excel VBA
Project VB to .NET migration
Evaluate small VB apps and migrate to .NET
Defined common data model after functional analysis
Produced OOP/OAD documentation
Implemented solution in C#/.NET, including data modeling
Tech: C#/.NET/ADO.NET, 3-tier app on Oracle 10g
Oracle 8i -> 10g migration
Migrate DB to Oracle 10g
Evaluate dependencies, document/test/adapt applications, coordinate production rollout
Adjust PL/SQL statements and provide SQL scripts to operations
Project FXPMS/FIDB
Maintain and test FXPMS and FIDB apps
FXPMS processes trades from Bloomberg and delivers hedges via reports
Apps built in VB, DB on Oracle 10g, ETL with Oracle Warehouse Builder, scheduling with Redwood Cronacle
Expand PL/SQL procedures/Redwood chains, update data model, adjust UI as needed
Follow SOX compliance and testing
Project MCD/FDR to OPDP
For official AXA-CH reporting, load data from MCD/FDR via SQL*Loader, transform, and store in reporting tables
Focus: data modeling, ADO, PL/SQL, OWB, BI with SSIS+SSRS
Programmer / Architect / Oracle Engineer
Winterthur
Project FXPMS
FXPMS displays and processes trading data from Bloomberg
Extend GUI and Oracle Warehouse Builder objects
Adjust mappings, GUI sorting, hedge/trade entry, and reporting via Crystal Reports and Office templates
Tools: Visual Studio, ADO, VB6, Crystal Reports, Office Automation, PL/SQL, Oracle Warehouse Builder
Project PAM/FOM
Built interface/GUI to read asset management data from flat files and process it
GUI allows data editing and triggers transformations and mappings
Output to SAP ESB bus for FI, CO, AR, AP modules
Document design to operations (UML), define data model, and develop software with OOP/OAD
Tools: Visual Studio, VB6, ADO, PL/SQL
Software Architect / Programmer
Schmack Biogas AG
- Created a sales database for biogas plant acquisition
- Access used as frontend, SQL Server 2000 for data storage
- Software helps sales staff manage appointments and contacts
- Provides overview of tasks for plant construction and planning
- Extended to maintenance and logbook with graphs for analysis
Consultant and Programmer
Abel Mobilfunk
- Abel builds telecom masts
- Developed SQL database with Access frontend for project data and scheduling
- Built interfaces for ERP-based post-calculation
- Continuously adapt to industry changes and client requirements
Software Architect
Jobscout24
- Analyze current architecture (project team)
- Identify strengths/weaknesses in business logic (COM components) and DB design
- Draft concept to evolve architecture for business logic and MTS use
- Plan MS Classic technology with view to future .NET use
- Support software product development (project team)
Architect / Developer
Vibru med
Build full OOP framework
Mainframe communicates with external DLLs via interfaces
DLL modules listed in a table so any DLL can load the interface
Medical domain:
Complete billing software for doctors and outpatient centers (02/05 - 08/05)
Service entry and patient admission via chip card
Tech: VB/.NET, Visual Studio, MS SQL Server
Built framework architecture and interfaces
Developed private billing module
Developer
Abel Mobilfunk
- Interface to print documents from SQL Server DB
- Uses metadata to generate Word or Excel sheets
Programmer / Subproject Lead
Micom
- Migrate VB6 hospital management software (KISS system) with 1,200 tables
- I implemented the Data Access Layer following OO patterns
- 20-person team, 3-tier model, built Web and WinForm UIs
- Layers communicate via SOAP and DataSets
- Led a team of 5 for the Data Access Layer
- Created a pre-deployment add-in to auto-generate TableGateway code
Programmer / Project Lead
SAG Abel
- Manage and analyze telecom data for SAG Abel building masts for T-Mobile, E-Plus, Vodafone, O2
- Software handles data entry and reporting (schedules, acquisition reports)
- Tech: VB, Visual Studio, SQL Server
Project Lead / Programmer
Airbus AG
- Built Template Navigator add-in to call templates / multi-language per CI/CD standards
- Strictly follow design norms
- Support multiple languages and dynamic A4/Letter layout
- Deployed add-in to 40,000+ clients as Airbus standard
- Extended connectivity to CMS on Oracle (Germany) or SQL Server (France)
Getting familiar with existing source code is one of my strengths. Whether in T-SQL or in programming languages like C#/VB.NET/jQuery/JavaScript, I feel right at home. Through the introduction of the GDF framework (SharePoint implementation and its enhancements / programming / web parts) within IBM, quick understanding of the client side and possible solutions was required in the related meetings. Still, the final vision of the software was never lost.
Personally, I’m a calm person with a positive vibe. When problems come up I look for solutions and see every issue, big or small, as a positive learning experience. Hey, I gained experience. I want to understand people from different cultures and languages, and I enjoy open discussions on any topic.
MCP
Similar Freelancers
Discover other experts with similar qualifications and experience
