JOCHEN RIESEBERG
EXPERT DATABASE SYSTEMS
- database design
- administration
- application development
- training
- support
EXAMPLE 2023/24
Cedo Ltd Telford UK
Project: SQL Server
Software: MS SQL Server Features SSIS, Word
Task: Support for extensions to a data warehouse, handbook
EXAMPLE 2023/24
Cedo Ltd Telford UK
Project: SQL Server
Software: MS SQL Server Features SSIS, Word
Task: Support for extensions to a data warehouse, handbook
EXAMPLE 2023/24
Mi-Hub Polska Z o.o.
Project: MS SQL Server
Software: MS SQL Server, SSIS, SSMS
Task: SQL Server administration tasks and improvements to the current
current reporting system (MIS)
EXAMPLE 2022/23
Telefonica
Project: Support backend
Software: MS SQL Server, SSIS, SSAS
Task: Detailed concept & development of automatically provided work lists for support
Rollout of the Telefónica network
EXAMPLE 2021
Einhaus Group Ltd
Project: SQL Server
Software: MS SQL Server Features
Task: Cleaning up the server landscape - creating a concept for maintenance
EXAMPLE 2020
Cedo ltd Telford UK
Project: Development of a SQL Server Data Warehouse
Software: MS SQL Server, Oracle, Qlikview
Task: Creation of a database for various cubes of the new data warehouse according to customer requirements
EXAMPLE 2018/2019
TOMRA Systems GmbH
Project: order management
Software: MS Access
Task: Creation of complex order management from previous version Excel, training of employees
EXAMPLE 2018/2019
TGIS IT Department
Project: Operation of SQL Server databases / relocation of data center
Software: MS SQL Server 2017
Task: Advice and support
EXAMPLE 2017
Dr. Glinz COVIS GmbH
Project: SQL Server 2000/2005/2008/2014
Software: Visual Studio, SSAS, SSIS, SSRS, DTS
Task: Administration of SQL Server 2000/2005/2008/2014 –Cluster for Deutsche Post, maintenance and creation of SSIS packages, documentation of the entire topology of around 100 instances with over 600 databases, advice and development on all questions related to SSIS , SSRS, SSAS, DTS, replication.
EXAMPLE 2017
ZERO Lack GmbH & Co.KG
Support and advice on MS-Access / Excel VBA programming and Microsoft SQL Server
EXAMPLE 2014 (MAINTENANCE CONTRACT)
CeDo Ltd. Telford, UK
Project: SQL Server 2005 / QlikView 8
Software: MS Visual Studio 2005, QlikView 7, WSH, SQl Server 2005,
SSIS / SSAS / Reporting, MS Excel 2003, MS Access 2003
Task: Administration of SQL Server 2005, maintenance and creation of SSIS packages,
Database tuning, tuning and creation of stored procedures, triggers
and indexes, creation of a library of useful SQL scripts,
Concept creation for rebuilding the server, testing and new installation
all DWH features, optimization of loading and reporting processes,
Reporting Services, Analysis Services, Database Engine Tuning Advisor
Scripting with QlikView 8, introduction to code management.
Language in the project mainly English, all correspondence in English.
CONSULTING 2007
Proenergy Contracting GmbH & Co. KG Bochum
Project: Product hardware / software plant technology
Task: Management / moderation of a workshop to create a
Specifications for a complex system of hardware and
Software with all employees involved
SUPPORT 2007
Bosch AG Stuttgart
Migration of SQL Server 2000 to 2005
Task: Creation of DTS packages, scripts and reports, performance optimizations
With Integration Services, Reporting Services, Database Engine Tuning Advisor
Coaching of employees
OTHER PROJECTS
Many other projects in my CV since 1994, references:
Project programming accounting software waste disposal industry, 01/06 - 02/07
Reference by managing director, Envicomp Systemlogistik GmbH & Co KG, from March 9th, 2007
"The cooperation with the consultant was fundamentally characterized by
an above-average commitment combined with a high level
of independence. The consultant's existing know-how led
for a quick and competent realization of the tasks addressed to him.
It is particularly positive that he is in
integrated the existing team very well. "
Project planning network administration / training rooms since 1996
Reference by head of administration of a language institute with 40 employees 29.03.00
"The consultant has been providing us with competent advice in the areas for several years
IT procurement, office applications and databases as well as our entire
network planning. He is currently working on general administration
of our NT networks and checkup of our backup system with commissioning
of our administration network after building renovation / relocation of the administration. "
Project MS Access programming, Nov / 99 to March / 00
Reference by project manager of a software company with more than 700 employees. v. April 6th
"The consultant fit perfectly into our team and made us successful
in the time-critical programming of a complex sales solution that
largest German energy supplier is used throughout the group. We
would be happy to work with him on a project again soon. "
All references are confirmed by GULP.
Selection of the most important customers since 1994
CUSTOMERS
DR.GLINZ COVIS GMBH
ZERO LACK GMBH & CO. KG
CEDO FOLIEN AND HOUSEHOLD PRODUCTS GMBH
PROENERGY CONTRACTING GMBH & CO. KG BOCHUM
BOSCH AG STUTTGART
ENVICOMP SYSTEMLOGISTIK GMBH & CO KG
RWE ENERGY
ISS GERMANY GMBH
STATE LANGUAGE INSTITUTE NRW BOCHUM (STATE-OWNED)
FOLKWANG UNIVERSITY EAT
ABOUT ME
resume
I gave up my beloved parachuting sport a few years ago and now I just annoy my friends and children with stories about veterans. Back to my roots - today I console myself with yachting under motor and sail, competitive shooting, and my sport CrossFit keeps me healthy.
After studying naval engineering and working as a designer for several years, I use the knowledge I have acquired over many years as a freelance IT consultant.
My experience in IT goes back to the punch card printer, the first halfway programmable calculator and the delight of seeing the first color monitor.
Today it's mainly about database projects, preferably with Microsoft SQL Server and MS Access
