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 #040 - (CLICK/TAP TO EXPAND)
PARALLEL / FREELANCER:
WHERE:
INDUSTRY:
COMPANY:
ERP:
HOW LONG:
NOTES:
Yes / No
Italy
Multisite, Multi-Company, Multi-National Durable Goods Manufacturing (Furnitures)
**********
IBM AS/400 ACG (Applicazioni Contabili Gestionali) Galileo
24/30 months
Hired as Employee #1 in the new internal ICT department. Managed both ERP and ICT infrastructure for the first 12 months. Maintained QSECOFR/QSYSOPR duties while transitioning server infrastructure from Novell to Windows NT4.5, Windows 2000 Server, and Linux. Standardized 100% Dell hardware with Cisco routing and HP blade switches.
ELEVATOR PITCH
Eliminated competitor data leaks.
Eliminated operational dependence and severe data security risks associated with third-party host systems.
Established an in-house IBM AS/400 ACG Galileo platform and executing Y2K readiness.
Managed full AS/400 system administration utilizing CL scripting, library management (ADDLIBLE), and security profile controls (QSECOFR/QSYSOPR/QSYS).
Executed fast SQL data extractions for cross-site reporting and inventory auditing.
Mapped end-to-end MTO/MTS manufacturing workflows
Modernized network infrastructure across sites, and built real-time integrations for external subcontractors (conto lavoro) and remote sales/logistics teams.
Delivered total leadership control over shop-floor data, inventory visibility, and subcontracted work orders across all sites.
CASE DETAILS- (CLICK/TAP TO EXPAND)
Business Models
Make-to-Stock (MTS) & Make-to-Order (MTO) for main components
Assemble-to-Stock (ATS) & Assemble-to-Order (ATO) for final products
Multi-Site / Multi-Country production with internal and external subcontractor (conto lavoro) work-order distribution
High variant/configuration complexity causing item code proliferation across materials, colors, markets, and optionals
Areas / Modules / Domains
ERP Vendor & System Migration
AS/400 Infrastructure & Security Administration (QSECOFR / QSYSOPR / QSYS)
Business Process Mapping & Digitalization
Supply Chain, Subcontractor (Conto Lavoro) & Logistics
Telecommunications & Field Mobility (Wireless Application Protocol [WAP])
What (Project Scope & Deliverables)
Phase 0 (Data & Process Migration):
Exported, cleaned, transformed, and normalized data from a competitor's Software-as-a-Service (SaaS) mainframe to the in-house AS/400 ACG Galileo ERP utilizing SQL data extractions.
Severed competitor data leaks and digitalized manual out-of-ERP procedures.
Phase 0.5 (Infrastructure Revamping & AS/400 Admin):
Executed in-house AS/400 implementation, managing system security (QSECOFR), operator queues (QSYSOPR), library configurations (ADDLIBLE), and CL command scripts.
Migrated Token Ring to 100Mbps Ethernet with fiber/radio bridges for adjacent sites.
Phase 1 (Subcontractor Integration & Fast Reporting):
Integrated 3rd-party vendors via dial-up connections for production planning, work orders, accounting, and shipping bills.
Built SQL extraction routines for rapid reporting on subcontracting workflows and stock movements across multi-site warehouses.
Phase 2 (Mobile Field Workers):
Integrated WAP mobile technologies for sales reps, truck drivers, and remote warehouse operators to access real-time ERP work orders, loading confirmations, and logistics data.
How (Tech Stack & Implementation)
IBM AS/400 & ACG Galileo ERP
CL (Control Language) automation and system management via QSECOFR / QSYSOPR / QSYS profiles
SQL data extractions and DB2 queries for fast reporting and audit troubleshooting
Year 2000 (Y2K) Millennium Bug planning & execution
Ethernet 100Mbps, Fiber Optics, Radio Bridges, and Leased Lines
Dial-up & WAP mobile gateways
«It is NOT important WHAT you do,
its is important HOW you do it!»
Page updated
Google Sites
Report abuse