SUMMARY

• Over 6+ years of experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Solutions.
• Extensive experience in Tableau Desktop in various versions of Tableau 7.x/8.x/9.x/10.x
• Proficient in Tableau Data Visualization Tool to Analyze and obtain insights into large Datasets, Create visually powerful and actionable Interactive Reports and Dashboards.
• Worked on Data Blending and increased the Dashboard performance by extracting & optimizing the data.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Filters, Calculated fields, Sets, Groups, Bins, Parameters in Tableau.
• Experience in developing complex visualizations like Waterfall Chart, Donut Charts, Parito Charts.
• Labored at the improvement of Dashboard reports for the Key Performance Indicators for the management.
• Scheduled the workbooks according to the requirement - scheduled the extracts to refresh automatically.
• Worked on complex KPI Scorecards, Heat Maps, Tree views, Circle views, Bar Charts, Data Visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Good interaction with Clients, understanding Business Applications, Business Data Flow and Data Relations.
• In-depth knowledge on SQL queries and working with SQL Server 2000/2005/2008.
• Experience in working and coordinating with offshore team.
• Experience in creating different Visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt Chart, Bubble Chart, Histogram Chart, Heat maps and Highlight tables.
• Experience in development of Reports and Dashboards in Tableau, on Tableau Desktop and Server.
• Experience in creating filters - Quick Filters, Data Source Filters, Context filters.
• Experience in creating Parameters, Formatting, Sorting and Grouping.
• Creating different type of reports including Cross-tab.
• Created Customized and Interactive Dashboards using multiple data sources.
• Experience on creating Clipboards and Data Source Filters in tableau.
• Extensive experience on Data Blending in Tableau.
• Implementing Individual Axis, Axis Blending, and Dual Axis in Tableau.
• Extensive Knowledge in creating Data Visualizations using Tableau Desktop.
• Proficient in creating Groups, Set and Data Bins.
• Skilled in Tableau Desktop for Data Visualization through various charts such as Bar Charts, Line Charts, Scatter Plots, Pie Charts and Packed Bubbles.
• Strong Analytical, Problem-solving, Organizational, Communication, Learning and Team skills.
• Strong communication, Collaboration & Team building skills.
• Working Knowledge on POWER BI.

TECHNICAL SKILLS

Languages: SQL

Applications: MS Word, Power-point, Excel, MS-Project

Databases: SQL Server 2005/2008/2012 , MS Access, Teradata

Operating Systems: Windows Server 2003, Server 2008, Windows XP/7/8

Business Intelligence: Tableau Desktop 10.x/9.x/8.x/7.x/6.x, Tableau Server

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reportsbased on user requirements for CCAR & DFAST 2016 submission.
• Worked Closely with ETL Architecture and reporting BA in creating the Architecture Diagram for Different Source systems for Pro Provision Net Revenue Models and Mortgage Process.
• Work with business in understanding the Nature of Data, accordingly will get the best possible way to create dashboards in Tableau for different Domains using Oracle and Essbase data sources.
• Worked on data from multiple data sources including Oracle, Hyperion Essbase, CSV file and ODBC connections.
• Created Reusable dashboards to utilize the same process for all the PPNR & Mortgage Models for Different Source systems.
• Created Data loads, Data Quality Checks for ensuring data accuracy and reproducibility.
• Hands on experience on reports using Micro strategy and Qliksense and analyzed with Tableau reports for data consistency.
• Worked extensively with Advance analytics likeReference Lines and Bands, Trend Lines.
• Mastered in differentFormattingtechniques, usingAnnotationsandMark labels.
• Developed effective and interactive Dashboards using Calculated Fields and Parameters across Multiple Data Sources
• Strong Dashboard design experience and passionate practitioner of effective data visualization.
• Provided Production support to Tableau users and fine-tunedCustom SQLscripts to support business requirements.
• Published and shared views on Tableau server and Scheduledextract refresh and subscriptions.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

Environment: Tableau 9.0, 9.3,10.0, Sql Server, Hyperion Essbase.

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Development of Tableau Visualizations and Stories in Tableau Desktop. Documenting Business requirements and plans for creating dashboards.
• Experience in designing complex Tableau report packages and story publishing them on the Tableau Server.
• Designed report that depicts top performers of the total client list in quadrant graph.
• Designed Status Requestor Dashboard that provides status of specific request from end client which provides them tracking ability of their ad-hoc report requests.
• Developing Cohort Analysis of claims data to estimate cost avoidance charges by connecting through virtual visit’s programs.
• Developing KPI’s dashboard package to depict success of MD live program for the client.
• Developed account specific reporting packages for client’s customers to track their spending on employee insurance.
• Developed client accounts specific reports.
• Enhancement of existing reports to improve performance by modifying the SQL code used in extraction of data.
• Involved in design requirement meeting with clients and internal employees.
• Development of Key Performance Indicators (KPI) Dashboards that provides internal employee productivity of specific period.
• Working with Level of Details Expressions (LOD’s) and Regular Expressions.
• Migrating reports from standard reporting tools like Excel to Tableau.
• Migrating all the reports from tableau 9.3 to tableau 10.2 and publishing them on the server.

Environment: Tableau Desktop 10.2/9.3, Tableau server 10.x/9.x, SQL Assistant.

Confidential, Chicago, IL

Tableau Report Developer

Responsibilities:

• Worked on multiple reporting tools include tableau, crystal reports and assisted ETL team
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Building, publishing Customized Interactive Reports and Dashboards, Extract scheduling using Tableau server.
• Created Action Filters, Parameters and Calculated Sets for preparing dashboards and worksheets in Tableau.
• Converted metric insight reports to tableau reports.
• Built complex formulas in Tableau for various business calculations.
• Created Tableau reports based on existing Excel reports. Implemented best practices to improve dashboard visualizations and tableau performance.
• Extensively developed and implemented Data Blending in Tableau.
• Administered User, User Groups, and Scheduled Instances for reports in Tableau.
• Trend Lines, Reference Lines, Formatting and Axis. Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Implemented data security by creating user filters.
• Created report schedules, Data Connections, Projects, Groups in Tableau server and checking the task's daily on the server
• Involved in creating database objects like Tables, Views, Procedures, Triggers, Functions using T-SQL to provide Definition, Structure and to maintain data efficiently.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau (Desktop/ Server) Oracle SQL Developer, SQL Assistant, Microsoft office 2007, Business objects, SQL, PL/SQL.

Confidential, Denver, CO

Tableau Developer

Responsibilities:

• Performed as Tableau Developer and Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Worked closely with Business Analyst in gathering various requirements
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Building, publishing customized Interactive reports and Dashboards, report scheduling using Tableau Server.
• Setting-up and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards by joining multiple complex tables.
• Created security parameters for tableau dashboards at row level.
• Used excel sheet, flat files, CSV files to generate Tableau reports.
• Generated Dashboards with Quick Filters, Parameters and Sets to handle views more efficiently. Published Workbooks by creating user filters.
• Hands-on development assisting users in creating and modifying Worksheets and Data Visualization Dashboards.
• Created report schedules, Data Connections, Groups in Tableau server.
• Generated Tableau Dashboards for Sales with forecast and Reference Lines.
• Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting.
• Generated dashboard for Clinical Team, provided security by using user filters at row level.
• Executed and tested required queries and reports before publishing.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Skilled in Tableau Desktop for data visualization through various charts such as Bar Charts, Line Charts, Scatter Plots, Pie Charts and Packed Bubbles.

Environment: Tableau Desktop 10.2/9.3, Tableau server 10.x/9.x, Teradata Sql Assistant, Teradata 14, My SQL, Oracle, MS Excel.