MS SQL Server BI Developer Resume Chicago, IL - Hire IT People

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.

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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MS SQL Server BI Developer

Responsibilities:

Developed, executed and maintained SQL queries/scripts and to validate completeness, integrity and accuracy of data.
Design and develop Tableau dashboards using Desktop 9.0 version and on tableau server.
Refresh data extract on the Tableau server for data consistency.
Extensively wrote and edited existing Stored Procedures, User Defined Functions and Triggers using T-SQL.
Worked on designing physical and logical data model using star schema methodology.
Designed and implemented SCDs in data model.
Created new database files and database file groups in SQL Server 2008 using SSMS and T-SQL.
Configured report server in development and production and also created SQL Server Reports using SSRS 2012 from initial stage.
Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.

Environment: Tableau 9.0, MS SQL Server 2012, MS SQL Server Reporting Services 2012,Oracle 11g

Confidential

MS SQL Server BI Developer

Responsibilities:

Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
Design and develop Tableau dashboards using desktop 8.0.
Configured report server in development and production and also created SQL Server Reports using SSRS 2008 from initial stage.
Designed and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
Worked on creating Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad-hoc reports.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008,Tableau 8.0,TFS, SharePoint

We provide IT Staff Augmentation Services!

Ms Sql Server Bi Developer Resume

Chicago, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship