Senior Software Consultant, Senior Data Warehouse Specialist, Consultant in DataBase Marketing

company in Cologne (a company of the Talanx Group ca. 15 thousand members in
staff)
Discussion and Evaluation of business requirements with in-House-Clients.
Transformation into an architecture which is both for IT and business teams
understandable. Presentation, communication, and negotiation of Architecture.
In a client-focused Data-Warehouse I was responsible for programming of
premium and claims data for several years into Staging Area and Star Schema
with DataStage and thereafter the same for regular monthly updates.
Thereafter I made up a concept for the Automation of the monthly loading
processes in this project and supervised its programming process. We succeeded
in reducing the monthly manual input for job preparation, administration and
testing from 24 man-days down to 4 man-days per month.
Appling the same Automation Framework to other In-House-Data Warehouses by
generalizing processes. One of them was using SAS Base and SAS processes were
atomized. In the SAS-DWH the monthly workload was reduced from 20 man-days
which were provided by an external company down to 2 man-days for internal
employees.
Team-Lead of 5 persons in the evaluation phase of a DataMart for Solvency-II-
purposes. Focus was several operations claims databases. Compatibility of Data,




Quality checks (using IBM Profile Stage), Analyses, Discussion with end-users and
Data providers, and compiling the business requirements into a document.
Concept, Design and Programming of an application for 8 world-wide subsidiaries
for to transfer monthly claims-, policy- and premium-data in an XML-File. The
transfer before was by MS-Excel-Files, which made a lot of trouble by loading
them into a SAS-DWH (SAS is not to blame) the local DB is now MS-Access. The
system was realized with VBA. By this we succeed in reducing the time for loading
from 2 man-days down to 2 hours. Beside this the technical quality rose also.
Set-up of an ad hoc-Data-Warehouse for Fusion purposes. Concept, Design of
Data models, Compiling Business requirement, programming with SQL and
DataStage, Set-up of Universes in Business Object.

company with a staff of 15 people working as close partner of Ardent (DataStage)
and Seagate Software (Chrystal) supporting the Consultancy Staff of those companies
with their manpower)
I was responsible both for pre-sales and post-sales Consultancy. Through my
experience in the post-sales sector I had a deep knowledge of the Tools. That was
a good advantage for my pre-sales activities. I was involved in many proof of
concepts (POC) which I helped to win for a product purchase. The Clients were
fascinated by my good understanding of their business processes, my clientorientation,
and my presentation skills.
In several post-sales engagements, I was responsible for the Design of Databases
and for the Architecture of the Data Warehouse and its filling processes.
Most of the DataStage-Projects I was sent to were start-up-projects, so
Sensitizations for programming standards and working standards and for a
Documentation of tasks was important for successfully running projects.