berater profil - IT-Freiberufler Wolfgang Macke

CONSULTANT PROFILE
Personal Details:
Name:
Address:
Telephone private:
Mobile:
Fax:
Email:
Date of birth:
Nationality:
Macke, Wolfgang
Burgunderstraße 1, 35578 Wetzlar, Germany
++49 / 6 44 1 / 44 29 575
++49 / 1 78 / 86 87 94 5
++49 / 6 44 1 / 44 29 574
[email protected]
27. April. 1964
German
Education:
Study:
Diploma in Business Administration (Purchasing & Marketing)
Professional education:
Consultant for application of electronic data processing and network administration
Qualification as IHK (German Chamber of Industry and Commerce) examiner for Operative
Professionals in IT
Qualification as IHK Cert examiner for IT specialists in the fields of Database Development,
and Database Administration
Training:
Local Area Network
TCP/IP protocol
Design & Operation of secure Inter- and Intranets
Internetworking – All about Bridges, Router, Hubs and Switches
Basics of DSS & Data Warehousing
Fast Track Reporting mit MSTR 8.x
DB2 for Win NT – Basics of functions and administration
DB2 for Workstation – functions and administration extension
Data Warehouse - methods and techniques
DB2 - Store Procedures Programming
DB2 – SQL extensions
OS390 / ISPF survey
Efficiency of routines (STP & UDF) and Triggern
DB2 – application programming
Perl
AIX - basics
AIX - 5L System Administration
Linux Serveradministration (SLES11)
PowerPlay – OLAP Analyse Vers. 7.3
Cognos 8 BI Reportbuilding II
Cognos 8 BI Modelling with the Framework Manager I
Cognos 8 BI Modelling with the Framework Manager II
Cognos 8 BI Server Administration
Cognos 8 BI Analyse
Cognos 8 BI OLAP Modelling with the Transformer
Cognos 8 BI Scorcard Applications Developing
Oracle DB 10g Administration I
Oracle DB 10g Administration II
Work experience:
1995
Operating systems:
MS-DOS
WINDOWS 3.x
WINDOWS 9x
WINDOWS NT
WINDOWS 2000
Telemation
Telemation
Telemation
Telemation
MicroStrategy
MicroStrategy
IBM
IBM
IBM
IBM
IBM
IBM
DGD
DGD
Gruber Consulting
IBM
IBM
Ordix
Cognos
Cognos
Cognos
Cognos
Cognos
Cognos
Cognos
Cognos
Oracle
Oracle
Windows XT Prof.
Windows Vista
Windows 7
MVS / TSO
OS390
AIX
Unix (basics)
Linux (SLES 11)
Programming languages:
SQL
PL/SQL
HTML
HTML5
CSS3
JS
jQuery
PHP
Perl (basic knowledge)
JCL (basic knowledge)
Data bases:
IBM DB2 UDB
MySQL
Oracle 8i, 9, 10g & 11g
ACCESS
MS SQL Server
Data Warehouse techniques
F&A for DOS & Win
Teradata (basic knowledge)
Data communication:
ISDN
WINDOWS NT Server
TCP/IP
LAN / WAN Networks
NOVELL (basic knowledge)
Networks:
Win NT 4.0
Novel 3.1
& 4.0
Intranet & Internet
TCP/IP
ISDN
Router
Hubs
Gateways
DNS
Products / Tools:
Corel Draw
Designer
One for All
Page Maker
Paint Shop Pro
SnagIt 32
IBM Accounting
IBM Sales
Sage/KHK company software
Design1
MicroStrategy V 7.1 and 8.x
DSS Agent (MicroStrategy)
DSS Architect (MicroStrategy)
Genio Designer 3.0 (Hummingbird)
PowerDesigner 6.1 (Sybase)
PowerDesigner 7.5 (Sybase)
PowerDesigner 8.0 (Sybase)
PowerPlay 7.3 (Cognos)
ReportNet (Cognos)
DecisionStream (Cognos)
IBM/ Cognos 8.x BI Products
Cubeware
Erwin
Query-Tool
Visual SourceSafe 6.0
SIR-Tool
Ultra Edit-32
Lotus Notes
Mail D
Pegasus Mail
Foreign languages:
English
Branches:
Wholesale and retail business
Telecommunication
Publishing trade
Law Firm
Big Banks
Trade Groups
Airlines
List of projects
07/14 – 10/14
Cognos Developer

Developing a Reporting platform

Consulting

Development of concepts with guidelines

Entwicklung von Framework Manager Modells

Building of Reports with Cognos Report Studio

Building of Filters and Keynumbers

Documentation
Required knowledge:
DB2 V9.7, Cognos V10.1, SQL, TOAD 11.5/12.1
06/14 – 07/14
Developer
PL/SQL Developing
Database Developing (Oracle)
 Database design
 SQL and PL/SQL Developing
 Development of concepts with guidelines
Administration
 Oracle 11R2 Administration
 Oracle 11R2 Tuning
Required knowledge:
Oracle 11R2, Windows 7, PL/SQL Developer, Excel, SQL, TOAD
12/12 – 05/14
Support / Datawarehouse Consultant
Microstrategy Support
 Data Analysis of Reports
 Access and User Management for Microstrategy
 Developing and Tasting from Reports
 Administration Microstrategy
Database Developing
 Databasedesign
 SQL and PL/SQL Developing
Web Developing
 HTML and PHP Developing for Intranet
 Access and User Management for Intranet
 Conception and Test of Webdesign with guidelines
 Test of Webdesign and Applications
 Management of Microstrategy
Administration
 Oracle 11R2
 Apache Webserver
Required knowledge:
Operating system:
Data base systems:
Windows XP, Apache Webserver, Windows 2003 Server
Oracle 11R2, Teradata 12
Tools:
Microstrategy 9.0.2, Windows 7, PL/SQL Developer, , LANDesk,
Teradata SQL Assistant 12.0, MS Visual Studio 2010, DBDesigner,
KeePass 2, HTML, PHP, Excel VB, SQL, VB
01/12 – 08/12
Consulting / Datawarehouse Consultant
Design and Developing with Cognos BI
 Datamodelling with Cognos Framework Manager
 Reportmodelling and Developing with Cognos Report Studio
 Development of concepts with guidelines
 Developing and Tasting from Reports
 Administration Cognos
 Administration from the Oracle 11g
 Developing a BI Database with Oracle 11g
Required knowledge:
Operating system:
Data base systems:
Tools:
06/11 – 08/11
Required knowledge:
Operating system:
Data base systems:
04/11 – 05/11
Required knowledge:
Operating system:
Data base systems:
01/10 – 03/11
Required knowledge:
Operating system:
Data base systems:
Windows XP
Oracle 11g
Cognos 8 BI, Cognos 10 BI
Consulting / Datawarehouseadministration
Administration from Oracle
 Administration from Oracle 10g
 Installation Oracle 11gR2
 Installation Oracle Grid Control
 Dokumentation of the Installation
Oracle Linux 6, Oracle VM, Red Hat Linux 5
Oracle 10g & 11gR2, Oracle Grid Control
Consulting / Datawarehouseadministration
Administration from Oracle
 Administration from Oracle 10g
 Tuning the SQL’s and the DB
 Design and Development of the miror DB
 ETL Developing and Executing the SQL‘s
 SOX Controlling and Dokumentation
Windows XP, Suse Linux Enterprise Server 11
Oracle 10g
Newspaper / Databaseadministration
Administration
 Databasemonitoring and Development from SQL‘s
 Developing from Databases
 Installation from Oracle 11g Server
 Administration from Oracle 10g und 11g
 Design from Databaseconnetions to the Oracle 10g
Windows XP, Suse Linux Enterprise Server 11
Oracle 10g und 11g
01/09 – 12/09
Consulting / Datawarehouse Consultant
Design and Developing with Cognos BI
 Datamodelling and Develloping from Cognos Reports
 Development of concepts with guidelines
 Developing and Tasting from Reports
 Administration Cognos
Installation und Administration from Oracle
 Installation the Oracle 10g Server
 Administration from the Oracle 10g
 Server Patchen
 Developing a BI Database with Oracle 10g
Required knowledge:
Operating system:
Data base systems:
Tools:
Windows XP, Windows 2003 Server
Oracle 10g
Cognos 8 BI,
10/08 – 12/08
Telekommunikation / Cognos Cube Developer
Construction of a reporting system (Cubes)

Checking concept of the business guidelines

Development of Cubes whit Cognos 8 BI

Tasting the Cubes

Development from Reports whit Cognos 8 BI
Required knowledge:
Operating system:
Data base systems:
Tools:
Windows XP
Oracle 10g
Cognos 8 BI
03/08 – 10/08
Telekommunikation / Datawarehouse Consultant
Design and Construction of a reporting system
 Development of concepts with guidelines
 Development from Reports whit Cubeware
 Administration from Cubeware
Installation and Administration from Oracle
 Installation from Oracle 10g and Server Administration
 Migration of the Oracle 9 database to Oracle 10g
Required knowledge:
Operating system:
Data base systems:
Tools:
09/07 – 02/08
Windows XP, Windows Vista, Windows 2003 Server
Oracle 10g
Cubeware
Cognos / 3. Level Support
Support and Helpdesk of the Cognos 8 BI system
 3. Level Support by Phone and Mail
 Development from Reports whit Cognos 8 BI
Installation and Administration from Cognos
 Installation from Cognos 8 BI and Administration
 Migration from the Cognos 8.1 BI to Cognos 8.2 Bi and Cognos 8.3 BI
 Installation of Buck fix’s for Cognos 8 BI
Required knowledge:
Operating system:
Data base systems:
Tools:
02/07 – 08/07
Windows XP, Windows Vista, Windows 2003 Server
Oracle 9 &10g, DB2
Cognos 8 BI
Trading Group / Datawarehouse Consultant
Construction of an ERP-CRM reporting system
 Data modelling and development of database inquiries with Cognos-Framework-Manager
 Design and development of Cognos-ReportNet-Reports
 Administration and deployment of Cognos-ReportNet-Reports
Installation and administration of Oracle
 Installation of 3 Oracle servers und 12 instances
 Patching of the new servers
 Migration of the Oracle 9 database to Oracle 10g
Required knowledge:
Operating system:
Data base systems:
Tools:
10/06 - 12/06
Windows XP, Windows 2003 Server
Oracle 9 & 10g
PowerPlay 7.3 (Cognos), ReportNet (Cognos),
DecisionStream (Cognos)
Trading Group / MicroStrategy developer
In this project complex inquiries and BW evaluations have been developed and realized.
Version 8.0.2 of the tool of MicroStrategy has been used. The database has been further
developed and optimized.
Required knowledge:
Operating system:
Data base systems:
Tools:
04/06 – 09/06
Windows 2000, AS400
DB2
Intelligence Server 8.0.2 (MicroStrategy), Erwin
Software / Database expert for the migration of a database system
In this project the database underlying-to a CRM-system has been migrated from MySQL to
Oracle. In the context of this migration, among others the table indices and the SQLstatements have been adapted and optimized, and triggers have been programmed.
Required knowledge:
Operating system:
Windows XP Prof., SUSE Linux
Data base systems:
09/05 - 03/06:
Oracle, mySQL
Airline / Company Lufthansa Systems; MicroStrategy Administration
In this project, I was in charge of the Administration of the MicroStrategy Data Warehouse
with Version 7.5.x. This entailed the following activities:








Licence controls and supervision
Development of reports
Weekly and monthly reports
Operational reporting
2. Level Support
generation and distribution of reports
Administration
User support and access rights
I was in charge of the smooth operation of the Narrowcast Servers as well. From this server, we
sent several e-mails with reports daily, weekly and monthly, and managed the Web Portal for
the Intranet.
Furthermore, I worked with a TeraData DB V2R5 in which I controlled access rights and
prepared queries in SQL.
I was also in charge of the following tasks:




Required knowledge:
Networks:
Operating system:
Data base systems:
Tools:
01/05 - 08/05:
MetaData backup and version
Load Status controls
General server support
Performance control and debugging in the productive and test systems
Novelle, LAN, WAN, TCP/IP
Windows 2000
Teradata V2R5, MSSQL, Access
Intelligence Server 7.5x (MicroStrategy), Narrowcast Server
(MicroStrategy),
Queryman 6.0, Web Server, Word, Outlook
Stiftung Warentest, Expert’s reports
Stiftung Warentest is a German foundation for independent and objective consumer support by
means of investigation of goods and services.
I visited several training and educational institutes on behalf of Stiftung Warentest and prepared
an analysis of their quality by means of expert talks.
I focussed on training programmes in the field of database development and administration.
I prepared expert reports, evaluating the training institutes and their performance.
Furthermore, I developed and applied statistic instruments for the evaluation of the data and
documents handed in.
Required knowledge:
Operating systems:
Data base systems:
Tools:
01/04 – 12/04
Windows XP Prof, Windows 2000, Windows NT 4.0
Oracle, MySQL, MSSQL, and Access
Paint Shop Pro, Word, Outlook
Software and Database development / Reporting / Acceptance test
The migration from DB2 to Oracle has been realized and filling designs have been created.
The database has been designed and developed. Test data have been created, and checked
and verified in extensive tests. Afterwards inquiries and delta fillings have been developed.
Required knowledge:
Data base systems:
Operating systems:
Tools:
09/03 – 13/03
Oracle 9, DB2
Win NT
Powerdesigner, MicroStrategy, SQL
Whossaler / CC CompuNet & GeCo; data base administration
4 DB2 V8.1 systems were completely new installed. This was done in a step-by-step
documentation.
Furthermore, the new productive databases DB2 V8.1.1 were analysed and optimised, and
afterwards the FixPacks 3 & 4 were installed.
Moreover, I installed and tested the Log Shipping for the system. This was also done in
step-by-step documentation.
I developed, installed and tested a backup concept as well.
Afterwards, in cooperation with the producer (authorized installer), the application ATAQ
was installed and started.
I organized a workshop for the users of the professional departments, where I gave them the
necessary knowledge for the administration of the database.
Required knowledge:
Data base systems:
Networks:
Operating systems:
Tools:
Data:
08/03
DB2 V8.1 Workgroup Server Edition with FixPack 3 & 4
Win2000 Server, LAN, TCP/IP
Windows 2000
ATAQ Risk, DSView, Excel, Word, Outlook
Adresse data, User data, Umsatzdaten, Reuters
Bank / Götzfried AG & Helaba; Schulung / Workshop
Education with the title "Introduction to hierarchical storage management in decentralized
systems (HSM)" and "Storage Area Network (SAN)"
I organized a workshop for the designers of the HSM/SAN to be newly developped, where I
gave them the the necessary knowledge for the administration of the database.
Required knowledge:
Networks:
Operating systems:
Tools:
07/03
LAN, TCP/IP, Internet, Intranet
Windows NT 4.0, Unix und AIX
PowerPoint, Word
Dienstleister/ Götzfried AG & autinform; data base administration
A complete analysis of the productive database DB2 V7.1 and the hardware was done in
documentation.
Furthermore, the new productive database DB2 V8 was analysed and optimized.
Afterwards, the migration of the old DB to the new DB was talked over and a step-by-step
manual was set up.
Also it was designed and build a Backup Concept.
Required knowledge:
Data base systems:
Networks:
Operating systems:
Data:
04/03-06/03:
DB2 V7.1 und V8.x
NT Server, LAN, TCP/IP, IBM Web-Server, Router
Windows NT
Addresses, User Data, Mailing- and Marketing Data
Bank / Götzfried AG & Dresdner Bank; AIX Administration & PHP Programming
Main task was the development of the Front-end application for the Intranet. An NT-Server with DB2,
PHP and webserver was used in the background.
My other tasks were development, analysis and documentation of the database which implied
coordination with the requirements/standards of the different departments.
In addition to these tasks I acquainted myself with the administration of the operating system AIX.
Therefore I installed this system as well as a DB2 database with a webserver on a server.
Required knowledge:
Data base systems:
Networks:
Operating systems:
Tools:
07/01-03/03:
DB2, Access, SQL, PHP 4.0
NT Server 4.0, LAN, TCP/IP, Internet, Intranet
Windows NT 4.0 and AIX
Power Designer 8, Maguma Studio
Bank / Gruber Consulting & Dresdner Bank; Design & Administration of data bases
Main task was the development, analysis and documentation of a support database. Based on that a
DB2 UDB support database on WIN NT4.0 was developed, filled and maintained. This implied
coordination with the requirements/standards of the different departments as well as the development
of the data model with PowerDesigner 7.
Moreover I was responsible for the data modeling, the interface analysis, the mapping and the
definition of rules for filling. Furthermore I cared for the first installation of DB2 UDB on an NT 4.0
Server.
In addition to this new development I created the Front-end application for the Intranet. Therefore I
wrote scripts with HTML and PHP for the inquiry and filling of the support database with web forms.
Moreover I developed select, update and report views for optimization and evaluation of the DB2 data
set.
In a workshop of several days I teached the users in the department how to administer their database. I
developed, prepared and held this workshop.
Required knowledge:
Data base systems:
Networks:
Operating systems:
Tools:
02/01 – 06/01:
DB2, Access, SQL, PHP 4.0
NT Server 4.0, LAN, TCP/IP, Internet, Intranet
Windows NT 4.0 Server and Workstation
Power Designer 7, HTML-Editor, Word, Excel
Bank / Gruber Consulting & Dresdner Bank; data base administration
Main task was the support in the development and maintenance of a Data Warehouse under
MVS/OS390 based upon the data base system DB2.
In addition to that I had to evaluate the running time of the system and to draw up statistics and
performance analyses.
I developed select, update and delete views for optimization and evaluation of the DB2 data base and
the data set.
Furthermore I granted and administered the RACF rights.
I wrote work instructions and manuals which I regularly actualized.
Required knowledge:
Data base systems:
Networks:
Operating systems:
Tools:
Data:
09/00 – 12/00:
DB2, Access, SQL
NT Server, LAN, TCP/IP
OS390, Win NT
Office 97, HostExplorer (Hummingbird)
Securities trade data, address data
Bank / PASS Consulting & MLP-Bank / Development of Data Warehouse
Main task was the support in the development of a new Data Warehouse in the customer’s own
Intranet under HP-Unix with a Client-Server-Architecture-Component based upon the data base
system Oracle 8i. I accomplished the following tasks: data modeling, interface analysis, mapping and
the development of rules fore the filling of the Data Warehouse.
The development was done on a Windows NT 4.0 Server with DB2 UDB 7.1 and after the port had
been set the warehouse was run by the customer on an HP-Unix and Oracle 8i system.
I developed and defined select, update and insert SQL’s and procedures for the filling, modifying,
adaptation and optimization of the DB2- and Oracle database and the data set in the Data Warehouse.
In close coordination with the customer I defined and realized standards for the acquiring of the
interfaces of Kordoba and Atos.
Required knowledge:
Data base systems:
Networks:
Operating system:
Tools:
Interfaces:
Data:
05/99 – 07/00:
DB2 UDB 7.1, Oracle 8i, Access
Windows NT 4.0 Server, Internet and LAN
Windows NT 4.0 Workstation, HP-Unix
PowerDesigner 6.1 (Sybase), Visual SourceSafe 6.0, Office 97,
Ultra Edit –32 6.0, Transfer Manager
Kordoba (bank data), ATOS (credit cards data)
Open account business data, credit cards clearing data,
address data
Bank / Parity EuroSoft & Deutsche Bank; Data base administration and Development of Data
Warehouse
Main task in this project was the support in the modification and development of a Data Warehouse
under Win NT with a Client-Server-Architecture based upon the data base system DB2.
For this Data Warehouse the running time of the single processes had to be evaluated and performance
analyses had to be carried out. Based on these analyses process modifications and performance
adaptations have been worked out.
Moreover I had to define and develop select, update and delete views (Spufis) for the filling,
modification and optimization of the DB2 data base.
Simultaneously with these tasks I wrote a complete documentation.
Required knowledge:
Data base systems:
Networks:
Operating system:
Tools:
DB2, Access, SQL
NT Server, LAN, TCP/IP
Win NT
Genio Designer 3.0, DSS Agent ( MicroStrategy),
DSS Architect ( MicroStrategy), SnagIt 32, Lotus Notes, Excel,
Data:
05/97 - 04/99:
Word
Refinancing data, merchant banking data, address data
Administrative agency / AC & Telecom; IT Consultant
Main task was the support in the modification and development of a new Mainframe-Architecture
under MVS/TSO with a Client-Server-Architecture-Component based upon the data base system DB2.
In addition to that I had to evaluate the running time of the single processes and to draw up statistics
on process cancels and performance analyses. Furthermore: development of select, update and delete
views (Spufis) and jobs for the optimization of the DB2 database and the data set.
Standards for the acquiring of pre-systems and consecutive systems have been defined in cooperation
with the customer and put into practice in cooperation with the software developers. I also worked in
close cooperation with the customer’s end control service.
Required knowledge:
Data base systems:
Networks:
Operating systems:
Tools:
Data:
DB2, Access, SQL
NT Server, Novel, LAN, WAN, TCP/IP
Win 3x, Win 95, Win NT, MVS/TSO, Unix
SIR-Tool, GW-Tel, Mail D, Pegasus Mail, Excel, Word, PWW,
Design1, Query-Tool
Billing data, address data