ANBU
TABLEAU DEVELOPER
Professional Experience:
- 5+ years of experience as Tableau developer
- Main responsibilities are developing Business Intelligence Solutions using Tableau Desktop, Tableau Prep Builder and SQL Server.
- Excellent understanding Business Process Flow and extensively used data extraction, visualization, validation techniques, Data Integration, Data Coding and Data Modelling methods.
- Tableau Dashboards and Reports created from various data sources like SQL Server Database,Excel, CSV data.
- Hands on experience in ETL using Tableau Prep Builder. Used Tableau Prep to combine, shape, Clean the data, Aggregate values, Pivot tables. Created data sources for Tableau desktop.
- Using Tableau Prep performed cleaning & shaping the data using followed functions such as Sorting, Split and merge columns, Filtering Include and Exclude values, Renaming fields, Handled null values & Grouping values.
- For multi table analysis, created various data modelling methods such as Joins, Union and Relationships.
- Created and saved Flow with various steps and functions involved in Tableau Prep Builder
- Output the Flow to a File, Published data source or to the Data base.
- Created KPIs, dashboards using stacked bars, bar graphs, scattered plots, geographical maps, Text tables, Line charts, Heat map, Tree map, Some Customized charts.
- Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.
- Individually testing reports before Publishing into Test environment
- Publishing reports into different environments (Dev, Test and Production server).
- Maintaining reports and checks performance testing and resolving issues on reports.
- Manage tables in SQL Server, Writing Custom SQL queries to perform joins and union.
- Published and maintained reports in Server as well, Schedule reports, add Users and set permissions.
Technical Skills
-
- Reporting Tools : Tableau Desktop, Power BI,
- ETL : Tableau Prep Builder,
- Data Base : Ms SQL Server,
- Operating System : Windows.
Employment History
- Working as Tableau Developer from April 2022 to Oct 2022
- Working as Tableau Developer at J&S Global from July 2017 to Dec 2021.
Project 3:
Project Name : Wealth and Asset management Analytics ( April 2022 to October 2022)
Client : Gamco Investors
Role : Tableau Developer
Environment : Tableau Desktop, Ms SQL Server,Tableau Server.
Description: This is US based fund management organization. Developed reports such as Account
performance summary, Client asset and performance summary, Portfolio Holding, Tax lot summary
report.
Responsibilities:
- Interacting with clients and getting business requirements to develop reports.
- Analysing the data and creating data modelling method to establishing the relationship between the tables.
- Build different KPIs using designed key figures and insights.
- Develop and design different visualization reports with the help of various charts and tableau functions.
- Worked extensively with Advance analysis, Calculations, Parameters and Customized charts.
- Involved in performance checks in existing dashboards.
- Utilized Tableau server to publish and share reports with business users.
- Scheduled extract refresh to published dashboards in server.
- Also involved in administration tasks such as setting permissions, adding users and creating groups.
Project 2:
Project Name : Revenue Analytics (Oct 2019 to Dec 2021)
Client : J&S Global
Role : Tableau Developer
Environment : Tableau Desktop, Tableau Prep, Tableau Server,Power BI Ms SQL Server.
Description: Report contains the sales & service information of their Business Partners such as Ashok Leyland, Wabco, Alcoa wheels and Service Mandi. Displayed Total Revenue, Labour revenue, parts revenue, vehicle model wise and customer wise revenue.
- Understanding business requirements and plan solution to address data need.
- Designed, developed, tested, maintained BI reports based on user requirements.
- Working closely with DB team for getting optimized queries and performance checks.
- Used Tableau Prep for ETL workflow to connect data sources, Cleaned data then combining i