Tableau Developer
Sama

Professional Summary


  • More than 7 years of IT experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
  • Experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, documentation, implementation and maintenance.
  • Experience in the Development, Implementation of Database/Data Warehousing, BI Analytics and Dashboards applications using Data Extraction, Data Transformation, Data Loading, Data Visualization and Reporting tools.
  • Created, modified, and administered analytics Intelligence Dashboards with links to web sites, HTML text, links to documents and embedded content such as images, text, charts, and tables in Tableau.
  • Built Tableau dashboards using heat maps, treemaps, circle views, bar charts, lines, pie charts, area charts, box and whisker, gantts, bubbles and highlight tables, symbol and filled maps according to deliverable specifications.
  • Worked on data blending and increased the dashboard performance by extracting data.
  • Worked on different table calculations for different Scorecards.
  • Expertise in Performance Tuning Tableau reports.
  • Developed Interactive dashboards which helped business get a good handle on the team's productivity.
  • Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards
  • Expertise in Tableau server installation, Configuration and enforcing security in Tableau.
  • Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), OLAP SAP BW, MS Excel, MS Access, Teradata, Netezza, Hive and DB2.
  • Highly Proficient in Agile, Waterfall and Scrum software development life cycle.
  • Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
  • Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, SQL Loader.
  • Well versed in query optimization for performance tuning and monitoring of processes.
  • Experience working as a BI Consultant with specialization in Business Objects 6.5/ XI3.1/ Crystal XI/2008 and Web Intelligence.
  • In-depth knowledge in building/maintaining Repository, Universes and creating adhoc reports.
  • Broad experience in resolving universe issues like Loops and Traps using Alias and context.
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
  • Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

Technical Skills

Programming Languages
T-SQL, XML, HTML, PL/SQL, C++
Business Intelligence tools
Tableau, SSAS, SSIS, SSRS, Informatica, Web Intelligence, BO 6.5/XI3.1, Crystal Reports XI/ 2008, Alteryx 9.5/10, Toad.
Database
SQL Server2005/2008/2008R2, Oracle 11g/10g/9i, Netezza, Redshift, TrackWise, Teradata, Hive, MySQL, DB2.
Operating Systems
Mac OS X, Windows XP, Windows NT / 2000, Windows 7, Unix.

Education

  • BS in Information Technology

Professional Experience

Facebook, CA
Duration
April 2016 – Till Date
Role
Tableau BI Developer
Responsibilities
  • Interact directly with the business users in gathering and analyzing the requirements.
  • Interact with business subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business needs.
  • Building, publishing interactive reports and dashboards, scheduling reports using server.
  • Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
  • Building Tableau dashboards using stack bars, lines, dual combination, heat maps, tree maps, symbol maps, filled maps, horizontal bars according to deliverable specifications.
  • Effectively used data blending feature in tableau.
  • Designed and developed graphic rich visualizations with Drill Down and Drop Down menu option.
  • Developed Dashboards with Advanced Tableau Mapping Techniques.
  • Develop adhoc reports for users.
  • Defined best practices for Tableau report development.
  • Involved in automation of jobs in Tableau.
  • Working on data sources such as Oracle and Hive.
  • Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards.
  • Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.
  • Configuring the analysis for scheduling auto emails from Tableau automation.
Environment
Tableau 9.2/9.3, Oracle, Oracle SQL Developer, Hive, OBIEE, Microsoft office 2016, Mac OS X.
Cablevision, Bethpage, NY
Duration
April 2015 – March 2016
Role
Tableau Developer
Responsibilities
  • Interact directly with the business team in gathering the requirements.
  • Analysis of BRD, design, documentation, estimations and technical specifications.
  • Created Tableau dashboards using heat maps, stack bars, lines, area charts, scattered plots, geographical maps using show me functionality.
  • Created Groups, Hierarchies, Sets for detail level summary reports and dashboards using KPI’s.
  • Worked extensively with Advance Analysis Actions, Calculations, Parameters, Trend Lines and Reference Lines.
  • Worked on Motion chart and Drill down analysis.
  • Developed dashboards with multiple data by data blending.
  • Developed Interactive (Dynamic) dashboards, adhoc reports for users.
  • Involved in the migration of OBIEE reports to Tableau.
  • Involved in the migration of Oracle Discoverer reports to Alteryx Apps.
  • Developed Dashboards with Advanced Tableau Mapping Techniques.
  • Involved in automation of jobs in Tableau.
  • Worked on various data sources such as Netezza, Redshift and Oracle.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Resolved various performance issues and analyzed the best process distribution for different projects.
  • Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.
  • Configuring the analysis for scheduling auto emails from Tableau automation.
Environment
Tableau Desktop 8.3/9.0/9.1, Alteryx 9.5/10, Oracle, Netezza, Redshift, Toad, Microsoft office 2010, Windows 7.
Stryker, Kalamazoo, MI
Duration
October 2014 – March 2015
Role
Tableau Developer
Responsibilities
  • Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
  • Development of new dashboards from the existing cubes.
  • Responsible for recreating reports and dashboards.
  • Creating reports for Metrics.
  • Strong analysis skills to understand the existing report specifications and translate those into new reports created with Tableau.
  • Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Developed multiple reports/dashboards using Dual Axis charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
  • Creating and modifying worksheets and data visualization dashboards.
  • Export of Data from TrackWise.
  • Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
  • Develop Scripts to load data into tableau and work with multiple data by data blending.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Generate context filters and use performance actions while handling huge volume of data.
  • Create complex reports using multiple queries and sub queries.
  • Co-ordinated Tableau TWBX files till UAT/Production environments.
  • Provided tableau desktop training for end users.
  • Worked with end users in creating complex dashboards in an iterative process.
  • Configuring scheduled updates (Automatic and User notified) for optimal performance.
Environment
Tableau Desktop 8.2/8.3/9.0, TrackWise 8.4.11, ANSI SQL, SSAS, SQL 2008R2, Informatica, Microsoft office 2010, Windows 7 enterprise.
Advanced America, Spartanburg, SC
Duration
December 2013 – October 2014
Role
Sr. Tableau Report Developer
Responsibilities
  • Gathering requirements from functional team.
  • Review the solution documents, design and technical specifications.
  • Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies in Tableau.
  • Created, customized & shared interactive dashboards.
  • Developed dashboards by data blending, if the data is from multiple data sources.
  • Migrated existing Cognos Reports into Tableau Dashboards.
  • Worked on various data sources such as Teradata and Oracle.
  • Used JavaScript API to create filters and customize the views.
  • Defined best practices for Tableau report development.
  • Provided tableau desktop training for the business team and end users.
  • Helped in designing Data-warehouses/ETL workflows required for the reporting applications.
  • Administered user and user groups for reports in Tableau.
  • Created incremental refreshes for data sources on Tableau server.
  • Hands-on development assisting users in creating and modifying worksheets and dynamic dashboards.
  • Access dashboards from any browser or tablet.
  • Scheduled auto emails from tableau automation to end users, once the dashboard gets refreshed.
Environment
Tableau 8.1/8.2, Oracle 11g, Teradata, Cognos, JavaScript, Crystal Reports 2008, Microsoft office 2010, Windows 2007.
AT&T, Dallas, TX
Duration
September 2012-November 2013
Role
Tableau Lead Developer
Responsibilities
  • Involved in requirement gathering from the on-site team leads.
  • Analysis, design, development, testing and production rollover of reports and dashboards.
  • Created joins, filters for fetching data into Tableau as per the business needs.
  • Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.
  • Generated tableau dashboards for sales with forecast and reference lines.
  • Built complex formulas in Tableau for various business calculations.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Published the dynamic dashboard reports to Tableau Server for navigating the developed dashboards in web.
  • Scheduled the updating of dashboards from Tableau Server on daily/weekly/monthly basis.
  • Sending the dashboards to users by emails with the help of admin team with subscriptions.
  • Given training/demos to users on Tableau Desktop for interacting and viewing the published dashboards and development of new dashboards.
  • Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Administered user, user groups and scheduled instances for reports in Tableau.
Environment
Tableau 7.0/8.0, MySQL Server, Oracle 10g, DB2, Microsoft Office 2010, UNIX, Visual Studio 2010.
Union Bank, San Francisco, CA
Duration
October 2011 - August 2012
Role
Tableau Dashboard Consultant
Responsibilities
  • Interacted with business users for gathering requirements and look and feel of the applications to be developed.
  • Developed various dashboards using hierarchies, groups, calculated fields and parameters.
  • Used excel sheet, flat files, CSV files to generated Tableau reports.
  • Generated Dashboards by joining multiple complex tables.
  • Generated dashboard for Finance team, provided security by using user filters.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Embedded Tableau views into SharePoint.
  • Worked on performance tuning of various OBIEE Reports / Dashboard.
  • Performed queries to fetch new data and create reports in Business Objects XI3.1 by connecting to Oracle Data Sources.
  • Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports.
  • Involved in migrating reports using the report migration utility.
  • Created and maintained Business Objects & Web Intelligence reports.
Environment
Tableau 6.0, SAP Business Objects XI3.1, Crystal reports, SQL Server 2008, XML, Windows XP, UNIX, Oracle 10g, MS-Excel 2007.
Invesco, Hyderabad, Andhra Pradesh
Duration
July 2009 - September 2011
Role
Business Objects Developer
Responsibilities
  • Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects.
  • Created Aliases, Multiple contexts for catering different functional areas in a single user query.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Customized LOVs in Universes for quicker performance of reports.
  • Interacted with the Business Users to analyze the business process and gathered the requirements, made necessary changes to schema objects to fulfill their reporting and business needs.
  • Experience in universe migration across repositories.
  • Performed queries to fetch new data, and create reports in Business Objects 6.5 by connecting to Oracle Data Sources.
  • Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
  • Used calculations, variables, breaks, sorting, filters, alerts and prompts while developing and creating reports.
  • Involved in migrating reports and universes from 5.x to 6.5 and Web Intelligence reports using the report migration utility.
  • Created and maintained Business Objects & Web Intelligence reports.
  • Created reports based on PL/SQL.
  • Published existing reports to corporate intranet through Web Intelligence.
Environment
Business Objects 6.5.1, Web Intelligence 6.X, BCA 6.5, Oracle 9i, Microsoft Excel, HTML, Windows XP.