SUMMARY:

• Over 7 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8.
• Involved inRequirements gathering and analysis,Design, Development, TestingandProduction rollover of Reporting, Report Optimization and Analysis projects.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in creating advanced visualizations like Donut charts, Waterfall charts, Pareto chart, Funnel Charts. Extensive experience on building dashboards using Tableau.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Familiar with Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• EstablishedBest Practicesfor EnterpriseTableauEnvironment and development processes.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Extensive experience in monitoring the database server for deadlocks, long running queries and tuning the same to improve performance.

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. Tableau Developer

Responsibilities:

• Worked with business analyst and business users to understand Wireless Device Expense Policy for corporate expenses and per user expenses across enterprise.
• Connected to data sources and performed Data blending implemented on SQL Server Database to generate interactive dashboards.
• Created Expense Tracker reports to show historic data and plot future trends and identify potential opportunities for lines of business to manage costs.
• Developed Tableau visualizations using line charts, bar charts, dual axis charts.
• Generated dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created ad-hoc reports to users in Tableau by connecting to various data sources to show expenses by devices and charge category.
• Published workbooks by creating user security and row level security.
• Created advanced charts like Waterfall chart and Pareto Chart.
• Handled Tableau admin activities generating access, managing extracts and installations.
• Performed troubleshooting to address connectivity issues.
• Experience on server administrative functions, Meta data model development, Performance tuning techniques and customization.
• Working knowledge of dimensional modelling, ETL, SQL query rewriting and optimization using Oracle, SQL Server databases.
• Worked in agile, iterative team setting and experience with other BI tools like Micro strategy, SSAS/SSRS and OBIEE.

Environment: Tableau Server v8.1/8.2, Tableau Desktop 8.1/8.2, SQL Server 2008/2012, Oracle

Confidential, ND

Sr. Tableau Admin/Developer

Responsibilities:

• Develop, support, maintain and test Developer Suite (Form, Report), SQL/PL-SQL andProgram Design, create and maintain data model and data.
• Tableau development lifecycle from gathering requirements and designing solutions, through developing code / reports, testing and release / deployment.
• Develop, Maintain, Test usingOracleSQL, PL-SQLincluding Program Unit According to Business Analyst and Function Requirements.
• Published dashboards and worksheets to server. Scheduled refresh and took backups at periodic intervals
• Design, create and extend application layer to manage the CMS data repository and ETL(Extract, Transform, and Load) feeds from multiple sources
• Design, develop and support Performance and Capacity Application Dashboard using APEX
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
• Expertise with Tableau architecture, data interoperability and data analytics using Tableau and SQLs
• Performed troubleshooting, performancetuning and enhancements

Environment: Tableau Server v7/8, Tableau Desktop v7/8, SQL Server 2008/2012, Oracle 11g, SQL SSIS, Team Foundation Server, Visual Studio 2012

Confidential, IL

Tableau Developer

Responsibilities:

• Worked on Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO.
• Adjust views/dashboards after initial POC presentation to CEO and CFO.
• Create views and dashboards on end client's sales data. Produce powerful dashboards using pie, bar, geo, and line charts that are viewed daily by CEO and CFO.
• Cleanse and normalize data in MS Excel by combining from various data sources.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

Environment: Tableau Desktop 6/7, Tableau Server 6/7, MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory

Confidential, New Jersey

Tableau Developer

Responsibilities:

• Scope of the project was to enhance the Insurance App’s systematic processes. Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability to get better understanding of future enhancements.
• Involved in end to end implementation and enhancements on insurance agent’s App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Insurance App’s by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Insurance App.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Created advanced charts like Pareto Chart and Donut Chart.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Insurance App usage 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.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.

Environment: Tableau Desktop 5, Tableau Server 5, MS Excel, CSV, Win Server 2008 R2, Active Directory

Confidential, CA

Data Analyst

Responsibilities:

• Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project and Budget of the Project.
• Participated with individual and JAD/RAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units (Amdocs) for business requirement gathering followed by (Agile Scrum) approach.
• Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs.
• Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.
• Applied SQL for cross checking Data Validation for Referential Data in SQL Server.
• Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.
• Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values
• Used SQL Server Integrations Services (SSIS) to extract data (ETL), and quickly load data into SQL Server table, and handle data quality issues.
• Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.
• Designed and developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams by using MS Visio.

Environment: MS Visio, MS Office Suite, HTML, XML, Test Director, VB, Client Server, UML, Waterfall, Windows XP, Test Director, MS Project, MS Access, MS SQL, Oracle, TOAD.