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+