AXIS is a Health Care Service Provider in United State. Purpose of System is capture all the insurer healthcare policy related details along with Premium & Claims. Policy data(BDX/NBDX) are flowing from different sourcing like SQL database, .csv file, Amazon MSSQ Queue etc. Using SSIS tool system push all the required data into SQL server DataMart which data analyzed by SSAS tool and finally user generate report using Power BI tool.

CPG Analytics is cloud based product, Client doesn’t need to maintain any software or hardware in premises. Based on variety of source data, product will perform the following operation 1) Gather all the required information using SSIS ETL tool, 2) Perform analysis on source data using SSAS tool, and 3) Generate meaningful historical reports and Dashboard using Power BI tool. Final output of the product hosted on SharePoint portal as reports. Currently following client using CPG Analytics product L’Oreal, Coke, Ferrero Rocher, SAB Miller etc.

SharePoint Insights Tool is created for Avanade (Joint Venture of

Microsoft). It is useful to track the status of DB Farm, Application, Site collection and Website. It is generate the useful graphical, Interactive and tabular report for Management. It’s give information like 1) how many database, services and website running on client portal, 2) How much space consume on disk by Database and web site, 3) Historical report of social and site related information which help management to compare year-wise, quarter-wise and month-wise, etc.

Humana is a Health Care Service Provider in United State. Purpose of System is Calculate the Rewards points based on policy holder attending event in Humana. According to Rewards points policy holder getting additional health plan or dollar ($).