http://www.topcoder.com/tc en-us Thu, 9 Sep 2010 03:19:07 TopCoder Active contest RSS http://www.topcoder.com/registration/actions/ProjectDetails.do?method=displayProjectDetails&projectId=30014419 Registration ends: 2010-12-10 21:00:00.000<br />Submission ends: 2010-12-10 21:05:00.000<br />Winning Payment: 165000<br />NA www.topcoder.com http://www.topcoder.com/registration/actions/ProjectDetails.do?method=displayProjectDetails&projectId=30014565 Registration ends: 2010-09-11 02:00:00.000<br />Submission ends: 2010-09-14 02:05:00.000<br />Winning Payment: 1500<br />Ilium is a direct to consumer seller of various items. One set of items can be seen at the GreatCleaners site (http://greatcleaners.com). Processing of sales by the GreatCleaners includes sending of daily sales data to invoicing and inventory system (SAP). This process is already implemented and based on hand-coded data warehouse. Sales data is originally stored in OLTP databases on production server. Asynchronously but fairly close to real time OLTP tables are replicated to the reporting server and then ETL processes are used to load data from reporting server to the data warehouse. The daily sales data is extracted from data warehouse into text file. This text file is moved to an FTP directory where electronic data interchange systems access it and pass to SAP. On the SAP side a text file is used to relieve inventory for the sold items and create invoices for recording the sales. Data warehouse is also used as convenient data source for various reports. This existing application is being upgraded in the following manner: Each set of products has its own branded site. One such site being developed now is the Trojan Vibrations and it will be incorporated so that orders shipped through the Trojan site are also included in the export file that is sent to SAP. Cash reconciliation. There are downstream projects that involve balancing order-to-cash processes on the SAP side. As such, data warehouse will be the one place to go to identify key attributes in the order life cycle. Data in warehouse should allow to track when an order was created, authorized, shipped, captured, sent to SAP, the product order number, and bank deposit date. Currently only part of this data is present in data warehouse. The ETL processes will be more robust. The current ETL processes don't correctly handle replication outage periods between production and reporting servers. It means that orders can be missed and not loa www.topcoder.com http://www.topcoder.com/registration/actions/ProjectDetails.do?method=displayProjectDetails&projectId=30014537 Registration ends: 2010-09-10 22:43:00.000<br />Submission ends: 2010-09-13 22:48:00.000<br />Winning Payment: 1200<br />NA www.topcoder.com http://www.topcoder.com/registration/actions/ProjectDetails.do?method=displayProjectDetails&projectId=30014521 Registration ends: 2010-09-10 18:00:00.000<br />Submission ends: 2010-09-13 18:05:00.000<br />Winning Payment: 1000<br />NA www.topcoder.com http://www.topcoder.com/registration/actions/ProjectDetails.do?method=displayProjectDetails&projectId=30014451 Registration ends: 2010-09-09 11:00:00.000<br />Submission ends: 2010-09-12 11:05:00.000<br />Winning Payment: 1000<br />NA www.topcoder.com http://www.topcoder.com/registration/actions/ProjectDetails.do?method=displayProjectDetails&projectId=30014436 Registration ends: 2010-09-09 09:00:00.000<br />Submission ends: 2010-09-11 09:05:00.000<br />Winning Payment: 1000<br />NA www.topcoder.com