We provide IT Staff Augmentation Services!

Tableau Admin/ Tableau Developer Resume

CO

PROFESSIONAL SUMMARY:

  • 7 years of experience as Tableau Developer, Tableau Administrator, data analysis, report development and Microsoft SQL server 2012/2008 - R2/2008/2005 in development, testing & production environment.
  • Deep experience with the design and development of Tableau visualization solutions.
  • Worked a great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
  • Expert in evaluating data models to design Tableau solutions. Responsible for developing interactive data visualizations.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Expertise in maintain and installed Tableau Server in multiple clustered.
  • Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
  • Perform software sync activities like planned upgrades, Configuration changes and patch deployments.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Expertise in designing and creating various analytical reports and interactive Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Professional in communicating Dashboards per Tableau visualization features.
  • Installed and upgraded Tableau server and server performance tuning for optimization also worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
  • Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
  • Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
  • Strong ability in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
  • Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
  • Installation and Configuration of Tableau Server and Tableau Desktop on Windows.
  • Ensured maintenance and security control of the Tableau products and solutions.
  • Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.
  • Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
  • Possess an Agile mindset. Gather data and provide Agile metrics
  • Engaged in lightweight Agile program management.
  • Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS 2005/2008 Packages with proper control flow and data flow elements by using MS SQL Server 2012/2008-R 2/2008/2005.
  • Good experience in generating Sub-Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS 2012/2008-R 2/2008/2005.
  • Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.
  • Self-learning ability, Leadership Quality, good team player and determination to learn new technologies and maintain positive relationships at all business levels.

TECHNICAL SKILLS:

Business Intelligence: Tableau Server 10/9/8, Tableau Desktop, Tableau Reader, Tableau Public, Tabcmd, Tabadmin, Alteryx, SSIS 20012/2010/2008, SSRS 20012/2010/2008 /, DTS, Crystal Reports, Microsoft Visio 10.0/11.0, ERWIN 10/9/8, OBIEE, Qlikview.

Database: MS-SQL Server 2012/2008R2/2008/2005, PostgreSQL, Redshift, Oracle9i/10g, Microsoft Access.

Programming Language: MS-SQL, C, C++, HTML, CSS, PL/SQL

Operating System: Windows XP/Vista, Windows 7/8/2003/2000

PROFESSIONAL EXPERIENCE:

Confidential, CO

Tableau Admin/ Tableau Developer

Responsibilities:

  • Involved in installation, configuration and Upgradation of Tableau Server.
  • Involved in planning, defining and designing data based on business requirement and provided documentation for further references.
  • Developed interactive data visualizations and developed automated processes for updating contents.
  • Created incremental refreshes for data sources, extracts and views on Tableau server.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Worked with alerts and subscriptions and schedule extracts on Tableau server.
  • Created Users Groups Projects Workbooks and assigned Access levels in Server.
  • Conducted Training sessions for Tableau Power users and created the documents for end user support
  • Creating users groups projects Data connections settings as a tableau administrator.
  • Involved in creating dashboards and reports in Tableau 10 and maintaining server activities user activity and customized views on Server Analysis.
  • Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
  • Monitored VizQL server, Application Server and data server activity to track performance and system stability.
  • Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
  • Automated and enhanced daily administrative tasks including database backup and recovery.
  • Performed extensive GAP analysis in the project.
  • Administered user, user groups using active directory and scheduled instances for reports in Tableau
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
  • Configured Cache settings for performance tuning of the reports, dashboard on server level.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
  • Involved in creating dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop.
  • Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
  • 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.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Created reports on data monitoring loaded into the data warehouse through from site.
  • Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
  • Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, Hadoop, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static.

Tools: & Technologies: Tableau Server 9/10.1, Tableau Desktop 10.1, Tabcmd, Tabadmin, MS SQL Server 2012.

Confidential, Charlotte, NC

Tableau Developer/ SSIS Developer

Responsibilities:

  • Worked as Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
  • Performed ETL mappings using MS SQL Server Integration Services.
  • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate and Slowly Changing Dimension, Merge Join and Union all.
  • Used for-each Loop Container, sequence container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
  • Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, complex data sets.
  • Evaluated data models to design Tableau solutions by created different KPI using calculated key figures and parameters.
  • Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
  • Created MDM dashboards to provide the critical information to the organization.
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
  • Utilized Data Blending tool like Alteryx, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Involved in developing finances KPI reporting.
  • 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.
  • Involved in trouble shooting of performance issues which were associated with Tableau reports.
  • Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
  • Maintained and installed Tableau Server in multiple clustered.
  • Installed and upgraded Tableau server in different version and server performance tuning for optimization
  • Expertise in Tableau server and data source administration, WDC(web data connector) including upgradation, patches, monitoring, troubleshooting, performance tuning, Cluster/Distributed Management, Cache/ History Management, User Management and change management. Creating and managing Tableau Sites, projects and workbooks.
  • Provided support for Tableau developed objects and Tableau security, back-up and restore process.
  • Created incremental refreshes for data sources on Tableau Server.
  • Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
  • Implemented parameters, quick filters and sets to display performance of different attributes.
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Used commands in Tabcmd and Tabadmin utility tool for Tableau Server maintains and configurations.
  • Published Workbooks and Dashboards to the Tableau server.
  • Combined visualizations into Interactive Dashboards and publish them to the web by created groups and users in Tableau server.

Tools: & Technologies: Tableau Server 9.2, Tableau Desktop 9.2, TabCMD Tabadmin, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source Erwin r8, HTML.

Confidential, White Plains, NY

SSIS Developer/ Tableau Developer/ Admin

Responsibilities:

  • Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
  • Develop automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS).
  • Developed SSIS packages for ETL from OLTP and various sources to and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more.
  • Developed and deployed SSIS packages for ETL from Oracle Materialized Views to fetch HP-PPM timesheet data load into staging and staging to Data warehouse using master package to call all child package.
  • Built compelling, interactive dashboards in Tableau that answer key business questions.
  • Audited the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
  • Mentored less experienced Tableau reporting specialists.
  • Maintained and installed Tableau Server in multiple clustered.
  • Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
  • Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
  • Installed and upgraded Tableau server in same version and server performance tuning for optimization.
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Formed Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau.
  • Converted charts into Crosstabs for further underlying data analysis in MS Excel.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Used commands in Tabcmd and Tabadmin utility tool for Tableau Server maintains and configurations.
  • Published Workbooks and Dashboards to the Tableau server.
  • Combined visualizations into Interactive Dashboards and publish them to the web by created groups and users in Tableau server.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

Tools: & Technologies: Tableau 8.2/9, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, OBIEE, Alteryx, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source, Erwin r8, Ultra Edit tool, SharePoint, C++.

Confidential, Atlanta, GA

Tableau Developer/ SSIS Developer

Responsibilities:

  • Worked as Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
  • Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.
  • Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
  • Possess an Agile mindset. Gather data and provide Agile metrics
  • Engaged in lightweight Agile program management.
  • Created action filters, parameters and calculated sets for preparing Analytical dashboards and worksheets for LOB mangers in Tableau.
  • Building, Performance tuning and then publishing customized interactive reports and dashboards using Java API on server.
  • Effectively used data blending tool Alteryx 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.
  • 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.
  • Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access).
  • Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
  • Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
  • Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
  • Experienced in Error handling and debugging coding issues and troubleshoot production problems.
  • Expertise SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
  • Well-versed in usage of SSIS Control Flow items (for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
  • Develop SSIS package for implement Slowly Changing Dimension. Fact Load and Dimension Load, Incremental Load.

Tools: & Technologies: Tableau Desktop 8.1, Tableau Server 8.1, Tabcmd, OBIEE, Sales force MS SQL Server 2012, MS SQL Server Integration Services,OBIEE, Alteryx, MS SQL Server Reporting Services, MS Visual Studio 2010, Oracle 10g, Erwin r8, C#.

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

  • Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
  • Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
  • Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
  • Optimized existing stored procedures and various T-SQL queries.
  • Wrote Dynamic Store Procedure to move data from Staging to Application.
  • Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Added more audits and alerts in SSIS Packages in case of package failure.
  • Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files.
  • Managed index, statistics and optimize queries by using execution plan for tuning the database.
  • Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc. to clean data.
  • Developed Master Child package using variables and Execute package task in SSIS.
  • Scheduled jobs to call the packages and Stored Procedures as per business requirement.
  • Deployed, tested and scheduled SSIS packages using SQL Agent.
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
  • Deployed and scheduled Reports using SSRS to generate all reports including current status.
  • Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Tools: & Technologies: MS SQL Server 2005, SSRS, SSIS, VB.Net, EXCEL, MS Access, ORACLE 9i,10g, Erwin Data Modeler v7.0/v4.x.

Hire Now