Résumé - alexander jahn consulting

Résumé











Leading Teams
Project Management
Teaching IT - Courses
MS SQL Server Administration and
Programming
Development of Concepts for MS
SQL Server Environments
MS SQL Server Reporting Services
MS SQL Server Integration Services
MS SQL Server Migrations
Development of T-SQL Scripts
MYSQL Server Administration and
Programming
Networkadministration
ajcon – alexander jahn Consulting
Professional Priorities
ajcon – alexander jahn Consulting
Main Practical Focus:











Managing Teams
Project Management
Teaching IT - Courses
MS SQL Server Programming
Development of Concepts for MS SQL Server
Environments
MS SQL Server Reporting Services
MS SQL Server Integration Services
MS SQL Server Migrations
Development von T-SQL Scripts
MYSQL Server Administration and Programming
Networkadministration
Personal Data
AJCON – ID
1
Last Name
Jahn
Firstname
A.
Availability
01.02.2016
Availability On-site
90 %
Last update
30.11.2015
Year of Birth
1968
Address
Vaihingerstraße 24
71063 Sindelfingen
Privat Phone Number
+49 7031 87 94 02
Mobil Phone Number
+49 1727672458
Fax
+49 7031 79433 - 25
E-Mail
[email protected]
Foreign Languages
Englisch (good, Project safety)
Locations
Germany/Switzerland/Austria
Preferred Location
Near Stuttgart
Preferred Contract type
Contract
Salary per year in Euro
depends
Salary per hour in Euro
depends
Graduation
School
College/University
Industrial Training
Expert Knowledge
Beraterprofil Stand April 2015
General Certificate of Secondary Education (1987)
Bachelor of Business Administration (especially ITTechnology (1993)
Commercial Education in Wholesale and Export Trades
(1990)
MCSE / MCT ( 2015 ) / MCITP (seit 2006 ) (1996)
Seite 1
Lock Flag
Lock Flag:
I already had contact to the following customers:












…
Microsoft Germany Ltd.
IBM Germany Ltd.
Bosch Ltd. Stuttgart, Munic, India, Singapore, USA,
France
Philip Morris Ltd. Germany
GFN AG,
Deutsche Telekom AG,
Digicomp Academy AG (Switzerland)
WALA Ltd.
Coca – Cola Ltd. Germany
KNV / KNO (Stuttgart)
LIDL Stiftung and Kaufland
State of Knowledge
Standardsoftware
MS-Office, Adobe Reader
Special Software
UC4, Remedy, Mediastar, Datext , TSM/TDP (IBM)
Programming Languages
Legend State of Knowledge
Years
1 - Training,
2 – Practical Experience
3 – Experience for many years
4 - Expert
RPG / 400
2
3
Cobol
2
3
Application Programs
Years
State of Knowledge
Symantec Norton Antivirus
2
3
Years
State of Knowledge
Microsoft SQL Server 6.x
19
4
Microsoft SQL Server 2000
15
4
Microsoft SQL Server 2005
10
4
Microsoft SQL Server 2008/2008 R2
8
4
Microsoft SQL Server 2012 / 2014
4
4
MYSQL 3.23 - today
10
4
Years
State of Knowledge
Microsoft Windows NT 4.0
19
4
Microsoft Windows 2000 Server
Microsoft Small Business Server
2003/2008/2012
MS Windows 2003/2008 Server /R2
15
4
12
4
12 /8
4
4
4
Databases
Operating Systems
MS Windows Server 2012/R2
Beraterprofil Stand April 2015
Seite 2
Desktop Operating
Systems
Years
State of Knowledge
2
3
11
4
12 /9
4
9
4
2 - 10
4
Network Protocols
Years
State of Knowledge
TCP/IP Version 4 and 6
16
4
Years
State of Knowledge
ADSL
12
4
WLAN
10
4
RDP
10
3
Microsoft Terminal Services
10
4
Citrix Metaframe
5
3
VPN
10
3
Network Systems
Years
State of Knowledge
Suse Linux 9.x and higher
10
4 - 18
2
4
Years
State of Knowledge
18
18
18
18
10
4
4
4
4
4
Suse Linux 9.x
Microsoft Windows for
Workgroups 3.11
Microsoft Windows 95 / 98
Microsoft Windows NT
Workstation 4.0
Microsoft Windows
XP/Vista/7/8/8.1
Communication
Technologies
Knowledge as IT Administrator
Windows NT 4.0 – Windows 10
Windows Server 2000 – 2012 R2
Functions
Administration / Support
Consulting
IT - Training
Team – Management
Project – Management
Beraterprofil Stand April 2015
Seite 3
Main Practical Focus
Software
Windows XP / Windows 7 /
Windows 8 / Windows Server
2008 R2 / 2012
Microsoft SQL Server 2008 R2 /
2012/R2 / 2014
Microsoft SQL Server Reporting
Services
Microsoft SQL Server Integration
Services
Network Administration
Hardware / OEM
Description
Planning , Realization , Administration, Support, Optimization
Administration, Migration, Powershell-,T-SQL-Programming
Administration, Programming, Designing Business Reports
ETL – Programming
Active Directory, DNS – Server, DHCP – Server, Developing Concepts,
First, Second – and Third – Level Support
Years
State of Knowledge
12
4
12
4
11
4
Years
State of Knowledge
Government Agencies
Automotiv
Financial Industry
Software Manufacturer
10
10
8
8
4
4
4
4
Telecommunication
10
4
Electronic Industry
8
3
Energy Suppliers
5
3
Tobacco Industry
6
4
Shipping Supplier
8
3
Metall Industry
16
4
IT - Trainings
18
4
IBM Workstation / Thinkpad
Network Printer (Kyocera, OKI,
IBM,HP)
HP / Compaq Server /
Workstation
Industries
Beraterprofil Stand April 2015
Seite 4
Projects
Workings
Nr.0
Lidl Stiftung / Microsoft
Ltd.
Installation and Migration of MS SQL Server
Writing Concepts, Programming Powershell Scripts
Period:
01/2015 – 04/2015
Industry:
Food Industry
Description:




Hardware:
Unattended Installation (even Cluster)
Writing Concepts
Administration of MS SQL Server
Monitoring and Performance Optimizing of the Database systems
(MS SQL Server and MYSQL)
 Network Optimizing
 Writing Powershell and T-SQL – Scripts
 Creating Manuals for the Installation and Migration of MS SQL
Server Systems for the International Team
 Developing of Learning Videos
 Coordinate the communication between the different Teams
(Network, Operating System and Database)
Dell, Netapp
Software:






Nr.1
UBS (Zürich)
Installation and Migration MS SQL Server
Writing Concepts and Network Planning
Period:
10/2014 – 03/2015
Industry:
Financial Industry (Bank) (Switzerland)
Description:









Microsoft Windows Server 2008 R2 Standard
Microsoft SQL Server 2005- 2012 Standard and Enterprise
Windows 7 and Windows XP
Office 2007 - 2013
Windows Server 2012 /R2,
Sharepoint, Lumension Server…
Unattended Installation (even Cluster)
Writing Concepts
Administration of MS SQL Server
Monitoring and Performance Optimizing of the Database systems
(MS SQL Server and MYSQL)
Network Optimizing
Writing Powershell- and T-SQL – Skripts
Creating Manuals for the Installation and Migration of MS SQL
Server Systems for the International Team
Developing of Learning Videos
Coordinate the communication between the different Teams
(Network, Operating System and Database)
Hardware:
IBM, Lenovo, Netapp, Hewlett-Packard, Dell, Fujitsu Siemens
Software:







Beraterprofil Stand April 2015
Microsoft Windows Server 2008 R2 Standard
Microsoft SQL Server 2008 Standard and Enterprise
Windows 7 and Windows XP
Office 2007 and 2010
Windows 8/8.1
Windows Server 2012,
Symantec, Sophos, Microsoft Forefront
Seite 5
Nr.2
IBM Deutschland Ltd.
Installing MS SQL Server
MS SQL Server High Availability
Writing Concepts
Networkadministration
Period:
07/2013 – 09/2014
Industry:
Financial Industry/Soft – and Hardware Manufacturer
Description:






Unattended Installation of Microsoft Client – and Server
Operating Systems
Unattended Installation of Microsoft SQL Server
Implementation of High Availability Solutions for MS SQL Server
(AlwaysOn, Cluster, Database – Mirroring)
Writing Concepts
Developing T-SQL Scripts
Administration of MS SQL Server
Hardware:
IBM, Lenovo
Software:







Nr.3
Microsoft Ltd.
Migration, Administration and Writing Concepts
MS SQL Server Environment, Networkbetreuung
Period:
09/2012 - Today
Industry:
Government Agency / Software Manufacturer
Description:




Microsoft Windows Server 2008 R2 Standard
Microsoft SQL Server 2008 Standard and Enterprise
Windows 7 and Windows XP
Office 2007 and 2010
Windows 8/8.1
Windows Server 2012,
Symantec, Sophos, Microsoft Forefront
Migration of MS SQL Server 2005 to MS SQL Server 2008 / R2
Unattended Installation (even Cluster)
Writing Concepts and T-SQL Scripts
Administration of MS SQL Server
Network Support (AD,DNS,DHCP), Virtual Environment
Hardware:
HP, DELL, Lenovo
Software:





Beraterprofil Stand April 2015
Microsoft Windows Server 2008/R2 Standard and Enterprise
Microsoft SQL Server 2008/R2 Standard and Enterprise
Windows 7/8, Windows XP
Office 2207 / 2010
Windows Server 2012/R2
Seite 6
Nr.4
Bosch Ltd.
Migration of Microsoft SQL Server 2005 to Microsoft SQL
Server 2008 R2 /2008 R2
Period:
04 / 2011 – 06/2012
Industry:
Automotive
Description:




Migration of MS SQL Server 2005 to MS SQL Server 2008 / R2
approximately 1000 Servers and more than 4000 Databases
Writing complex T-SQL Scripts for the unattended Migration of
whole MS SQL Server Systems or just a few Databases
Administration, Monitoring and Installation of MS SQL Server
Coordination of the International Team
Hardware:
HP / IBM Server / SAN – Storage EMC and IBM XIV
Software:



Nr.5
Microsoft Windows Server 2008 R2 Standard, Enterprise
Microsoft SQL Server 2008 Standard and Enterprise
Windows 7,Windows XP
Migration Microsoft Windows XP auf Microsoft Windows 7.
Unattended Installation (500 Computer Systems). MS WUS
installed
Period:
02.01.2010 – 03/2011
Industry:
Automotiv
Description:

Hardware:
HP Server, SAN – Storage (HP – EVA)
Software:
Microsoft Windows Server 2008 R2 Standard and Enterprise,
Microsoft SQL Server 2008 Standard and Enterprise, Windows 7
Professional, Windows 7 Ultimate, Windows XP pro
Beraterprofil Stand April 2015
Migration of Client and Server Operating Systems and continuous
Support
Seite 7
Nr.6
Shipping Supplier
Microsoft SQL Server 2008 Migrations of 2005. Server
Maintenance SQL 2008 (continuous). Reporting Services
Solutions implemented. ETL Programming
Period:
01.06.2009 – 31.12.2009
Industry:
Automotiv
Description:

Hardware:
IBM x3400 Server inkl. Server RAID 5
Software:
Microsoft Windows Server 2008 Standard, Microsoft SQL Server 2008
Enterprise
Nr.7
Wilhelm Thome Ltd.
Microsoft SQL Server 2005 Database Administration and
Implement Microsoft Dynamics NAV, Network Administration
Period:
1996 - 2013
Industry:
Automotiv
Description:





Hardware:
IBM x3400 Server inkl. Server RAID 5
Software:
Microsoft Windows Server 2003 Standard, Microsoft SQL Server 2005
Standard
Nr.8
Deutsche Telekom AG
Microsoft SQL Server 2005 System Analysis and Performance
Optimizing
Period:
16.07.2007 – 20.07.2007
Industry:
Telecommunication (Enterprise Company)
Description:






Hardware:
Software:
Beraterprofil Stand April 2015
MS SQL Server Support
(First-, Second – and Third – Level Support)
Administration of MS SQL Server Systems
Administration of MS Dynamics NAV
Network Support (Active Directory, DNS, DHCP)
Network Planning, Migrations (Active Directory, DNS)
Planning and Installation of Microsoft Client – and Server
Operating Systems
Analyze the existing Database System
Configuration and Evaluating the planned Cluster Solution of
Microsoft SQL Server 2005
Performance Optimizing of the Application with MS SQL Server
Profiler
Optimization of T-SQL Queries
Problem Analysis with in the Application of the customer
Network Optimization in conjunction with MS SQL Server
Fujitsu Siemens Server (old) / Fujitsu Siemens Server (new ) Cluster
Solution
Microsoft Windows Server 2003 Enterprise, Microsoft SQL Server
2005
Seite 8
Nr.9
Microsoft SQL Server 2005 System Analysis and Performance
Optimization, Network Administration
Period:
09.07.2007 – 13.07.2008
Industry:
Shipping Supplier
Description:



Hardware:
Fujitsu Siemens Server (old) / Fujitsu Siemens Server (new )
Clusterlösung
Software:
Microsoft Windows Server 2003 Enterprise, Microsoft SQL Server
2005 Enterprise Edition
System Analysis and Configuration of MS SQL Server
Evaluate the planned Cluster Solution with SQL Server 2005
Performance Optimizing
Nr.10
Microsoft SQL Server 2005 Database Mirroring (High
Availability)
Period:
01.01.2007 – 2012
Industry:
Automotiv
Description:



Software:
Microsoft Windows Server 2003 Enterprise, Microsoft SQL Server
2005 Enterprise Edition
Installation of Microsoft SQL Server 20xx Standard Edition
Installation of Microsoft Dynamics NAV
Continuous Support for MS SQL Server
Nr.11
Microsoft SQL Server 2005 Database Mirroring (High
Availability)
Period:
21.05.2007 – 25.05.2007
Industry:
Shipping Supplier
Description:

Software:
Microsoft Windows Server 2003 Enterprise, Microsoft SQL Server
2005 Enterprise Edition
Beraterprofil Stand April 2015
Implementing of a High Availability Solution with Database
Mirroring for 1 Location and 5 Databases
Seite 9
Nr.12
Microsoft SQL Server 2005 Database Mirroring ( High
Availability )
Period:
06.11.2006 – 10.11.2006
Industry:
Tobacco Industry (Enterprise Company)
Description:

Software:
Microsoft Windows Server 2003 Enterprise, Microsoft SQL Server
2005 Enterprise Edition
Implementation of Database Mirroring for 3 Locations with 6
Databases
Nr.13
Microsoft Windows Network Administration
Project Planning
Period:
01.01.2005 – 05.01.2005
Industry/Firma:
Medical Industry
Description:
Implementation of the whole IT – Equipment/Environment for a
Medical Practice
Nr.14
Continuous IT - Service
(MS Windows / MS SQL Server)
Period:
02.08.1996 - 2012
Industry/Firma:
Automotive
Description:










Beraterprofil Stand April 2015
Network Support of a Microsoft Windows 2000 Network
Support for Navision XAL
Support for Microsoft Exchange Server 2000
Implementation of different PDAs (Qtec, Palm, Nokia
Communicator)
Integration of a WIFI - Solution
Support for a CNC – Laser Machine
Connecting the Companies Network with the Internet (DSL)
Installation and Configuration of a CISCO Router and a
Cisco Firewall PIX 506e
Implementing a VPN - Solution
Migration of Windows 2000 to Windows 2003
Seite 10
Nr.15
Writing and Developing of Training Materials
Period:
01.04.2002 – 30.04.2002
Industry/Firma:
IT
Description:


Writing and Developing of Training Materials for the Companies
Software „TEDIS“ based on Microsoft SQL Server 2000
Training of the Companies Employees for the Software „TEDIS“
Hardware
IBM Server
Software:
Microsoft Windows 2000 Server / Microsoft SQL Server 2000
Nr.16
TeleCash Ltd.
Network and Datenbase Administration
Period:
01.10.1997 – 30.10.2001
Industry/Firma:
Financial Industry (Bank)
Description:









Administration of an AS 400 with the Operating System OS 400
Network Design of the new Windows 2000 Network
Database Administration of MS SQL Server 6.5/7.0/2000
Administration of MS Exchange 5.5
Network Support for MS Windows NT 4.0 / 2000
First, Second & Third Level Support
Installation of Hardware (all Components)
Implementation of the Companies User Helpdesk
Migration from Windows NT 4.0 to Windows 2000
Nr.17
Network Administration
Period:
01.06.1996 – 30.08.2000
Industry/Firma:
Fitness – Industry
Description:





Network Support for MS Windows 95
MS Windows NT 4.0 Server
Hardware Installations
Implementation of the Member Access via chip card
Support for the Software for the Member Administration “Hector”
(MS Access – Database Application)
Hardware





PC-Systems
Server
Networkprinter
Network - Cards
Chip Card Reader
Beraterprofil Stand April 2015
Seite 11
Nr.18
Network Administration
Period:
01.06.1997 – 01.09.1997
Industry/Firma:
IT
Description:
First Level – and Second Level Support within a heterogeneous
Network (Unix, Novell, Microsoft Windows 95 / NT 4.0)
Beraterprofil Stand April 2015
Seite 12
Additional
Delivered Courses since 1996
*MOC-Course=
This Seminar will be taught with
original Course Materials
Implementation and Administration of Microsoft Windows 95
(MOC-Copurse)*
Administration of Microsoft Windows NT 4.0 Server ( MOC-Course) *
Configuration and Installation of Microsoft Windows NT 4.0
( MOC
– Course ) *
Microsoft Windows NT 4.0 Server in the Enterprise (Enterprise)( MOC
– Course ) *
Administration of Microsoft SQL Server 6.0 – 2012 ( MOC – Course ) *
Implementation and Database Design of Microsoft SQL – Server 7.0 –
2012 ( MOC – Course ) *
Internetworking with TCP / IP on MS Windows 3.51 - 2012( MOC –
Course ) *
Network Basics (Network Technologies / Windows 7+8 /
Windows Server 2008 R2 / 2012)
Many 1 –2 Day User Trainings for MS Windows 3.51 – MS Windows
7/8 or Windows Server 2008 R2/2012
Many Company Trainings for Microsoft SQL Server 6.5 – 2014
(Administration, Programming and Querying of Databases with SQL
MYSQL Administration and MYSQL Programming
Microsoft Windows Server 2003 / 2008 / 2008 R2 sämtliche MOC
Kurse / 2012
Microsoft SQL Server 2005 / 2008 R2 (MOC 2780/2779) / 2012
Microsoft SQL Server 2008 / 2008 R2 (MOC 6231/6231) / 2012
Microsoft SQL Server 2012 (all MOC Seminars)
Microsoft SQL Server Reporting Services 2005/2008/2008 R2/2012
Microsoft SQL Server Integration Services 2005/2008/2008 R2/2012
Microsoft Windows 7 / 8 (sämtliche Seminare)
Schreiben von SQL Abfragen auf einem Oracle Server mit Hilfe des
Tools PL/SQL Developer
Trainings Centers
These Trainings had been
taught at the listed Trainings
Centers
GFN AG (Stuttgart - Vaihingen)
Digicomp Academy AG (different Locations in Switzerland)
PC College (Stuttgart)
NT + C Networktraining Ltd. (Stuttgart)
AJCON e.K. (since 01.06.2010 own Classrooms)
Microsoft Deutschland Ltd.
Beraterprofil Stand April 2015
Seite 13