27.09.2026 aktualisiert
100 % verfügbar
IBM i (AS/400) RPGLE Developer – SQL, CL, DDS, Db2 for i
Indonesien
Nur Remote
BSc Computer Science – UMS, IndonesiaÜber mich
IBM i (AS/400) developer with 7 years in core banking. I work every day with RPGLE, SQLRPGLE, CL, DDS and Db2 for i: bug fixes, enhancements, SQL reports, free-format modernization and REST/JSON integrations. Remote, about 30 h/week, UTC+7. Sample code: github.com/dodikibmi/ibmi-inventory
Skills
Db2/400IBM System IIBM DB2IBM IIbm RpgJSONWindows Application Programming InterfaceRpl Programming LanguageIntegration (Software)Core BankingRestful ApisÄltere Systeme
IBM i Programming (RPG, CL, DDS)
Expertise in RPG IV (RPGLE fixed and hybrid free-format), SQLRPGLE, CL (CLLE, CLP), DDS (DSPF, PRTF, PF, LF), SQL PL, Python, and Bash. Over 2,000 source members created or modified and 460,000+ lines of RPG, CL and DDS source worked on across 100+ work packages.
Db2 for i Database Development
Proficiency in DDL, views, indexes, journaling, commitment control, JSON functions (JSON_TABLE, JSON_OBJECT, JSON_ARRAYAGG), MERGE, and QSYS2 services. Designing physical and logical files with SQL DDL including keys, constraints, identity columns, and journaling.
Core Banking Application Development
Seven years of experience building and maintaining core banking applications for a regional bank in Indonesia, covering deposits, loans, cards, payments, and API integrations. Full-cycle work on a production system including reading and fixing legacy RPG, writing new programs, and supporting production.
ILE Service Programs and Modular Design
Knowledge of ILE modules, service programs, binder source and signatures, binding directories, activation groups, and prototypes. Development of ILE service programs with *CURRENT / *PRV signatures and RPGUnit test suites.
API Integration and Web Services
Experience with HTTPAPI, YAJL, DATA-INTO, QSYS2.HTTP_GET, sockets, REST APIs, and JSON. API registration and routing for digital channels including JSON over HTTP and Bank Indonesia SNAP open-API standard.
Tooling and Source Management
Use of RPGUnit, Git / GitHub, Code for IBM i (VS Code), IBM i Access Client Solutions, PDM / SEU, IBM i 7.4 and 7.5. Maintaining 450+ versioned backups to ensure every edit is traceable and can be rolled back.
Green-Screen Application Development
Building complete green-screen applications including load-all subfile, maintenance with optimistic locking, stock movements under commitment control, stock card, reusable F4 prompt window, and 132-column reports with multi-row FETCH.
Production Support and Root-Cause Analysis
Root-cause analysis from compile listings, job logs, and database journals. Data corrections and verification with SQL, and multi-stage automated compile pipeline for source promotion.
Expertise in RPG IV (RPGLE fixed and hybrid free-format), SQLRPGLE, CL (CLLE, CLP), DDS (DSPF, PRTF, PF, LF), SQL PL, Python, and Bash. Over 2,000 source members created or modified and 460,000+ lines of RPG, CL and DDS source worked on across 100+ work packages.
Db2 for i Database Development
Proficiency in DDL, views, indexes, journaling, commitment control, JSON functions (JSON_TABLE, JSON_OBJECT, JSON_ARRAYAGG), MERGE, and QSYS2 services. Designing physical and logical files with SQL DDL including keys, constraints, identity columns, and journaling.
Core Banking Application Development
Seven years of experience building and maintaining core banking applications for a regional bank in Indonesia, covering deposits, loans, cards, payments, and API integrations. Full-cycle work on a production system including reading and fixing legacy RPG, writing new programs, and supporting production.
ILE Service Programs and Modular Design
Knowledge of ILE modules, service programs, binder source and signatures, binding directories, activation groups, and prototypes. Development of ILE service programs with *CURRENT / *PRV signatures and RPGUnit test suites.
API Integration and Web Services
Experience with HTTPAPI, YAJL, DATA-INTO, QSYS2.HTTP_GET, sockets, REST APIs, and JSON. API registration and routing for digital channels including JSON over HTTP and Bank Indonesia SNAP open-API standard.
Tooling and Source Management
Use of RPGUnit, Git / GitHub, Code for IBM i (VS Code), IBM i Access Client Solutions, PDM / SEU, IBM i 7.4 and 7.5. Maintaining 450+ versioned backups to ensure every edit is traceable and can be rolled back.
Green-Screen Application Development
Building complete green-screen applications including load-all subfile, maintenance with optimistic locking, stock movements under commitment control, stock card, reusable F4 prompt window, and 132-column reports with multi-row FETCH.
Production Support and Root-Cause Analysis
Root-cause analysis from compile listings, job logs, and database journals. Data corrections and verification with SQL, and multi-stage automated compile pipeline for source promotion.
Erfahrung
Berufserfahrung5 - 10 Jahre
Freelancer seit2026
Sprachen
Englishverhandlungssicher
Projekthistorie
Personal portfolio project (github.com/dodikibmi/ibmi-inventory) on IBM i 7.5 (PUB400). Complete green-screen application with load-all subfile, optimistic locking, stock movements under commitment control, stock card, reusable F4 prompt window, and 132-column report with multi-row FETCH. Db2 for i designed with SQL DDL, ILE service program with RPGUnit test suite (8 test cases, 24 assertions), and REST integration in both directions using QSYS2.HTTP_GET, JSON_TABLE, MERGE, and a Python REST API in PASE.
Core banking development and production support on IBM i. Responsibilities include deposits (account opening, CIF flows, dormant-account lifecycle), loans (credit quality classification, payroll-deduction billing), cards (credit card billing, monthly e-mail statements with PDF), payments (local-government tax payment channels, revenue-sharing split), API integration for digital channels (JSON over HTTP, HTTPAPI, YAJL, DATA-INTO, Bank Indonesia SNAP open-API), tooling (socket-based host simulator, automated compile pipeline), production support (root-cause analysis, data corrections with SQL), and parameter-driven program design.