Nishil J.

Currently working as a Senior BI Architect with responsibility to further develop the existing Microsoft Datawarehouse BI Solution which has 40-50 BI Reports and many Cubes/Dimensions developed in SSAS Tabular model . Working on moving the On-premise datawarehouse to Azure Synapse , Data Factory, Data Lake ,Azure Functions. Also working on getting realtime sensor data into Azure Synapse and analysing using Azure Anaylysis Services/PowerBI. Also working on getting Microsoft Dynamics CRM Marketing Interactions data into Azure Synapse using Dataverse and analysing using Azure Anaylysis Services/PowerBI. The Reports are developed using SSRS and Excel and Performancepoint/Power BI . My role involves:  Establish new technology and process to support more modern analytics and information consumption.  Evangelize the BI and Analytics ecosystem to ensure strong and appropriate usage of existing tools as well as strong adoption of new technology and process.  Work on projects to specify patterns and standards to be used across the full development life cycle.  Accountable for Architect related deliverables to ensure all project goals are met within the project time lines by working closely with project team.  Perform mapping between source and target data, as well as performing logical model to physical model mapping and mapping from third normal form to dimensional.  Oversee the design of and tactical implementation of custom views to ensure optimization based on the RDBMS (Relational Database Management System) being used. I have also been working as a Biztalk Architect since 2004. Its been a good experience with BizTalk versions varying from 2004,2006,2006 R2,2009 till date. I saw this product grow in age and maturity level and now its a mature product to be called a successful Integration tool. Worked with other Microsoft products like Sharepoint also.