Demand Signal Repository Services
FCS provides an end-to-end service spectrum for CP Companies for Demand Signal Repository Solution. This includes:
Implementation and Consulting
FCS DSR implementation and consulting is an accumulation of experiences, best practices, existing methodologies and has been designed to increase its and accelerate the time taken for ROI generation. It includes the standard structured project phases with an iterative approach to validate results and ensure early business feedback and buy in.
Typical implementation includes
- Harmonizing POS data from Retailers
- Enabling Custom Dimensions and Hierarchies
- Mapping Retailer SKU/UPC to Manufacturer Product
- Map Shipments, Promotions, Consumptions and Forecast
- Customize Analytics and Security needs
- Real Time Analytics
- Volume testing for scalable loading of POS data volumes
FCS’s consulting practices includes
- Integration of DSR to downstream applications like Oracle Demantra
FCS’s BI and Data Warehousing consultants come with more than 60 person years of experience and in-depth domain knowledge of the Consumer Products industry . FCS’s BI and Data Warehousing consultants
- Helped Oracle build the Demand Signal Repository
- Understand the Retailer data format nuances like full/partial restatements, pre-aggregated data, ragged customer hierarchies etc.
- Have handled large volume BI-DW implementations – including implementation of Oracle DSR for a leading Consumer Goods Manufacturer in the United States
Managed Services
High availability and scalability are critical for the success any BI implementation. FCS offers the following services for ensuring that analytics are performant and the infra-structure is manageable and contained. FCS has more than 60 persons having years of experience in Tuning, Managing and Maintaining large scale databases and systems.
- Technical support on scheduling and monitoring data loads
- Database Maintenance and Backup
- System Performance Tuning
- Troubleshooting
- Database and Network Administration services
- Hosted environments in FCS Data Center
- Managed Services for customer hosted systems, including System administration, Maintenance and Infrastructure Consulting
Data Governance
Retailer Data Format Governance:
FCS provides Data Management support to
- Supports and manages the interaction with Retailers
- Capture changing data formats and frequency of data loads
- Monitor monthly/weekly files from retailers
- Troubleshooting
- Analyze the source data changes and translate them into corresponding ETL and scheduling changes
- Maintain Customer Hierarchy and Distribution Center Hierarchy
- Maintain Retailer UPCs to Consumer Product UPC mappings
- Maintain Promoted Product Groups
Data Quality Governance:
- Cleansing and Harmonizing data received from proprietary sources like Retail Link
- Parsing, Cleansing and Harmonizing of EDI 852, excel file, flat file data feeds
- Watch on quality of incoming data feeds and detects patterns or anomalies in the incoming data. The data management team then interacts with the source to get the data corrected and cleansed to ensure accurate reporting and analytics
Adapters
FCS has adapters targeted for Consumer Product Companies to bring in sales/ inventory data from retailers into Oracle Demand Signal Repository seamlessly without writing any code or customizations. FCS Retail Adapters, built in conjunction with Oracle Corporation Product Development team reduces the cycle time between receiving the data file and supplying data to DSR, thus reducing cost and complexity of IT solutions and empowering Supply Chain managers to analyze consumption data and demand signals
FCS provides pre-built adapters to DSR for
- Syndicated Data Sources – IRI and A.C Nielson
- Generic EDI 852
- Monitor monthly/weekly files from retailers
- Target
- Safeway
- Bestbuy
- Comp USA
- Walmart Retail Link , Walmart EDI 852
- And many more...
In addition, FCS also provides integration consulting for integrating Oracle Demand Signal Repository to Oracle Demantra and other downstream applications.
FCS updates its Adapter code base regularly with changed retailer data formats and veils Consumer Product companies from the complexity of maintaining these formats.
|