Johan Scheefer - Project Manager IT, Stras

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

STRASFounder & IT Program manager

Jan. 2018LuxembourgSTRAS founder: Strategy and Services Current mission: E2E application migration program - This program was certainly the most complex that I have the amazing opportunity to drive during the last few years! Main purpose was to migrate without impact on business activities, around 300 applications (Java, .NET home-made or packages), running on different OS (Solaris, AIX, Linux, Windows 2003, 2008, 2012), including storage (SAN, NAS), Network and security items (VLAN, F5, security guidelines), active directory (AD, ADLDS, ADMT, Access manager layer), to answer to CSSF (Commission de Surveillance du Secteur Financier) requirements and isolate all customer activities on a dedicated IBM Cloud (on premise) - 10 M EUR, 10 000 man-days split on around 100 ETP (internal and external resources) - Build Program Initiation documents, define scope in agreement with stakeholders and sponsor directives - Initiate projects, assign Project leader, create PID - Program follow-up with the management board - Projects follow-up with project teams - Budget follow up with financial lead team - Risk management - Issue management - Review migration strategy including ARM/TRM parameters and digitalization opportunities - Assign teams and coordinate actions with 3rd Parties - During this program, the infrastructure provider was performing 2 internal transformations (from DTS-IS4F to IBM, from IBM to IBM and Kyndryl split) with impacts on contracts, deliverables, and capacity to deliver. This was particularly complex to manage on top off, but I did it - A great challenge was also to combine Waterfall and Agile methodologies (Scrum) to assign resource capacity and prepare timeline combining 2 approaches (forecast vs Sprints) using bandwidth and ranges.

Davidson consultingSenior Consultant

Aug. 2016 - Dec. 2017Luxembourg

Intys ConsultingHead of Innovation and Corporate Identity

Apr. 2015 - Jul. 2016

Innovative Solutions For FinanceChange & Configuration Manager (missioned by Intys)

Jan. 2010 - Apr. 2015Bertrange, LuxembourgConfiguration Manager: My mission consists to maintain the CMDB Web Portal, provide team KPIs, develop ETL's and reports for severals departments, synchronise data's between countries. Change Manager: My role is to challenge changes to do not have any impact on the production. During IS WE we have to coordinate all changes and communicate status. I also have to provide tools and reporting for the change management team which help us to take any decision (impact analysis report, coordination report, etc.) Technologies: TSQL, SSIS, SSAS, SSRS, Sharepoint, BO, D+ Methodology: ITIL

Altran CISSenior Consultant Business Intelligence & .NET

Jun. 2009 - Dec. 2009LuxembourgJune 2009 - September 2009: Infotechnique ------------------------------------------------------------------------------ Purpose * FP7 is the short name for the Seventh Framework Program for Research and Technological Development. This is the European's main instrument for funding research in Europe and it will run from 2007-2013. FP7 is also designed to respond to Europe's employment needs, competitiveness and quality of life. * The scope of this project is to implement the new release of the application due to a modification into the database schema. The implementation is done by using Visual Basic .NET 1.1. ------------------------------------------------------------------------------ December 2009 - January 2010: GSK ------------------------------------------------------------------------------ The scope of this project is to update functionalities available into an Excel spreadsheet using vba to provide KPI and maintain data.

DP WorldConsultant Business Intelligence (missioned by Keyrus)

Dec. 2008 - May. 2009Antwerp Area, BelgiumThe project purpose is to setup a data warehouze into the company. My role is to assist the project leader. He analyzed the system specifications and created the analysis document. Based on this document I able to setup the data warehouze. The first phase was to connect to all differents databases (Progress OpenEdge 10.1A, iSeries DB2) and export data to SQL Server 2008. Atfer that an ETL is working. All data are transformed and loaded into a staging status and finally to the data warehouze. The next phase is to use SSAS to create OLAP and SSRS to provide report to the end user.

KeyrusFunctional Analyst

Sep. 2008 - Dec. 2008The scope of this project is to understand the business specification of a call center. The system has to be able to handle any kind of end user issues based on the call center competencies. These issues are managed trough a defined workflow. At the end of the process, the end user has to obtain a non ambiguous answer. A UML analyze has to be done with Use Case, Class diagram, Sequence diagram, deployment, implementation, etc) accordingly to the documentation done by the project manager. My responsibility is to understand the project specification and analyze it. The project manager asked me to create an use case diagram, implementation, deployment, class diagrams and sequence diagrams. When it was done and approved by him, I installed IIS on a server and start the project development. By using .NET, Ajax and SQL, I developed a web interface based on the project specification.

Keyrus - SOLIDNET/SECUREXAnalyst Programmer

Sep. 2008 - Dec. 2008The purpose of this project is to update our intranet. HR Data will be provided by a new social security company. My responsibility is to develop and test the interaction between the new system and our intranet, create tables into SQL server, update existing JavaBeans and XML files to manage these data. I also have to create a documentation file in case of some other developers continue the development. I will also set up an ETL to import a flat file provided by HR Accent into our database.

TNT AirwaysAir Network System Analyst

Oct. 2007 - Sep. 2008Development and analysis based on flight operations. Develop a workflow to provide reports to the end user using Crystal Report. Develop tools used in real time to obtain an overview of night operations. Analyze old databases and replace them into an automated process. My responsibilities include: Understanding the business and the airline specifications. Analyzing projects and defining user expectations. Developing different kinds of tools by using the .NET technology. Creating reports, manuals and procedures. Supporting end users during the user acceptance tests phases.

TNT Euro HubAnalyst Programmer

Mar. 2007 - Sep. 2007Analyzed Access databases and replaced them into SQL Server. Provide data via a web interface. Support previous functionalities developed. My responsibilities include: Analyzing the project and defining user expectations. Reports by using Excel and Crystal Report.

MicrosoftSales (as Student)

Sep. 2001 - Jun. 2004My role was to promote Microsoft Products (Games, Hardware). I travel all around Belgium to inform end users about new Microsoft products and increase sales.