John Erps Email & Phone Number

Rotterdam, Zh, Nl

Rotterdam, Zh, Nl

Woerden, Utrecht, Nederland

Hoofddorp

► CompanyKawasaki Motors Europe (KME) in Hoofddorp is part of Kawasaki Heavy Industries. It is the headquarters of the sales organization in Europe, supporting distributors and dealers of motorcycles, engines, mules, ATVs, Jetski's and associated parts (ranging from screws to clothing)► Programming languages & ToolsLE RPG IV (free format), RPG/400, DDS, CL, (Embedded) SQL, Java, PDM, RDi (Eclipse), Jasper Reports► Responsibilities / Tasks>> Development of new functionality or maintenance of existing functionality to support the sales organization consisting of distributors and dealers in Europe. This mainly concerns the software related to stock management, invoicing, printing of labels (barcode), EDI, for the "parts" department.>> Development of a Java framework for producing documents with Jasper Reports. Per type of document, supporting Java code is divided into a "pre task", "print task" and "post task".>> Technical support to users in using the software and solving common problems.

Schiphol-Rijk

Beerse

► CompanyMetallo Group, with recycling facilities in Belgium and Spain, has close to 100 years of experience resulting in state-of-the-art metallurgical processes. By recycling complex secondary raw materials and refining them into new metal products, Metallo has a key position in the circular economy.► Responsibilities / TasksDevelop new functionality and change requests in response to the merge of Metallo Spain. The software architecture uses highly modular ILE RPGIV components on the IBM i, in combination with Java client (PC) software using Swing and the JawFlow workflow framework. Creation/modification of forms and reports using Jasper Reports.

Zeist

Amsterdam En Omgeving, Nederland

Amsterdam En Omgeving, Nederland

► CompanyThe company develops and markets EasyOrder, a software package with which customers can easily implement B2B and B2C web shops.► Responsibilities / Tasks● Using the SCRUM methodology, implemented new solutions in collaboration with consultants.● Analyzed and fixed bugs.● Upgraded producing MS Excel reports with Apache POI to Office 2007 (.xlsx).● Optimized JVM performance (GC) using JNI functions.► PlatformsIBM i (AS/400), PC / Windows, Web Browser, Java (JVM)► Programming Languages & ToolsILE RPGIV (/free), DDS, CL, Embedded SQL, HTML, Javascript, jQuery 2, Service Programs & Modules, OS/400 API Programming (IFS, CGI, Crypto), Apache POI, PDM

Heerhugowaard

► CompanyASSA ABLOY is a global supplier of locks, gates and industrial doors. The establishment at Heerhugowaard is part of the Entrance Systems division where overhead doors are produced for different brands, in particular the well-known "Crawford" brand.► Responsibilities / Tasks● Modernization of (part of) the legacy RPG/400 code to ILE RPG (/free), making use of service programs and modules to produce modular software such that the software is better able to absorb changes in products like new door types or door amendments and in the logistic process.● Changing / extending the software, in particular related to changes in the logistic process. For example, one important change was the relocation of of producing the harness and springs from Heerhugowaard to Hungary. This required substantial changes in the logistic process.● Create complex reports using Excel / VBA. Created ​​a comprehensive framework that can easily be adapted for new reports. It consists of a stored procedure (RPGIV program on the server) that is called by Excel. The data is placed in one or more SQL tables with ODBC which are then read and processed by the Excel VBA application such that the user-supplied template sheets with their own format and column arrangement are filled with the data.► PlatformsIBM i (AS/400), PC / Windows, Excel (VBA)► Programming Languages & ToolsILE RPGIV (/free, RPG/400), DDS, CL, SQL (CLI), Query/400, Service Programs & Modules, Stored Procedures, OS/400 API Programming, Integrated File System (IFS), Excel (VBA), ODBC, RDi (eclipse), PDM

Amsterdam

► CompanyG-Star is an international fashion company. The company designs, manufactures and sells various fashion brands, the main one being "G-Star RAW".► Responsibilities / TasksCreating programs for reading and writing data from the database (DB2) for migration to SAP (ETL).► PlatformsIBM i (AS/400), PC / Windows► Programming Languages & ToolsRPG/400, DDS, CL , Embedded SQL, Commitment Control (journaling), SEU, PDM

Den Haag (The Hague)

► CompanyIntrum Justitia is Europe's leading credit management services company, with offices in 22 European countries. The primary process (collection) is supported by the in-house developed collection system. ► Responsibilities / Tasks● Maintenance of the system (e.g. due to regulatory changes) and programming of new functionality with all necessary documentation.● Develop different interfaces (C.S.V. files) with third parties, e.g. for transferring, receiving and processing files to and from bailiffs.● Develop several links from AS/400 to PC and vice versa, e.g. to open a browser with a specific link on the client PC initiated by an AS/400 (batch or interactive) RPG program.● Develop a link to "Accept mail" (a third party provides this functionality) such that a claim can be paid directly by the debtor through a link sent by e-mail.● In general, introduce the concept of modular programming and more specifically the usage of ILE RPGIV (/free) and service programs (mainly generic functions such as formatting and date checking).● Developing Web Services to enable a new front-end system for the call center to access back-end functionality through WAS (Websphere Application Server), JAX-WS and JT400.● Implement / configure / test WAS, Kerberos and LDAP to implement Single-Sign-On through web applications using SPNEGO authentication.● Functional / technical analysis, and making Functional Design and Technical Design.● Thinking along about long-term strategies / solutions for modernization of the legacy system code (modern user interface, "untangle" code, restructure database).● Tech support / advice / fix incidents. ► PlatformsIBM i (AS/400), PC / Windows, LAN, WAS, Java (JVM)► Programming Languages & ToolsILE RPGIV (/free) RPG/400), DDS, CL, SQL, Query/400, SrvPgms & Mods, Stored Procedures, Java, JT400, SOAP, Web Services, OS/400 API programming, IFS, RDi, PDM, OMS, X / Analysis, Subversion

Amsterdam

► CompanyWholesale of clothing of different brands. Operates a number of fashion brands, including their own brand Turnover.► Responsibilities / Tasks● Extend / change the in-house developed ERP system which covers the whole process of design, production and logistics.● Solve any production problems. ► PlatformsAS/400, PC / Windows► Programming Languages & ToolsRPG/400, DDS, CL, Query/400, PDM, Journalling / Commitment Control, iGenerate (RPG program generator)

The Hague (Den Haag)

► CompanyZ-Index is part of KNMP, De Koninklijke Nederlandse Maatschappij ter bevordering der Pharmacie ( (Royal Dutch Society for the Advancement of Pharmacy). The main product of this companyis the "G-Standard". This is a complete data collection of everything sold in the dutch pharmacies like medicines and related products. The data is represented with a vast array of tables containing all the data and all kinds of relations inbetween. These tables are monthly produced and distributed on CD or through the internet and intended to be used by applications used in the pharmacies.► Responsibilities / Tasks● System maintenance (e.g. due regulatory changes), programming new functionality and making documentation.● Developing a system with which the quality of the G-standard tables can be tested. Users can enter rules which consists of (user-developed) functions (like a modulus 11 test), and relationships between different fields in the same table or different tables. Part of this system was a custom made expression evaluator developed in ILE RPGIV (/free) in the form of a service program. It could be easily extended by fellow programmers with functions (like Mod11) and binary/unary single-character operators (like @ or %). The system produces a detailed report consisting of HTML pages which can be accessed from the network.● Participated in the development of a web application that allows distributers of medicines themselves can introduce new product and maintain. (Web) applications are developed using HTTP server (CGI) on the AS/400, developed with ILE RPG (RPG / free), and HTML / CSS and Javascript on the client (PC).► PlatformsAS/400, PC / Windows, Web Browser► Programming Languages & Tools

Helmond

► CompanyCom-Unit is a small software company which develops and markets a comprehensive ERP system for the transporting industry. It's mainly written in ILE RPGIV (/free) and RPG/400. Some front-end functions where added with Delphi.► Responsibilities / TasksDevelop and a web shop, which was meant to be hosted by a transporting company. Customers of the transporting company could then maintain their own data such as products and transporting plans. The server side of the web store was developed with Net.Data and ILE RPGIV (/free). The client (front-end) part for the the buyers of the transported goods consisted of HTML that was generated dynamically with Net.Data. The application that allows clients (the transporters) to maintain the database was created with Delphi (version 6)► PlatformsAS/400, PC / Windows, Web Browser, Net.Data, Delphi 6► Programming Languages & ToolsILE RPGIV (/free), RPG/400, CL, DDS, HTML / CSS, PDM, Delphi 6 (OO Pascal), Net.Data

Venlo

► CompanyA wholesale seller of car tires. The company imports and exports batches of tires worldwide.► Responsibilities / TasksDevelop several enhancements / modifications to the previously developed application for this company (see below). For example: local startup of the Java client program (i.e. without internet connection), another table-structure, order printing to customers.► PlatformsAS/400, PC / Windows, Java (JVM)► Programming Languages & ToolsJava (1.4), VisualAge for Java

Amsterdam

► CompanyDelta Lloyd is a Dutch insurance company, part of the Delta Lloyd Group, a company in financial services. The Delta Lloyd Group's range varies from savings products to complex insurance products and financial planning.► Responsibilities / Tasks● Development of an application for batch processing (bulk) of incoming mutations of the status of insurees, for example sick/leave for company employees. These were supplied externally (e.g. on diskette). The application was generically designed such that it could be easily adapted for different types of mutations by adding a new "Mutation" subclass.● Development of a framework that allows simple text files to be read with different formats.● Create comprehensive technical documentation.► PlatformsPC, Oracle, Smalltalk► Programming Languages & ToolsSmalltalk, VisualAge for Smalltalk

Venlo

► CompanyA wholesale seller of car tires. The company imports and exports batches of tires worldwide.► Responsibilities / TasksDevelop a Java application to replace a legacy DOS application which allows customers (other wholesalers) to view a list of available tires, sort the list in various ways, and maintain/view orders and their statuses. The application provides different assortments and selections, a function to view tire profiles, etc.► PlatformsAS/400, PC / Windows, Java (JVM)► Programming Languages & ToolsJava (1.4), VisualAge for Java

Den Haag

► CompanyThe Siebel Group consists of a number of jewelry chains. The head office uses a homemade system mainly for the logistic processes. This system was originally written in RPGII and was moved a few years before from an S/36 to a an AS/400. Meanwhile, parts of the software was rewritten in RPG/400. The main function of the system is to support the logistic processes (supply of branches), the processing of sales (data provided by the cash registers) and the interface with the financial system (journal entries). New (or significantly modified) applications were (re)written in RPG/400.► Responsibilities / Tasks● Created a template for new interactive RPG/400 applications. This allowed to quickly create new applications.● Troubleshooting, user support, build entirely new functionality and maintenance of existing.● Major projects during this period was to make the system Y2K resistant, building a new modulair order system using RPG/400, and building new functionality on behalf of a newly established franchise organization.► PlatformsAS/400, PC / Windows► Programming Languages & ToolsRPG/400, RPGII, CL, DDS, OCL , PDM, Query/400

Amsterdam

► CompanyWholesale of wooden furniture, kitchen accessories, mainly as a supplier of Gamma.► Responsibilities / Tasks● Developing a converter to convert existing RPG/400 programs to ILE RPGIV programs. It automatically converted all internal file definitions to externally defined ones.● Investigating the disadvantages and advantages of a modular design of the system in ILE RPGIV.► PlatformsAS/400, PC/Windows► Programming Languages & ToolsILE RPGIV, RPG/400, CL, DDS, PDM

Maarssen

► CompanySoftware consultancy specializing in Object-Oriented Programming. Develops and markets the model-based development environment "Sofa", based on OO language Smalltalk► Responsibilities / Tasks● Mainly involved with the development of Sofa, whichis a framework for creating business applications based on Smalltalk. In Sofa the developer defines a model based on Business Objects, their relationships and constraints. Business Objects may or may not be persistent and if so they can be stored in different types of data stores or storage systems such as an RDBMS or an OO database such as GemStone.● Worked as developer/consultant for Theodoor Gilissen. Contributed to the development of an automated system for buying and selling securities.● Hired by investment bank MeesPierson (ABN AMRO) for setting up the initial architecture of a framework to support Smalltalk projects. Based on the knowledge gained at Doosys when developing Sofa. After a half year Origin itself continued the further development of this framework.► PlatformsPC / AS/400► Programming Languages & ToolsSmalltalk, ILE RPG, Java, VisualAge for Smalltalk, PDM, Digitalk VSE, Parc Place, Gemstone