SUMMARY:

• Around 6+ 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 Reader in various versions of Tableau 9.1,9.0, Tableau 8/7/6.
• 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.
• Experienced in tuning long running SQL queries for better performance.
• Extensive experience in creating Calculations (Cube Calculations, Hide Columns, 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:

BI/ Reporting Tools: Tableau Desktop v9/v8/v7/v6, Tableau Server v9/v8/v7/v6, Tableau Online, Tableau Public, Tableau Reader, MSBI Suite (SSIS, SSAS, SSRS).

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

Languages: SQL, PL/SQL, Java, C, HTML, XML, UNIX Shell Scripting.

Other Tools: RMAN, OEM, TOAD, SQL Developer, SQL*loader, Golden Gate, Data Guard.

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

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Sr. Tableau Developer/Admin

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.
• 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.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• 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 Dashboards and preparing ad-Hoc Reporting.

Environment : Tableau Desktop 9.1, 9.0, 8.1, 8.0, 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.
• 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.
• 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.
• 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.
• Applied Cascading Prompts and Multi Level Prompts on dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence dashboards and Reports.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau.
• 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.1 & 7, Tableau Server, MS Office Suite, Teradata.

Confidential, Rockville, MD

Tableau Developer

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.
• 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.
• 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.
• 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.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important projects & business stakeholders throughout the project life cycle.

Environment: Tableau Software 7.0, 8.0, Microsoft office, 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 form 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, OEM and Windows, Patching, Monitoring, SQL Tuning.