Mark Flores

markfl@floresconsulting.com (312) 371-4471 - phone

Retail Applications

Master File Maintenance
Purchase Order Management
Store Order Processing
Replenishment
Customer Order Processing
Receiving
Distribution
Transfers
RTV Inventory Control
Carton Management
Warehouse Operations
Price Changes
Retail Stock Ledger
Merchandise Planning
General Ledger
Sales Audit
Inventory Audit
Inventory Stock Ledger
Sales Analysis
Cash Balancing
Store Data Interchange(SDI)
EDI X.12
RF Functions
Advanced Shipping Notice(ASN)
Invoice Processing
Monarch & Zebra Printer Labels

Logistics Applications

Truck Loads
Customer Orders
Bill of Lading
Load Price Lookup
Carrier Event
Advanced Shipping Notice(ASN)
Shipment Orders
Shipment Loads and Warranty
Carrier LTL Shipment Automatch
Inbound Process
Outbound Process
Driver Check-In
Driver Check-Out
Loading & Unload Containers

Technical Expertise

Oak Brook, Illinois

Working from multiple customers with different projects. Concentric AB I was the IT Department supporting all iSeries operations. Hibbett's working on various JDA MMS projects. Also developed process useing UPS & Fedex API's with web services to update P.O. & Transfer receiving in real time. Peter Stevens of Australia using API's & Web services to transmit JSON files. Also created a process to migrate csv files into iSeries database. Follett Higher Education Group using API's & Web services to update an IBM Cloud application for store inventory. Also worked on various JDA MMS projects. DM Bowman various logistics projects.

Environment: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, CLLE, CLP, SEU, SDA, DFU, Query, MKS Implementer, Thenon.

Oak Brook, Illinois

Modified assorted in-house functions in RPG Free and RPGSQL including Container Order, Load, Stops, Order Events, GPS Events, Accessorial Management, Dispatch Price Engine. Created a new process called by a website through a Stored Procedure to create new orders. Created a process to update Vendor Contact information from XML Documents.

Environment: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, CLLE, CLP, SEU, SDA, DFU, Query, MKS Implementer.

Springfield, Missouri

Modified assorted in-house functions in RPG Free, RPGSQL and Java including Store Register Transaction XML, Physical Inventory and New Store Setup File Maintenance. Developed an application in java to select & copy files from the iSeries IFS onto a local pc for users that don't know how to setup mapped drives. Application will also delete files from the iSeries IFS directory. Developed an application reading refund & return information from a remote unix server with a DB2 database and a remote iSeries reading store information and writing an ascii file to a local iSeries IFS directory written in java using JDBC and IBM Toolbox for Java.

ENVIRONMENT: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, CLLE, CLP, SEU, SDA, DFU, Query, Java, IBM Toolbox for Java, Aldon, IBM MQ, Rational Business Developer, Eclipse.

Des Plaines, Illinois

Field expansion project. Develop a process to locate and identify all files that use the fields being expanded. Develop a process to locate all programs, CL and RPG, which use the fields and files being modified. Develop a process to streamline check out of all source data into Implementer, importing thousands of objects to be converted. During check out of RPGIII programs, establish a process to automatically convert source to RPGILE and create the Chkout-Dlt, allowing Implementer to remove source from old QRPGSRC file. Develop a process to change all source code for the CL and RPG programs. Manually tested all objects. Created a migration process to automate conversion of all data. Modified assorted in-house function in RPG Free & RPG/SQL including Inbound Process, Outbound Process, Driver Check-In, Driver Checkout, Loading & Unloading Containers.

Environment: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, CLLE, CLP, SEU, SDA, DFU, Query, MKS Implementer.

Oak Brook, Illinois

Developed an algorithm to Auto Build Truck Loads from Customer Orders based on weight and/or carton size or number of pallets. Read and built XML Documents for a Bill Of Lading Web-based application, Load Price Lookup Web-based application and a Carrier Event Web-based application. Developed and modified assorted in-house functions in RPG Free and RPG/SQL, including ASN’s, Shipment Orders, Shipment Loads and Warranty, Carrier LTL Shipment Automatch, Vendor & SCAC Code purge. Using RPGSQL & a configuration table developed procedure to update a file in an always changing environment.

Environment: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, CLLE, CLP, SEU, SDA, DFU, Query, MKS Implementer.

Itasca, Illinois

JDA MMS to SAP Conversion. Detail level code review of warranty functions in RPG to migrate to Oracle SAP. Modified assorted in-house warranty functions and General Ledger Functions in RPG III, RPG Free & RPG/SQL.

Environment: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R4, MKS Implementer.

Northbrook, Illinois

Developed and modified assorted in-house warehouse picking and putaway functions in RPG Free & RPG/SQL.

Environment: IBM iSeries, OS/400, RPG Free, RPG/SQL, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, Crate & Barrel’s Custom Management System, MKS Implementer.

Denver, Colorado

Developed process to create P.O. and Transfers, utilizing data from JDA Fulfillment System into MMS. Modified ASN, P.O. and Transfer process to utilize demand created from JDA Fulfillment. Modified assorted program modules, including Picking, P.O. and Transfer, Pallet & Carton load process, Sales Audit reporting, RTV Process. P.O. and Transfer process for transmission to GSI Commerce. Developed Time/Date program to be used in Robot for automated queries & Journal Extraction. Modified Picking & Letdown approval process to utilize RF Barcode Scanners. Modified Master File Maintenance, P.O., Receiving, ASN & Invoice processes to purchase, ship and invoice by a strict Case Pack Process.

Environment: IBM iSeries, OS/400, RPG Free, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R4, MKS Implementer, Robot.

New York, New York

Customized, enhanced and modified assorted program modules, including Warehouse RF functions, Crossdock Putaway, Picking and Packing, ASN Functions, Transfer Functions and Physical Inventory. SDI Functions included converting EOD SDI PREPOLL process into a trickle polling process to run periodically.

Environment: IBM iSeries, OS/400, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 510, Turnover.

Hayward, California

Customized, enhanced and modified assorted program modules, including Master File Maintenance, Sales Audit, Price Change Event Processing. Built Server processes called by .NET Clients using stored procedures to automate Style, SKU & Price Change Maintenance.

Environment: IBM iSeries, OS/400, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 510, Aldon.

Pittsburgh, Pennsylvania

Customized, enhanced and modified assorted program modules, including Warehouse Management, A/P, Master File Maintenance, Purchase Order Management, Distribution, Inventory Control/Physical Inventory/Cycle Counts, Sales Audit, Transfers, RTV, Price Change Event Processing, Replenishment. Built Server processes called by .NET Clients using stored procedures to automate Style & SKU Maintenance and P.O. Creation.

Environment: IBM AS/400, OS/400, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R6, Turnover.

Oakbrook, Illinois

Customized, enhanced and modified assorted program modules, including Warehouse Management, A/P, Master File Maintenance, Purchase Order Management, Distribution, Inventory Control/Physical Inventory/Cycle Counts, Sales Audit, Sales Reporting, Transfers, RTV, Price Change Event Processing, Replenishment, 4R5 to 4R6 Upgrade, Course Tracks Text Books Project, Zebra Printer Labels, Store Conversions.

Environment: IBM AS/400, OS/400, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R5, MKS Implementer.

Naperville, Illinois

Customized, enhanced and modified assorted program modules, including Warehouse Management, A/P, General Ledger, Retail Stock Ledger, Inventory Stock Ledger, Master File Maintenance, Purchase Order Management, Distribution, Inventory Control, Sales Audit, Sales Reporting, Transfers, RTV, Store Orders, Price Change Event Processing. Zebra Printer Labels.

Environment: IBM AS/400, OS/400, RPGILE, RPG/400, CLLE, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R4, MKS Implementer.

  • TPI/Dollars Bills

  • October 1994 – May 1995

Westmont, Illinois

Customized, enhanced and modified assorted program modules, including Warehouse Management, A/P, Master File Maintenance, Purchase Order Management, Distribution, Inventory Control, Sales Audit, Transfers, RTV.

Environment: IBM AS/400, OS/400, RPG/400, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R3.

  • Leewards Custom Crafts

  • October 1994 – May 1995

Elgin, Illinois

Customized, enhanced and modified assorted program modules, including Warehouse Management, A/P, Master File Maintenance, Purchase Order Management, Distribution, Inventory Control, Sales Audit, Transfers, RTV.

Environment: IBM AS/400, OS/400, RPG/400, CLP, SEU, SDA, DFU, Query, JDA Merchandise Management System 4R3.

  • Janbell Marketing

  • August 1993 – April 1994

Sunrise, Florida

Customized, enhanced and modified assorted program modules, including Master File Maintenance, Purchase Order Management, Distribution, Inventory Control, Price Changes, Sales Audit, Inventory Audit, Transfers, RTV, Replenishment, Drop Ship Receiving, Gold by Weight Tracking, Display Card Labels using Monarch & Zebra printers.

Environment: IBM AS/400, OS/400, RPG/400, CLP, SEU, SDA, DFU, Query, Monarch Printers, Zebra Printers, JDA Merchandise Management System 4R2.

  • System Software Associates

  • June 1993 – August 1993

Chicago, Illinois

Member of team to develop RPG/DDS to C compiler. Compiler was used to migrate SSA’s BPCS system, written for AS/400 in RPG/400, to run in a UNIX environment written in the C language. Responsibilities included building database dictionary, creating database, porting data from AS/400 to UNIX, developing API’s for compiler to access data dictionary for file field definition, creating commands to perform like standard AS/400 commands.

ENVIRONMENT: IBM AS/400, OS/400, RPG/400, CLP, SSA, BPCS Manufacturing System. HP 9000/700 workstations, HP-UX, C, Informix Online.>

  • Sears Business Center

  • April 1990 - June 1993

Chicago, Illinois

Customized, enhanced and modified assorted program modules, including Master File Maintenance, Purchase Order Management, Receiving, Distribution, Inventory Control, Price Changes, Merchandise Planning, General Ledger, Sales Audit, Customer Order Processing, Inventory Audit, Transfers, RTV, Cash Balancing, Replenishment, Warehouse Operations and Store Polling Upload/Download Procedures. Designed and developed sales program modules, including Sales Analysis, Enterprise Sales Analysis and a Salesman Commission Payment System.

Environment: IBM AS/400, OS/400, RPG/400, CLP, SEU, SDA, DFU, Query, Rumba, JDA Merchandise Management System.

Developed inquiries utilizing MS Windows environment, accessing JDA database.

Environment: IBM AS/400, IBM PS/2, PCS/400, Rumba, MS Windows, Visual Basic, Borland C++, Open Access Open DAL API.

Coordinated and evaluated two software packages and coordinated sets for sending and receiving transmissions. Implemented Preminos data sets into JDA Merchandise Management System. Program modules included EDI X.12, Catalog, Purchase Order and Status System.

Environment: Preminos EDI Translation System.

  • Spurgeon Mercantile

  • August 1986 - April 1990

Chicago, Illinois

Customized, enhanced and modified assorted program modules, including Master File Maintenance, Purchase Order Management, Distribution, Inventory Control/Physical Inventory/Cycle Counts, Sales Audit, Transfers, RTV.

Environment: IBM S/38, RPG/III, CLP, SEU, SDA, DFU, Query.

  • Gary North & Associates

  • Febuary 1985 - June 1986

Irvine, California

Led a team of 7 programmers to develop Softlines Merchandise Management System. Involved in all aspects of development through to Quality Assurance. Responsibilities also included teaching entry level programmers RPG, DDS & CLP.

Environment: IBM S/38, RPG/III, CLP, SEU, SDA, DFU, Query

  • Universal Data Processing

  • June 1978 - Febuary 1985

Wilmington, California

Converted/Rewrite Waterfront Transportation Software from S/3 to S/38. Developed Transfer system for Container cargo from Ships to Rail for S/38 then converted to S/36. Started in 1978 as a clerk. Promoted to S/3 & S/34 operater June of 1979. Promoted to Programmer in 1980.

Environment: IBM S3, S34 & S/38, RPG, RPGII & RPG/III, OCL, CLP, SEU, SDA, DFU, Query.