Candidate Cover Sheet - Microsoft Dynamics 365 Senior Power Platform / BI Architect #NA-1984293160

This candidate is a BI Architect with expertise in Data Warehousing and Business Intelligence including Strategies, Design, Architecture, Development, Administration and Performance Tuning. They have In-depth knowledge of Data Warehouse concepts, dimensional modeling and design, enterprise data warehouse and data marts with slowly changing dimensions and conformed dimensions. This candidate has worked in the Information Technology industry for over 23 years and has been accredited as a Microsoft Certified Professional since 1999. This individual currently holds certifications as a Microsoft Certified IT Professional, Microsoft Certified Technology Specialist, Microsoft Certified Professional, Microsoft Certified Professional + Internet, Microsoft Certified Systems Engineer and Brainbench Certified Professional.

This candidate has a proven track record of architecting business intelligence data warehousing systems and RDBMS enterprise-wide client-server and web solutions using Microsoft tools and technologies. This individual has Served in numerous roles on diverse engagements, ranging from senior developer to BI Architect.

In a previous role, this candidate designed and developed a data warehousing and SSAS Tabular solution by combing 9 instances of Microsoft Dynamics SL for Project, General ledger, Budget, Commitments and Payroll modules. He also Designed and developed views, stored procedures and SSIS packages to load data into data warehouse. Implemented table partitioning and indexing strategy on fact tables. Designed and developed ETL strategy to load current month fact partition data. Implemented Column Store indexes on fact tables. Created SSIS packages to dynamically create staging tables and switch it with fact table partition. Implemented incremental data loading in dimensions by comparing source and target tables.

This candidate has Specialties in: Business Intelligence Architecture, Design and Development using SQL Server, Analysis Services, Integration Services, Reporting Services, Microsoft Office Sharepoint2007/2010/2013, Performance Point, Power Pivot and Power View.