Technical Consulting, SQL Server, Business Intelligence, Power BI, Big Data, Machine Learning, SharePoint.Designing, Developing, Deploying, Architecting & Consulting Cloud Solutions.BI Solutions Consulting of Enterprise Reporting & ScorecardsAdvanced Analytical skills including HDInsight, Azure Machine Learning, Data Science, IoT, Azure Stream Analytics.Have done enterprise level Implementation for End to end BI/DW projects for multiple domains including Telecom, FMGG and Insurance.

OLAP Tech Lead, responsible for SSAS cube design, development & delivery for the telecom domain

Project: Reports & Correspondece for SuperPartnersSuperPartners, the largest Superannuation fund administrator in Australia. TCS is developing a new application which integrates the 16 different fund administrations into a single application. Reports & Correspondence team is responsible for developing and designing the Reports using SSRS and extract XML Data from database required for generating Correspondence letters.

Intelligroup is a strategic IT consulting service provider having around 2000 employees across the globe. Being a CMMI Level 5 certified, Quality is given great importance. Ebiz dept. is certified as Microsoft's Gold Partner.Project: SUMMIT for Reckitt Benckiser The SUMMIT project for Reckitt Benckiser (leading FMCG UK based company) is aimed to provide crucial financial information of the client. The source data comes from JD Edwards, Hyperion and other sources which are loaded into staging environment. From Staging environment the data is transformed, cleansed and loaded into a data mart environment where necessary olap cubes are created for analysis. Reports are generated using proclarity analysis tool.

Tools SQL server 2005, Microsoft Analysis Services 2005, MDX, DTS, ProClarity Responsibilities Support for scorecard built on proclarity5.0 on call basis.Identify Bugs on the system.Testing of new patches.Maintaining reports that are used to send the client for weekly and monthly basis. OverviewData is loaded from multiple data sources (JD Edward, SQL) to Stage then cleansed data is loaded in to Mart databaseDTS is used to load data and process partitions using DSO classes.Security is implemented on dimensions using dynamic MDX in dimension securityMoCo 2007This project was enhancement of already existing project (Summit).There was requirement to fetch the data directly from AS-400 rather then text file; Also Bug fixing was done in order to improve the system.