About Me
I am IT Professional with 11 Years of Experience in Software Development and Support. I have strong Skills with MSBI(SSIS/SSRS/SSAS), SQL Server 2012/2016, Power BI. I have Understanding of Healthcare and insurance domain.
... Show More
Skills
Database
Programming Language
Web Development
Others
Portfolio Projects
Company
AXIS Capital
Role
Full-Stack Developer
Description
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.
Show More Show LessSkills
SQL Server Integration Services (SSIS) SQL Server Reporting Services - (SSRS) SSAS SQL Power BITools
Power BICompany
CPG Analytics
Role
Full-Stack Developer
Description
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.
Show More Show LessTools
Power BICompany
SharePoint Insights / Application X-Ray
Description
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.
Show More Show LessCompany
Humana Rewards System / Atlas Rewards System
Role
Full-Stack Developer