We provide IT Staff Augmentation Services!

Tableau Developer/bi Consultant Resume

San Diego, CA

PROFESSIONAL SUMMARY:

  • 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
  • Extensive Tableau experience in enterprise environment, in tableau 7.x, 8.x, 9.x, 10.x as a developer analyst with in - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Preparing Dashboards using calculations, parameters in Tableau 7.0/8.1.
  • Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
  • Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Deep technical knowledge of the Qlik view Platform to design and develop dashboards and visualizations.
  • Experience in various integration options using Tableau Desktop, Tableau Server and Tableau Reader to minimize overall end user licensing requirements.
  • Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2 and SQL Server.
  • Developed and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
  • Created various reports like Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc using BIDS.
  • Experience in Data analysis, with good data modeling exposure. I am a great team player and very easy to work with.

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau (Desktop and Server)7.x/8.x/9.x, MSBI, QlikView, Alteryx

Web Technology: HTML, HTML5, CSS

Languages: SQL, PL/SQL, C, JAVA, XCode

Database: ORACLE, MySQL

Operating system: Windows … and MAC OS

Others: Apache Hive, MS Office, NetBeans, Eclipse, Visio

PROFESSIONAL EXPERIENCE:

Tableau Developer/BI Consultant

Confidential, San Diego, CA

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.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • 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.
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL Server to tableau.
  • 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.
  • Having experience in SME (Subject Matter Expert) in all BI tools.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, SAS/SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Tableau Developer

Confidential

Responsibilities:

  • Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
  • Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.
  • Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
  • Developed formatted, complex reusable formula reports.
  • Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
  • Created affinity analysis dashboard and Radical charts for better understanding data.
  • Used Trend Lines, Reference Lines and statistical techniques to describe data.
  • Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts etc.
  • Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.
  • Used Context filters and Created Geographic map reports which explains the company financial keys according to the members.
  • Created Sets, Groups, and Data Bins as per user requirements.
  • Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
  • Created views using various axes like Individual Axes, Dual Axes.
  • Created Data extracts for better performance and accessing data offline.
  • Used parameters and input controls to give users control over certain values.
  • Implemented Data blending with multiple data sources on a single worksheet for data analysis.
  • Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
  • Created and Published Tableau Dashboards into Tableau Server.
  • Writing SQL queries for data validation by using join conditions.
  • Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
  • Provided support for Tableau developed objects and understand tool administration.
  • Involved to create Documentation for debugging report for Tableau.
  • Developed the table documentation for Tableau Dashboards.
  • Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
  • Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
  • Designing excel based reports on tableau.
  • Working with Level of Details expressions and Regular Expressions which are helpful in providing etl functionality for tableau.
  • Migrating reports from standard reporting tools like excel to tableau.
  • Migrating all the reports from tableau 9.3 to tableau 10.3 and publishing them on the server.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, Microsoft SQL Server 2012, MS Excel, MS Access, Windows 2007 server

Tableau Developer

Confidential, CA

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. Effectively used data blending.
  • Worked on Motion chart and Drill down analysis.
  • 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.
  • Worked on various data sources such as Netezza and Oracle.
  • Hands-on development 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.
  • Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
  • Created and Published Tableau Dashboards into Tableau Server.
  • Writing SQL queries for data validation by using join conditions.
  • Created SQL Documentation for Benchmark queries and implemented new methods for better performance.

Environment: Tableau Desktop 8.3/9.0/9.1, Alteryx 9.5/10, Oracle, Netezza, Toad, OBIEE, Microsoft office 2010, Windows 7.

Tableau Developer

Confidential, Florida

Responsibilities:

  • Worked extensively on Tableau Desktop, Oracle and MSBI Tools (SSRS, SSAS, SSIS) mainly for creating reports and dashboards, creating and modifying data as per their requirements in the oracle database.
  • Pulled data from different databases and integrated into a central source using SSIS to get all the needs of the customers in various fields so we can do a better analysis and tweak our suggestions to different customers.
  • Analyzed sales data using SSAS and gave detailed reports of the best products which can suggested to specific set of customers.
  • Created many complex dashboards by extracting data from many different sources using data blending and joining multiple tables in case of merging data from different sources using Tableau and SSRS for a different set of teams.
  • Involved in testing databases using complex SQL and TSQL Scripts.
  • Involved in creating database objects like Tables, Views, Procedures, Triggers and Functions using T-SQL to provide definition, structure and to maintain data efficiency.
  • Interacted with the existing database developers and DBA to understand the existing schema.
  • Automated monthly excel reports into Tableau workbooks and dashboards.
  • Consolidated multiple Tableau workbooks into a single workbook for the company sales division for a better understanding of data at glance.
  • Have created many dashboards with interactive view, trends and drilldowns along with user-level security.
  • Hands-on development in assisting users creating and modifying worksheets and data visualization dashboards.
  • Well documented the entire process of working with Tableau desktop and in evaluating business requirements.

Environment: Tableau Desktop, MSBI Tools (SSRS, SSAS, SSIS), Microsoft Office, Oracle, SQL developer, Microsoft SQL server Management studio.

Hire Now