Recommended expert

Alois Gruber

IT Consultant / EDP Management

Alois Gruber
Düsseldorf, Germany

Experience

Jan 2021 - Dec 2024
4 years

Bank DZ Privatbank S.A.

  • Various programming tasks as specified
  • Performed in home office; meetings/tasks via email, phone and Microsoft Teams
  • Logging via GIT
  • Implementation with RDI, FreeSQL SQL
  • Extended automated test environment creation as specified – adding automatic import of existing iSeries users and processing and anonymization of test data
  • Creation of trigger and service programs in SQLRPGLE, Free RPG, ILE RPG and CLLE
  • Development and implementation of the CallKredite project, including additional extensions for other departments
  • Conversion of RPG to Free RPG and SQL, as well as extending existing modules per specifications
  • Migration to new bank release
  • Support for business segment / OIV
Jan 2019 - Dec 2021
3 years

Dachser

  • Various programming tasks as specified
  • Performed in home office; meetings/tasks via email and phone, WebEx and Jabber
  • Implementation with RDI
  • Creation of trigger and service programs in SQLRPGLE, Free RPG, ILE RPG and CLLE
  • Development of a simulation program from green screen to a full Free RPG application with SQL data access
  • Batch simulation with data transfer via user space and a service program to pass data to the front end
  • Cross-iSeries data transfer and processing in SQLRPG
  • Programming of automatic backup checks across all iSeries systems, including logging and evaluation of system changes
Jan 2018 - Dec 2019
2 years
Hamburg, Germany

Kühne und Nagel

  • Various program adjustments in SQLRPGLE, Free RPG, ILE RPG, RPG IV and CLLE
  • Performed in home office; meetings/tasks via WebEx and Jira
  • Process control and XML processing
  • Dialog programming and print formatting of shipping documents via XML
  • Generation of XML from spool files and additional data
  • Automatic monitoring and control of batch jobs for optimal management of automated processes
Jan 2013 - Dec 2018
6 years
Kirchheim unter Teck, Germany

Mosolf SE & Co. KG

  • Various programming tasks as specified

  • Performed in home office; meetings/tasks via HipChat and Jira

  • Implementation with RDI and installation at multiple sites with full responsibility (systems on releases V5R3 to V7R1)

  • Application programming in SQLRPGLE, Free RPG, ILE RPG, RPG IV and CLLE

  • Dialog and batch programming with varying levels of complexity

  • Replaced complex RPG native file accesses with simplified SQL access

  • Handling day-to-day tasks (requirements and error corrections)

  • Implemented file accesses in SQLRPGLE service programs

  • Created an email function via command (CMD) using MIME/SMTP with up to 250 recipients in To/CC/Bcc and attachments (PDF, text, binary, PS)

  • Extracted XML data for incoming orders and passed it to the IFS via C-API for control PCs in production halls

  • Created conversion jobs for full system updates or incremental changes

  • Set up asynchronous backup jobs (daily/weekly/monthly) stored on remote systems with automatic success notifications

Jan 2012 - Dec 2013
2 years
Luxembourg

DEKA-Bank

  • Various programming tasks based on design specifications
  • Application programming in SQL stored procedures (procedures and functions), SQLRPGLE, Free RPG, ILE RPG, CLLE service programs and Java
  • Breakdown into functions, procedures and modules
  • Redesign of the order engine
  • Took over the Kreuzverteilung Sicherheiten Darlehen project
  • Dialog programming
Jan 2011 - Dec 2012
2 years
Hamburg, Germany

Kühne und Nagel

  • Various program adjustments in Java, SQLRPGLE, FreeRPG, ILE RPG, RPG IV, and CLLE
  • Process control and XML preprocessing
  • Dialog programming and print formatting of shipping documents via XML
  • Control of Java programs and calling various service programs from Java for process optimization
Jan 2011 - Dec 2011
1 year
Luxembourg

DEKA-Bank

  • Various programming tasks based on specifications
  • Application programming in SQL stored procedures (procedures and functions), SQLRPGLE, FreeRPG, ILE RPG, CLLE service programs, and Java
  • Support in the Tax Data project
  • Menu programming and dialog programming
  • Support in the Order Engine project
Jan 2010 - Dec 2011
2 years
Kassel, Germany

Rohde Schuhe

  • Project management and development for evaluating inventory valuation for the executive board

  • Programming in embedded SQL, FreeRPG, ILE RPG, CLLE, and Excel

  • Consolidation of data from EDIFACT, Excel, text files, POS system, and iSeries

  • Preparation of inventory data and output to the IFS as well as Excel CSV

  • Programming of an EDIFACT D96A converter for various clients

  • Project management and development for preparation and transmission of invoice data (Invoice), order data (Orders), and item data (Pricat) via EDIFACT

  • Various program adjustments as specified in embedded SQL, FreeRPG, CLLE, RPG IV, and Java

Jan 2009 - Dec 2010
2 years
Mönchengladbach, Germany

Santander Consumer Bank

  • AV system programming and system control

  • Development and execution in embedded SQL, FreeRPG, ILE RPG, and CLLE

  • Participation in installation and testing of consumer credit guidelines (VKR) and Basel requirements

  • Handling daily operations and participating in tests of the month-end run as well as month-end and year-end closing

  • Menu development/modification and interactive SQL analyses and changes

Jan 1998 - Dec 2009
12 years
Kirkel, Germany

Praktiker

  • Extension of the ERP system and development of a management information system in purchasing for foreign headquarters to determine turnover frequency and sales share

  • Programming in embedded SQL, FreeRPG, ILE RPG, and CLLE under the ILE concept

  • Base modules: item data, order quantities, sales quantities, promotional sales, order backlog

  • Distribution to markets and periods (month/quarter/year) and calculation of percentage shares and totals

  • Automatic extension when adding new markets and preparation of data for Excel

  • Integration of mobile data entry devices via TCP/IP and W&T box (CLLE, RPG, C++) with socket programming

  • Expansion of warehouse management, inventory control, inventory processing, and stock-dependent planning (SQLRPG, FreeRPG, SQL, CLLE, ILE)

  • Creation of booking interfaces for DCW and SAP using FTP scripts and FreeRPG, embedded SQL, CLLE, ILE

  • Development of a unified numbering system for markets and headquarters at home and abroad in FreeRPG, embedded SQL, and CLLE

  • Automated creation of new foreign headquarters and markets as well as night processing for markets with centralization in CLLE, FreeRPG, ILE RPG, and embedded SQL

  • Standardization of fixed texts and header/footer lines for documents in multiple languages and adaptation of label outputs

  • Execution of the € conversion and Y2K conversion in ILE RPG, RPG, CLLE, and CLP

  • Consulting, programming, and support (first and second level) with migration of /36 programs to ILE RPG

Jan 1996 - Dec 2002
7 years
Nuremberg, Germany

Rogg Polycell GmbH

  • Support, project management and programming in SQLRPGLE, ILE RPG, RPG400, CLP, RPGLE, SQL, CLLE, RPGII and OCL

  • New development of an order management system and a management information system for a metal and plastic foundry

  • System optimization and maintenance on IBM AS/400

  • Further development and modification of the ERP system and migration of /36 programs to AS/400 (order management, inventory planning, PPS)

  • Implementation of a simple warehouse management

Jan 1994 - Dec 1998
5 years
Nuremberg, Germany

Siscoform Siebert Schmitt + Co GmbH

  • Consulting, support and project management for a new installation of an IBM AS/400 and migration of existing data
  • System optimization and maintenance on IBM AS/400
Jan 1992 - Dec 1998
7 years
Westendorf, Germany

Perfecta Rolladen GmbH

  • Consulting, support and project management for the enhancement and modification of an ERP system for plastic window manufacturing
  • Development and implementation of the warehouse management
  • Migration and adaptation of /36 programs to AS/400 in order management, inventory planning, PPS as well as payroll
  • System optimization and maintenance on IBM AS/400
Jan 1990 - Dec 2003
14 years
Dürrwangen, Germany

GIO Gesellschaft für Informatik und Organisation mbH

  • Team leadership and programming in the ERP material management module for inventory planning, warehouse management, logistics, inventory management, inventory processing and PPS

  • Development in SQLRPGLE, ILE RPG, RPG400, CLP, RPGLE, SQL and CLLE

  • New development of modules for inventory planning, purchase suggestions, warehouse management (external warehouse, third-party warehouse, goods in transit), logistics, inventory management and inventory processing

  • Development of a PPS system with automatic bill of materials creation, BOM cost calculation as well as quote and order generation

  • Data transfer to production and CNC machines as well as invoice processing

  • Support and further development of the ERP system

  • Connection of different computer platforms and integration of PCs via Twinax and Ethernet

Jan 1990 - Dec 1997
8 years
Nuremberg, Germany

Noris Druckguss GmbH

  • Consulting, support and project management for migration from /36 to IBM AS/400
  • System optimization and maintenance on IBM AS/400
  • Enhancement and modification of a PPS system as well as warehouse management
Jan 1988 - Dec 1990
3 years
Oettingen in Bayern, Germany

Moralt-Fertigelemente Oettingen

  • Migration from System/36 to AS/400 including data and program conversion in RPG II, RPG400, OCL, and CLP
  • Development and support of batch and interactive applications for manufacturing, sales, and payroll
  • Optimization of production planning (PPS), purchasing, and sales
Jan 1987 - Dec 1988
2 years
Gunzenhausen, Germany

Standard Elektrik Lorenz

  • Development in the TSO environment with COBOL and CL
  • Creation of COBOL programs on IBM mainframes with OS/390/MVS
  • Creation of TSO dialogs and interactive program packages

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (20 years), Manufacturing (16 years), Retail (14 years), Banking and Finance (9 years), Transportation (6 years), and Professional Services (5 years).

Information Technology
Manufacturing
Retail
Banking and Finance
Transportation
Professional Services

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (38 years), Supply Chain Management (20 years), Production (16 years), Project Management (15 years), Procurement (15 years), and Logistics (14 years).

Information Technology
Supply Chain Management
Production
Project Management
Procurement
Logistics

Summary

With my many years of experience on the iSeries, I am considered a competent expert. This is backed by excellent references. My specialty is programming in all RPG and CLP variants, including ILE RPG, Free RPG and SQLRPGLE with and without embedded SQL. I work with SQL stored procedures, SQL tables and service programs. I am also very familiar with the ILE concept. Additionally, I am skilled in interface programming across various platforms. My knowledge of COBOL, Java, C/C++ and .NET rounds out my profile. I also have strong skills in reading and processing XML and C-APIs like Qp0zGetAllSysEnv (reading dirs), opendir, readdir, strerror and __errno, as well as reading from and writing to the IFS.

My programming style is fluid and well-documented, making it easy to read for other programmers. I see challenging tasks as an opportunity, and I complete them quickly whether I work alone or as part of a team. In a team, I am always valued and welcomed for my solid technical knowledge, creative ideas and friendly manner.

Skills

  • Functions: Programmer, Systems Programmer, Application Programmer, Erp And Pps Systems, Software Analyst, Team Leader, Project Assistant, Project Management, User Support, It Department Support

  • Programming Languages: Sqlrpgle, Free Rpg, Ile Rpg, Rpg400, Rpgiii, Rpgii, Java, Sql, Sql Stored Procedures, Templates, Embedded Sql, Sql/rpgle Functions, Procedures, Modules And Service Programs, Clp, Clle, C, C#, Cobol, Cbl, Cblle, Rexx, Ftp, Ftp Scripts

  • Hardware: Ibm Ix, Iseries, As/400, Network Technology, Interfaces To Cnc Production Machines, Pc

  • Operating Systems: Os/400, Windows

  • Protocols/miscellaneous: Ifs, Apis, C-apis, Tcp/ip, Socket Programming, Ms Office, Openoffice, Outlook, Lotus Notes, Websphere, Rdi, Dbeaver, Postman, Turnover, Cm One, Excel, .Net, Windows Server 2008, Remedy, Qaf, Sap Accounting, Edi, Dcw, Html, Php, Javascript, Erp, Aix, Linux, Git

Languages

German
Native
English
Advanced

Education

Secondary school diploma / advanced technical college entrance qualification · IT Consultant / EDP Management

Chamber of Commerce and Industry exam · IT Clerk · Grade 1.3

Certifications & licenses

IT Clerk with Chamber of Commerce and Industry certification

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Alois based?

Alois is based in Düsseldorf, Germany.

What languages does Alois speak?

Alois speaks the following languages: German (Native), English (Advanced).

How many years of experience does Alois have?

Alois has at least 38 years of experience. During this time, Alois has worked and for 15 different companies. The average length of individual experience is 2 years and 3 months. Note that Alois may not have shared all experience and actually has more experience.

What companies has Alois worked for in recent years?

In recent years, Alois has worked for Bank DZ Privatbank S.A. and Dachser.

Which industries is Alois most experienced in?

Alois is most experienced in industries like Information Technology (IT), Manufacturing, and Retail. Alois also has some experience in Banking and Finance, Transportation and Logistics, and Professional Services.

Which business areas is Alois most experienced in?

Alois is most experienced in business areas like Information Technology (IT), Supply Chain Management, and Production/Manufacturing. Alois also has some experience in Project Management, Procurement and Purchasing, and Logistics.

Which industries has Alois worked in recently?

Alois has recently worked in industries like Banking and Finance and Transportation and Logistics.

Which business areas has Alois worked in recently?

Alois has recently worked in business areas like Information Technology (IT).

What is Alois's education?

Alois attended education in IT Consultant / EDP Management.

Does Alois have any certificates?

Alois has 1 certificate: IT Clerk with Chamber of Commerce and Industry certification.

What is the availability of Alois?

Alois is immediately available part-time for suitable projects.

What is the rate of Alois?

Alois's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Alois?

To hire Alois, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 860-1020 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.