We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

Irving, TX

PROFESSIONAL SUMMARY:

  • Senior Data Analyst with extensive experience in the banking sector, Tableau Business Intelligence Solutions, rich background utilizing ETL tools and writing complex SQL queries for compliance, credit risks, and fraud related projects.
  • Over 7 years of Data warehousing experience and creating reports using Tableau Business Intelligence Solutions (Desktop/ Server), OLTP and OLAP Microsoft SQL Server, Oracle SQL Server as a Developer in various companies.
  • Expert in using Tableau Business Intelligence Solutions to design effective, interactive, and visually appealing dashboards
  • Responsible for designing well - tuned Tableau Dashboard by integrating Tableau and SQL to create materialized views using complex joins, stored procedures, and SQL functions to help increase Performance in Tableau
  • Expert experience in the optimization of dashboards performance and SQL queries
  • Highly proficient in designing compelling dashboards using customized charts like Sankey, Pareto, waterfall charts and combining data from various sources using blending and joins
  • Rich experience developing workarounds to customize Tableau Dashboards to meet business objectives
  • Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
  • E xtensive experience in Microsoft T-SQL/PL-SQL statements (DDL and DML) including features like Temporary Tables, Ranking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
  • Rich experience with Requirement Analysis, Functional Specifications, Technical Specifications, Data Cleansing, Data Modeling, Data Architecture, Gap Analysis, Data Transformations, Data Relationships and Reporting Analysis.
  • Effective skills in applying various management tools like SWOT, Porter's generic strategies, Mc Kinsey 7s model and competitive analysis.
  • Proficiency in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), Test Case Document (TCD)

TECHNICAL SKILLS:

Tableau Desktop 7/8/9/10/2018/2019/2020 Tableau Server 7/8/9/10/2018/2019/2020 Tableau Online, TabCmd, Microsoft SQL Server 2012/2008-R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler, Microsoft Visual Studio, Microsoft Access, Microsoft Office(MS Word/ Excel/PowerPoint), Python, Alteryx, MS Project, HTML

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Tableau Developer

Responsibilities:

  • Developed interactive Tableau visualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Experience designing complex dashboards that take advantage of all Tableau functions, including data blending, actions, parameters, and more.
  • Translate the business needs into system requirement by communicating with the business on non-technical level and with the System Analyst on technical level
  • Create workbooks and Dashboard using calculated metrics for different visualization requirements.
  • Used Alteryx to provide an end-to-end solution that enables users to spend less time discovering, preparing, blending, and analyzing data for Tableau. Utilized Alteryx and Python to automate Dashboard refresh
  • Maintain the integrity of development work and underlying data through use of version control systems
  • Worked on the performance tuning part, as most of our application have issues with PL/SQL store procedures
  • Participated in the daily stand up Scrum Agile meetings for reporting the day-to-day developments of the work done.
  • Quickly and effectively diagnose and respond to service desk request regarding data integrity and functional or interactive issues in existing and future dashboards
  • Interact directly with Audit Managers and their staffs, Business process owners, Finance, and IT to design and implement data analysis solutions. Continually re-assess these solutions in efforts to make them more efficient and effective.
  • Assess performance, reward results, motivate and foster matrix management
  • Develop methodologies that allow for efficient and repetitive data extraction processes.
  • Extended Tableau limits to create unconventional Tableau charts such as Sankey Diagram, Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.
  • Analyzed massive, and highly complex data sets, performing ad-hoc analysis and data manipulation.
  • Ensured high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
  • Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Tools: Tableau (Desktop), Tableau Server 2020.2, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook), Alteryx, Service Now, MicroStrategy

Confidential, Wilmington, DE

Sr. Tableau Developer/ Risk Reporting Analyst

Responsibilities:

  • Develop interactive data visualizations and develop automated processes for updating content used in standardized dashboards.
  • Built compelling, interactive dashboards in Tableau that answer key business questions.
  • Audits the datasets and data analyzed as required ensuring their continuity, accuracy, and consistency.
  • Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
  • Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
  • Reviewed, assessed, and promoted adoption and standardization of Tableau support solutions.
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Produced complex table calculations, use of parameters, actions, filters, and other advanced options in Tableau.
  • Design excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
  • Develop, managed, and implement reporting processes to improve efficiency, collaboration, and innovation
  • Interface with both technical and business leaders with the organization
  • Provided input in the development and maintenance of RADAR reporting and data management for regulatory and internal risk reporting
  • Developed, managed, and implement reporting processes to improve efficiency
  • Used Alteryx to provide an end-to-end solution that enables users to spend less time discovering, preparing, blending, and analyzing data for Tableau. Utilized Alteryx and Python to automate Dashboard refresh
  • Worked with leaders in the development of a one source data management tool

Tools: Tableau (Desktop), Tableau Server 2020.2, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook), Alteryx, Service Now

Confidential, Cincinnati, OH

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

  • Used Tableau Desktop for blending databases and create interactive views and dashboards
  • Created multiple scorecards and dashboards
  • Performed data analysis on daily, weekly, and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
  • Actively involved in new KPI generation for Tableau Scorecards.
  • Data collection and leveraging on data manipulation teams for required data.
  • Identified new metrics and enhance the existing KPI's.
  • Worked extensively using Excel to validate the data and use as the source data files.
  • Converted existing Excel reports into Tableau reports
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
  • Used Alteryx to provide an end-to-end solution that enables users to spend less time discovering, preparing, blending, and analyzing data for Tableau. Utilized Alteryx and Python to automate Dashboard refresh
  • Effectively used data blending, filters, actions, Hierarchies feature in Tableau.
  • Defined best practices for Tableau report development.
  • Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
  • Executed and tested required queries and reports before publishing.
  • Converted metric insight reports to Tableau reports.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Worked with Teradata database and pull data to work on BI requirement.
  • Provided Ongoing support to BI application running in production & troubleshoot.

Tools: Tableau (Desktop), Tableau Server 2020.2, Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook), Alteryx, Service Now

Confidential, Salt Lake City, UT

Tableau Developer/Admin

Responsibilities:

  • Develop interactive data visualizations and develop automated processes for updating content used in standardized dashboards.
  • Creates Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users Hold responsibility for integration points and the order in which these must be executed.
  • Built compelling, interactive dashboards in Tableau that answer key business questions.
  • Audits the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
  • Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
  • Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
  • Reviewed, assessed and promoted adoption and standardization of Tableau support solutions.
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Produce complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
  • Design excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Create views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
  • Optimized existing stored procedures and various T-SQL queries
  • Wrote Dynamic Store Procedure to move data from Staging to Application
  • Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
  • Added more audits and alerts in SSIS Packages in case of package failure

Tools: Tableau Desktop 8, Tableau Server 8, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, SAP, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, C#.

Confidential, Portland, OR

Tableau Developer

Responsibilities:

  • Developed interactive Tableau visualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Extended Tableau limits to create unconventional Tableau charts such as Sankey Diagram, Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, and logical calculations to create groups.
  • Utilized performance tuning procedures to increase performance and help make dashboard more visually appealing and user friendly
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Participated in the daily stand up Scrum Agile meetings for reporting the day-to-day developments of the work done.
  • Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
  • Effectively used data blending feature in Tableau.
  • Manipulating, cleansing & processing data using Excel, Access and SQL.
  • Analyzing raw data, drawing conclusions & developing recommendations.
  • Worked on various kinds of data filtering as required in the dashboards/reports like quick filters, context filters, filtering measures, continuous and discrete filters.
  • Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
  • Ensured high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
  • Developed and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
  • Created users, groups, projects, Data connections, settings as a Tableau administrator.
  • Created 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 SQL Developer to provide definition, structure and to maintain data efficiently.

Tools: Tableau 8.1/8.0, Tableau Server, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7, SQL Developer.

Hire Now