We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

Cleveland, OH

PROFESSIONAL SUMMARY:

  • Around 8 Years of IT experience in Business Intelligence, Data warehousing, Data architecture and Data Modeling. Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics
  • Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modeling and Waterfall model.
  • Experienced in Tableau Desktop 9x/ 10/10.1/10.2/10.3/10.4/10.5
  • Involved in admin activities like publishing, creation of subscriptions, granting access to users, managing extracts and installations.
  • Ability to analyze and dissect user requirements and build front - end BI applications according to specifications.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization a nd other making use of actions, other local and global filters according to the end user requirement.
  • 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 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 ownership, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
  • Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL Server 2005/2008 R2/2014/2016 Reporting Services (SSRS), SQL Server 2005/2008 R2/2014/2016 Integration Services (SSIS) and in SQL Server 2005/2008 R2/2014/2016 Analysis Services (SSAS) in Business Intelligence (BI).
  • 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.
  • 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.

TECHNICAL SKILLS:

ETL/BI Reporting Tools: Tableau Suite of Tools which includes Desktop, Server, online and Public. Informatica Power Center Designer

Databases: MS SQL Server 2008/2008R2/2012, MS Access, Oracle 11g/10g/9i/ using PL*SQL Developer tool.

Programming Languages: C, C++, ASP.Net, Basic Java, HTML, SQL, PL/SQL

Computer Skills: MS Office: Excel, Word, Access, Outlook, Publisher, PowerPoint

Operating Systems: UNIX, Windows ME /2007/2010, Sun Solaris 2.x / 7 / 8.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. Tableau Developer

Responsibilities:

  • Created Interactive Dashboards with Context filters, Quick filters, Parameters and Actions to handle views more efficiently.
  • Gather functional and technical requirements from clients and implementing them in Tableau.
  • Use informatica to pull data from the data warehouse and populate them across the stages staging, integration and distribution.
  • Hook up Tableau reports to the distribution tables from informatica.
  • Gathered requirements from Traders, PM’s and implemented them in a way to help them in the investment process.
  • Responsible for accessing disparate sources of production data and integrated these sources of information into common and interactive platform through Tableau.
  • Designed dashboard visualization tailored to customer needs and ensuring flawless integration within the reporting framework.
  • Performed analysis to build Tableau extract data sources leveraging existing data mart.
  • Used live connection Oracle database schemas to provide near real-time data.
  • Migrated Tableau Dashboard from version 9.3 to 10.3.2 and adding users to the AD group.
  • Technical expertise in identification of solutions meeting complex business needs that facilitates automation and drives self-service.
  • Created Interactive Dashboards with Context filters, Quick filters, Parameters and Actions to handle views more efficiently.
  • Created Dual axis charts, Stacked bar, Histograms and Line charts for time series.
  • Used Box plot to show the distribution of outliers which aren’t performing well.
  • Did Data validation with backend database once the dashboard is created.

Environment: Tableau Desktop 9.3.x/10.3.x,10.4,10.5, Informatica 10.x, Tableau Reader 10.3.x, Rapid SQL, PL/SQL, Redshift, Microsoft Excel 2010, Microsoft office 2010.

Confidential, San diego, CA

Sr. Tableau developer

Responsibilities:

  • Working as an active member of Reporting & Analytics team for providing critical analysis to multiple business groups across the company. Develop effective and scalable Business Intelligence solutions including Data Visualizations, Dashboards, Reporting Data Marts, operational Reports and Data Integration solutions.
  • Preparing Dashboards using calculations, parameters in Tableau 10.4. Responsible for creating the complex Analytical, Executive and operational Tableau Reports.Connect to live databases and creating the Tableau data extracts for creating the workbooks.
  • Connect to multiple data sources (excel files, flat files, SQL Server) to do analytics in Tableau Desktop and creating the Data extracts and data sources, publishing to Tableau server.
  • Design, Develop, Test, Publish and maintain PowerBI Functional reports, Dashboards based on user requirements.
  • Automated several critical reports and created reusable utilities using Unix Shell Scripting to reduce the number of repetitive requests from users.
  • Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality. Interpret data, analyze results using statistical techniques and provide ongoing reports.
  • Involve in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handle the performance issues effectively.
  • Use Spark cluster to manipulate RDD’s (resilient distributed datasets) and also used concepts of RDD partitions.
  • Wrote Python modules to extract/load asset data from the MySQL source database.
  • Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
  • SQL Server (experience in designing database, writing and implementing SQL stored procedures and scripts, and performance tuning).

Environment: Tableau Desktop,10.4, Tableau Reader 10.3.x, Power BI, Rapid SQL, PL/SQL, python, Redshift, Microsoft Excel 2010, Microsoft office 2010.

Confidential, Middleton, WI

Sr. Tableau Developer

Responsibilities:

  • Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
  • Built functionalities by writing condition to in corporate with various metrics and hands on experience in Level of Detail Expressions (LOD’s) such as Daily profit KPI, Percent of total, yearly trending analysis and root cause behavior.
  • Writing complex SQL queries on Teradata handling source data challenges and adapting to the dynamic nature of the project.
  • Developed various reports using SQL for Inventory Management and Innovations team in accordance with Business Strategies.
  • Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
  • Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau
  • Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
  • Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters
  • Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Develop parameter-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop
  • Migrated all dashboards from Tableau 9.1 to 10.1
  • Used SQL tools like Squirrel and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.

Environment: Tableau Desktop 9.1, Tableau Server 9.1, SSIS, SQL, MS Excel, Flat Files, SQL Server 2012. CSV, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory

Confidential, Houston, TX

Tableau Developer

Responsibilities:

  • Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
  • Worked on the development of Dashboard reports for Key Performance Indicators for the top management
  • Rebuild existing Reports into Tableau Visualizations with user and action filters
  • Performed Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
  • Generated various dashboards in Tableau Server using different data sources such as Access, Oracle and Microsoft SQL Server.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Interact with customers on a regular basis to resolve issues.
  • Create custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations
  • Published Workbooks by creating user filters so that only appropriate users can view/edit them.
  • Generated context filters and handled performance issues while dealing with huge volume of data.
  • Generated tableau dashboards with forecast and reference lines.
  • Experience in creating aggregate tables, table partitions, indexes and cache management.
  • Also acted as the ETL developer in the team and used Informatica when complex transformations were required.
  • Created advanced mapping, transformations, and workflows using Informatica PowerCenter 8.x then exported the csv files to use in Tableau.

Environment: Tableau Desktop 8.1, Tableau Server, Tabadmin, Tabcmd, Tableau Data Engine, Informatica PowerCenter 8.x, Oracle 9i, PL-SQL, SQL, SQL Server 2008 R2, MS Excel.

Confidential, Silver Spring, MD

Tableau Developer/Admin

Responsibilities:

  • Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Designed and deployed rich graphic visualizations with Drill Down and Drop down menu option and used parameters using Tableau.
  • Attended meetings with the Client SME’s, to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
  • Interacted with business users and performed Gap Analysis of Client requirements.
  • Actively participated in clarification meeting with the Clients.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Generated Tableau dashboards with combination charts for presenting KPI’s, with different Data Visualization Techniques like Tree Maps, Geo Maps, Stack Bars and Line Graphs for Showing Trend with Dual-Axis and Data Blending Techniques.
  • Developed key indicators and appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
  • Worked on Custom complex SQL Queries to generate data from various data sources to generate Innovative and Powerful dashboards for easy data visualization and analytics in Tableau.

Environment: Tableau Desktop 8.0, Tableau Reader, Tableau Server 7/8, Tabcmd, MS SQL Server 2012TSQL, MS Excel, SQL Server Management Studio, Share Point, MS Office 2010/2013.

Hire Now