We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

IL

PROFESSIONAL SUMMARY:

  • 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
  • Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10,9,8,7
  • Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 4.x/ XIR2/ Crystal Reports 2011/2013 and Web Intelligence 4.x
  • Skilled in working on enterprise data sources like Teradata, SQL, SAS, HANA, Oracle, SSAS, Hadoop, Salesforce
  • Experience in ETL tool Informatica Power Center, involved in data mappings, identified and resolved performance issues at levels like sources, targets, mappings and sessions
  • Expertise in dealing with OLAP and Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors
  • Proficient in Agile and Scrum methodologies
  • Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML)
  • Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup and drivers setup activities
  • Skilled Tableau user with knack for identifying clever workarounds; able to perform both creative and complex calculations (Table calculations, LODs, etc.)
  • Provided Production support to users and wrote custom SQL and also supported international teams
  • Good understanding on statistical and data analysis languages like R
  • Built interactive dashboard using techniques like visual best practices provided by Tableau
  • Quick learner and good performer both in team and independent job environments

TECHNICAL PROFICIENCY:

Data Modeling Tools: Star and Snowflake Schema

BI Tools: Tableau Desktop, Tableau Server, Business Objects Platform, Information Design Tool (Universe Designer), Web Intelligence, Crystal Reports, SAP Dashboards

ETL Tools: Informatica Power Center, Alteryx

Databases: MS SQL Server 2012/2008R2/2008/SYBASE, MYSQL, Oracle 10g/11g, Teradata, AWS, SSAS, SAS, Hadoop

Other: PL/SQL, SQL, Rest API, Excel, Access, HTML, MDX Scripting, Tab Cmd

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. Tableau Developer

Responsibilities:

  • Designed, developed, tested, and maintained Tableau dashboards based on user requirements
  • Experienced in Tableau Site Admin role, good at managing permissions, adding users and also restricting data to users at data/report level, reviewing performance of the dashboards
  • Managed offshore resources to support Asia Pacific and Europe users
  • Worked on multiple projects by connecting to multiple data sources like SQL Server, Excel files, Salesforce, SAP Ariba and AWS
  • Worked on blending the data using different data sources like SQL Server, AWS, Salesforce, CSV files
  • Used charts like Tree Maps, Heat Maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms.
  • Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE and also set URL to the customized team view
  • Created ad - hoc reports as requested and created customized calculations depending on the requirements
  • Worked with User Filters to restrict data at report level and provided Row Security to data
  • Strong Dashboard design experience and passionate practitioner of effective data visualization, familiarity with best practices around visualization and design
  • Utilized all kinds of filters and Sheet swapping/ Sheet selector to view multiple sheets in a single dashboard which increases performance of the dashboard
  • Developed donut charts for analyzing sales planning data
  • Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks and also created offline cubes
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measures and YTD, WoW, Level of Detail calculations and many more calculations
  • Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines
  • Experienced in Production support to users and writing custom SQL
  • Working with Birch Street source system to create 3rd party groups dashboards
  • Worked with Alteryx support project to automate the server process like refreshing the data and scheduling the data
  • Pull data from SAP Ariba system and use the data to develop reports
  • Published and shared views on Tableau server
  • Scheduled extract refresh and subscriptions
  • Experience in migrating from one site to another site
  • 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
  • Using TAB CMD function to auto generate pdf’s with associate filters

Environment: Tableau Desktop 10.x/9.x, Tableau Server 10/9.x, Tableau Public, Microsoft SQL Server 2016/2012, AWS, Alteryx, Salesforce, SAP Ariba, Birch Street, Excel, Windows 7/8/10.

Confidential, WI

Tableau Developer

Responsibilities:

  • Interacted with business users, gathered requirements, analyze the data, designed mockups and developed dashboards in Tableau
  • Created charts like Funnel Chart, Panel Chart, Line Chart, Pie Chart, Maps, Plots, Filters, Sets, Parameters, Grouping, LOD’S
  • Created different complex calculations and used them to get highly visualized dashboard
  • Worked on blending the data using different data sources like SAS, SQL Server, Hadoop Hive
  • Provided reporting solutions for OLTP and OLAP systems
  • Responsible for SAS programming for producing Reports, Summaries, Listings, Graphs for statistical analysis and reporting
  • Developed Tableau dashboards on top of MSAS cube data by writing different MDX Scripts
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views and also worked on Level of Detail Expressions
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users
  • Utilized all kinds of filters and Sheet swapping/ Sheet selector to view multiple sheets in a single dashboard which increases performance of the dashboard
  • Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks and also created offline cubes
  • Experience in working with multiple projects and also worked as production support
  • Worked on Tableau Server in providing permissions to Users, Groups and also worked on User Filter in restricting access in data level
  • Used Filter actions function in developing the Scatter plots with Grid view by using specific layouts
  • Worked on complex calculations and wrote custom SQL queries for creating dashboards
  • Utilized all the functionalities to increase performance of the dashboards by recording performance and creating context filters, reducing number of marks, avoiding Grid Views, reducing number of sheets for each dashboard

Environment: Tableau 9.x, Tableau server 9.x, MS Excel, SQL Server 2012, Hadoop Hive, MSAS

Confidential

Tableau Developer

Responsibilities:

  • Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
  • 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.
  • Developed customized calculations when required.
  • Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
  • Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0.
  • Interacted and worked with ETL team for improving performance on data from multiple data source
  • 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 technical specification documents related to Tableau design and architecture.
  • Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments
  • Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc
  • Setup hierarchies in the Universe for providing drill down options in the reporting environment
  • Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
  • Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects

Environment: Tableau 8/7, Tableau server 8/7, Crystal Reports, Web Intelligence 4.x/3.1, MS Excel, SQL Server 2008 R2, Oracle

Confidential

Oracle DBA

Responsibilities:

  • Installed and configured Oracle 11g database on Solaris.
  • Oracle Databases upgraded from Oracle 11.2.0.3 to 11.2.0.4
  • Applying Oracle interim CPU patches
  • Oracle test database refreshing on ad-hoc basis
  • Resolved the Oracle database instance and application SQL performance issues using tools AWR, ASH, SQL Trace and explain plan
  • Creating and follow up Oracle SRs for database issues
  • Refreshing the test databases and schemas
  • Oracle database backups using backtrack tool
  • Refreshing the test databases and schemas using data pump and RMAN backup
  • Resolved the database performance related issues.
  • Resolved the Oracle database instance and application SQL performance issues using tools AWR, ASH, SQL Trace and explain plan. Creating and follow up Oracle SRs for database issues

Hire Now