This website is by invitation only and is not tracked by search engines. Thereafter, ALL the DATA and/or FIGURES shown shall be considered as part of a NON-DISCLOSURE AGREEMENT and SECRET among the parties. Refer to the NDA for further details
Embedded Files
USE THE MENU BAR TO BROWSE THE SITE
ERP CASE #060 - (CLICK/TAP TO EXPAND)
PARALLEL / FREELANCER:
WHERE:
INDUSTRY:
COMPANY:
ERP:
HOW LONG:
NOTES:
Yes / No
Italy
Packaging (Flexible Food & Beverage Film & Paper)
********** (Phase 2)
IBM AS/400 + Custom 3-Tier ERP ("E-ROLLS")
18 months
Re-hired for a 2nd engagement to modernize the entire IT architecture from AS/400 to a custom client-server ERP platform.
ELEVATOR PITCH
Rejoined to drive digital evolution by executing the full replacement of legacy IBM AS/400 ACG with "E-ROLLS," a custom transactional 3-tier ERP designed specifically for flexible packaging conversion.
Leveraged advanced SQL queries to perform rapid legacy AS/400 DB2 data extractions, normalization, and verification during system migration.
Authored business specs, structured complex Manufacturing and Process BOMs (MBOMs/PBOMs) for slitting and coating operations.
Built out plant-wide Wi-Fi, and equipped forklifts with real-time terminals.
Dramatically reduced material transit times and providing complete real-time tracking across sales, purchasing, and production.
CASE DETAILS- (CLICK/TAP TO EXPAND)
Business Models
Make-to-Stock (MTS) / Make-to-Order (MTO)
Vacuum metallizing & coating of plastic film and paper for Food & Beverage packaging
Cut-to-Width (CTW) & Cut-to-Length (CTL) material conversion
Contract manufacturing / toll processing (lavorazione conto terzi) & direct sales
Areas / Modules / Domains
Sales & Distribution
Production Planning
Warehouse Management
Materials Management
Purchasing
Industrial Infrastructure & Factory Wi-Fi
What (Project Scope & Deliverables)
ERP Migration & Data Engineering: Migrated core business operations from IBM AS/400 ACG to a custom transactional 3-tier ERP system ("E-ROLLS"). Formulated complex SQL scripts to extract, clean, and map legacy AS/400 DB2 physical/logical files to Microsoft SQL Server.
System Architecture: Modernized the former sidecar module into a full-scale 3-tier ERP using Visual Basic 6, MS SQL Server, and transactional stored procedures.
Business Analysis & Data Engineering: Conducted feasibility analysis, authored technical specifications, executed User Acceptance Testing (UAT), and managed master data validation/migration using SQL extractions for fast audit reporting.
BOM Management: Structured complex Manufacturing Bills of Materials (MBOMs) and Process Bills of Materials (PBOMs) tailored to film slitting and coating.
Real-Time Warehouse Mobility: Implemented industrial factory Wi-Fi and installed rugged vehicle-mounted terminals on forklifts to optimize inventory flows from raw material arrival to finished goods shipping.
How (Tech Stack & Implementation)
IBM AS/400 DB2 & CL procedures (QSECOFR / QSYSOPR / QSYS)
Visual Basic 6 (VB6) & MS SQL Server (Stored Procedures, 3-Tier)
SQL data migration, normalization, ad-hoc querying, and UAT protocols
MBOM & PBOM process structuring
Factory-wide Industrial Wi-Fi & Forklift Radio-Frequency (RF) Terminals
«It is NOT important WHAT you do,
its is important HOW you do it!»
Page updated
Google Sites
Report abuse