Alois Gruber
IT Consultant / EDP Management
Experience
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Similar Freelancers
Discover other experts with similar qualifications and experience