We provide IT Staff Augmentation Services!

Sr. Tableau Developer/sr. Data Analyst Resume

5.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • Over 8 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
  • Expertise in Installing, Configuring, Maintaining, Upgrading and Troubleshooting Tableau server.
  • Extensive experience in working with Tableau Desktop, Tableau Server in various versions of Tableau 10.3, 9.3, 8.1.6, 8.0, Tableau 7 and Tableau 6.
  • Expertise in creating Tableau reports with best practices and conducting doctor sessions for desktop authors to resolve their issues.
  • Employed various Tableau functionalities like Tableau Extracts, Cross Database joins, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
  • Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
  • Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
  • Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
  • Extensive experience in creating Tableau scorecards, Tableau dashboards using stack bars, bar graphs, scattered plots and geographical maps.
  • Experience with R Integration in Tableau to identify patterns, build practical models for a deep statistical analysis and accomplish forecasting of those statistical models.
  • Experience in generating reports by fetching data from different sources (RDBMS/ Text/ CSV/ EXCEL) using Data Blending.
  • Expertise in designing and creating various analytical reports like Performance Dashboards, Score cards and Metrics to help users to identify critical KPIs and facilitate strategic planning in all functional areas including Order Management, Finance and Planning, Process Management, Sales/ Marketing and Resource Management.
  • Very strong experience in building OBIEE Repository (.rpd file) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer).
  • Hands on experience in using Oracle Business Intelligence including Answers, Delivers, Dashboards, Agents, Admin tool, Catalog manager, Administration, Setup and maintenance
  • Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports generated from various ETL sources.
  • Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
  • Good Knowledge on other BI tools like QlikView, Microsoft Power BI, Tibco Spotfire.
  • Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
  • Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
  • Good Programming knowledge on Python, C.
  • Expertise in Automation of backup and logs maintenance on Tableau server.
  • Strong experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS).
  • Expertise in designing and implementing High Availability and Failover Server.
  • Experience in troubleshooting issues using log files, Knowledgebase.
  • Experience in Administering user, user groups, Projects, Sites and scheduled instances for reports in Tableau.
  • Strong analytical, logical, Communication and problem-solving skills and ability to quickly adapt to new technologies by self-learning.
  • Offers proven abilities, as team player possesses strong communication, verbal and written skills and possess a track record of success in meeting the project deadlines.

TECHNICAL SKILLS

BI/Reporting Tools: Tableau desktop 10.3, 9.3, 9.1,8.1.6, 8.0, 7.0, Tableau Server 7.0, 8.1.8, 8.3.2, 9.1, 9.3, QlikView, OBIEE 10.1.3.3:

Requirement Management: Requisite Pro, Microsoft Office:

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes:

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum:

Defect management tool: Test Director, HP Quality center:

Relational Databases: MS SQL Server, MYSQL server, Oracle, Teradata, Netezza, Kognitio.:

Languages: SQL, PL/SQL, T-SQL, Python, HTML, XML, XSL.:

Operating systems: Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.:

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

  • Analysing Confidential ’s Foundational data to provide insights about the Data Quality issues.
  • Created a real-time tableau report on Foundational Data Data Quality.
  • Enabled auto-trigger for Dashboard framework on completion of Data Profiling and Data Quality framework.
  • Designed a dashboard where the users can slice and dice the data at a wide range of Data elements.
  • Created a dashboard with row level security, restricting access to the data on the dashboard based on the user.
  • Administered tableau server for the Data Quality site and developed best practices on tableau platform.
  • Created a dashboard consisting of more than 20 tables by joining them using custom SQL.
  • Designed a dashboard with wide variety of visualizations including pie chart, donut chart, heat map, stacked bar chart etc.
  • Designed a dashboard to dynamically show or hide crosstab sheets with the detail records upon the selection on the summary chart on the dashboard.
  • Created a dashboard that consisted of more than 5 different data sources and applied action filter to filter cross all the data sources on the dashboard.
  • Designed and documented Technical design, Dashboard training deck, Performance test results and other technical aspects of the implementation.
  • Handled deployments from DEV to PROD for both onsite and offshore.
  • Troubleshot various issues in tableau, as well as from the database end.
  • 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.
  • Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
  • Working with User for requirements and part of the team developing the software.
  • Scheduled reports debugged issues and provided resolutions for Tableau.
  • Extensively worked on AWS cloud platform.

Environment: Tableau Desktop10.3,10.2, Tableauserver 9.3, GitHub, Jenkins, Teradata, Microsoft SQL Server, SQL, PL/SQL, Windows 07/08 server, Microsoft office 16.

Confidential, Plano, TX

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

  • Analysing Confidential Home Loans data to provide insights for Decision Making.
  • Created a real-time tableau report on Louisiana Flood impact integrating US government (FEMA) data with in house loan data.
  • Built excellent Tableau Dashboards for several processes of Home Loans including Home Equity, Bankruptcy, Loss Mitigation, Credit Bureau Reporting and Tax Insurance and Flood reporting.
  • Administered Tableau server for the Home Loans Site and developed best practices on tableau platform.
  • Upgraded Tableau Server from version 9.3 to Tableau 10.1 and then to 10.3.
  • Extensively worked on AWS cloud platform.
  • Implemented Rest API and tabcmd for automating several tasks such as custom scheduling, event triggering, API triggering, Timely PDF snapshots etc.
  • Implemented Active directory with SAML Authentication.
  • Troubleshot different installation/ upgrade issues including port issues, SSL configuration issues, restoration failure etc.
  • Implemented High Availability server on a 4node cluster using Tableau server best practices.
  • Dynamically implemented the changes in Server processes configuration to follow best performance for growing use of Tableau.
  • Implemented performance optimization techniques for desktop authors and held doctor sessions every week to solve their issues.
  • Implemented Automation of Tableau Backup on weekly basis and Automation of Tableau Logs on Daily Basis and stored them in separate folder automatically.
  • Created batch scripts for scheduling the refresh/ data extracts using Task scheduler.
  • Created Custom Admin Views for the server Using Postgre SQL Database to track detailed view of usage, user activity, server activity etc.
  • Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
  • Worked on SQL/PLSQL for creating views on Teradata for making the data usable for reporting needs.
  • Employed Hudson/Jenkins to automate SQL jobs and to trigger Tableau refresh using rest api/ tabcmd.
  • Used GitHub for source code management and version control.
  • Worked on python scripting to automate refreshes, table check etc.

Environment: Tableau Desktop10.0, 9.3, 9.1 Tableauserver 9.3, 9.1, 8.3, GitHub, Jenkins, Teradata, Microsoft SQL Server, SQL, PL/SQL, Windows 07/08 server, Microsoft office 16.

Confidential, Phoenix, AZ

Tableau Server Admin

Responsibilities:

  • Worked as Tableau Server Administrator and Tableau desktop developer.
  • Installed and configured Tableau Server and Tableau Desktop.
  • Upgraded Tableau Server from Tableau 8.1.6 to Tableau 8.3 and tested 9.0 BETA version.
  • Created a multilingual report for different region users with a workaround on the same sheet (for both server and reader), tableau software was impressed with the robust workaround and are now saving the workaround in their knowledge base.
  • Involved in POC’s with memsql Database, Kognitio Database to get the better performance on the workbooks.
  • Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication
  • Extensively Used Data Blending to Join Multiple Data Sources.
  • Experience in creating complex Dashboards using Parameters, Filters, Sets and Groups.
  • Created Custom Admin Views for the server Using Postgre SQL Database to track detailed view of usage, user activity, server activity etc.
  • Provided production and admin support of Tableau BI reporting solutions
  • Analyzed, troubleshoot and / or tune product performance or deployment issues when required
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks as Tableau Administrator
  • Administered user, user groups, roles, permission setup, Management etc
  • Did performance turning in tableau to improve report response time.
  • Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Created ODBC connection, DSN to connect to Kognitio database since the native drivers doesn’t support
  • Created Forecasted Reports for the Upcoming Year to Observe Trends in Tableau
  • Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
  • Monitored VizQL server, Application Server and data server activity to track performance and system stability.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Conducted Performance Testing and solved potential Bottlenecks.

Environment: Tableau Desktop7.0, 8.1.6 Tableauserver 7.0, 8.1.6, 8.3, MapR Hadoop Hive, IBM Netezza, Kognitio ODBC, Oracle DB, Teradata, Microsoft SQL Server, SQL, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 07/08 server, Microsoft office 2007, Business objects 4.0.

Confidential, Hoffman Estates, IL

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

  • Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
  • Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
  • Communicated Project Requirements, Business Issues, Solution and made recommendation.
  • Worked with Project team to determine technical and development impact of a project.
  • Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
  • Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
  • Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
  • Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
  • Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Interact professionally with diverse group of professionals in the organization including managers and executives.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Created reports and dashboards using Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created new Schedule's and checking the task's daily on the server.
  • Experience in standardizing Tableau for shared service deployment.
  • Extensively used data blending, embed functionalities in Tableau.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
  • Created users, groups, projects, Data connections, and settings as a tableau administrator.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment: Tableau Desktop / Serve, Teradata, Informatica, MS SQL Server, Toad, Teradata SQL Assistant, SQL, PL/SQL, T-SQL, UNIX, Microsoft office Suite (Word, Excel, PowerPoint).

Confidential, San Francisco, CA

Tableau Developer/ Data Analyst

Responsibilities:

  • Interacted with business to collect and understand Requirements.
  • Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
  • Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
  • Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
  • Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
  • Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
  • Created Data Definitions and help maintain Metadata repository.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • 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 SSRS.
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau / SSRS.
  • 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.

Environment: Tableau (Desktop/ Server), MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010.

Confidential, Rochester, MN

SQL Developer

Responsibilities:

  • Wrote program to export as text files or PDF to outside Business Users.
  • Utilized SQL Queries, stored procedures, packages, used defined functions, views, cursors using Toad or SQL Developer to present data on the reports such as sales information, deposit and payout and their incentive compensation information.
  • Created mid to complex Reports (Oracle data sources) with one or more of the following features to support statistical and operational business needs, Grouping, Sorting, Drill-down Dynamic Parameter prompts, Sub reports or Crosstab summaries
  • Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports
  • Created formulas and/or used statistical or financial functions for reports as needed.
  • Used SQL stored procedures, created alias data tables as required to improve report performance.
  • Created Stored Procedures and Views as data sources using Oracle databases for reports.
  • Wrote different queries and stored procedures to make our daily data verification and conversion processes faster, more accurate and automated.
  • Used Optimizer HINT for tuning SQL and PL/SQL queries rewrite most of them for efficiency
  • Worked with DBMS PROFILER to tune PL/SQL Procedures.
  • Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
  • Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling
  • Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.
  • Implementing performance tuning methods to resolve issues and bottlenecks. Identifying long running queries and performing performance tuning.
  • Created trigger to collect the trace files to get login information.
  • Created Materialized Views and partitioning tables for performance reasons.
  • Used cursor, ref cursor, bulk collect and bulk insert (BULK BINDING) in procedure to reduce its execution time.

Environment: Microsoft SQL Server 2008, SSRS, SSIS, XML, T-SQL, .NET, MS Word and Excel, SQL Profiler, Toad.

Confidential

OBIEE Developer

Responsibilities:

  • Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
  • Analyzed the specifications provided by the client, understanding the business.
  • Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
  • Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
  • Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
  • Specified Dimensional hierarchy, Aggregate levels for the dimensions.
  • Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
  • Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
  • Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
  • Managed Security privileges for each Subject area and Dashboards according to user requirements.
  • Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
  • Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
  • Used DAC (Data warehouse Application Console) for both incremental and full loads.
  • Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
  • Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
  • Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.

Environment: OBIEE 10.1.3, Oracle 10g, Data Warehouse Administration Console (DAC), Windows XP, UNIX/LINUX Oracle 10g, SQL, PL/SQL, SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, XML, MS PowerPoint, MS Access 2003 & Windows

We'd love your feedback!