Yogendra S.

With 15+ 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 Australian software development company, helping 50+ clients across ANZ for Dashboard development.