We provide IT Staff Augmentation Services!

Tableau Developer Resume

2.00 Rating

Houston-tX

SUMMARY

  • 7+ years of experience in IT Industry
  • 3+ years of experience in Tableau (9.x, 8.x) and Informatica
  • 4 years of experience in SQL Development
  • Data Visualization and Analysis using Tableau to:
  • Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
  • Define specification, design and build of Tableau Desktop reports and dashboards
  • Ability to drive insight by designing visualizations with logical and meaningful data flow and ability to see patterns.
  • End to end experience in Installation and configuration, designing and deploying data visualizations using Tableau.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Expertise in creating databases, schema objects, optimizing SQL statements.
  • Extensive experience in Data Analysis, Reporting, ETL, Data Modeling, Maintenance, Testing and Documentation.
  • Experience in analysis, design, development using Oracle, PL/SQL, SQL, Tableau and Informatica.
  • Expertise in creating databases, schema objects, optimizing SQL statements.
  • Extensive experience with SQL Server in constructing tables, views, triggers, normalization, indexes, functions, stored procedures, user profiles, relational database models.
  • Business intelligence project work Expert with SQL and PL/SQL Experienced with SQL-Server databases.
  • Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables, Star Schema and Snowflake Schema modeling.
  • Good understanding in database and data warehousing concepts (OLTP and OLAP)
  • Familiar with entire software development life cycle (SDLC) and various project methodologies such as Agile and Scrum Methodology.
  • Strong team member with good communication and analytical skills.
  • Excellent problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

BI & ETL Tools: Tableau 8/9, Informatica PowerCenter 6.1, SSIS, SAP BW 3.0, SAP CRM

Databases: Oracle 11g/10g/8i, MS SQL Server 2005, MS Access, DTS, Flat Files

Database Tools: SQL Developer, Toad

Programming Languages: HTML/HTML5, CSS/ CSS-3, PL/SQL, T-SQL, XML, UNIX, DBMS

Operating System: Windows 2000, Linux

Modeling & Other Tools: MS-Office, Putty, MS Visio, Clear Case, Rational Rose

Methodologies: SDLC, Scrum, E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, Houston-TX

Tableau Developer

Responsibilities:

  • Involved in generating proper data in excel for Tableau Dashboard.
  • Extracts data from multiple database to create Tableau Dashboards.
  • Involved in installation and patch up gradation of application on servers.
  • Responsible for efficient timely backups, project, groups’ creation.
  • Scheduled for auto refresh of dashboards on the application server.
  • Skillfully Used Link Tables utility to update Access table to reflect the Excel changes.
  • Skillful at creating multi-level hierarchy in Tableau Dashboard.
  • Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
  • Recommended Dashboards per Tableau visualization features.
  • Efficient at using Parameter in calculation field to give flexibility to end user.
  • Created global filter for the dashboard that uses different data source.
  • Created different kinds of actions to make the worksheet invisible while there is no selection.
  • Skillfully created different kinds of actions for navigation and drill down.
  • Created custom color pallet, custom shapes to use in dashboard.
  • Extensive use of Marks, Filters and Pages, Add Reference line, Calculation Fields to create complex Dashboards.

Environment: Tableau 9.x, Windows 7 SP1, Microsoft Excel 2010, Microsoft Access 2010, SAP BW 3.0, Oracle 10g,SQL Server, SAP CRM

Confidential, Cleveland, OH

Tableau Developer/ Data Analyst

Responsibilities:

  • Interacted with business user group for domain requirements gathering.
  • Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
  • Involved in defining the whole project life cycle, following agile methodology. Analyse business requirements and segregated them into high level and low level
  • Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Interact professionally with diverse group of professionals in the organization including managers and executives.
  • Developed Standard Operating Procedures (SOP) for Monitoring.
  • Extensively used data blending, embed functionalities in Tableau.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • 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 Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
  • Gathered user requirements, analysed and designed software solution based on the requirements.
  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Involved in creating 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 T-SQL to provide definition, structure and to maintain data efficiently.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment: Tableau Desktop/Server 8.x, SQL Server 2008, HPQC, Oracle 11g, Business objects, SQL, PL/SQL, T-SQL, Microsoft office 2007.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

  • Understood the source systems and collected requirements from business users.
  • Worked with analysts and data source systems experts to map requirements to ETL code.
  • Analyzed the source data coming from different sources (Oracle, Flat files).
  • Created mappings for cleansing, transforming and loading data into warehouse.
  • Used various transformations like Source Qualifier, Expressions, Aggregator, Update Strategy, Sequence Generator, Router and Lookups.
  • Involved in writing PL/SQL stored procedures and functions.
  • Created Mapplets to facilitate ease and reuse of common mapping logic.
  • Created sessions for mappings and utilized workflow manager & monitor to create, schedule and monitor workflows.
  • Involved in Unit Testing for Created mappings.
  • Involved in code review of Informatica mappings and sessions.
  • Worked with UNIX shell scripts to run Informatica workflows.
  • Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.

Environment: Informatica PowerCenter 6.1, Oracle 8i, PL/SQL, Toad, Flat files, UNIX,MS Visio, Control M and Windows 2000.

Confidential

MS SQL Server Developer/ DBA

Responsibilities:

  • Database Administrator for Development, Test and Production servers with MS SQL Server 2005 on Windows 2000.
  • Installed, administered and secured SQL Server 2005 on Server and Clients.
  • Designed and implemented logical and physical data models using Visio and Erwin.
  • Created database objects like tables, views, indexes etc.
  • Created and modified stored-procedures, triggers, cursors.
  • Wrote T-SQL for the retrieval of the data.
  • Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
  • Checked Performance Tuning, Indexing, Query Optimization.
  • Generated reports using Microsoft Reporting Services and documented SQL Server architecture and overall system network diagrams using Visio.
  • Monitored Database using system tools.

Environment: Windows 2000, MS SQL Server2005, DTS, XML, Visio Enterprise, MS SQL reporting Services.

Confidential

SQL Developer

Responsibilities:

  • Understanding the business process/requirement and translate them into technical requirements.
  • Created Database Objects like Tables, Views, Synonyms and Sequences.
  • Extensively used of PL/SQL Stored Procedures, Functions, Triggers and Packages.
  • Tested the entire application in testing environment and exported to Production.
  • Done the documentation and provided on-site production support.

Environment: Oracle, SQL, PL/SQL, Windows

Confidential

SQL Developer

Responsibilities:

  • Creating and altering Tables, Views.
  • Creating Primary Keys in the tables at the design time
  • Finding appropriate solutions for those requirements in an easy way and preparing low level technical approach documents for them.
  • Handled Maintenance, Development support activities.
  • Documenting the Database activities and involved in System Documentation.

Environment: Oracle, Windows, Clear Case

We'd love your feedback!