Jochen Rieseberg
Independent IT Consultant
Experience
Independent IT Consultant
State Office of Criminal Investigation, Thuringia
- Database development, coding SSIS to merge different sources via REST/API access PostgreSQL data into a SQL Server database structure. Introduction of ZappySys and KingswaySoft development packages for SSIS
- Various ETL processes maintenance-free even with changing source structures, MS Access maintenance tool for the main tasks without access to the SSMS.
Independent IT Consultant
Inatec GmbH
- VBA for the automation of process flows in MS Visio and MS Access to MS Excel
- Development of macros that make the flow of information within complex process engineering drawings more efficient with automation of parts list management, which greatly reduced processing time.
Independent IT Consultant
Mi-Hub Polska z o.o.
- SQL Server Management Tasks and Improvements to the Current Reporting System (MIS)
- Streamlining of the entire database system, which led to a significant simplification of the complex database structures used.
Independent IT Consultant
Cedo Ltd.
- Support and extension of a data warehouse with SQL Server and Power BI.
- Implemented new data pipelines that enable more efficient data processing and reporting, resulting in improved visibility for management.
Independent IT Consultant
Telefónica Germany GmbH
- Backend support for MS SQL Server instances, rollout support of the Telefónica network.
- Automation of worklists for network rollout, which led to a significant increase in efficiency in the database structures used.
Independent IT Consultant
Cedo Ltd.
- Support and extension of a data warehouse with SQL Server and Power BI.
- Implemented new data pipelines that enable more efficient data processing and reporting, resulting in improved visibility for management.
Independent IT Consultant
Dr.Glinz COVIS GmbH
- Database Administration SQL Server 2000 / 2005 / 2008 / 2014.
- Successful maintenance and creation of SSIS packages, documentation of the entire topology of about 40 instances with over 400 databases, consulting and development in all questions related to SSIS, SSRS, SSAS, DTS, and replication.
Independent IT Consultant
ISS Deutschland GmbH
- Mobile data collection and integration with pocket PCs.
Independent IT Consultant
RWE Systems
- Development of various applications for data management and automation (MS Access, SQL Server).
Independent IT Consultant
Envicomp Systemlogistik GmbH
- Programming of management software for waste disposal processes.
Independent IT Consultant
Proenergy Contracting GmbH
- Development of a CRM solution and cost management tool for telecommunications.
Independent IT Consultant
Landesspracheninstitut NRW
- Key management application for visualising an extensive locking system.
Independent IT Consultant
RWE Systems
- Development of user frontends and management systems, implementation of data migrations, postcode database connection (MS Access, Oracle).
Independent IT Consultant
B.U.S. Engineering GmbH / Esso AG
- Development of maintenance databases and hazardous goods registers for the petrochemical industry.
Independent IT Consultant
Folkwang Hochschule Essen
- Porting and development of a student administration software.
Independent IT Consultant
Architectural office
- Development of a time recording software
Summary
Senior IT consultant with over 30 years of experience in database design, data warehouse architecture and database-related development. Extensive knowledge of SQL Server, MS Access and .NET technologies. Expert knowledge in the migration of data assets, interface programming and process optimization for large companies.
Database design and administration: MS SQL Server (all versions), MS Access, data warehouse architecture, SQL Server Data Tools (SSDT) / Visual Studio
Data Integration & ETL: SSIS, SSAS, SSRS, Talend, ETL Processes, PostgreSQL
Application Development: .NET (VB, ASP), VBA, Visual Basic 6.0
Business Intelligence: MS Reporting Services, QlikView, Power BI
Many years of experience in leading and executing database migrations and process optimizations for leading companies in the telecommunications and manufacturing industries.
Build and design complex data warehouse solutions used by large organizations to increase efficiency and reduce costs.
Languages
Similar Freelancers
Discover other experts with similar qualifications and experience