Tableau Developer

Mamatha Chirumamilla

Raleigh, NC ■ *******.**@*******.*** ■ (919)800-112 ■ https://public.tableau.com/profile/mamathachirumamilla#!/

BI Developer/Data Analyst

Seasoned Business Intelligence professional with experience in Tableau, Data Analysis and Testing experience

Experience Summary

Seasoned Business Intelligence Professional having IT experience in analysis, design, development, integration, documentation, testing, implementation, maintaining enterprise BI applications with Tableau, Power BI along with strong Data base development.

Extensive Tableau experience in Enterprise Environment, using Tableau 9.x, 10.x, 2018.2, 2019.2 as an Admin, Developer and Data Analyst.

Experience in creating the Groups, Sites, Projects, schedules and assigning the schedules to the workbooks, Tableau Extracts, Suscriptions in Tableau server.

Experience in using Tabadmin and Tabcmd commands in taking and restoring backups of Tableau repository.

Experience in creating highly interactive Data visualization views and Dashboards, Stories using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures, Trend lines, Statistics, Binning the measures, Hierarchies (For Drill up and Drill Down) in Tableau

Designed Analytics dashboards combining multiple data sources and types in Tableau to drive actionable insights.

Developed Dynamic interactive dashboards using Tableau new features like Set Actions, Parameter Actions for Proportional Brushings, Dynamic Viz-in-Tool Tips, Customized Highlight actions.

Implemented new Parameter actions functionality to create customizable dashboards.

Proficient in creating custom Analytical Calculations (String, Logical, Date, Number, Table, LOD Expressions) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables

Expertise in using Dual Axes, Blended Axis and Individual Axes for comparing different measures on the same view in tableau Desktop.

Expertise in developing the rich interactive dashboards by using dashboard actions (Filter, Highlight, URL) and formatting the dashboard using the Layout Containers, Images, Web links, Tiled Objects and Rich Text Formatting.

Create Extracts in Tableau Desktop and published to Tableau server.

Restricted data for users using Row level security and User filters

Associating TOP N/Bottom N/Range/String Parameters in Calculated Fields, Filters, Sets and Reference Lines.

Produced attractive visualizations/dashboards to convey the Tableau story inside the data which allows the business users to understand the data.

Used Worksheet Actions for navigating, Drill through from Summary View to the detail view in the same worksheet in Tableau.

Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Power BI.

Created customized Tableau Dashboards, integrating Custom SQL Oracle.

Documenting the entire Life cycle of the Tableau Project (Business Requirement documents, Design documents, Test cases, Change Points)

Created test plans, test objectives, test strategies and test cases in the QA testing phase.

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

Experienced in working with many SQL queries with joins, date functions, inline views, collections, partition tables, external tables, materialized views, sub-queries and analytical queries.

Experience in SQL Queries, Creating Views, PL/SQL Stored Procedures, Functions, Triggers, Cursors as per the business needs requirement and having good communication skills, strong problem-solving skills.

Skills

Tableau Desktop (9.x, 10.x, 2018.x)

Oracle (11g,12c)

ODI 12c

LINUX, Windows 7,8,2012

Unit & UAT Testing

Tableau Server (10.x, 2018.x)

SQL Server (2012,14,16)

SQL, PL/SQL

Erwin, Microsoft Visio

Tableau Online and Public

MS Access, SAP BW

Power BI Desktop and Service

Toad, Edit Plus, SSMS

Professional Experience

DEUTSCHE BANK, CARY, NC. BUSINESS INTELLIGENCE (TABLEAU/DATA ANALYST)

OCT’17- APR’19

Involved in the entire project life cycle from evaluation, installation and development of end user

Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement.

Assigned License levels to the end users and added the users to the groups and sites based on the business needs.

Create groups, sites (for multi tenancy) in Tableau admin console

Assigned permissions to the workbooks and projects in the individual sites.

Created, the Customized schedules, assigned/modified the schedules to the workbooks and tableau data extracts, Subscriptions.

Used Tabadmin commands for backing up and restoring the server.

Developed Dynamic Dashboards to navigate from Summary to different detail dashboards/Sheets using action filters and by creating the sheet filters.

Created Interactive Dashboards using the Parametrized sheet selector for rendering different sheets and comparison of different measures.

Utilized Tableau visual analytics and best practices like Dashboard structure (Layout Components, Tiled and Floating objects), view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.

Developed different level of dashboards for different line of Business-like Finance Dashboard (Trend Analysis of Portfolios), Segment Analysis of the Portfolios, Revenue Performance of the customers, Credit Risk Overview, Small Business Loan Customer List, Personal Lon Customer List. Customer Insights, Customer List Dashboards.

Developed several Worksheets, Views, Dashboards, and Visualizations by using several tableau calculations, filters, calculated fields, Level of Detail Expressions, Actions, Trend Lines, Forecasting, Hierarchies, Groups and calculated dynamic sets.

Developed several worksheets using Bar, Line, Pie, Maps Charts and Highlight Tables, Scatter Plots for rich visualizations and for analyzing the data.

Used Dual Axes, Blended Axes for comparing different measures on the same View/Sheet.

Create sheet using table calculations (Running Sum, Moving Sum) to compare the actual Spending for each account and leftover money for the account for a specific period.

Extensively used LOD (Fixed) Expressions to calculate the view level of detail calculations

Highlighted the measures in the same view using advanced conditional formatting

Used detail filters and context filters to limit the data that is to be viewed in the sheet and dashboards based on the business logic.

Used User Filters to perform the Row Level Security in Tableau

Used Data blending, combined fields, custom calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspective

Created and used Parameters for dynamic calculations and Custom sets based on the conditions.

Developed Maps views for the demographic data to analyze and forecast the revenues.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server

Performed Advanced Sorting of the visualizations by using the Calculated Measures and Parameters.

Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue, expenses.

Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production

Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas

Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.

Trained the end users to effectively use the Tableau tool to build and customize their ad-hoc reports.

Environment: Tableau 10 (Desktop, Server), Oracle 11g, MS Access, Toad, Excel, Windows 7, Windows 2012 R2

JAN 15 – JUN 16 SOFT SOL, HYDERABAD, INDIA (TABLEAU ANALYST/SQL DEVELOPER)

Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications

Installation of Tableau Server on Development, Quality Assurance and Production environment.

Developed, publishing customized interactive reports and dashboards, scheduled using Tableau server. Creating new schedules and monitoring the tasks daily on the server.

Created Users, Groups, and Projects, assigned the security based on the License Levels.

Created and Scheduled Data extracts (.tde) on the server and maintained Data source Connections

Utilized Tableau Desktop for blending databases and creating different interactive views and dashboards.

Developed Tableau dashboards using dynamic sets, Parameters, Advanced Calculated Fields, Dynamic sorting, Filtering, Table Calculations, Parameter driven analysis.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Developed several Visualizations using Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Text Tables, Highlight Tables for analyzing the data

Extensively developed worksheets by changing the Measures, Dates to discrete and continuous based on the visualization needs

Used Individual Axes, Blended Axes, and Dual Axes to compare different measures.

Created Dynamic Groups by using advanced logical calculations, String Calculations.

Finely control mark properties including showing multiple fields on labels. Added rich text formatting to annotations, titles, captions, and tooltips.

Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Webpage, Image in order to create efficient dashboard using tableau desktop

Extensively used Data Source Filters, Advance filters (Conditional, Top N) by formula and by field, Context filters, Cascading Filters to limit the data that is to be rendered in the sheet.

Customized the Quick Filters by enabling/disabling different Filter types, Include/Exclude, All Values.

Created Hierarchies for Drill-Drill Down (Expand/Collapse) behavior of dimensions when analyzing the measures

Created Bins for distributing of the data.

Utilized user filters to implement the row level security in Tableau to define data access restrictions for user

Created Aggregations, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure

Extensively used Table Calculations (WINDOW_AVG, WINDOW_SUM, RUNNING_SUM, RUNNING_AVG, FIRST, LAST, LOOKUP) for creating the advanced calculated fields that are used in defining the Reference lines, Bands across the Pane, Table and cells in the visualization.

Extensively used Fixed LOD Level of Detail Expressions for daily trends of total customer acquisition

Utilized Dashboard Actions to develop highly interactive Dashboards by Filtering, Highlighting target visualizations from the source within or other Dashboards.

Creating Worksheet actions to Filter or Highlight or navigate to the Target Sheets from the Source Sheets.

Implemented best practices for better performance of the Dashboards and sheets.

Performed Tableau dashboard performance recording and tuned layout and queries accordingly.

Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Trace, Stored Outlines.

Resolved issues resulting from User Acceptance Testing (UAT).

Provided the Documentation and tutored the End Users how to Use Different types.

Environment: Tableau 9.0 (Desktop, Server), MS SQL Server 2012, Toad, Excel, Windows 7, Windows 2008, Excel Files, Erwin

OCT 12 – FEB 14 TELEARC TECHNOLOGIES, HYDERABAD, INDIA (DEVELOPER/TESTER)

Gathered the business requirements and converts into business requirements.

Analysis, Design and Developing test cases for SQL objects verification and testing.

Responsible for testing database program application and developing data models.

Writing and Execution of Test Cases and Preparation of Test Data

Responsible for Defect management and Bug Reporting using Bugzilla.

Performed ad-hoc and Regression testing of system components.

Tested few Business Object Reports.

Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins by using SQL Developer for report data validation.

Developed logic and code using Core Java.

Conducts Code reviews with other programs.

Designed application modules, base classes and utility classes using core java.

Troubleshot system errors.

Environment: Windows 7, SAP Business Objects, Oracle 10g, SQL Developer, Bugzilla, Java, Hibernate.

DEC 10-FEB 12 UNIQLO, LONDON, UNITED KINGDOM (SOFTWARE DEVELOPER).

Involved in the full life cycle of software design process of project, including prototyping, proof of concepts, design, interface implementation, testing and maintenance.

Imported data with validation from flat files to Oracle database using SQL Developer

Upheld quality control and data validity for Java programs

Loaded data into flat files from oracle using SQL Developer

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction

Involved in writing SQL queries, View and Materialized views, PL/SQL programming and created new packages

Responsible for Unit level testing, Module level testing and Application testing

Environment: Windows XP, Java, SQL Server 2008, Microsoft Excel 2007, SOAP

Education & Trainings Attended

Master of Science in Computer Systems Engineering from East London University, London, U.K 2008-10

Bachelor of Technology in Computer Science and Engineering from JNTU Hyderabad, India 2003-07

Tableau Server Administration from Tableau Software

Tableau Desktop Development (Fundamentals, Intermediate and Advanced) from Tableau Software

Power BI from Microsoft (Virtual Instructor Led Training)

Oracle 11G/SQL Server 2012 SQL development for Soft Sol

Contact this candidate