Business Areas:                
                            
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Relational Database Design
 
We are a team of highly skilled people with proven software development expertise in engineering, business, advanced relational database and web applications in a real-time environment. Since 2000 LOT Software Engineering Consultants has been providing custom software solutions to unique engineering and business problems and we must be doing something right - our customers keep coming back. From our perspective, that is the highest compliment we can receive.
 
The quantity of T.O. 00-25-107 (referred to as 107) Technical Assistance Requests is increasing each year. In addition, since 107 requests can be divided into two categories, Engineering Technical Assistance Request (ETAR) and 107 requests, has caused this trend to increase sharply. This is generating a concern within the F-15 community. The ability of the F-15 Engineering Division to manage the 107/ETAR would be greatly enhanced by a computerized system that stores, tracks, evaluate trends, perform reliability and maintainability analysis, and communication on the processing of field technical assistance requests.
 
The resulting F-15 Technical Assistance Database System (TADS) is a real-time web distributed advanced relational database application designed, developed and maintained by LOT Software Engineering Consultants for the US Air Force. The Software Engineering Institute (SEI) Capability Maturity Model Integration (CMMI), Staged Representation, Level 3 was achieved during the development of TADS. TADS enable the F-15 System Program Office (SPO) personnel to accomplish their tasks in a more timely manner by providing the following functions:

  • Efficient handling of new 107/ETAR
  • Provide consistent accurate 107/ETAR status updates
  • Provide understanding, rapid assimilation and dissemination of data
  • Provide search capabilities of historical 107/ETAR
  • Provide trends analysis
  • Develop corrective methods for trouble areas
  • Take appropriate action to prevent potential problems
  • Manage the assigned system to ensure aircraft availability remains high
 
TADS web distributed relational database system providing a workflow to process and manage 107/ETAR data in a real-time environment, reducing the need for legacy communications such as emails, time-consuming telephone calls, paper files and faxes. Additionally, TADS improves the processing time for the 107/ETAR Request for Technical Assistance. As a result, it promotes efficiency, real-time access to the 107/ETAR work status and aircraft available remains high.
 
The F-15 TADS major functions are:

  • Input New 107/ETAR
  • MAJCOM 107 Certification
  • Compile 107/ETAR Engineering Disposition (Solution)
  • Engineering Manager Review and Approve 107/ETAR Solution
  • MAJCOM 107 Repair Cost Approval
  • Release 107/ETAR Engineering Disposition (Solution) to Base
  • Compile 107/ETAR Engineering Supplement
  • Closeout 107/ETAR
  • View 107/ETAR Work Status
  • View 107/ETAR Process Times
  • Query and View 107/ETAR Historical Data
  • Input Accrued/Legacy 107/ETAR Data
  • Aircraft Location Maintenance
 
The F-15 TADS allows for access to the 107/ETAR status and data via the following user interfaces:

  • Base/Field
  • Deployed Base/Field
  • MAJCOM
  • Production Analyst
  • Engineering Manager
  • Assigned Engineer
  • Technical Support
  • Trend Analyst
  • Senior Management
  • Contract Field Team
  • Program Manager (Equipment Specialist)
Copyright© 2006-2008 Lorenzo Oldain Thompson, CPA, P.A. All Rights Reserved.