We provide IT Staff Augmentation Services!

Tableau Developer Resume

Orange County, CA

PROFESSIONAL SUMMARY:

  • 7+ years of extensive IT Experience as a Data Analyst, Business Systems Analyst in Data Warehousing and Business Intelligence applications.
  • 4+ years of experience in working with Tableau Desktop, Tableau Server, Alteryx, and Tableau Reader in various versions of Tableau 10x/9x/8x/7x.
  • Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
  • Experience in facilitating Joint Application Development (JAD) sessions with Business Analysts, IT Groups and Conflict Management with Project team members.
  • In depth understanding of the as - Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.,
  • Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
  • Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like calculated fields, LOD (Level of Detail), Adhoc Calculations, etc.
  • Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Teradata, Oracle, Informatica, MicroStrategy, Unix technologies.
  • Experience in integrating Tableau into Front-End Web Application using JavaScript API to call parameters and filters as well as individual sheets.
  • Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
  • Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
  • Working knowledge of performance improvement measures including aggregate tables, Indexes and explain plan.
  • Experience in writing complex SQL queries to perform End-to-End Data validations and support Ad-hoc business requests.
  • Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 10x, 9x, 8x, 7x, Tableau Server, SAP BOCrystal Reports 2008 XI, Cognos

ETL tools: SQL Server Integration Services (SSIS), AlteryxInformatica Power Center 7/8

Databases: Teradata, Oracle, Server 2000/2005/2008/2008 R2/2012, DB/400MS Access, Oracle 11g/10g, Excel Flat files, Sybase, Hadoop, DB2.

SDLC tools: Perforce, Team foundation Server (TFS), HP Quality center

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio, Visible Analyst

Operating Systems: Windows Server 2000/2003/2008 , Windows 98/2000/XP/VISTA/7 UNIX, Linux, Solaris, VLOOKUP, Mac

Languages: C, C++, T-SQL, XML, UNIX, Oracle, Java, Python, ABAP, VB, PL/SQL

Web Scripting Languages: HTML, DHTML, VB Script

Web Tools: MS: Front Page, Dream Weaver

Design/Version Control: UML, Rational rose, Jira

PROFESSIONAL EXPERIENCE:

Confidential, Orange County, CA

Tableau Developer

Responsibilities:

  • Tableau license procurement and reporting across organization (United States, Asia Pacific, Europe, Middle East and Africa).
  • Data Analysis (Tableau 10.x)
  • Interacting with business users to identify and build out visualizations .
  • Build out reporting and KPI’s for executive team and multiple functional areas.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
  • Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
  • Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
  • Created various interactive reports/dashboards using tableau desktop.
  • Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management. Created different Calculation fields according to requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
  • Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report. Experienced on Date functions creating, executing test Cases and documenting the Test Results.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau 10x (Desktop/Online) Informatica, MS Access, MS SQL Server 2012, Excel.

Confidential, Eden Prairie, MN

Sr. Tableau Developer

Responsibilities:

  • Created worksheets reports and converted into interactive dashboards by using Tableau Desktop and provided to Business Users, Project Managers and End Users.
  • Experienced in designing and developing multiple analytical reports from multiple data sources by using Alteryx data blending on a single worksheet in Tableau Desktop.
  • Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
  • Reviewed business requirements and analyzed data from various sources like Index, VLOOKUP, Excel/ SQL Server for design, development, testing and analyze the projects within Tableau Desktop.
  • Created various interactive reports/dashboards using tableau desktop.
  • Expertise in Creating Heat Maps showing registers service subscribers by using parameters, colors that were broken into regions allowing business users to make better decisions and improve data performance.
  • Used advance features of Tableau like to link data from various sources merged on one dashboard and to filter data in multiple views at once.
  • Created different Calculation fields according to requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
  • To estimate profit generation by creating calculated fields and calculation across the table on the data from Micro SQL Server and MS Excel.
  • Experienced in writing SQL queries to extract data from databases and connecting live/dynamic and static datasets to tableau desktop.
  • Experienced on creating, executing test Cases and documenting the Test Results.
  • Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data accurately.

Environment: Tableau 10x/9x (Desktop/ Server), Oracle11g, Informatica, MS Access, MS SQL Server 2012,Index, Cognos, Hadoop, Teradata, MS Visio, Alteryx

Confidential, Bloomfield, CT

Sr. Tableau Developer

Responsibilities:

  • Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
  • Hands-on experience in analysing the data and writing Custom SQL queries for better performance, joining the tables and selecting the required data to run the reports.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Alteryx in Tableau Server.
  • Developed Tableau workbooks from multiple data sources using data blending.
  • Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
  • Responsible for creating dashboards using bars, stacked bars, pie charts, scattered plots, line charts, Gantt charts, and maps.
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyse data in different perspectives.
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Effectively used data blending feature in Alteryx to combine the data from different sources like SAP Lynx, Vision etc. into a single report.
  • Used advanced Excel functions to generate spreadsheets and pivot tables.
  • Created and maintained issue log where business users enter their feedback by working on dashboard in test environment.

Environment: Tableau Desktop 9x, Tableau Server, SQL Assistant, SAP Lynx, SharePoint, Microsoft SQL Server, Terada, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Alteryx Designer, MS Access

Confidential, Erie, PA

Tableau Developer

Responsibilities:

  • Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
  • Created different views in workbook to visually analyze the data.
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
  • Gathered user requirements analyzed and designed software solution based on the requirements.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Created many Dashboard reports for company's decision making purpose and made them Key Performance Indicators (KPI).
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Restricted data for particular users using Row level security and User filters.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Provided 24/7 production support for Tableau users.

Environment: Tableau Desktop 8x, 7x, Tableau Server, SQL Server 2008/2008 R2, Alteryx,SharePoint, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Cognos.

Confidential

SQL Developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures, packages and the necessary insight into the data.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys
  • Created PL/SQL ,Index stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX ,Vlookup scripts to download and manipulate files.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, PL/SQL, Index,Shell Scripts, ETL,VLOOKUP, UNIX, Teradata, Software Development Life Cycle - Agile, Tableau

Hire Now