Bharath Thamilarasan

Sr. BI developer - National Basketball Association

Overland Park, KS

abk9ar@r.postjobfree.com - 913-***-****

• Over 7 years of extensive work experience as an ETL Developer and in depth proficient experience in OLTP,

Dimension Modeling, Data warehouse, T-SQL, OLAP and Database technologies.

• Expertise in SQL Server 2005/2008/2012, Business intelligence tools like Integration Services, Analysis

Services and Reporting Services.

• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor, Activity Monitor and Windows

Performance Monitor for monitoring and tuning MS SQL Server Performance.

• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers using T-SQL

(DML and DDL) as well as analyzing and debugging existing complex stored procedures.

• Experience in writing T-SQL queries, Rank functions, CTE and derived table.

• Experience in Database Maintenance, taking Database Backup/ Restore, Trim Log Files.

• An expert in creating, configuring and fine-tuning ETL workflows designed in SQL Server Integration

Services.

• Extensively worked in SSIS Transformations like Lookup, Aggregate, Cache, character Map, Conditional

Split, SCD, Data Conversion, Derived column, script component, pivot.

• Extensive experience in creating ETL solutions with different data sources like RDBMS, Flat file, XML, Excel.

• Experience in creating master and child packages, package configurations, logging and Error handling.

• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages using SQL Server Job

Agent and Windows Scheduled task.

• Experience in command line execution of SSIS Package.

• Expertise in SSIS Package deployment using Package configuration in Production.

• Expertise in developing SSAS Cube for business requirement.

• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Calculated Measures,

Hierarchy, Partitions and KPI's using SQL Server 2005/2008 Analysis Services.

• Experience in analyzing data and creating Facts and Dimension tables.

• Expertise in Dimension Modelling.

• Experience in Creating MDX query for Calculated member, KPI's, SSRS reports.

• Experience in taking cube backup and restore.

• Experience in generating drill down reports, parameterized reports, matrix, charts in SSRS 2005/2008.

• Experience in Log Shipping and Database Mirroring.

• Experience in creating Transformations using the Pentaho data integration tool.

• Experience in creating job using the Pentaho data integration tool.

• Extensively Worked in Pentaho Transformation tasks like Mongo DB Input, Json Input, Table output, Modified

Java Script etc.

• Good Exposure to MongoDB database.

• Good Exposure to Reporting tool like OBIEE and Cognos.

• Coordinated in requirements gathering effort to assure that client's business needs are understood.

• Good team player, strong interpersonal combined with self-motivation, initiative and the ability to think outside

the box.

• Ability and open to learn new technology in a short time and work in it.

WORK EXPERIENCE

Sr. BI developer

National Basketball Association - September 2014 to Present

Project Name: LPBB Data Transfer

Description:

The National Basketball Association (NBA) is the highest professional basketball league in the United States.

It consists of thirty franchised member clubs, of which twenty-nine are located in the United States and one

in Canada.

NBA needs to assist Turner with gathering, standardizing and importing account IDs from various domestic

cable companies, where the owners of those accounts purchased the online viewing rights to NBA games - a

digital product called League Pass Broadband, abbreviated LPBB.

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts to gather the

requirements.

• Designed Dimension model, Facts and Dimension tables using Star schema.

• Created Entity Relation (ER) diagram.

• Implemented a complex logic to download the files from SFTP using script task in C# and the script used

in Execute process task in SSIS.

• Optimized complex T-SQL queries for better performance.

• Implemented a fully automated complex alert mailing system in SSIS as per the business requirement.

• Created SSIS package to Consolidate flat files from different sources and encrypted using GnuPG.

• Implemented Error handling and Custom Logging to keep track of Package flow and Package Execution

status.

• Deployed SSIS package using XML Package configuration in Production.

• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.

• Interacted with developers, Business & Management Teams and End Users.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

Sr. BI developer

National Basketball Association - February 2014 to August 2014

Project Name: Sailthru

Description:

The National Basketball Association (NBA) is the highest professional basketball league in the United States.

It consists of thirty franchised member clubs, of which twenty-nine are located in the United States and one

in Canada.

Sailthru is the leading provider of personalized marketing communications technology. Sailthru conduct email

campaign for NBA. Sailthru provides API to access the campaign stats. The NBA wants more insight on

campaign data. The activities include consolidating and posting the data to partner database. The email data

are then classified as spam, bounced, unsubscribed etc.

Responsibilities:

• Involved in Requirement gathering and designing data model.

• Created Entity Relation (ER) diagram.

• Implemented a logic in C# code to download and parse JSON files through web API in SSIS.

• Created SSIS task to archive the flat files and move to the archive folder.

• Created complex T-SQL using Rank function and CTE.

• Created constraints and validated database integrity.

• Deployed SSIS package using XML Package configuration in Production.

• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.

• Designed Dimension model, Facts and Dimension tables using Star schema.

• Review and Testing the Packages.

• Involved in fixing issues when the scheduled job fails.

• Interacted with developers, Business & Management Teams and End Users.

• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

ETL\ BI developer

Americo Life, Inc - April 2013 to January 2014

Project Name: Agent Cafe

Description:

Americo Life, Inc. is currently one of the largest, independent, privately held insurance companies in the United

States. Today, all sales and marketing activities are facilitated through Americo with operations in Kansas

City, Missouri.

Agent Cafe is an online web application which helps the agents in the following areas

1. Access to the most current forms, marketing materials, and software.

2. Personalized commission statements.

3. Daily pending business reports.

4. The latest Americo bulletins distributed to agents.

5. Important news and announcements.

6. Sales tools that can be customized to fit the needs.

The reporting system was based on a SSAS cube built with all measures and dimensions with Time and

Operational level hierarchy.

Responsibilities:

• Understand requirements as stated in the Business Requirement document.

• Analyze the data for the business requirement.

• Designed ETL processes using SSIS to extract the data from flat file and to load the data into SQL server.

• Analyzed the data and created Fact and Dimension tables.

• Designed and created OLAP cubes.

• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

• Designed the dimensions and relationship between dimensions and measure groups

• Created user Hierarchy and given attribute relationships in dimensions.

• Created calculated members in the cube using MDX.

• Created partitions and Aggregations.

• Interacted with developers, Business & Management Teams and End Users.

• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSAS, SSIS, Windows Server 2008.

ETL\ BI developer

National Basketball Association - August 2012 to March 2013

Project Name: VERITIX ETL

Description:

The National Basketball Association (NBA) is the highest professional basketball league in the United States.

It consists of thirty franchised member clubs, of which twenty-nine are located in the United States and one

in Canada.

Veritix is the ticket sales partner of 4 NBA teams (Cleveland Cavaliers, Utah Jazz, Denver Nuggets and

Houston Rockets) which mainly sell the season and group tickets. NBA receives 6 data feeds from each team

on a daily/monthly basis. All data feeds needs to be cleaned, loaded into Partner database on an incremental

basis.

Responsibilities:

• Involved in Requirement gathering and designing data model.

• Created Entity Relation (ER) diagram.

• Designed ETL processes using SSIS to download flat files from SFTP and extracts the data from flat files,

and to load the data into the target database.

• Created SSIS task to archive the flat files and move to the archive folder.

• Implemented Error handling and Logging to keep track of Package flow and Package Execution status.

• Created complex Stored Procedures and Functions.

• Created complex T-SQL using Rank function and CTE.

• Created constraints and validated database integrity.

• Designed rich text Email report format using C# in Script task and send Execution Status and Execution

Summary including Rows Inserted and Rows Updated

• Deployed SSIS package using XML Package configuration in Production.

• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.

• Designed Dimension model, Facts and Dimension tables using Star schema.

• Review and Testing the Packages.

• Involved in fixing issues when the scheduled job fails.

• Interacted with developers, Business & Management Teams and End Users.

• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

ETL\ BI developer

National Basketball Association - November 2011 to July 2012

Project Name: Responsys Data Consolidation

Description:

The National Basketball Association (NBA) is the highest professional basketball league in the United States.

It consists of thirty franchised member clubs, of which twenty-nine are located in the United States and one

in Canada.

Responsys is a partner of the NBA. They conduct email campaigns for the NBA. Responsys will provide us

the email Campaign data on a daily basis as flat files. Every day, they send around 3 million e-mails. NBA and

Responsys wanted to have more insight from the Responsys data. The activities include consolidating and

posting the data to partner database. The email data are then classified as spam, bounced, unsubscribed etc.

Responsibilities:

• Involved in Requirement gathering and designing data model.

• Created Entity Relation (ER) diagram.

• Designed ETL processes using SSIS to download flat files from SFTP and extracts the data from flat files,

and to load the data into the target database.

• Created SSIS task to archive the flat files and move to the archive folder.

• Created complex Stored Procedures and Functions.

• Created complex T-SQL using Rank function and CTE.

• Created constraints and validated database integrity.

• Deployed SSIS package using XML Package configuration in Production.

• Created command line execution of the package in a bat file and scheduled it in a Windows Scheduled task.

• Designed Dimension model, Facts and Dimension tables using Star schema.

• Review and Testing the Packages.

• Involved in fixing issues when the scheduled job fails.

• Interacted with developers, Business & Management Teams and End Users.

• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSIS, Windows Server 2008.

ETL\ BI developer

Farmers Insurance - March 2011 to October 2011

Project Name: Liability Analyzer

Description:

Farmers Insurance is the third largest Insurance Service provider in the USA.

Liability Analyser is an online scorecard for the Farmers Insurance Employees. The objective of the project is to

integrate all the Employees report in a consolidated dashboard. This report contains metrics and performance

scores of each employee. There are around 15 metrics built into these dashboards.

The reporting system was based on a SSAS cube built with all measures and dimensions with Time and

Operational level hierarchy.

Responsibilities:

• Understand requirements as stated in the Business Requirement document.

• Analyze the data for the business requirement.

• Designed ETL processes using SSIS to extract the data from Oracle Source and to load the data into SQL

server.

• Analyzed the data and created Fact and Dimension tables.

• Designed and created OLAP cubes

• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).

• Designed the dimensions and relationship between dimensions and measure groups

• Created user Hierarchy and given attribute relationships in dimensions.

• Created calculated members in the cube using MDX.

• Created partitions and Aggregations.

• Setup http access in IIS to import the SSAS cube into OBIEE for reporting.

• Processing the cube in weekly basis.

• Taking cube backup on a regular basis for maintenance.

• Interacted with developers, Business & Management Teams and End Users.

• Participated in regular project status meetings.

Environment: SQL server 2008, T-SQL, SSAS, SSIS, Windows Server 2008.

ETL Developer

Farmers Insurance, Inc - March 2009 to February 2011

Project Name: Athenium

Description:

Farmers Insurance is the third largest Insurance Service provider in the USA.

ATHENIUM is an online scorecard for the Claim Representatives. The objective of the project is to integrate all

the Claim representatives' data from different source databases and flat files to a single data mart. We get data

on a daily basis from different sources as flat files. After loading all the data, the data had to be transformed to

meet the requirement for the development team. The SSIS project had to be completely automated to execute

automatic file upload feature.

Responsibilities:

• Requirement gathering, analysis and data modeling.

• Created SSIS packages to copy the different source files from FTP site and load into SQL Server 2008.

• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1

and type 2 slowly changing dimensions.

• Implemented Error handling techniques.

• Identified the dimension, fact tables and designed the data warehouse using star schema.

• Created the SSIS packages using different transformations Data conversion derived Column, Lookup union

All, Slowly Changing Dimension.

• Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

• Designed Dimensional Modeling using SSAS packages for End-User.

• Created Hierarchies in Dimensional Modeling.

• Developed Aggregations, partitions and calculated members for cube as per business requirements

• Wrote SQL queries and stored procedures to generate data for reports

• Created Non-Clustered indexes to improve query performance and query optimization.

• Interacted with developers, Business & Management Teams and End Users.

• Participated in regular project status meetings.

Environment: SQL server 2005, T-SQL, SSIS, Windows Server 2003.

Software Engineer

Nuvento System - Bangalore, Karnataka - January 2008 to February 2009

Project Name: Shout Analytics

Description:

Shout Analytics is a social media analytics platform that helps organizations leverage the power of social media

websites to understand, monitor, verify and swiftly respond to customer preferences and feedback.

Responsibilities:

• Designed ETL processes using SSIS to extract the data from flat files and to load the data into the target

SQL database.

• Created the SSIS packages using different transformations Data conversion derived Column and Lookup.

• Created scheduled job in SQL server agent.

• Deployed the Package in Production Server.

• Monitoring the ETL on daily basis.

• Involved in fixing issues when the scheduled job fails.

• Provide production support for this project by solving data issues raised by the users

Environment: SQL Server 2005, T-SQL, Windows Sever 2003, SSIS.

EDUCATION

B.E in Electronics and Communications Engineering

Anna University

ADDITIONAL INFORMATION

Skill Summary:

RDBMS MS-SQL Server 2005/2008/2012, Oracle 10g/11g, MS Access

Languages C#, T-SQL, MDX, VB.NET, HTML

Operating Systems Windows 2008/XP/7/8, Ubuntu

ETL Tools SQL Server Integration Services (SSIS), Pentaho Data Integration (PDI)

OLAP SQL Server Analysis Services (SSAS), Cognos Power Transformer

Reporting Tools SQL Server Reporting Services (SSRS), Oracle Business Intelligence (OBIEE)

Application Software Visual Studio 2005/2008, Toad, SQL Developer, MS Office Suite

Contact this candidate