SUMMARY:

• Over 8+ years of experience in Designing, Administration, Analysis and Management in Business Intelligence Data warehousing. 5+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.0, 8.2, 9.0, 9.3, 10.2, 10.3 as a Developer and Administrator.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Experience in Informatica (ETL) tools which is widely used in building enterprise data ware house.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema, Snowflakes modeling, fact and dimension tables modeling of data.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, and SQL Server technologies.
• Experience working in Supply chain management and creating real time dashboards.
• Administration, Installation and configuration of a Core Licensed Tableau Server.
• Hands-on experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau 8.0 to 9.0).
• Extensively worked on TabCMD, TabAdmin, creating users, sites and projects in tableau.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Hands-on experience on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and other making use of actions, other local and global filters according to the end user requirement.
• Deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized dashboards using Tableau Desktop.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Experience in data extraction, data integration, data modeling and data rendering in Tableau.
• Strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Develop Business object in accordance to client needs and requirements.
• Experience working in Agile and Scrum Methodology.

TECHNICAL SKILLS:

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

Business Intelligence tools: Tableau Desktop(10.x, 9.x, 8.3/8.2/8.1/8.0/7.0 ) Tableau Server, Tableau Reader, Business Intelligence Development Studio (SSIS/SSRS)

Data Base: MS SQL Server 2005/2008/2012 , MS Access, Teradata.

Languages: T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

Tableau Developer

Responsibilities:

• Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
• Deep experience with the design and development of Tableau visualization solutions.
• Created Interactive Dashboard, worksheets using Tableau with primary and secondary data sources using data blending where primary and secondary data sources linked by specified relationships.
• Created trend lines, statistics, groups, hierarchies, and sets to create detail level summary report and Dashboards using KPI's.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Interacted closely with the Business users along with the administration and management to gather the report business requirements, report types and report formats.
• Define best practices for Tableau report development and effectively used data blending feature in tableau.
• Evaluated bug fixes and identified the changes from tableau 10.3 to 10.4 and digested the customer accordingly.
• Perform Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Desktop/Server Reports.
• Used Tableau visualization software to generate Tableau combination dashboards .
• Contribute to our team's growing set of development platforms, tools, and processes especially within the area of Business Intelligence for future projects.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Dashboards with different style using QlikView components like List Box, Slider, Buttons, charts and Bookmarks.
• Interacted with Data Modelers on regular basis for creating the Logical Data Model(LDM) and Physical Data Model (PDM)
• 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.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• 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.
• Blended data from multiple databases into one report by selecting primary keys 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.
• Using MicroStrategy Desktop created Application Objects like Template, Filters, Prompts, and Reports according to the Business requirement.
• 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 complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Created Physical Data Model (PDM) from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• 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.
• Schedule data refresh on Tableau Server for weekly and monthly data updates based on business change to ensure that the views and dashboards to display data accurately.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 9.0/8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, Jacksonville, FL

Tableau Developer/ BI

Responsibilities:

• Gathered user requirements, reporting requirements and Involved in designing Physical Data Model (PDM).
• Use data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their Data.
• Designing the Reports as per client Requirement and created the reports using Excel file, SQL Server and Oracle databases.
• 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.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• 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 reports and dashboards using KPI's.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Produced Logical Data Models/Physical Data Models.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented a whole process of working with Tableau Desktop, and evaluating Business Requirements.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering with Erwin tool.
• Interacted on a day to day basis with several different groups in order to achieve a common deliverable.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal Reports, Quarterly reports by creating multiple queries.
• Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
• Involved in resolving reporting issues and design issues throughout the reporting life cycle.
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Ensured all project requirements and objectives are properly documented and pursued.
• Created conditional filters to filter the data on dashboard.
• Creating Parameters for desired functionality.
• Responsible for developing, analyzing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
• Utilize SAS, and other software, to provide ad-hoc reporting, tables and listings and graphs for clinical trials data, regulatory submissions, Risk Based Monitoring, and publications.
• Developed and produced peer quality metric performance: validated data and processes to ensure accuracy, completeness, and consistency of data using SAS.
• Work with client and team members to understand and clarify visualization requirements.
• Written complex SQL queries and optimized queries for performance tuning.

Environment: Tableau 9.0, MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10, Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2000/2003

Confidential, Dallas, TX

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.
• 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.
• 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.
• 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.
• 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: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential

Tableau Developer

Responsibilities:

• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Expert in infographics and Dashboarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in providing Tableau server and tableau desktop training.
• Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.

Environment: s:Tableau Server v6/v7, Tableau Desktop v6/v7, Windows Server Standard R2ClearQuest, ClearCase, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EETomcat, TSQL, UNIX, Linux RHEL 5.4.

Confidential

T-SQL Developer

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Recovered the backups of SQL Server production databases in test server environment.
• Analyzed poorly performing SQL queries to improve application performance.
• Coordinating with peer groups for Network, Infrastructure and Data Center Operations.

Environment: T-SQL, MS SQL Server 2005, SSAS, SSRS, SSIS, XML, Windows 2000/2003/NT/XP, MS-Excel.