Revathi Thipparaju

Email: adjeps@r.postjobfree.com

Mobile: 1-504-***-****

PROFESSIONAL CERTIFICATIONS:

Certified BI Consultant in Tableau

PROFESSIONAL SUMMARY:

Having 4+ years of overall professional experience with 2+ years of experience with the Tableau Desktop and Tableau server.

Worked closely with business teams for gathering requirements and provide support on new Business initiatives towards Analytics and reporting.

Successfully developed various dashboards, reports using Tableau 9.x/10.x versions.

Possess good knowledge on different interactive dashboards using different charts (Donut, Waterfall, Bar charts, scatter plots, geographical layered maps, lollipop) along with toggle functions for the KPI.

Familiar with Tableau server on providing access to different users / groups and assigning appropriate schedule for the extract refreshes.

Publish dashboards to Dev / Test / QA tableau servers and provide appropriate permissions to different BU user groups.

Provide demo of various dashboards to BUs after successfully publishing to QA environment.

Formatting the data layout with Legends, Marks, Color, Size, Text, and Shapes.

Possess extensive knowledge on parameters, sets, different filters (Local, Context, Quick Filter, Global, Relevant, Data source), aggregates, table calculations, trend lines and calculated measures (LOD, Ranking, index, PYTD, YTD, PYMTD, MTD).

Provide details to DBA for adding appropriate indexes and partitions for better performance on the extract refresh.

Have good knowledge on SQL queries using different joins, aggregate functions to fetch required data set and add on to the custom SQL in Tableau.

Good understanding on DB views, indexes, triggers and partitioning concepts in RDBMS.

Co-ordinate with ETL teams on data related issues and availability.

Take ownership of tight deadline deliverables and work quickly with focus on the details.

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.

Having work experience on Software Methodologies like Agile.

Outstanding analytical and problem-solving skills, capable of learning new technologies quickly.

SKILLS SUMMARY:

Operating Systems : Windows 7/XP, 10

Productivity tools : Microsoft office

Languages : SQL

Databases : Oracle, MS SQL Server

Tools : Tableau Desktop, Tableau Server, Toad, MSSQL Server Management studio

EDUCATION

Bachelor of IT Engineering from JNTU, INDIA

PG Diploma in Management and Finance

PROFESSIONAL EXPERIENCE:

Project Name : Accenz LLC, FL Nov 2019 – Dec 2020

Client : Kozzie Group (Bic)

Role : Tableau Developer

Roles & Responsibilities:

Involved in full project lifecycle of SDLC and coordinated with the cross-functional teams

Analyzed business requirements and identified data sources for design and development

Worked on development, testing and production support on the user’s dashboards and reporting using Tableau Desktop

Actively participated in Business Intelligence standardization to create database layers with user

friendly views in Redshift to optimize SQL for the better performance of various Tableau reports/ dashboards

Designed and developed Interactive dashboards using Tableau Desktop, allowing executive management to view past, current and forecast financial & supply chain data

Used LOD (Level of Details) functions like Fixed, Include and Exclude in Tableau

Built filled maps, actions, parameters, filters (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau Desktop

Auto scheduling reports for data refresh and publish the reports/dashboards to the users in Tableau Desktop

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

Used advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once

Developed prompts, customized calculations, conditions and filter (Local, Global) for various analytical reports and dashboards

Used multiple measures like Individual Axes, Blended Axes, and Dual Axes

Developed and modified Interactive Dashboards, guided navigation links within Interactive Dashboards and make use of filters and making them local and global accordingly

Generated stories for Finance team and improved the reporting performance with push down optimization

Worked on reporting enhancements, production bug fixes, performance issues for better scalability and availability of Tableau Desktop

Environments: Tableau Desktop 2020/2019, Tableau Server, MySQL,SQL, MS Office Suite,, Windows Server 2012

Project Name : HelpZilla Jan 2018 – Oct 2019

Client : VMware, Burlington MA

Description:

VMware is radically transforming IT with technologies that make your business more agile, efficient and profitable. A pioneer in virtualization and policy-driven automation, VMware simplifies IT complexity across the entire datacenter.

HelpZilla is the project to analyze the service to the customers who raise the tickets. Growth trend on the number of tickets resolved and not met by user group and create total count of tickets raise in a week, assigned to department, category wise analysis, Region level severity, How much time to take the resolved kind of analysis done

Roles & Responsibilities:

Conduct meeting with Business Units for requirement gathering and provide thoughts of using different charts based on the requirement.

Develope interative dashboards / reports using table calculations, Pareto, Waterfall, Bar charts, scatter plots and other Tableau features.

Worked on the development of dashboard reports for the Key Performance Indicators (KPI) for the top management.

Work closely with the ETL team to understand the data load process and availability of data that are to be utilized in the dashboards.

Provide details to DBA for adding appropriate indexes and partitions for better performance on the extract refresh.

Developed reports using parameters, sets, different filters (Local, Context, Quick Filter, Global, Relevant, Data source), aggregates, table calculations, trend lines and calculated measures (LOD, Ranking, index, PYTD, YTD, PYMTD, MTD).

Utilize SQL queries using different joins, aggregate functions to fetch required data set and add on to the custom SQL in Tableau.

Provide demo of the dashboard at the end of every sprint.

Publish the dashboard until QA environment tableau server.

Assign schedules for the extract refreshes based on the data availability and requirement.

Grant access to reports until QA for business groups / users.

Raise service requests for every activity in production environment for deployment.

Provide warranty support for two weeks after every production implementation.

Project Name: Financial Services Jun 2016 - Dec 2017

Client : HDB, HYD, India

BI Developer/ Data Analyst

Responsibilities:

Worked as an active member of Reporting & Analytics team for providing critical analysis to support multiple business groups across the company

Develop effective and scalable Business Intelligence solutions including Data Visualizations, Dashboards, Reporting Data Marts, operational Reports and Data Integration solutions

Connected to live databases and creating the Tableau data extracts for creating the workbooks

Hook up Tableau reports to the distribution tables from Oracle database

Worked on Oracle database to pull the data from the data warehouse tables and populate them across the stages staging, integration and distribution.

Connect to multiple data sources (excel files, flat files, SQL Server) to do analytics in Tableau Desktop and create the Data extracts and data sources, publishing to Tableau server.

Involve in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handle the performance issues effectively

Used different calculation fields according to the business requirement, applied conditions and filters for various analytical reports and dashboards data mapped from Oracle and Flat files

Maintained existing ETL workflows and mappings and monitor scheduled jobs for the data processing using Informatica Powercenter

Prepared test cases and performed Unit testing and supported QA & UAT testing phases

Environments: Informatica PowerCenter 9.x, Oracle 11g, Tableau Desktop/Server 2018, PL/SQL, SQL Developer, Test Cases (Unit, QA, & UAT), MS Office, Windows Server 2008 R2.

Project Name:

Aditya Birla Financial Services Jan 2016 - Jun 2016

Data Analyst Hyderabad, India

Responsibilities:

Developed and support reporting to the client’s information needs for the internal & external customers

Publish ad-hoc reports, dashboards, and supporting our client's BI platforms and applications

Develop test conditions and use cases for assigned tasks

Create technical design specifications, debug, troubleshoot and resolve technical issues

Administration activities like data security, authentication and authorization, assistance in reports migration between environments for the BI platform

Performance tuning, Report Enhancements, Data Validation, Data Quality, Sanity Checks, etc.

Train & support the users on the BI tool for the self service reporting

Writing complex SQL queries for ad-hoc reports, optimization to work efficiently

Environments: OBIEE 11g, Windows 10, SQL, MS SQL Server, Test cases (Unit, Sanity)

Contact this candidate