We provide IT Staff Augmentation Services!

Tableau Developer Resume

CA

SUMMARY

  • Over 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • In - depth knowledge on Tableau Desktop and Tableau Server.
  • Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
  • Expert in Strong understanding of dimensional data modeling and strong SQL optimization capabilities.
  • Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
  • Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
  • Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
  • Improved Reports performance in tableau using extracts and context filters.
  • Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables .
  • Extensive experience in handling ETL using InformaticaPower Center/Power Mart 7.x/6.x.
  • Strong design and development experience in ETL tools/ processes using Informatica client tools like Designer, Server Manager, Workflow Manager, Workflow Monitor, and Repository Manager.
  • Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
  • Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

Database: Teradata, MS SQL Server 2005/2000, DB2, Oracle.

Languages: SQL, PL/SQL, Teradata-BTEQ, TPT.

Reporting Tools: Tableau 7.0, Tableau 8.0/8.1, Tableau 9.2

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

ETL Tools: InformaticaPower Center/Power Mart 7.x/6.x.

Domains: Financial, Banking, Retail.

Web Tools: HTML, DHTML, XML.

Others: MS Word, Excel, VISIO 2007.

PROFESSIONAL EXPERIENCE

Confidential, CA

Tableau Developer

Responsibilities:

  • Gathered reports requirement and collaborated with business users using wireframe mockups.
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Utilized complex SQL join statements to represent relationship between facts and dimensions.
  • Computed margins using calculated field following pre-defined business rules.
  • Modelled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location.
  • Generated groups for the application field to do category based analysis.
  • Implemented hierarchies in Tableau with Portfolio as the highest level followed by application and project details.
  • Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made of represent the application category.
  • Implemented sets to display Top N projects based on business defined conditions in a portfolio.
  • Scheduled daily data extracts to enhance performance.
  • Experience with creation of users, groups, projects, workbooks and appropriate permission sets for Tableau server authorization.
  • Created symbol maps to understand the geo-spatial distribution of projects with custom symbols to represent the application category.
  • Used Tableau workbook design, Tableau reports and dashboards design.

Environment: Tableau 8.0/8.2, SQL Server 2005/2008, MS Access database and MS Excel.

Confidential, NY

Sr. Tableau Developer

Responsibilities:

  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Effectively used data blending feature in tableau.
  • Defined best practices for Tableau report development.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • 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 side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • 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.
  • Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
  • Provided support for Tableau developed objects and understand tool administration.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Created Custom Hierarchies to meet the Business requirement in Tableau.
  • Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
  • Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
  • Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
  • Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
  • 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.
  • Experience on writing SQL Queries.
  • Strong verbal and written communication skills, ability to work effectively with user departments.

Environment: TableauDesktop 7 & 8.1,TableauServer, Business Objects, SQL Server 2008/2012SQL, PL/SQL, Crystal Reports, Xcelsius, Web Intelligence, Info view, MS Project.

Confidential

Sr. Tableau/BI Analyst

Responsibilities:

  • As Sr. BI Analyst responsible for interaction with business stake holders, gathering requirements and managing the delivery
  • Created multiple sites on the tableau server and implemented the security for these sites by creating users, groups and assigning data level, report level and site level permissions
  • Helped the customers with integration of their front end application with tableau server by establishing trusted authentication.
  • Created rich dashboards using tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights
  • Was in charge of Tableau Architecture and Administration, configurations and installations
  • Setup and Deployed tableau server to publish dashboard to a central location for portal integration
  • Implemented the Local Authentication, integration with windows AD authentication and application security design
  • Connected tableau server with SharePoint portal and setup auto refresh
  • Expertise with modules Claims Processing, Enrollment, Network, Provider and Pricing.
  • Created visualization for hospital logistics calculation and department spend analysis
  • Generated KPI for customer satisfaction survey results and disease management
  • Maintained Test Log and wrote Test Evaluation, Summary Reports.
  • Participated in Walkthrough’s, Technical Reviews, and Defect review meetings all through the delivery phase.
  • Worked with the tableau community to extensive test the tableau 8 beta version.

Environment: Tableau Software 7.0, Confluence, Jira, Microsoft office, SQL Server, Oracle, SharePoint, Teradata, Composite

Confidential, NC

Tableau Consultant

Responsibilities:

  • Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
  • Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
  • Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
  • Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
  • Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
  • Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
  • Participated in preparing detailed technical documents from the functional specifications.
  • Created Global Filters and applied for all the views in the dashboard.
  • Created Data Source and published into the server for other users.
  • Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
  • Executed and tested required queries and reports before publishing dashboards.
  • Created Tableau scorecards, dashboards, Heat maps using show me functionality.
  • Created complex data Views manually using multiple measures also used Sort, Filter, Group, Create Set functionality.
  • Published Reports, workbooks & data source to server and exporting the reports in different Formats.
  • Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.

Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL developer, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server.

Confidential, MN

Tableau Consultant

Responsibilities:

  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Upgraded tableau 7.0 to tableau 8.0 and gathered requirements, analyzed from raw data.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
  • Worked on Motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
  • Ability to work quickly and under tight delivery deadlines with focus on details.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
  • Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, SSAS/SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential, CA

Informatica Developer

Responsibilities:

  • Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.
  • Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.
  • Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on Confidential table.
  • Created mapplets and reusable transformations.
  • Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
  • Created stored procedures, Functions and Packages in Oracle, used PL/SQL and SQL. Used SQL*loader to load data from MS-EXCEL sheets.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Power Center 7.1.4, Oracle 8i, PL/SQL, SQL, UNIX, Win 2000/NT.

Confidential

SQL Data Analyst

Responsibilities:

  • Analyzed business process workflows and developed ETL procedures for moving data from source to Confidential systems.
  • Designed Web-based Internet applications linked to firm-wide SQL databases.
  • Creating and debugging of packages and procedures and functions and troubleshoot jobs using the debugging tool.
  • Involved in analysis, coding, testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.
  • Used PL/SQL for creating database objects, running the command scripts for inserting the configuration data items.
  • Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data using SQL* Loader to custom tables.
  • Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
  • Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
  • Tested any changes to the system and ensured that the changes are according to the specifications.

Environment: Oracle 10g, PL/SQL, SQL* Loader, MS Excel, UNIX Shell scripting.

Hire Now