United States   |    Mexico   |    India     

For immediate service, call (714) 491-2636

Interconnection of Disparate Systems

Out team was in charge of developing adapters for different life sciences applications and services to keep them synchronized and up to date. Our client already had a custom Middle-ware framework for connecting life sciences applications. In fact their framework is totally focused on the life sciences industry.

Our task was to create custom adapters for a comprehensive list of applications related to the life-sciences industry in order to connect them in real-time. This required knowledge of Systems integration, Message based architectures, Web Services, and Optimization Techniques.

The adapters were created on top of their own custom middle-ware which is created on top of the .Net Framework and Sql Server 2005.


Our client integrated the process of building/remodeling a house by providing a service that allows all interested parts to contribute to the project. It allows the home owner to plan how many rooms, bathrooms, and kitchens he/she will need. Then the architect can add items and materials to each of them. An interior designer can decide on different artifacts and decoration that best suits the place. Plumbers can enter the needed material and so on. Finally it allows the home owner to have a realistic plan and schedule for the remodeling: dates, products, costs, materials and everything in one single place.

This web application was built using ASP.NET 2.0. It makes intensive use of AJAX enabled controls. One of them is the new Microsoft's AJAX Framework known as AJAX.NET. The other set of controls used belong to a third party vendor called Telerik (http://www.telerik.com). Most of the operations in a single page were thought/designed to use AJAX in order to avoid full page refreshes, thus providing the user with a more interactive experience while browsing the site. While developing this site, an integration between different types of controls and manual operations was planned in order to optimize the speed and response of AJAX calls. This set of features turn the Client into what nowadays is known as a rich web client where the pages are similar to a windows like application with sliders, trees, and tooltips.


The client engaged us to build a complex image-modification system based on complex algorithms allowing the different layers of an image to be separated. This engine together with a program allows the end user to take their favorite pictures, load them up in the program and let it automatically separate the foreground from the background. It then allows the user to make manual changes to the computer's decision to tune up the areas that the algorithm didn't segment accurately. The purpose of this application is to demonstrate the full potential of the algorithm providing different views and scenarios of how the image would look like if fed with X, Y parameters.

The image processing engine was built using native C/C++ by Client's engineers. This core was dynamically integrated into C# to coexist with the stand alone application developed by Axis Technical staff making use of advanced marshaling techniques. This kind of architecture allows for maximum flexibility and makes it possible to upgrade/improve the engine without changing the windows application. It also optimizes memory usage by delegating pixel-per-pixel manipulation to a more low level programming language (such as native C/C++) and delegating UI's functionality and user related events to a more sophisticated object oriented language such as C# .NET 2.0.


This client is a world premier provider of innovative drug discovery and development solutions. We delivered a web based application that keeps track of the expenses made by their employees. The solution handled the different types of expenses made by the company's employees in a very detailed level, also allowing any type currency input for each expense. The expense entry is a user-friendly page that adapts to the user needs. Depending on many variables that change along each expense entry, the page shows or hides, enables or disables and calculates different input controls that build up the complete detail of each entry. Each entry can be partitioned into different projects by percentage, allowing the user to bill a certain expense to different projects or companies.

Since this application required a very high level of interactivity, speed, functionality and usability without refreshing the page each time the user clicked on it, the solution was built using native Asynchronous JavaScript and XML techniques (AJAX) and the Microsoft ASP.Net 2.0 platform.


This Client serves as a "service layer" placed between the Insurance Carriers and the Brokers (those who sell the insurance policies). This company provides services to the brokers, which allows them to find the best insurance policy for a particular client. However, the company does not charge the Brokers, their real customer are the Insurance Carriers, as they are charged for each sale made through the company.

One tool for the client was a Sales Representative Dashboard for their own Intranet only. This tool is used by the Sales Representatives, and it allowed them to manage all the broker information and activities. Each Sales Representative can see the contact information for all the brokers assigned to him. It allowed tracking of calls, meetings, etc. between the Sales Representative and the Broker. Also keeps record of quotes and potential sales that may need special attention. Also the Sales Representative can look to former sales made through a specific broker. The application is integrated with Exchange, so an activity created on the dashboard will appear on the Sales Representative's Exchange calendar, and every activity entered from Outlook will appear on the Dashboard calendar. The dashboard also allowed filter information for the Sales Representative Managers, so they know which activities and how many sales each Sales Representative is doing, also allows knowing how many activities with brokers he/she has scheduled for the following days.

Another tool developed for the client was known as "Forms Request." This tool is for the public site and it allowed brokers to request physical forms from the carriers, or when available, to download them in a pdf file. Basically the broker logs into the portal and selects all the forms that are required, once selected, the broker confirms the order and then the application asks for the shipping address, if different to the address registered on client database. If the forms are available for download, after the brokers select all the needed files, the application generates a .zip file with the pdf's and the broker gets the compressed file.


Enterprise Command Application

Our team was instrumental in the major enhancements and performance improvement for an Enterprise application that was created to have every piece of information and tool a Loan Agent would need in one centralized application. This means that it contains parts of multiple systems; for example the application has the functionality to manage the client resource, making it very close to a CRM system. It also has Loan application functionality, where it manages all the information regarding loans and their management. In the back-end, Command Center is powered by two other systems which provide the Loan Origination Functionality and the Rate Selection mechanisms. In brief, this Enterprise redesign efforts for this system is an all-in-one application, which provides the necessary tools for the Loan agent to do its job.

The redesign project is an effort to correct what accelerated and unplanned growth has caused to the overall performance of the application. The main goals of the project were: To add referential integrity, normalize tables, remove unnecessary SQL objects, dynamic SQL statements conversion into stored procedures and an overall performance gain.

Axis Technical Group took part on the first stage of the project where the requirement was to extract the queries out of the application through another Object layer, which can be easily modifiable in the future. The main target of this migration was to achieve an improvement of 10% to 15% of performance gain by structuring the database access through the use of a Data Access Layer, Business Entities and Stored Procedures.

A team of 6 people worked for 4 months to create the layers, entities and stored procedures using a well designed approach to get the best performance out of the migration. The team created the required objects and put together five release packages which were applied sequentially to the production environment with a very low bug rate: 5 defects out of 350 migrated queries. Once the iterations were released there was between a 25% and a 30% of performance gain.

SQL Server 2005 Reports Migration

This project consisted of migrating hundreds of MS Access reports used in an enterprise Loan Origination system to MS Reporting Services. The migration process included the creation of new Reporting Services using an existing template customized for Lending Tree. The process also included the rewrite of MS Access embedded queries to robust SQL Server 2005 stored procedures.

When complex business and slow views were found, we re-engineered them and created straight and simple queries that performed much faster than the original. We were responsible of ensuring that business rules were maintained in place, so that reports returned what the original reports provided. During the migration process, a new release of MS Reporting Services was launched, so a full migration from framework 1.1 to 2.0 had to be executed.

Business Intelligence

The main objective of this project was to create the infrastructure needed to provide key executives with indicators and measurements with information coming directly from the trenches of the company. This helped decision makers take the necessary steps to implement aligned strategies with a clear view of the market and company status.

While working in this project, we always imagined this set of tools and reports using the metaphor of an airplane. The company would be an airplane, and this project would represent an airplane dashboard, that would show the pilots of the plane, the company's top executives, the information needed to fly the plane, and keep it in the right direction.

This project was created on top of Microsoft technologies, like SharePoint, Reporting Services and Sql Server 2005 Business Intelligence Technologies. Also to improve the aesthetics of the final product Dundas Charts and Gauges were used appropriately.

Home  |  About us  |  Consulting Services  |  Staffing Solutions  |  Outsourcing  |  Capabilities  |  Careers  |  Contact Us

Copyright © 2008 Axis Technical Group, Inc. All rights reserved.