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 #050 - (CLICK/TAP TO EXPAND)
PARALLEL / FREELANCER:
WHERE:
INDUSTRY:
COMPANY:
ERP:
HOW LONG:
NOTES:
Yes/Yes, as ITS4B.it (Information Technology Solution 4 Business)
Italy
Durable goods, high-end luxury furnitures
**********
IBM AS/400 ACG (Applicazioni Contabili Gestionali)
9 months
Direct mandate from the company owner to audit, streamline, and digitalize operations.
ELEVATOR PITCH
High-end luxury furnitures manufacturing requires strict operational tracking across high-variant product lines and external subcontractors.
Mandated directly by the owner, led a comprehensive operational audit of existing AS/400 ACG usage using ad-hoc SQL queries to diagnose data integrity issues and eliminate process gaps.
Exercised direct authority (QSECOFR/QSYSOPR) to enforce dormant ERP features.
Configured CL execution scripts.
Authored technical specifications for custom software enhancements.
Established rigorous UAT/FAT protocols.
Delivered fully digitalized workflows across sales, production planning, and subcontracting.
Created absolute visibility and reduced turnaround times across the enterprise.
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
Multisite 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
Sales & Distribution (SD)
Materials Management (MM)
Production Planning / Production Scheduling (PP/PS)
Work Orders (WO)
Production Tracking (PT)
What (Project Scope & Deliverables)
AS-IS Operational Audit & SQL Diagnostics: Conducted an end-to-end analysis of existing business processes using ad-hoc SQL data extractions against AS/400 DB2 tables to identify operational gaps, bottlenecks, manual procedures, and underutilized ACG modules.
Process Optimization & Fast Reporting: Supervised business process re-engineering, built fast SQL reporting routines for management troubleshooting, and drove the digitalization of manual, un-tracked workflows previously handled via phone, email, or paper.
Subcontractor & Production Tracking: Digitalized external subcontracting (conto lavoro) and internal work orders to establish complete traceability within the ERP system via CL scripts and SQL tracking views.
How (Tech Stack & Implementation)
IBM AS/400 & ACG ERP platform
CL scripting and system management under QSECOFR / QSYSOPR / QSYS authority
SQL data extractions and DB2 queries for fast diagnostic reporting and process auditing
Business process re-engineering leveraging proven high-end furniture manufacturing frameworks
Owner-delegated operational authority to enforce tool adoption and workflow compliance
Authoring of technical specifications, User Acceptance Testing (UAT), and Factory Acceptance Testing (FAT) protocols for custom AS/400 extensions
Creation of training materials and execution of user enablement sessions across departments
«It is NOT important WHAT you do,
its is important HOW you do it!»
Page updated
Google Sites
Report abuse