Datawarehouse / Business Intelligence / Report Lab

• Informatica Certified Developer Partner
• Wide range of Solution Offerings - DW Design, ETL, OLAP, pointed Data Quality Solutions & Offshore Report Development
• Experience in delivering solutions based on leading products such as Microstrategy, COGNOS, Business Objects, MS OLAP, Hyperion Essbase and other OLAP tools
• System Integrator who is an expert in Data Quality Strategy & Solutions
• Development of integration products between tools

Tratum Technologies have been in the forefront of datawarehouse development for the past 10 years. We have worked with some of the very large companies to set up large datawarehouse infrastructure and reporting tools. We have worked with major ETL and OLAP tools for implementing these systems. In the recent past, there has been developments in data warehousing arena wherein third party providers are giving an added value for some areas of corporate performance improvement by giving industry vertical based data analysis. It is no longer good enough to improve the efficiency of your enterprise. You need to look beyond your company and see how you are doing compared to the industry. Tratum Technologies have been on the forefront of these business segments. We are working very closely with multiple datawarehouse vendors, operating like a bureau, for these industries in developing their data mart for reporting to multiple customers of their chosen industries

We are also proving custom report development tools for various domains like Contact Center management reports, CRM systems, ERP systems and also for established Data Warehouse setups where interim reports are developed on a cost effective fashion on offshore basis.

In this age of Information technology with enormous Data at your disposal it is important that the right information reaches you at the right time for making the right decisions on a timely fashion. Today internal and external data are blended together in CRM, ERP, data warehouses and advanced web applications that constitute Business intelligence systems. These applications would be confusing unless they have effective and sensible reporting capabilities because the organizations rely on these information to make key decisions. Keeping in mind these scenarios, we have designed Reporting services based on leading packages/technologies. Datawarehoue Bureau models add further complications of outside or other sources of information from spreadsheets to publicly available information to other structured information from CRM, ERP systems along with advanced web tools for better access of intelligence to the corporate users.

Offerings

Reporting
Crystal Reports
Actuate Reports
Business Objects
Oracle Reports
Informatica Power Analyzer Reports
Microsoft OLAP/Reporting Services
Microstrategy
Hyperion Essbase

Data Warehouse design/ETL

Implementing datawarehouse projects including analysis and design of the data warehouse database with Star schema, Snowflake schema etc.
Designing multidimensional cubes
Populating the datawarehouse using ETL tools like Informatica, Ab Initio, Microsoft DTS etc.
Using Informatica Powerconnect features like MQConnect to directly source and integrate enterprise data.
Developing other Powerconnect tools for Informatica using Powerconnect SDK.
Using Informatica external procedure and custom transformations talk to third party API’s.

Highlights

A well-established Report Development team and knowledge center
Has provided solutions, services and support using Microstrategy, Oracle, Crystal Reports, Business Objects, Actuate etc. to various organizations
Has well-established CRM, Business Intelligence/ Data warehousing, Application Integration, and Custom Development practices focused on Enterprise solutions.
Has well experienced and certified consultants across various technologies, vertical skill set experience and project management skill