SUMMARY:

• Professional Tableau developer with around 7 years of experience encompassing a wide range of skill sets in data analytics.
• Proficient in building metrics, reports and compelling visualizations using Tableau.
• Sound experience working with large datasets and intensive data cleaning.
• Experienced in preparing detailed reports and effectively communicating analysis through storytelling and data visualization.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters.
• Developed and modified Business Intelligence analytical reports/ dashboards dealing with Origination, Portfolio Risk, Consumer Credit, FP&A and Marketing using Tableau.
• Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas.
• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online.
• Experience with statistical analysis, modeling, clustering & analytics of data using Tableau.
• Extensive knowledge in modeling Business Processes (As-Is and To-Be), Use Cases, Activity Diagrams, Data Flow Diagrams, Process flow Diagrams, and Network diagrams.
• Experience of creating Functional Specification Documents (FSD), Business Requirement Documents.
• Expertise in Performance Tuning of Tableau reports by following best practices in source data like data blending, custom SQL etc.
• Extensive experience in ETL design, development and maintenance using SQL, PL/SQL, SQL Loader.
• Strong SQL and PL/SQL skills with good knowledge of RDBMS concepts.
• Well verse in writing SQL queries such as indexes, Stored procedures, view, functions and tables in MS SQL Server and Oracle database platform.
• Excellent understanding of Data modeling (Dimensional & Relational) using fact and dimension tables and relational databases (Oracle), OLAP SAP BW, MS Excel, MS Access, Teradata and DB2.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Expertise in Using the MS-excel, Pivot Chart, Pivot Tables, Vlookup.
• Experience handling Structured and Unstructured data.
• Work independently to complete project without direct supervision.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.

TECHNICAL SKILLS:

Database, RDBMS: Oracle 10g, 11g, SQL Server, SQL Server Management Studio (SSMS), TeraData

BI Tools: Tableau 10.X/9.X/8.X/7.X/6.X, Tableau Desktop, Tableau Server, Tableau Public, MS Office (Excel, Word, Powerpoint), SQL Server, Reporting Services (SSRS), SAP Business Objects, SAS Enterprise Guide, R Studio

SQL, T: SQL, PL/SQL, SAS, R

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Tableau Developer/BI Analyst

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Developed and modified Business Intelligence analytical reports/ dashboards dealing with Origination, Portfolio Risk, Consumer Credit, FP&A and Marketing using Tableau.
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extracted data from various sources (SQL Server, Teradata, TrackWise, SAS, text files and excel documents)
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts etc., to assist business users in solving complex problems.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created very complex Dashboards using Tableau using the drill down, drill across, actions for business committee.
• Design and development of various reports and dashboards with various device layouts that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Used ETL load scripts to manipulate, concatenate and clean source data.
• Used SAS Enterprise guide for data cleaning.
• Generate context filters and use performance actions while handling huge volume of data.
• Co-ordinated Tableau TWBX files till UAT/Production environments.
• Configuring scheduled updates (Automatic and User notified) for optimal performance.
• Monitored user activity on a weekly basis for benchmarking adaptability and usability of reports.

Environment: Tableau Desktop, Tableau Server, SQL, SAS, SQL Server, Oracle 11g, MS Office.

Confidential

Tableau Developer

Responsibilities:

• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units.
• Extensive use of R programming for data cleaning purposes.
• Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
• Worked on building queries to retrieve data into Tableau from SQL Server and Oracle SQL.
• Developer and developed T-SQL statements for loading data into Target Database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Environment: Tableau Desktop, Tableau Server, Oracle SQL developer, SQL Server, Oracle 10g/11g, Teradata, R, MS Office.

Confidential

Tableau Developer/Analyst

Responsibilities:

• Understanding existing business model and customer's new requirements.
• Created workbooks and Dashboards using calculated metrics for different visualization requirements.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created dashboard views from provider information data to members.
• Extensively created visualization dashboards for the claims.
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Involved in creating dashboards, reports and then published on to the Tableau server.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau desktop.
• Created extensive custom joins for blending data from several different data sources.
• Helped customize Tableau Server with Company Logo.
• Introduced several Levels of Dashboard Drill Down and links to interrelated performance metrics.
• Created and assisted users in Tableau dashboard development
• Coordinate new data development, which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.
• Extensively worked on ETL design development and maintenance.
• Collaborated with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop as per requirement.
• Created a proof of concept for the optimal data integration process.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Log Axes, Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Created workbooks and Dashboards using calculated metrics for different visualization requirements.

Environment: Tableau Desktop, Tableau server / Administrator, Windows, Oracle 10g, Teradata, SAP Business Objects.