Tableau developer
Resume:
Vinitha
*******.*******@*****.***
SUMMARY:
Around 8 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a developer and Administrator
Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
Experience including technical support, troubleshooting, report design and monitoring of system usage.
Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
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.
Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
Experienced in creating reports using Business Objects Universes, webi and Crystal reports
Developed reports & dashboards using Business Objects and Tableau to provide status updates on a daily basis
Highly Experienced in working with Dashboards, Metadata layer and different types charts in Tableau
End to end experience in designing and deploying data visualizations using Tableau
Extensive experience working in Windows, UNIX, LINUX environments.
Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
Created incremental refreshes for data sources on Tableau server.
Worked with Oracle, Microsoft SQL Server, Microsoft Access databases, and Excel Spreadsheet.
Performed impact analysis and validation of production reports after application and database upgrade Interface with business analysts for the users to clarify requirements.
Well Experienced in web technologies like HTML, CSS, JavaScript
Proficient in designing Data Warehouse using Erwin, Star and Snowflake Schemas.
Experienced in well designing staging tables at the data base level and performed data loads using ETL tools.
Highly motivated team player and a Quick Learner with good communication, strong problem solving skills and excellent in presentation and interpersonal skills. Extremely well organized, meticulous and highly self-motivated.
Technical Skills:
ETL Tools
IBM Info Sphere / Web Sphere Datastage 8.5 /8.1/8.0 /7.5 (Designer, Director, and Administrator), Info Sphere
Reporting Tools
Tableau, Qlikview, OBIEE, Cognos
Database
Teradata, MS SQL Server 2005/2000, DB2, Oracle
Languages
SQL, PL/SQL, UNIX Shell Script, PERL, Teradata-BTEQ, TPT
Data Modeling Tools
Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP
Tools
TOAD, WinSQL, MS Office, Autosys, SQL*Plus, SQL*Loader
Operating Systems
Windows NT, UNIX
Methodolgies
Agile, Scrum, Waterfall
Professional Experience:
CELGENE, Warren, NJ Feb 2014 – Till Date
Sr. Tableau Developer
Responsibilities:
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Effectively used data blending feature in tableau.
Defined best practices for Tableau report development.
Administered user, user groups, and scheduled instances for reports in Tableau.
Executed and tested required queries and reports before publishing.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
Provided support for Tableau developed objects and understand tool administration.
Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
Created Custom Hierarchies to meet the Business requirement in Tableau.
Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
Created various connections, Data foundations and Business layers using Information Design Tool 4.1
Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
Responsible for developing provisioning reports for various groups and upper management.
Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created Hyperlinks for each of the Metric to open a detail report using Open Documents
Experience on writing SQL Queries.
Experience on BW Analyzer & Query Designer.
Strong verbal and written communication skills, ability to work effectively with user departments.
Worked towards the goals of quality, time and budget.
Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 8.0/2005, XML, Tableau 8.1/8.0, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI BI: SAP BW Query Designer, Analyzer
LIFE TECHNOLOGIES, San Diego, CA May 2013 to Jan 2014
Tableau Developer/BI Consultant
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 for Amazon.
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.
Honda, San Jose, CA April 2012 – May 2013
Title: Tableau & Business Objects Developer
Responsibilities:
Involved in the design of the Application Business Logic Components, which formed the architecture for distributed application development encapsulating business and data logic.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Navigation and drill down features were implemented in Tableau dashboards.
Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Effectively used data blending feature in tableau.
Created visually compelling and actionable interactive reports and dashboards.
Creating Backup scripts to take periodic backups for the content on Tableau server.
Defining group/user level security standards for Tableau.
Created, modified/maintained Products Universe.
Created web based reporting using web intelligence.
Created a component, which stores the total business logic of the portal, which contains many class modules related to business.
Worked with Xcelsius dashboards.
Developed, deployed, and managed Commerce applications for the Web.
Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
Written SQL queries have been used on the Universe and created as Derived Tables.
Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.
Environment: Tableau Desktop and Server, Business Objects 5.x, Erwin, Windows 2000, IIS 5.0, ASP, SQL Server 2005/2008, VB 6.0, COM, MTS, HTML, DHTML, MS Visual SourceSafe, VBA, Excel
Client: Capital One, Richmond, Virginia Sep 2011 – Mar 2012
Title: Tableau Developer
Roles and Responsibilities:
Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
In charge of the team that build tableau architecture and dashboards using Tableau desktop, Tableau Server and Tableau Online.
Working with User for requirements and part of the team developing the software.
Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
Participated in Preparing Detailed technical documents from the functional specifications.
Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Executed and tested required queries and reports before publishing dashboards.
Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
Created Tableau scorecards, dashboards, Heat maps using show me functionality.
Good Experience in publishing reports and dashboards to Tableau server
Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
Published Reports, workbooks & data source to server and exporting the reports in different Formats.
Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
Created Web Intelligence Ad-hoc and canned reports in 3.1.
Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
Troubleshoot issues with existing reports in the production environment.
Created Views, Stored Procedures and validated data for the Performance.
Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
Experienced in developing Dashboards using Xcelsius 2008.
Provided daily production support and administration of portal operations, such as problem resolution.
Worked closely with Data Modelers in designing various data warehouse schema techniques
Create complex reports against SAP BEx Queries.
Created the reports on the web by using Web intelligence.
Worked on the data provider that forms the basis of the ad-hoc analysis
Environment: Tableau 7.0 (Desktop and Server), BusinessObjectsXIR3, Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, Oracle 10g, SQL Server 2008, Windows 2003Server, .NET and Java based Applications.
Ranbaxy Pharmaceuticals, Hyderabad, India Dec 2009 – Jun 2011
Business Object Developer
Responsibilities:
Published reports in Business Objects Enterprise XI R2 using Central Management Console and
Publishing Wizard.
Assigned Scheduling Rights as per the User Requirements
Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
Work with production team to coordinate and assist in rollout of releases.
Setup hierarchies in the Universe for providing drill down options in the reporting environment
Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
Worked with BO support in troubleshooting issues and provide logs as per request for resolving
several complex issues
Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
Provided solutions to various groups for scheduling reports using Packages and event based job
scheduling.
Co-ordinating with various groups in scheduling releases between environments.
Deployment of Crystal Reports via various methodologies Central Management Console(CMC),
Publishing Wizard, Infoview, Import Wizard.
Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
Experience on Developing Crystal Reports.
Daily reporting to Management on status, issues, migrations, escalations and progress.
Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit Database for investigating User activity and narrowing down issues.
Assist Team in Optimizing system architecture.
Assist with website deployment architecture (e.g. web servers, databases etc.) and code optimization.
Designed and implemented Ad-hoc Reports, Extracting Data from an SQL Server database.
Experience managing user accounts and group accounts in Crystal enterprise environment.
Used Clear case Explorer to Take Backup of Webi Reports and Universe.
Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case
Johnson and Johnson, India Jun 2008 - Jun 2009
Sql Server Developer
Responsibilities:
Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
Involved in Database design, creation and maintenance of Databases.
Managing the use of disk space, memory & connections by monitoring.
Created tables and views.
Created functions, stored procedures, triggers and constraints using T-SQL.
Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
Server & Application fine-tuning & trouble shooting.
Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
Monitoring MS SQL Server performance and network issues.
Performance monitoring and tuning of SQL servers.
Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access.
Education:
Bachelor of Engineering from Osmania University, India
References:
Available on request.
Contact this candidate