We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

Addison, TX

SUMMARY:

  • Tableau Developer with around 8 years of experience in tableau data visualization, data discovery, SSIS & SSRS report development, data analysis, MxS SQL Server Developer/ ETL Developer in analysis, design & implementation
  • Strong Expertise in using Tableau software as applied to BI data analytics, reporting and dashboard projects.
  • Professional in writing Complex Formulas, Sub Reports, Summary Reports in analyzing high - volume, high-dimensionality data from varying sources.
  • Extensive Experience in various Tableau Desktop reporting features like Measures, dimensions, Folder, Hierarchies, Extract, Filters, Table Calculations, Calculated fields, Sets, Groups, Parameters, Forecasting, blending and Trend Lines.
  • Worked on various Life Cycle Models like Waterfall, Iterative and 'V' model Test Strategy, Test Plan and Traceability Matrix Documents.
  • Extensive knowledge in various reporting objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
  • Expert in Business Intelligence Applications using CognosTools such asCognos10.1 & 8.x BI(Report Studio, Analysis Studio, Query studio).
  • Expertise in design & development of various reports, dashboards using various Tableau Visualizations like Dual Axis, Bar Graphs, Box & Whiskers Plot, KPI Scorecards, Scatter Plots, Pie-Charts, Heat Maps, Gantt Charts, Bubble Charts, Tree Maps, Funnel Charts, Box-Plots, Waterfall Charts, Geo-Spatial Analysis and other making use of actions, other local and global filters according to business requirements.
  • Worked extensively on data blending, and different table calculations for different scorecards, performance tuning Tableau Reports, published dashboards on Tableau Public
  • Proficient in Oracle 11g, SSIS, SSRS MS SQL Server on Windows platforms. Extensive experience in Database activities like Database Modeling, Data Mapping and Data Analysis. Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.
  • Proficient in preparing Presentations, Graphs, Pivot Tables using Macros and VLOOKUP, MATCH Functions in returning cell/column values using Microsoft Excel and PowerPoint,
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in SSRS database.
  • Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
  • Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
  • Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
  • Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
  • Developed effective and interactive Dashboards using Parameters and Actions
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
  • Effective Ability to create Custom Tableau reports using SSRS and advanced Tableau mapping.

TECHNICAL SKILLS:

BI/Reporting tools: Tableau Desktop 9.X, 8.X, 7.0, 6.0, Tableau Server 9.X, 8.XBusiness Objects XIR3/XIR2/6.X/5.X,Crystal Reports, Altyrex

Relational Databases: Apache Hive, Teradata Oracle MS SQL Server, Microsoft SQL server

Languages: HTML, Java Script, PL/SQL, SQL, Tabcmd

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer

Confidential, Addison, TX

Responsibilities:

  • Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.
  • Performed ETL activities using SSIS, SSRS, Data Integrator and Data Services, by extracting data from various Sources.
  • Wrote SSRS Macros and used various analytic functions.
  • Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
  • Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.
  • Created Dashboards to present critical company data in a single report.
  • Created list reports & cross tab reports using cognos 10.1
  • Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to
  • SSRS
  • Create Schedules and extract the data into Tableau Data Engine.
  • Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server
  • Worked closely with WEBI Reporting team on the requirements.
  • Created Attribute, Analytical and Calculated views as per the requirement needs.
  • Created procedures in HANA Database
  • Developed Jobs in SAP Business Objects Data services which do the ETL between Developed SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
  • Knowledge of monitoring and debugging apps in the Cloudera environment. Understanding of how Hadoop works, tracking errors and performance issues, Map Reduce troubleshooting, performance tuning
  • Manage the Tableau solution architecture, administration and actively manage the performance and usability. Align/standardize team members on best practices around Tableau driven implementations.
  • Implement action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
  • Create 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.
  • Worked on Oracle E-Business Suite(EBS) Applications
  • Define best practices for Tableau report development.
  • Administer user, user groups, and scheduled instances for reports in Tableau.
  • Execute and tested required queries and reports before publishing.
  • Develop parameter and dimension based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
  • Execute and tested required queries and reports before publishing dashboards.
  • Provide support once the dashboards were published if there were any data changes, system changes, or requirement changes.
  • Extensively work on Tableau Desktop, by creating Complex reports & Dashboards.
  • Create Tableau scorecards, dashboards, Heat maps using show me functionality
  • Scheduling the monthly/weekly/daily reports to run automatically.
  • Develop implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Create procedures to ensure the quality, usability and accuracy of reports.

Environment: Tableau Desktop (Version 8.1.2 - Version 9.0.2), SQL Server, Microsoft Visual Studio, SSRS, TeraData, Microsoft Visual Basic, Oracle, SQL Server Management Studio, MS Excel, MySQL, Crystal Reports 2008

Tableau Developer

Confidential, Detroit, MI

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-axis bar chart with multiple measures.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
  • Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Salesforce, Microsoft SQL Server and Microsoft Analysis Services.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Created incremental refreshes for data sources on Tableau server.
  • Monitored 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. worked on programming interface (API) to directly create a Tableau Data Extract (TDE) file, Which works with Python.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Wrote Teradata macros and used in various analytical functions.
  • Manage report analysis, requirement collection, communication with clients and providing delivery estimates.
  • Support post production system and resolve/fix bugs or defects.
  • Extensively used Adadmin 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 SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, Apteryx, MS SQL Server 2008R2, UNIX, LINUX, Hadoop, salesforce.

Tableau Developer

Confidential, Peoria, IL

Responsibilities:

  • Business requirement analysis and providing LOE for Tableau reports and dashboards.
  • Created Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI).
  • Leveraged Tableau built in graphical capabilities to create Bar charts, Treemaps, Geomaps, Area charts.
  • Used Tableau to create visual interactive dashboards, workbooks and stories for better decision making.
  • Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
  • Created detailed Functional Specifications Documents, including data samples, use cases, key project assumptions, report samples, data flows and data models
  • Used Sets, Bins, Parameters, Aggregate Functions, Filters, Action in Tableau. Used Tableau Desktop to analyze and obtain insights into large data sets.
  • Combine the visualizations into Interactive Dashboards, Stories and publish them to the web using in Tableau Desktop 9.1
  • Publishing the Worksheets, Dashboards and Stories on Tableau server to share it with multiple BU's.
  • Develop complex reports on Weekly, Monthly wire line scorecards, Ticket summary, Region level.
  • Created visualization reports on Tableau Desktop9.1 on existing data model build in DW.
  • Created visually compelling, actionable interactive worksheets and dashboards for the clients to analyze various KPIs.

Environment: Tableau 7.0, Informatica 9.1, SQL Server 2012, Teradata, Windows

Tableau Developer

Confidential, Boston, MA

Responsibilities:

  • Involved in creating Static and Interactive dashboards by extracting data from different sources.
  • Created dashboard using parameters, sets, groups and calculations.
  • Extensively used dashboard actions (filter, highlight and URL) to additional different granularity in the dashboard.
  • 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.
  • Developed dashboards with the data security to restrict data to the different level of users based on their roles.
  • Created calculated fields, mapping and hierarchies, groups, sets and LOD expressions.
  • Created dual-axis charts with multiple measures to provide more meaningful insights to business.
  • Performed end-to-end Data Analysis and ensured the data quality gaps are identified and reported to management.
  • Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
  • Use SSIS to extract, transform and load data directly from different source systems that includes flat files, Excel, Oracle and SQL Server.
  • Work on generating various dashboards using different data sources such as Oracle, Microsoft SQL Server and Microsoft Analysis Services.
  • Extensively used data blending in Tableau for connecting different databases.
  • 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 server.
  • Worked with user groups in creating and modifying dashboards or worksheets in desktop and server.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Documented solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop/Server 8.1/8.4/9.1, Excel, SQL Server 2008/2012 and Oracle 10g.

Tableau Developer

Confidential, San Antonio, TX

Responsibilities:

  • Participated in the daily stand up Scrum Agile meetings for reporting the day-to-day developments of the work done.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Effectively used data blending feature in Tableau.
  • Manipulating, cleansing & processing data using Excel, Access and SQL.
  • Worked on various kinds of data filtering as required in the dashboards/reports like quick filters, context filters, filtering measures, continuous and discrete filters.
  • Analysed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
  • Ensured high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
  • Developed and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
  • Created users, groups, projects, Data connections, settings as a Tableau administrator.
  • Created dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using SQL Developer to provide definition, structure and to maintain data efficiently

Environment: Tableau 8.1/8.0, Tableau Server, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7, SQL Developer.

Tableau/Cognos Developer

Confidential, Chicago, IL

Responsibilities:

  • Worked extensively with Business groups and developed technical specifications for tableau dashboards.
  • Created different visualizations in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Worked on estimates of report development and provided the same to client.
  • Designed Framework manager metadata for reporting and adhoc reporting.
  • Implemented star schema grouping for multi Fact, Conformed dimension.
  • Used advanced functionalities like parameter map, macros to create dynamic reports.
  • Designed best practices for report development and also documented steps for performance running of cognos reports.
  • Requirement gathering and design and review of cognos Power cube.
  • Setting up oracle 11g data source and configuring oracle client for client Framework manager.
  • User training and presentation of Framework manager project and report studio design techniques.
  • Scheduled reports using cognos connection and through cognos triggers.
  • Production support activities including handling issues, troubleshooting them and report to management.

Environment: Tableau Desktop 7.1, Cognos BI 8.4 (Framework Manager, Report Studio, Cognos Analysis Studio, Cognos Power Play Transformer), IBM DB2.

Sr Software Engineer

Confidential

Responsibilities:

  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS.
  • Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
  • Worked on a package Migration wizard in SQL Server 2005 to migrate DTS Packages to SSIS, SSIS Package Configuration,
  • Identified and worked with Parameters for parameterized reports in SSRS 2005.
  • Developed Various Complex Matrix, Sub report and Charts.
  • Involved in building a strategy for star schema with fact and dimension Tables.
  • Used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers
  • Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table.

Environment: MS SQL 2000/2005, Windows NT/2000/XP, SSIS, SSRS, MS Access, MS Excel

Hire Now