|
SPECIAL MENTIONS
Continued from page: 4
Friday, June 03, 2005
Data Warehousing, J K Industries Limited
Project Head: S S Sharma , GM (IT)
Location: HO-Delhi & Regional Offices
As the name suggests, this is a data-warehousing project, implemented for analyzing data on warranties and claims from different sales regions of J K Industries. The company has more than 100 sales offices, doing invoicing, collection, warranty claim, etc. Before this, a heterogeneous platform was used for the job, leading to duplicity in data.
This system centralized all the data and the data redundancy was reduced by an astounding 75%. It also helped the sales force become more productive, as they could now analyze the data easily and make more informed decisions using the past data.
Their initial project used MS SQL Server 2000, in which they found some desirable features missing. To overcome this problem, they switched to Oracle 9i/AS midway. Using this arrangement, the data at the warehouse level is captured into a Visual FoxPro database, which is then filtered and moved into the new Oracle system. Also, in doing all this, they ended up with the ability to Web-enable their entire data and increase the accuracy of information by eliminating what was redundant.
They were also able to utilize their Oracle experience in other areas, streamlining a lot of systems in the process.
Programmer-independent reporting and MIS systems added by this project help their executives query, drill-down, roll-up the information (using OLAP cubes) and assess lag and lead functions.
The original system was mainly to reduce the time required to process warranty and claims applications of JK's tyres division. The application helped them reduce this from 30 to 3 days per month, which is a commendable leap.
Next Page : Sankraman, Mahindra & Mahindra Page(s) 1 2 3 4 5 6
|
Print
Comment
Email
Digg
Del.icio.us
Reddit
Twitter
