SUMMARY

• Over 8+ years of Experience in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Expert in creating visualizations like Stack Bar, Bar Graphs, scattered plots, Bars, Bump, Funnel, Lines, Bubble and Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Box plots, Tree maps, Word clouds and Highlight tables, Pareto Charts, Bollinger Bands and Waterfall charts inTableau.
• Involved in Tableau Server Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc., in a multi - server and multi-tier environment.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts.
• In Depth Experience in analysis, design and development of reports using Tableau, Oracle SQL, PL/SQL and Data analysis
• Experience in developing interactive reports and dashboards by making use of LOD expressions, actions, local and global filters, calculations, calculated fields, groups, sets, hierarchies and parameters Tableau.
• Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
• Extensive experience in Software Development Lifecycle (SDLC) managing project scope, requirement definition, resource management, change management, analysis, managing work schedules, project status reporting, project coordination and conflict resolution.
• Played key role in agile team includingoverseeing job sprints on SCRUMbased projects.
• Participated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
• Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications.
• Proficient in conducting Gap Analysis, organizing Joint Application developments (JAD) sessions, Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Hands on experience in publishing and sharing workbooks, data sources with user filter totableauserver, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts.
• Proficient in performance optimization and using best practices for developing reporting solutions in Tableau.
• Strong understanding of Data warehouse concepts, OLTP, OLAP, ETL, Star Schema, Snowflake, data modelling and SQL.
• Administered user, user groups and scheduled instances for reports in Tableau.
• Strong experience in Business and Data Analysis, Data Profiling, Data Cleansing, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star &Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Have strong experience in Business Intelligence, Data Warehousing and Data Mining applications in Automobile, Health Care and Financial industries.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Impact Analysis and providing corrective actions to meet business requirements.

TECHNICAL SKILLS

Reporting Tools: Tableau Suite of Tools 10.4, 9.0, 8.2, 8.1, 8.0, 7, 6, 5.1 includes Desktop, Server, Online and Public and Administration of Tableau Server.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema modeling, Snowflake modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWI, Oracle Designer and MS Visio.

Database: Teradata14.10/14/13, Oracle-11/10g/9i, MS SQL Server- 2012/2008/2005, DB2, MS Access, MS Excel.

SQL Programming: SQL, TSQL, PL/SQL.

Tools: & Utilities: Teradata SQL Assistant, SQL Navigator, SQL Developer, SQL Loader, WS FTP, Meta Manager, TOAD, HP Quality Center 9.2, CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes.

Domain Knowledge: Pharmaceutical, Automobile, Banking.

PROFESSIONAL EXPERIENCE

Confidential, Bolingbrook, IL

Sr. Tableau Developer

Responsibilities:

• Designed and develop innovative dashboard and reports using Tableau.
• Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes, etc.) using Tableau.
• Develop load scripts for extracting, transforming and loading data into Tableau applications.
• Transferring Crystal Reports to Tableau.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.
• Involved in project planning, scheduling for database module with project managers.
• Created new Data source and replaced with existed Data source.
• Created Schedules and Extracted the data into Tableau Data Engine.
• 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.
• 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.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
• SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.

Environment: Tableau 10.4, TSQL, Microsoft SQL Server, SSRS, Crystal Reports.

Confidential, Stanford, CT

Sr. Tableau Developer

Responsibilities:

• Interacted with Business users, Business Analysts to understand reporting requirements and transform them into technical specifications.
• Involved in the development of new TableauDashboards and publishing them to Tableau Server.
• Effectively involved in the data migration from Teradata server to MySQL Server of other reporting Systems.
• Effectively involved in the administration of TableauServer.
• Involved in the upgrade of Tableau server to its new version 9.1
• Build many Tableau reports using Bar Char, side-by-side bars, stacked bars, maps, tree map, pie charts, line charts, interactive reports using Tableau Desktop and Dashboard.
• Developed Tableau workbooks using DataBlending feature which involves the integration of multiple data sources like relational database and flat files.
• Involved in the different Dashboard actions like URL Filters, Action Filter and User Filters.
• Performed different calculations like Quick table calculations, Date Calculations, Aggregate Calculations, String and Number Calculations.
• Build Tableau Dashboards on different sources like Oracle Database, Flat Files (excel, csv) and OLAP database.
• Created Tableau data extracts (. tde) files to import dashboard users from csv file to Tableau Server using Extract API.
• Involved in the creation of Users and User Groups in the Tableau server.
• Worked on Tableau Command line tools tabadmin for Configuration settings in tableau Server and tabcmd for users, groups creation.
• Effectively involved in the maintenance of DataServer, metadata management, creating shared Data sources and publishing them to Tableau Server.
• Involved in creating Project workbench and published the reports as Object Package to BI Platform.
• Created Teradata External loader connections such as MLoad, Upsert,Update, and Fastload while loading data into the target tables in Teradata Database.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTILOAD andFASTLOAD.
• Automate Teradata SQL Jobs in LINUX using Shell scripting.
• Involved in Performance tuning, including collecting statistics, analyzing Explain Plan& determining which tables needed statistics.
• Experience in scripting using Python.

Environment: Tableau 9.1,MongoDB 3.0, Teradata,Python, MySQL Server 6.2, Oracle 11g, Oracle PL/SQL Developer, Python 2.7.

Confidential, MN

Sr.Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0, 8.2and 8.1.
• Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements.
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 9.0, 8.1, 8.2, Teradata 13, Oracle 10g, Crystal Reports 2008, MS Office Suite.

Confidential, Olympia, WA

Tableau Developer

Responsibilities:

• Understand Requirement, Analyzing Systems and Source Databases.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Handled small development project work which pulls data from MS Excel files, MySQL and Oracle DB and translates to usable metrics which are highly visible to the client leadership.
• Created basic calculations including string manipulation, basic arithmetic calculations, Custom aggregations and ratios, date math, logic statements and quick table calculations.
• Representing data using the visualizations such using Charts.
• Used Trend Lines, Reference Lines and statistical techniques to describe the data.
• Used Measure name and Measure Value fields to create visualizations with multiple Measures and dimensions.
• Responsible for dashboard design, look and feel and development.
• Used parameters and input controls to give users control over certain values.

Environment: Windows, Tableau Desktop 8.3, Tableau Server, MS Office Suite, SQL Server, MS Excel.

Confidential

Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts& End Users to gather business requirements.
• Analyzed requirements for various reports, dashboards, and scorecards.
• Effectively used data blending feature in Tableau.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast data.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree maps, Pie/Bar charts, Circle views, Line/Area charts, Scatter plots and Bullet graphs.
• Created prompts, customized calculations, conditions and filters (Local, Global) for various analytical reports and dashboards.
• Created and modified interactive dashboards and developed guided navigation links within interactive dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and dashboards.
• Published the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and data marts.

Environment: Tableau Desktop/ Server, MS ProjectTeradata, Teradata SQL Assistant, SQL, PL/SQL, SQL Developer, Informatica Power Center, SQL Server, Control-M.

Confidential

Junior Tableau Developer

Responsibilities:

• Involved in gathering the requirements and analyzing the requirements and interact with the client to find the proper information.
• Responsible for Preparing the Report Design specifications based on the User's requirement.
• Extracted data from various sources and performed data blending.
• Created different type of charts.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Applied various types filters like Data source filters, Quick filters and Context Filters, Cascade Filters and Global Filters.
• Created table calculations, calculated fields and parameters.
• Published sheets and dashboards on server.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Created Stories using Tableau as part of report presentations to Business.

Environment: Windows, Tableau Desktop 8.3, Tableau Server, MS Office Suite, SQL Server, MS Excel.