Case Studies.jpg

Questions about your project?

Home Case Studies
Oracle Data Integrator (ETL) PDF Print E-mail
Written by aptude   
Thursday, 14 July 2011 16:20

 Challenge   

A global, multi-billion dollar manufacture of retail goods had a contracts process that runs on an AS400 legacy system.   This process pulled contract information from the source system and populated a contract fact table.  The contract fact table in the ODS was then utilized to populate the Client’s GDW.  This process completed with “renewal” reporting.Three of our client’s largest markets had been migrated from their legacy system over to their new Oracle EBS Service Contracts system.  This left approximately 70 additional markets to migrate.  Unfortunately the legacy contracts process which fed the GDW was not in place for the “new system” contracts and as markets migrate, their GDW information became invalid.

The purpose of this engagement for our client was to meet the following three high level goals:

·         Integrate contracts from both the new and Legacy source systems in the ODS table that feeds the GDW.

·         Ensure that the GDW picks up the new contracts, modifying code as necessary.

·         Standardize the processes and infrastructure on current standards applied across all new development.  This would apply to both the New and Legacy contract processes

·         Execute the project, minimizing the impact to current staff, which are currently working at capacity and have little time to dedicate to a new project.   

Solution 

1.    Aptude analyzed the existing system and document the requirements to:

Reorganize specified tables within the data layers, to meet current standards

Modify the legacy system as needed to meet current standards and centralize common processes.

Combine New contracts with the legacy contracts in the Tier 2 ODS contract fact table

2.    Aptude reorganize the contract tables within the data layers to meet current standards.

3.    Aptude extracted common processes from the Legacy system and place them in the process where they can be leveraged for both Legacy and New contract processing.

4.    Aptude updated current Legacy system artifacts to reflect changes in the process.

5.    Aptude developed interfaces to move data from the legacy source system to the Atomic data layer as well as combining that contract data with the Legacy contract data in the Tier 2 ODS fact table.

6.    Each of the scope items were performed and delivered in accordance with the developed and agreed upon design documents.

 Technology

·    Oracle Data Integrator 11g
Last Updated on Tuesday, 23 August 2011 22:15
 
OBIEE Case Study PDF Print E-mail
Written by aptude   
Tuesday, 12 July 2011 17:06

 Challenge   

A global, multi-billion dollar manufacture of retail goods desired an Executive Dashboard.   The Dashboard and subsequent scorecard analytics were to provide information on Global Strategic Planning, Corporate Marketing, Distributor Compensation and Sales 

Requirements

  • Leverage data from from the Global Data Warehouse, Finance Hyperion and Survey Capture
  • Leveraging the CSV file populated by client’s IT department, create a new Scorecard Metric Fact Table and expose the data for ad-hoc reporting and existing Time, Exchange, Currency, and Geography BI dimenions                                  
  • Based on the current MS Excel template, produce a Global Strategic Planning scorecard that is accessible through the current standard portal for reporting.
     
  • Based on the current MS Excel template, produce a Corporate Marketing scorecard that is accessible through the current standard portal for reporting
     
  • Based on the current MS Excel template, produce a Distributor Compensation & Sales scorecard that is accessible through the current standard portal for reporting
 

 Solution 

  • Created a new Scorecard Metric Fact table in the GDW, along with processes to populate the table with data from a CSV file created by IT.  This was developed as a repeatable process

  • Defined and implemented a process for annotating the scorecards with user provided information.  The users provided information and we included all the other metric data in the CSV file 

  • Exposed the data in the new GDW to the business for ad-hoc reporting purposes 

  • Leveraged the new Scorecard Metric Fact table to produce executive scorecards 

  • Implemented the new development into production and supported the product for the first three weeks after the roll out.    

Technology

·    Oracle Business Intelligence Enterprise Edition (10.1.3.4)

 
Last Updated on Tuesday, 12 July 2011 17:55
 
Challenge  
 
A large “Oracle Technology” client had invested heavily in an off-the-shelf product to help support a logistical piece of its business.    The excessive price point of continuing to utilize the platform resulted in the need to develop a custom built application that provided similar functionality.  The client’s current resource utilization had been capped and decided that it would outsource this initaitve.

Solution

Aptude and our client decided to design, develop and implement a customized solution built on Oracle Fusion’s Application Development Framework (ADF).   The design and development of the solution followed Oracle’s AIM methodology.  This "project delivery"  initiative was driven by Aptude’s managed services method of delivery in where:
 
·   Project delivery was managed by Aptude
·   Communications managed by Aptude
·    Known cost for well defined units of work.
·    Reduced offshore rates
·     Improved turn around due to time zone differences Aptude delivered a high-quality solution within time and cost commitments. 
 
 
Technology
·    Oracle 11g R2,   Oracle Application Development Framework (ADF)
 
 
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
 
Challenge

A steamship equipment depot management facility which stores and repairs equipment for some of the largest steamship companies in the world had the following challenges: 
  • Sharing information among its multiple facilities.
  • Providing customers with timely and credible repair estimates.
  • Providing timely and accurate information to their customers regarding their equipment. 
  • Providing customers with an interface that would allow them to view equipment activity, approve repairs and create bookings. 
  • Providing customers data that can be integrated into their own systems and applications.  
Solution
*Working together with our client, Aptude built a robust data warehouse application that allowed the Depot's customers the ability to access the new enterprise system via a secure internet connection. Gate Activity (Storage) was captured in real time using a hand-held device with images that updated a live database ia a 802.11 b connection. Repair estimates were also generated on the hand-held unit as intermodal equipment came into the depot. The repair estimates were also sent to the database via an 802.11 connection. Once the repair was stored in the database, a scheduled job would electronically notify the depot's client that a repair estimate was created for a particular unit and an approval or disapproval action was needed. The depot's client has the password authority to view the repair estimate and the images related to the repair, then approve or disapprove the repair estimate. The new hand-held/repair piece can potentially save days in the repair estimating process. Futhermore, the new application sends hourly data feeds to its customers in the format they require. This is truly a business-to-business application that has increased labor efficiencies, provided immediacy and increased customer satisfaction. 

Profit Improvement Benefits
Repair estimates that are more credible, accurate and timely lead to more repair approvals which led to higher sales. Reducing labor resources via the hand-held, online reports and business to business transactions reduces our client's expenses. 

Technology
Microsoft .NET Platform, SQL Server 2005, SQL Server CE, WIN CE 3.0, Embedded Visual C++. 
 
 
Challenge 

A network security software company desired a remote scanning and penetration testing application that would be compatible on wireless and LAN internet and/or network connections. This company wanted to be one of the first to market and sell such a product.

Solution
*Working with the client's network security team, Aptude designed and created a network scanning and penetration testing application for the Pocket PC and HPC platforms.

Profit Improvement & Customer Satisfaction Benefits
The client has been successful in selling and marketing a hand-held solution. The Pocket PC Magazine for Best Product of 2002 nominated the product as a finalist. 

Technology
Embedded Visual C++, CE.Net 
 
 
More Articles...
<< Start < Prev 1 2 Next > End >>

Page 1 of 2