Profileimage by Stefan Diener Senior Technology Consultant / Softwareentwickler / Projektleiter (PMI / PRINCE2/ SCRUM) from Haibach

Stefan Diener

partly available

Last update: 06.09.2022

Senior Technology Consultant / Softwaredeveloper / Projektmanager (PMI / PRINCE2/ SCRUM)

Company: WebAppz IT-Consulting GmbH
Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

Diener.Stefan.CV.en.pdf
Diener.Stefan.CV.en.pdf

Skills

- Projektmanagement (PMI / PRINCE 2 / SCRUM)
- AS/400 (Synon/Cool:2E, RPG, CL, DB2/400)
- webbased solutions using PHP, AJAX, HTML, Javascript, CSS etc.
- Database development (Modelling/Optimizing/Development) SQL-Server (T-SQL), mySQL, etc.
- Google Tools (Google Analytics, Google Tag Manager, Search-Console, etc.)
- Implementation of the ECJ ruling on cookie-consent „planet49“ – rollout of a cookie-consent solution
- Web Security (HP-Fortify)
- eSign (digital qualified signatures)
- Archiving solutions

Project history

05/2016 - Present
Senior Technology Consultant - Digital Transformation Services
Nestlé Deutschland AG, Frankfurt (Consumer goods and retail, >10.000 employees)

Tasks:
▪ Conception and support for digital transformation
▪ Implementation of the General Data Protecton Regulation (GDPR) for various applications
▪ Implementation of the ECJ ruling on cookie-consent „planet49“ – rollout of a cookie-consent solution on all german  websites
▪ Onsite coordinatior for technical teams (internal/external)  across the world.
▪ Review and signoff for technical concepts
▪ Conducting code-reviews, prepare audits
▪ Installation of IIS web applications / Configuration of IIS web-server
▪ Analysis and evaluation of the results of performed security-scans (HP-Fortify). Communication and mediation between Nestlé IS/IT and software developers (external/internal)
▪ Administration of various tools in the area of search engine optimization, tracking and analysis  (Google Tag Manager, Google Search Console, Google Analytics)
▪ Review and signoff for tracking concepts and implementations from external media agendies (MediaCom, Path, Ad-Agents, etc.)
▪ Rollout of  DMP (Data Management Platform) – Oracle Bluekai und Salesforce (krxd.net)
▪ Maintenance and further development oft he Nestlé Product and Image database (.net MVC5 Anwendung, Resp. Web-Frontend, SQLServer 2012)
▪ Development and implementation of an application with which a technically inexperienced user is able to „configure“ onlinepromotions/competitions   (.net, SQL-Server 2012, 2016)
▪ Migration Project of a very large website  (2500 content pages from SAP/Hybris to Drupal (Acquia)
▪ Conception of an e-commerce solution (Magento 2) with interfacest o SAP and the internal product database
▪ Migration of a datacenter (application and database server) into Microsoft Azure cloud

o Technology: Windows Server 2008, 2012, 2016,  SQL-Server 2008 / 2012 / 2016, TSQL, ETL, SSIS, Microsoft Visual Studio, TFS, GITLAB, BITBUCKET, C#, PHP, jQuery, IIS, Apache, Hybris, Drupal, Acquia, Magento, Oracle Bluekai, Salesforce DMP, Microsoft Azure

02/2019 - 02/2019
Part-Time: Development of a REST based web-service for article stocks in 170 branches
Adler Modemarkt AG, Haibach (500-1000 employees)

Tasks:
▪ Planning and conception (REST Service + additional database components: Functions, Views and Stored Procedures) ▪ Programming und Testing
▪ Documentation

o Technology: .NET, SQL-Server 2012, TSQL, REST

06/2014 - 04/2016
Stream-Lead - Conversion of business critical database applications to SEPA
Telecash GmbH, Bad Vilbel (Banks and financial services, 500-1000 employees)

Tasks:
▪ Analysis of the existing database models, conception of the necessary code changes, optimization of processes (SQL server job control)
▪ Requirement Analysis / Coordination with several departments
▪ Creation of SRD´s (Solution Requirements Document) based on Business Requirements
▪ Creation of Work-Packages and coordination of implementation 
▪ Monitoring of "deliverables" (Requirement-Tracablility Matrix)
▪ Planning and execution of tests (Unit-Tests, SIT, UAT) ▪ Release Planning/Coordination
▪ Documentation and PCI-Code Reviews
▪ Implementation of training courses / Handover of the software packages to line-organization

o Technology: Windows Server 2008, SQL-Server 2008 / 2012, TSQL,  SSIS, ETL, Microsoft Visual Studio, SVN, Control-M (BMC) Jobcontrol

03/2014 - 03/2014
Part-Time: Design / Developer - Redesign and implementation of the website, introduction of a CMS system
EDI AG, Obernburg (Internet and Information Technology, 10-50 employees)

Technology: LAMP (Linux, Apache, MySQL, PHP), jQuery, Ajax, CSS

02/2014 - 03/2014
Senior Technology Consultant - Evaluation and optimization of a platform in the area of Multi-Channel Marketing
adidas AG, Herzogenaurach (Consumer goods and retail, >10.000 employees)

Technology: Cloud computing, Apache Karaf Server, Tomcat, Spring, Ant, MySQL, Microsoft .net, Nuxe

11/2013 - 01/2014
Design / Developer - Development of a web-based system for problem management in 170 stores
Adler Modemarkt AG, Haibach (Consumer goods and retail, 500-1000 employees)

Technology: WAMP (Windows, Apache, MySQL, PHP), jQuery, Ajax, CSS, XML, SMTP, LDAP, Baramundi

06/2012 - 11/2013
Stream-Lead / Project Manager - Migration Project Moving to new data center
Telecash GmbH, Bad Vilbel (Banks and financial services, 500-1000 employees)

Virtualized server platform
Upgrade to 64-bit operating system
Upgrade to SQL Server 2008
Database encryption
Optimization of workflows
Conversion to 3-tier architecture (distributed environment)
Control of external service providers (offshore OnSite)

o Technology:
Windows Server 2000-2008, SQL-Server 2000-2008, TSQL,  SSIS, SSRS, SVN 

10/2010 - 05/2012
Developer - Database development, ETL and customizing of clinical studies
eResearch Technology GmbH, Würzburg (Pharmaceuticals and medical technology, 250-500 employees)

Technology:
Microsoft SQL-Server 2005/2008, TSQL, SSAS, SSIS, SSRS, TeamFoundationServer, PHP, jQuery, Ajax

10/2010 - 02/2012
Part-Time: Design / Developer - maintenance and further development of a web-based system for problem management in about 170 stores
Adler Modemarkt AG, Haibach (Consumer goods and retail, 500-1000 employees)

Technology: : LAMP (Linux, Apache, MySQL, PHP), jQuery, Ajax, CSS, XML, SMTP, LDAP, Baramundi

11/2009 - 09/2010
Design / Developer - online portal for managing data backups, asset management and workflow optimization (about 1200 users)
Novartis Pharma AG, Basel (Pharmaceuticals and medical technology, >10.000 employees)

Technology: Microsoft SQL-Server 2008, TSQL, PHP, jQuery, Ajax, SVN Acronis-Server

09/2009 - 10/2009
Design / Developer - Web-based application for the mass distribution of personalized SMS messages.
WebAppz IT-Consulting GmbH (Internet and Information Technology, < 10 employees)

Technology : LAMP (Linux, Apache, MySQL, PHP), jQuery, Ajax

03/2008 - 08/2009
Design, technical Project Manager, Developer - DMS migration in Germany and Switzerland
Volvo Trucks Deutschland GmbH (Automotive and vehicle construction, 250-500 employees)

Dealer Management Systems of 9 sites will be migrated to two new locations. Consolidation of open orders / invoices and the parts inventory. Conversion of interfaces, printers, archiving systems. Address lists are both in the DMS as well as in the accounting software used yet. Removal of duplicates.

o Technology: AS/400, DB2/400, CLP, SQL, RPG/ILERPG, Excel/VB

12/2006 - 02/2008
Design / Project Manager - Qualified electronic signatures for the countries AT, CH, DE
Volvo Trucks Deutschland GmbH (Automotive and vehicle construction, 250-500 employees)

Documents are sent out electronically. Conversion on the AS/400 in  PDF format. Collection of documents by NT service via FTP. Create XML control files for the upcoming signature. Transfer to Trust Center (via SFTP). Collection of documents signed by the Trust Center and transfer to the archive (IBM OnDemand)

o Technology: AS/400, DB2/400, CLP, Interform, FTP/SFTP, Trust-Center,  IBM: OnDemand
 

06/2005 - 12/2006
Design / Project Manager - Connection to archiving system (IBM OnDemand).
Volvo Trucks Deutschland GmbH (Automotive and vehicle construction, 250-500 employees)

Interface definition, workflow optimization and submission of the documents to OnDemand

o Technology: AS/400, DB2/400, CLP, MS-SQL-Server, Visual Studio, FTP/SFTP,  IBM: OnDemand

01/2005 - 05/2005
Design / Developer - Software solution for handling communication between AS/400 software package and WIN32 application via XML
various BMW dealers / workshops (Automotive and vehicle construction, 10-50 employees)

Technology: AS/400, DB2/400, CLP, SQL, RPG/ILERPG, Cool:2E , Visual Studio

04/2002 - 01/2005
Developer - Print formatting and output management for about 120 dealerships in AT, CH and DE
Volvo Trucks Deutschland GmbH (Automotive and vehicle construction, 250-500 employees)

AS/400 spool files (raw data) are completed with graphic elements and forwarded to the printer. Control for copies, and duplex printing and workflow.

o Technology: AS/400, DB2/400, CLP, Interform/400

04/2002 - 03/2004
Developer - Maintenance and development of a system for vehicle registration documents (KBA)
Volvo Trucks Deutschland GmbH (Automotive and vehicle construction, 250-500 employees)

Technology: AS/400, DB2/400, CLP, Cool:2E

07/2001 - 03/2002
QA manager - Quality assurance: MICOS
Dplus/Mobilcom AG (Telecommunications, 500-1000 employees)

MICOS is a sales management software for provisioning processes and the management of external partners and internal sales staff.

o Technology: Oracle, PL-SQL

07/1997 - 06/2001
IT-Consultant / Software-Developer (permanent deployment - several customers)
PCONAS GmbH, Hanau (Internet and Information Technology, 10-50 employees)

• Automotive  –  Volvo Car GmbH
  o Management of used sales system – Creating an interface to SAP / FI  o Maintenance and development of a system for executing and controlling business processes
 
• Marketing  –  PPD Marketing Services GmbH
  o data collection of project information via the Internet
 
• Pharma / Logistik  –  Stada Arzneimittel AG
  o development of a software for stock and production control
 
• Wholesale  –  Praktiker Deutschland GmbH
  o Development of a system for managing IP addresses
 
 
Technology: AS/400, OS/400, DB2/400, CL, RPG, SQL, Cool:2E, Silverrun, Win32, MS-SQL-Server, HTML, PHP, ASP,  Visual Studio, VBA, Javascript, SAP/FI

03/1990 - 06/1997
IT-Consultant / Software-Developer (permanent deployment - several projects)
deutsche kleiderspedition Gmbh&Co.KG / Logwin AG (Transport and Logistics, 5000-10.000 employees)

o Creation of software for planning and controlling transports
o Implementation of an EDIFACT interface
o Process optimization for order picking and dispatching

Technology:  IBM/36, SSP, AS/400, OS/400, DB2/400, CLP, RPG, SQL,  Win32, Cool:2E , MS-SQL-Server  
 

Local Availability

Open to travel worldwide
On-site work is generally possible.
Projects abroad are also possible.

Other

Download latest CV:
https://www.webappz.de/profile/Diener.Stefan.CV.de.pdf
https://www.webappz.de/profile/Diener.Stefan.CV.en.pdf


Reference letters:
https://www.webappz.de/profile/Diener.Stefan.Referenzen.zip
Profileimage by Stefan Diener Senior Technology Consultant / Softwareentwickler / Projektleiter (PMI / PRINCE2/ SCRUM) from Haibach Senior Technology Consultant / Softwaredeveloper / Projektmanager (PMI / PRINCE2/ SCRUM)
Register