SUMMARY:

• Around8 years of extensive experience in IT with full System Analysis & Design,Development, Administration, Integration, Implementation, Performance Tuning and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience in working with Tableau Desktop, Tableau Server, Tableau Online and Tableau Public in various versions of Tableau 10.5, 10.3, 10.0, 9.3, Tableau 9/8/7/6.
• Excellent Experience in tracking KPI's like Platform Availability, SLA Adherence, Service Delivery, Storage Metrics, Incident Metrics, Platform Capacity, Platform Performance, Security Metrics etc.,.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive experience working in Windows, UNIX/LINUX, Sun Solaris environments.
• Excellent knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in Oracle and MS SQL Server.
• Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Experience in administering user, user groups, and scheduled instances for reports in Tableau.
• Excellent knowledge of Business Intelligence platforms and processes across Banking, IT and Financial industries.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Extensive working experience in Packages, Procedures, Cursors, Triggers and UNIX Scripting.
• Experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Data Island.
• Experienced in Business Intelligence (Teradata-SQL, SSRS), Data Warehousing and Dashboards. Developed& delivered dynamic reporting solutions using SQL Server 2008 Reporting Services (SSRS).
• Experienced on UI/UX design across the technology organization.
• Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE.
• Experienced in tuning long running SQL queries for better performance.
• Experienced in Developing custom Java API’s to embed the dashboards into HTML web application.
• Extensive experience in creating Calculations (Cube Calculations, Hide Columns, Custom Logics, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
• Excellent Experience in publishing Dashboards to Tableau Server.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Have been working with various data sources such as Oracle, SQL Server, Teradata and flat file sources.
• Excellent experience in Installation and configuration of Oracle 11g, 10g & 9i in UNIX/LINUX and Windows environment.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, Logical and Physical Database Design.
• Worked with development teams and database administration staff to enhance database and application performance.
• Experience in managing Schemas, Tablespaces and Indexes.
• Result oriented, self-motivated, team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Analytics/BI: Tableau Desktop& Server v10/v9/v8/v7/v6, Tableau Online, MSBI Suite, QlikView, OBIEE.

RDBMS: Teradata, Oracle (12c, 11g, 10g, 9i), MS SQL Server, MS Excel, MS Access.

Programming Languages: SQL, PL/SQL, Python, C, C++ and Data Structures

Web Technologies: ASP.NET, HTML, JavaScript, CSS, XML, SL

Tools /Utilities:: .SQL*Plus, SQL Developer, Toad, SQL Tuning Advisor, Data pump Export & Import, SQL Trace, SSMS (SQL Server Management Studio), RMAN, TOAD, OEM, Golden Gate, SQL*loader, Data Guard

Operating Systems: Windows, UNIX/LINUX, AIX, HP-UX and Sun Solaris.

Other: JIRA, Service Now, MS Excel, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. Tableau Developer

Roles & Responsibilities:

• Installation, Upgrades, Maintenance, Performance Tuning and support of all Tableau components.
• Experienced in publishing of various kinds of Live, Interactive Data Visualizations, Dashboards, Reports and Workbooks from Tableau Desktop to Tableau servers .
• Responsible for reviewing business requirements and analyzing data sources from Teradata/Oracle/MS SQL Server/Excel.
• Experienced in creating Aggregations, calculated Fields, Table calculations, Totals, Percentages using Key Performance Measures (KPI) and Measures .
• Created Tableau Scorecards, Dashboards, Heat maps, Donut charts, Pie charts, etc.
• Experienced in tracking KPI's like Platform Availability, SLA Adherence, Service Delivery, Storage Metrics, Incident Metrics, Platform Capacity, Platform Performance, Security Metrics etc.,.
• Experienced in identifying new metrics and enhanced the existing KPI' s.
• Identified issues, performance bottlenecks, and optimize the Business Intelligence dashboards and Reports.
• Excellent experience in deploying Tableau reports in various environments
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Analyzed the source data and handled efficiently by modifying the data types. Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
• Created Views, Stored Procedures and validated data for the performance.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• Developed dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Participated in regular Technical Reviews, Defect reviews and walkthrough meetings with important projects & business stakeholders throughout the project life cycle.

Environment : Tableau Desktop 10.5, 10.3,10.0, Tableau Server / Administrator, Teradata, SQL Loader, SQL, Oracle 11g & 12c, SQL, Windows, MS Excel, MS Access.

Confidential, Foster City, CA

Sr. Tableau Developer

Responsibilities:

• Extensive experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• 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.
• Defined best practices for Tableau report development.
• 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.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau Desktop using various sources such as Oracle.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Performed business analysis on integrating Web Intelligence reports with JAVA API’s.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Focused on improving readability, utility, and overall UX.
• Created stories in Tableau using Story functionality.
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Prepared proof of concept for best practices in Tableau deployment.
• Responsible for developing Dashboardsand preparing ad-Hoc Reporting.

Environment : Tableau Desktop 10.0, 9.3, 9.2, Tableau server / Administrator, SQL developer, SQL, Oracle 11g& 12c, SQL, PL/SQL,MS Access.

Confidential, Washington, DC

Tableau Developer/Admin

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 by color that was broken into cities allowing business user to understand.
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• PerformedTableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Blended datafrom multiple databases into one report by selecting primary key’s 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.
• Worked extensively on OBIEEAnswers and Dashboards to create the reports as per the client requirements.
• 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.
• Developed QlikView Dashboards using different Chart, Drill through, Cyclic Groups, List, Input Field, Table Box, Container, etc.,.
• Designed and developed business intelligence solutions using QlikView.
• Applied Cascading Prompts and Multi Level Prompts on dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
• 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 8.2, 8.1 &7, Tableau Server, QlikView, OBIEE, Oracle 11g, MS Office Suite, Teradata.

Confidential, Rockville, MD

Tableau Developer/Admin

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
• Created dashboards for the clients to measure performance of their services and financial management.
• Created views and dashboards on end client's sales data. Produced powerful dashboards telling story behind the data in an easy way to understand format such as pie, bar, geo, and line charts.
• Developed Scatter Plots and Area Maps to show investment/ROI by states.
• Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8.
• Developed Geo/Area Maps to show Finance details by states.
• Created Shared data sources for the users.
• Installed and Configured Tableau 8.0 on multiple environments.
• Verified the runtime user permissions on the Database.
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
• Imported the users via Active Directory and granted permissions based on the client requirements.
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Configured row-level security and user-level security.
• Created calculations this includes from basic arithmetic calculations to complex Mathematic calculations.
• Created dashboards style of reports using QlikView components like Slider, Buttons, Charts and Bookmarks.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability.
• Worked with client staff to enable them to utilize the QlikView applications
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Environment: Tableau Software 7.0, 8.0, Microsoft office, QlikView SQL Server 2008.

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Analysis for the Individualized Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Defined group level security standards for Tableau.
• Installed patches on server and documented upgrade plan from Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Created extract files for improving the performance.
• Used different Mark types and Mark properties in view to provide better insights into large data sets. Created various types of charts for better visualization.
• Created Bar Charts which are complied with data sets and added trend lines and forecasting data.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL BI Suite (SSIS, SSRS), Oracle 11g, MS Office.

Confidential

Oracle DBA

Responsibilities:

• Experience with configuration, installation, and administration of Oracle 11g/10g/9i, RAC, Enterprise Manager, Diagnostic Pack and Tuning pack.
• Perform daily Maintenance tasks including creating users, adding space to the tablespaces, monitoring of databases using the shell scripts.
• Analysis on database design and functionality.
• Creation & maintenance of Databases and Database objects.
• Ensuring continuous 24x7 Availability, Reliability and Optimal Performance of Production Databases using Dataguard, RAC, RMAN etc.
• Proactively identify, diagnose and resolve database issues in Production, Development environments related to SQL, server performance, locking, bugs, storage, networking, backups and communicate with other teams, clients or agencies in the resolution of these issues.
• Developed Backup Strategy includes documentations of Backup and Recovery Processes, Ensuring Successful Periodical Database Backups, Restoration and Testing Backups using RMAN.
• Review and Execute scripts on production and staging environment.
• Logical, physical data modeling, implementation and database administration.
• Working on the projects related to the data warehousing design and implementation.
• Installed different Oracle database components and tools (OEM, Client &TOAD).
• Performed capacity planning for Oracle databases part of the projects.
• Migration and upgrade of oracle databases to Oracle 10g/11g from 9i/10g in all development, QA, Production environments.
• Management of schemas, tablespaces, indexes and partitioning.
• Automation of data load and data parsing using Pl/Sql procedures, shell scripting and Sql*loader.
• Responsible for managing user accounts, granting required privileges to users.
• Perform other regular DBA activities including space management and performance monitoring.
• Implemented Real Application Clusters (RAC) setup, configuration and cluster interconnection of 5 instances with server side load balancing using Automatic Storage Management (ASM).

Environment: Oracle 11g/10g /9i, TOAD, HP-UX, Linux, RMAN, ASM, OEMand Windows, Patching, Monitoring, SQL Tuning.