We provide IT Staff Augmentation Services!

Senior Tableau Developer/analyst Resume

SUMMARY:

  • 8+ years of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.
  • Hands on experience on Tableau Desktop versions 7/8.0/8.2, Tableau Server and Tableau Reader.
  • Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
  • Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.
  • In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
  • Mastered in different Formatting techniques, using Annotations and Mark labels.
  • Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
  • Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
  • Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
  • Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Been part in writing technical requirement documents and low level design documents.
  • Experienced in requirement gathering/analysis, design, development, testing, and production support of reporting and analysis projects.
  • Worked extensively in Informatica Power Center 8.6 & 9.1.
  • Proficient in Oracle Database and UNIX Shell Scripting.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
  • Involved in Gathering/ analysis, Design, Development, Testing and Production rollover.
  • Conversant with Software Development Life cycle and SEI-CMMI level 5 Quality Processes while executing projects

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000, Windows XP Professional, Windows NT, UNIX

Languages: C, C++, C#, SQL, PL/SQL, HTML

Databases: Oracle 8i/9i/10g/11g, SQL Server 2008/2005, DB2, Teradata.

Tools: Tableau Desktop v7/v8, Tableau Server v7/v8, Informatica Power Center 9.1.0/9.0.1 ,8.6.1,8,Cognos

Related Skills: MS Visio

PROFESSIONAL EXPERIENCE:

Client: Confidential, Redmond WA

Role: Senior Tableau Developer/Analyst

Responsibilities:

  • Understand the Requirements and Functionality of the application from specifications.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
  • Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Converted existing BO 5x reports into tableau dashboards
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Created different KPI using calculated key figures and parameters
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's 
  • Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Also involved in administration tasks such as creating and managing Sites, Setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 8.2, Business Object 5x, Amazon Redshift, Sage VIP (SQL Server), SWOP

Client: Confidential, Oakbrook IL

Role: Tableau Consultant

Responsibilities:

  • Created dashboards for analyzing POS data using Tableau 8.0.
  • Developed dashboards for POS use cases to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting and cannibalization.
  • Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
  • Extensively worked on different types of filters.
  • Expert level capability in table calculations and applying complex, compound calculations to large, complex big data sets
  • Used trend lines extensively for correlating different KPI’s for new product launches.
  • Created custom Function's (Date range, Time functions, Logical functions, and Conditional formatting functions) in the reports.
  • Scheduled extract refresh and subscriptions for weekly and monthly reports.
  • Integrated Tableau dashboards into internal web portal using Java Script API.
  • Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
  • Consistently attended meetings with the client subject matter experts to understand functional business requirements.
  • Provided user trainings on the key dashboards
  • Provided detailed documentation on the Analytical deliverables
  • Used Industry standard design templets for POS use case analysis.

Environment: Tableau Desktop 8.0, Tableau server / Administrator, SQL Server 2008, Windows/UNIX, Oracle.

Client: Confidential , Michigan

Role: Business intelligence 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

Client: Confidential

Role: ETL Developer

Responsibilities:

  • Analysed Customer requirements and prepared design/mapping documents.
  • Creating the SQL queries based on source to target mappings for Target tables.
  • 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.
  • Worked with modeling team for source issues.
  • Created multiple Mappings and Workflows.
  • Worked with DBA team for performance improvement issues.
  • Prepared technical design documents and coding specification documents.
  • Prepared unit test cases for the modified existing ETL routines.
  • Worked closely with reporting team for their reporting needs.
  • Worked with reporting team on reconciliation issues.
  • Worked with Dashboard teams for backend changes for their specific report tables to gain performance.
  • Worked with DBA’s for performance improvements.
  • Worked with DBA’s on various issues like table space and table locking issues, long running query analysis and so on.
  • Experienced in handling large volumes of data.
  • Code developed based on the business requirement
  • Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data.
  • Created Unit Test cases and captured Test log

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

Client: Confidential

Role: ETL Developer

Responsibilities:

  • Understanding existing business model and customer’s new requirements.
  • Prepare ETL technical Design Documentation and coding.
  • Used various transformations to achieve business logics.
  • Worked on transformations like Expression, Lookup, Filter, Router, Aggregator, Ranking, Normalization, Sequence Transformation were implemented to load the data from source to Target.
  • ETL performance optimization with SQL.
  • Worked with Modelers and Architects for table issues.
  • Worked on building Mappings, Mapplets.
  • Prepared detailed documentation for development, Test cases, testing different scenarios and documenting the result, working on defect fixes from System Testing & User Testing.
  • Tested ETL code in Dev, SIT & UAT environments to ensure defect free code.
  • Provided Development support for System Testing/User acceptance testing.
  • Migration workbook creation and tracking the code versions

Environment: Informatica 8.6, SQL, Oracle, Windows/UNIX

Client: Confidential

Role: ETL Developer

Responsibilities:

  • Worked on data migration from legacy systems to MST.
  • Based on Technical spec created and used multiple Transformations in Informatica like Expression, Lookup, Filter and Router.
  • Worked on SQL to get data efficiently into the system.
  • Worked on various logics in transformations.
  • Created Mappings and Workflows.
  • Prepared UTC & UTR after completion of the development and provided results to client.
  • Tested ETL code in Dev, SIT & UAT environments to ensure defect free code.
  • Provided Development support for System Testing/User acceptance testing.
  • Worked with testing team for defect fixing during various testing phases.

Environment: Informatica 8.6, SQL, Oracle, Windows/UNIX

Hire Now