We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

Richmond, VA

PROFESSIONAL SUMMARY:

  • Over 8+ years of extensive BI Experience in Enterprise Environment in Tableau 2018.1/10.5/ 10.4/10.3 /10.2/10.0/9.3/9.1/8.2/8.0 , Business Objects and QlikView as a BI Developer and Analyst.
  • In - depth knowledge on Tableau Desktop, Tableau Server, Tableau reader, Tableau Cloud, Business Objects 4.1/3/1 and designed several business dashboards and reports
  • Deep experience with design and development of complex Tableau visualization solutions.
  • Created 700+ worksheets and 100+ Dashboards in large Business Intelligence environments using Tableau Software.
  • Experience with utilizing Tableau Prep (2018.1.x) for fast and efficient data cleansing and creating hyper extracts .
  • Experience in Tableau Server Installation, Configuration, Maintenance, Security , creating users, groups, projects, assigning access levels. Production support for monitoring server health.
  • Connected Tableau with Python to provide fast visual analytics solutions with data mapping.
  • Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
  • Used Python to manipulate the data and connect it with Tableau to build analytical dashboards and story points.
  • Good understanding in AWS solutions like EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups.
  • Worked on AWS EC2 Instances Provisioning, VPC setup , Auto Scaling for availability of EC2Instances and availability of applications.
  • Experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS) .
  • Extensive usage of AWS for connecting to data sources on cloud using Amazon Redshift.
  • Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Worked on several interactive dashboards with Filtering, highlighting , ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visualization techniques.
  • Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
  • Published Tableau dashboards on Tableau Server and Tableau Online, embedded them into portal.
  • Combined multiple data sources using blending in Tableau to keep track of sensor data , operator inputs, and real-time systems all in one dashboard.
  • 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.
  • Setup trusted authentication in Tableau server and pass requests from Web server.
  • Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, LODs, dynamic interaction, flexible ad-hoc capability in various functional areas like Health & life science, finance.
  • Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
  • Setup of SSO between Tableau portal and Oracle.
  • Performance tuning for the Tableau Visualizations and Tableau server for more than 250 concurrent users.
  • Experience working on Agile Methodologies.
  • Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop.
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Designed and setup user security for the entire landscape to facilitate Windows AD login and used Tableau CMD for various Dashboard migrations from one environment to another .
  • Expert in installing, configuring tableau server and using Tableau Command line utility for administrative tasks like creating users, groups, projects and permissions.
  • Good understanding of Enterprise Data Warehouse Power insight data .
  • Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
  • Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
  • Experienced in writing queries, stored procedures and functions using.
  • Experience in configuring Tableau Server to use an external identity provider (IDP) to authenticate Tableau Server users over SAML to provide a Single Sign-On(SSO).
  • DTS packages to SSIS, Package Migration Wizard, and Storage Management .
  • Experience in Database Backup, Recovery and Disaster Recovery procedures .
  • Skilled in translating business requirements into technical designs and specifications .
  • Excellent interpersonal communication, problem solving, documentation, good understanding of business process management and business analytical skills with an ability to adapt modern technology quickly and a strong team player.

SKILL:

  • Tableau 10.5/10.4/10.3 /10.2/10.0/9.3/9.1/8.2/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
  • SAP-BI, BW, SAP BOBJ 4.0/3.1, SAAS
  • SPLUNK, C, C+ +, Java, Python, Django, Visual Basic, ASP.NET, SQL, PL/SQL.
  • UNIX, LINUX, Web Sphere, Apache/Tomcat.
  • Data Warehousing: BW 3.5, 3.1c, 3.0b, BI 7.0Oracle 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5 , Access, DB2, Teradata
  • ABAP/4 and Web Technologies, SAP R/3 4.7, 4.6c, 4.5b and 3.x.
  • HTML, CSS, JavaScript, AWS

WORK EXPERIENCE:

Sr. Tableau Developer

Confidential, Richmond, VA

Responsibilities:

  • Designed, developed, maintained Tableau functional reports based on the requirements of the user.
  • Experience in design and development of Tableau visualization solutions.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (10.5, 10.4/10.3/10.2/10.1/9.3/9.2 ). and Tableau
  • Experienced in creating the groups, users, workbooks and permission sets for the tableau server logons and checks
  • Hands on development in assisting the users in creating the worksheets and modifying them and data visualization dashboards.
  • Designed, developed and tested various Tableau/Tableau visualization for dashboard and ad-hoc reporting solutions.
  • Preparing Dashboards using the calculations, parameters in the Tableau and creating SQL datasets for Tableau and Ad-hoc reports.
  • Expert on creating the report schedules on Tableau server.
  • Developed story telling boards in desktop and published in to the server which allowed users to understand the data with the filters when they needed certain information.
  • Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau
  • Extensive experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Proficient in developing Entity- relationship diagrams, star/snow flake schema designs and expert in modelling the transactional databases and data ware house.
  • Provided production support to Tableau users and written custom SQL to support business requirements.
  • Blended the data from the different databases in to one report by selecting the primary keys from each database for the data validation.
  • 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.
  • Involved in creating the ad hoc analysis and reporting requests in a timely manner for BML Risk related to the fraud approvals - yearly, monthly and daily.
  • Mastered the ability to design, develop and deploy effective dashboards and rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters, actions using Tableau.
  • Installing Tableau Server in an enterprise level for substantial number of Global users with a Governance principle.
  • Assisting users with questions and issues using the Tableau, working with various infrastructures teams and Tableau team to help the response time of dashboard.
  • Working with Data Architecture, Security Architecture, SSO team, AD team and Infrastructure SME’s to ensure that all aspects of the solution architecture are defined and elaborated.
  • Performance monitored and tuned the Tableau reports.
  • Involved in reviewing the requirements and data sources from the MS Excel for the design, development, production of reporting and the analysis projects with in Tableau Desktop.
  • Worked extensively with Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
  • Evaluated bug fixes and identified the changes from 10.3 to 10.4 and digested the customer accordingly.
  • Involved in Trouble Shooting, Performance tuning of reports with the huge queries using query execution for better performance and resolving issues within Tableau/Tableau Desktop/Server Reports.
  • Tested dashboards to ensure data matching per the business requirements and any changes in the underlying data.
  • Perform Linux scripting to move the files from one location to other
  • Perform complex T-SQL scripting on MS SQL server 2015/2016
  • Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality

Sr. Tableau Developer/ Data analyst

Confidential, Baltimore, MD

Responsibilities:

  • Designed, developed, tested, maintained Tableau functional reports based on the user requirements.
  • Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
  • Provided 24/7-production support for Tableau users.
  • Delivered POC on Tableau. And successfully Deployed the reports in Prod.
  • Extensively involved in creating graphs by using measures and the dimensions data from the multiple databases by using the data blending concept.
  • Created Scatter plots, Stacked Bars, Box and Whisker plots using, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
  • Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions
  • Created executive dashboard sourcing the heterogeneous sources extracting 15 million records with the decent performance.
  • Used Tableau URL Actions to navigate from main to detailed reports of the dashboards.
  • Setup and configuration of Tableau server 10.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices
  • Expertise in working with the data building Groups, hierarchies and the sets.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Developed custom functions Data range, Time functions, array functions and conditional formatting functions in the reports
  • Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
  • Converted Xcelsius dashboard to Tableau Dashboard with high visualization and good flexibility.
  • Worked with business team and technology team in understanding the requirements and then translating them to the Technical design and detail design documents.
  • Used functions like select, where and prompt functions to create prompts, which helps the user to select the values dynamically.
  • Integration experience of SAP HANA with Tableau 9.3 and 10.0 for high performance Visualizations, Dashboard analysis
  • Robust MS Access and Excel skills with Power Pivot, Pivot table, Pivot Charts, Power View, Tableau functions and formulas.
  • Provided production support to the Tableau users and wrote custom SQL to support business requirements.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Created business driven dashboards using different chart types like Crosstab's, Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullets, Bullet Graphs, Highlight tables and Histograms in Tableau Desktop.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, Ad-Hoc business views along with user acceptance test and data accuracy test.
  • Created different KPI using the calculated key figures and parameters.
  • Developed multiple dashboards with Tableau depicting differing KPIs for business analyses.
  • Responsible for creating calculated fields, combine field, bins, sets, geo coding using the Tableau Desktop.
  • Defined best practices for Tableau report development.
  • Involved in creating dual axis bar chart with the multiple measures.
  • Strong verbal and written communication skills, ability to work effectively with user departments.

Tableau Developer

Confidential, Washington, DC

Responsibilities:

  • Building, publishing customized interactive reports and dashboards , report scheduling using Tableau server.
  • Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server per best practices.
  • Connected Tableau with Python to provide fast visual analytics solutions with data mapping. Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
  • Connected to the Amazon Redshift (AWS) directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
  • Used Tableau with AWS cloud connecting to AWSEMR and Amazon Redshift (AWS).
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Related views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
  • Setup trusted authentication in Tableau server and pass requests from Web server.
  • Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts ) based on client’s need.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.
  • Coordinated database middleware issues with DBA's, system performance with System Architects.
  • Involved in license management SLA's with Tableau support.
  • Converted existing Cognos Reports into Tableau Dashboards.
  • Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
  • Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

Tableau Developer

Confidential, NYC

Responsibilities:

  • Understand the requirements and functionality of the application from the specifications.
  • Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server per best practices.
  • Mastered the ability to design and deploy rich visualizations with Drill Down and Drop-down option using Tableau.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Related views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
  • Setup trusted authentication in Tableau server and pass requests from Web server.
  • Worked extensively with Advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics and table calculations.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
  • Organized data in the repots by using Filters, Sorting, Ranking and highlight data with Alerter.
  • Performance tuning of Business Objects including testing and modification of universe objects as required
  • Used Alteryx to wrangle or blend data (on need basis) and Tableau to develop the dashboard and finally publishing via Tableau Server.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Worked on Universes Query Panel, Prompts and reports layout and re formatting.
  • Used star and snow flake schema in the data modelling phase, created Aliases for the Loops that are Resolving with the development of the tables, stored procedures and functions for data processing and manipulation.
  • Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
  • Install upgrade Tableau server and server performance tuning for optimization.
  • Proof read all the documents and maintain accuracy of information and preparing SOP.
  • Involved in license management SLA's with Tableau support.
  • Represented portfolio data as a tree map based on the margin, detailed application data is represented as a column graph with highlight table distributing margin across the roles of an employee
  • Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Customized tool tips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue, expense and margins as currency values.
  • Utilized pages cards to create animated visualizations to understand growth of the margin with respect to revenue and expense over the time
  • Setup user security for the entire landscape to facilitate Windows AD login.
  • Worked heavily using Tab-admin tools and Tableau CMD for setting up security profiles for various User groups and Users.
  • Required activities included planning, design and installation of RDBMS systems both locally and on the AWS cloud for both application and project
  • Used Tableau with AWS cloud connecting to AWSEMR and AWS Redshift.
  • Worked on Setting up Tableau Server on AWS.
  • Actively involved in the Server migration and the Tableau Server Installation process.
  • Used Elastic Load Balancing to distribute requests across multiple gateways in a Tableau Server cluster.
  • Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

BI/Tableau Consultant

Confidential, Chicago, IL

Responsibilities:

  • Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
  • Converting high-level design specifications to detailed functional and technical specifications.
  • Responsible for writing complete requirement document by interacting with business directly to ascertain rules and logic of the business
  • Independently worked on owning IT support tasks related to the Tableau reports.
  • Created the Backup scripts to take backups periodically for the content on the tableau server.
  • Administer user, user groups and scheduled instances for reports in Tableau.
  • Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
  • Maintaining and updating database models, generating or modifying the database schemas Data Mapping and DWH loading Use case analysis. Database coding and implementation.
  • Created Users, adding the users to the site, adding users to group viewing, editing and deleting the users, activating the licenses, installing worker servers, high availability
  • Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
  • Developed and modified Business Intelligence analytical reports/ dashboards dealing with Origination, Portfolio Risk, Consumer Credit, FP&A and Marketing using Tableau desktop.
  • 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.
  • Hands on building groups, hierarchies, sets to create detail level summary reports and dashboard using KPI’s
  • Created and developed parameterized, drill down and ad hoc repots using SQL Server Report Services(SSRS)
  • Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
  • Hands on development assisting users in creating and modifying worksheets and data visualization dashboards
  • Expert level capability/capacity in calculations in Tableau and applying the complex data sets
  • Worked on creating Universes using the Business Objects and connected to the database using ODBC.
  • Upgraded Business Objects Universes, User groups, and reports from Version 5x to 6x.
  • Using SSRS, Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports, Cross-Tabbed Reports.
  • Scheduled extract refresh for weekly and monthly reports
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau/ SSRS.
  • Worked on workbook permissions, ownerships and user filters.

BI Consultant

Confidential

Responsibilities:

  • Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Consistently attended the meetings with SME’s of the client to acquire the functional requirements.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Got involved in designing the Data model for the Data warehouse and for different Data marts
  • 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 tableau.
  • Worked on motion chart, Bubble chart, drill down analysis using tableau desktop
  • Created custom function’s data range, Time functions, array functions, in the reports.
  • Involved in created stored procedures, views, and custom SQL queries to import data from DQL server to tableau.
  • Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
  • Developed dimension-based reports, drill - down reports, matrix reports, charts, Tabular reports using Tableau desktop.
  • Connect to MySQL directly, created the dimensions, hierarchies, level on the Tableau desktop
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows
  • Creating organized, customized analysis and visualized projects, dashboards to present to upper level.
  • Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
  • Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards
  • Use of designer module to implement Universe, Linkages between Tables, create prompts and queries, parse the universe and alias tables to remove cyclic dependencies
  • Develop and maintain reporting and analytical tools, including Business Objects
  • Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental
  • Lead BI work stream projects in the implementation and use of new BI software tools and systems.
  • Performed End to end testing using SQL Queries in Oracle.
  • Analyzed reports using Slice and dice, drill down, cross tab, master detail and formula’s
  • Work experience in advanced Xcelsius concepts like, what if analysis, dynamic visibility, narratives, interactive charts, hierarchies and experience in connecting Xcelsius/ QaaWS, live office
  • Monitoring the project during development phase and involved in UAT once the change requests are released from system testing
  • Ability to work quickly and under tight delivery deadlines with focus on details.

Hire Now