
![]() Challenge A major international airport was constructing a new 900,000 square foot terminal. This 600 million dollar construction project was managed on an application that Solutions Through Understanding and its sister company, Aptude created. Through initial design and requirement analysis it was determined that an enterprise wide application that supported every detail of airport construction management was to be included with this system. One of our most challenging tasks was to integrate data among disparate systems. Solution *Working with the client, we built a robust Oracle based data warehouse and intranet application that supports contractors, city employees, architects, Department of Aviation employees and a number of other individuals who at any time desire information from this application. With thoughtful design and planning this application has blossomed. Utilizing a three-tiered architecture and object oriented design methodologies, it has become relatively easy to add or enhance modules. In addition, careful attention waspaid to database design and data mart considerations so that meaningful and strategic data mining could occur regardless of a user's technical expertise. Today, a central repository houses all of the airport construction information. Profit Improvement & Customer Satisfaction Benefits A major construction project that was completed on time and within budget. Improved management decision making via the one integrated database. Technology Oracle11i, PLSQ, J2EE, Business Objects and Oracle Reports |