MS SQL (SSIS/SSAS/SSRS) Developer

Skills

Description

• Experienced MS SQL BI developer with 6+ years of experience with demonstrated success in Database Design, development of SQL Server [...] [...] etc.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services(SSIS), Analysis Services(SSAS), and Reporting Services(SSRS)
• Thorough knowledge of fixing Performance Issues using query tuning, Index tuning, Data Profiling and other database related activities.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL [...]
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Optimized long running ETL packages by using different mechanisms.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals
• Deep understanding of changes made to Configuration files and deployment models and other changes in SQL Server 2012, DEV, UAT and Production Environments.
• Experience in deploying packages to Integration Services Catalog in SQL Server 2012 and 2008 Deployment models (File System, MSDB)
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate insurance data from various source systems
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Migrated data in various formats like text based files, Excel spreadsheets etc. to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Preparing Data Warehouse Road Map plan.
• Good Experience on Cube Developments in Multidimensional Model and Tabular Cube.
• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling with Ralph Kimball Methodology (Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables) using Analysis Services.
• Experience in creating Calculation, Perspectives, Partitions, KPI's and Design Aggregations in cubes using SSAS.
• Experience in Providing the cube level security (Data level, Column level)
• Extensive experience in writing MDX Scripting and MDX Queries.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Created basic reports using CSV files as source to fetch the data in Power BI
• Responsible for creating Databases, Tables, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Expertise in Power BI, Tableau Reporting, and QlikView.
• Highly motivated with an ability to learn new systems and business processes.