Over 8+ years of professional experience in working with projects driven On SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes. * Expert in T-SQL (DDL, DML): functions, views, triggers, stored procedures on an SQL Server. * Strong experience In SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Reporting Services (SSRS). * Solid experience with ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS. * Designed, developed and implemented various SSIS Packages and deployed using Deployment Wizard. * Responsible for creating SQL datasets for Power BI and Ad-hoc Reports. * Using Microsoft SQL Server to model datasets into datasets for Business Intelligence software. * Expert in developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS. * Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions using SSRS. * Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file from Client servers and through FTP.
Description
