SUMMARY

• Overall 8 years of IT experience in Software Development and 4 years of experience in Tableau Desktop, Tableau Server, Tableau Reader and Tableau Public in versions 8.x and 9.0.
• Extensive experience working with Tableau Software as a developer and SME.
• Extensive Tableau Experience in Enterprise Environment including technical support, troubleshooting, report design and monitoring of system usage.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Extensive experience on building Analytic Dashboards using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau
• Experience in creating Tableau dashboards Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables with quick filters, parameters, sets, group, filter and URL actions, table calculations, various performance optimization, scheduling of data refresh and dashboards.
• Extensive experience creating canned and ad - hoc reports in Tableau Desktop.
• Good 5+ years Hands on experience in Microsoft SQL Server 2005/2008R2, 2012 and RDBMS Concepts, Database Programming with the help of Stored Procedures, Triggers, Cursor and Indexes.
• Experience in developing Cognos reports using list, crosstab, drill through, conditional rendering, charts prompts and summary, scheduling of reports
• Experience in developing of Metadata in Framework Manager by importing tables, views and stored procedures from Database and Preparation of Presentation layer in Framework manager. Experience in developing relational and dimensional models.
• Experience in .NET and SQL Server with Development, Build and Deployment and Production Support.
• Expertise in performance tuning of SQL Server Stored procedures.
• Domain knowledge in Health care, Retail, Manufacturing and Insurance.

TECHNICAL SKILLS

Operating System: Windows XP/Vista/7/8, UnixBI/Visualization Tools: Tableau Desktop 6/7/8.x/9, Tableau Public 8.1/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.x/9.x, Microstrategy

Programming Languages: TABLEAU, SQL, PL/SQL, SAS, Visual Basic, HTML, SPSS, UNIX

RDBMS: Oracle, Teradata, DB2, MS Access, Netezza

Application Software: MS Excel, MS Word, MS Power Point, Microsoft Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Danbury

Sr. Tableau Developer

Responsibilities:

• Worked closely with the HR team to identify various KPI’s and designed solutions to enhance business decision-making.
• Worked as the only Tableau resource for this data to represent the Data across the globe with different categorization.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Applied uniform color coding for the data across all the visualizations in the Dashboards categorized on OOC (their categorization of Human resources).
• Worked on converting the group of visualizations filtered on different OOCs into a global visualization and dashboard which has data represented about each OOC.
• Used dual axis and synchronization to combine multiple reports into a single visualization in order to compare the data in terms of different measures.
• Data plotted on different time fields have been repointed to a single global time field across all the dashboards.
• Applied data filters in the reports and used the globalize feature to filter out the data across multiple visualizations.
• Introduced toggling feature of switching between values and percentages using parameters for tabular data in multiple visualizations.
• Reordering of underlying data and showing only required fields in multiple Vizs.
• Performance optimization of various dashboards in all the dashboard files.
• Parameter based toggling of multiple visualizations on a dashboard with globalized filters.
• Used Tableau type conversion functions when connected to relational data sources.
• Used Data blending to connect data from multiple sources.
• Validated export to PDF of the dashboard and fixed the orientation of the dashboards in pdf.
• Created a landing page of the dashboards with images and URL links to other dashboards.

Environment: Tableau Desktop, Tableau server, Oracle, SQL Server, SQL, PL SQL Developer, Unix, Javascript API, HTML,CSS, MS-Excel, Microsoft office, SQL-PLUS, C++, Visual Basic, Windows 10 and Linux.

Confidential, Roanoke, VA

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Developing and maintaining high level overview of the data flows using MS Visio
• Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Designed and developed very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Advanced analytics using data blending, context filters, date filters, sorts and analytics.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Provided analytical solutions for the large problems into smaller units and reported graphically using various charts to display same dataset in different views.
• Performed SQL filters and UI formatting in tableau reports.
• Published the reports on HTML pages using Embed feature.
• Troubleshooting critical production issues and resolving integration issues.
• Preformed Data mining for the identification of unusual data records or data errors that require further investigation.
• Defined best practices for Tableau report development.Extracted data from various sources (SQL Server, Oracle, text files and excel documents), used ETL load scripts to manipulate, concatenate and clean source data.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Extensive use of JavaScript API for viewing the reports in the web page
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.

Environment: Tableau Desktop, Tableau server, Oracle, SQL Server, SQL, PL SQL Developer, Toad, Unix, Javascript API, HTML,CSS, MS-Excel, SharePoint, Microsoft office, Jdeveloper, SQL-PLUS, C++, Visual Basic, Windows 7 and Linux.

Confidential, Kansas City, MO

Tableau Developer/ Analyst

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• 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.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateuser defined functions.
• Used ETL process to Extract, Transform and Load the data into data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: s: Tableau Server v8/V9, Tableau Desktop v9/v8, Clear quest, Oracle, Teradata

Confidential, Atlanta, GA

Sr. Tableau Developer

Responsibilities:

• Gathered requirements from end users, involved in modifying various technical & functional specifications
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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.
• Involved in new KPI generation for Scorecards.
• Installed and upgraded of Tableau server and server performance tuning for optimization.
• 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.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Published developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Environment: Tableau Desktop 8.1-8.2, Tableauserver / Administrator, SQL developer, SQL 2008, Oracle 10g, PL/SQL, T-SQL Microsoft Excel 2007,MS Access, Windows 2007 server, java 1.5 platform, Teradata, Microsoft office 2007, Business objects 4.0.

Confidential, Somerset, NJ

Tableau Consultant

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Experience with creating Worksheets and Dashboard.
• Experience with Tableau for Data Acquisition and data visualizations.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Experience with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Used parameters to make dashboards dynamic.
• Worked extensively with Date, String and Logical Functions.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Worked closely with ETL team for various Data sources issues
• Interacted and worked with ETL team for improving performance on data from multiple data sources
• Used ETL efficiently for complex joins of various scenarios
• Provided User training for the various dashboards.
• Worked with ETL team for performance improvement using custom SQLs.

Environment: Tableau 7.0, Informatica 9.1, Hyperion (Oracle), SQL, Oracle 10g, Teradata’s, Windows/UNIX

Sql / ETL Developer

Responsibilities:

• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Worked on the backend SSAS cube development which was the source data for the tableau.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Worked with DBA team for performance improvement issues.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Analysed Customer requirements and prepared design/mapping documents.
• Creating the SQL queries based on source to target mappings for Target tables.
• Worked with DBA’s for performance improvements.
• Gathered Business Requirements Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
• Worked with modeling team for source issues.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Created various Mappings by using different kinds of transformations like Source Qualifier, Expression, Join, Lookup, Filter, Rank, Sequence Generator, Stored Procedure, Router, Normalize, Transformations.
• Worked on SQL for Source overwrite queries to improve performance.
• Created multiple Mappings and Workflows.
• Worked with DBA’s on various issues like table space and table locking issues, long running query analysis and so on.

Environment: Informatica 8.6/Cognos, Oracle, Windows XP, UNIX

Confidential

SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Analyze, design, implement and test ad-hoc and standard reports.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
• Designed and developed various complex reports.
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Created roles, assigned permissions and users/groups to roles to limit the access for the users.
• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Preparedfunctional specificationsfor user requirements.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms/reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned rolesandaccess.
• CreatedTables, Indexes, Table Spaces, Views synonyms,andintegrity constraints.
• Involved in creation ofschema objects, rolesandprivileges, users.
• PreparedUser manual, Technical documentsfor the end user.
• Prepared executables for system deployment and led the release of applications following
• Experience in UNIX Environment in file transfers, job scheduling and error handling
• Maintenance and support for the system. Involved inend user training.

Environment: Oracle 10g/9i, Windows 2000, PL/SQL, TOAD