Programador en SSAS Boliviano
Experiencia en SSAS
Soy un consultor certificado por Microsoft en SSAS. Nombrado Microsoft Most Valuable Professional.
- Crear y modificar ETLs in SSAS.
- Modificar consultas en PL-SQL y T-SQL (Oracle y SQL Server).
- Mantenimiento de Aggregations.
- Mantenimiento de nuevos campos, remover campos en el modelo SSAS.
- Mantener reportes en MDX y DAX.
- Automatización de tareas en PowerShell
- Automatización de mantenimiento de particiones con SSIS, Script tasks, PowerShell.
- Hace deployment y mantenimiento de tablas, vistas, procedimientos almacenados en TFS.
- Mantener registro de cambios en TFS.
- Atender requerimientos de usuario y tener reuniones.
- Realizar control de calidad de cambios. Coordinar con el cliente.
Experto en trabajar con clientes de habla inglesa. Mi idioma nativo es español. Puedo comunicarme en Francés de manera escrita.
Docencia en SSAS
- Docencia en SSAS para la fundación Jala, Tekhne y empresas privadas tales como Tigo, BOA entre otros.
Articulos escritos
Analysis Services Administration
- Automate SQL Server Analysis Services Tasks with PowerShell - Part 2 (last update: 5/17/2013)
- Create SQL Server Analysis Services Partitions using AMO (last update: 11/9/2012)
- How to synchronize two SSAS Servers (last update: 4/15/2013)
- Import data from Azure SQL to Tabular Databases (last update: 8/18/2016)
- New features for SQL Server Analysis Services Tabular Databases in PowerShell (last update: 10/12/2016)
- PowerShell Commands for SQL Server Analysis Services Tabular Mode (last update: 12/12/2014)
- Retrieve SSAS Properties Using Analysis Services Management Objects and SSIS (last update: 3/28/2018)
- Using ASCMD to run command line scripts for SQL Server Analysis Services (last update: 6/8/2012)
- Using PowerShell for SSAS to check service status and database availability (last update: 7/9/2013)
Analysis Services Development
- Common DAX functions and expressions for a SQL Server Tabular Database (last update: 9/6/2016)
- Dynamic XMLA using T-SQL for SQL Server Analysis Services (last update: 11/2/2012)
- New DAX functions in SQL Server 2016 (last update: 12/28/2015)
- New SQL Server Tabular Projects for Analysis Services (last update: 6/20/2012)
- SQL Server Analysis Services ProcessAdd for a Partition (last update: 3/17/2014)
- Tabular vs Multidimensional models for SQL Server Analysis Services (last update: 1/28/2016)
- Analysis Services Dimensions
- Copy SQL Server Analysis Services Dimensions (last update: 12/17/2012)
- Using ProcessAdd to add rows to a dimension in SQL Server Analysis Services SSAS (last update: 7/15/2013)
Analysis Services Measure Groups
- Different options for creating a distinct count measure in SSAS (last update: 9/12/2013)
- Analysis Services Performance
- Improve SQL Server Analysis Services Performance with the Usage Based Optimization Wizard (last update: 2/22/2013)
- Improving SQL Server Analysis Services Query Response Time with msmdsrv (last update: 3/25/2013)
Analysis Services Tutorials
- Getting Started with the DAX queries for SQL Server Analysis Services (last update: 10/28/2015)
- Using Excel to interact with a SSAS cube (last update: 2/27/2013)
Contacto
Whatsapp +59175502310
Comentarios
Publicar un comentario