We provide IT Staff Augmentation Services!

Sr. Tableau Developer/sr. Data Visualization Analyst Resume

4.00/5 (Submit Your Rating)

Greenwich, CT

PROFESSIONAL SUMMARY:

  • 9+ years of experience in Data Visualization, Report developing, Business Analysis, System Analysis, Data analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and Data Warehousing Platforms across Airline Services, Banking, Retail, Insurance and Technology domains.
  • Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
  • Experience in aggregating data and configuring reports from different data sources using data blending.
  • Extensive experience on designing database using ER modeling and Normalization.
  • Hands on experience in embedding Tableau reports and dashboards on external websites using Java API and Java API Scripting.
  • Over 6 years of experience in Tableau Desktop, Tableau Server, Tableau reader, Tableau Mobile in various versions of Tableau (7.x to 2018.x).
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Highly Proficient in Agile and Waterfall software development life cycles.
  • Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
  • Worked on integrating several data sources like BIGDATA, Excel, SSAS, and HADOOP into Tableau reporting.
  • Created TDE's using Hadoop as the data source and using Hive and Impala connectors.
  • Extensively used Tableau, Crystal Reports, Business Objects, Xcelsius, Informatica Power Center, Alteryx, SQL Server, Oracle, Teradata, Hadoop and Hive.
  • Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
  • Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture...
  • Experience in working on generating various dashboards to Tableau Server using different data sources such as Teradata, SQL Server, AWS, Sales force, Oracle, DB2, Teradata, SAS datasets, MS Excel etc.
  • Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Informatica, and Tableau Prep.
  • Hands - on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
  • Possess strong knowledge of database management in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
  • Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
  • Proficient in writing complex SQL queries, scripts in Python & automating the data pulling from multiple sources by creating Alteryx workflows.
  • Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleaning and processing, writing data extract scripts/programming of data conversion and researching complex data problems.

TECHNICAL SKILLS:

Analytical Tools: Tableau 2018/10.x, 9.x, 8.x, 7.x (Desktop/Server/Reader/Public)

Data Integration Tools: Alteryx, Informatica, Tableau Prep

Data Modeling /UML Tools: Power Designer, MS Office (Visio, Word, Excel)

RDBMS: Teradata, Oracle, MS SQL Server, DB2, Sybase, Access, SAP HANA

BigData: Hadoop, Spark, Hive, Impala.

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, Query Analyzer

Document Management: SharePoint, JIRA, Version One

Scripting Languages: SQL, T SQL, PL SQL, Stored Procedure, Python, R

Operating Systems: Windows, Linux, Unix

Industries /Domains: Financial/Investments, Banking, Healthcare, Telecommunication, Retail, Manufacturing

PROFESSIONAL EXPERIENCE:

Confidential, Greenwich, CT

Sr. Tableau Developer/Sr. Data Visualization Analyst

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic
  • Maintained and Installed Tableau Server in all the environments.
  • Performed Python and R integration in Tableau for statistical analysis.
  • Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
  • Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
  • Created customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, Hadoop and performing data blending in reports.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Worked in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
  • Used Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
  • Developed Alteryx modules for big data analysis of geospatial information and SQL queries
  • Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx.
  • Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data.
  • Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
  • Actively involved in the creation of users, groups, projects, workbooks and the appropriate

Confidential - Raleigh, NC

Sr. Tableau/BI Developer

Responsibilities:

  • Involved in full project lifecycle of SDLC and coordinated with all project teams.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Created Users, Groups and projects in Tableau environment.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Gathered data from different data sources like MySQL, Excel, Oracle, MSSQL, Hadoop and Hive etc.
  • Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
  • Developed dashboards with interactive views, drill downs, and published them to the portal with user level security.
  • Utilized advance features of Tableau software like to link data from different sources together on one dashboard and to filter data in multiple views Confidential once.
  • Built complex calculations using advance functions (ATTR, LOD, DATEDIFF, Ifs, Nested Ifs, RANK DENSE, OR, NOT, AND, and Quick Table calculations).
  • Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
  • Designed and developed Big Data analytics platform for processing customer viewing preferences using Java, Hadoop, Hive and Pig.
  • Utilized Alteryx for blending data from multiple databases to create a single source of truth.
  • Data Manipulation using Oracle, SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx.
  • Creating Scripts to load data from one server to another server using Alteryx.
  • Created visual workflows in Alteryx for data blending and analysis using data quality, integration and transformation. ­­­­­­.
  • Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users with various scenarios of predictive analysis.
  • Generated guided navigation links for Interactive dashboards in Tableau.
  • Created and updated custom SQL scripts to serve as data sources for various reports and handled performance issues effectively.
  • Provided post implementation production support.

Environment: Tableau 9.x/8.x (Desktop/ Server), Alteryx, JavaScript, SQL Server, Oracle, SQL Server, Bigdata/Hadoop, Jira, VISIO, MS Office Suite (Word, Excel, PowerPoint).

Confidential, New York, N. Y

Tableau Developer

Responsibilities:

  • Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
  • Involved in System Analysis & Design of the Enterprise Data Visualization Architecture.
  • Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
  • Developing and maintaining high level overview of the data flows using MS Visio
  • Thoroughly analyzed the current Architecture, databases and designed schemas on campaign data, the tables/views of which are used as data sources for Tableau reporting
  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Involved in Extraction, Transforming and Loading (ETL) data flows to creating mappings/workflows to extract data from Flat File sources and load into DW environment.
  • Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.
  • Created Executive Dashboard sourcing heterogeneous sources extracting huge records with decent performance.
  • Extraction, transformation and loading of data from various file formats like .csv, .xls, .txt and various delimited formats using Talend open studio and sql loader.
  • Used Tableau URL Actions to navigate from the main Dashboard to detail Reports.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Developed and published customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
  • Defined best practices for Tableau report development.
  • Created ad-hoc SQL queries for customer reports, executive management reports.

Environment: Tableau Desktop/ Server, Teradata, DB2, MS SQL Server, SQL Developer, MS Project, MS Office (Word, excel, PowerPoint)

Confidential, Brooklyn, N.Y

BI Developer/ BO developer

Responsibilities:

  • Worked with end users to gain an understanding of information and core data concepts behind their business.
  • Developed Adhoc reports in Business Objects Webi and used Xcelsius for Visualization.
  • 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.
  • Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
  • Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
  • Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
  • Extensively used Informatica Power Designer to pull the data from various data bases and integrate the data.
  • Design, Create and Monitor workflows using workflow designer and workflow monitor.
  • Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
  • Written SQL scripts to test the mappings and developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Identify & record defects with required information for issue to be reproduced by development team.

Environment: Webi, Crystals, Xcelsius, SQL Server 2008, MS SQL, Informatica, Windows XP, MS Office Suite (Word, Excel, PowerPoint).

Confidential, Raleigh, NC

BI/Tableau Developer

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Analyzed the source systems and created Business Requirement Document (BRD).
  • Designed data marts to accommodate views/tables (AGG tables) with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
  • Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ data marts.
  • Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XLS.
  • Extracted digital marketing data from Adobe Marketing Cloud in Tableau Data Extract (TDE) format by connecting to Adobe Site Catalyst for developing Business Intelligence dashboards.
  • Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
  • Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
  • Ability to create custom Dashboards, Alerts and Reports to meet requirements of various user groups.
  • Designed and developed Tableau visualization solutions by connecting to Google Analytics, Oracle and SQL databases.
  • Developed custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
  • Enabled tableau Actions to drill down from Dashboard to worksheet.
  • Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Designed and developed trend reports including forecast and trend lines.
  • Configured incremental data refresh for the data sources.
  • Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
  • Background in installing and upgrading of Tableau server and server performance tuning for optimization.
  • Responsible for authorizing the users based on their privileges.
  • Involved in migration activities related to Tableau across the environments.
  • Designed filters, power prompts, and complex financial calculations for various analytical reports.
  • Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
  • Established, maintained and ensured adherence to application standards for data reporting.

Environment: Tableau 8.x (Desktop/Tableau server), Google Analytics, SQL developer, SQL Server, MS Access, Windows 2007 server, R

Confidential, Louisville, KY

B I Developer

Responsibilities:

  • Acted as liaison between Business Intelligence and Business User groups to relay change requests.
  • Conducted Requirement walk-through meetings with key stakeholders.
  • Performed detailed requirement analysis and created data mapping documents
  • Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
  • Oversee the performance of Design to develop technical solutions from Analysis documents.
  • Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
  • Actively participated in Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
  • 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.
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • 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), Parameters, Groups and sets for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
  • 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 publishing 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.
  • Built complex SQL queries to validate ETL/Reporting code in Teradata and Oracle.
  • Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
  • Developed test cases and test plans for unit and system tests for new or modified programs and job streams.
  • Involved and guided/mentored other team members in their problem-solving efforts.

Environment: Tableau Desktop/Server, Teradata 12/13, Oracle 10g/11g, Informatica 8/9, TOAD, UNIX, MS VISIO, MS Office.

We'd love your feedback!