We have accomplished a number of projects using Progress OpenEdge Database technology. A sampling is listed below:

TECHNICAL WRITING CONSULTANT Provided user documentation for manual data integration between the QAD Enterprise Edition ERP system and American Express One AP™ Accounts Payable automation system.


SYSTEM MIGRATION ENGINEER – Worked as a System Engineer for a retail distributor in the process of migrating from HP Unix (HP-UX 11) to Red Hat Enterprise Linux (RHEL 8.3). Acted as Migration Engineer/Developer and Project DBA. (Oct 20-Aug 21)

·     Migrated system resources and subsystems existing on current HP-UX system to Linux system. Created new databases with improved infrastructure; wrote migration scripts. Subsystems included: emailing (sendmail), FacetTerm integration (migrated from HP TSM), interfaces to C and Perl programs, CUPS printing system.

·     Wrote program to analyze 11,000+ legacy application programs, Varnet ERP, written in Progress OpenEdge ABL (4GL) for potential system interface issues. Analyzed and documented discrepancies.


QAD TO SAP MIGRATION PROJECT – Delivered technical and functional services on the Extraction Team of a multi-plant SAP Migration Project as Progress Data Extractor and QAD/Progress Consultant for a multi-national corporation. SAP modules included FF, SO/DP, MM, WH, HU, FI/CO and PE/CP. (Nov 17-Oct 18)

·        Made modifications to QAD data structures and Progress data extraction code for plant-specific needs. Also implemented code changes for timesaving and efficiency using Linux scripting and Progress ABL (4GL) code.

·        Worked on data cleansing and preparation with key users FF and SO/DP data before enrichment and extraction was required. Harvested data from QAD to produce SAP-enriched data ready for import into SAP MM module.

·        Created comprehensive workflow spreadsheets to detail extraction and migration tasks, showing their correlation to input and output processes in the QAD and SAP ERP systems.

·        Develop and execute extraction processes for data loading into SAP LSMW processes, especially for FI/CO, SO/DP, and FF modules. Analysis of SO/DP and FF data for migration team.


WAREHOUSE MANAGEMENT SOFTWARE DEVELOPMENT PROJECT – Work as a Progress OpenEdge programmer and integrator on a development team tasked with the development of a Microsoft Windows UI, .NET compatible custom warehouse management application (OpenEdge GUI .NET) designed to run on Surface tablets. Used PDSOE 11.5 and 11.6, an Eclipse-based development platform, and class-based forms to achieve full object-oriented design and state-free deployment. (Oct 15-Apr 16)

·        Designed and developed system to leverage legacy report logic executed by new user-friendly Windows user interface. Legacy code was executed using a Progress AppServer.

·        Worked closely with original designers on the inbound messaging logic to redesign the functionality. Developed code in which load and order data is completely independent, and message file extraction methods are in a separate file from methods which access, create and update database records.

·        Updated queries in codebase of original, character-based warehouse system application to make use of schema improvements, new tables, indexes, and new fields in existing tables.

·        Developed a report calling framework utilizing ProDataSet structures to pass information back and forth with an application server to achieve state-free program deployment. Framework handles email output, Excel spreadsheet object creation, standard text, and printers. Emails are originated centrally on AppServer.


PROGRAMMING SUPPORT FOR IN-HOUSE SYSTEM – OpenEdge ABL (4GL) Programmer for large, privately-held food service company with $10 billion annual sales. (Jan 14-Jun 14)

·        Modified in-house developed Progress-based enterprise management system to business user requirements and change requests. Followed client’s DevOps style SDLC methodology to make changes needed by the business.

·        Worked on a team revamping and expanding the membership-based loyalty system. Performed extensive data analysis and coding for name-field reformatting.

·        Developed interface programs to integrate middleware system with in-house application using Progress AppServer and third-party applications, e.g., Product Lifecycle Management System (PLMS), ExactTarget.

QAD: Our Passion, Your Advantage.