Citrix Partners with AAJ Technologies to Fix BI Implementation (FBI)


Citrix, a client of AAJ Technologies for over 10 years needed to consolidate multiple data warehouses in order to be more efficient. AAJ fixed Citrix’s BI issues by removing redundancies and enhanced performance by optimizing queries.


  • Removed redundant steps in the ETL process
  • Added improved logging for better troubleshooting and reporting
  • Used conformed dimensions to have a single version of the truth
  • Optimized the queries to extract the data faster
  • Reduced the cube processing times. Delivered the project within the client’s budget and timelines
  • Positioned the company for continued growth


  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)


  • Consulting services development
  • Project Management


About Citrix

Citrix solutions are used by over 100 million individuals at 400,000 organizations around the world, including 99% of Fortune 500 companies. Their Workplace-as-a-service technologies help organizations redefine the limits of productivity. With revenues of $3.28 billion, Citrix is a global leader in Enterprise Mobility technology.

A Big Opportunity – and a Big Challenge

Citrix was using multiple data warehouses which were built over years by different teams using different standards and redundant steps. These challenges were stopping Citrix from making changes more efficiently. The troubleshooting was also multifold due to so many different steps and sometimes the reports were inconsistent.

Partnering with AAJ Technologies

AAJ Technologies has been a trusted partner for Citrix for over 10 years. AAJ Technologies has delivered many projects with Citrix with high quality, always within their timelines and budget.

Citrix engaged with AAJ Technologies to fix the BI-related issues, remove redundant steps, enhance performance by optimizing queries, and use conformed dimensions to have a single version of the truth – essentially re-architecting the whole solution. “We chose AAJ due to their expertise in Business Intelligence and systems integration, they are easy to work with and very predictable. Their teams provide high quality every single time and on top of all we don’t need to interact with the whole team, but just the lead Project Manager and they take care of everything from there”. Said Karl.

AAJ’s Solution for Citrix

AAJ’s consultants worked closely with Citrix’s BI team to define the requirements and tasks associated with each step. The new solution took the data from ERP, Licensing fulfillment system and CRM. “AAJ created a solution that has complex integrations, is well-engineered, robust, and technically sound,” observed Karl. “Their work was very high quality, but they also did it quickly. And AAJ’s commitment was impressive. They did whatever it took to help us get the project completed on time – even if it meant working late hours – to ensure that we met our tight deadlines. The project was delivered ahead of time with a lot more functionality than what was committed in the original scope at the beginning of the project”

The Results

  • Improved data quality
  • Improved customer satisfaction
  • Improved operational efficiency
  • Reduced costs
  • Increased competitive advantage
  • More accurate and faster reporting, analysis or planning
  • Better business decisions

PDF Download

AAJ Technologies

Global Headquarters

6301 NW 5th Way Ste. 1700
Ft. Lauderdale, FL 33309
TEL: 954.689.3984

LATAM Headquarters

AAJ Technologies S.R.L.
Alvear 1670 – 4to Piso
(2000) Rosario, Santa Fe

Copyright © 2017 AAJ Technologies. All rights reserved.