SQL Power BI Specialist

Personal summary

 Over 15 years of experience in developing BI applications SQL Server, BI Stack, Power BI.  Currently working with Collinson Group as a Contractor with Role as Senior BI Developer on Alteryx, SSIS, SSRS, SQL Server Projects.  Worked with Smartest Energy Ltd as a Senior BI Developer on Power BI, SSIS, SSRS, SQL Server Projects.  Worked on St. James’s Place (Wealth Management) project in Brentwood, Essex UK (Client location) as a Senior BI Developer.  Experience in building SSAS Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripts.  Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.  Experience with Web Service, WCF (Windows Communication Foundation) and ASP.NET Web API.  In-depth knowledge of developing web applications using ASP.NET web forms, ASP.NET MVC.  Experience in Reporting Services, Power BI (Dashboard Reports), SSRS using MS SQL Server in supporting services MDX.  Proficient knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflakes Schemas, ETL processes, Dimensional Modeling and Reporting tools.  Experience in Ad-hoc reports, Data Driven Subscription reports by using Report Builder.  Experience in Migrating databases from SQL 2008 R2 to SQL 2012.  Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.  Worked on ASP.Net (MVC 4.0, Entity framework, 3 Tier architecture), C#.Net, WCF, VB.Net and SQL Server 2014.  Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).

Skills

Microsoft SQL Server Integration Services (SSIS)14 Microsoft SQL Server Reporting Services (SSRS)12 SESAM/SQL Server14 Microsoft Power BI6