BI Developer

BI Developer-

v BI Developer with 6 years of experience in the IT Industry in Data Warehousing (DW) and Business Intelligence (BI) using Microsoft Business Intelligence tools ADF, SSIS, SSAS, SSRS, SQL Server, and Power BI.

v Experience in Deploying SSIS Packages, Creating Jobs, Alerts, and Scheduled SSIS packages using SQL Server Agent.

v Proven experience in extracting data from heterogeneous sources, transforming and loading (ETL) process using SQL Server Integration Services (SSIS) with different Control Flow Tasks and Data Flow Transformations.

v Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.

v Good experience in implementing Full or Incremental loading.

v Experience in developing Visualization reports dashboards using Power BI.

v Having knowledge in Dimension Data Modeling, Cube Development, and Manipulations in SQL Server Analysis Services (SSAS).

v Having good experience in creating SSRS reports in the form of sub reports, linked reports, drill down and drill through reports.

v Proven experience in creating database objects like Tables, Views, Writing Stored Procedures, Triggers, Cursors, Clustered Indexes, and NonClustered Indexes.

v Generated SQL Queries using necessary join conditions and used indexes efficiently for good performance of queries.

v Natural communicator with strong motor skills and the ability to build, produce and succeed.

v Team Player and self-starter with the ability to work independently or as a part of a team and capable of picking up new skills quickly.