Apparel/Soft Goods Design and Manufacture

Apparel Enterprise Class Project - Case Study

Client: A leading designer, manufacturer, and marketer of women’s and men’s apparel that offers an extensive array of clothing and accessories ranging from casual to formal.

Existing Application

  • Sewn2000 (Supply & Demand Solution)
  • Link (Intranet Applications Portal)
  • Reports (180+ Supply and Demand Reports)
  • RAMS (Retail and Merchandising System)
  • EDI (Electronic Data Interface)
  • WMS (Inbound Receiving Process)
  • BPS (Business Planning System)
  • PLS (Product Lifecycle System)
  • Trade-beam (Logistics)

The Challenges

  • Existing Applications were not compliant with the growing business.
  • EDI and WMS Interface systems were performing poorly.
  • Store Level Business Planning was not available.
  • Marginal analysis reports missing data.
  • Dependency on 3rd party logistics system.
  • Reports and applications were limited to US currency, date formats and taxation rules.

Business Benefits

  • Enhance applications to make them business compliance
  • Upgrade supply and demand reports
  • reengineer WMS and EDI interface applications
  • Enhance Retail and Merchandising System
  • End-to-end quality assurance for PLS system
  • Migrate PLS reporting from HTML to SQR based reporting

Key Objectives

  • Enhance applications to make them business compliant. This was necessary because of the:
    • Growing family of brands, customers and retails stores.
    • Acquisition of major Europe brands.
    • Growing business across the world where have to dealt with multiple currencies, date formats and taxation rules.
  • Upgrade supply and demand reports to support worldwide currencies, currency formats and date/time formats.
  • reengineer WMS and EDI interface applications in Oracle to make them efficient and scaleable.
  • Provide business planners with more flexibility to plan product lines at store level along with enhanced marginal analysis capabilities.
  • Support growing family of outlets/retail stores, enhance RAMS to make it capable of Multiple Currency/date-time formats.
  • End-to-end quality assurance for PLS system that includes product design, costing, raw material management and factory allocation.
  • Migrate PLS reporting from HTML to SQR based reporting.

Technology

  • Microsoft Visual Basic
  • Microsoft .NET Framework
  • J2EE, Java Applets
  • Oracle Web Toolkit
  • Hyperion SQR Reporting
  • Oracle 10g (Database), Oracle Application Server 10g

Impacted Business Lines

  • Product, Account Setups
  • Product Designs
  • Product Costing
  • Business Planning and Reporting
  • Raw Material Management and Sourcing
  • Demand Management and Sourcing
  • Retail and Merchandising
  • Corporate Supply and Demand Reporting
  • Allocation
  • Distribution and Invoicing
  • RMA and Credits

Number of Users
Employees: 3000+
Customers: 1000+
Vendors: 400+

Number of Concurrent Users
Employees: 1500+
Customers: 800+
Vendors: 200+

Project Duration
3 Years+

Project Effort
290,000 Hours+

Application Line of Code
2.5 MLOC+