Skip to main content

Microsoft BI Team Resume

Experience in supporting tens of thousands of SQL Server databases running on all versions (from 6.0 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, partitioning, database schema design, and ERD diagramming. 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.

Summary of Qualifications:

  • 24 x 7 Database and Business Intelligence Support
  • Average 8 Years of BI Development
  • Support of Over 300 Remote DBA Clients
  • Manage Tens of 1000s of BI Processes Daily
  • Support 1000s of BI Servers
  • Performed over 3000 DTS/SSIS Package, SSRS Report and SSAS Cube Upgrades and Migrations
  • Support over 2000 SSRS Reports

Basic Administration Skills:

  • 7x24x365 Support of SQL Server BI Stack Environments (SSRS, SSIS, SSAS)
  • Backups of SQL Server BI Environments (SSRS, SSIS, SSAS)
  • Monitoring Strategies for Business Intelligence Environments
  • Emergency Recoveries of Data Warehouses, Data Marts, and SQL Server Business Intelligence Environments
  • Ensuring Recoverability of Data Warehouses, Data Marts and SQL Server Business Intelligence Environments
  • SQL Server BI Stack Installation, Configuration, Migration,Upgrades and Patches
  • Restores and Refreshes
  • Object Creation and Management
  • Change Management
  • Security Administration and Maintenance of SQL Server
  • Business Intelligence Environments
  • Effective and Efficient Critical Response
  • Regulatory Compliance Support
  • Health Checks/Assessments of Data Warehouses, Data Marts,SQL Server Business Intelligence Environments
 

High Availability Skills:

  • Scale Out Deployments
  • Report Server Database Mirroring
  • Multi-Instance SSIS Configuration
  • AlwaysOn Availability Groups
  • Design and Support Report Server Encryption Key, SSAS, SSIS and SSRS Configuration Backup Plans
 

Security:

  • Report Server User-Driven Filtering
  • Analysis Server Hierarchy and Dimension Security
  • SSIS Package level Encryption
  • Database User, OLAP Roles, SSIS Proxy, Report Server and Security Administration
  • SSRS Encryption Key Management
 

Development Support:

  • T-SQL, MDX, DAX Development and Tuning
  • ETL Strategy, Development, Optimization, Troubleshooting, Maintenance
  • Creation and Optimization of SSRS Reports
  • Creation and Optimization of SSIS Packages
  • Creation and Optimization of SSAS Cubes
  • Formal or Informal Code Reviews
  • Creation and Tuning of SSRS Reports
  • Creation and Tuning of SSIS Packages
  • Creation and Tuning of SSAS Cubes
 

Strategic Skills:

  • Data Warehouse and Data Mart Analysis, Design and Implementation (Complete Project Support)
  • Data Modeling (Kimball, Inmon, OLTP, OLAP, Data Marts/Warehouses)
  • Dashboard Design and Implementation
  • Requirements Gathering, Documentation, Milestone and Process Management
  • Partitioning Strategies Including Sliding Windows Partitioning
  • Create SSAS Cube Measure Group Partitioning
  • Align Table and/or Sliding Window Partitioning with SSAS
  • Cube Measure Group Partitioning
  • Data Warehouse and Business Intelligence Architecture Consultation
  • Data Modeling for Forward or Reverse Engineering
  • Archival Strategies Including Implementation and Maintenance
  • SharePoint (SSRS Related)
  • Hardware Architecture for Data Warehouse Environments
  • Strategies for Heterogeneous Data Warehouse ETL Environments
  • Strategies for Automation Including Refresh Jobs Removing Sensitive Information
  • Design and Implement Analysis Services Multi-Dimensional Cubes and Tabular Models
  • Data Cleansing
  • OLTP and OLAP Server Consolidation Recommendations
  • Power BI

Planning and Design Services:

  • BI Architecture Design and Implementation (Complete Project Support)
  • Evaluation and Analysis of Existing BI Architectures
  • Requirements Gathering, Documentation, Milestone and Process Management
  • Data Warehouse and Business Intelligence Architecture Consultation
  • Data Modeling (Kimball Methodology, Inmon Methodology, OTLP or OLAP, Data Marts or Data Warehouses, Power BI)
  • Dashboard Design
  • Power BI Design and Development
  • ETL Design
  • SSRS Report Design
  • MDX and OLP Cube Design
  • Health Checks/Assessments of Data Warehouses, Data Marts, SQL Server Business Intelligence Environments
  • OTLP and OLAP Server Consolidation Recommendations
 

Implementation and Development:

  • SQL Server BI Stack Installation and Configuration
  • Feature Installation and Configuration
  • New Project Development
  • Power BI Development
  • ETL Design, Deployment and Administration
  • TSQL, MDX, DAX Development and Tuning
  • Formal or Informal Code Reviews
  • Creation and Tuning of SSRS Reports
  • Creation and Tuning of SSIS Packages
  • Creation and Tuning of SSAS Cubes
  • Scale Out Deployments
 

Ongoing Support:

  • 24x7x365 Support of SQL Server BI Stack Environments (SSRS, SSIS, SSAS)
  • Proactive Monitoring and Problem Resolution
  • Backups of SQL Server BI Environments (SSRS, SSIS, SSAS)
  • Emergency Recoveries of Data Warehouses, Data Marts, and SQL Server Business Intelligence Environments
  • SQL Server BI Stack Installation, Configuration, Migration,Upgrades and Patches
  • Restores and Refreshes
  • Object Creation and Management
  • Change Management
  • Security Administration and Maintenance
  • Effective and Efficient Critical Response
  • Regulatory Compliance Support
  • Health Checks/Assessments 
 

High Availability Services:

  • Scale Out Deployments
  • Report Server Database Mirroring
  • Multi-Instance SSIS Configuration
  • AlwaysOn Availability Groups
  • Design and Support Report Server Encryption Key, SSAS, SSIS and SSRS Configuration Backup Plans

Technical Skills

 
SQL Server Versions SQL Server 6.5, 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016
Database Features Database Mirroring, Log Shipping, Clustering, Backup Compression, Database Snapshots, Replication (Merge, Transactional, Snapshot, Heterogeneous Subscribers), Change Data Capture (CDC), Table/Index Paritioning, Data Compression, SQL Auditing, Transparent Database Encryption, Extensible Key Management, Role-based Security, Sliding Window Partitioning, Always-On Availability Groups, Contained Databases, Master Data Services, Data Quality Services, Encryption
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, Crystal Reports, Tableau
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, Veritas Clustering, Veritas NetBackup, Polyserve, PowerPivot,PowerView, QlikView, RSScripter, R
close button

Resources

*Required