With 10+ years of experience in Software Development, Database and Power BI Development. I can bring your raw data from different data sources to insightful with cleverly and smart dashboards for Intelligent business decisions. My priority is user satisfaction with the result. I am open to listen to your requirements, goals and needs and do my best. I have been developing platform comprising of Power BI, Azure, SQL Database, and BI Services that run on the cloud Business Intelligence solutions for 4+ years for multiple Domains. 

I'm an expert in the following tools: 

✅ Power BI - I have extensive experience in the development of BI solutions using these tools 

✅ SQL - I'm proficient with queries, stored procedures, functions, testing, using window functions, CTEs, joins, etc. 

✅ Business Intelligence and Datawarehouse Solution (BI/DW): Power BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). Data Warehouse ETL Tools (SSIS, DTS, BCP, BULK INSERT). 

✅ Reports: Power BI Reports, Active Reports, MS-Access Reports, Crystal Reports, SharePoint, SSRS 

✅ Other: Azure SQL, Azure services, Azure Migration, ASP .NET C#, VB.Net, WCF, Webservices 

My competencies include: 

✅ Design & development of Data Model, Data Warehouse database for Power BI Analytics & Reporting functionalities. 

✅ Create dynamic power BI reporting with Data Slicing & Drill through ability. 

✅ Developed high performance Power BI reports using conditional formatting, page navigations & hyperlink filtering. 

✅ Utilization of various KPIs in Power BI Dashboards for deeper knowledge about business data & better decision making. 

✅ Create & manage Roles in Power BI desktop, Implementing security for confidential data. 

✅ connection to data sources (sql databases, api data, odata, sap, csv, json, excel and other sources; import/direct query mode), 

✅ Development of Stored Procedure, Function, View etc. with complex TSQL queries and Reports. 

✅ Extensive use of SSIS packages for Data Extraction, Migrations, Data load (Author/Action) and data cleansing. 

✅ Design and development of data model, analytical dashboards and reports, 

✅ Designing and development of Dimension & Fact Tables, Dimension Relationship, Calculated Columns and Measures. 

✅ Design, Optimization & maintenance of CUBE in SSAS, MDX expressions, Partitioning & tuning of data structure in SQL Server for OLTP & OLAP 

✅ Deployment and maintenance (on cloud and on-premises), 

✅ Preparation of a user manual, 

✅ Consulting about BI tools and help in choosing a BI tool 

I am a member of the development team of an Australian software development company, helping 50+ clients across ANZ with dashboard development.