We provide IT Staff Augmentation Services!

Tableau Developer Resume

Chicago, Il

SUMMARY:

  • Tableau/BI Developer with Over 7+ Years of IT Experience in Business Intelligence and Data Warehousing applications in Retail, Education, Health Careand FinancialDomains.
  • Extensive knowledge in Dimensional data modeling, Star Schema, Snow - Flake Schema, Normalization, Physical and Logical modeling.
  • Good understanding of Tableau Desktop architecture for designing and developing dashboards.
  • Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
  • Utilized all Tableau tools including Tableau Desktop, Tableau ServerTableau Online,, Tableau Public, and Tableau Reader extensively
  • Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports
  • Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes
  • Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts
  • Experience with analysis, data, databases, and business intelligence
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
  • Excellent in applying Actions and Quick Filters
  • Expertise in Data Warehouse development working with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Data Integrator with DB2 UDB, Oracle, and SQL Server.
  • SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
  • Worked extensively with Business Objects Data Integrator to create complex Data Flows using Query, Table comparison, lookups and all transformations.
  • Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues
  • Hands on experience with reporting tools BOBJ, Crystal Reports, and Tableau.
  • Exposure to Full Life Cycle Solution Development (Requirement gathering, Analysis, Design, Development, Documentation, Testing and User training)
  • Ability to handle multiple tasks and work independently as well as in a team.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level. Defined best practices for Tableau report development.
  • Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

TECHNICAL SKILLS:

BI Reporting Tools: Tableau Suite of Tools 10.0/9.0/8.0/7.0 which includes Desktop, Server, online and Public and Administration of Tableau Server, Business Objects and SSRS

ETL Tools: Informatica Power Center and SSIS

Front End Tools: MS Project, JIRA, MS Office Suite

Databases: MS SQL Server 2014/2012/2008/2005, MS Access \, Oracle 11g/10g/9i

Scripting Languages: SQL, TSQL,PL/SQL, Python, Java, C#, HTML

Operating Systems: Linux, Ubuntu and Windows

Data Models: Erwin

Methodologies: Agile and Water Fall

WORK EXPERIENCE:

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

  • Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
  • 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 reports and dashboard using KPI’s.
  • Installed Tableau Server in Dev, QA, UAT and Prod environments.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
  • Used Sheet filters to produce multiple chart types in a single view.
  • Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test..
  • Involved in creating dashboards and reports in Tableau 10/9 and Maintaining server activities user activity and customized views onTableau server.
  • Coordinated database middleware issues with DBA's, system performance issues with System Architects.
  • Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
  • Provided 24/7 production support for Tableau users.

Environment: s: TableauDesktop10/9, Tableau server/Administrator, SQL developer, SSIS, Microsoft Excel, MS Access, Microsoft office Suite.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
  • Experience in standardizing Tableau for shared service deployment.
  • Extensively used data blending, embed functionalities in Tableau.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.
  • Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.
  • Involved in license management SLA’s with Tableau support.
  • Defined and created procedures to install Tableau desktop in silent mode.
  • Defined best practices for Tableau report development.
  • Provided 24/7 production support for Tableau users.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Combined visualizations into Interactive Dashboards and publish them to the web.
  • Migrated Workbooks and Dashboards from Tableau 8 to Tableau 9.
  • Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: s:Tableau server, Tableau Desktop 9/8,, MS SQL Server 2014/2012, MS Excel, TSQL, Windows.

Confidential, Washington, D.C

Tableau Admin/Developer

Responsibilities:

  • Defined best practices for Tableau report development.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • 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 Desktop.
  • Effectively used data blending feature in tableau.
  • Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Executed and tested required queries and reports before publishing.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Created Custom Hierarchies to meet the Business requirement in Tableau.
  • Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
  • Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
  • Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
  • Responsible for developing provisioning reports for various groups and upper management.
  • Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
  • Experience on writing SQL Queries.

Environment: TableauDesktop8,Tableauserver/Administrator,SQLdeveloper, SSIS,OLAP, Oracle 10g, Microsoft Excel 2007, MS Access, Windows, Microsoft office.

Confidential, Providence, RI

BI Consultant

Responsibilities:

  • Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications and externally purchased software products.
  • Write detailed technical specifications for subsystems and identify integration points.
  • Performed unit testing and debugging and set test conditions based on code specifications.
  • Blended data from multiple databases into one report by selectingprimary key's from each database for data validation.
  • Good understanding of columnar database, multi-dimensional OLAP cubes, big data implementations.
  • Supported application throughout the Product Development life cycle.
  • Coordinated with areas for integration architecture solutions and determine the integration approach.
  • Design, develop and maintain reports, ad hoc queries and analytical tools.
  • Provide analysis and issue resolution on business reported concerns.
  • Participate in design and delivery of cubes, dashboards and various self-service business intelligence solutions.
  • Produce metrics and other report objects and components.
  • Perform ongoing monitoring, automation and refinement of reports and BI solutions.
  • Perform daily monitoring of data loads, automated production reports and automated report distributions through email.
  • Work with business departmental teams to help them define and document business requirements for new metrics and reports.
  • Participate in process reviews and enhancements.
  • Enforce established documentation guidelines and best practices.
  • Maintain a high degree of business functional knowledge and current automated technologies and tools.

Environment: SQL Server 2008, Flat Files,SSIS, MS Excel, MS Visio.

Confidential

SQL Developer

Responsibilities:

  • Developed SSIS Packages, Procedures and Functions for Various Extract Process run through SQL Jobs.
  • Coded SSIS Packages and Procedures using Bulk Binding, for all Statements, DynamicSQL and Cursor Variables.
  • Tuned SSIS Packages and SQL Procedure to manipulate large no of data using collections like nested queries and C# script.
  • Created Schema Objects like Tables, Views, Triggers, Sequences, Constraints, and Indexes.
  • Developed and Deployed Data REPORTS in MS Excel.
  • Improved Performance of Discoverer Reports using Materialized views.
  • Developed UNIX Shell Scripts for Autonomous Jobs.
  • Experience in developing logical and physical database design, data modeling using Erwin.
  • Provided Productions support and ongoing user support for the application.
  • Designed Development Documentation and Support Documentations.

Environment: MS SQL Server 2005, SSIS, TOAD, UNIX, MS Excel, Erwin.

Hire Now