We provide IT Staff Augmentation Services!

Lead Tableau Developer Resume

Greenwich, ConnecticuT

SUMMARY:

  • A Tableau Developer with 9+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms in Retail, Manufacturing, Banking/ Finance, Health Care, Delivery Services and Pharmaceutical industries.
  • Proficient in Tableau 10.x/9.x/8.x/7.x/6.x (Desktop, Server, Online), Business Objects Webi, Crystal reports, Dashboard designer/Xcelsius, SSRS, Power BI, SAP BOBJ Cloud Analytics and Informatica Power Center.
  • Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
  • Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
  • In depth understanding of the As - Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
  • 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.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
  • Expertise in using Tableau Filter, URL and Highlight actions to switch between sheets and navigate to external or internal websites
  • Expert in visualizing the data, reporting and analyzing, creating the dashboards and reports in an intelligible pictorial representing like bars, geographic maps, bubbles, pies, lines etc.
  • Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc.
  • Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
  • Extensive experience in creating users, groups, sites, row level security and monitoring server activities in Tableau Server.
  • Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,
  • Expertise in analysis, design and implementation of data warehousing applications using Teradata,, Informatica UNIX, DB2, Oracle, SQL Server and MySQL technologies.
  • Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
  • Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
  • Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
  • Expert in Trouble shooting, Performance tuning the reports and resolving the issues within the server and dashboards.
  • Excellent communication skills, Team lead and player and interpersonal skills.
  • Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
  • Experience working with offshore team.

TECHNICAL SKILLS:

Tableau Desktop/Server/On: Line 10.x/9.x/8.x, Power BI, Dashboard Designer, SQL, Google Analytics, Google Sheets, Server Reporting Services (SSRS).

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

Languages: SQL, Custom SQL, Stored Procedure, ANSI 89/92, PL/SQL, HTML, Python

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

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

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 Delivery Services.

Document Management: JIRA, Share Point, Version One

PROFESSIONAL EXPERIENCE:

Confidential, Greenwich, Connecticut

Lead Tableau Developer

Responsibilities:

  • Involved in the solution scoping of the project.
  • Organized workshop sessions to gather business requirements (blue printing) from the business users.
  • Built Strategic, Analytical and operational dashboards using Tableau.
  • Built interactive dashboards using extracts from Google Analytics and Big Query.
  • Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
  • Implemented row level security for the Tableau dashboards and used various advanced table calculations for the dashboards.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and Teradata.
  • Created stored procedures, user defined functions, views, tables and T-SQL scripting for complex business logic.
  • Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending
  • Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.
  • Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements
  • Implemented visualizations and views including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, sparklines, crosstabs etc.
  • Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
  • Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce to show the relevant data for that selected object.
  • Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.
  • Developed tableau dashboard landing page for the embedding into Salesforce to provide integrated views and navigation inside Salesforce for the users.
  • Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.
  • Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.

Environment: Tableau Desktop/Server 10.x/9.X, MS Office Suite, Google Analytics, Adobe Analytics, Sales Force, SQL Server 2014, Salesforce, Teradata, SQL Assistant, SharePoint, JIRA, MS Excel.

Confidential, Houston TX

Lead BI Consultant

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Analyzed requirements for various reports, dashboards, and scorecards and developed the same using Tableau desktop
  • Mentored business power users to create reports/dashboards using Tableau desktop.
  • Design, build and maintain logical model for Tableau reporting application.
  • Design, build and maintain all Tableau schema objects (attributes, facts, hierarchies).
  • Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
  • Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Tableau server and desktop upgrade from 9.3 to 10.3.
  • Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
  • Make use of filters and making them local and global accordingly.
  • Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
  • 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 Ipads, iPhones, and other smart mobile phones.
  • Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. This replaced time consuming Excel/ SAS based data analysis.
  • Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users could generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Created several base formulas (mathematical expressions) using existing facts in Tableau that can be re-used to build any number of metrics.
  • Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
  • Actively participated in clarification meeting with the Clients.
  • Created Test Cases and documented the Test Results.
  • Used Tableau QA Testing server to migrate Tableau objects from development environment to the Test environment.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau 8.x (Desktop/Server), Teradata, Oracle, SQL Server, Informatica, Teradata SQL Assistant, SharePoint, PL/SQL, Oracle 11g, UNIX, Documentum, Microsoft office Suite

Confidential, Minnetonka, MN

BI / Tableau Developer/Analyst

Responsibilities:

  • Requirement gathering for various users, interviewing them, and satisfying their exact needs.
  • Involved in the complete Life cycle of the Project and in the data analysis process
  • Gather the various requirement matrices from the business analysts.
  • Assisted the DBA in converting the logical models to physical.
  • Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
  • Created technical designs for the various reporting requirements.
  • Developed complex SQL scripts for Teradata 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.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.
  • Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
  • Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
  • 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.
  • Helped end users 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
  • Maintained Test Log and wrote Test Evaluation, Summary Reports.
  • Setup and Deployed tableau server to publish dashboard to a central location for portal integration
  • Implemented row level security and windows AD authentication for Tableau reports
  • Worked with the tableau community to extensive test the tableau 8 beta version

Environment: Tableau 8.x (Desktop/Server), Teradata, Oracle, SQL Server, Power Designer, MS Visio, JIRA Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential, Houston TX

Data Analyst Lead

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
  • Developed and maintained high level overview of the project and design flows using MS Visio.
  • Created dashboard using parameters, sets, groups and calculations.
  • Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
  • Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Created incremental refreshes for data sources on Tableau server.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Created report schedules, data connections, projects, groups in Tableau online.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
  • Migrated reports from Business Objects to Tableau 8.
  • Worked on Framework Manager Models Relational DMR for Standard Reporting and Adhoc Analysis
  • Validated the Data Loads in the Cube using Analysis Studio
  • Developed numerous multi tab multi page dashboard reports based on the existing remedy database incident management system with drill through functionality to the detail reports.

Environment: Tableau Desktop/Server 6.x, Business Objects, SQL Server 2008, SQL Server Management Studio, Oracle11g, DB2, Clear Case, Excel, Linux.

Confidential - Pocatello, ID

Data Technician/Oracle DBA

Responsibilities Include:

  • Creation of roles, privileges, profiles policies for group of users and assigns roles to proper end users.
  • Perform daily routine dba tasks. Managing tablespace, data files, reading alert performance tuning using reports with 3rd party software.
  • Controlling and monitoring user access to the database.
  • Creation and management of multiple instances for testing and development.
  • Take care and troubleshoot, if any problem occurs in computer labs, making sure all the computers are in running condition and all of the hosts have live connection to DB.
  • Tuned the oracle memory structure (Buffer cache, library cache, Shared spool, sort area).
  • Implementation of Database Monitoring scripts to monitor the Space usage of various tablespaces, Memory tuning, I/O and network traffic.
  • Have performed Oracle RAC & ASM Admin/Installation.
  • Created, upgraded, and cloned Oracle databases for Development and testing environments.
  • Tested database performance issues (monitoring and tuning) to ensure database optimization.
  • Implemented RAC and Physical Standby databases for High availability and disaster recovery.
  • Performance monitoring using explain Plan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
  • Implemented Oracle database backup & recovery solutions using RMAN as well as conventional backup methods.
  • Retrofitted HR and Payroll based on new requirements and customizations.
  • Worked on Data Mover Scripts (DMS Scripts) on HR and Benefits tables to validate in different environments
  • Worked on PeopleSoft Security by creating and testing user roles and permission list.
  • Identify gaps in business processes not met by delivered solutions in PeopleSoft HCM 8.8 system.

Confidential

Oracle Database Administrator/OBIEE developer

Responsibilities Include:

  • Performed Database Performance Tuning and Monitoring of Databases.
  • Designed and implemented Security Policies.
  • Configuring the Auditing of database at DB or OS level, to monitor illegal use of database.
  • Utilized Oracle Export and Import utilities to perform logical database backup and recovery, to move Oracle data from one machine, database or schemas to another and to detect database corruption
  • Controlling and monitoring user access to the database.
  • Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
  • Created schemas with partitioned external tables for a production environment, using SQL Plus.
  • Using Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
  • Configured the database for maximization of disk space utilization and memory utilization and minimizing the disk I/O to make the application faster.
  • Administered Oracle 9i and Infrastructure support using Oracle OEM.
  • Performed requirement analysis, capacity planning for databases and system infrastructure.
  • Populated Oracle tables with data from external and non- oracle files using SQL*Loader utility.
  • Used Stored Procedures for performing complex business logic involving database access and for validating information.
  • Support the database with logical backup as well as cold and hot backups.
  • Design variety of Triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
  • Built Databases and refreshed them by executing the scripts.
  • Developed shell scripts for day to day database administration activities.
  • Developed validation procedures and error reporting on the data in the intermediate tables.
  • Written SQL Loader Scripts for data extraction and transformation.

Hire Now