We provide IT Staff Augmentation Services!

Tableau Developer Resume

Cincinnati, OH

SUMMARY:

  • Tableau Developer with an experience over 7+ years in Reporting, Database Design, Development and Business Intelligence of Microsoft SQL Server in the development, test and production environments with various business domains.
  • Experience in design and development of interactive data, data visualizations, graphical dashboards and reports. Use various kinds of Charts, Maps and other Tableau components to develop the interactive dashboards. Having a strong SQL and programming knowledge to deal with data transformations and translations. Advanced knowledge of handling large datasets and performance optimization in Tableau.
  • Excelled in writing complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
  • Skilled in designing Tableau reports/Dashboard utilizing Tableau desktop and Tableau Online.
  • Acknowledged as an effective communicator with excellent analytical, problem - solving & communication skills.

TECHNICAL SKILLS:

Database: SQL Server 2017, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modelling: ER-win, WorkFront

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: Tableau Desktop, Tableau online, Tableau Server, SSRS Power BI, Excel Power BI

Source Control & Collaboration Tool: Microsoft Teams, Cherwell, JIRA, Team Foundation Server (TFS), SharePoint

Programming Language: Java & C#

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Tableau Developer

  • Developed annual biometric reports, sub, and ROI reports with multiple datasets and sources in Tableau.
  • Successfully delivered on-demand and scheduled reports with complete standardization of reporting for business analysis in Tableau.
  • Designed Drop down menu option and grouping, calculated field, Parameterized and Linked reports using Tableau.
  • Gained extensive knowledge in various reporting objects such as facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, and so on, in Tableau.
  • Attend feasibility sessions to understand the scope of user needs and identify/determine technologies that will provide optimum BI solution to meet those needs;
  • Give visibility into complex process flows so senior stakeholders can see where there are issues and identify potential ways to improve;
  • Perform data pull requests, automate frequent pulls through SSIS, form Cerner, WellSource and EPIC database and verify data is within required quality standards;
  • Confer with stakeholders to strategize on dashboard design and creating visually attractive and user-friendly reports with business intelligence tools;
  • Document and disseminate the steps and tools utilized in synthesizing and generating BI data by creating templates like data dictionary documents, data mapping documents, functional design documents by maintaining them for future needs.
  • Interacted with business users and project management to gather system specification requirements for the project via JRD sessions.
  • Developed the full report development life cycle; requirements elicitation, data modelling, prototyping, development, training and deployment.
  • Developed KPIs to track the health status and behaviour of customers over the time period based on the project requirement documents.
  • Created data connections and published on Tableau Server for usage with operational/monitoring dashboards.
  • Tested the data connections that bring the data from the database to the Tableau dashboards in order to develop the reports.

Confidential, Philadelphia, PA

BI/Tableau Developer

  • Successfully collaborated with business users and project management to gather system specification requirements for the project via JRD sessions.
  • Developed the full report development life cycle; requirements elicitation, data modelling, prototyping, development, training and deployment.
  • Contributed in maintaining referential, domain, and column integrities with available options such as constraints.
  • Formulated CTEs and ranked functions to remove duplicate records in OLTP tables.
  • Organized packages through SQL server agent and implemented shared schedules.
  • Developed KPIs to track the response and behaviour of customers based on the project requirement documents.
  • Generated cascaded, sub, and parameterized reports in Tableau.
  • Created complex reports with multiple datasets and sources in Tableau.
  • Successfully delivered on-demand and scheduled reports for business analysis in Tableau.
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau.
  • Gained extensive knowledge in various reporting objects such as facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, and so on, in Tableau.

Confidential

Tableau Report Developer

  • Built a dimensional model of the new data mart with Erwin.
  • Contributed in maintaining referential, domain, and column integrities with available options such as constraints.
  • Formulated CTEs and ranked functions to remove duplicate records in OLTP tables.
  • Designed and developed code with respect to security vulnerabilities, such as SQL injections.
  • Successfully redesigned and fine-tuned existing stored procedures, triggers, UDFs, and views to improve the performance of queries.
  • Organized packages through SQL server agent and implemented shared schedules.
  • Developed KPIs to track the response and behaviour of customers based on the project requirement documents.
  • Formulated complex visualizations reports using data from relational databases using Tableau Desktop.
  • Developed various data connections from data source to Tableau for report and dashboard development.
  • Designed complex formulas and calculations within Tableau to meet the needs of complex business logic
  • Created complex calculations in Tableau reports including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions, and so on.
  • Utilized bar charts, straight tables, pie charts, dual combination charts, and filled maps using Tableau.

Confidential, Scottsdale, AZ

SQL Tableau Developer

  • Contributed with the design architect and business analyst to outline business requirements in JRD meetings.
  • Successfully performed data modeling (Star Schema) with Erwin for the ETL strategy.
  • Improved and implemented pre-existing logical and physical database.
  • Designed database objects such as tables, views, stored procedures, and triggers.
  • Revised temporary tables, indexes, and lookup techniques to optimize stored procedures.
  • Implemented dynamic SQL to develop customizable queries, answerable by the OLTP Server.
  • Developed fact tables with multiple granularity levels and maintained fact table relations with alternate keys.
  • Contributed in analyzing cube performance with partitions and perspectives.
  • Formulated report snapshots and caches to enhance performance, deployment and scheduling of reports.
  • Developed dashboards and scorecards with Tableau Desktop along with multiple charts and KPIs.
  • Designed dashboards using Tableau with rich visuals such as charts, slicers, gauges, funnel, word cloud.
  • Represented data using the cross tabs, scatter plots, maps, pie charts, bar charts, maps, utilizing Tableau.
  • Participated in rendering reports to several file formats such as PDF, Image, and Excel according to the needs of the management.
  • Successfully designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Contributed in sourcing data from multisource and collaborated using data blending feature in Tableau.
  • Established TFS for version control and change management of BI solution for cross-functional communications.

Confidential, Philadelphia, PA

ETL BI Developer

  • Collaborated with business users and stakeholders in JRD sessions to gather business requirements.
  • Built logical model and defined various constraints utilizing ER-Win for data mart.
  • Conceptualized and designed data migration strategy to populate the data-mart with facts and dimensions.
  • Created and administered schema objects such as tables, views, indexes, and referential integrity.
  • Created a parent-child architecture on database objects including SPs, UDFs, and tables.
  • Implemented database objects with T-SQL such as stored procedures, UDFs, triggers, and Indexes to create complex scripts and batches.
  • Successfully filtered bad data from the legacy system utilizing derived columns, lookups, fuzzy lookups, and conditional splits.
  • Contributed in resolving SSIS package errors utilizing error logs, breakpoints, checkpoints, and data viewers.
  • Produced a multitude of reports from cubes utilizing MDX.
  • Administered cubes and objects such as calculated members, KPIs, perspectives, and hierarchies.
  • Played a key role in generating and scheduling on-demand reports for business analysis and management decisions with SSRS.
  • Authorized snapshots, subscriptions, and report caches to improve response times and reduce traffic to the report server.
  • Established report deliveries and backup schedules with subscription configurations and snapshots.
  • Contributed in optimizing SSRS reports with snapshots, caches, execution log views, embedded queries, and stored procedures.

Confidential, Redwood City, CA

SQL SSIS Developer

  • Participated in JRD sessions to gather requirements and outline functional requirements.
  • Contributed in the normalization and de-normalization of existing tables improving query processing.
  • Outlined and developed logical/physical dimensional models of the data mart with Erwin.
  • Developed functions to provide custom functionalities according to the requirements.
  • Successfully maintained data integrity with the creation of constraints and DML triggers.
  • Established multiple isolation levels with lock mechanisms to avoid deadlocks.
  • Managed the creation and deployment of SSIS packages with transformations.
  • Supervised test script/SSIS package reviews.
  • Developed reports with multiple options with report designer and report builder in SSRS.

Confidential, Pittsburgh, PA

SQL Developer

  • Successfully gathered business requirements from end users via JRD sessions.
  • Outlined multiple constraints in logical phase of the data modeling life cycle.
  • Contributed in the modification of existing dimension data model by adding required dimensions and facts using star schema.
  • Participated in the prevention of potential blocks and deadlocks with complex code.
  • Successfully identified and wrote code to prepare for newer SQL Server version migrations.
  • Designed stored procedures and functions for data storage and manipulation.
  • Produced reports in SSRS with advanced calculations and deployed reports on the SharePoint server.
  • Administered report delivery schedules by configuring standard/data driven subscriptions within report manager.

Hire Now