Business Intelligence Team Resume

Summary of Qualifications:

  • 24 x 7 Database and Business Intelligence Support
  • Average 5 Years of BI Development Experience
  • Support of Over 300 Remote DBA Clients
  • Manage 10s 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

Work Experience

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.

Basic Administration Skills

  • 7 x 24 x 365 SQL Server Business Intelligence Support
  • 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 SQL 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 Activities

  • 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 Skills

  • TSQL, MDX, DAX Development and Tuning
  • ETL Strategy, Development, Optimization, Troubleshooting, Maintenance
  • Creation and Optimization of SSRS Reports
  • Creation and Optmization 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 Methodology
    • Inmon Methodology
    • OTLP or OLAP
    • Data Marts or Data Warehouses
    • Power BI
  • 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 Modeling for Forward or Reverse Engineering
  • Archival Strategies Including Implementation and Maintenance
  • Data Warehouse and Business Intelligence Architecture Consultation
  • 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
  • OTLP and OLAP Server Consolidation Recommendations

Technical Skills

SQL Server Versions
SQL Server 6.0, 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, AlwaysOn 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
Certifications
Member of Microsoft Partnership Program; All major Microsoft Database Certifications including MCP, MCDBA, MCTS, MCITP, MCSE

References

“It is very nice to be off the ground with our EDW. It was a big project and we couldn’t have done it without RDX. We initially sought the help of RDX to consult with us on the EDW data model and design, but we eventually decided to leverage your BI Team for quite a bit of development work as well. What was initially going to be only a couple months of partnership turned into a longer-term relationship. This is a testament to the value that RDX brings and how well they worked with us.

Like most large-scale development projects, the work is never “done,” and we are continuing to build off of the foundation RDX helped us construct.”

-Business Services Client

“I have been extremely happy with all of the BI-related support and training the RDX team has given us. It has always been a positive experience, and we appreciate everything. Keep up the good work..”

-Healthcare Client

Select Clients

  • abb concise
  • avenue
  • catawaba valley medical center
  • gate gourmet
  • sportclips haircuts
  • sbarro
  • mount sinai
 
image description
All Customers Receive
timely service 24x7 Support from DBA Experts
united states support 100% Onshore DBA Solutions
team of resources Dedicated DBA Resources
database service Customized
SLAs