SUMMARY

• Having 8+ years of professional experience in Sales and Financial Industry with Software Design, Development, Analysis, Testing, Data warehouse and Business Intelligence Applications.
• Expertise in Tableau 10.0/9.3/9.2/9.1/8.0 , Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
• Setup and configuration of Tableau server 10.0/9.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security Confidential application level, folder level and user level.
• Involved in installation of SAP HANA 1.0.17 in two environments.
• Installed patches on server and documented upgrade plan from Tableau 9.3 to Tableau 10.0
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Expert in gathering external data to Tableau from different sources like Oracle, SQL Server & flat files etc., for data visualization
• Analyzing unstructured and text Data using different tools such as SAS Enterprise Miner, and ASTER platform in Teradata
• Configured security Confidential report level and data level.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Created sets and used them in the calculated fields to retrieve the specific data by combining multiple sets and visualize the data.
• Experience in migrating all the reports, dashboards from Tableau 8 to Tableau 9.
• Experience in trouble shooting slow running queries and creating indexes to improve the performance.
• Performed regular reviews of the database to identify performance problems, inadequate programming and data duplication problems.
• Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML and drivers setup activities.
• Created various User, groups by assigning row and column level security Confidential application level, folder level and user level
• Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.
• Excellent Knowledge in Data Warehouse Concepts, Data Modeling, ETL and worked on OLTP & OLAP in all environment which includes development (DEV), test (QA) and production (PROD).

TECHNICAL SKILLS

BI TOOLS: Tableau Desktop 10.x/9.x/8.x, Business Objects, OBIEE Tableau Server 10.x/9.x/8.x

Data Base: SQL, PL/SQL, SAP HANA, Oracle, MS SQL Server, Access, DB2, Teradata, Mongo DB2.

Environment: Windows XP, 2003, 2007, Linux, Unix

PROFESSIONAL EXPERIENCE

TABLEAU DEVELOPER

Confidential - Atlanta GA

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 TableauDesktop.
• Created views inTableau 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.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating a dual - axis bar chart with multiple measures.
• 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.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Focused on improving readability, utility, and overall UX.
• Microsoft SQL Server T-SQL(Working With Views, Stored Procedures, Tables )
• Reviewed basic T- SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Blended data from multiple databases into one report by selecting primary keys from each database.
• Designed and optimized data connections, data extracts, schedules for background tasks and incremental refresh for the weekly and monthly dashboards/reports on Tableau Server.
• Used Teradata Data Warehouses (SQL) to query relevant structured data.
• Worked with ASTER platform from Teradata to analyze and extract unstructured datasuch as text and comments.
• Met with leadership team to develop problem statement and business requirements.
• Created new schedules and troubleshooting the failed schedules and extracts on the server.
• Created scripts to send automated alerts whenever restore or backup fails.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks in the Tableau Server.

Environment: Tableau Desktop 10.3/10.0/9.3/ 9.0 , Tableau Server, T-SQL, MS Office Suite, CSV, Oracle SQL Server R2, MS Excel.

TABLEAUDEVELOPER

Confidential, Portland - OR

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Integrated tableau with Google Big Query to quickly analyze massive amounts of data and built interactive dashboards.
• Integrated the tableau reports to other portals.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Administered user, user groups, and scheduled instances for reports in Tableau.

Environment: Tableau 8.0 to 9.0, Tableau server, Oracle 11i, MySQL, SQL*Plus, TOAD, Windows 2003/XP, UNIX

Tableau Developer/Admin

Confidential - FL

Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards in Tableau that answer key business questions. audited the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
• Mentored less experiencedTableau reporting specialists.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
• Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
• Reviewed assessed and promoted adoption and standardization ofTableau support solutions. generated insights out of voluminous and complex datasets and built story lines. designed excellentTableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.

Environment: Tableau Desktop, Oracle 10g, SQL, PL/SQL, Toad for Data Analyst 2.5, Windows 2003

SQL DEVELOPER

Confidential

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment, and user training.
• Involved in Physical/Logical design of database, creating and managing the database and all the database objects.
• Designed and developed forms using Visual Basic with ODBC. Designed and developed reports using Crystal Reports.
• Developed E - R diagrams (logical and physical using ER win) mapping the data into database objects.
• Designed and developed various complex reports.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Involved in dimensional modeling to design data warehouse.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD
• Used the calculated members in the fact tables to improve efficiency.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD