Clients

PROJECT #1:   Billing Application

SMI staff partnered with AT&T to build a real-time interactive application that needed to pull historical information from a Usage/Data Warehouse environment. This application was to assure strong business users who had limited experience with technology.

The system requirements stated that the solution needed to gather usage/billed data from the prior day and provide it based on other warehousing segmentations. Marrying the usage to history that segments the customers by calling habits, AT&T products, AT&T services and Marketing segments were part of the requirements. The data would be needed in one of 14 different geographical segments: City, State, Zip, NPA, CMA, MSA, etc. The application was available to both Headquarters and regional Marketing personnel.

SMI staff was responsible for database administration, program design, program development and GUI development. The technology used for this application was COBOL, DB2, Connect Direct, Oracle Database, UNIX, C/C++ and PowerBuilder.

PROJECT #2:

Integrated Order Management Environment Error Correction

SMI staff members partnered with AT&T employees to understand the complexity of dealing with Error Correction efforts within the Ordering and Provisioning of many AT&T products and services. SMI provided significant contributions to the proposed solution that would use one Order & Provisioning Error Correction platform to receive/distribute errors to specialty centers/agents throughout the continental United States. The proposal identified one synergistic system providing real time routing of errors to qualified agents.

Knowing one order may spawn multiple errors to different centers/agents, the proposed solution was designed to automatically implement business rules that determined prioritization of all error handling activity. It also cared for the separation of errors to different centers while maintaining the integrity of the entire order. This way AT&T would always know what was promised to the customer while understanding the subsections that were being worked due to errors.

The technology used for the system solution included: Web Browser technology, Cold Fusion/Allaire Corporation GUI software, C++ customized code interacting with Tuxedo/BEA transaction based processing to remote Oracle Databases. SMI was responsible for DBAs experienced in Oracle, C++, Solaris and Cold Fusion technical skills. From concept through delivery, the solution was implemented into production within 5 months with a staff of 18 project managers, analysts, developers, testers and support personnel.

                                                                           Back to previous page