SUMMARY:

• SSRS, Tableau BI Developer With 9 years work experience in the areas of analysis, Use Tableau tools in Data warehousing, Client Server Technologies and Web - based Applications, design and development of Business Intelligence solution using Microsoft BI suite (SSAS, SSIS & SSRS).
• Define specification, design and build of Tableau Desktop reports and dashboards.
• Responsible for best practice implementation of Tableau workbooks for Tableau 8.3 migration
• Display the different business information simply, quickly and correctly for clients with the different chart type
• Having excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. Worked with business partners to define analysis requirements. Guide them through the BI delivery process and layout the business and application architecture road map.
• Developed Stored Procedures, User Defined Functions and SQL scripts for performing automation tasks. Hands on experience in creating Jobs, Alerts and Scheduled SSIS Packages
• Experience in Data Extraction, Transform & Load (ETL) development using SQL Server Integration Services (SSIS). Tableau Extracts data.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables. Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS). Building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Experienced in designing and developing SSRS 2012 reports using data from SSAS Cubes and Relational database data sources. Designed Dashboards and reports using multiple KPI's . Experience in various reporting tools like Report Builder, Report Designer .

TECHNICAL SKILLS:

• SQL ( 7 Years), SSIS ( 3 Years), SSAS ( 1 Years), SSRS ( 4 Years)
• TABLEAU 8.3 ( 2 Years)
• Crystal Report ( 1 Years)
• Oracle 11G SQL ( 1 Years)

EXPERIENCE:

Confidential, Seattle, WA

Tableau Lead Consultant

Responsibilities:

• Converting SSRS reports to Tableau by Re-creating them into Tableau 9.0. Defined best practices for Tableau report development.
• Validating and Testing of the Database data. Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.

Confidential, Melville, NY

Tableau Consultant

Responsibilities:

• Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, EXCEL sheets, CSV format and used complex data conversion to target. Attained legacy data to use as a source to develop new reports previously compiled .
• Used SSRS to create customized Reports . Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS. Created Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development. Created DTS Packages to integrate the Business Logic and Data Transformations, saved DTS package according to requirements.
• Planned and recommended data model designs suited best for Tableau needs . Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once. Built compelling, interactive dashboards in Tableau that answer key business questions .Extensively created and drafted Tableau Dashboards for Regional Marketing teams utilizing complex features such as Table Calculations. Removed constant values by given dynamic values by creating parameters with calculated fields .
• Converting SSRS reports to Tableau by Re-creating them into Tableau 8.3. Defined best practices for Tableau report development.
• Validating and Testing of the Database data. Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.

Confidential, New York, NY

Tableau Consultant

Responsibilities:

• Created numerous dashboards in Tableau Desktop based on the data collected from MS Excel, CSV and SQL server
• Converting SSRS reports to Tableau by Re-creating them into Tableau 8.3
• Extract data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers.
• Utilized SQL Server 2012 and Visual Studio in creating and deploying SSRS reports
• Developed datasets to perform reporting and including interactive drill down reports, report models and ad-hoc reports. Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using SSRS
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.

Confidential, Las Vegas, NV

Table Game Data Analyst

Responsibilities:

• Configured SQL Server 2008 and Oracle 10g/11g database parameter files to adjust the memory usage and file size
• Created database tables with various constraints including primary key, foreign key, etc.
• Loaded data from flat data files and excel sheet into Oracle database using SQL*Loader and SQL Developer
• Extracted data from Oracle database tables into flat data files and Excel sheet.
• Generated variety of business reports using SQL queries, PL/SQL, sql plus

Confidential, Ledyard, CT

Table Game Data Analyst

Responsibilities:

• Successfully installed and configured MS SQL Server2012 into Windows Server 2008R2 operating system, created user login, role and permission configuration
• Successfully created Casino database tables with various constraints including primary key, foreign key, etc
• Loaded all the flat data files and excel sheet data, which have been accumulated since the opening of Casino in 1986, to SQL Server 2008 Data Base tables using BCP, BULK insert and table Import /Export. And extracted data from SQL Server 2008 database tables into flat data files and Excel sheet
• Power user of advanced SQL queries with multi-table joins, group functions, sub queries, set operations and T-SQL functions. Analyzed the proportion of people from the different races who touched gambling. Analyzed people who touched gambling from their gender, age and race to their gambling time range, season and holidays … And Analyzed the VIP members of the portion of their family who touched gambling, how much time and how much money they spent on gambling… in order to make different-level plans, provide the valuable analysis report to decision makers and help to make the effective promotion program
• Generated variety of business reports using SQL Server 2008 sql query, Crystal Report 2 and Excel 2007 Pivot table. Fully used the current casino resources such as hotels, restaurants, golf course, theaters, bar and clubs … to attract people across the country to come for gambling
• Created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions. Created data-mining solutions, deployed them to SSAS instance. configured report server and deployed reports on web server and SharePoint, built Performance Points Dashboards in SharePoint 2010. Built reports from Analysis Services cube with MDX query designer