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/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Fair Knowledge in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Extensive Tableau Experience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience on building dashboards using Tableau.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake 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, ND

Sr Tableau Admin/Developer

Responsibilities:

• Develop, support, maintain, and test,Developer Suit (Form, Report), SQL/PL-SQL,Program Design, create and maintain data model and data.
• Create Tableau software (BI), dashboards, data analysis, visualization, report,
• Develop, Maintain, Test usingOracleSQL, PL-SQLincluding Program Unit According to Business Analyst and Function Requirements.
• Tableau development lifecycle from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment
• 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 data architecture, data interoperability and data analytics using Tableau and SQLs
• Assist Seagate DBAs and Application Developers with Oracle SQLtroubleshooting, 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.
• Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
• Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as 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

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.
• 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.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

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

Confidential, LA

Data Analyst

Responsibilities:

• Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management, 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, 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.