We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

PROFESSIONAL SUMMARY:

  • 9+yearsof experience as Tableau developer and SQL Developer,Tableau 2019.4/2018.3/10.3/9.1/8.2/8.1/8.0/ 7.0 , OLTP and OLAP Microsoft SQL Server.
  • Core expertise includes design, analysis, development and implementation of various applications in Client/Server OLAP environment withstrong background in Databases and Data warehousing concepts.
  • Strong experience in SQL Server coding, System Analysis, Design, and Development using MS SQL Server 2012, 2008 and 2005. Ability to use custom SQL for complex data pulls.
  • Master in Tableau charting, reusability, leveraging variables and templates and building/deploying section access security models.
  • Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity using Tableau desktop and Server.
  • Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
  • Deployed tableau server in clustered environment by adding worker machines.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Well versed in query optimization for performance tuning and monitoring of processes.
  • Created Dashboard’s using multiple BI Tools with Drill - Down capabilities using Dashboard prompts, Local and Global Filters .
  • Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS).
  • Responsible for interacting with business partners and customers to identify information needs and business requirements for reports.
  • Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
  • Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
  • Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and/or concrete variables.
  • Ability to handle multiple tasks concurrently and meet the deadlines.
  • Outstanding knowledge in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio).

TECHNICAL SKILLS:

Database: D2I, MS SQL Server 2014/2008/2005/2000 , DB2, Oracle

Languages: SQL, PL/SQL

Reporting Tools: Tableau 6.0. Tableau 7.0, Tableau 8.0/8.1/8.2.3 , Tableau 9.1, Tableau 10.1/10.3, 2019.4

BI Tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS)

Domains: Financial, Banking, Retail, Healthcare

Web Tools: HTML, DHTML, XML

Others: MS Word, Excel, VISIO 2007, Service Now, Query Surge

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Tableau Developer

Responsibilities:

  • Project: The HCM project is phasing out OBIEE by converting all the reporting coming out of the HCM tool into Tableau Dashboards. There are about 3000 existing reports that will need to be converted into Tableau dashboards. This Project needs Planning, Consolidation, Advanced Tableau development skills, Server Integration, Security Implementation and Individual Contribution to handle the project seamlessly.
  • Working closely with business and technical teams to design, develop and document business and technical requirements and do GAP analysis in support of existing and new Business Intelligence Solutions- (Time Spent 10%)
  • Tableau Development (Tableau Desktop), Dashboard Enhancements, this involves external extension scripting (Java Scripts/ Rest API/ Python Scripting), data extraction and performance fine tuning along with the new development of reports. (Time Spent 40%)
  • Data Extract readiness, this involves creating either Alteryx created data sets or SQl (Stored Procedures) connected data extracts, Publishing the data sources to Tableau Server to connect to existing or new dashboards. (Time Spent 20%)
  • Production Support task 1: Ensuring the refresh schedules are successful, and the weekly/ daily report refresh is successful. (Time Spent 2.5%)
  • Production Support task 2: Ensure the continuity of the 24/7 production environment, and of the QA, UAT and Development environments (Time Spent 5 %)
  • Tableau research/Analysis items, having a meeting with tableau center of excellence team on weekly basis on new implementations and existing issue resolutions for better dashboard capability. (Time Spent 10
  • Tableau Client support tickets- PPM Addressing all the client questions, issues, new requests and modifications in the existing report environment/ new development. (Time Spent 12.5%)

Environment: Tableau Server (8.3/9.1/9.3/10.1/10.4/2018.1/2018.2 ), Tableau Desktop (8.3/9.1/9.3/10.1/10.4/2018.1/2018.2 ), Tableau Public, Microsoft SQL Server (2012, 2014, 2016), COGNOS framework manager, Java, Python, HTML, Microsoft Office, Bit Bucket, Jira Boards, Service Now, Oracle toad, SharePoint, Alteryx, Tableau prep (2018.1)

Confidential

Tech Lead- Business Intelligence

Responsibilities:

  • Involved in Design, developing, implementation and delivery of reports/dashboards in accordance with the business and reporting requirements. Need to ensure technical quality, accuracy, efficiency and adherence to project timelines.
  • Developed rich interactive visualizations integrating various reporting components from the data warehouse and multiple data sources.
  • Worked closely with the Data Architect and provide technical design recommendations on the database structures which support analytical applications.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Involved in creating dashboards and reports in Tableau 2019.1.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
  • 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 report and Dashboard using KPI's.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Confidential, Lakeland, FL

BUSINESS INTELLIGENCE ANALYST

Responsibilities:

  • Estimate, document, review and evaluate reporting and dashboard requirements and specifications.
  • Work with data & business analysts or end users to gather project requirements, analyze needs and process flow and develop user-oriented data solutions.
  • Work in a team environment offering assistance, advice and technical expertise to peers.
  • Interact regularly with management and clients to constantly improve ETL processes, data marts, reporting and dashboard services.
  • Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources.
  • Transition data marts, developed reports, and dashboards to operational and business teams.
  • Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users.
  • Ensure proper configuration management and change controls are implemented for BI data marts and reports.
  • Provide technical assistance and cross training to other team members.
  • Provide training and assistance to users for generation of ad-hoc reports.
  • Design and implement technology best practices, guidelines and repeatable processes.
  • Must be able to perform duties with moderate to low supervision.

Confidential, MARIETTA, GA

BUSINESS INTELLIGENCE ANALYST

Responsibilities:

  • As a Business Intelligence Analyst I was involved in partnering with clients across the enterprise in analyzing, creating complex analytic and reporting solutions for supporting internal and external reporting.
  • Responsible for developing databases SQL queries and stored procedures for data analysis and report sourcing.
  • Responsible for analyzing, debugging and tuning SQL databases queries for performance improvements.
  • Analyzing data warehouse architecture, maintain normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, troubleshoot and recommend improvements and alternate methodologies
  • Responsible for monitoring nightly processes to ensure timely completion and availability of data and standard reporting sets.
  • Analyze and resolve problems and provides technical assistance as is necessary. Implements corrective actions to legacy issues.
  • Conduct code reviews and participate in technical design
  • Conduct quality analysis and regression testing to ensure optimal reporting solutions
  • Working closely with business and technical teams to design, develop and document business and technical requirements in support of existing and new Business Intelligence Solutions
  • Working closely with multiple technical teams to design, develop and maintain SQL Stored procedures and scripts required to implement full Business Intelligence Solutions

Confidential, WAKEFIELD, MA

TABLEAU BI DEVELOPER

Responsibilities:

  • Involved in Design, developing, implementation and delivery of reports/dashboards in accordance with the business and reporting requirements. Need to ensure technical quality, accuracy, efficiency and adherence to project timelines.
  • Developed rich interactive visualizations integrating various reporting components from the data warehouse and multiple data sources.
  • Worked closely with the Data Architect and provide technical design recommendations on the database structures which support analytical applications.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Involved in creating dashboards and reports in Tableau 10.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
  • 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 report and Dashboard using KPI's.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Had an experience in leading a small team and Knowledge in Medical Information domain (Health Insurance and Clinical Data concepts and terminology).

Confidential, MEDFORD, MA

Sr. TABLEAU BI DEVELOPER

Responsibilities:

  • Involved in web application and Tableau report configuration designed exclusively for the access of tableau dashboards created for clients.
  • Worked on translation of data and analysis into usable and informative BI solutions which produce accurate and timely business critical reports and dashboards.
  • Worked with business partners across the enterprise to lead Business Intelligence projects from concept to implementation.
  • Responsible for developing databases SQL queries for data analysis and data extracts.
  • Responsible for analyzing, debugging and tuning database SQL queries for performance improvements.
  • Worked with business users to gather requirements, troubleshoot and resolve data and reporting issues.
  • Worked closely with Data Warehouse and Data Integration teams to build reporting solutions.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau
  • Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Involved in creating dashboards and reports in Tableau 9.1, 8.2.3 and Maintaining server activities, user activity, and customized views on Server Analysis.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • 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 report and Dashboard using KPI's.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Had an experience in leading a small team and Knowledge in Medical Information domain (Health Insurance and Clinical Data concepts and terminology).
  • Having experience with Big Data.

Environment: Tableau Desktop 9.1 &8.2.3, Tableau server / Administrator, SQL developer, Cognos Report Studio

Confidential, WELLESLEY, MA

TABLEAU BI DEVELOPER

Responsibilities:

  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau
  • Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • 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 report and Dashboard using KPI's.
  • Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
  • Had an experience in leading a small team and Knowledge in Medical Information domain (Health Insurance and Clinical Data concepts and terminology).
  • Having experience with Big Data.

Environment: Tableau Desktop 8.1, Tableau server / Administrator, Hyperion IR, SQL developer.

Confidential, FARMINGTON HILLS, MI

TABLEAU DEVELOPER

Responsibilities:

  • Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Building, publishing customized interactive reports and dashboards in Tableau 8.1, and report scheduling using Tableau server. Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Effectively used data blending feature in tableau and converted metric insight reports to tableau reports.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator and administered user, user groups, and scheduled instances for reports in Tableau.
  • Helped management see a comprehensive view of our sales pipeline and results.
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Created Business requirement documents and plans for creating dashboards.
  • Involved in creating ad hoc analysis and reporting requests in a timely manner for BML Risk related to fraud Approval's, Declines daily, monthly and yearly.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, and Maps.
  • Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
  • Coding SQL queries to create SQL views and design SQL reports.
  • Designed and developed Tableau visualization solutions as per higher management requirements.

Environment: Tableau Desktop 7.0, 8.0, Tableau server / Administrator, SQL Developer, SQL 2008.

Confidential, SAN JOSE, CA

TABLEAU REPORT DEVELOPER

Responsibilities:

  • Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau.
  • Liaise between business users and Tableau support team, and advocated the use of Tableau solution to help educate business users, and to facilitate early adoption of the tool.
  • Created several dashboards that captured Operational Performance, Financial Performance, Information Security, Talent Management and Project Performance metrics.
  • Migrated content from Production, QA to Development Environment.
  • Created extensive joins for data blending from several different data sources.
  • Used Actions extensively to link and filter sheets for easier navigation in Dashboards.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableaudesktop & publish them to server.
  • Manage Production, Test and Development environments including installation of patches, security administration and access controls.
  • Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
  • Attended meetings with Data Warehouse team, ETL team and Project Managers to track deliverable status.
  • Performing complex data management, mapping and query development.
  • Identification and integration of data from a variety of sources and formatted them into analytics and graphs using Tableau Software.
  • Helped customize Tableau Server with Company Logo and Company Pop-Ups.
  • Work with various infrastructure teams and Tableau support team to help improve dashboard response time.
  • Served as escalation point for database issues with Teradata
  • Experienced in Backup, restore, migrate Teradata data and objects using TARA with TSM, NetBackup, and MVS
  • Worked with Teradata on Installing/Updating/Maintaining new/existing Teradata systems including DBS Control, XDBW, CTL, VProcManager, etc.
  • Have hands on experience with Teradata Utilities such as BTEQ, FastLoad, MultiLoad, FastExport, Tpump etc.

Environment: Tableau Desktop 6.1 Tableau server / Administrator, tabcmd, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Teradata, Microsoft office 2007.

Confidential, SOMERSET, NJ

SQL/BI DEVELOPER

Responsibilities:

  • Designed, Coded, Tested, Implemented the Stored Procedures to support the System.
  • Fixed bugs in the existing in-house developed Software which is used to upload the reports for the end users to view the reports.
  • Designed, coded and tested several T-SQL Queries to Support the System.
  • Fixed bugs in the software that was used to support the healthcare system.
  • Designed, Coded, Tested, Implemented Stored Procedures to get data for the reports.
  • Designed the reports using Crystal reports And SSRS to create reports for the end users.
  • Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
  • Scheduled meetings with the end users and business owners and gathered requirements for the system.
  • Developed triggers on tables to support the system.
  • Created and configured SQL mail to send mail as events occur.
  • Used the SQL profiler to trace the data and thus troubleshoot effectively.
  • Worked on SQLSMS to grant other users the rights to the needed stored procedures and table as required.

Environment: SQL Server 2008, MS Visio, Erwin Visual studio 2008, NET Framework, PowerBuilder, Crystal reports, SSRS.

Hire Now