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.