Database Administrator
CurrentWith expertise in SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS), implemented reports in SQL Server Reporting Services (SSRS) that maximized CEO management of Big Data. • Connected to multiple sources to Extract, Transform, and Load (ETL) data into the proper datatypes for staging tables inside SSIS. • Defined fact tables, dimension tables, and measure group dimension for data cubes in SSAS. • Rendered multidimensional data into complex formats… Show more With expertise in SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS), implemented reports in SQL Server Reporting Services (SSRS) that maximized CEO management of Big Data. • Connected to multiple sources to Extract, Transform, and Load (ETL) data into the proper datatypes for staging tables inside SSIS. • Defined fact tables, dimension tables, and measure group dimension for data cubes in SSAS. • Rendered multidimensional data into complex formats using SSRS report writer. • Corrected report formats and values for upper management and their customers.• Using SQL wrote data driven schedules for SSRS reports running in SharePoint.• Constructed Relational Tables, Views, and Functions in SQL Server Data Services (SSDS) to support multidimensional data in SSAS. Show less