Tableau Developer/admin Resume
Bethesda, MD
SUMMARY
- Over 8+ years of extensive IT experience in design, development, implementation, and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse.
- Extensive experience using Tableau Server, Tableau Desktop and Tableau Public.
- Extensive experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
- Expertise in Installing, Configuring and Administration of Tableau Server.
- Proficient in Tableau Administration and Tableau Enterprise Environment.
- Experience in creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.
- Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters
- Proficient in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i, SQL, PL/SQL, and Oracle Data Integration
- Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
- Working experience in Oracle (9i, 10g, 11g), SQL, PL/SQL, Packages and Dynamic SQL.
- Extensive experience in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
- Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
- Having knowledge on the SDLC methodologies like AGILE, Waterfall model
- Extensive experience in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
- Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option- Parameterized, and Linked reports using Tableau.
- Have working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
- Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
- Experience in publishing Dashboards and presenting dashboards on web and desktop platforms to Tableau Server.
- Having strong analytical, logical, Communication and problem-solving skills. Ability to adapt to new technologies by self-learning.
- Created various Data Visualization Objects Viz. Scatter Plots, Bar Charts etc.
- Expertise in writing SQL Queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
- Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
- Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
- Good Understanding of Big Data and Hadoop technologies experience in loading, processing and extracting data in Hadoop environment.
- Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.
- Created multiple customized PL/SQL Procedures & Packages for various businesses’ needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications
- Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development to manage risk analysis and mitigation plans, status reports, and client presentations.
- Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality.
- Excellent skills in communication & collaboration, Strong analytical, logical,problem solving skills and ability to quickly adapt to new technologies by self-learning
TECHNICAL SKILLS
Tools: Tableau Desktop 8.2,8.1,8.0/7.X/6.X, Tableau Server, Oracle PL/SQL Tableau Reader,Tableau online,Tableau Administration
Operating systems: Windows XP/2003/2007, Windows Server 2003/2008, UNIX
Programming Languages: HTML,SQL, T-SQL,PL/SQL, Java, JQuery, C and C++
Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000,Teradata,Oracle 11g/10g/9i/8i/8.0.
Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin
Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum
Operating Systems: UNIX, Linux, Ubuntu and Windows
PROFESSIONAL EXPERIENCE
Confidential, Bethesda, MD
Tableau Developer/Admin
Responsibilities:
- Converted theBusiness Objects/OBIEE reports into Tableau Dynamic Data Visualization andcreated Mapping Documents.
- Gathered business requirements andtransformed the business into high interactiveData VisualizationusingTableau.
- Understood the business challenges and translated them into requirements and developed inTableau Desktopaccording to Business Requirements.
- Created Metadata dictionary dashboard and allowed the business users to audit the metadata of identified data sources.
- Transformed complex data into easy-to-understand visualizations using Tableau and created a Story.
- Converted theBusiness ObjectsTechnical Specification into Tableau MetadatausingWorkbook Tools for Tableau
- EnsuredAction Filters, created aRow Level Securityand shared the reports with functional/business users
- Created Dashboards with the security using filters for the clients to measure cost saving.
- Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
- Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
- Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drills down and drill up reports.
- Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes. Combined
- Multiple data sources by joining tables and using Data Blending.
- Published Workbooks by creating user filters and security, so intended teams can view it.
- Worked on groups, sets, different calculation functions including Table calculations.
- Hands on Tableau Administrator installation, configuration, and load balancing.
- Hands on Design and implement security model.
- Blended data from multiple databases such as MS Excel, MS SQL, Teradata and Oracle
Environment: Tableau, Data Stage, SQL Server,Oracle, Oracle 11g, SQL, PL/SQL, MS Access, Teradata, Microsoft Office Suite (Word, PowerPoint, Excel).
Confidential, Palo Alto CA
Sr.Tableau Developer/Data Analyst
Responsibilities:
- Going through Report Specification Documents and Understanding the User requirements.
- Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
- Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
- Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
- Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
- Created of dashboards for business groups like finance and sale.
- Designed and publishing visually rich and intuitive Tableau dashboards for decision making
- Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
- Created symbol maps to understand the geo-spatial distribution of projects with custom symbols made ofrepresent the application category
- Provided visual/graphic analysis based on data content.
- Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
- Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
- Derived the performance of company base on revenue, occupancy, rate.
- Used Trend Lines, Reference Lines and Annotations to describe the data.
- Created Data extracts for better performance and accessing data offline.
- Used parameters and input controls to give users control over certain values.
- Created and Published Tableau Dashboards into Tableau Server.
Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SSIS, SSRS, SQL developer, SQL2008, Oracle 10g, PL/SQL, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0.
Confidential
Tableau Developer
Responsibilities:
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
- Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
- Installed Tableau Server 7.0 in Dev, QA, UAT and Prod environments.
- Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
- Access dashboards from any browser or tablet.
- Created incremental refreshes for data sources on Tableau server.
- Coordinated database middleware issues with DBA's, system performance with System Architects.
- Involved in license management SLA's with Tableau support.
- Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
- Defined and created procedures to install Tableau desktop in silent mode.
- Defined best practices for Tableau report development.
- Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
- Provided 24/7 production support for Tableau users
Environment: s:TableauDesktop8.0/7.0,Tableauserver/Administrator,SQLdeveloper,SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server,Teradata SQL, Microsoft office 2007
Confidential, Union, NJ
Tableau Developer/Data Analyst
Responsibilities:
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements
- Generated report schedules on Tableau server
- Administered sites for various projects
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Published Workbooks by creating user filters so that only appropriate teams can view it.
- Install upgrade Tableau server and server performance tuning for optimization.
- Participated in daily stand-ups with clients on daily design and development effort
- Scheduling data refresh on Tableau Server for weekly and monthly increments based on the newchanges to ensure that the views and dashboards were displaying the changed data accurately.
- Deployment of Tableau Server in clustered environment by mapping server nodes to primarymachine.
- Using Tabadmin and Tabcmd commands in creating backups and restoring backups of repository.
- Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
- Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
- Developed donut charts for analyzing sales planning data.
- Created different KPI’s using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
- Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
- Expertise in working with data building Groups, Hierarchies and sets.
- Mastered in different Formatting techniques, using Annotations and Mark labels.
- Developed effective and interactive Dashboards using Parameters and Actions
- Strong Dashboard design experience and passionate practitioner of effective data visualization.
- Familiarity with best practices around visualization and design.
- Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
- Scheduled extract refresh and subscriptions.
- Assisting users with questions and issues using Tableau.
- Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
- Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
- Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
- Ability to work effectively in team environment and interact with all levels of management
Environment: Tableau Desktop 9.x\8.X, Tableau Server 9.x\8.X, MS Excel, MS SQL Server 2008 R2, Win Server 2008 R2, Active Directory, Informatica Power Center 9.X.
Confidential
Business Objects Developer
Responsibilities:
- Involved in functional requirements gathering meeting different Business Groups and preparing the Technical specifications.
- Involved in the designing and building of Universes from different data sources like Oracle/SQL Server.
- Linked Universes to share the Universes which had common dimension tables and the classes and objects.
- Generated reports using free-hand SQL as a data provider.
- Migrated Universes, Connections, Full Client / Web I Reports from the existing version 6.5 to XI 3.0 using Import Wizard.
- Created hierarchies to provide the drill down functionality to end-users.
- Involved in Writing Detailed Level Documentation for reports.
- Modified the existing reports by adding new columns based on the result set.
- Created template documents with header, footer and company logo.
- Converted full client report (.rep) to Web Intelligence (.wid) using Report Conversion Tool.
- Created Web I reports using Business Objects Web Intelligence and exported to the corporate documents.
- Exported the Business Objects reports to the repository so that the end users can view the reports through Web I.
- Tested the reports and modified the relevant Objects in the Universe as per the user specifications.
- Developed Desk I Reports using functionalities like cross tab, master detail, drill down, using filters, breaks, alerts and formulae.
- Created user response objects, user prompts in various Desk I Reports.
- Created Interactive Metric Trends (IMT) and score cards using Performance Manager according to the user requirements.
- Created reports to visually represent data using Crystal Xcelsius.
Environment: s: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web
Confidential
Business Objects Developer
Responsibilities:
- Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
- Extensively used Business Objects Designer to design and maintain Data Warehouse Universe.
- Created New Universes and Managed existing Universes Migrate, upgrade and test the Business Object XIR3 content/environment
- Setup, execute, and test the assigned programs utilizing BO XIR3 WEBI and DESKI tools
- Creation of multiple Universes and Linked Universes.
- Design complex Web Intelligence and Desktop Intelligence Reports
- Plan the implementation of migration to different Environments in Business Objects.
- Involved in the Data Warehouse design process
- Develop Dashboards for the higher management of the company
- Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls
- Creation of reports, working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
- Analyzed the reports using the Drill Through, Slice and Dice.
- Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
- Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
- Designed, developed, tested and maintained highly complex reports.
- Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
- Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports giving access permission for Business Objects Reports.
Environment: Business Objects XI 3.1/6.5(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400, SQL Server, Windows XP.