Chandreshsinh S.

Hello Recruiter, Thanks for Checking out my profile, I am having extensive knowlege in Power BI, Power Apps, Data Engineering & Data science Project having 11+ years of experience in Database Development and BI Solutions for Enterprise level systems using Microsoft suite of products and IBM Cognos. I am also Certified Power BI developer with hands on experience to deliver two hundred plus reports and dashboards of different modules and different domains. Certified Azure data engineer with expertise in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions Below are My Key highlights Experience in developing ETL interfaces using SSIS and ADF, Analysis cube using SSAS (Tabular and Multidimensional) and enterprise reports using SSRS, IBM Cognos and Power BI utilizing latest versions and features Designed and Developed Data Warehouse architecture in on-premises and cloud environment, ETL packages (SSIS) and Azure Data Factory for data load from various heterogeneous data sources. Experienced in Building SSAS Tabular and Multidimensional Cubes using different data structures of Fact and Dimensions and writing MDX and DAX Scripts. Build and Deployed different Business Dashboards and Analysis reports for Sales, Purchase, Backlog, General Ledger, Production, CRM, Marketing, M&A and Inventory processes. Provide full lifecycle support to the clients from initial client interaction and requirements analysis through design, coding, testing, debugging, implementation and integration. Utilized Power BI to create various analytical dashboards that depicts critical KPIs such as sales, budget, GL, YoY and case proceedings along with slicers and dicers enabling end-user to make filters. Developed Business Dashboard including different types of KPIs, Graphs and Summary data in Cognos and Power BI with Dynamic RLS. Working knowledge in the of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models and Data integrity, and SQL joins. Good understanding and experience of Web Technologies like ASP.NET C#, HTML, CSS and Client-side Scripting using JavaScript and JQuery Technical Skills Visualization/Reporting Tools - Power BI, SSRS, IBM Cognos, Tableau, High chart, D3 JS BI Technologies - SQL Server Integration Service (SSIS), SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS), Power Platform (Power BI, PowerApps, Power Automate) Databases - MS SQL Server, MySQL & Oracle Cloud Environment - Azure Analysis Service, Azure Synapse Analytics (SQL DW), Azure Data Factory, Azure Functions, Azure data lake, MS Fabric Programming Languages - C#, SQL, DAX, MDX, Python, M Code, Java Script Certification • Microsoft Certified Professional: MS 70-778 • Microsoft Certified: Data Analyst Associate • Microsoft Certified: Azure Data Engineer