PROFESSIONAL SUMMARY

• Developer with 9+ years of experience on Tableau, data discovery, data visualization, data analysis, report development, MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server in development, testing & production environment.
• Experience across multiple domains/industries - Banking, Credit/Finance, Healthcare, Insurance, Oil & Gas, Retail, Telecom.
• Create and maintain complex dashboards in Tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Build, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Experience with the design and development of Tableau visualization and dashboard solutions using Tableau Desktop.
• Involve in design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Expert in evaluating data models to design Tableau solutions.
• Extensive Experience in various Tableau Desktop reporting features like Measures, dimensions, Folder, Hierarchies, Extract, filters, Table Calculation, Calculated fields, Sets, Groups, Parameters, Forecasting, blending and Trend lines.
• Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Established Best Practices for Enterprise Tableau Environment and development processes.
• Extensive experience in Tableau Administration Tool for Configuration, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint. Administer and supervise all Tableau servers which include creation and maintenance of users, user groups, roles, assigning security on projects/sites, automate background tasks and maintaining the servers.
• Perform migration and deployment of dashboards across multiple Tableau servers.
• Responsible for writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Involved with Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• 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.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL
• Proficiency in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI Tools: Tableau Server6/7/8, Tableau Desktop 6/7/8/9, Tableau Online, Tableau Public, Tableau Reader, QlikView, OBIEE 10g,11g, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), TabCmd.

Database/ERP: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access, OLAP, OLTP, SAP.

Tools: and Packages SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, MS Office (Word, Excel, PowerPoint), Adobe Acrobat, Visio, JIRA, TOAD.

Languages: SQL, PL/SQL, C, C++, ASP.Net, HTML, XML, XSL, CSS

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

Methodologies: SDLC, Scrum, E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer

Confidential, Houston, TX

Responsibilities:

• Gathering business requirements from various users of different Departments.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively use data blending features in tableau for developing data reports.
• Define and develop best practices for Tableau report development.
• Administer user, user groups, and schedule instances for reports in Tableau.
• Execute and test required queries and reports before publishing.
• Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Create side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Coordinate with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Provide support for Tableau developed objects and understand tool administration.
• Work in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Create Custom Hierarchies to meet the Business requirement in Tableau.

Environment: Tableau Desktop 9.2, 8.1/8.2, Tableau server / Administrator, Cognos 10, Crystal Reports XI, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Teradata

Sr.Tableau Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Created Dashboards for various fields like Consumer Banking & Credit Cards for reporting purpose.
• Created Dashboard to analyze the trends for Market, Region and Branch wise for the Regional Manager to interact and filter on a branch in the Dashboard.
• Enhanced the dashboard with nested sorting feature, and URL links to apply the lock filter on a specific product and navigate around the dashboard.
• Published data sources & 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.
• Participated in meetings, reviews, and user group discussions and business groups for data driven decision requirements to create multiple Dashboards and being able to navigate from one Dashboard to another.
• Customer satisfaction is at the top priority, which includes having consistent communication and providing them with a variety of customized reports.
• These reports measure the performance against the predetermined quality specifications. Once the customer’s reporting needs understood, the reports produced according to the customer’s requirements.
• Created Scatter Plots, Box Plots Graph for customer detail dashboard with filters applied for top customers.
• Using data blending between multiple sources created Donut, Bullet, Bar in Bar graph for comparing Target Goals with Actual.
• Done Map enhancements like dynamic size and auto zoom were created and filtering through Map to Dealer city and customer city were used to analyze a Dealership or customer.
• Coordinated with data analysis process, writing queries in SQL, joining tables, pivot tables in Excel for the early process of connecting to data in Tableau.
• Solved Performance issues on Executive Business Dashboards to increase the speed for filtering on the Dashboard.

Environment: Tableau 9.x, Windows 7 SP1, Microsoft Excel 2010, Microsoft Access 2010, SQL Server

Sr. Tableau Developer

Confidential, Overland Park, KS

Responsibilities:

• Work closely with the Business Analyst to develop the visual analytics for the given data and make it available online and on mobile products.
• Create Tableau worksheets, design, develop dashboards and publish.
• Involved in creating dashboards by extracting data from different sources.
• Working with large volumes of datasets and loading delimited files into tableau.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Develop Scripts to load data into tableau and work with multiple data connections by data blending.
• Created drill through reports in dashboard.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Design and develop layout themes, develop field groups and cyclic displays.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Forecasting demand and consumption patterns. Fixing bugs and updating the software periodically.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Environment: Windows 7, Tableau 8.1/7.0, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript.

Tableau Developer/Admin

Confidential

Responsibilities:

• Created visually compelling and actionable interactive reports and dashboards using Tableau 8.0/8.1/8.2.
• Created ad hoc reports to users in Tableau 8.0/8.1/8.2 by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Implemented Data blending on multiple data sources and generated interactive dashboards.
• Generated tableau dashboards for Leadership Team with forecast and reference lines of Targets.
• Built Dashboard using various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems
• Built Active Reports in Cognos 10.2 for Business Offline Reporting and Executive Demo presentations
• Built Complex Reports having child reports, HTML items in Report Studio
• Extracting the data tables using custom generated SQL queries from Excel files, Access & SQL database and providing extracted data as an input to Tableau.
• Created Tableau scorecards and dashboards using stacked bars, scatter plots, Geographical maps & Gantt charts using show me functionality.
• Worked extensively with Advanced Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines,
• Statistics, Groups, Hierarchies and Sets to create Detail & Summary Reports and Dashboards using KPI's
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created incremental refreshes for data sources on Tableau server.
• Created, Organized, Customized Analysis and Visualized projects and Dashboards for Senior Executives.
• Deployed Tableau Server in clustered environment by adding worker machines.
• Supervised VizQL processes to monitor performance and system stability.
• Involved in License Management S
• LA's with Tableau support, Administered users, user groups, and scheduled instances for reports in Tableau.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Defined Best Practices for Tableau report development.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Developed canned / Ad-Hoc reports and complex dashboards in Tableau as needed.

Environment: Tableau Desktop, Tableau Server, MS Office Suite, Oracle SQL Server R2, SSIS & Excel

Tableau Developer/Admin

Confidential, Los Angeles, CA

Responsibilities:

• Understanding business requirements documents and developing design documents.
• Defined data source and data source views for each report as per client requirement.
• Created YoY and QoQ comparison charts using Line Graph to better understand the performance of claims over a period.
• Created reports on auto insurance by state, to show which state includes injuries and damages by applying a quick filter.
• Created user accessible reports to view the claim status.
• Created the SAS Datasets from raw data using PLSQL and joins. Deployed the same to production.
• Created SAS datasets by sub - setting production datasets according to the requirement from the modeling team.
• Extensively used formats and indexes in creating snapshot datasets for portfolios like Home equity.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services (SSRS).
• Created bar chart showing the claims closed by week filter by sales rep.
• Created report showing the average time to settle a claim (in days) using line chart.
• Designed worksheets to show different insurance products and other related information by user access using user filters.
• Designed, developed and supported legacy business intelligence solutions; Involved in triaging critical issues and root cause analysis.
• Participated in requirement gathering by meeting with Business Users and base lining the details, preparing the BRD (Business Requirement Document) and conducting application demonstration. Based on the scope of business requirements, designed the System Requirement Specifications (SRS) documents.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps and Gantt charts.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Worked extensively with Advance analysis Actions, 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
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Involved in installation of Tableau desktop 8.2, Tableau server Application software, Creating users, groups, projects and Data connections, settings as a tableau administrator.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting.
• Created Crosstab reports to display underlying data based on various graphs and charts created for further data analysis.
• Organized one on one, group meeting with the business users to present and get BRD sign off.
• Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to tableau reports and Dashboards.
• Created context filters to limit data sourced into tableau engine.
• Created parameters to give ability to users to dynamically change the filters and see resulting numbers.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server, which allowed story telling behind the growth in insurance policies with Quick Filters for on demand needed information with just a click of a button.
• 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.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server
• Maintenance of server activities, user activity, and customized views on Server Analysis.
• Created Business requirement documents and plans for creating SQL views and dashboards.
• Developed and refactored code of the existing applications or reports to extract the data from various data sources like DB2, ORACLE.
• Created Action filters in worksheets and dashboards.
• Involved in installation, configuration, patching and upgrading of Tableau tool across the environments
• Involved in managing the application's users, groups, and integration with Active Directory
• Involved in Tableau Server Management (like Clustering, Load Balancing, User Management)
• Worked on taking back ups and restoration of Tableau repository
• Peer review of reports and SQL queries.
• Added background images to add more context to the marks in the view.
• Address any issues/clarifications logged in JIRA.
• Participated in weekly meetings, reviews, production support meetings.
• Involved in installing tabcmd to schedule the report's and setup email reports.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: Tableau Desktop 8.3/8.2/8.1/8.0 , Tableau Server/Administrator, tabcmd, SQL developer, SQL 2008, Oracle 11g, Microsoft Excel 2007, MS Access, SAS, Windows 2007 server, java 1.5 platform, Teradata, Confidential 2007, Microsoft Excel, PowerPoint, UNIX, DB2

Tableau Developer/Admin

Confidential, Chicago, IL

Responsibilities:

• Gathered Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports
• Incorporating weekly changes of the data source files by integration into Tableau data sources for timely leadership reporting
• Creating reports and infrastructure to show migration activities by monthly release, business function, IT projects and overall
• Created Visuals for PayPal team workflow optimization using different Tableau charts such as KPIs and spark lines in a single view
• Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard
• Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
• Participated in daily stand-ups with clients on daily design and development effort
• Prepared test scripts and documented user training modules.
• Generated reports with SQL queries and relevant files.
• Maintained Test log and Wrote Test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Create reporting and infrastructure to show migration activities by monthly release, function, IT projects and overall
• Developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Developed Ad-hoc reports using Tableau Desktop, Excel
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Attended Bolt sessions to build dashboard on live
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Worked with Teradata database and pull data to work on BI requirement
• Provided Ongoing support to BI application running in production & troubleshoot

Environment: Tableau Desktop, Tableau server, OBIEE, Axure, Microsoft SQL Server, Confidential Suite (Word, Excel, Power Point, Visio, Outlook).

Tableau Developer/Admin

Confidential, New Jersey, NJ

Responsibilities:

• 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.
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Projected and 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.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• 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 keys from each database for data validation.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Involved a key member in development of E - R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Automate regular repository back up based as per business needs.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears and Kmart Complex reports and Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Analyzing the existing system and to identify the areas of improvement.
• Create Technical design document, provide end user training and training manual.
• Handle issues raised by Tableau server 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.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Environment: Tableau Desktop, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS. Excel, SQL Server Management Studio, Microsoft Excel.