Sql Server, SSAs, ssis, power bi, MDX, ssrs

Location:

San Francisco, CA

Posted:

August 02, 2016

Contact this candidate

Resume:

Rahul Algude

+1-615-***-****

***********@*****.***

Professional Experience Summary:

8+ years of hands-on experience in the Information Technology industry with specialization in data warehouse development life cycle

Highly proficient in structured database source system analysis, data profiling, and development of DWH Star/ Snowflake schema

Rich experience in all stages of SDLC, including knowledge transition, requirement gathering, designing and documenting, development, testing, implementation, post-implementation support and following Quality Assurance (ISO 9001 and SEI CMMI 5) processes

Over 8 years of strong technical experience in working on MSBI technologies – SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tabular model

Implemented optimal SSIS solutions using ample understanding of SSIS data flow engine and buffer handling

Handled performance issues with source system by implementing looping in SSIS and reading only required partitions on source

Implemented SSIS event handling to monitor package progress and provide logging for debugging and maintenance

Design and implemented SSIS solution which allows large volume data transfer using parallel execution

Experienced in SQL code optimization and tuning using various best practices

Extensively worked on SSAS cube performance optimization

Extensive hands-on experience reporting tools such as ProClarity 6.3/ Performance Point Server/ TIBCO Sporfire

Experience in creating ETL packages using SSIS to extract and transform data from a variety of sources to integrate the data in a data warehouse/data mart model

Experience in configuring SSIS packages – providing logging using package logging, error handling through event handler, breakpoints and check-points to fix errors

Expertise in job scheduling using SQL Server Agent to perform hourly/daily/nightly updates

Experience in using all new features of SQL server like – Common Table Expression (CTE), error handling using TRY-CATCH statements, MERGE operations, data partitioning etc.

Extensive experience in developing and fine tuning of T-SQL objects like complex queries, views, stored procedures etc.

Demonstrated experience in generating different types of reports such as drill through/drill-down reports, parameterized reports, sub reports using SSRS.

Hands-on Experience in creating simple and complex ad-hoc reports using drilled through reports, cascading parameter and Grouping reports in SSRS

Export various entities from different databases and source files and load into SQL tables using SSIS

Implemented configurable SSIS packages using parameters and variable

Implemented advanced features in SSAS including translation, role based security, custom actions, SSRS actions & partitions

Implemented SSIS solution to optimally process SSAS databases

Implemented framework based SSIS package to load large number of tables using third party components (CozyRock)

Hands-on experience in QlikView 11 and NPrinting

Coordinating with clients from multiple countries and effectively gathering and prioritizing requirements

Ample understanding of business process of client and accordingly suggested and implemented various reporting solutions

Domain knowledge in Insurance, Sales and Services domains

Ability to work independently and as part of a team. Excellent troubleshooting and problem solving skills

Experienced in understanding and working with product databases

Hands on experience on Hadoop eco system using Pig, Spark and Zeppelin

Technical Skills:

Languages:

T-SQL, Python, MDX

ETL Tools:

SQL Server Integration Services (SSIS)-2005,2008R2, 2012

Reporting & Analysis Tools:

ProClarity 6.3, PPS 2007/2010, SSRS,QlikView, NPrinting, Tibco Spotfire, SQL Server Analysis Services

Databases:

MS-SQL Server 2005/ 2008/2008 R2/2012, PostgreSQL 6.3

Other related tools:

Apache Spark, Hive, Zeppelin, TFS, MS VSS, MS Visio

Work Experience:

Project 1

Product Analytics

Client

Asurion-USA (Mobile Insurance)

Organization worked for:

Synechron

Title

Lead- Software

Work Location

San Mateo, California

Duration

18 months (On Going)

Time

July 2014 – till date

Team

12 member team

Roles/Responsibilities

Requirement analysis, impact analysis and effort estimation

Writing technical specification document based on requirement needs

Understand and analyze data from multiple sources

Developed business focused data marts using SQL server BI stack and provided dashboard solution

Created SSIS packages to gather data from various sources such as flat files, PostgreSQL, SQL server

Handled performance issues with source system by implementing looping in SSIS and reading only required partitions on source

Implemented SSIS event handling to monitor package progress and provide logging for debugging and maintenance

Implemented in-flow decryption of data using script task in SSIS

Created a SSIS package for JSON data parsing and loading

Implemented project deployment model in SSIS for better maintainability

Implemented configurable SSIS package using parameters and variables

Designed and implemented SSAS solution for analytical reporting and KPI tracking across various dimensionality

Implemented SSRS reports along with TIBCO Spotfire dashboards

Using Apache Hive, Spark and Zeppelin to access data in Hadoop implementation for analysis

Created complex stored procedures to summarize data in data marts; which are fed into dashboards

Optimized SQL code in views, which are used in reporting solution

Perform AD-HOC analysis to support business cases

Implemented SSRS reports for operational reporting

Technologies/Tools used:

ETL – SQL Server Integration Services (SSIS – 2012)

Reporting– Tibco Spotfire, SSRS 2012, Apache Zeppelin

Databases: SQL Server 2012, PostgreSQL, SQL Server Analysis services, Apache Spark, Hive

Project 2

APAC Qlik-View Dashboard

Client

Asurion-APAC (Mobile Insurance)

Organization worked for:

Synechron

Title

Lead- Software

Work Location

Pune, India

Duration

5 months

Time

February 2014 – June 2014

Team

2 member team

Roles/Responsibilities

Requirement gathering and analysis

Requirement analysis, impact analysis and effort estimation

Development and implementing software programs to meet business and technical requirements

Understand and analyze data from multiple sources

Implemented a SSIS package to bulk transfer data, using various tuning methods

Created a framework around SSIS package to reuse same package to load 200+ source tables

Created data -warehouse as per requirement using SQL server BI stack

Designed and implemented SSAS solution for analytical reporting and KPI tracking across various dimensionality

Implemented a Tabular model POC for a section of data model

Developed analytical reports using SSRS, using drill-down and drill-though approach

Implemented SSIS logging using custom stored procedures for support team

Implemented SSIS package dependency mechanism using SQL logging tables and SSIS expressions

Implemented configurable SSIS package using parameters and variables

Developed QlikView Dashboards for management

Created static distribution reports using NPrinting

Implemented data cleansing using DQS in SSIS

Implemented project deployment model in SSIS for better maintainability

Technologies/Tools used:

ETL – SQL Server Integration Services (SSIS – 2012)

Reporting– QlikView, NPrinting, SSRS 2012

Databases: SQL Server 2012

Project 3

Acyan Enterprise Dashboard

Client

ACYAN (Member of NEW Asurion) -Japan

Organization worked for:

Synechron

Title

Senior Associate

Work Location

Japan & Pune-India

Duration

29 months

Time

October 2011 – February 2014

Team

5 member team

Roles/Responsibilities

Requirement gathering by interacting with business teams

Worked as an on-site coordinator in Japan

Performed data analysis of various business systems

Writing technical specification document based on requirement needs

Tuned up design for maintainability, scalability and efficiency

Designed Data model to support analytical and operational reporting using Microsoft BI stack

Implemented an efficient SSIS solution to load multiple incoming flat files on FTP

Implemented efficient SSIS solution, using native components and optimally planning buffer load

Implemented error handling and reporting in SSIS; error is reported along with wiki page for support team, detailing required steps to correct the issue

Implemented a parent child SSIS packages to allow controlled execution of packages depending upon scenarios

Designed test plans for SSIS solution

Designed and developed of SSAS cubes for analytical reports

Implemented Custom drill to details solution using .Net code and adding it to SSAS solution; this allowed to generate custom reports being generated using SSAS default drill to details action

Implemented SSAS expressions to provide comparative analysis

Implemented translations for reporting using SSAS

Implemented role based security

Created SSAS perspectives to provide simplistic view of Cube to business users

Implemented optimal SSAS processing plan using SSIS

Implemented configurable SSIS package using variables and configurations

Technologies/Tools used:

ETL – SQL Server Integration Services (SSIS – 2008 R2)

Reporting– SSRS, Excel

Databases: SQL Server 2008 R2, SQL Server Analysis services

Project 4

Market Feedback Analysis

Client

UTC Fire and Security - USA

Organization worked for:

Larsen & Toubro InfoTech

Title

Senior Associate

Work Location

Navi-Mumbai- India

Duration

10 months

Time

December 2010 – September 2011

Team

4 member team

Roles/Responsibilities

Requirement analysis, impact analysis and effort estimation

Detailed Design and Prototyping

Writing technical specification document based on requirement needs

Tuned up design for maintainability, scalability and efficiency

Designed data mart to provide analytical and operations reporting solution

Developed business focused data marts using SQL server BI stack and provided dashboard solution

Created SSIS packages to gather data from various sources such as flat files, SQL server

Handled performance issues with source system by implementing looping in SSIS

Created complex stored procedures to summarize data in data marts

Optimized SQL code in views, which are used for static reports

Created Stored procedures for SSRS reports

Implemented SSIS event handling to monitor package progress and provide logging for debugging and maintenance

Implemented a parent child SSIS packages to allow controlled execution of packages depending upon scenarios

Designed and developed of SSAS cubes for analytical reports

Developed SSRS reports for regular reporting

Implemented configurable SSIS package using parameters and file based configurations

Technologies/Tools used:

ETL – SQL Server Integration Services (SSIS – 2008)

Reporting– SSRS, Excel

Databases: SQL Server 2008, SQL Server Analysis services

Project 5

Time Analysis Tool

Client

UTC Fire and Security - USA

Organization worked for:

Larsen & Toubro InfoTech

Title

Associate

Work Location

Navi-Mumbai- India

Duration

5 months

Time

September 2010 – January 2011

Team

4 member team

Roles/Responsibilities

Requirement gathering and analysis

Created POC for SSRS reports using SSAS as underlying database

Developed business focused data marts using SQL server BI stack and provided dashboard solution

Requirement analysis, impact analysis and effort estimation

Tune up design for maintainability, scalability and efficiency

Understand and analyze data from multiple sources

Combine data sets based on business rules and provide insights

Designed data-mart based on user requirements and performance expectations

Designed KPIs and reports to support regular reporting

Created SSIS packages to gather data from various sources such as flat files, SQL server

Combined data from multiple payroll systems using SSIS solution

Implemented text file based logging and implemented summary email for SSIS package

Created complex stored procedures to summarize data in data marts; which are fed into operational reports

Designed and developed SSIS solution for analytical reporting; implemented best practices for optimal performance

Implemented Drill Through actions in SSAS to provide quick access to granular data

Implemented currency conversion in SSAS to provide correct output value based on currency being analyzed

Implemented role based security in SSAS to secure sensitive data

Implemented configurable SSIS package using parameters and file based configurations

Technologies/Tools used:

ETL – SQL Server Integration Services (SSIS – 2008)

Reporting– SSRS, Excel

Databases: SQL Server 2008, SQL Server Analysis services

Project 6

Service Dashboard Upgrade to PPS

Client

UTC Fire and Security - USA

Organization worked for:

Larsen & Toubro InfoTech

Title

Associate

Work Location

Navi Mumbai- India

Duration

6 months

Time

March 2010 – August 2010

Team

3 member team

Roles/Responsibilities

Infrastructure Setup for Performance point

Requirement gathering and analysis

Created POC using Performance point 2007, to convert existing ProClarity report into Performance point

Requirement analysis, impact analysis and effort estimation

ETL flow design to integrate various data sources

Developed SSIS packages to gather additional data points for comprehensive analysis

Design and development of SSAS cube

Implemented KPIs and time series analysis using Performance point

Created reporting portal using SharePoint 2007 and integrated existing SSRS reports

Created new analytical dashboards using Performance point

Implemented text file based logging and implemented summary email for SSIS package

Implemented configurable SSIS package using parameters and file based configurations

Designed and developed SSAS solution for analytical reporting; implemented best practices for optimal performance

Implemented Drill Through actions in SSAS to provide quick access to granular data

Implemented currency conversion in SSAS to provide correct output value based on currency being analyzed

Implemented role based security in SSAS to secure sensitive data

Conducted performance tuning for SSAS solution to optimize dashboard performance

Conduct demonstrations for end users

Created User Manual for Data Model and Dashboard

Created guidelines for Support teams

Technologies/Tools used:

ETL – SQL Server Integration Services (SSIS – 2008)

Reporting– SSRS, Performance point 2007

Databases: SQL Server 2008, SQL Server Analysis services

Project 7

i-Sales Dashboard

Client

UTC Fire and Security - USA

Organization worked for:

Larsen & Toubro InfoTech

Title

Associate

Work Location

Navi-Mumbai- India

Duration

8 months

Time

August 2009 - March 2010