Vamsi

BI-Tableau Developer

347-***-****

ac2f8f@r.postjobfree.com

Over 8+ years of IT experience Specialized in Data visualization, Dash board Development, Implementation, testing of software applications to support reporting and Business Intelligence Initiatives.

Extensively worked on various Tableau desktop 7.x/8.x/9.x/10.x versions, Tableau Server, Tableau online, Tableau reader.

Experience in creating rich interactive visualization reports and dashboards in Tableau Desktop and server utilizing LOD, Filters, Actions, Parameters, sets, Groups, Extracts, Data Blending, Page Trails.

Extensively involved in the development of various interactive dashboards and reports such as Dual Axis, Pie-charts, Heat Maps, Waterfall Charts, Funnel Charts, Bar Graphs, Bubble charts, Box plots, Tree Maps.

Extensive experience in publishing Tableau dashboards to Tableau Server.

Excellent knowledge in administrative activities such as configuration, Installation, upgrades, and documentation.

Extensively involved in creating users, user groups, roles, scheduled instances for reports in tableau server.

Worked with various teams in gathering user needs and documenting them in business requirement documentation.

Extensively involved in Unit, System, User Acceptance Testing also involved in performing data validation for the dashboards that are generated from various data source.

Worked on MS Visio for database design and development of Entity Relationship Diagrams.

Effectively utilized various Tableau features such as Dashboards, Stories, Quick POCs and worked with senior managements in analyzing the data trends, well utilized future forecasting option.

Solid understanding on Microsoft SQL Server Integration Service(SSIS), SQL Server Reporting Service, MS Access, MS Excel, MySQL.

Proficient in developing Stored Procedures, Triggers, User Functions, SQL joins, Sub queries.

Excellent knowledge in developing Drill down and Drill through reports in SQL Server Reporting Services.

Extensively worked on various filters such as Data Source filter, extract filter, Context filter, Measure filter and global filter.

Extensively involved in performance tuning of reports and involved in resolving issues related to tableau server.

Experience in data modelling techniques like Snowflake Schema, Star schema, Fact, and dimension tables.

Strong knowledge of Software Development Life Cycle(SDLC) methodologies like waterfall, Agile.

Strong Individual contributor, good team player, problem solving skills, ability to work under pressure, fast learner.

Skills:

Reporting Tools

Tableau 10/9.4/9.2/8.x/7.x, SSRS

ETL Tools

SSIS

Databases

My SQL, SQL Server, Oracle 10g/ 11c/9i/8i, AWS Redshift.

Data Warehousing Modeling

Snow flake schema, star schema, Fact Tables, Dimension Tables

Operating Systems

Windows, Unix, Red Hat Linux

Programming Languages

SQL, PL/SQL, JAVA, UNIX

Other Tools

TOAD, MS OFFICE, MS VISIO, HP ALM, Quality center

NBC Universal, New York city, NY

Sr. Tableau Developer Feb 2016 to Current

Responsible for conducting requirements gathering sessions with corporate senior information risk officer, Information Risk Management Teams.

Prepared Business use cases and converted it into analytical use cases for conceptualizing Tableau dashboards with the captured ADAP data stream.

Used Data blending to join the Data stream from various heterogeneous data sources to get the desired mapping.

Implemented row level, column level, and table level calculations in generating tableau reports and dashboards.

Extensively utilized Level of detail(LOD) expressions like include, fixed, and Exclude to create visualizations that are different from view level.

Using Data Blending Developed Tableau workbooks from various data sources.

Developed Tableau data visualization using Heat Map, Tree Map, Area Chart, Scatter plots, Bar Chart, Stacked Bars, Bullet Chart, Area Chart, Scatter plot, Gantt chart, Donut chart, Pie Chart.

Performed Comparison analysis via combination of Line/Bar charts, Line/Line Charts using Tableau dual axis feature.

Worked on creating the dashboards for weekly, monthly, daily reports using tableau Desktop.

Used Complex SQL queries at Meta data window to restrict the data source to only useful ones.

Used Data source filter, context filter for restricting visualization to desired data set, used filter action for further drill-down from one worksheet to another.

Performed the Sentiment analysis, time series analysis, Trend analysis with created visualizations.

Extracted data from various data sources such as SQL server, Excel files, Salesforce to create Tableau dashboards.

Acted as Tableau coach in migrating the data from various data sources to Tableau Dashboards.

Involved in scheduling tasks and then checking the tasks on the server on daily basis.

Publishing the dashboard to the Tableau Server to share the reports with the business users.

Published the Created Tableau Dashboard to development server and then subsequently to QA and Production server.

Performed web authoring of published Tableau content and edited reference line distribution.

Thoroughly supported the end users for further custom enhancement in line with Line of Business (LOB) requirement.

Continuous improvement of dashboard design to increase data visibility and provide improved insights through Cross-sectional analysis, drill-able insights and self-explanatory report structures and visualizations.

Documented the requirements, conducted walk-through sessions with development team.

Performed Functional Acceptance Testing, Facilitate User Acceptance Testing with CSIROs and IRM Teams, Facilitate production moves.

Trident Maritime Systems, Crozet, VA

Tableau Developer Nov 2014-Jan 2016

Data Pulse Reports are set of 50+ analytical visualizations developed through Tableau using the data information from Data Pulse Big Data.

Used best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel.

Developed custom designed dynamically chart selection driven dashboard which shows 10+ data visualization in a single dashboard.

Indexed all columns whichever are part of Tableau Table Join/Filter operation to ensure improved time efficiency.

Used union table feature in Tableau during the Meta data connection window in order to leverage database structure and schema.

Created multiple visualizations using Bubble chart, Bar chart, Line chart, Pie Chart, Donut chart, Scatter plot, Gantt Chart, side by side Bars, side by side circles, packed bubbles, Histograms, Filled geo-maps, Symbol geo-maps.

Used Ranking feature in Crosstab worksheet to highlight the Top N ranks of custom chosen dimension based on specific measure.

Created multiple story to describe systematic data analysis with areas of data security risks.

Data Pulse Reports are used to analyze volume of Applications across sectors and their usage in terms of frequency and duration.

Ensured precision and maintained sanity for data table calculation using the Tableau partitioning and addressing feature.

Used the Analytics tab in Tableau and performed the forecasting feature to predict the portfolio composition in user holding in line with historical data.

Published the created dashboard in production server and maintained load balancing feature on.

Implemented advanced geographic mapping techniques and use custom geo coding to build spatial visualizations of non-geographic data.

Transformed massive datasets through grouping, aggregation, and Complex table calculations.

Consulted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.

Used advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.

Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.

Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.

Responsible for Publishing the desktop version dashboard to the server and maintenance of server activity (Versioning, Data extract refreshing via server scheduler).

Arthrex, Naples, FL

SQL/ Tableau Developer Sep 2012- Nov 2014

Created the Analytical visualizations based on the AIP data to provide the clear discrimination of in-scope vs. Out-of-scope Applications and Active vs. inactive Applications across Organization down to various departments.

Responsible for conducting requirements gathering sessions with business and prepared high level functional specification document for the application.

Created custom joins through calculations to bring multiple heterogeneous data source together.

Used advance analytics features Reference line, Reference band, Distribution band, Trend lines in creation of Tableau dashboard.

Responsible for tracking defects and issue raised by the business users and communicating the same to developers.

Participated in change request session with business users and conveying the same to developers with functional document; and tracking the progress of change request with Jira.

Responsible for the gap analysis during the assessment phase of changes.

Published the dashboard to the server and maintained the server sanity with the use of in Tableau in memory feature and load balancing standards.

Tuned the database after publishing content to Tableau server.

Supported the Published Tableau dashboard while migrating to newer versions.

Epromos, Pompano Beach, FL

SSIS/ SSRS Developer Dec 2010- Aug 2012

Involved in gather the business requirement documentation and converting that documentation into functional design documents.

Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.

As per the business requirements created complex stored procedures, Triggers, User-defined functions, Queries.

Created SSIS packages using Pivot transformation, Fuzzy Lookup, Conditional Split, Term Extraction, Aggregate, Execute SQL Task, Data Flow Task, to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Designed and tested packages to extract, transform and load data(ETL) using SSIS, designs packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data conversion, For each Loop container.

Intensively worked on transformations like derived columns, import columns, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.

Created Drill-down and Drill-through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.

Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).

Deploying reports to reports server, proving features for reports to show in PDF format as per the requirement and printing all the reports in a batch process for monthly Statements.

HSBC, India Feb2009- Nov 2010

Title- Jr. SQL server Developer

Responsibilities:

Interacted with Team and involved in Analysis, Design and Developing databases using ER Diagram, Normalization, and relational database concepts.

Involved in Design, Development, and testing of the system.

Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).

Applied Normalization rules in designing the database.

Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.

Developed database objects like Tables, views, stored procedures, indexes etc.

Tuned SQL statements using views and Stored Procedures.

Rebuilding the indexes at regular intervals for better performance.

Wrote various stored procedures for application development.

Wrote SQL Scripts to select the data from the source. Designed and implemented data access stored procedures and triggers for automating tasks.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.

Creating and automating the regular Jobs.

Tuned and Optimized SQL Queries using Execution Plan and Profiler.

Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Involved in performing database Backup and Recovery.

Education

Bachelors in Computer Science

Contact this candidate