Sql Server Development, SSIS, SSRS, SSAS

Professional Summary:

Experience developing various projects in the role of a Microsoft Business Intelligence Developer.

Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

Extensive experience in BI suite - using integration services (SSIS) for ETL, reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.

Proficient in creating and maintaining tables, indexes, Views, complex Stored Procedures, user defined functions, joins, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.

Handled performance tuning and optimization, with strong analytical and troubleshooting skills for quick issue resolution.

Created and implemented complex SSIS package to migrate data from multiple data sources to the new data warehouse by performing different kinds of transformations like lookup transformations, derived columns, merge join, conditional split, and data conversion with multiple data flow tasks.

Proficient with data warehouse structures staging, facts, dimensions, aggregate tables, dimensional modeling, Star/Snowflake schemas and maintaining data integrity.

Design and build reliable SSIS packages with detailed error handling and notification techniques to maintain integrity and notify responsible parties in the event of an error.

Expert in designing enterprise reports using SQL server reporting services (SSRS) like Matrix, Drill down, Drill through, Sub reports and Ad-Hoc reporting. Created multiple value parameters, cascading prompts, dynamics reports.

Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Created SSRS report projects in BI Visual studio and developed dashboards for daily business intelligence analysis and decision making.

Designing enterprise reports using SQL server reporting services (SSRS) based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Worked with Business analyst, Data architect and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and User oriented with a desire to learn client's business requirements

Education / Certifications

Master of Science in Mechanical Engineering – Southern Illinois University Carbondale (SIUC)

Bachelor of Engineering in Chemical Engineering – Enugu State University of Science & Technology

Microsoft Certified Technology (MCSA) Querying Microsoft SQL Server 2012/2014

School of Data Analytics: Certified BI/EDW Developer

Technical Competencies

Operating Systems

Windows 98/2000/2003/XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2

Database Tools

SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard

GUI Tools

SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2008/2010/2012

DBMS/RDBMS

MS SQL Server 2012/2008 R2/2008

Languages

T-SQL, C#

OLAP Tools

SSAS, SSRS

ETL Tools

SSIS, DTS, Import/Export Wizard

Project Experience

Health Axis Group, Irving, TX NOVEMBER 2016 – CURRENT

Role: Database Developer

Responsibilities

Experience gathering and analyzing the business requirements of the company and translating the information into business intelligence report development.

Performed SQL Server Installation and configuration of SQL Server 2012. Management tools using Sql server Setup Program.

Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions.

Wrote and executed complex T-SQL queries using SQL Management Studio for data retrieval and back end data validation testing.

Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.

Worked extensively on creating Stored Procedures, Views to support Web front Dashboards and reports.

Extensively work in designing & deploying SSIS packages for transferring data from heterogeneous data to and from SQL Server.

Regular monitoring of Time/Data driven Subscription based SSRS reports (Daily, Weekly) and SSIS external file transfers.

Support the ETL team with functional knowledge of SSIS ETL and framework

Produce results in a rapidly evolving environment with quality result

Created parameterized reports for the users and clients, with drill-down, drill-through features.

Managed business issues on connectivity, permissions, data validation & worked with business analysts for report generation.

Colaberry School of Data Analytics, Dallas, TX FEBURARY 2016 – OCTOBER 2016

Role: SQL Server BI Developer (SSIS/SSRS/SSAS)

Responsibilities

Experience in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform

Developed T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex join and sub queries in SQL Server Management studio (SSMS).

Designed ETL packages dealing with different data sources (SQL Server, OLTP, XML) and loaded the data into target data sources by performing different kinds of transformations like merge joins, derived columns, merge join, conditional split, and data conversion in SQL Server Integration Services (SSIS).

Implemented Error Handling by using the Script component to generate custom error messages and redirected the error rows to an error file

Build the SSIS packages to load the Data into Staging, ODS and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.

Created data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.

Developed reports, sub reports, data driven subscriptions, drill down reports and drill through reports using various features like Charts, graphs, filters etc.

Involved in creating different Parameterized reports like standard parameter reports, cascading parameter reports and dashboards using SSRS.

Deployed reports to report manager and troubleshooting for any error occur in execution.

Role: SQL SSIS\SSRS ETL Developer NOVEMBER 2015 – January 2016

Responsibilities

Have developed and maintained T-SQL Stored Procedures, User Defined Functions and Data Models according to the business requirements.

Implemented complex SQL queries using joins, sub queries and correlated sub queries.

Created SSIS Packages to perform filtering operations and to migrating the data from the OLTP system and multiple excel files to SQL server.

Extensively work in designing & deploying SSIS packages for transferring data from heterogeneous data to and from SQL Server.

Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.

Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.

Involved in monitoring and troubleshooting complex packages by using data viewers, debugging and maintenance of ETL packages and its optimization using SQL server best practices.

Created packages to migrate data from different data sources to data warehouse.

Created reports using complex T-SQL queries, user defined functions, stored procedures and views and defined the report layout and identified datasets for the report generation.

Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports using Reporting Service for the business requirement.

Processed and generated reports for the end business users on a daily, weekly, and monthly basis.

Contact this candidate