IT- Project Manager,
Business Analyst,
Senior Consultant

Personal:

Date of birth: 05/13/1967
Civil status: married

Contact:

You & MeDia UG
CEO & Freelancer
Birkenweg 21
DE 37079 Göttingen
Mobil: +49 171 5371025
Mail: a.friedrichs@youand.media

Qualifications & Certificates:

• from 2020: ITIL® 4 Foundation
• from 2007: CIC (IHK) certificate to instruct apprentices as IT experts (with specialization in system integration); successfully taught two apprentices so far, last in 11/2016
• from 2000 until 2003: Microsoft Certified Trainer (MCT)
• from 2000: Certified Trainer HP-Education
• from 1999: Microsoft Certified Systems Engineer (MCSE)
• from 1995: State-certified IT Assistant / specialization in software technology, final grade: 1.4 (out of 6 possible grades, 1 being the best)

Skills & Roles

Hard Skills & Experience in the following Roles:

• Project Manager (IT & Media) – traditional, agile and hybrid methods.
• Tools: Atlassian Jira (Kanban & Scrum) & MS Project (traditional) & others
• Business Analyst & Technical Coordinator (IT & Technical Production Environments / MES)
• Architect & Engineer (IT Infrastructure)
• Windows Scripting (WSH, PowerShell, Batch)
• Trainer & Coach (IT, Business Development, Crisis- and Risk Management)
• Project Team Member as well as Team Leader

Soft Skills:

• Team player
• Goal-oriented & resilient
• Thinking economically and business-focused
• Quick grasp
• Communicative & ability to inspire others
• International experiences, also on site, e.g. Canada, Romania, Russia and others
• Experience in crisis and risk management
• Autodidact & self-taught on new technologies, topics and challenges

Typical Tasks:

• Transition and migration project planning and management
• Analyzation and optimization of IT Compliance-policies and -processes
• Coordination of requirements between business and IT as Business Analyst
• Planning and implementing Microsoft infrastructures, Active Directory, TCP/IP-services and Office 365-services
• Conception and implementation of directory services migration, also heterogeneous (e.g. eDirectory into Active Directory), automatization through Scripting
• Planning and rollout of Group Policy Objects (GPO)
• Microsoft SQL Server Infrastructures & Database Design

Typical Customers:

• High Tech & Automotive
• Research and Development
• Factories and MES Environments
• Banks & Financial Services
• Authorities and Civil Service

Language Skills:

• German: native speaker
• English: fluent
• French: basic

Other Interrests:

• My family, our five kids and our young labrador retriever
• Composing and producing music, playing concerts
• Exchange of ideas with other entrepreneurs
• Everything that has to do with technology
• Publishing books

Excerpt of Projects (with References):

Since 2022 Police authority at state level (anonymized), in cooperation with Group24 AG: connect criminal investigation office of another federal state to the infrastructure and services. Further development of ITSM service reporting and definition of corresponding KPIs. Planning and further development of the Microsoft SQL Server infrastructure, especially with regard to high availability, performance and operational integration. Switching the MS SQL and Sharepoint Services backup processes to Veeam Agent Backup. Coordination of the connection of the project platform to the existing central “One Identity” infrastructure for Active Directory administration (IAM). Contact: on request

2020-2022 Police authority at state level (anonymized), in cooperation with Computer Futures & Sepago GmbH: definition and introduction of ITSM processes for an isolated high-security environment, selection and evaluation of various ITSM tools and coordination of the implementation according to ITIL 4, starting with the PoC through the piloting to production. The tasks also included developing and performing monthly service level reporting. In addition, the operating team received conceptual and practical support in the ActiveDirectory and MS SQL Server environments. For the internal training platform, training videos on various technical topics were produced on own responsibility. Contact: on request

2019-2020 Veoneer, Munich (automotive electronics & software), in cooperation with Etengo & Gulp: Project management of the international migration from Microsoft Skype for Business to Microsoft Teams. The scope included the cloud-based services within MS Office 365 as well as connected locations with local hardware for voice telephony. In addition to managing the team and calculating project costs, coordination with the legal department and the works council on data protection aspects, including negotiating the approvals of critical features was also part of the task. Missing processes for approvals and service management also had to be developed. Contact: on request

2019-2020 Veoneer, Munich (automotive electronics & software), in cooperation with Etengo & Gulp: True-Up of Microsoft licenses used in the company and support of the customer license team preparing a new Microsoft Enterprise Agreement. In addition, the creation of migration- and license databases and the programming of scripts under Powershell and MS SQL for data collection and consolidation were part of the task (MS SCCM, Active Directory and others). Contact: on request

2018-2019 Veoneer, Munich (automotive electronics & software), in cooperation with Etengo & Gulp: Business analyst, technical coordinator and interim project manager for the conception and implementation of the technical split after the company spin-off regarding the migration of approx. 2000 production systems, especially production-critical MS Windows based MES control systems. The activities of the international locations in Canada, USA, Europe and Asia had to be synchronized with each other and downtimes had to be kept short. The use cases of the production sites had to be converted into technical solutions within the target environment. This essentially included the creation of an Active Directory role and delegation model, migration steering and the provision of production related IT services. Contact: on request

2017-2018 heger.IT Solutions, Hann. Münden, joint support- and advisory services for selected medium-sized businesses in the field of data protection (GDPR), external data security officer for several customers. Various open lectures on the subject of GDPR were also held. Contact: on request

2016-2017 JAKALE Film GmbH & Co. KG, Kassel, development and implementation of storage solutions for storing and securing cinema movies, including developing a security concept for camera date in compliance with processes and policies for data storage demanded by film insurance companies for this industry. In addition, a concept for restructuring the internal IT was developed, which combines the technologies Microsoft O365, FreeNAS and Avid Nexis Server within the framework of the required workflows and access requirements (role model). Contact: on request

2007-2016 Commerzbank AG, Frankfurt a.M., in cooperation with Hewlett Packard GmbH, Wolter Consulting GmbH and NET.Office GmbH: Conception of transforming the global fileservices of all Commerzbank AG offices in the course of outsourcing to Hewlett-Packard as IT Architect and Project Manager in the first project phase. The main task was to conceptualize and manage all the intra-bank and external groups involved in the transformation as well as the coordination of gateways between those sectors (e.g. Fileservice HP with encryption Commerzbank). A special challenge presented itself in the technical integration of Dresdner Bank which was bought by the Commerzbank in 2009. Main components of the technical solution included Active Directory, Citrix, Group Policies, NetApp Filer, HP Eva Storage, DNS, DHCP, IPAM with Infoblox Appliances. More than 100,000 workplaces with PC were affected while the continuous access to data and apps had to be ensured. Contact: on request

2012-2016 anonymized international pharmaceutical company Chicago & Wiesbaden, management of several projects, among others: the development of web-based “mobile dashboards“, the development of a tool for planning product strategies (and many more).
Ongoing tasks were advisory services SOX-conform IT policies as well as the development of an automated solution for identifying the relevancy of policies for certain IT projects, thereby securing the IT compliance. Here lied another challenge in synchronizing the requirements of various company branches. Contact: on request

2012-2016 Klingelnberg GmbH, Hückeswagen, in cooperation with NET.Office GmbH: Consolidation of IT technologies after the acquisition of other companies. Users and groups were migrated into a central Active Directory environment and all correspondent Exchange-mailboxes were migrated accordingly. Another main task was the OU- & GPO-Design. Contact: on request

2008-2013 Jenoptik AG, Jena, project authority and responsibility right below CIO level for the transportation of a heterogeneous corporate IT (Unix, NDS, AD) into a Microsoft Active Directory as new basis for Corporate Services. OU- & GPO-Design was a key aspect. Contact: on request

2007 DBD Deutsche Breitband Dienste GmbH, Heidelberg, lead project management and technical project for the launch of several web portals. This included the coordination of all teams‘ work packages (Portal, Middleware, Webservices, ERP and CRM). Contact: on request

2006-2007 Techem AG, Eschborn, in cooperation with NET.Office GmbH: Project planning und -coordination for a global Active Directory-Rollout which was the basis for the introduction of Exchange 2003. We had to work out a concept for the consolidation and migration for two AD-Forests, eDirectory, SSO and Oracle OCS. Contact: on request

2006-2007 LGN Niedersachsen, Hannover, project planning and steering of the state-wide migration of the agency for topographical survey and geo basis information for the federal state of Lower Saxony as preparation to integrate it into the central Exchange 2003 environment of the national Active “ads.niedersachsen.de“. The project’s main goal was the migration of the LGN-NT4-domain and further 53 NT-domains of Lower Saxony’s land registry office into the GLL-domains of the nationwide network. Therefore the necessary processes had to be defined first. A main part in this course was the introduction of new fileservices via DFS and a new role concept, including the planning of a suitable OU-structure and the design of group policies. Contact: on request

2005 City of Frankfurt / Main, in cooperation with Microsoft Services Germany: responsible for the migration and consolidation of application- and function-servers and corresponding apps for more than 400 users in 80 office locations. Additional conceptual support for the subprojects “Exchange“, “Active Directory“ and “Migration and Deployment“. Microsoft Operations Framework (MOF) was the basis for the process development. Contact: on request

2004-2005 Lower Saxony office for geoinformation, landscape development and properties (GLL), Hannover, external technical project management for the conception and support of a nationwide Windows NT/2003 and Exchange 5.5/2003. Design of an Active Directory structure, definition of security guidelines and group policies. Reduction of expenses through scripting of administrative tasks. Conceptualization of a directory replication between Exchange 2003 (Active Directory) and NDS at the land-registry. Contact: on request

2000-2009 Retail associations EHV of the HDE nationwide (except Bavaria), subcontracted by NET.Office GmbH Kassel, the MS SQL based member management DIALOG32 from the software house Plantext GmbH was rolled out nationwide, adapted to local needs (SQL queries) and long-term support provided. Contact: on request

2005 Mahr GmbH Göttingen, development of a tool for the daily, automated creation of the Exchange 2003 address books by location, department and department worldwide (for 61 countries). Contact: on request

2005 T-Online AG Darmstadt, development and commissioning of a cluster-compatible Exchange 2003 reporting tool to determine the SLA reaction speed for mail-based support and service desk requests within the T-Online group. Contact: on request

2005 Pius Hospital Oldenburg, introduction of an Active Directory, commissioning of an Exchange 2003 cluster. Mailbox migration of approx. 700 intraline mailboxes to Exchange using a script solution. Contact: on request

2005 Chamber of Crafts Lower Bavaria / Upper Palatinate, support in consolidating 11 domains (NT, 2000,2003) into a new Windows Server 2003 forest as an infrastructure basis for the introduction of Exchange Server 2003. Contact: on request

2000-2005 HP Education, subcontracted by NET.Office GmbH Kassel. Conducting MOC trainings (Microsoft Official Curriculum) as a “Microsoft Certified Trainer” and “Certified Trainer HP Education” in HP training centers. MCP, MCSE and MCDBA exam candidates were trained (Microsoft Certified Professional, Microsoft Certified Systems Engineer, Microsoft Certified Database Administrator). Contact: on request

2003-2004 Kodak Polychrome Graphics, technical responsibility for the development and implementation of a web-based reporting and monitoring system for production data on a production line using MS-SQL Server 2000, Sybase, DB/2 databases and ASP.net as a development platform. Development of an Exchange connection for automatic reporting. Contact: on request

2003 Authority for Agricultural Structures Lower Saxony (AfA), conception and support of a nationwide Windows NT / 2003 and Exchange 5.5 / 2003 migration project as trainer and consultant. Design of an Active Directory structure, consolidation of 13 NT domains, definition of security guidelines and group policies for hardening the environment according to BSI basic protection. Contact: on request

2001 COLT Telecom Frankfurt, in collaboration with NET.Office GmbH Kassel. Planning, installation and hardening of a Windows 2000 web server farm in an isolated Active Directory high security environment. Contact: on request

2000 MAN Roland Offenbach: development of a database-supported logistics information and control system. Contact: on request

1999-2002 Regional Association of Bavarian Retailers LBE (now Handelsverband Bayern e.V. HBE), subcontracted by NET.Office GmbH Kassel, a complete member management program including contribution management, accounting and dunning was developed in Microsoft Visual Studio with an underlying MS SQL Server infrastructure. The front end was mainly developed in Visual Studio. The logic, data processing and data replication were developed entirely in Transact-SQL. All of the customer’s Bavarian locations successfully used the solution. The trigger for the project was the so-called Y2K problem of the previous solution. Contact: on request

1995-1998 German Aerospace Center (DLR ARES project) Göttingen, IT manager and developer for adaptable algorithms and control systems based on DSP for use in wind power plants, baby emergency vehicles, aerospace, acoustics, transonic wind tunnels, trains and more in employed position. Contact: on request