Sql Server Data
Resume:
Bharath Thamilarasan
Sr. BI developer - National Basketball Association
Overland Park, KS
************@*****.*** - 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