SQL Server DB Development, Optimization, Troubleshooting
DBA – Relational Database, SSAS, SSIS, SSRS
SQL Server Integration Services – DataMart Design, SSIS ETL, API, 3rd Party Tools
SQL Server Analysis Services – SSAS (Multidimensional and Tabular) – Creation, Support, Troubleshooting
SQL Server Reporting Services – SSRS Development – Large number of Reports
Stored Procedure Development, Optimization, Troubleshooting
Microsoft Access Forms, Reports, Modules / Visual Basic
PowerShell Development and Troubleshooting – System Center (SM, Orchestrator, Operations Manager, VMM)
QA – Testing, Bug Management, Triage, Documentation
Active Directory / LDAP – Setup, Testing and Authentication with MICROSOFT SQL, IIS, Service Accounts
Text File Processing and importing, BCP, Rowset commands in T-SQL
Financial Systems Troubleshooting and Migration (McFarland Cascade purchased by Stella Jones)
Reporting –SQL Server Reporting Services, Tableau, MS Access, VBA
Rewrite Cognos BI Reports into SQL Server Analysis Services (SSAS/OLAP)
Website Management / Administration
SQLCLR Development