Tableau Developer

HARIKA

Tableau consultant

PROFESSIONAL SUMMARY

Over 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of

Business Intelligence and Database Platforms.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

In-depth knowledge on Tableau Desktop, Tableau Reader, Tableau Public and Tableau Server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

End to end experience in designing and deploying data visualizations using Tableau.

Extensive experience working as a Business Intelligence Consultant with specialization in cognos, microstrategy, SSRS.

Extensive experience working in Windows, UNIX, LINUX environments.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications.

Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.

Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Worked extensively with the major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.

Professional in writing complex Formulas, Sub Reports, Summary Reports.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau.

Installation, configuration and administration of Tableau.

Deployed the reports and Scheduled Reports for the use of end users and customers.

Worked extensively with creating reports as per user requirements using Reporting Services.

Extensive working experience in Packages, Procedures, Cursors and Triggers.

Experienced in tuning long running SQL queries for better performance.

Expertise in using Version controllers like SVN & Serena Dimensions.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

BI Reporting Tools

Tableau Desktop, Public, Server, Reader/Cognos/Microstrategy

Java & J2EE Technologies

Core Java

Databases

Oracle, MySQL, DB2, Teradata, SQL Server

Operating Systems

Windows 95/98/2000/XP/Vista/7, Unix

Other Tools

Putty, SVN, Dimensions

PROFESSIONAL EXPERIENCE:

HANGER INC, AUSTIN AUG ’13 TILL DATE

TABLEAU DEVELOPER

RESPONSIBILITIES:

Currently working on Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.

Recommended OS configuration for installing Win Server 2012 R2, Tableau Server, and MS SQL Server 2012 R2.

Experience with other BI tools like Cognos, Business Objects, Micro-strategy and Netezza.

Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations.

Adjust views/dashboards after initial POC presentation.

Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.

Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily.

Cleanse and normalize data in MS Excel by combining from various data sources.

Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

Involved in migration of Cognos reports to Tableau workbooks.

ENVIRONMENT: Tableau V 8 (Desktop, Server, Reader), Oracle, SQL Server, MSTR, Cognos.

AT&T, ALPHARETTA, GA JAN ’12 – AUG’13

TABLEAU DEVELOPER

RESPONSIBILITIES:

Involved in creating dashboards by extracting data from different sources.

Created dashboard using parameters, sets, groups and calculations.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating calculated fields, mapping and hierarchies.

Created drill through reports in dashboard.

Involved in creating data blending in case of merging different sources.

Involved in creating a dual-axes bar chart with multiple measures.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel.

Extensively used data blending in Tableau.

Performed Tableau type conversion functions when connected to relational data sources.

Maintained and Installed Tableau Server in all the environments.

Created incremental refreshes for data sources on Tableau server.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

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.

Created report schedules, data connections, projects, groups in Tableau server.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Involved in creating Stored Procedures, tables, and views for applications.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

ENVIRONMENT: Tableau V 7/8 (Desktop, Server, Reader), Oracle, Teradata, Java, SVN, MS Excel

UNITED PARCEL SERVICES, GA NOV ’10 – DEC ‘11

TABLEAU DEVELOPER

RESPONSIBILITIES:

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Created Heat Map showing current services by color that was broken into regions allowing business user to understand.

Experience with other BI tools like Cognos, Business Objects, Micro-strategy and Netezza.

Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, Teradata and MS Excel.

Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

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.

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.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

ENVIRONMENT: Tableau Desktop, Reader, SQL Server, MS Excel.

CARTEL SOFTWARE PVT.LTD, INDIA MAY ’08 – OCT ‘10

BI DEVELOPER

RESPONSIBILITIES:

Worked on Database design and reporting. Experience development of dashboards and publishing the reports. Working on Data warehousing and reporting.

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)

Experience in using SQL Server 2005 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle, Lotus notes and Sybase and DTS (i.e. Import and Export) and Automate the ETL operations.(Automate SSIS Packages and Import, Export).

Developing Ad hoc reports within SQL Server Reporting Service (SSRS).

Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.

Working on Subversion and repositories.

Creating dataflow diagram and documenting the whole data movement process.

Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.

Migrating data based on the confirmed Customer's, Technician's and Service Provider's.

Creating report models and deploying on report server.

Creating standard report Subscriptions and Data Driven report Subscriptions

Creating report snapshots and cache for better performance.

ENVIRONMENT: SQL Server Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, TFS

IBM INDIA PVT.LTD, INDIA NOV ’07 – MAY ‘08

BI DEVELOPER

RESPONSIBILITIES:

Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.

Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL

Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.

Implemented Report Services and generated the documents to be distributed to end users using Narrowcast Subscription.

Tuning of SQL Scripts and also was involved in Data cleansing.

Took regular back-ups of the Production Metadata in SQL Server Database.

Involved in design of the application system.

Involved in developing complex reports through SSRS.

Created drill down, drill through, sub reports and many more complex reports

Provided level of effort estimates for new project work, enhancements and fixes.

Performed the administration tasks like tuning, Caching, specifying Query and Report optimization.

ENVIRONMENT: SQL Server Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, TFS

Contact this candidate