We provide IT Staff Augmentation Services!

Lead Tableau Developer Resume

New York, NY

PROFESSIONAL SUMMARY:

  • 8+ years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects using Tableau, Cognos, SSIS, SSRS, Informatica, Teradata, Oracle, SQL Server, MySQL in Retail, Healthcare, Telecommunication, and Financial/Banking Industries Expertise in BI/Data Warehousing concepts, designs, and project implementations.
  • Proficient in Tableau 7.x/8.x/9.x/10.x product suite (Desktop, Server) Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
  • Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
  • Extensive experience in all Phases of the project such as analyzing, requirement gathering, development, UAT and Production support.
  • Experienced in preparing Business Process Re - Engineering Models.
  • 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.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
  • Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
  • Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
  • Proficient in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
  • Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
  • Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources. Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues
  • Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
  • Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
  • Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client. Willing to relocate anywhere

TECHNICAL SKILLS:

Tableau Desktop/Server/On: Line 10.x/9.x/8.x, Business Objects 3.x/4.x, Cognos, Dashboard Designer, Xcelsius, BEX Query, Microsoft Power BI, SQL Server Reporting Services (SSRS)

ETL Tools: Informatica Power Center 9.x, SQL Server Integration Services (SSIS)

Languages: SQL, Custom Sql, Stored Procedure, ANSI 89/92, PL/SQL, HTML, CSS, Core Java

Data Modeling: Star Schema/Snowflake Schema model, Fact & Dimensions tables, SCD Type 1/2/3, OLAP, OLTP, Conformed Dimensions

Databases: Oracle 10g/11g/12g, MS SQL Server 2008/2012/2014 , Teradata, MS Access, MySQL, DB2, PostgreSQL

Operating Systems: Windows XP/Vista/7/8/10, MAC OS X, Linux, Unix

Microsoft Tools: MS Excel, MS Word, MS Project, MS PowerPoint

Industries: Banking/Financial, Investment, Healthcare, Retail, Manufacturing, Pharmaceutical and Telecommunication.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Lead Tableau Developer

Responsibilities:

  • Experience with the design and development of Tableau visualization solutions.
  • Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Extracting data from various sources connecting them and used the same to create dashboard.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Creating data blending in case of merging two different datasets.
  • The ability to interact professionally with a diverse group including executives, managers.
  • Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
  • Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while Confidential the same time maintaining the accuracy of the core information content that is being communicated.
  • Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
  • Proof-read all documents and maintain accuracy of information and preparing SOP.
  • Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
  • Working knowledge on Tableau Server / Administration.
  • Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
  • Identify new metrics and enhance the existing KPI's.
  • Dashboard Visualization through Tableau BI application.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, Hierarchies 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.
  • Converted metric insight reports to tableau reports.
  • Working extensively with Tableau Business Intelligence tool to develop various dashboards.
  • Working extensively using Excel to validate the data and use as the source data files.
  • Analysing the data using Statistical features in Tableau to develop trend analysis.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Scheduled frequency and time to refresh data for the when sources are published or extracted to server.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhone, and other smart mobile phones.

Environment: Tableau Desktop/Server 9.x/10.x, Xcelsius, Informatica Power Center, MS SQL Server 2014, Oracle 12g, Windows 7, TOAD, Management Studio 2008

Confidential, New York, NY

Senior Tableau Developer

Responsibilities:

  • 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.
  • 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.
  • 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 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.
  • Responsible for developing provisioning reports for various groups and upper management.
  • Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents Experience on writing SQL Queries.
  • Experience on BW Analyzer & Query Designer.
  • Strong verbal and written communication skills, ability to work effectively with user departments.
  • Worked towards the goals of quality, time and budget.

Environment: Tableau Server/Tableau Desktop 8.x/9.x, Postgresql, Dashboard Designer, Windows Server Standard R2, SQL Server management studio, MS SQL Server 2008R2, Oracle 10g, UNIX.

Confidential, Portsmouth, OH

Tableau Developer/ BI Developer

Responsibilities:

  • Interacted with business users in gathering, analysing and documenting the business requirements and translating them into technical specifications.
  • Analyzed data sources in Excel/MS SQL Server for design of dashboards to depict product and customer trends using Tableau Desktop.
  • Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
  • Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
  • Developed Metadata Models in Tableau and dashboards.
  • Prepared Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Developed ad-hoc data visualizations to aid analytical efforts of the internal team.
  • Created initial views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Worked along with Business Analysts and Functional Analysts to identify and highlight process improving opportunities.
  • Used effective visualizations like tables and graphs which were easy to comprehend and Confidential the same time maintained the accuracy of the underlying data.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
  • Created and assisted users in Tableau dashboard development Administered and provided production support for CHOP Enterprise wide Tableau application consisting of multiple key functional business domains.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Defined and created procedures to install Tableau desktop in silent mode.
  • Defined best practices for Tableau report development.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Provided 24/7 production support for Tableau users and tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: Tableau 8.x, Business Objects 4.x/3.x, Oracle, Teradata, DB2, MS SQL Server, Java, Tableau Server.

Confidential, New Albany, Ohio

Tableau Consultant/Data Analyst

Responsibilities:

  • Gathered User requirements and reviewed them from a technical perspective and conducted meetings with end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.
  • Participated in installation and configuration of tableau server and desktop Preparing Dashboards using calculations, parameters in Tableau.
  • Understanding of relational database structures, theories, principles, and practices.
  • The ability to interact professionally with a diverse group, including executives, managers, and LOB. Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
  • Working on generating various dashboards in Tableau server using various sources such as Teradata.
  • Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while Confidential the same time maintaining the accuracy of the core information content that is being communicated
  • Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
  • Proof-read all documents and maintain accuracy of information and preparing SOP.
  • Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
  • Actively written batch scripts as part of deploying and running Cognos10 Power Cubes on Unix prod box.
  • Created scorecard reports and dashboard using Cognos 8 report studio.
  • Developed ad-hoc reports, drill through reports and created master detail relationship to burst a crosstab report using Report Studio Designed model using power play transformer and created multiple cube views.
  • Deployed the packages and reports from Dev to QA and QA to production environments Documentation of the report results and updated daily with the testing results. Participated in the testing of the developed reports and reported the defects.

Environment: Tableau Desktop 7.0 Tableau server / Administrator, Tabcmd, SQL developer, Cognos 8.4 (Report studio, Query Studio, Analysis Studio), Powerplay Transformer, Cognos 8 Framework Manager, Cognos SDK 8.4, Oracle 11i, TOAD, Windows, Sun SOLARIS.

Confidential, Torranance, CA

Business Objects Developer/ Data Analyst

Responsibilities:

  • Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
  • Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
  • Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
  • Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps)
  • Leveraged BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
  • Created monthly and summary reports in WEBI for the different domains like Finance, Marketing and HR domains.
  • Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
  • Created WEBI reports & Crystal reports and deployed them through Info view with BEX as source
  • Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
  • Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
  • Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source Webi reports and by selecting the filter option changing with refresh on trigger option to pick from the latest instance.
  • Created Dynamic Dashboards using SAP BI data/ BEX Queries.
  • Extensively worked on Xcelsius Dashboard using Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: Business Objects 3.1, Xcelsius, Webi, Crystal, SQL Server 2008, Teradata, MS SQL ServerUDT.

Hire Now