lightingpopla.blogg.se - Sql server business intelligence development studio 2005

#Sql server business intelligence development studio 2005 software
#Sql server business intelligence development studio 2005 professional

Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.

Knowledge in all types of Database migrations with all the versions of SQL Server.

Expert in creating and developing Power BI Dashboards in to rich look.Expertise in Power BI, Power BI Pro, Power BI Mobile.Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/ cleansing process, reports or data validation.Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

#Sql server business intelligence development studio 2005 software

Ability to work with various types and stages of Software Development Life Cycle ( SDLC) processes including Analysis, Design, Development, Testing and Implementation.

#Sql server business intelligence development studio 2005 professional

A results driven software professional with 8+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005, SSIS, SSRS and SSAS.