Gregor Huyskens

Farm technology is a rising sector. The use of ERP for urban farms is yet rare.

From concept to implementation of the first versions I suggested and enhanced a production tracking system allowing farm owners to monitor, compare and plan production quantities while organizing stock and sales smoothly with an open source ERP solution.

Achievements:

Delivered a prototype of a multi lingual offline/ online tracking app serving customer db and central ERP db.

Python, Odoo 16, Android Apps, JS, Aquaponics

Design and Implementation of an Android App allowing to display picking orders and use of QRCode scanner to identify order items and avoid costly misspicks.

The app is designed around an online database which gets relevant delivery orders from the clients sales system.

When orders are received via fax to the warehouse the app identifies all requested product numbers and displays order line detail and instructions per pick.

Achievements:

Delivered a complete application with challenging legacy DB integration.

Python, Odoo 16, QRCode Scanners, Andorid Apps, JS, Droidscript, MySQL

nag Informatik AG in Bern (CH), PAX Insurance

Extension of Contract Administration, a PAX inhouse development, required implementation experience with ABAP to correct and build Webdynpros and BAPIs in three week sprint cycles (Scrum).

Apart of ABAP OO some of the applications use SAP Workflow and custom extended Fiori Applications i.e. a specific Workflow task inbox.

Analysis of bug reports led in all cases to solutions or proposals for improvement.

SAP HANA, Netweaver, ABAP OO, BAPIs, Webdynro, WebIDE, Javascript, UI5, OData, SAP Workflow

Improving the Portal Software of fileon.de was required for better usability and customer satisfaction.

Apart from Python programs extended for the Odoo System version 14, backend processes could be improved using QR codes for fast and reliable identification of documents.

Achievements:

Extended Python modules of Odoo 14 and employed many open standard protocols and libraries. Designed and refined backend processes.

Odoo 14, Python, OWL, Javascript, node.js, Web Server Administration, Image Processing, Cloud Server

The demand for energy and nutrition is rising and new technologies have to optimize the use of resources.

Since 2016 we follow the development of farming techniques for micro aglae.

The company Emyune PT, Lda was founded in Lisbon to build new farm types and find better ways for production. We focussed on low cost ponds with off grid power supply and a network integrated management system.

We suggested cooperations with ISA (Instituto Supperior da Agronomia) and local organizations.

Achievements:

Studied alga production, their use, benefits and metabolism. Learned to use tools and chemistry for better production approaches. Learned to fight the Portuguese burocracy.

Microbiology, Chemistry, Nutrition, Spirulina, Microcontrollers, Farming

Supplying online services is a demanding task for big insurance companies with millions of users.

AOK is a group of german public insurance providers who offer access through an internet portal. Their system is an SAP custom development and runs 24/7 for four million users.

My project had several aspects: Solving daily problems of different type in second level support and developing an order application for customizing changes.

This order application uses the Odoo (Python ERP) framework to let about 50 key users of 11 subsidiaries identify relevant settings through a CMS, create change orders and track the status of these orders.

Achievements:

Solved 900+ technical problems. Designed and implemented an order tracking system.

SAP Customer Service, Odoo Python, OO Design and Implementation, Docker

Utillity companies like E.ON need to optimize not only standard documents but also individual communication for customer service.

In 2008 EON had started to develop a system based on SAP CRM, Adobes Document Server and forms editor.

Now these editor tools were replaced by a new system and we supported redesign of web services and small UI changes for the new integration.

Achievements:

Wrote design documents and implemented classes for data integration.

SAP CRM 7, ABAP OO, Webservices, GMC Inspire, XML

In 2018 Atotech plans to replace their SAP systems database with HANA DB.
The preparation of this step required compliance checks for about 4.000 custom program sources. A two weeks workshop turned out a code parser and workbench supporting manual and semi automatic code upgrades. Manual efforts could be cut in half.

ABAP on HANA, Training of Developers , Netweaver 7.4

Use of smart phones shows large potential in transport logistics since GPS, scan and photo features help to secure and accelerate handling for driver and customer.
Objective of our development for the airfreight carrier "CCS Cargo City Sued GmbH" is the renovation and mainly new development of an ERP integrated solution including verification of personnel, load tracking, bar code identification of partners, packages and vehicles.

Platform of choice is Odoo 10.0 , the ionic framework and web2py for a scaleable restful API.

Candidate is responsible for design and implementation.

Odoo, OpenERP, python, ionicframework, Android, web2py Logistics Process, Im- and Export, Airfreight

Two leading mature open source ​frameworks were not yet integrated in any documented way.

web2py is a stable python based web server with an excellend DAL (Data Access Layer) - an equivalent to SAP's OpenSQL in ABAP.

Python as one of the strongest server based languages allows use of large secure libraries on all major OS platforms.

Goals of the project are to build:
1) .. an interactive modeller for backend models
2) .. a generic maintenance app for associated entities
3) .. an application designer with a new event handler manager

After POC the prototype could be deployed on HANA DB with an extension of py-dal for this new DB.

web2py's DAL opens access to several (About 18) database types.

http://www.web2py.com/book​

http://pydal.readthedocs.io/en/latest/​

https://openui5.hana.ondemand.com​

Studying situation of environment and measures for overdue change I started to focus on a central topic - micro algae for nutrition and energy.

The potential of micro algae, which was promoted by WHO, UN and FAO, is widely disregarded. Value of algae like Spirulina is in addition raising or at least stable while publications of farming technique is rare.

Cooperation with Thai University in Khon Kaen (KKC) was planned.

A prototype of a scalable low cost farm could be developed and a ROI of under 6 months leaves motivation for further research.

Prysmian Group: High Tech Industry - International Supplier

Support of HANA upgrade project

Trainer for ABAP Developers: HANA​ Upgrades: "Requirements and new ABAP features"

Development of a central "Drums Replenishment Cockpit" with weekly analysis and direct order creation feature.

Development of a report for "Print and EDI message Repetition".

Poste Italiane - Rome, Italy

CRM 7 Backend Integrations

- Web Service Class extensions of messages with authentication parameters

- Order Export to legacy (partner) system in flat file and xml formats

- Development of fast order statics for custom front end overview screens

1) Development of a "Fiori like" Application for S4 HANA
A work list for supplier evaluation was required replacing older POWL lists. In the new S/4 environment all BSP applications are replaced.

CDS Views were developed and optimized. Annotations with metadata helped to render list views generated dynamically by a new template class OData-Services were extended.

2) Extension of MM-PUR Standard Functions
New legislation regarding incoterms required code extensions down to release ECC 6.0, Netweaver 7.3. Dialogs, Reports und IDOC Functions had to be updated to cater for versioned attributes.

SAP ECC 6.0, Netweaver 7.3, Fiori, OData, CDS Views, HANA DB

A&O GmbH, Ludwigshafen

fileon UG - fileon.de

Design and implementation of archiving services for SMEs

Complete development of backend and frontend modules on OpenERP

Business plan und calculation for start up

Python, Web Server Entwicklung, Linux, OpenERP

Riegele KG, Augsburg

Upgrade of EMCS XML Tax Application (rel. Project Sep 2012)

Upgrade to SAP ERP Release required adaptation of reports.

Syntactical and functional extensions were planned and implemented.

SAP ERP 6.0 , ABAP

BASF - Business Services, Ludwigshafen

Support of SAP Systems for Module EHS - Environment Health and Saftety Management.

Large production and trade companies have to achieve compliance with REACH legislation. Laws require to track substances imported into or produced in Europe by quantity. Exceeding quantities require specific licenses.

Analysed program flow, traced system DB access and logic of custom coding.
Incident and Problem Handling for EHS, Material Management, GTS (Global Trade System), ALE, Lable Management, Substance Workbench

SAP ECC 6.0, EHS, SVT, GTS, Debugging, BAdIs, Logistics

Implementation of OpenERP

Configured Test systems for a trading company and a legal agency in Bangkok.
Proposal for ERP process integration (warehousing, project management)

Implemented a new module for integration of a web shop (osCommerce), which is extendable to other systems.

Python, OpenERP

Riegele KG, Augsburg

Development of EMCS XML tax application (Excise Movement and Control System)
A standard message type for deliveries was extended with a file output for automatic transmission of tax declaration documents.

SAP 4.5, ABAP, XML

OSESoftware Co. Ltd.

Development of OpenERP Migration toolsAnalysed data structures of CAO-Faktura and OpenERP sales modules

Analysed and tested features of "Talend Open Studio" migration workbench

Studied market about use of Open Source ERP in Europe and Thailand

Python, OpenERP

Mieschke Hofmann und Partner (mhp.de) / Volkswagen AG

Developed tools for CRM7.0 country specific datamigration

Migration program for „Workshop Orders"
Designed and developed program for order creation used for opportunities from historic contacts

Developed and corrected IDOC extensions

SAPCRM7.0 (1Order, Sales, Service, BOL, ALE)

Research about Online Operating Systems based on Javascript Framework ExtJS.

Analysing features and architecture, proposing generic approach for Frontend IDE for RAD in HTML5 / Script Frameworks.

Experimental, Prototyping

OOS, JS, ExtJS, OO Patterns, Software Ergonomics

Sudies of SMB ERPSolutions of NSD

Market and System studies to prove concept of sales and service partnership with NSD, a french provider of a commercial ERP system.

NSD BCS, ERP, GRP

HP AG www.hp.com

Development/Correction Support for Life Systems of Carl Zeiss AG, International

Zeiss roles out CRM 7.0 Template releases in half year cycles. The current life systems are in USA, UK and Germany. HP organized the help desk, responding to problem reports.
Analysed cause and conditions of user problems with CRM standard and custom applications and views. Classified incidents, proposing solutions and implemented corrections

Reviewed hand over documentation and test plans for Zeiss Custom Release Upgrades.

Delivered training sessions for new team members, presenting 4 new feature areas of the Zeiss Business Release.

Areas:
1Order Objects, BOL, View Maintenance, Quote to Order, Opportunities, Copy Rules.

Bug Fixes, Analysis of requirement solution fit, testing

SAP CRM 7.0

DSKG Germany, www.dinkelacker-schwabenbraeu.com

Connected a mobile warehouse system (MOWIS) to SAP ECC 6, based on DSD (direct store delivery) functions.

SAP DSD, ABAP, BAPIs, Logistics, (SD) Transports

IBM Germany, www.ibm.com

Improvements of of WebUI Usability

Service Requests and Service Order extensions on Customer Interaction Center and Backoffice Components

AET view (BOL) extensions, Layout extensions, Partner Determination BadIs, Checks on partner roles

SAP CRM 2007, CRM 7.0, ABAP OO

SyBit GmbH, Radolfzell www.sybit.com

Maintenance of WebUI Extensions

Configuration of assignment blocks, extension of structures with new extension tools (integrated).

Development of new assignment block for competitive machinery in sales and marketing roles with custom persistence

Enhancement of opportunity detail views

SAP CRM 2007, CRM 7.0, ABAP OO

IBM Germany, www.ibm.com

Maintenance of CRM 4.0 Custom IBase Application

Troubleshooting and functional extension of highly custom modified IBase Workplace on ERP 2005 Environment.

SAP CRM IBase custom extensions

mowis GmbH

System Integration with SAP Business Connector

DSD, Direct Store Delivery on SAP ECC 6.0 has ALE integration capabilities and can be connected via Business Connector, XI or other integration tools to mobile systems.

Targeting a configurable interface for the mobile warehouse system “MOWIS“ of movis-GmbH, the SBC was chosen as preferred platform.

Implementation of a demo version for downloads to handheld devices

SAP Business Connector 4.8

Idea, Design, Implementation of an Annotation Web Service

Motivated by the use of e-learning software this service was developed to allow for collaborative text handling. Setting annotations on arbitrary web pages is implemented with JavaScript, PHP and SQL database only.

The portal started commercially and is currently a candidate for wider use in German class rooms.

PHP, SQL-Database, HTML, Javasript, Linux

Web Development using Javascript Framework ExtJS

Concept and Prototype Development of Browser based IDE for ExtJS

Applications

ExtJS, Javascript, JS Framework, JSON, AJAX

Java-XML Converter

Developed an Interface platform for connecting a mobile Warehouse System to SAP ERP 2005 using XML to TXT Mapping Logic.

Javascript Framework iWeb

Open Source platform to stage e-learning multimedia content - Goal is a commercial language learning portal based on interaction and association

Java, XML, JS Framework ExtJS

e.on, Hannover

CRM WebUI Extensions,Data Retrieval Modules Integration of Adobe FormsSolution (Backend)

Development of Data Retrieval Classes for commonactivities, assemblingdetails for 70 Templates of customer contact letters. Modifications of WebUI views, EEWB, Component workbench

SAP CRM 2007, WebUI, Netweaver, BSP

Siemens AG, Munich, Germany ; Siemens Bangkok, Thailand

Extension of WebUI features and preparation for rollout of CRM Rel. 5.2 as worldwide platform for customer and sales support.

Conversions of ICWeb Client features and Integration of modules supporting Business Partner data exchange with central MDM system

SAP CRM 5.2, WebUI

BMW AG, Munich, Germany

Review and update of Development Guidelines regarding new technologies like Object Orientation, Enhancement Framework

SAP R/3 4.7

Petro Rabigh, Saudi Arabia

Custom Development for MM and HR modules of a new R/3 Implementation in petrochemical industry.
User Exits for Purchasing Approval (Role Determination)- Interface for transfer of Personal Data (several infotypes) froma Recruitment database to PA (HR Personal Administration)Forms Development check form, CI adaptations (formatting)

SAP R/3 4.7, MM, Screen Painter

movis GmbH, Germany

Development of an Interface to a Mobile Data Capture System
Conversion of transport orders (accumulation of delivery notes) to flat files for processing on mobile hand held computers, using BDC inbound.

SAP R/3 4.6 Shipment, IS Beverage

Postbank AG, Germany

Master Data (GP-) Connection of two SAP CRM-Systems across companies.

The fusion of BWH and Postbank promised benefits from cross-selling potential.

GP master data on both systems had to be matched systematically in order to consolidate contract data of identical customers.

ECATT Script development for data conversion – Prototype for conversion scenario with remote system control.
Interface design and development of a solution allowing for near real time comparison of changes on GP records

SAP R/3 Basis 620, CRM 3.0

BHW Insurance, Hameln, Germany

Design and Development of a generalization of custom coding addressing the need to roll out functional extensions to foreign and national subsidiaries.
Central question was, which functionality should be included in a general, customizable solution for BHW's contract management.
Evaluation of an implementation of SAP's BRF (business rule framework).

SAP R/3 Basis 620, CRM 3.0

SAP AG, Walldorf, Germany

Development of a Database Layer to support the BRF (Business Rule Framework)
The architecture of BRF was lacking a consistent database access through shared class methods. This feature was due because of a requirement to process data for past validity dates.

SAP R/3 Enterprise, WAS 620 , ABAP OO

SAP AG, Walldorf, Germany

Development of a Price Planning Workbench for IS-Retail
Design and implementation support for a dialog transaction handling mass maintenance of price plans.
Use of ALV-Trees and Grids, UML design tools

SAP R/3 Enterprise, WAS 620 , ABAP OO

tt-netcom GmbH (later movis GmbH), Germany

Development of an XML-Interface for the Integration of a Mobile Data Collection System with R/3 using a MySQL database, PHP-Scripting and XSLT Tranformations.
The platform independent solution builds on Java-based open source tools and allows for communication via SAP Business Connector.
Design, product selection (EAI), implementation

SAP R/3 4.6 ALE , Java, PHP, XML, Business Connector

EDEKA Zentrale AG

Cooperative society of german retailers

Preparation of a web based master data maintenance application

Design and implementation of a prototype for customer record maintenance using SAP Java Connector and JDK 1.3.1

SAP IS-Retail, SAP R/3 4.6C, Java Connector

LBK - Landesbetrieb Krankenhäuser, Hamburg

Integration of SAP MM and Warehouse Management System WLS® (SALT AG Würzburg)

Designed and and implemented an interface using ALE, RFC

Extension of IDOCs, definition of data structure and flow

Reporting on warehouse system WLS®

Analysis of stock database with MS ACCESS

SAP R/3 ALE, Warehouse Management, MS ACCESS

Team assistance for R/3® Application Remote Support Center (Hyderabad)

Deloitte offers off shore support with a team of specialists out of a development center in Hyderabad, India.

Customers in need of ABAP-, scripting- and configuration support get connected remotely.

Planning, documentation and supervision of development tasks for several US American clients (EDI, reporting, SAPforms)

Introduction and improvement of development standards

SAP R/3

Boehringer Ingelheim, CT, USA

Pharmaceutical Industry

Implementation of R/3® to Host Interface; Module QMDevelopment on MERCATOR®, Middleware for Message Exchange

Scripting (UNIX), Transaction Calls to module QM

Reporting for annual order evaluation

SAP R/3 4.0, MERCATOR®, UNIX

Office Max, OH, USA

Development Support for Retail ImplementationCoding of pricing enhancements

Design and implementation of Deal Pricing Application

Enhancements of Listing Functionality

Adjustment of material classification

Preparation of Development-Plan (Volume of 2000 developer days)

SAP R/3 IS-Retail

Hunt Wesson Foods, CA, USA

R/2 Migration (Rel. 4 auf 6.0). Analysis and adaptation of data and program pools for release upgrade

SAP R/2

Nash Finch, Retailer, MN, USA

Development Support for Retail Implementation

Development of a Background Pricing Function for the first US Retail roll out.
Developed a custom application to identify groups of stores and articles due for new price determination after arbitrary condition changes.

SAP R/3 , IS-Retail

ACME Steel Corp. Chicago, IL, USA

Development of a Time Tracking and Approval FunctionConcept, implementation, training for employment time trackingtransaction (Interactive Reporting)Maintenance of interface programs integrating data capture terminals(EPIC Data, Canada) into R/3 HR

SAP R/3 2.2

ABAP training, inhouse preparation and delivery of first courses to colleagues.

Projects for Hospitals (UK Eppendorf) and trading companies.

PCP – Hamburg

DB development, 3D software, CAD software selection and training

Study basics of biology, chemistry, genetic technolgy for the application in Synthetic Biology and Microbial Engeneering

Calculation of optical wave guide properties with FFT Algorithms using parallel computing

Using algorithms for predictions of long range laser beam propagation, my thesis could prove the concept of applying such approximations in QM domain of weakly leading wave guides.

Instructed developers about specifics of SAP tools and architecture.

ABAP Reporting

Basis Administration