Summary
Overview
Work History
Skills
Timeline
Generic

Hugo Cantor

Summary

Results-driven IBM i (iSeries/AS400) consultant with deep experience guiding assessments, architecture, build, and deployment across legacy-to-modern transformations. Hands-on with RPG ILE, CL, DB2/400, SQL, and web/API patterns to modernize green-screen workflows, re-engineer data models, and connect IBM i with web, partner, and cloud systems. Trusted SME who partners with architects, developers, and business stakeholders to align technology with outcomes, mitigate risk, and deliver secure, performant solutions.

Overview

18
18
years of professional experience

Work History

Software Developer

Profound Logic
03.2023 - 07.2025
  • Resolved Profound UI tickets across JavaScript, RPG, SQL, and IBM i job control; promoted fixes through release cycles with clear ops documentation.
  • Maintained/enhanced DSPF-RPG shipping & inventory programs with structured change control.
  • Led the 30-screen Inventory Replenishment solution: defined presentation/service/data layers; built reusable REST middleware; designed normalized DB2/400 schemas, indexes, and stored procedures; implemented a maintainable TypeScript MVC front end.
  • Exposed curated views/endpoints feeding dashboards and scheduled BI/reporting.
  • Stabilized data exchange between Node.js services, DB2 on IBM i, and web clients; ensured reliable TCP/IP connectivity, session/security configuration, and deployment pipelines (SOA practices, partner/system workflows).
  • Supported JDBC/ODBC and API integrations; troubleshot third-party issues end-to-end.
  • Ran daily standups, sprint planning, reviews, and retros; organized requirements sessions with stakeholders; translated business requirements into technical designs with risk/mitigation plans.
  • Authored runbooks/architecture notes; mentored peers on programming fundamentals, SQL tuning, and IBM i best practices.
  • Improved system performance (optimized SQL and caching patterns), increased release predictability, and delivered reliable cross-system integrations aligned to enterprise standards.

Consultant IBM i Developer

Allied Beverage Group
01.2022 - 12.2022
  • Normalized product data (3 files → DDL tables + detail) and standardized field names; tuned queries/indexes and refactored access patterns for faster reads/writes.
  • Built an externally callable RPG stored procedure returning an open cursor with JSON, enabling low-latency consumption by services, reports, and BI tools.
  • Introduced an RPG procedure layer that isolated file changes, allowing 600+ programs to migrate with minimal defects—applying clean interfaces and testing discipline.
  • Wrote data-migration programs to move legacy data to the new schema; validated integrity and performance post-cutover.
  • Exposed curated views/JSON outputs used by reporting/analytics and partner applications.
  • Delivered on IBM i (iSeries/AS400) with sound OS setup and dependable TCP/IP connectivity supporting upstream/downstream integrations.

IBM i Developer

The vitamin shoppe
03.2019 - 01.2022
  • Replatformed third-party file exchanges from QNTC to SFTP; built a generic SFTP program (RPG/CL) and updated 50+ jobs to push partner data securely to cloud endpoints (TCP/IP), improving reliability and auditability.
  • Implemented Profound UI handler in the main menu driver; standardized web session/auth (automatic sign-on); exposed SOA-style entry points and callable utilities that other teams can reuse.
  • Modeled partner/export schemas, standardized CSV outputs consumed by vendors/BI, and tuned DB2/400 SQL access patterns to reduce I/O and latency.
  • Web-enabled JDA green-screen workflows for stores, adding UI affordances (clickable options) and JavaScript barcode scanning for iPad/browser users.
  • Stood up Profound UI across Dev/Test/Prod; packaged and promoted changes via Aldon LMI; documented runbooks and rollback steps.
  • Analyzed an Access-based workflow and produced an IBM i web solution proposal (database design, REST/JDBC/ODBC access, security, migration phases) with risk, mitigation, and success metrics for stakeholders.
  • Coordinated with store ops, vendor partners, and infra teams to schedule cutovers; communicated change impacts and trained devs on the reusable SFTP utility.
  • RPG/400, RPG-ILE, CL, DDS (DSPF/PRTF), JavaScript; clear architecture docs and deployment guides to serve as SME references.

IBM i Developer

Holy Name Medical Center
04.2012 - 02.2019
  • Built and maintained RPG/400, RPG-ILE, CL, DDS (DSPF/PRTF) assets; created a GENSRV utility suite (service programs) for IFS, sockets, logging, JSON, user spaces.
  • Deployed Zend Server and configured Apache virtual hosts; supported CGI programs and OS-level operations.
  • Designed SOA-style entry points (RPG procedures, PHP/Lumen APIs) to decouple UI and back-end.
  • Modeled DB2/400 schemas, wrote optimized SQL, stored procedures, and UDTFs; parsed CDA/HL7 using XMLTABLE for clinical data pipelines and BI/reporting.
  • Exposed/consumed REST (OAuth2 gateway bridging PHP ↔ legacy RPG CGI).
  • Integrated .NET websites with IBM i data; exchanged JSON from PHP and RPG; synchronized DB2 (IBM i) with MS SQL consumers via JDBC/ODBC and curated views.
  • Implemented messaging and partner workflows (DrFirst web APIs; SMS modem API for text alerts; VCard generation and delivery).
  • Delivered single-page applications (Sencha Ext JS, jQuery) backed by PHP APIs and DB2 procedures; built an internal hospital site for Haiti staff.
  • Collaborated with clinicians, vendors, and IT teams; translated business needs into technical designs; documented architecture and runbooks; presented modern RPG/RDi/SQL practices; mentored interns/colleagues.
  • Supported risk quantification and mitigation (auth flows, data integrity checks, rollback plans).
  • Exposed curated data (views/SPs/UDTFs) to BI/reporting tools.
  • Managed OS/web stack (IBM i, Apache/Zend), and ensured reliable TCP/IP connectivity and security for third-party integrations.

IBM i Developer

Haddad Brands
09.2007 - 04.2012
  • Built and maintained RPG/400, RPG-ILE, CL, DDS (DSPF/PRTF) assets; delivered browser-based applications on Valence and Presto; deployed and supported a Magento e-commerce site on IBM i.
  • Translated business needs into layered designs (UI, service, data). Authored DB2/400 schemas, optimized SQL, stored procedures, and reusable ILE service programs; implemented logging, error handling, and configuration UIs (Excel Report Generator, SENDREPORT).
  • Shipped an Executive Dashboard and Web Fill-Rate reporting with curated views/endpoints for stakeholders; enabled scheduled outputs and drill-downs.
  • Built a JDBC Java connector to join IBM i data with MS SQL image stores; enabled real-time shipment-management updates to DB2; implemented Kerberos SSO for IBM i web apps; supported partner/system workflows with secure network configuration.
  • Gathered requirements with business and vendors; ran demos/reviews; mentored colleagues on ILE construction, embedded SQL, and query optimization; presented on modern RPG, RDi, PHP, and change control.
  • Identified integration risks (auth, data integrity, rollout); provided mitigation plans and rollback paths; produced architecture docs and operational runbooks.

Consultant

Seiden Group
02.2022
  • Analyzed and debugged a PHP application written in the Symfony framework. Skills required for this task was knowledge of PHP, JavaScript, HTML and JSON.

Skills

  • RPGLE
  • CLLE
  • SQL
  • IBM i
  • Zend Server on IBM I
  • Windows 10
  • Mac OS
  • Linux
  • Vagrant virtual machines
  • IBM i Web Development
  • Architecture & Design
  • Stored Procedures
  • Functions
  • Full Development Lifecycle
  • Structured Programming Methodologies
  • Debugging & Problem Resolution
  • Solutions Development
  • Requirements Analysis
  • Team Leadership
  • CLP
  • Embedded SQL
  • JavaScript
  • PHP
  • C#
  • Java
  • HTTP APIs
  • List APIs
  • User Spaces
  • Error Handling
  • CGI APIs
  • C Function APIs
  • IFS APIs
  • DB2
  • MySQL
  • MS SQL
  • Oracle
  • Aldon LMI
  • RDi
  • GitHub
  • Profound UI
  • SQL Performance Monitors

Timeline

Software Developer

Profound Logic
03.2023 - 07.2025

Consultant

Seiden Group
02.2022

Consultant IBM i Developer

Allied Beverage Group
01.2022 - 12.2022

IBM i Developer

The vitamin shoppe
03.2019 - 01.2022

IBM i Developer

Holy Name Medical Center
04.2012 - 02.2019

IBM i Developer

Haddad Brands
09.2007 - 04.2012

Similar Profiles

  • Kimberly Sanchez

    Kimberly SanchezKimberly Sanchez

    Behavioral Health Technician at Profound TreatmentBehavioral Health Technician at Profound Treatment

  • Chaim Blum

    Chaim BlumChaim Blum

    Lead Behavioral Health Technician at Profound Treatment CentersLead Behavioral Health Technician at Profound Treatment Centers

  • Mairajuddin Umer

    Mairajuddin UmerMairajuddin Umer

    Business Development & Operations Manager at Profound Properties LtdBusiness Development & Operations Manager at Profound Properties Ltd

  • KUMAR GAURAV

    KUMAR GAURAVKUMAR GAURAV

    IBM Cloud and Storage Developer – Software Developer, Software Developer at IBM, DELL INDIAIBM Cloud and Storage Developer – Software Developer, Software Developer at IBM, DELL INDIA

  • Manikanta Yekkateela

    Manikanta YekkateelaManikanta Yekkateela

    Software Developer, Sr Software Developer at Zensar TechnologiesSoftware Developer, Sr Software Developer at Zensar Technologies

CREATE PROFILE
Hugo Cantor