SUMMARY

• Around 7 years of experience in Data Visualization, Business Intelligence & have worked in developing reports and Dashboards in Tableau.
• Experience in building both n - tier static and interactive web applications & e-business projects using ColdFusion, Asp.Net, JavaScript, CSS, Oracle 9i, SQL server 2005/2008 and ColdFusion Application Server and Java
• 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 and Parameterized 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.
• Strong experience in programming with .NET framework and using C#, Asp.Net, Web API, WCF services.
• Experience in Web Services, WDDX and Fuse box

TECHNICAL SKILLS

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

Web Technologies: ColdFusion, Adobe Pagemaker, Photoshop, Adome Image ready, Visual studio .net, Viusal source Safe, ShockWave

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, Pleasanton, CA

Tableau Consultant

Responsibilities:

• Worked with the client and team members to understand and clarify visualization requirements
• Created the reports using external data files (xlsx, csv) or database queries for Tableau Desktop. Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Written complex SQL queries and optimized queries for performance tuning.
• Involved in data migration to snowflake using AWS S3 buckets.
• Recreated existing SQL Server objects in snowflake.
• Also converted SQL Server mapping logic to Snow SQL queries.
• Built different visualizations and reports in tableau using Snowflake data.
• Wrote different Snow SQL queries to interact with compute layer and retrieve data from storage layer.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Worked extensively with Calculations, Actions, Parameters, Background images and Maps. Created Trend Lines, Groups, hierarchies and Sets to create detail level summary reports.
• Created dashboards in Tableau Desktop and published onto Tableau Server.
• Worked on advanced viz charts like Bubble, Donut and Step chart. Created Drill down analysis for dashboards.
• Created conditional filters to filter the data on dashboard and creating Parameters for desired functionality.
• Created complex reports like Detail Level Transaction report's and MTD/YTD calculations.
• Involved in resolving reporting and design issues throughout the reporting life cycle.
• Published completed dashboards on to server and scheduled extract refresh.
• Strong ability in developing SQL queries to fulfil data and reporting requirements including identifying the tables and columns.
• Monitored the project processes, making periodic changes and guaranteeing on-time delivery.
• Documented a whole process of working with Tableau Desktop, and evaluating Business Requirements.

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

Confidential, Phoenix, AZ

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, Irving, TX

Tableau Developer

Responsibilities:

• Handling dashboard development in the areas of BSC Metrics and CPS.
• Upgraded Tableau 8.3 to Tableau 9.x and 10.1 and gathered requirements, chalked dashboard development plans from raw data and interacted with Data Warehousing team regarding database design
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown capabilities
• Designed and implemented the logic for cut-over strategy in data warehouse for migration of reports from SAP BO to Tableau
• Provided Production support for all the Tableau reports
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in TManaged Tableau extracts on Tableau Server and administered Tableau Server
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Alteryx is specifically used for financial data extraction for large volumes.
• Created Custom Hierarchies to meet the Business requirement in Tableau
• Defined architecture for Tableau and established Dev/QA/Prod environments
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Extensively used data blending to combine disparate data sources for dashboard development
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Administered user, user groups, and scheduled instances for reports in Tableau Online environment.
• Manage the application's users, groups, and integration.
• Used Tabadmin and Tabcmd commands in creating and restoring backups of Tableau repository.
• Tableau Server Management (like Clustering, Load Balancing, User Management)
• Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development to manage risk analysis and mitigation plans, status reports, and client presentations
• Done support for Tableau server and data source administration and Permissions model
• Participated in Tableau troubleshooting and tuning issues

Environment: ColdFusion MX 8.0, Eclipse SDK 3.5, Json, Jquery, Adobe Flex 3, XML, Crystal Reports, HTML, ColdFusion Reports, AJAX, Jnuit, Adobe Photoshop cs3, Java Script, Oracle 10g, TIBCO, HP quality Center

Confidential, Rochester, NY

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users. forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data. Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Adobe Dreamweaver CS3, Adobe Flex 3, Adobe Flash CS3 with Action Script 3.0,XML, Crystal Reports, HTML, ColdFusion Reports, Adobe Fireworks CS3, Adobe Photoshop cs3, Java Script, SQL Server 2008 and 2005/Oracle 10g.