Experience in supporting tens of thousands of SQL Server Business Intelligence environments, architectures and solutions running on versions 2000 to 2016 for hundreds of organizations on a 24x7 basis. Very strong in Business Intelligence administration, development, and architecture, including but not limited to DTS, SSIS, SSAS, SSRS, T-SQL, data warehousing, logical and physical partitioning, database schema design, ERD diagramming and cloud/virtual services. Perform a variety of SQL Server BI tasks related to problem resolution and monitoring, administration, development, design, performance analysis, security, data mining and corporate strategy.
|SQL Server Versions||SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016|
|BI Features||SSIS Package Configurations, Dynamic SSIS Task Building, Third Party Tasks, SSRS Scale Out Deployment, Time and Data Driven Subscriptions, Standard and Dynamic Cube Partitioning, MOLAP, ROLAP and HOLAP Cube Processing, XMLA Scripting, Attribute Hierarchies, KPIs, Calculated Measures, MDX, DAX|
|Applications||Visio, E/R Studio, Powerbuilder, Cognos (Additional expertise in Crystal Reports, Tableau, and Qlikview, although not officially supported)|
|Tools||Microsoft Database Migration Tools, SQL Server Management Studio, SQL Server Agent, Microsoft Database Tuning Advisor, Microsoft Visual Studio, Quest Benchmarking/Toad/SQL Navigator, Ingress, BMC Patrol, Quest Central, DB Artisan, ERwin Data Modeler, ER/Studio, Rational ClearCase, AutoSys, ITSM, PowerPivot,PowerView, QlikView, RSScripter, Master Data Services, Data Quality Services|
|Cloud Services||Azure Data Warehouse, Analysis Services, Power BI, Machine Learning, Data Factory|