We provide IT Staff Augmentation Services!

Tableau Developer Resume

Plano, TX

SUMMARY:

  • Over 8+ years of IT experience in Software Development and experience in Tableau Desktop, Tableau Server and Tableau Reader in versions 8.x and 9.0, 10.x.
  • Experience in Financial and Clinical research - based projects.
  • Hands on experience in creating workbooks and dashboards using Tableau Desktop.
  • Publish Tableau Dashboards in Tableau Server, Tableau public Premium.
  • Performed Tableau Server admin duties add users and groups from Active Directory and schedule instances in Tableau Server including weekly data dump.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Extensive experience on building Analytic Dashboards using Tableau.
  • Formulated procedures for installation and configuration of Tableau desktop.
  • Developed quarter over quarter and dual axis reports
  • End to end experience in designing and deploying data visualizations using Tableau.
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in tableau reports.
  • Experience in creating Tableau Dashboards Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables with quick filters, parameters, sets, group, filter and URL actions, table calculations, various performance optimization, scheduling of data refresh and dashboards.
  • Good knowledge on Star Schema, Extended Star schema and Snowflake modeling.
  • Involved in Design and Development, Testing and Production rollover of Reporting and Analysis projects.
  • Very good knowledge and principles on good practicing of data analysis and data visualization.
  • Performed extraction, transformation and load (ETL) functions using data from multiple data sources and designed and built efficient dimensional data models using SQL scripts for data visualization.
  • Designed and developed SSIS packages for Tableau dashboards.
  • Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors, importing data from excel.
  • Experience in OBIEE 10g configuring repository, create and manage dashboards, Reports/Answers using industry best practices.
  • Knowledge on Informatica, Datamining. Demonstrated ability to self-motivate and be flexible within a fast-paced environment.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Excellent understanding and Strong experience in entire software development lifecycle (SDLC).
  • Excellent interpersonal and technical skills, quick learner, good team player.

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau Desktop 10.2,10.3, Tableau Reader, Tableau Server 10.x, MicroStrategy, SSRS, SSIS, OBIEE.

Languages: C, C++, PHP, HTML, CSS, JavaScript, Python, Shell Script, PL/SQL, MySQL RESTful Web Services.

Databases: MYSQL, SQL Server 2016, Teradata, Oracle.

Operating Systems: Windows and Mac.

Other Tools: Android Studio, Toad, MS Excel, Visio, Eclipse, SharePoint, Informatica, Quality Center, Load Runner.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Tableau Developer

Responsibilities:

  • Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
  • Responsible for making reports using Tableau desktop (10.2) according to the user's requirements.
  • Worked closely with Customer service and BO department for prompt and efficient delivery of Tableau Reports.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Developed various data connections from data source to Tableau Desktop for report and dashboard development .
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
  • Trend Lines, Statistics, Groups, Hierarchies, sets to create detail level summary report and Dashboard using KPI's.
  • 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.
  • Migrated SSRS reports to Tableau. Designed and developed Tableau reports based on the SSRS reports which are developed using store procedures. Custom SQL is developed to migrate and create same reports on Tableau.
  • 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.
  • Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
  • Analyzed and gained understanding of the underlying data and generated Tableau dashboards with forecast and reference lines.
  • Created Users and groups on Tableau Server and created monthly subscriptions of reports.
  • 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.
  • Used JavaScript to develop web UI to integrate tableau reports.
  • Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.

Environment: Tableau Desktop 10.2, Tableau Server 10.2, MySQL, JavaScript, HTML, CSS, SSRS, SSIS, SharePoint, Visual Studio, Visio, TFS, SQL Server, Rally and Windows.

Confidential, Indianapolis, IN

BI Analyst/ Tableau Developer

Responsibilities:

  • Developed various types of Charts and customized it according to requirement.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Create and Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections.
  • Create, Modify and Manage server task schedules Monitor server activity, usage statistics to identify possible performance issues.
  • Developed Metadata Models in Tableau and dashboards. Experienced with trouble shooting and optimizing Report performance.
  • Customized data by adding filters at both the Framework level and Report level.
  • Created organized and formatted reports, folders and other contents on Connection Portal. Created List Reports, Cross tabs, Cascading Prompts.
  • Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/ Mapping and Presentation layers of metadata repository.
  • Involved in creation of prompts, views, aggregates, pivot tables, measures, customization, conditional formatting of reports to as per user requirements.
  • Created the SSIS packages and scheduled them using SQL Server Agent.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Involved in part of ETL Process for loading the data and by designing catalogs and supporting ETL Process.
  • Used SQL Assistant to analyze and query from the Database.
  • Designed and Developed a static website using HTML, CSS and Java Script that displayed Tableau reports.
  • Embedded Tableau report URLs in the Java Script to control the user access to the reports and enter new data.
  • Design and develop web application using JavaScript, HTML, CSS and integrate the tableau server links into the Java script to facilitate the changes and user access restriction.
  • Provided Training and End User Support with my reports and Knowledge transfer.
  • Applied three levels of security to the model (Data, Object and Package).
  • Applying Row and Object level security to Reports.
  • Performed Admin task for user permissions, scheduling the reports.
  • Performed Report Administrator to give set of permissions to the end user.
  • Created scripts for Informal and Formal Testing after development in QA Environment using HP-ALM.
  • Performed testing using HP-ALM and report the test results for approval and make changes accordingly as per business requirement.

Environment: Informatica, Toad for Oracle, JIRA, OBIEE, MS Project, MS Visio, SSIS, SSRS, HP-ALM, Tableau Desktop 9.2, 10.2 Tableau server, SQL Server 2016, T-SQL, JavaScript, HTML, CSS, MS Access, Windows, Teradata.

Confidential, Reston, VA

Tableau Developer

Responsibilities:

  • Involved in reviewing business requirements and analyzing data sources from Excel/MS SQL Server for design, development, testing within Tableau Desktop.
  • Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
  • Created multiple automated reports and dashboards sourced from data warehouse 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.
  • Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
  • Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
  • Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.
  • Wrote SQL Procedures and Views to facilitate data access for reporting needs.
  • Update and upgrade the OBIEE platform to customize the system as per needs. Install and configure OBIEE tools across multiple tools and versions.
  • Designed SSIS Packages to transfer data from flat files to SQL database tables.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Created and updated server architecture for scheduling tasks. Analyzed and resolved performance and server-based issues.
  • Formulated procedures for installation and configuration of Tableau desktop.
  • Designed and developed SSIS packages for Tableau dashboards.
  • Created and updated server architecture for scheduling tasks. Analyzed and resolved performance and server-based issues.

Environment: Tableau Desktop, JIRA, SSIS, SSRS, SQL Server, Microsoft Visual Studio, WebStorm, GIT, Oracle, OBIEE, SQL Server Management Studio, MS Excel, MySQL.

Confidential

BI Developer

Responsibilities:

  • Worked on Data Mapping for the models for data transformation.
  • Involved in Creation of Tableau Reports, Dashboard Reports.
  • Created Complex Reports using Report studio, Plugged Prompts, Drill through Master- Detail Reports.
  • Gathering the requirements from the Business users and understanding the functionality & business rules.
  • Preparing functional design document, requirement document & technical design document for reports.
  • Developing data model to create reports and dashboards.
  • Developing worksheets using parameters, calculated fields, groups, sets and hierarchies.
  • Developing worksheets with different styles like bar, pie, tree map, dual axis, filled maps.
  • Implementing the reports with best practices to improve the report performance.
  • Creating rich dashboards using Tableau Dashboard and applying actionable insights.
  • Implementing user level security to restrict the data by group level and user level.
  • Publishing dashboards to tableau server and managing the security for users
  • Preparing deployment documents and involving in production deployments.
  • Created burst table and did Bursting of reports.
  • Prepared, developed and modified Powerplay reports and graphs with different layouts according user requirements.
  • Developed No. of Charts and customized it according to requirement.
  • Experienced with trouble shooting and optimizing Report performance.
  • Customized data by adding filters at both the Framework level and Report level.
  • Created List Reports, Cross tabs, Cascading Prompts. Involved in part of ETL Process for loading the data and by designing catalogs and supporting ETL Process.
  • Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
  • Provided Training and End User Support with my reports and Knowledge transfer.
  • Applied three levels of security to the model (Data, Object and Package).
  • Applying Row and Object level security to Reports.

Environment: Informatica, SSIS, SSRS, Tableau, GIT, Toad, Oracle, SQL, MySQL server.

Confidential

BI Analyst

Responsibilities:

  • Developing customer segmentation approaches that support Marketing programs and implement systems and reports to monitor performance.
  • Business Analysis knowledge for business process, the need to understand all aspects of the company’s operations. Identify, analyze and design proves to improve the overall flow of information within the company.
  • Interacting with stakeholders, gathering requirements, elicitation techniques like interviewing, questionnaires, brainstorming, focus groups, cost/benefit analysis and risk analysis.
  • Maintain and develop (in close coordination with IT department) databases and analytic applications in environments such as SAP, Excel/Access, Business Objects, or other proprietary environments.
  • Developed custom user interface and business applications on the Salesforce.com platform.
  • Used various Transformations in SSIS Dataflow, Control flow using for loop Containers.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Created SSIS packages with error handling, logging and performed data cleansing by creating tables to eliminate the dirty data using SSIS.
  • Leveraged clients existing IT framework/CRM system for better data visibility and system integration.
  • Develop and sustain relationships with key stakeholders.
  • Assisted in developing Project Scope, Business Requirements and Functional Requirements with internal team and clients. Facilitated the creation of test scenarios and test scripts.
  • Update and process internal data (call file, sales data, etc.) into Excel and other environments using automated procedures and custom programming.
  • Create and update the catalog of standardized market definitions and analytical business rules used within the analyses and reports. Maintain detailed master-calendar of key deliverables, including lead times for editing and approval processes.
  • Ownership of the development, maintenance and update of all national/subnational, and market tracking analyses according to a defined schedule.
  • Collaborate in development of presentations with clear storylines to communicate key conclusions and recommendations to brand and management teams.

Environment: Tableau, SQL, MS-Office, Lilly CRM, HP-ALM, Salesforce, SAP, Excel, Business Objects.

Confidential

Business Analyst

Responsibilities:

  • Successfully completed training on in-house databases, extracted data from various data sources, applied Excel functions to transform raw data in business information required for reporting and data analysis purposes.
  • Created forms, benchmarks, objects, and projects. Successfully participated in group projects.
  • Prepared various statistical data analysis reports for corporate clients, provided ad-hoc updates and modified report templates as required
  • Scripted VBA code which helped managers to store client meeting activity information in automated way.
  • Prepared user guides by documenting the steps involved in generating various reports provided snap shots and explained the calculations with examples.
  • Provided recommendations for improving existing reports generation process by pointing out constraints and suggested corrective measure.

Environment: MySQL Server, MS SQL Server 2008, Oracle 10g, Excel, SQL BI Suite (SSIS, SSRS), MS Office.

Hire Now