Sr Tableau Developer/LEAD/ARCHITECT

Location:

Posted:

May 15, 2018

Resume:

Summary

Senior consultant with *.* years of experience in Development and Support projects in Digital Media (2 year), Insurance (1 years), Retail (3 years) and Life Sciences (3 years) -MAIL **-*********************@*****.***

Tableau developer with 3 years of experience in creating complex visualization dashboards, workbooks and worksheets using different data sources, Excel files, google sheets, charts, multi-layered maps and multiple input controls

Experience with Tableau workbook objects including multiple charts types, Trends, KPI’s, Bookmarks, Pivoting, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting and other KPI’s.

Experience in creating hierarchies, Measures, Slicer Dimension, Filter Function, Calculated Member, Aggregate functions (sum, YTD, MTD), Joins and KPI’s.

Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau Server

Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS)

Have done performance tuning in tableau server by implementing clusters and re-routing the server user traffic

Have improved complex dashboards performance by generating performance report and working on problem areas

Experience in designing Tableau Layouts to make consistent and professional optimized look to clients.

Performed Tableau Admin activities like – scheduling extracts, user management (assigning roles/groups to business users)

Proficient in building SAP BO universe and WEBI reports

Expert in creating Universes with Measures and Dimensions Objects, Join conditions, Filters, LOV's, Aliases, Contexts, Aggregate Awareness with various back end sources like Oracle, Teradata.

Expertise in scheduling regular and customized reports generation using SAP-BO CMC

Experience in daily data loads using Informatica work flows

Hands-on in QlikView and Qlik Sense visualization tools

Expertise in building Dimensional and Relational Models using Framework Manager in Cognos

Proficient in creating advanced Reports using Cognos report studio

Worked on Creating Users, Groups and Role in Cognos Using Access Manager

Generated and published cubes using Cognos Transformer and create batch scripts using scheduler for incremental loads of Cubes

Implemented SSO in Cognos web portal

Worked on capturing requirements for complex projects involving multiple functional areas and multiple stake holders

Good experience in writing unit test cases, Integration test cases and System test cases.

Good in-depth Knowledge on Data Ware Housing concepts

Extremely efficient in roles that demand rigor, a high level of drive and dedication and a focus on delivering business outcomes through the use of standard methodologies and best practice.

In depth knowledge of Waterfall and Agile methodologies and thorough understanding of various SDLC phases - requirements gathering, design, development, testing, release and support

Technical skills

BI Tools

DBMS / Web application

Operating System

Servers

Language/Scripts

Tableau 9.x/10.x suite (Server, Desktop)

Sap BO 3.x/4.x Suite (Webi, UDT/IDT)

Cognos 8.x/10.x Suite (Reporting, Modelling, Cube)

Oracle 9i/10g, SQL Server 2005, Teradata 14/15

Google sheets

Windows 2008 Server

Windows 2003 Enterprise Server,

XP, Windows 7, Unix

Application Servers (WAS, Tomcat), Web Servers (IIS)

PL/SQL, SQL,

XML,

HTML

Professional Experience

Client: Adamas Pharmaceuticals, Emeryville, CA Dec 17 to Till Date

Role: Sr. Tableau Developer

Responsibilities

Involved in gathering requirements from the Business Users and produce technical, functional specifications for the reporting system. Study and understand the Business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules

Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives

Have improved complex dashboards performance by generating performance report and working on problem areas

Building executive, adhoc, and custom dashboards and publishing to Tableau server.

Testing, monitoring performances, cleaning unused dashboards

Conducting kick off meetings, status calls, walk thru sessions and trainings to business users

Created best practices, publishing checklists and repository backups etc.,

Created schedules, Tasks, Groups, Users, Permissions on Tableau server.

Conducting performance tuning, applying user and data source level securities upon need

Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.

Worked on set analysis and advanced aggregation functions.

Created dynamic and cascading prompts using Business views

Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields to compare and analyze data in different perspectives.

Experience in creating sets, joins,filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.

Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab, donut, pie and highlight tables

Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed

Executed and tested required queries and reports before publishing.

Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Tableau 10.4.2 desktop and server, HP Vertica 8.1, Alteryx 11.8, Windows 7

Client: Univision Communication Inc, Sunnyvale, CA Jan 17 to Nov 17

Role: Sr. Tableau Developer

Responsibilities

Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives

Have improved complex dashboards performance by generating performance report and working on problem areas

Building executive, adhoc, and custom dashboards and publishing to Tableau server.

Testing, monitoring performances, cleaning unused dashboards

Conducting kick off meetings, status calls, walk thru sessions and trainings to business users

Created best practices, publishing checklists and repository backups etc.,

Created schedules, Tasks, Groups, Users, Permissions and Subscriptions on Tableau server.

Conducting performance tuning, applying user and data source level securities upon need

Created Data Extract files ( tde), Data connection files ( tds),Database connection in Tableau

Worked on different Tableau objects like straight tables, line charts, bar charts and pivot tables etc for dashboard design.

Worked on set analysis and advanced aggregation functions.

Created dynamic and cascading prompts using Business views

Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields to compare and analyze data in different perspectives.

Experience in creating sets, joins, hierarchies, filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.

Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab,donut, pie, heat maps and highlight tables

Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed

Executed and tested required queries and reports before publishing.

Running Informatica Workflows using workflow manager and monitor them using workflow monitor

Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Tableau 10.2 desktop and server,Google Sheets, Teradata 14,15, Windows 7, HP ALM (Quality Center), ServiceNow, Informatica 9.x,10.x

Client-Univision Communication Inc,NJ Mar 15-Dec 16

Role: Tableau Developer

Responsibilities

Results-focused approach with regards to design and development of Tableau software applications to support reporting and Business Intelligence initiatives

Gathering user requirements, analyzing, designing and efforts estimations

Building executive, adhoc, and custom dashboards and publishing to Tableau server.

Testing, monitoring performances, cleaning unused dashboards

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support

Integrated information from several data sources, Excel, Oracle, SQL Teradata

Created server-based Tableau workbooks(twb), Packaged workbook (twbx), dashboards and applications from scratch based on client needs

Worked with end users to explain Tableau workbooks, creating ad-hoc reports

Recreated BO reports in tableau as per business requirement

Trained developers on Tableau in terms of best developing and design practices

Coordinated an employee training program for various Tableau applications and basic troubleshooting principles

Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Tableau.

Testing reports using review checklists for Quality Assurance before delivering to the end users

Developing, Maintaining, Troubleshooting and updating Reports in Business Objects

Creating package report and very complex and critical Business Objects reports as per user request

Environment: Tableau 10.1, SAP Business Object 4. x (Webi Report), IDT, SQL, NoSQL, Teradata 14,15, Windows 7, HP ALM (Quality Center), ServiceNow, Informatica 9.x

Client-Lincoln Financial Group, Ph Aug 14 – Mar 15

Role: Report Developer

Responsibilities:

Working as a BI analyst/SAP BO Developer.

Created functional specification documents, based on the technical specification documents for universes and reports. Facilitated universe design-walk through before promoting the universe to Q.A (UAT).

Used short cut joins to bypass intermediate tables and improve query performance.

Implemented object level, row-level security at the universe level by creating relevant restrictions on user groups.

Modified existing Business objects auditor canned reports and created customized auditing reports to keep track of report run times and volume of data churned by report/user.

Developing, Maintaining, Troubleshooting and updating Reports in Business Objects

Creating complex reports in Business Objects

Scheduling monthly, quarterly and annually reports as per business requirement in Business Objects

Creating objects as per business requirement in UDT

Perform Unit testing of reports against database and posting them to the repository

Adding users as per business requirement in SAP BO CMC

Performing Ad-hoc data loads in Informatica

Environment: SAP Business Objects 3.x(Webi Report),UDT 3.x,SQL, NoSQL, Oracle 11i,Windows XP,HP ALM(Quality Center),Informatica

Client-AstraZeneca, UK Feb 12 – Jun 14

Role: Report Developer

Responsibilities:

Interacting with Business users and Stake holders and gathering requirements and building reports using Business Objects

Managing new enhancements end to end, from Requirements gathering till delivery.

Estimating Cost and timelines for the enhancement requests.

Maintenance of existing Business Objects reports.

Adding users as per business requirement in SAP BO CMC

Performing Ad-hoc data loads in Informatica

Mentoring new team members and providing them process and technical knowledge.

Providing weekly status updates

Managing and tracking all Incident, Problem Tickets, Change Request, Release tickets in Remedy to closure.

Handling Internal Remedy Audits for Change Request, Problem Tickets.

Interacting with multiple teams and closing the tickets on time so as to avoid any SLA breach.

Actively involved in UAT

Coordinated in training sessions and demonstration of SAP BO tools to End-users

Involved in creating Technical Design documents

Environment: SAP BO 3.x(Webi Report),UDT 3.x,Informatica 9.x,SQL, NoSQL, Oracle 10g,Windows 2003,Remedy.

Client-GE, Houston Jun 09 – Dec 11

Role: Report Developer

Responsibilities:

Design and Development of Reports, Cubes and Framework Model using Cognos Framework manager.

Verify and customize the imported metadata (setting relationships and cardinality).

Create Report studio reports and use these source files as data source to create cubes by using power play transformer in Cognos.

Generate the cube and publish cube for analysis using Cognos transformer.

Analysis of Cubes and Models using Analysis Studio.

Generating Reports using Report Studio

Creating Groups, Roles and adding users using Access Manager

Report validation and testing

Actively involved in UAT

Implemented SSO on Cognos web portal

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Access Manager), SQL, Oracle 9i, Unix server, Windows 2003

Client-GE Aero, Houston Oct 08 – Apr 09

Role: Report Developer

Responsibilities:

Design and Development of Reports, Cubes and Framework Model using Cognos Framework manager.

Verify and customize the imported metadata (setting relationships and cardinality).

Create Report studio reports and use these source files as data source to create cubes by using power play transformer in Cognos.

Generate the cube and publish cube for analysis using Cognos transformer.

Analysis of Cubes and Models using Analysis Studio.

Generating Reports using Report Studio

Creating Groups, Roles and adding users using Access Manager

Report validation and testing

Actively involved in UAT

Environment: IBM Cognos 8.2 (Framework Manager, Report Studio, Access Manager), SQL, Oracle 9i, Unix server, Windows 2003

Education

Bachelor of Engineering (B.Tech): Electrical & Electronics Engineering (2007)

JNTU, Hyderabad, India

Contact this candidate