SUMMARY:

• Around 6+ years of experience in Data Visualization, Business Intelligence & have worked in developing reports and Dashboards in Tableau.
• Extensively worked on various Tableau desktop 7.x/8.x/9.x/10.x versions, Tableau Server, Tableau online, Tableau reader.
• Experience in creating dashboards using calculations, groups, sets, parameters, calculated fields, and hierarchies.
• Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters
• Extensive experience in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
• Data blending to create views combining data from multiple data sources.
• Extensively involved in creating users, user groups, roles, scheduled instances for reports in tableau server.
• Expertise in SQL Server Integration Services and SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS).
• Extensive experience 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, Waterfall Charts, Geographic.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in connecting and extracting data from different data sources.
• Extracting data from data sources like Sales force, SQL server and Excel files for getting data to Tableau for creating various dashboards.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option andParameterized and Linked reports using Tableau.
• Experience in publishing Dashboards and presenting dashboards on web and desktop platforms to Tableau Server.
• Exposure to Amazon web services.
• Experience Working in Agile, Waterfall and Scrum project management methodologies.
• Worked with the data architects and ETL team to finalize the data model and transformations for the data mart
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.
• Experience in data modeling techniques like Snowflake Schema, Star schema, Fact, and Dimension tables.
• Strong knowledge of Software Development Life Cycle(SDLC) methodologies like waterfall, Agile Scrum.
• Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality.
• Excellent skills in communication & collaboration, Strong analytical, logical, problem-solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Tableau: Tableau desktop 7.x/8.x/9.x/10.x, Tableau Server, Tableau online, Tableau reader

ETL Tools: Informatica, SSIS, SSRS, SSAS.

Databases: MS SQL Server, Oracle 10g,11g,Teradata

Programming Languages: SQL,TSQL,PL/SQL

Scripting Languages: HTML5,CSS5,JavaScript

Operating Systems: Windows XP/7/8/10,Mac,Unix

Methodology: Agile, Waterfall, Scrum

PROFESSIONAL EXPERIENCE:

Confidential - Columbus, OH

Tableau Developer

Responsibilities:

• Performed as Tableau Developer and Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Worked closely with Business Analyst in gathering various requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• The building, publishing customized Interactive reports and Dashboards, report scheduling using Tableau Server.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Exposure to Amazon web services.
• Created Adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards by joining multiple complex tables.
• Created security parameters for tableau dashboards at the row level.
• Used excel sheet, flat files, CSV files to generate Tableau reports.
• SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in SQL Server 2012 Self Service BI tools like Power view, BISM Tabular models and SQL Server Data tools.
• Used advanced concepts - blending, LOD to meet the customer requirements.
• Experience in Data Conversion and Data Migration using DTS and SSIS services across different databases like Oracle, MS access and flat files.
• Generated Dashboards with Quick filters, Parameters, andSets to handle views more efficiently. Published Workbooks by creating user filters.
• Hands-on development assisting users in creating and modifying Worksheets and Data Visualization Dashboards.
• Created report schedules, Data Connections, Groups in Tableau server.
• Generated Tableau Dashboards for Sales with Forecast and Reference Lines.
• Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting.
• Executed and tested required queries and reports before publishing.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Skilled in Tableau Desktop for data visualization through various charts such as Bar Charts, Line Charts, Scatter Plots, Pie Charts.
• Created extracts and published data sources on Tableau Server for the users from various databases.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop, Tableau server, Tera Data 14, Teradata SQL Assistant, My SQL, Oracle, MS Excel.

Confidential - Reston, Virginia

Tableau Developer

Responsibilities:

• Performed as Tableau Developer and Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Interacted with client to understand the requirements.
• Worked on New report, dashboard requests using Tableau 8.x on top of Oracle 10g, Teradata.
• Tuned the SQLs, reports for improved performance.
• Resolved multiple report errors.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Created a number of SSIS packages using advanced tools to pull data from various data sources including flat files, MS-Access, Excel, SQL Server/Oracle databases, etc.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Created SQL Agent Jobs, Alerts, to schedule DTS/SSIS packages.
• Excellent Knowledge in Data Warehouse Concepts, Data Modelling, ETL and worked on OLTP & OLAP in all environment which includes development (DEV), test (QA) and production (PROD).
• Experience with Teradata/ Oracle/ MS SQL Server and ability analyse data sets using SQL.
• Experience in working with Oracle 12g/11g/9i/8i, MS SQL Server 2000/2010/2012/7. x running on Windows 2000/XP.
• Analyzed several data issues and got them corrected where applicable.
• Extensively worked on different types of filters.
• Used trend lines extensively for correlating different KPI’s for new product launches.
• Created custom Function's (Date range, Time functions, Logical functions) in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Provided training to Business users in using Tableau.

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

Confidential - New York

Tableau Developer

Responsibilities:

• Performed Been a single point of contact to understand and make the enhancements.
• Worked on New report requests using Tableau 8.0.
• Written Custom SQL for retrieving the limited data from Tera Bytes of Data.
• Created visually appealing reports which captured Top Artists, Albums and Songs for Spotify system.
• Extensive Experience inSuit Tableau Desktop/Server/online 10.x/9.x/8.x/7.x/6.x and SAP Business Objects 3.x/4. x.
• Performed trouble shooting of performance issues associated with reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Acquired the understanding of the complex logical and physical design of the reporting system.
• Performed Data Warehousing and ETL using Informatica Power Center9.5.
• Creating the SQL queries based on source to target mappings for Target tables.
• Worked with DBA’s on various issues like table space and table locking issues, long running query analysis and so on.
• Created Unit Test cases and captured Test log
• Analyzed requirements for various reports, dashboards, created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using Tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Worked on extensively large data volumes, experience writing SQL against databases using Toad, SQL developer to write queries for understanding data and testing dashboard output.

Environment: Tableau Desktop 8.0, Tableau Server/Administrator, ParAccel (DB), Windows XP, SAP Business Objects XI 3.1, Oracle 10g, Windows/UNIX.

Confidential

Tableau Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
• Generated Tableau combination charts using Tableau visualization software.
• Created Technical Design Document from the functional specification documents.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• 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.
• Identify new metrics and enhance the existing KPI's.
• Design, create and extend application layer to manage the data repository and ETL (Extract, Transform, and Load) feeds from multiple sources.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
• Reverse Engineered SQL Server Reports into Tableau Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Created various actions in database like filter actions to send information to other tableauworksheets and to connect the same in analytical flows.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server

Environment: Tableau Desktop/Server 8.x,SSIS, SQL Server, DB2,Data Studio, Microsoft Office Suite (Word, Excel, Power Point, Visio).

Confidential - Lutherville, MD

Software Developer

Responsibilities:

• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to the server.
• Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts etc.
• Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.
• Used Context filters and Created Geographic map reports which explain the company financial keysaccording to the members.
• Created Sets, Groups, and Data Bins as per user requirements.
• Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Created views using various axes like Individual Axes, Dual Axes.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input control to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
• Created and Published Tableau Dashboards into Tableau Server.
• Effectively involved in the maintenance of Data Server, metadata management, creating shared Data sources and publishing them to Tableau Server.
• Developed the table documentation for Tableau Dashboards.
• Enhancement of existing reports to improve performance by modifying the SQL code used in the extraction of data.
• Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
• Working with Level of Details expressions and Regular Expressions which are helpful in providing ETL functionality for the tableau.
• Migrating reports from standard reporting tools like excel to the tableau.
• Migrating all the reports from tableau 9.3 to tableau 10.3 and publishing them on the server.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, MS Excel, MS Access, Windows 2010 server