| Case Studies |
Business Intelligence Projects Project Type: Billing Data Warehouse Objective: Integrate telecommunication billing information for three different billing systems to obtain a complete view of billing activities and revenue. Requirements: Utilize existing technologies to build a process to integrate the information from three separate billing systems. Assist the clients existing team with Design and Develompment of the Data Warehouse solution within a short timeframe. Challenges:
Solution: Understand and assess the billing business process. Identify the information collected during the business process. Document and standardize business definitions across the different systems. Assimilate the information from the three systems into a standardized business model. Convert the business model into a robust, scalable, physical data model to store billing information. The initial phase not only delivers the billing foundation but also creates the foundation for a robust data warehousing platform for future projects. Operational Applications Project Type: Debt Collection Objective: To automate the collection of bad debts by generating and mailing donning letters. Requirements: Process and track thousands of bad debts on a daily basis. Integrate the output with an existing commercial printing, stuffing and mailing process. Challenges:
Solution: By creating a hybrid application which borrowed concepts from Data Warehousing and mail merge processing, we designed a solution which accepts large amount of information via flat file. Oracle Warehouse Builder was utilized to load, scrub, and cleanse the information. Upon loading into a data store, a mail merge process is executed to generate thousands of donning letters on a daily basis with corporating OMR markings. The resultant output is delivered to a commercial printing and stuffing process for mailing. The project is a huge success allowing the customer to recoup significant amounts of bad debt. Security Projects Project Type: Financial Information System Objective: Build a large data entry and reporting system for thousands of local and geographically dispersed users. Requirements: Single Sign On across all products, integration with exisiting Microsoft Active Directory Server, integration with existing Sun iPlanet Server, conformance to corporate security policies, ability to link application users to enterprise users and single point for provisioning. Inclusion of row level security within the database to secure personally identifiable information and sensitive. Challenges:
Solution: Worked collaboratively with the offshore development team, corporate security, infrastructure and Oracle Support / Development / Product Management to collaboratively design a security solution to meet the needs of the project. Tested and validated a variety of software from Sun, Oracle (Oracle Password Filter, Oracle Virtual Directory, Oracle Internet Directory, Oracle Single Sign On) and Microsoft to determine practical feasibility of solutions. Project Type: Insurance Application Objective: Integration of application and users into corporate security. Challenges:
Solution: |