SUMMARY

• Extensive Experience of 5+ years in Tableau Desktop and Tableau Server with SQL/ETL in various versions of Tableau 8.0, 8.1, 8.2, 9.0, 9.3, 10 as a Developer.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expert in design/development using Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• 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, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive Knowledge in use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project.
• Outstanding knowledge in writing complex SQL queries.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Experience in ETL implementation using SSIS for loading the data from Various Data sources to using Variables, Parameters and Configurations to Other destinations
• Strong data analysis expertise in the field of Financial Analysis, Financial Modeling, Capital Markets, Industry Research and Product Development.
• Extensive experience using Tableau Server, Tableau Desktop and Tableau Public.
• Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS.
• Extensively worked on Business Intelligence technologies like SSIS, SSRS, and SSAS of MS SQL server 2005/2008/2012.

TECHNICAL SKILLS

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Databases: MS Access, SQL Server, Oracle

Tools: Tableau Desktop v7/v8, Tableau Server v7/v8

Data warehouse /BI Tools: Informatica, Teradata

MS Office Suite (365): Word, Excel, Access, PowerPoint, Project, Outlook

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP, UNIX,LINUX.

Languages: SQL, PL/SQL, C, HTML, XML, XSL

Others: SQL management studio, Visual studio, SAP, BIDS, Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, Apache Tomcat 5.0, Visual Basic 6.0,Jmeter, SSIS, SSRS,Cognos, Visio, SQL Developer, SQL Tools, Automate MS Office

BI Tools: Business Objects 4.1, WebI, Crystal Reports XI/ 2008, Xcelsius, Toad 9.0, Tableau 9.0/8.x

ETL Tools: SSIS(Microsoft SQL Server Integrated Services), Data Stage

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, Boston, MA

Responsibilities:

• Understanding the business requirements by interacting with the business users.
• Created own customized visualizations in tableau.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Developed effective dashboards according to the requirements of the clients by using Tableau Desktop.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Conduct kick off and follow up client meetings for these dashboards
• Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
• Design, configure, and document Tableau Data Source and Extract
• Built the Data Visualizations using Charts, Drill - Downs, and Quick Filters.
• Built the Dashboard View for Senior Executive Team.
• Involved in writing SQL queries using Teradata, Oracle 10g.
• Liase with various stakeholders to gather requirements and write functional requirement documents and mapping documents.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Schedule and maintain packages by daily, weekly and monthly in SQL Server Agent.

Tableau Developer

Confidential, Boston, MA

Responsibilities:

• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Developed story telling 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Involved in creating dashboards and reports in Tableau 8.0 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked with Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in Upgrade of Tableau Server from v7.0.12 to v 8.0.7 and also Created Users, Groups, Projects, Workbooks and assigned Access levels in Server.
• Conducted Training sessions for Tableau Power users and created the documents for end-user support.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Created report schedules on Tableau server.
• Created drill down and drill up in worksheets in tableau
• Users to interpret functional requirements into report specifications. Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries.
• Extracted data using SSIS packages ETL from different server locations and data sources
• Had conducted deep dive meetings with the business users to understand the current automation process and Adhoc jobs for budget/forecast calculations
• Documented various business requirements, deployment plans and prepared various users guides to facilitate the users to learn and adapt to the new systems.

Jr Tableau/SQL Developer

Confidential

Responsibilities:

• Worked as a Tableau admin, in charge of the report development and maintenance
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Built and maintained many dashboards.
• Training classes to the employees on Tableau Software.
• Creating dataflow diagram and documenting the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Worked on the requirement gathering of the reports
• Analyzed the database tables and created database views based on the columns needed.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Implemented calculations and parameters wherever needed.
• Published dashboards to Tableau server.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.