Going an extra mile to create affordable, cutting edge components of future technology
Q3's global sourcing model gives the maximum benefit to customers in terms of cost savings, improved quality, access to highly talented professionals, flexibility of operations and reduced time to market.
The product can access most databases and file formats and profile the results accurately as well as to greatly reduce the time and effort to move and integrate data.
Also, the software is an effective data quality strategy that can help you better understand your business environment, allowing you to maximize profitability and reduce costly operational inefficiencies.
Our technology platform is primed for delivering a wide array of data services that offer maximum flexibility, exceptional quality and execution speed. Our technology platform combines quality processes, cutting edge best practices, specialized hardware, data integration tools and a vast repertoire of reusable code libraries into a unified framework that delivers a highly optimized solution to our clients.
A very critical part of our technology is our quality processes and methodologies. Every process step in our implementation is subject to our stringent internal quality checks. These quality checks result in a solution that maximizes quality and reduces errors.
Poor data quality can play a significant role in eroding your company's bottom line and competitive advantage in the marketplace. Data corruption can occur due to a number of reasons; the following are the most common reasons that contribute significantly to poor data quality.
The fair lending process – Automation was required to help perform complex statistical regression. The client wanted us to introduce five constructs to accommodate all changes in data format and content. They are as follows:
The client wanted an approach for implementing a predictive and automated process for data cleansing, quality and analysis. The premise is to use data profiling maps and associated process maps to predict the actions necessary to cleanse data or determine the further analysis steps on a column-by-column basis.
The client wanted the product to be written in Microsoft’s Visual Studio 2005 C#, and also fully integrated into Microsoft’s SSIS 2005 SQL Server SSIS, DB2 and using the .Net 2.0 Framework which can access most databases and file formats.
We enhance all facets of the enterprise data including customer data, product data, business data and conformance of data to business rules. Based on our pioneering integrated technology framework our services deliver the following key benefits:
Client is the industry’s choice for Companies that often cannot rely on the information that serves as the very foundation of their primary business applications. Inaccurate or inconsistent data can hinder the company's ability to understand its current – and future – business problems. This leads to poor decisions that can cause a host of negative results, including lost profits, operational delays, customer dissatisfaction and much more.
Compliance expertise, acquired during more than two years of operating success, positions client to help provide the infrastructure to transform raw data into consistent, accurate and reliable corporate information.
The application now provides a superior data profiling application. This application supports the creation and maintenance of eCartography datamaps.
In addition the application predicts the actions (Domain, Relationship etc …) required for individual columns and guide the user thru the analysis and correction. With the associated Microsoft SQL Server Integrated Services eCartography (SSIS) components, this product eliminates the need for external data profiling and data cleansing software provided such vendors as First Logic, Trillium, Evoke etc ... We have leveraged Microsoft’s SQL Server Business Intelligence Development Studio and Microsoft Visual Studio 2005 C# to develop this application and associated SSIS Control flows and Data Flow Components.
We have also implemented the SSIS which is a series of data flow components that provides advanced data flow actions (pattern, matching, merging, cleansing etc ...) through and intuitive interface and targets at low to moderately skilled developers.
The components required are an eCartography datamap. The data flows comprises of the initial implementation of AMB Dataminers Self Healing Application Architecture. From a competitive perspective the eCartography data flows once integrated into Microsoft SQL Server Integrated Services eCartography (SSIS) provides the equivalent to the data quality/cleansing capabilities the leading DQ vendors. Also included is a custom control flow designed to enable scheduling and processing datamaps created in eCartography via the Microsoft SQL Server Integrated Services (SSIS).
Q3 set up a dedicated team consisting of a team lead and software developers with internal program managers to monitor and guide the client-vendor partnership. Q3 ensured a transparent and flexible relationship by putting the right combination of people and technology under detailed consultation with technical managers at client site. Semi-detailed specifications were provided by client’s and Q3’s system architects worked extensively with peers both at Q3 and at client site for building a state of the art data base structure and detailed functional and design specifications. Complete operational transparency was maintained by keeping communication of status updates and progress as a regular process. People at client would hear from the team lead, the program manager and the developers on a regular basis, with more detailed daily status reports indicating progress against milestones.
Implementation, Training & SupportTraining Description
Web Version InformationData security, availability and reliability details:
Security is a critical aspect of our entire infrastructure. The following are a few of the steps that we use to ensure security of our systems and data.
In this difficult economic environment, Symfo decided to outsource one of its most critical developments to Q3 Tech. We were definitely reluctant doing so at the beginning of the project. But rapidly we understood that Q3 had the necessary skills and professionalism to bring the project to a successful realization. It was not always easy primarily because of the differences of culture. However once we understood each other, things went much better. We also understood that such a difficult project needed intense communications between Q3 and our company. Our company works on two time zones (Europe and East Coast North America) and we were amazed by the availability of the Project Manager and his team. It really contributed improving communications between us.
Phase I of our product is now ready and we are quite happy with it. We are definitely ready to start Phase II with Q3 and we highly recommend them.