We provide IT Staff Augmentation Services!

Sr. Tableau Developer/ Visualization Expert Resume

5.00 Rating

New York N, Y

SUMMARY:

  • A Tableau Developer with 7+ 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, 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.
  • Extensive experience in creating BRDs, FRDs, and project related documentation.
  • 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 (user’s filters) and monitored 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.
  • Extensive experience in performance optimization on the database side by creating Views, Stored Procedures and Functions and as wells as Tableau Side.
  • Experience in analyzing data from large and complex datasets and optimizing dashboards for large datasets.
  • Extensively used Tableau API for complex and statistical calculations using Python (Tabpy).
  • Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, Oracle, SQL Server and MySQL technologies.
  • Experience bringing and modeling data from multiple sources using Informatica and SISS and developed interactive dashboards using those workflows.
  • 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.
  • 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:

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

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

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

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, New York, N. Y

Sr. Tableau Developer/ Visualization Expert

Responsibilities:

  • Involved in all the phases of SDLC (Analyzing, Requirement gathering, Development, QA and Deployment.
  • Worked closely with users and developed BRDs (Business requirement documents) and FRDs (Functional required documents) for self-servicing the tool.
  • Built Strategic, Analytical and operational dashboards in Tableau.
  • Developed and demonstrated Tableau's advanced features including calculated fields, parameters, table calculations, row-level security, Python integration, joins, data blending and dashboard actions for the users.
  • Performed Data blending to bring data from multiple sources and developed interactive dashboards.
  • Built interactive Tableau dashboards using very large datasets from SQL Server and Apache Hive.
  • Extracted and Transformed data using Informatica and SISS to build Tableau dashboards.
  • Used Tabpy (Python) to perform Predictive/ Statistical analysis in Tableau dashboards.
  • Created complex calculations in Tableau and called python functions using Script INT, Script Bool, Script Real, and Script STR.
  • Performed Administrative Task such as, assigning access to workbooks, created extracts, scheduled workbooks and created user filters in Tableau server.
  • 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.
  • Created views, Stored procedures, and Functions in SQL server for Tableau reporting.
  • 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, spark lines, 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,
  • Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.
  • Tableau server and desktop upgrade from 9.3 to 10.4.

Environment: Tableau Desktop/Server 10.x/9.X, Apache Hive, Google Analytics, Adobe Analytics, Python (Tabpy), SQL Server 2014, SISS, Informatica, SQL Assistant, SharePoint, JIRA, MS Excel.

Confidential, Melville, N. Y

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Worked very close with Users and IT to automate and self-serve the process.
  • Created a wiki Confidential SharePoint containing Business required, Functional required and architectural documents for the business users.
  • Analyzed requirements for various reports, dashboards, and scorecards and developed the same using Tableau desktop.
  • Performed Tableau integration with R to perform complex statistical analysis.
  • Performed ETL work and model the data by creating a fact and dimension Table for Tableau dashboards reporting using Informatica.
  • Mentored business power users to create reports/dashboards using Tableau desktop.
  • 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 Confidential once.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Created and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Published the developed dashboard from Dev to QA, QA to Prod on the Tableau Server and gave access to users and created user filters.
  • 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.
  • 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.
  • Used Tableau QA Testing server to migrate Tableau objects from development environment to the Test environment.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

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

Confidential, New York, N. Y

Tableau Developer/ Sr. BI Developer

Responsibilities:

  • Requirement gathering for various users, interviewing them, and satisfying their exact needs for Tableau dashboarding.
  • Involved in the complete Life cycle of the Project and in the data analysis process
  • Gather the various requirement matrices from the business analysts.
  • Developed interactive dashboards using drill down filter along with complex calculations in Tableau desktop.
  • 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.
  • 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.
  • Built Complex Reports in Tableau using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
  • Conducted Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Performed ETL and created workflow from source to staging, staging to Target using Informatica.
  • Created technical designs for the various reporting requirements.
  • 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 - Middletown, N.J

BI Developer/ Sr. Data Analyst

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, Deerfield, IL

BI Developer/ Business Objects Developer

Responsibilities:

  • Migrated Web Intelligence reports, Crystal reports and dashboards from XIR2 to XIR3.1.
  • Tested reports and universes, debugged and resolved the defects identified after migration.
  • Involved in daily scrum meetings to discuss what tasks have been achieved, what needs to be done and what are the loopholes.
  • Installed and configured Business Objects XIR3.1 in DEV, IT, QA and PROD environment.
  • Set up clusters in various environments.
  • Responsible for installing Business Objects, Xcelsius, Toad and Crystal Report client tools for different users.
  • Implemented security set up for users and Groups.
  • Unit tested and fixed issues identified in BOXI 3.1 universes and reports migrated from BOXI R2.
  • Fixed the bugs caused after migration in dashboards.
  • Used life cycle manager to promote the jobs from DEV to QA.
  • Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
  • Optimized Crystal Reports performance for large reports (reduced page generation time).
  • Used Toad to verify data pulled by the report is correct compared to the database data and to verify the joins used in designing the universe are correct.
  • Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report. Prepared user documentation for hands on training for end user community.
  • Created Classes, Dimension objects, Measure objects and Detail objects in the universe.
  • Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality. Analyzed data using Slice/Dice and Drill Mode.

Environment: Oracle, Toad, Teradata, Data Stage, Webi, Xelsius, UDT, Crystal reports, UNIX, Microsoft (Word, Access, Excel, Outlook), MS VISIO

Confidential, Memphis, TN

Business Objects Developer/ BI Developer

Responsibilities:

  • Developed software development life cycles (SDLC) of the Projects.
  • Participated in the end user meetings to obtain the business requirements for creating reports.
  • Performed Data-Modeling Analysis like Creation of Snowflake schema, report structure based on the user requirements.
  • Used the Project Creation Wizard to create Facts and Attributes.
  • Created Attributes, Facts for different SAP Business Objects projects.
  • Created the requirements documentation for SAP Business Objects projects and environment.
  • Created Reports using complex Filters and Compound Metrics and Prompts.
  • Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
  • Designed an efficient BI Dashboard for the Company Executives, through efficient use of SAP Dashboard Design.
  • Developed Universes and Web intelligence reports Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
  • Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Managing schema objects and application objects across the project.
  • Developed Dashboards using Xcelsius for Stakeholders using QAAWS and Live office connections.
  • Demoed Xcelsius (2008) dashboards to summarize the bestselling product and dashboards displaying sales by store and region.

Environment: Sun Solaris, Windows NT, Oracle 9i, My SQL, JP, Servlet, MS Office Suite. Micro Strategy, Deski reports, Webi, Xcelsius, SQL Server 2005

We'd love your feedback!