We have accomplished a number of projects using Progress OpenEdge Database technology. A sampling is listed below:
CONSULTANT – Provided user documentation for manual data
integration between the QAD Enterprise Edition ERP system and American Express
One AP™ Accounts Payable automation system.
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
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
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
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.
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),