SUMMARY

• Qualified professional with 6+ years of extensive IT Experience as a Tableau Developer, Data Analyst, and Business intelligence Developer.
• Worked in Various domains such as Marketing, Insurance and Pharma.
• Extensively worked on Tableau 10.4/9.x/8.x/7.x (Desktop, Server, Mobile, and Public) and Crystal Reports (2013/2011/2008 ).
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Adept in business process improvement, change request management.
• Highly Proficient inAgile, Test Driven, Iterative, Scrum and WaterfallSoftware Development Life Cycle (SDLC).
• Participated in numerous Joint Application developments (JAD) and Requirement Elicitation sessions with end - user/clients/stake holders, Subject Matter Experts and the technology group.
• Strong understanding ofData Warehouseconcepts, Star Schema, Snowflake Schema, Physical andLogical data modeling.
• Hands on experience in publishing of various kinds of interactive dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
• Expertise in creating quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for key Performance Indicators.
• Experience in creating Data Blending by merging data from different datasets. Created visualizations using scatter plots, Gantt Charts, Bubbles, Geographic Map, Histograms, Bullets, Heat maps and Density Chart.
• Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Extensive experience in using Tableau (Desktop/ Server), SQL Server, Oracle, Teradata, Informatica Power Center, Oracle 11g, and DB2.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Expertise inperformance tuning of loading the OLTP Transactions and integration of the data intoData Warehouse (EDW)and Data Marts.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Extensive experience in creatingTableauscorecards,Tableaudashboards using stack bars, bar graphs, scattered plots and geographical maps
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

BI Tools: Tableau (Desktop/Server/Mobile/Public), Crystal Reports 2013.

ETL Tools: SSIS

Databases: Teradata, Oracle, SQL Server, DB2, MS-Access, SAP HANA, Amazon RedShift

Database tools: Teradata SQL Assistant, SQL Enterprise Manager, TOADSQL Developer

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

PROFESSIONAL EXPERIENCE

Confidential, Florida

Sr. Tableau Developer

Responsibilities:

• Worked with Business Users from different functional Units and understand business challenges in terms of providing reporting solutions across organization.
• Worked directly with BI Architect, Administrator, DW / DBA team and Business Units to deliver solutions
• Updated BI Manager with any Reporting challenges and worked towards creating solutions for the same.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Designed, developed and published customized interactive reports and dashboards using Tableau.
• Used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. for preparing dashboards and worksheets in Tableau.
• Created Groups and Custom Hierarchies to meet the Business requirement in Tableau.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Participated in meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Provided support for Tableau developed objects and understand tool administration.

Environment: Tableau 10.x/9.x (Desktop/Sever), WEBI, Teradata, Oracle, SQL Server, Teradata SQL Assistant, SQL Server Management Studio, Microsoft Office Suite ( Word, Excel, PowerPoint, Visio).

Confidential

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Assisted Project Manager in developing design and specification, according to the requirement and information gathered during JAD sessions and other forms of information gathering methods.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Prepared dashboards using calculated fields, parameters, groups, sets and hierarchies.
• Creating data blending while designing a dashboard reading data from different datasets.
• Extensively worked on Tableau dashboard and SQL query optimizations and response monitoring.
• Used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Motion Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Worked with Advance analysis Actions, Drill-Down Analysis, 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
• Installed Tableau Server 8.1 in Dev, QA, and Production environments.
• Deployment of Tableau reports, creating project folders and assigning user/group permissions.
• Worked creating Aggregations, Calculated fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created actions in worksheets and dashboards for interactivity and to compare data against different views.
• Created and managed tableau server groups and permissions.
• Designed and developed aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.
• Restricted data for particular users using Row level security and User filters.
• Consulting with business partners on reporting requirements and deciding business strategies for slice and dice analysis.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Conduct demonstration for business users and interacted with end users.
• Actively participated in clarification meeting with the Clients.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.x/7.x( Desktop/ Server), SQL developer, SQL 2008, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office Suite ( Word, Excel, PowerPoint).

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Experience withTableaufor Data Acquisition and data visualizations.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Developed effective and interactive Dashboards using Parameters and Actions
• DevelopedTableaudata visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Mastered the ability to design and deploy rich Graphic visualizations usingTableau.
• Created Inventory trends, sales integration and forecast accuracy related dashboards
• Designed, developed, and maintainedTableaufunctional reports based on user requirements.

Environment: Tableau Desktop 8.x/7.x( Desktop/ Server), SQL developer, SQL 2008, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office Suite ( Word, Excel, PowerPoint).

Confidential

Database Developer

Responsibilities:

• Involved in the System study, analysis and Design for creating a robust MIS Reporting System.
• Involved in initial study, design of Data Warehouse for better Reporting for Inventory and Procurement Systems.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Used SQL*Loader to load flat files data to various tables.
• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.