space
Search Courses  in 

Get COURSE FEES Instantly from MSBI ACADEMY!

 

I need details for

 

My Name

My Mobile Number

My Email ID

 

MSBI ACADEMY

MSBI ACADEMY Sector 3 - Corporate Training Profile

 

 

Address : A-15, Sector 3, Noida - 201301

Behind HCL Building

Location : Sector 3 - Noida

Postal Code : 201301

Phone :9717008603

Mobile : 9717008603

Website :

 

>> B.Tech (Computer Science) having more than 11+ years of experience in Software Development and Application Support. Currently associated with one of the MNC in Noida as Sr. Software Engineer (Consultant)

>> Experience in MSBI Suite and SQL Server Development

>> Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
>> Good knowledge of POWER BI Services

>> Expert in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2008/2012, SQL Server Import Export, Bulk Insert.

>> Experience in designing of and implementing ETL packages using SSIS 2012/2008 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Flat file, Text File) by using different transformations available in SSIS toolbox such as Data Conversation, Conditional Split, Bulk Insert, Merge, Lookup, Cache, Multicast, Merge Join, Union all, Derived Column, Conditional Split, Sort, Incremental Data Load

>> Experience of Data Profiler Viewer, Project Conversion wizard, Deployment of application using SSISDB Catalog and Environment variables
>> Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages

>> Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging

>> Experience in creating Parameterized, Graph, Dashboard, Drill down, Drill through, Sub Reports, Matrix Reports and Linked reports using SSRS (SQL Server Reporting Services) and Crystal Reports

>> Good working knowledge of Subscriptions, Cache, Snapshots, Security in SSRS

>> Expert in creating Rules, indexes, Views, complex Stored Procedures, user defined functions, cursors, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency

>> Good knowledge in Transaction, Locking, Concurrency problems and
different Isolation levels

>> Good knowledge of different schemas, Dimensions, Cube, Relationships

>> Storage locations and MDX query

>> Dimensions Types and KPI

>> Multidimensional and Tabular techniques

>> Experience in executing complete SDLC

>> Experience in Designing, Coding and Supporting different workflow tool using different SDLC model

 

 

List of Corporate Training Courses offered by MSBI ACADEMY


Microsoft BI
MicroSoft Business Intelligence
Microsoft BI-SSIS
SSRS
SSAS
MDX
MSBI-SQL SERVER

 

 

TrainerDesk Training Jobs

 

High Technologies Solutions - Delhi,Noida,Gurgaon

Training course fee & Discounts