Programmer

Diverse programming tasks as specified. Work performed from home office, meetings and tasks via email and phone, Webex, and Jabber. Implementation with RDI.

• Created triggers and service programs in SQLRPGLE, FreeRPG, ILE RPG, and CLLE.
• Converted a green-screen simulation program into a fully interactive FreeRPG application, with SQL data access; handled simulation requests from the front end in batch, passing data via userspace and a service program back to the front end.
• Cross-iSeries data import and processing in SQLRPG; developed automatic backup monitoring across all iSeries; logged and analyzed system changes.

Diverse programming tasks as specified. Work performed from home office, meetings and tasks via HipChat and Jira. Implementation with RDI, installations at multiple sites under own responsibility. Systems on release V5R3 to V7R1. Created triggers and service programs in SQLRPGLE, FreeRPG, ILE RPG, RPG IV, and CLLE, broken down into functions, procedures, and modules.

• Dialog and batch programming with varying levels of complexity.
• Replaced complex RPG native file accesses with simplified SQL accesses.
• Handled daily operations (requirements and error messages).
• Converted file accesses to SQLRPGLE service programs.
• Created an email function with CMD via MIME/SMTP for up to 250 recipients in To/CC/Bcc. Up to 250 attachments in PDF, text, binary, PS, and iSeries file formats with or without field headers. Subject and body written directly, via IFS with C APIs or files. Body formatted in HTML.
• Read XML data for order entry – created XML data and passed it to the IFS with C APIs for the control PCs on the shop floor.
• Created a conversion job with criteria for a full system run or updates when files, DSPFs, PRTFS, or service programs changed.
• Created an asynchronous daily/weekly/monthly backup job with storage on a remote system. (The remote system accesses the backup log, processes the required entries, retrieves the SAVFs via FTP, and logs the success in the remote file.)

Various program adjustments in Java, SQL RPGLE, FreeRPG, ILE RPG, RPG IV, CLLE.

• Process control, XML preparation, dialog programming, print formatting of shipping documents via XML, controlling Java programs, calling different service programs from Java for process optimization.

Inventory valuation report for management:

• Gathering data from various systems received via EDIFACT, Excel, text files, sales data from POS system, iSeries.
• Preparing this data for processing, evaluating the stock.
• Outputting the data also to IFS and as Excel CSV.
• Created in embedded SQL, FreeRPG, ILE RPG, CLLE, Excel.

EDIFACT D96A converter programming and setup for different clients:

• Preparing invoice data and sending via EDIFACT.
• Parsing order data from clients via EDIFACT and transferring into order files.
• Preparing and analyzing product data (Pricat) for clients.
• Created in embedded SQL, FreeRPG, CLLE.

Various program adjustments as required:

• Modifying various programs as specified.
• Created in embedded SQL, FreeRPG, CLLE, RPG IV, Java.

• ERP system extension - management information system: project management, development, programming. Creating a management information system in purchasing for the foreign headquarters to determine turnover frequency and share of sales.
• Connecting mobile data entry devices via TCP/IP and W&T box: project assistant, programming. Interfaces in C++ and routines to receive and send to the W&T box over TCP/IP using socket programming.
• Warehouse management, logistics, stock control, inventory processing: programming. Extending warehouse management, stock control, inventory processing, and stock-based ordering.
• Creating market postings for DCW / SAP: team leader, execution, programming. Importing cash register and market data via FTP into the ERP, determining posting texts and codes, defining and populating the accounting interface for DCW and SAP.
• New unified numbering system in the ERP: project management, execution, programming. Developing a new universal number assignment system for domestic and international use.
• ERP system extension - retroactive supplier discount, bonus calculation: team lead, execution, programming. Calculating retroactive supplier bonuses across the group with respect to legal regulations. Including invoice creation and interface to DCW and SAP.
• Subproject Bonus - simultaneous multilingual print outputs: project management, execution, programming. Converting various print outputs to support simultaneous multilingual output (e.g., first print in Russian, copy in Ukrainian, and second copy in English).
• Supplier delivery rate: programming. Developing new and adjusting existing programs to determine supplier reliability.
• DCW accounting extension - accounting Germany: project assistant, execution, programming. Various program extensions and adjustments in DCW as specified.
• Supplier information system: project management, execution, programming. Extraction programs for analyzing and compressing data from the ERP system, domestic and international. Forwarding to various computer platforms via FTP.
• Automatic creation of a new foreign headquarters: project management, execution, programming. Routine to automatically create a new headquarters including users, profiles, system values, and data.
• Automatic creation of a new market: project management, execution, programming. Routines to automatically create a new market domestically and abroad.
• Automating night market processing with centralization: project management, execution, programming. Automating the night market processing with variable control, parallel processing, and logging.
• Standardizing fixed texts in printouts: project management, execution, programming. Creating a universal module/subroutine to standardize headers and footers in different languages.
• Euro conversion: programming. Converting the entire ERP system to the euro, checking data for fixed texts, and integrating conversion routines.
• Year 2000 conversion: programming. Converting the entire ERP system to date fields, changing all date fields to 10-digit date fields.
• Others: consulting, programming, first and second level support. Converting /36 programs to ILE RPG programs. Supporting foreign subsidiaries and employees working in Germany. Maintaining and further developing the multilingual user menu. Developing and expanding in-house software.

• New installation of IBM AS/400 and migration of existing data.
• System optimization and maintenance on IBM AS/400.

ERP Package – Material management area:

• Group leader, programming. Built in SQLRPGLE, ILE RPG, RPG400, CLP, RPGLE, SQL, CLLE.
• New development of the scheduling module and order suggestions.
• New development of a warehouse management system including off-site and external warehouses, goods in transit, logistics, inventory control, and stocktaking.
• Development of a PPS system with automatic parts list generation, cost calculation, quote creation, and order creation.
• Transfer of calculated data to production and to CNC machines.
• Invoice creation for an order.
• Support of the ERP system and further development as per specifications.

Network technology and system integrations:

• Project management and execution.
• Connecting AS/400 to various computer platforms.
• Integration and connection of PCs via Twinax and Ethernet.

Developed in RPGII, RPG400, OCL and CLP.

• Migration /36 to AS/400: Converted the /36 system including data and programs.
• Other: Development and extension of batch and dialog applications of the ERP in manufacturing, sales, payroll and wages. Optimization of production planning, purchasing and distribution.