We provide IT Staff Augmentation Services!

Sr. Tableau Developer/admin Resume

The Woodlands, TX

SUMMARY

  • Competent IT Professional with 8+ plus years of extensive experience in Tableau, Business Intelligence, Oracle SQL and ETL Developer within the Oil and Gas, Manufacturing, Food, Finance, Designing industries.
  • Around 5+ years of experience in Tableau.
  • Worked on different Tableau versions (Tableau 10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.2/9.1/8.0/7.0 ), Tableau server, Tableau online, Tableau public, Tableau reader and SAP BI/BO. Having In - Depth knowledge on Tableau 10.5.
  • Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications, creating dashboards, designing Universes, Full Client/Web reports etc.
  • Used Tableau CMD for various Dashboard migrations from one environment to another.
  • Used efficient load balancing techniques to manage the load on the server for concurrent user logins.
  • Created automated scripts for tableau workbook refresh when not using live connections
  • Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
  • Good knowledge in connecting and extracting Cloudera Hadoop and SAP Hana to Tableau.
  • Experienced in managing schedules and scheduling workbooks and activities on Tableau Server
  • Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
  • Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
  • Preparing Dashboards using calculations, parameters in Tableau
  • Extensive knowledge in various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters, Level-of-Detail (LOD) expressions etc., in Tableau.
  • Implemented Binning & Blending concepts in my Tableau Reports.
  • Worked on setting permissions on content for specific users or group on a per site basis.
  • Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Expertise in web integration of Tableau Reports with HTML or Asp.Net.
  • Proficient in design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Pareto Charts, Dual Axis, Blended Axes, Scatter Plots, Bar in Bar, Box Plot, Bullet Chart, Gantt Chart, Heat Map, Spark Line, KPI Charts.
  • Expertise in creating MicroStrategy documents, Grid reports, dashboards for various business environments.
  • Expertise in Developing Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports.
  • Experience in Performance Optimization of MSTR Reports, using Intelligent Cubes for better performance and to reduce the load on Database.
  • Experienced in building solutions to enable self-service BI by architecting ADHOCMicroStrategy schema.
  • Strong Knowledge of Business Intelligence (BI), Data Warehousing &ETL.
  • Excellent knowledge on Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report.
  • Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Colour, Fonts and Tooltips.
  • Installed and setup cluster environment for Tableau server and used J meter for load balancing and load analysis.
  • Experience in working on different data warehousing methodologies including star schema and snowflake schema, ETL processes, dimensional modelling, reporting tools.
  • Experience in software systems Development client/server Business systems with 5 years of strong Data Warehousing experience in Extraction, Transformation and Loading (ETL) using IBM Information server 8.5/8.1. Business Reporting/Business Intelligence processes (Business Objects BI 4.0).
  • Experience in using Custom SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions.
  • Involved in complete Software Development Lifecycle (SDLC) by identifying the business requirements and converting them to tableau design.

PROFESSIONAL EXPERIENCE

Confidential, The Woodlands, TX

Sr. Tableau Developer/Admin

Responsibilities:

  • Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
  • Installation of Tableau Server on Single Server as well on the distribution environment
  • Installed Primary server and Worker nodes for high availability, performance and scalability of the environment
  • Configured Tableau server with Active Directory as the Authentication Source.
  • Maintaining Security and Create/manage Users, Groups, Licenses and integrate with Active directory.
  • Installed and configured Tableau desktop 9.0 along with silent mode features and migrated Tableau reports from 9 to 10.0 Version.
  • Built functionalities by writing condition to incorporate with various metrics and hands on experience in Level of Detail Expressions (LOD’s) such as Daily profit KPI, Percent of total, yearly trending analysis and root cause behavior.
  • Writing complex SQL queries on Teradata handling source data challenges and adapting to the dynamic nature of the project.
  • Developed various reports using SQL for Inventory Management and Innovations team in accordance with Business Strategies.
  • Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
  • Involved in reviewing business requirements and analyzing data sources from Excel/MySQL, AWS Amazon Redshift for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Designed and deployed interactive reports with Drill Downs, Drop down menu option, Parameters and Linked reports using Tableau
  • Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
  • Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters.
  • Working knowledge in Hadoop HDFS Admin Shell commands.
  • Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Develop parameter-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop
  • Migrated all dashboards from Tableau 9.1 to 10.1
  • Used SQL tools like Squirrel and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.

Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0, Amazon RedShift

Confidential, San Antonio, TX

Tableau Developer/Admin

Responsibilities:

  • Basic understanding of financial instruments, accounting concepts, Hedge Fund Industry.
  • Responsible to Create Dashboards for compliance reports, treasury reports, Daily P&L reports for Client and internal management using Tableau Desktop and Server.
  • Prepare financial statements for all funds on the monthly, quarterly, and yearly basis.
  • Involved in migration reports from various reporting tools like Spot fire, QlikView, and OBIEE to Tableau.
  • Involved in migration reports from Oracle BI Publisher to Tableau. And involved in Data extraction and transformation to Oracle BI to Tableau
  • Implemented Installation of Tableau Desktop 9.0/8.3 and Tableau Server.
  • Used Trend Lines, Reference Lines and Annotations to describe the data. Created Data extracts for better performance and accessing data offline.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Monitored Tableau Servers for its high availability to users and provided availability accordingly.
  • Worked on Tableau Server upgrades for new versions .
  • Managed Tableau extracts on Tableau Server and administered Tableau Server.
  • Used Microsoft Azure SQL Data warehouse which facilitated reading, writing and managing large data sets residing in distributed storage.
  • Analyzed data in the Microsoft Azure SQL Data Warehouse along with working on determining additional fields and data points that need to be added
  • Had good knowledge and experience in Data Modeling. Used parameters and input control to give users control over certain values.
  • Worked extensively on setting up groups, roles and user permissions in Tableau Server.
  • As a Site Level Admin created Project folders & assigned permissions for respective Active Directory groups
  • Manage the application’s users, groups, and integration with Active Directory
  • Experience in taking back ups and restoration of Tableau repository
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Created complex calculation using Table Calculation, Date, Aggregate functions in Tableau.
  • Providing support once the dashboards were published if there were any data changes, system changes, or requirement changes.
  • Assisting QA team in creating Test Cases, Test Scenarios and working closely with QA team in managing all the reported defects.
  • Working closely with the Business teams in organizing Training for UAT Sessions and assisting business teams to write use cases throughout UAT Phase.
  • Assist managers in meeting client expectation by monitoring timely delivery of daily, weekly and monthly deliverables.
  • Involved in integration of Tableau JavaScript API Filters in web application
  • Publishing Reports, workbooks & data source to the server and export the reports in different Formats.
  • Effective oral and written communication. Ability to engage meetings/calls with clients/counter parts in other groups.

Environment: Tableau Desktop 7.0, Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, Microsoft office 2007.

Confidential, Cincinnati, OH

Tableau Developer

Responsibilities:

  • Interacted with business user group for domain requirements gathering.
  • Gathered user requirements, analysed and designed software solution based on the requirements.
  • Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
  • Interacted with Business Analysts and Data Modellers and defined Mapping documents and Design process for various Sources and Targets.
  • Involved in defining the whole project life cycle, following agile methodology. Analyse business requirements and segregated them into high level and low level.
  • 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.
  • Developed Standard Operating Procedures (SOP) for Monitoring.
  • Extensively used data blending, embed functionalities in Tableau.
  • Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
  • 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.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
  • Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create, customize and share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Environment: Tableau Desktop/Server 6.x-7.x, SQL Server 2008, SSRS, HPQC, Oracle 11g, SQL, PL/SQL, T-SQL, Microsoft office 2007.

Confidential, Mc Lean, VA

Tableau Developer

Responsibilities:

  • Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
  • Involved in end-to-end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
  • Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
  • Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
  • Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
  • Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
  • Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
  • Worked with the design and development of end user applications for the data presentation and analytics, including dashboards, reports and graphic presentation.
  • Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory.

Hire Now