SUMMARY:

• Over 7+ years of experience in Business Intelligence, Data warehousing, Data architecture, Data modeling, Data Visualization tools with specialization on Tableau 6.x/7.x/8.x.
• Experience in SQL, PL/SQL, SAS JMP, SPSS, R and other data analysis and statistical tools.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster), multi-threaded, multi process and administration of Tableau Desktop/Server, SSL, Kerberos, SAML & drivers setup activities.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installation, configuration of Tableau Server and creating users, groups, projects, sites by using TABCMD and TABADMIN command line utility tools and also assigning permissions to workbook and data view level in Tableau server.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server, SAP HANA, Hadoop, Salesforce, etc
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Improved Reports performance in tableau using extracts and context filters.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables. Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Worked with Cross functional groups and various business users to analyze the business requirements, prepare GAP analysis sheets and designed Technical documentation based on the Business Requirements
• Very good understanding of Enterprise Data Warehouse Architecture and Designing.
• Experience in user training and documenting the methodologies and requirements.
• Have good communication, interpersonal and analytical skills with the ability to effectively multitasking, meet deadlines, efficiently plan and prioritize projects with strong technical and business management skills.

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer/Administrator

Confidential, St. Louis, Missouri

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created motion chart, Bubble chart, Drill down analysis using tableau desktop
• Extensively used Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.3 in Dev, QA, UAT and Prod environments.
• Upgraded Tableau 8.0 environment to Tableau 8.3
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands - on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Create, customize & share interactive web dashboards in minutes.
• Access dashboards from any browser, tablets or IPad.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Composed documentation related to visualization dashboards and performed end user training.

Environment: Tableau Server 8.x, Tableau Reader 8.x, Tableau Public 8.x, Hadoop, SAP HANA, Java, Oracle ERP Systems, SQL Server, Teradata.

Sr. Tableau Developer

Confidential, Columbus, OH

Responsibilities:

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
• Involved in designing and creating Dimensional Data model (Star schema)
• Gathered requirements to create Project/User Usage Executive Dashboards, International Usage reports for Sales Executives.
• Created Project planning and Defect Tracking reports which help Management to keep track of budgets and Project releases.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc. Involved in up gradation of Tableau Server from v7.0.19 to v 8.0.7 and also Created Users, Groups, Projects, Workbooks and assigned Access levels in Server.
• Conducted Training sessions for Tableau Power users and created the documents for end - user support.
• Involved in Performance tuning the reports and dashboards for optimization.

Environment: Tableau v8.0/7.x, Oracle 11g, MarkLogic, TOAD, Informatica 9.x, Rally.

Tableau Reports Developer/Analyst

Confidential, Buffalo, NY

Responsibilities:

• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, IPad)
• Created extensive joins for data blending from several different data sources
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Migrated Reports from Development to Testing and to Production Environment using Import Wizard.
• Migrated Business Intelligence reports from Business Objects to Tableau.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Created Complex workbook to visualize sales using scattered plots, bar charts by tableau desktop
• Applied Multi - dimensional analysis such as slice and dice, drill functions at report level.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 6.0
• Identify risks associated with the testing strategy, then document and communicate such risk to stakeholders
• Involved resolving Error's in the reports like context error, Syntax errors, Multivalve Error, Timeout errors Created custom Function's (Date range, Time functions, array functions, and Conditional formatting functions) in the reports.

Environment: Tableau 6.0 Server, Tableau Desktop, Tableau Reader, Business Objects XI R2/ 3.1, Java, Crystal Xcelsius 2008, SQL 2008, Oracle 10g, SAP LOGON GUI 7.10 (FSCM ERP R/3), Import Wizard, Microsoft Excel 2007

SQL BI Developer / Admin

Confidential, Knoxville, TN

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T - SQL, scripts, stored procedures and views).
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005/2008, Windows 2000/2003, Microsoft office 2003, XML, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), MDX, SQL Profiler, MS Excel 2003, Visual Studio 2005, .NET Frame Work 1.0, SharePoint 2007.

SQL Server Developer/Analyst

Confidential

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Configured SSRS 2005 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Actively involved in Normalization & De - normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project

Business Analyst

Confidential

Responsibilities:

• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process Modeling.
• Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Matrix
• Develop test plans in conjunction with team leads and business personnel and perform unit, integration, regression testing.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Microsoft Office, Oracle 9i, Rational Clear Case, XML, MS Visio and Manual Testing