Sql Server Manager

Professional Summary

Technical BI Consultant with over 5 years of IT development experience using Microsoft BI tools and Tableau 9.0 in Finance and HealthCare domain.

Extensive knowledge and experience in dealing with Relational Database Management Systems RDBMS with strong understanding of key concepts like Normalization and Relational Integrity Constraints.

Strong experience in BI tools including MS SSIS and SSRS 2008/2012 versions.

Over 2 years of experience in Tableau visualization and dashboard development using Tableau 8.0 and 9.0

Extensive experience in writing DDL, DML, Stored Procedures, Triggers, Views, Functions and complex T-SQL queries.

Excellent knowledge and experience on Datawarehouse implementation using Star Schema and snowflake schema, Slowly Changing Dimension and Factless fact table.

Hands on experience in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad-hoc reports and distributed reports in multiple formats using MS SQL Server Reporting Services (SSRS).

Experienced in cascaded parameterized reports, formatting report layout, sub reports using global variables, expressions and functions using MS SSRS.

Expertise in creating standard report Subscriptions and Data Driven report Subscriptions

Experienced in configuration of report server and report manager scheduling, setting various permissions levels of users in MS SQL Server Reporting Services (SSRS).

Expert in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) and Data conversion process experience with strong ETL skill.

Expertise in created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned.

Expertise in error handling for complex packages and troubleshooting.

Expert in dealing with Alerts, Operators and Jobs through MS SQL Server Agent.

Education

Bachelor of Pharmacy, Amaravati University, India.

Academic Awards

Gold medal for highest rank in Pharmacy Division in academic year.

Technical Skills

Tableau 9.0, MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2005/2008/2012, MS SQL Server Integration Services 2005/2008,Oracle 11g, Toad, SSMS

Contact this candidate