SQL Server Business Intelligence Developer (SSIS, SSRS, SSAS, PowerBI)
I'm having 7+ years of progressive IT experience in software development, designing and implementing with major focus on ETL(SSIS-SQL Server Integration Services) tool, Reporting (SSRS-SQL Server Reporting Services), Data Warehousing, Database applications.
Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio), SQL Server Integration Services (SSIS), SSRS.
Extensive experience in Data Migration, Data Conversions, and Data Extraction, Transformation, Loading (ETL) using SSIS packages, T- SQL Scripts.
Transformed unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort, Aggregation, Union and Derived Column.
Configured SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
Maintained log information in SQL table and Text File for tracking Errors and recording package execution status.
Extensive experience in T-SQL to write: stored procedures, functions, tables, views and indexes.
Experienced in creating reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
Experience in Creating Tabular, Matrix reports with and without parameters And generated Drill Down, Drill Through, List, Parameterized and Sub reports using SSRS.
Having Good communication skills, understanding situations and process oriented as an Individual and in Team.