Major energy provider successfully streamlined its supply chain using data analysis and cleansing techniques provided by EITACIES
Client : A Leading Nationwide Provider of Competitive Energy Industry: Information Technology
Service Offering : Application Services
The Situation : A wholesale power generation company engaged in the ownership and operation of power generation facilities and the sale of energy were faced with a set of QA & Testing challenges. A leading nationwide provider of competitive energy was looking for assistance with the data analysis and cleansing of its supplier database. The client provides economical energy solutions to some of the nationʼs largest commercial and industrial customers by supplying wholesale power. Through its diversified fleet of generating units, which offer approximately 2000 megawatts of generating capacity, the client manages fuel and energy services to support energy intensive industries and utilities.
The Challenge : The clientʼs supplier file database was overloaded with obsolete, duplicate, and outdated entries. In order for the client to effectively utilize this resource for accounts payable and procurement activities, all supplier data needed to be validated. Although the clientʼs supplier database contained more than 2000 records, many of these files contained multiple entries for the same supplier or were no longer valid.
The client wanted to reduce its supplier file count to more accurately reflect its current active account list. To accomplish this, supplier records and files that had not been used in 24 months would be flagged with an end date and deactivated within the database. The clientʼs Application Support Group was interested in a partner company who could assist with this important initiative. The Response : EITACIES, a premier provider of technology staffing and services, has been providing staffing services to the client since 2008 and has developed a strong reputation for delivering well‐qualified technology professionals of all skill levels. After meeting with the client to learn its data project goals and discuss the projectʼs specifics, EITACIES proposed a turnkey solution that outlined the projectʼs management, deliverables, and resources. This cost‐effective and comprehensive plan gave EITACIES an advantage in an area normally dominated by large integrator competitors, and the client selected EITACIES over two other vendors. EITACIES utilized its local market strength and extensive pool of technical resources to provide the client with a team of highly‐skilled professionals. The Result : EITACIES successfully met the clientʼs expectations in this important, five‐month endeavor. Of the suppliers that responded to requests for updated information, EITACIES revised the records of over 250 suppliers had deactivated more than 2500 files. EITACIES also added 100 new supplier contacts and identified, but did not deactivate, an additional 147 suppliers that were listed with duplicate information. Another 210 suppliers were identified but put on delayed activation status at the request of the clientʼs purchasing and/or accounting departments. EITACIES communicated its best practices and lessons learned to the client at the projectʼs completion to help lay the groundwork for future initiatives. Although some suppliers elected not to respond to the information change requests, EITACIES helped the client take steps towards improving the validity and accuracy of supplier data by capturing the support information necessary for potential merge candidates. The Technology : Information about each supplier was moved from the clientʼs internal system to a Microsoft® Access TM database for the tracking, disposition, and merge processes.Requests for information were made by direct mail, fax, and by email using an Adobe® Acrobat® form that was generated by the Access database. EITACIESʼ team members validated the supplierʼs contact information, and set a flag in the tracking database. Jobs were periodically run to email the information change forms to the suppliersʼ validated email addresses, and then to update the tracking database that a response had been received. The returned forms were gathered in a comprehensive directory. Updates of supplier information and deactivations of unused suppliers were done using the existing user interface in Oracle® , the clientʼs Supplier Management System.