Author process validation and continuous process verification protocols and reports.I have around 4 years of IT expertise in OLTP & OLAP (Data warehousing) systems with MS SQL Server, SSIS/SSRS/SSAS. Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS, and T-SQL Programming for various business applications using DDL, DML, and DCL commands, expert in designing ETL interfaces with SSIS, data marts/cubes with SSAS, & enterprise reports with SSRS using most recent versions and features.Expertise with RDBMS principles like tables, indexes, indexed views, functions, table variables & stored procedures.SQL optimization expertise using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV's, DMFs, and Query Execution Plans.Explore data in various ways and across multiple visualizations using Power BI.Expertise in creating reports in the Power BI preview portal utilizing the SSAS Tabular via Analysis connector.Experience publishing Power BI Desktop reports created in Report View to the Power BI service.Expert in data extraction and transformation (ETL) from a variety of heterogeneous sources, as well as package creation using SSIS, Import, Export Data, Bulk Insert, and BCP utilities.Used SSIS data transformation activities like look-ups, fuzzy lookups, conditional splits, event & error handlers, & so on.Models for Data Mining in SSAS, as well as Deploying and Processing SSAS Objects.Knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and snowflake modeling is required.Experience in error handling and debugging coding issues, as well as troubleshooting production issues.
