Uploaded File
add photo
Anil
anilgangishetti@gmail.com
334-492-2652
2336 millbrook loop
Leander, TX 78641
Sr Tableau Developer
13 years experience W2
0
Recommendations
Average rating
125
Profile views
Summary

  • 7+ years of experience in Analysis, Design, Development, Testing and Implementation of Business Applications and Client/Server applications.

  • Extensive experience working with Tableau Software as a dashboard developer and SME

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

  • Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle),Teradata, Mainframes, MS Access and client/server applications.

· Extensive experience creating canned and ad-hoc reports in Tableau Desktop.

· Involved in license management SLA's with Tableau support.

· Involved in creating dashboards and reports in Tableau 8.2. Created report schedules on Tableau server.

· Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.0 to Tableau 8.1

  • Extensive experience working in Windows, UNIX, LINUX environments.

  • Extensive experience working on trend reports, service provider functionality, sample assessment, online business intelligence and capital markets.

  • Extensive experience working in Enterprise Wide Applications.

  • Experience training end users through online and in-class sessions.

  • Extensive experience interacting with Department Managers and different levels of users and developers.

  • Experience in MS PowerPoint presentations for end users and in MS Access and MS Excel.

  • Ability to communicate business and technical issues to both business users and technical users.

  • Excellent communication skills, strong team-building and conflict management skills.

  • Excellent ability to work independently and as a part of a multi-functional, geographically diverse team.

  • Knowledge of Cognos and OBIEE reporting tools.

  • Experience in relational modeling through IBM DB2 on different OS like windows, Linux.

Experience
Sr Tableau Developer
Information Technology
Jan 2014 - present
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
  • Installed Tableau Server 8.1 in Dev, QA, UAT and Prod environments.
  • Upgraded Tableau 8.1 environment to Tableau 8.2
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Hands-on development creating and modifying worksheets and data visualization dashboards.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop.
  • Access dashboards from any browser or tablet.
  • Created incremental refreshes for data sources on Tableau server.
  • Coordinated database middleware issues with DBA's, system performance with System Architects.
  • Involved in license management SLA's with Tableau support.
  • Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
  • Defined and created procedures to install Tableau desktop in silent mode.
  • Defined best practices for Tableau report development.
  • Extensively used Tabadmin commands in creating backups and restoring backups of Tableau repository.

Tech Environment: Tableau Desktop 8.2/8.1/8.0 , Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g,IBM DB2, Microsoft Excel 2007, MS Access , Windows 2007 server, java 1.5 platform, Microsoft office 2007 .

Tableau Data Analysis SQL Server 2008 Tableau Server Business Intelligence SQL Server SQL Tableau Desktop Analysis Oracle Java Xcelsius Crystal Reports Data Visualization DB2 SQL Developer Windows
Remove Skill
Tableau Developer
Information Technology
Mar 2012 - Feb 2014
  • Developed a dashboard to measure critical KPIs including admission rates, patient waiting time, referrals, and patient satisfaction.
  • Involved in Exploring, Designing, Building, QCing and Deployment the high level dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics using Tableau 7.0 & 8.0 tool.
  • Involved in understanding the reporting requirements and providing Tableau reporting solutions.
  • Adhered to good systems agile development methodology.
  • Developed, maintained and documented highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
  • Developed universe using Information design tool (IDT)
  • Good experience in Tableau Business Intelligence Tool for dashboard development.
  • Presented to higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
  • Coordinated and conducted business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, and DBA’s and project managers.
  • Worked to understand Business requirements, analysis and translated them into Application and operational requirements.
  • Translated functional requirements of the reports build into technical specifications document.
  • Involved in the complete process cycle; functional skills in analyzing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
  • Developed and executed test cases and test plans for functional performance of the reports.
  • Translated functional requirements of the reports build into technical specifications document.
  • Tuned Universes for Report level performance.
  • Designed deliverable content to precisely reflect the engagement contract and client needs and strive to improve deliverable quality through verification and validation of results.
  • Designed aggregated tables on the most frequently queried data for Daily, Monthly & Yearly based reports.
  • Wrote PL/SQL validation queries for cross testing the resulting data from the reports.
  • Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
  • Created Classes and Objects for management system based on the warehouse schema in Universe.
  • Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
  • Migrated number of reports from Dev /Test to Production environments.
  • Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Loves.
  • Revised the Group Structure in both Development and Production Environments.
  • Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
  • Created alerts, filters and inserted Breaks in designing reports.
  • Design processes to minimize data quality risks and proactively identify potential data issues.

Environment: Tableau 7.0, XI R3.1,QAAWS, Oracle 11g, PLSQL, SQL SERVER 2005,TOAD, UNIX , BI 4.0 Launch Pad, Xcelsius Dashboards

Tableau Data Analysis Business Intelligence SQL Server Tableau Server Tableau Desktop PL/SQL Xcelsius UNIX UniVerse Unit Testing TOAD Oracle Quality Assurance SQL Analysis Data Integrity Business Requirements Agile Methodology Project Management Solutions Architecture Business Analysis System Requirements
Remove Skill
Tableau Developer
Information Technology
Mar 2010 - Feb 2012
  • As a CFS team member, interacted with Functional/End-users to gather requirements for Core reporting system.
  • By understanding Exceptional features and User expectations for reporting system, by designed Business Requirement Packages (BRP's) to successfully implement Business logic.
  • Worked in Tableau environment to Create dashboards including weekly , monthly , daily reports.
  • Utilized Tableau Desktop to publish them to server
  • Managed Production, Test and Development environments including installation of patches, security administration and access controls.
  • Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
  • Resolved the loops using Contexts and checked the Integrity of the Universes.
  • Exported the Universes to Repository for making it available to users
  • Created complex reports like Detail level Transaction reports, monthly Aging, YTD cash goal reports,
  • Created Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
  • Created Complex workbook to visualize Wal-Mart & Target sales using scattered plots , bar charts by tableau desktop
  • Applied Multi-dimensional analysis such as slice and dice, drill functions at report level.
  • Created Workbooks and dashboards for analyzing statistical billing data using Tableau 6.0
  • Identify risks associated with the testing strategy, then document and communicate such risk to stakeholders
  • Involved resolving Error's in the reports like context error, Syntax errors, Multivalve Error, Timeout errors,
  • Created custom Function's (Date range, Time functions, array functions, and Conditional formatting functions in the reports.

Environment: Rich Client, Info-View Web Intelligence, CCM, CMC, Designer, Crystal Reports XI, Crystal Xcelsius 2008, SQL 2008, Oracle 10g, SAP LOGON GUI 7.10 (FSCM ERP R/3), ECM Live link workspace, Import Wizard, Microsoft Excel 2007, Tableau 6.0

Tableau Data Analysis Business Intelligence SQL Server Tableau Desktop Xcelsius Web Intelligence UniVerse SQL Requirements Gathering PS FSCM Oracle Microsoft Excel LiveLink SAP Business Requirements Crystal Reports ERP
Remove Skill
SQL Developer
Information Technology
Aug 2008 - Feb 2010

This project is been designed for Pragathi Organics Ltd. Industry, that they want to computerize their operations. In the view of the huge database required for this industry and the security Oracle database has been preferred. This company is involving in production and exports of different chemical products user interaction is provided through main menu comprising display choices to maintain customer order, sales order, purchase order, inventory debt , supplier and production unit. Proposed functionalities for each of the unit and database development based on the information with respect to the organization flow.

Responsibilities:

  • Tested and documented the databases created.
  • Gained understanding of the business process/requirement and translated them into technical requirements.
  • Created Database Objects like Tables, Views, Synonyms and Sequences.
  • Extensively used of PL/SQL Stored Procedures, Functions, Triggers and Packages.
  • Tested the entire application in testing environment and exported to production.
  • Done the documentation and provided on-site production support.

Test Environment: Oracle, SQL, PL/SQL, Windows.

SQL Server 2008 SQL Server Triggers Technical Specifications Stored Procedure PL/SQL Oracle SQL Documentation SQL Developer Database Design Production Support Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Skills
Windows
2021
8
Oracle
2021
7
SQL
2021
7
SQL Developer
2021
7
SQL Server
2021
7
Crystal Reports
2021
6
Business Intelligence
2021
5
Data Analysis
2021
5
DB2
2021
5
Tableau
2021
5
Tableau Desktop
2021
5
Xcelsius
2021
5
Data Visualization
2021
4
Analysis
2021
3
Business Requirements
2014
3
PL/SQL
2014
3
SQL Server 2008
2021
3
Tableau Server
2021
3
UniVerse
2014
3
Agile Methodology
2014
2
Business Analysis
2014
2
Database Design
2010
2
ERP
2012
2
Java
2021
2
Production Support
2010
2
Project Management
2014
2
Solutions Architecture
2014
2
System Requirements
2014
2
Data Integrity
2014
1
Documentation
2010
1
LiveLink
2012
1
Microsoft Excel
2012
1
PS FSCM
2012
1
Quality Assurance
2014
1
Requirements Gathering
2012
1
SAP
2012
1
Stored Procedure
2010
1
Technical Specifications
2010
1
TOAD
2014
1
Triggers
2010
1
Unit Testing
2014
1
UNIX
2014
1
Web Intelligence
2012
1
Cognos
0
1
Linux
0
1
OBIEE
0
1
Snowflake
0
1
Teradata
0
1