Skip to main content

Microsoft BI Team Resume

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.

Summary of Qualifications:

  • 24 x 7 Database and Business Intelligence Support
  • Average 8 Years of BI Development
  • Support of Over 400 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
  • Disaster Recovery Strategy
  • Multi-instance SSIS Configuration
  • Read-only Reporting Architecture
 

Security:

  • Report Server and Power BI User-Driven Filtering
  • Analysis Services Row Level Security (Multi-dimensional and tabular model)
  • SSIS Project 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
  • Formal or Informal Code Reviews
  • Tuning and Optimization of SSRS Reports
  • Tuning and Optimization of Power BI Reports
  • Tuning and Optimization of SSIS Packages
  • Formal or Informal Code Reviews
  • Creation and Tuning of SSAS Cubes and Tabular Models
 

Strategic Skills:

  • Data Warehouse and Data Mart Analysis, Design and Implementation (Complete Project Support)
  • Dashboard Design and Implementation
  • Requirements Gathering, Documentation, Milestone and Process Management
  • Partitioning Strategies Including Sliding Windows Partitioning
  • Create SSAS Cube and Tabular Model 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 Reporting

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 DAX OLAP Cube Design
  • Health Checks/Assessments of Data Warehouses, Data Marts, SQL Server Business Intelligence Environments
 

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
  • JSON Extraction and Parsing
  • Azure Data Warehousing Design and Implementation
  • Azure Data Lake Design and Implementation
  • Amazon AWS/Redshift Design and Implementation
 

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
  • Multi-Instance SSIS Configuration
  • Design and Support Report Server Encryption
  • Key, SSAS, SSIS and SSRS Configuration Backup Plans

Technical Skills

 
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
close button

Resources

*Required
The website encountered an unexpected error. Please try again later.