SUMMARY

• 7+ years of IT experience in Data warehousing and Business Intelligence technologies like Tableau in Retail, Financial, Health Care and Manufacturing industries.
• Experience in Agile, Waterfall, RUP & SCRUM Methodologies.
• Experience in Installation, Configuration and Administration ofTableau Server in a multi - server and multi-tier environment.
• Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and dashboards using Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Experienced in Tableau support across enterprise (Dev, Staging and Production), troubleshooting, report design and monitoring of system usage.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like SQL Server BI Tools (SSIS, SSRS & SSAS).
• End to End experience in designing / deploying / exporting data visualizations using Tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Participated in business discussions with the users and created requirements from which the dashboard blue prints and graphic rich tableau dashboards are created.
• Experienced in analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Worked on creating various dashboards based on user requirements and built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices,
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Developed solutions for management dashboards, BI analytics and documented technology roadmaps through collaboration with the data management, ETL and business teams.
• Well versed in Tableau commands for developing scripts for Tableau server backup and restoring.
• Strong analytical, logical, communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
• Excellent communication skills in both written and oral along with ability to tell a story through data.

TECHNICAL SKILLS

BI/Visualization Tools: Tableau Server & Desktop 7.x, 8.x & 9.x, Cognos, SSIS & SSRS

Platform: Windows 8/7/2003/NT, MAC OS, DOS, HP Proliant, VMware

Databases: MS-SQL Server 2008/2008R2/2012, Teradata, Oracle 10g/11i

Languages: T SQL, Java Script, HTML, CSS, PHP, XML, and Power Shell

Software Packages: MS Office Suite, MS SharePoint and MS Project

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Tableau Consultant

Responsibilities:

• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in bothTableau and Excel.
• Worked on Server Administration of Tableau like setting up of the fail over mechanism and training users on functionality of Tableau and provided permissions to the servers.
• Performed Tableau Server Distributed environment upgrade from v8.2.5 to 9.0.3 in various environments.
• Tableau Backups - Checking/Verifying all the backups to validate that they were successfully created per process.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published onTableau Server for usage with Operational or Monitoring Dashboards.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Performance Logs - Reviewing the performance metrics to determine if the baseline exceeded or for the slow points during the day that need to be reviewed.
• Tested reports and uploadedTableau dashboards on to server and provided production support for Tableau users.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.

Environment: Tableau Server and Desktop 8.x and 9.x, Windows Server 2008R2, MS Excel, T-SQL, SSIS and HP Vertica

Confidential, Palo Alto, CA

Tableau Consultant

Responsibilities:

• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of Tableau Servers.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Using Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Performed Data Migrations from Tableau 6 to Tableau 7.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• 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.
• Published views and dashboards in Tableau Server for auditor review.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized usingTableau.
• Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies and used Process Explorer for maintenance of stuck process, and to release the handles on files.
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation

ENVIRONMENT: Tableau Desktop v7, Tableau Server v7, Oracle, SQL Server, SSIS, SSRS, MS Excel, MS Access

Confidential, Springfield, IL

Tableau Developer

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• 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.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Confidential SQL Server and Confidential Analysis Services.
• Created views in Tableau Desktop which 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.
• Performed regular Administration activities from managing system resources, users and database to the fine-tuning level and implemented projects successfully on Tableau.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Used tabcmd to run Tableau schedules and execute extracts refresh on workbooks or data sources.
• Created Prompts customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Created ad Hoc and parameterized various reports using SQL server 2005 reporting Services with data from SQL Server and MS Access as data sources.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

ENVIRONMENT: S: Tableau Server v6, Tableau Desktop v6, SQL, Teradata, Excel, SSIS and SSRS.

Confidential, Cincinnati, OH

BI Developer

Responsibilities:

• Actively involved in business meetings with the customers for understanding the as-is process flow and new business requirements or enhancement activities.
• Prepared the technical and functional specification documents for report development, coding and testing.
• Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
• Created standard filters, prompts, calculations and conditions in Catalog.
• Created various impromptu reports (List, Cross-Tab and Drill through) and power play Reports.
• Defined join conditions, table aliases and views for the user requirement.
• Updated impromptu catalog by adding tables and creating new joins.
• Created various report studio reports using calculations, filters, prompts conditional formatting and drill through.
• Created IQDs those are used as data sources in PowerPlay transformer to generate transformer models.
• Converted char fields to varchar fields and date functions.
• Migrated reports from Cognos EP Series 7.3 to Cognos 8 Environment.
• Published impromptu reports and Power Play reports to upfront and scheduled reports to run periodically.
• Validated report results with the source data and authorized the reports to production environment.
• Granting access to different users for the system.
• Provided technical assistance, training and mentoring to business users.
• Involved in Data Auditing process using SQL to validate the masked data.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality.
• Installing applications like Impromptu user 7.3 & Power Play user 7.3.

ENVIRONMENT: Cognos 8.0 BI, Cognos Powerplay7.3, Transformer 7.3, Cognos Report Net 1.1, Power Play Enterprise Server 7.3, Upfront 7.3, Impromptu 7.3, Access Manager 7.3.