Country or Region: United States Industry: Construction Client Profile: As one of New York City's largest expediting firms, Milrose Consultants provides a turnkey solution for all of its clients needs. Milrose Consultants is staffed to assist its clients in every phase of the expediting process. They provide a team approach to projects, with an assigned Team Leader, Project Manager, Expediter, and Sign-off Coordinator. This ensures cohesiveness throughout the life of a project. Business Situation: Milrose Consultingês technical objectives were to reduce disk I/O, CPU utilization, network traffic and increase the reliability of their Permit Processing application. Solution: FAI analyzed over 500 database objects and made recommendations to optimize and tune the mission critical permit processing SQL database application. Benefits Speed adoption by using familiar interfaces and tools Lower total cost of ownership Better data integrity throughout the application Real-time reporting Enterprise-ready availability and performance

Milrose Consultants
–The fact that we can run a mission critical application on our existing software and hardware infrastructure without upgrading is a huge relief.” Henry Solano, IT Director, Milrose Consulting

Milrose Consulting is constantly looking for more-efficient ways to utilize its existing infrastructure and as an organization it had expanded in recent years and had increased its through put of permit processing and other related database activity accordingly.

Situation
Because of the number of records sets; end users had to wait 30 seconds in some cases to retrieve their requested results. It was identified that Milrose needed a solution that would offer:

• Enterprise-ready availability and performance.
• Agility to enable Milrose’s staff to swiftly react to customer need.
• Scalability for future growth of end users and data
• Be a solid foundation to expand the existing functionality of the application.
• Reduce complexity of code.

Solution
FAIês development team initially implemented an error tracking process system to log and monitor behavior aspects of the application. Over time FAI was able to identify not only the bottlenecks with the applications through put, but make recommendation on the table structure.

Added Value

Increase Productivity. Through a comprehensive stored procedure review. Capabilities of table look up could be identified and optimized, so to allow timely delivery of business information to those who request it and tailors it to their specific needs. The goal is to extend reporting to the entire Milrose staff and ultimately to help everyone, at all levels of the organization, make better business decisions based on one of their most valuable assets—their data.

Reduce IT Complexity. FAI methodology process simplified the development, deployment, and management of the engagement by providing a clear status meeting to the Milrose engagement team.

Lower Total Cost of Ownership (TCO). The extension of the use of the existing technology has allowed Milrose to further increase its return on their database investment.

Capitalize on Data Assets. In addition to delivering a secure, reliable database, FAI enabled its end user community to get more value from their data by including embedded functionality such as reporting and analysis.