Description
PROFESSIONAL SUMMARY * Around 3 Plus years of Experience in Microsoft BI tools (SSIS, SSRS and SSAS) and worked on SQL Server 2008R2/2012/2014 Versions, writing SQL queries, procedures, functions, packages, exception handling, triggers, collections and performance tuning. * Experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2008R2/2012/2014 for Batch Processing using DDL, DML, DCL commands for various business applications and Data ware-housing Systems (SSRS, SSIS, SSAS). * Experience in designing ETL data flows using SSIS creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Flat Files/Oracle /Excel Sheets/ Access Database using SQL Server SSIS. * Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Sort and Derived Column. Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging. * Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files. * Experience in creating Ad Hoc Reports, parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS. * Experience in developing and deploying reports into Report Manager by using SSRS (SQL Server Reporting Tools). Managing Report Manager Securities. * Knowledge in generating cubes with DAX queries by using SSAS (SQL Server Analysis Services) * Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables * Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands. * Experience in Query optimization and performance tuning. Knowledge to Use SQL Profiler, Execution Plan and Performance Monitor. * Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies and capacity planning. * Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2008R2 to SQL server 2012 and 2014. * Expertise in Database design, entity Normalization & database creation, maintenance and monitoring. * Worked on SVN, Team Foundation server, Visual Studio online and the application lifecycle tools associated with it. * Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile and sprint methodologies etc. PROFESSIONAL SUMMARY
Accomplishments
Highlights:
Keywords
