ALLTERRA IT Solutions

• Development of a database application (SQL Server 2014) for production visualization
  • Data import from MES and ERP
  • Analyzing and support of improving the data quality
  • Definition and calculation of various KPIs
  • Configuration of the visualization software Visual Shop Floor®
  • Documentation of the system
• Development of a Windows desktop application (C#) for managing the database application including user and developer documentation
• Support of the project “MES new”

The projects below, executed between 04/2013 – 08/2016. were done for 4K Invest. Due to contractual limitations the company names can’t be given.

• Project leader for the carve-out of IT systems
• Contract negotiations with IT service providers
• Introduction of a new call center solution
• Re-negotiation TSA
• License transfer and purchase
• Support of department store openings
• Support of headquarter move
• Pilot project for SAP automation using WinShuttle
• Process optimization for master data creation
  • Process simplification in SAP
  • Adaption master Excel (VBA programming)
• Introduction of new processes for concession suppliers incl. EDI automation
• Introduction of layout module system in SAP
  • Planning, implementation and migration
• Data preparation for external partner for campaign analysis
• Building of a data warehouse for operative reporting for layout module system
  • Installation and configuration Microsoft SQL Server 2014
  • Creation of reports (Reporting Services) for Purchasing, Sales and IT department
  • Ad hoc queries for various business units
  • Automated data import SAP (DB2) and POS (PostgreSQL)
• Programming (C#) of a download tool for web shop pictures (Windows App) from suppliers
• Introduction of Google Apps for work
• Management reporting KPI with Tableau (SAP Retail on DB2)
• Data verification for data warehouse migration
• Support for introduction of CRM-Tools and POS receipt archive
• Programming (C#) of a tool for article selection for campaigns (document-level Office-customization for Excel)
• Support of business units concerning data faults and errors as well as supply chain issues
• Operative tasks in SAP
  • LSMW-Import for replenishment parameters
  • Testing of SAP development provided by service providers

• Project support for introducing of a CRM tool
• Project support for the production WLAN
• Project support for product tracing
• Project support for master data clean-up
• Reporting tool for Sales department based on Microsoft Excel with database access
• Purchase, planning and configuration of the new firewall solution (Sophos UTM)
• Support of the IT department

• TSA (transition service agreement) negotiations
• Carve-out IT systems
  • Design and purchase of server hardware, firewall, load balancer and storage
  • Installation and data migration Microsoft Exchange Server 2013
  • Budget tracking
• Introduction SAP
  • User management
  • Role management
  • Customization transport
  • Support data migration
• Design and implementation of a data exchange portal based on SharePoint 2013
• Introduction of a video conferencing system (Cisco WebEx)
• Introduction of a reporting tool for the factoring supplier
• Preparation and execution of Microsoft license transfer
• Introduction Normalizer (material normalization within the group)
• Support of the IT department

• Documentation of the IT landscape
• Negotiation and re-design for new blade servers
• License consulting and contracting of a Microsoft Select Plus contract
• Building of a data warehouse based on Microsoft SQL Server
  • Installation of virtual machine (Windows) on vSphere
  • Data import from AS400 (DB2) and SAP (using RFC)
  • Creation of production KPI reports
  • Creation OLAP cube (production defect analysis)
• Programming (C#) Tool for RFQ-creation/management and ERP data import
• Introduction TrueCrypt (desktop encryption)
• Negotiation and technical verification of ISP change for WAN and Internet access
• Project support for SAP in-housing
• Project support Normalizer (material normalization within the group)
• Pilot project for work effort registration
• Process optimization for goods receipt
• Support of the IT department (servers, network, firewall)

• Concept for hardware virtualization based on Microsoft Hyper-V
• General consulting for IT infrastructure

• Concept for hardware virtualization based on Microsoft Hyper-V
• Concept for network infrastructure
• Consulting on Microsoft licensing

• Building of a data warehouse and an operative reporting system based on Microsoft SQL Server 2012, Reporting Services, Analysis Services and Integration Services
  • Research of business specific requirements
  • Investigation of department specific data ware house requirements
  • Design of data interfaces together with service providers
  • Data analysis and correction with service providers
  • Design of data model
  • Design and installation of the SQL server
  • Data import from Oracle, MySQL and text files from service providers
  • Creation of reports (Reporting Services) for Purchasing, Sales, Network management, Operations and Controlling
  • Creation of reports and query tools based on Microsoft Excel
  • Creation of an OLAP cube (SSAS) for Sales
  • Creation of ad hoc queries
• Support of the IT department
  • Management of Exchange Server
  • Firewall management
  • Management Active Directory
• Support for introduction of Dymatrix DynaCampaign
• Introduction Kisters BelVis (energy data management)
  • Installation Server
  • Testing
  • Import weather data
• Support of sales process
  • Ad hoc queries of operations data