Our Locations

Data Warehouse

 

We have delivered total Data Warehouse solutions, encompassing all aspects such as source system analysis, data modeling, design, development, deployment and post production support.

 

Data warehouse solutions for Oracle E-Business Suites

• We have successfully delivered complete data warehousing solutions for Oracle E-Business Suite. The solution would include,
• Various aspects of Finance such as revenue, costs, payables, receivables, budgets and balances; from both sub ledger and general ledger point of view.
• Order Management, fulfillment and delivery
• Materials Management and Inventory
• Pricing
• Human Resources

 

Source of Data – Oracle E-Business Suites 11i, Oracle Database 10g.

ETL Tool – Informatica Powercenter v9.

Destination – Oracle Database10g

 

 

Data warehouse solutions for Customer Relationship Management (CRM) Products

• We have successfully delivered complete data warehousing solutions for Siebel CRM. The solution would include,
• Equipments, Agreements, Warranties and Entitlements.
• Service requests – Installations, Preventive Maintenance, Field Repairs and other Specialties.
• Service Activities – Parts, Labor and Expense tracking.
• Service Invoices
• Derivation of several cross functional metrics to facilitate decision support in large service organizations.

 

Source of Data – Siebel CRM v8, Oracle Database 10g.

ETL Tool – Informatica Powercenter v9.

Destination – Oracle Database10g, SQL Server database.

 

 

Data Warehouse Solutions for Device Tracking – An advanced CRM Application

• The latest productivity improvement trend in customer service is to track performance of capital goods (Industrial equipments and Devices) installed at customer locations, at real time; for predictive analytics, guaranteed Device uptime and offering high end service contract.
• We have designed, developed and implemented analytics solution to facilitate these activities.

 

Source of Data – SQL Server database, XML Files, Flat Files

ETL Tool – Informatica Powercenter v9.

Destination – Oracle Database10g, SQL Server database.

 

 

Oracle Application Development

 

We have designed, developed and deployed complete modules for Oracle E Business Suites. Following are some of the examples.

 

International Product Registrations

Companies have to seek regulatory approvals and statutory clearances before selling certain products in certain international markets. The approvals are obtained for individual products or for a class or family of products.

 

We developed an add-on module to Oracle E-Business Suite to manage the entire regulatory business. The module is fully integrated with the rest of the ERP solution. E.g. an order would automatically go on hold in Order Management module if the given product is not approved for sale in a given geography.

 

Custom Item Creation

Creating an Item can be a cumbersome process, especially if sales category, product attributes flags etc. are to be set. They need to be created individually one at a time with lot of information to be entered manually for every record in various organizations.

 

We developed a small solution sitting on the top of Oracle E Business Suite Inventory module that offered item creation with provided attributes in multiple organizations. Standard templates can be designed, saved, modified with common data for most of the input information and items could be created across multiple organizations using background batch processing.

 

 

Business Intelligence

 

Reports and Dashboards

Custom web based Dashboards with drop down menu based interlinked reports and links. The reports would include tabulated data with various types of graphs and charts. User level security is enforced.

 

Backend source of data – Data warehouse in an Oracle database.

Technology Stack – Microsoft .Net, Oracle PL/SQL, EstJs.

 

We have delivered end-to-end solution for sales and service dashboards including design, development and deployment.

 

 

BI in Oracle iStore

iStore is Oracle’s business-to-business (B2B) and business-to-consumer (B2C) electronic commerce (e-commerce) solution. It’s a web-based sales outlet that can be fully integrated with Oracle E Business Suite in the backend.

 

We delivered customer reporting solution, replete with graphs and charts, as an add-on into iStore. The solution sourced data from the top of Device tracking data warehouse we built for our client. This allows to create a personalized experience for shipping clients, as it provides visibility to their global install-base, health of various device, purchase history etc.

 

This is an end to end solution fulfilling all BI related requirements. Security features were designed and implemented to provide personalized data.  Additional security measures were implemented to make sure servers inside the firewall were not compromised while accessing data from outside.

 

Technology Stack – Java, Java Script, MQ series.

 

 

Healthcare Data Integration

 

We have extensive presence in the domain of data integration and interoperability using HL7 messages.

 

We provide both inbound and outbound data movement from Electronic Medical Records (EMR) systems of hospitals into healthcare related products of our customers. We have developed, deployed and continue to actively support such interfaces with more than 15 hospitals in the United States. We have worked with several EMRs including Cerner, Epic, Meditech, ORSOS, SIS etc.