PAVANI REDDY

Tableau Developer

Employer Details:

Ganesh

ac517z@r.postjobfree.com

972-***-****

SUMMARY:

Over 6+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms. Extensive Tableau experience in enterprise environment, in tableau 7.x, 8.x, 9.x, 10.x as a developer with in-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.

Experienced in Tableau working with different Enterprise Data sources likes SAP HANA, SSAS Cubes, Hadoop HDFS, SQL Servers, Amazon Redshift and the Extracts (auto/incremental).

Expertise in developing complex Dashboards, Stories using features such as Data Blending, Joins, Custom SQL Queries, Calculations, Filters, Advance analysis Actions, Parameters, Sets, Groups etc.

Hands-on experience in creating solution driven dashboards by developing different visualizations like Crosstab's, Heat/Geo/Tree Maps, Dual Axis, Funnel Chart, Waterfall Chart, Pie/Bar Charts, Circle Views, Line/Area Charts, Donut Charts, Scatter Plots, Box Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Hands-on experience on Level of Detail Expressions, Context Filters, Hierarchies, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.

Experience with complete Software Development Life Cycle including requirements gathering, analysis/design, development and testing.

Experience working as Tableau Admin, Published workbooks with view permissions, scheduling and authentication features for refreshing extracts on a particular schedule.

Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau 8.0 to 9.0).

Experience on working with MS SQL Server 2012/2008/2005 with Business Intelligence in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expertise in scripting T-SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA).

Used Sub-Queries and Joins to simplify complex queries involving multiple tables.

Expertise in creating, maintaining database objects like Indexes, Views, CTE’s, UDF's, constraints.

Extensively created SSIS packages to Import data from sources like Flat Files, Excel, HTML and Raw Files using various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Error Handlers etc.

Good experience in creating Jobs, Alerts, SQL Agent, and automating DTS/SSIS Packages.

Created various reports like Drill through reports, Drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc., using SQL Server Reporting Services(SSRS).

Extensive experience in Performance Tuning and Query Optimization, Optimizing universe through Linked Universes, Aliases and contexts.

Experience working in Agile and Waterfall models in full life cycle implementations.

Excellent communication and interpersonal skills in handling multiple tasks, able take initiative to handle responsibilities independently as well as a member of team.

TECHNICAL SKILLS:

Programming Language: C, C++, Java, JavaScript, T-SQL, XML, HTML, .NET (ASP.NET, C#)

Business Intelligence tools: Tableau 10.0/9.0/8.0/7.0, SSRS, SSIS and Crystal Reports.

Data Base: SQL Server 2005/2008/2008R2/2012, Oracle 10g/11g, MS Access2000, Hadoop, Teradata

Operating Systems: Windows 2000/2003 Server, Vista / XP, LINUX, UNIX

SDLC tools: Perforce, Team foundation Server(TFS), HP Quality center

PROFESSIONAL EXPERIENCE:

Government Employees Health Association, Lee’s Summit, MO July 2016 - Till Date

Role: Tableau Developer

Responsibilities:

Analyzed business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.

Converted Legacy Reports to Tableau dashboards connecting to SQL server.

Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.

Created pie and bar charts and combined them into dashboards to show top content Viewed by customers in each category including interaction between the two charts for drill down analysis.

Analyzed data from various databases and formatted it into graphs using Tableau Desktop.

Blended data from multiple databases such as MS Excel and SQL database by assigning primary key from each database.

Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created URL's, Hyperlinks in dashboards.

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.

Administered projects, user, groups, permission and scheduled instances for reports in Tableau Server.

Created incremental refreshes for data sources on Tableau server.

Monitored Application Server and data server activity to track Performance and system stability.

Experience in Tableau Server upgrades, taking backup's and restoring

Presented, interacted, and communicated with business user for explaining the dashboards that was created with the change timely fashion.

Published of various kinds of live/extract based interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Train user to interact, filter, sort, customize views and enable subscription on Tableau Server for an existing visualization generated through Tableau.

Identified and solve the issues in coordinating with testing team within marked SLA.

Prepared detailed documents for the Dashboard specifications.

Created custom database connections, join tables as needed, create & manage Extract and Monitor Queries using SQuirreL SQL Client.

Implementing best-practices for the dashboards with a solid understanding of the use of Contexts filter, hiding sheet functionality and their impact on performance.

Develop Ad-hoc reports according to user's requests and meet the expectation.

Experience in publishing reports, data source and dashboards, scheduling refresh, create projects, groups, users, exporting the reports in different Formats in Tableau server.

Experienced in data source transition and troubleshooting its impact.

Provided 24/7 production support for Tableau users.

Environment: Tableau Desktop 10.2, Tableau Server 10.2, Amazon Redshift, Excel, Microsoft SQL server 2012.

Chase, Columbus, OH November 2015 - July 2016

Role: Tableau Developer

Responsibilities:

Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Handled Tableau admin activities granting access, managing extracts and Installations.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Embedded Tableau views in to SharePoint

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Restricted data for particular users using Row level security and User filters.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Created Views, Functions and wrote complex queries for extracting data.

Created Running totals for creating financial reports.

Extensive use of sub reports and cross tab reports.

Extensive use of formatting options for achieving the designed prototype.

Created complex SSIS packages using proper control and data flow elements.

Responsible for data center migration from MD to GA using SSIS

Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and Un Pivot as per the client requirement.

Created reports using Microsoft SQL Server Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

Created SQL Server Reports based on the requirements using SSRS.

Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for monthly Statements.

Developed reports for delivery transactions, pick up Transactions and some end request user reports on periodic basis.

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Worked on Troubleshooting performance issues and fine-tuning queries and stored procedures.

Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance.

Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.

Designed SSRS reports with Cascaded Parameters, Gauges and Interactive Charts, etc.

Configure reports in Report Manager and build custom report interfaces based on specific business requirements and rules.

Used JIRA for defects tracking.

Environment: SQL Server 2008/2008R2/2012, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Data Tools, Excel, Tableau

Lincoln Financial Group, Ft Wayne, IN May 2014- October 2015

Role: Tableau Reports Developer/ SSRS Developer

Responsibilities:

Gathered the business requirements in order to create database.

Involved in project planning and scheduling of database module.

Created new tables, wrote stored procedures for application developers and some user defined functions. Created SQL scripts for tuning and scheduling using T-SQL.

Performed Database Normalization to avoid data redundancies.

Performed backup/restore, database objects such as Stored Procedures, Triggers, Constraints, Indexes and Views.

Integration Services (SSIS) -- Data sources and package connections, Control flow objects and

Data flow adapters, Debugging, deploying, and configuring SSIS packages.

Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.

Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.

Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).

Generated various reports based on business requirements using SSRS that could be used to send information to diverse group of users, clients and managers.

Used PIVOT/UNPIVOT operations to turn rows into column and vice versa to normalize table structure of the database which doesn’t meet the desired reporting format.

Involved in the daily meetings of the project design and development using Scrum project methodology.

Created various Tabular and Matrix Reports using SSRS.

Environment: SQL Server 2008/2008R2/2012, SQL Server Integration Services, SQL Server Reporting Services, Business Intelligence Development Studio, Query Analyzer, Excel, MS Access.

Genpact, Mumbai India January 2012 – April 2014

Role: SQL Developer

Responsibilities:

Involved in understanding the requirements of Business analysts and corporate managers.

Engaged in the development and implementation of ad-hoc reporting system using Crystal Reports.

Guide users to use Deployed Reports on web by using components of Crystal Enterprise.

Used shared and global variables to pass data from main report to sub report & vice versa.

Generated reports using various databases. Alerts, drill down analysis

Developed production/development reports using Crystal Reports 8.5.

Scheduling the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.

Analyzing client requirements by conducting meetings with users and business analysts.

Created procedures and views in Oracle according to the user requirements.

Responsible for proactively generating and compiling reports based on findings, complete with recommended improvements to- or new requirements for – business processes, operational procedures, and their corresponding reporting structures.

Analyzed the existing Crystal reports and tuned for faster execution. Troubleshoot existing reports to eliminate data discrepancies and respond to end-user inquiries.

Developed database connections, SQL joins, Loops, views, aggregates.

Generated reports with parameters, sub reports, cross tabs, charts using SSRS

Used prompts, as per the end user requirements.

Environment: Crystal Reports 8.5, SSRS, T-SQL and Windows NT.

EDUCATION:

Bachelor of Computer Science Engineering.

Contact this candidate