SUMMARY:

• Around 8 years of experience in the IT Industry and worked on Tableau 8.3 to Tableau 9.0., Tableau Desktop, Tableau Server and efficient in connecting various data sources.
• Strong experience using Tableau Server, Tableau Desktop and Tableau Public.
• Involved in installation of Tableau desktop 8.0, Tableau server Application software and also in server migration from 8.3 to 9.0.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Wrote T - SQL queries in SQL Server, AWS's Redshift environment using SQL Management Studio/Visual Studio 2012.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.3 to Tableau 9.0.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Experience in the maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers etc.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Extensive knowledge of tableau architecture and Dimensional Modeling experience.
• Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS. Proficient in handling parameterized reports in SSRS.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server

TECHNICAL SKILLS:

BI Tools: Tableau 9.0, 8.3/8.2/8.1/8.0/7.0 , SAS, SSRS, Crystal Reports 9.0/8.5,OLAP, Cognos, Power BI

Databases: SQL Server 2012,SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g

Languages: UML, C, C++, HTML, Java, Oracle ETL, SQL, PL/SQL

Application Packages: MS Visio, MS Project, MS Access, MS Office Suite, RDBMS Oracle 11g

Data Warehousing ETL Tools and Environment: SSIS, Power Center 8.X,7.X, Salesforce, Teradata, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, Tempa, FL

Sr. Tableau Developer and Administrator

Responsibilities:

• Involved in installation of Tableau desktop 9.3, Tableau server 9.3.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created complex dashboard using parameters, sets, groups and calculations and also drill down and drill up in worksheets and customization using filters and actions.
• Involved in creating a dual-axis bar chart with multiple measures.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Demonstration of the tableau dashboards and its functionality to the business users for the self-service business intelligence.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Worked on Tabcmd to schedule the report's and setup email reports using command lines.

Environment: Tableau Desktop 9.3, Tableau Server 9.3, MS Office Suite, SQL Server, Teradata, MS Excel.

Confidential, Marysville, OH

Sr. Tableau Developer and Administrator

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Created complex dashboard using parameters, sets, groups and calculations and also drill down and drill up in worksheets and customization using filters and actions.
• Process, filter, and publish large quantities of data.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Secured Tableau server to protect the Tableau environment, security group and AWS Direct Connect.
• Involved in creating a dual-axis bar chart with multiple measures.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
• Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce in order to show the relevant data for that particular selected object.
• Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Demonstration of the tableau dashboards and its functionality to the business users for the self-service business intelligence.
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
• Developed tableau dashboard landing page for the embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users.
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.
• Best practices to enhance the response time of tableau dashboards and speed for the embedded dashboards.
• Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.
• Tableau server and desktop upgrade from 8.3 to 9.0.

Environment: Desktop 8.3/9.0, Tableau Server, MS Office Suite, SQL Server, Teradata, MS Excel.

Confidential, NJ

Sr. Tableau Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
• Worked in ASDW team where solved issues raised by the front end users and worked on the Tableau reports according to the user’s requirements.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Tableau integration for enhanced experience for the users.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Used User row level security for data in the Dashboard.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Desktop 8.1, Tableau Server, MS Office Suite, SQL Server, SSRS, SSIS, MS Excel, Sales, Teradata.

Confidential, Austin, TX

Sr. Tableau Administrator

Responsibilities:

• Worked on Tabcmd to schedule the report's and setup email reports using command lines.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,
• Trend Lines, Statistics, and Groups, hierarchies, Sets to create detail level summary report and Dashboard
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• See a comprehensive view of your user’s pipeline and results.
• Involved in installation of Tableau desktop 8.0, Tableau server Application software
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.0. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server.

Environment: Tableau Desktop 8.0/7.0, Tableau Server/Administrator, Tabcmd, Oracle, Teradata, Excel, Windows 2008 R2.

Confidential, Kansas City, MO

Sr. Tableau Developer and Administrator

Responsibilities:

• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Created complex data Views using multiple measures, also used sort, Filter, group, Create Set functionality.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure

Environment: Tableau 7.0, SQL Server 2008 R2, SSRS, SSIS, MS Excel, T-SQL.

Confidential, Tampa, FL

Tableau Developer and Administrator

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Conduct client interviews, high-level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
• Created dashboards and visualization by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
• Assist BAs in the team with appropriate documentation and domain knowledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Interaction and coordination with end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: Tableau 7.0, MS SQL SERVER, Oracle 10g/11g, MS Office, MS Excel.

Confidential, Boston, MA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel.

Confidential, Libertyville, IL

Tableau Developer

Responsibilities:

• Analyzed existing complex systems to understand and document data elements, relationships, data flows, dependencies and related interfaces.
• Extracted the data from various source like flat file, html document, excel sheets and databases, combined the data to present in meaningful information
• Cleansing the data through TIBCO Spotfire to detect the inconsistencies and removed the corrupt data, transform the data into right reporting format.
• Designed and deployed solutions which utilize TIBCO Spotfire hybrid in-memory/ in-database analytics architecture to support the most demanding enterprise needs, scaling to thousands of users and limitless rows of data
• Modified the SQL of an Information link.
• Administered users and Library Management, access levels, rights and folder structure
• Designing and developing the information links, Data Source, Columns, Joins, Filters and Procedures
• Created dashboards and visualization by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas.
• Structured the Spotfire library to publish and share all the analysis material, information links, data sources to end user according to their role and knowledge
• Creating data sources, parameter information links, joins, filters in information designer for fetching data in to Spotfire as per the business needs.
• Created Information Links By using Information Designer to pull the data from Oracle Database and SAS data sets required to create the reports.
• Optimized TIBCO Spotfire and Background Tasks for Targeted Interactions Analytics and Visual Inventories.
• Implemented security for write back of claims amounts from TIBCO Spotfire dashboards.

Environment: TIBCO Spotfire4.0/5.0, MS SQL SERVER, Oracle 10g/11g, SAS, Toad.

Confidential

Sr. SQL Developer

Responsibilities:

• Developed and maintained of websites using .NET for US Bank client.
• Designed a website for US Bank customer online banking using ASP.NET.
• Mastered the ability to design and deploy online banking application with front end designing.
• Created different Hierarchies to meet the Business requirement in .NET and HTML.

Environment: .NET, Microsoft SQL server, HTML, PL/SQL.