SUMMARY

• Over 7 Years of IT experience in Business Analysis and Business Intelligence Projects, along with 4 years of Tableau Development using Tableau Desktop and Tableau Server .
• Expertise in Data Visualization tools like Tableau Desktop, Server and Reader in various versions of Tableau 6.0, 7,8 and 8.2, 8.3, 9.0.
• Experience in installation, Configuration and administration of Tableau Server in multi Server and multi - tier environment.
• 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.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Good knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in oracle.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts
• Extensive Experience in Tableau Server includes Automatic Backup, Cluster Node environment.
• Experience in Administering user, user groups, and scheduled instances for reports in Tableau.
• Experience in Tableau Server 8.2, online publishing, Sharing, and Tableau online
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Strong Knowledge of Tabcmd and Tabadmin Commands, able to generate log files when it required.
• Experience in Validating Reports Based on User-Requirement.
• Strong knowledge of Software Development Life Cycle (SDLC).
• Good understanding and background in financial services, media, and telecom industry.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.

TECHNICAL SKILLS

BI/Visualization Tools: Tableau Desktop 6/7/8.1/8.2/8.3 and 9.0 Tableau Public, Tableau Reader and Tableau Server 8.1and 8.2.

Programming: SQL, UNIX Shell

Utilities: MS Office Suite, MS Share Point, MS Project

Databases: Oracle 10g/11i, Oracle SQL Server 2008 R2, MS Access, MS Excel

Platforms: Windows 7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX.

Networking: TCP/IP, LAN/WAN Technologies.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Tableau Consultant

Responsibilities:

• Installed tableau software, installing worker nodes on supporting servers and configured worker nodes with primary server.
• Configured and upgraded Tableau Server and Tableau Desktop.
• Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.
• Implemented Automation of Tableau Backup on weekly basis and stored them in separate folder automatically.
• Experience in taking backup frequently from all three existing environments and making sure that server is up and running in all the three environments.
• Work closely with business users migrating workbooks from one environment to another and closely worked with them provided them ways to improve performance and recommended tableau suggested ways .
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Created ODBC connection to connect to database since the native drivers doesn’t support
• Created Forecasted Reports For the Upcoming Year to Observe Trends in Tableau
• Implemented Automation of Tableau Backup on weekly basis and stored them in separate folder automatically.
• Implemented Automation of Tableau Logs on Daily Basis and stored them in separate folder automatically.

Environment: Tableau Desktop 8.2 and 9.0 Tableau Server, Oracle SQL Server, Kognitio, Teradata, MS Access, Win Server 2008 R2, Active

Confidential, Irvine, CA

Tableau Developer/Administrator

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Implemented Automation of Tableau Backup on weekly basis and stored them in separate folder automatically.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 8.0, Tableau Server 8.0, Oracle SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active

Confidential, East Brunswick, NJ

Tableau Developer

Responsibilities:

• Installed and configured Tableau Server and Tableau Desktop.
• Created reports in tableau by using the metrics and aggregate tables already created in OBIEE.
• Did Performance turning and did analysis of performance comparison between OBIEE and Tableau.
• Implemented security in Tableau by making Data Level Security and User Filter Security.
• Extensively Used Data Blending to Join Multiple Data Sources.
• Experience In Creating Hierarchies and Created New Calculations Using Dimensions and Measures.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks as Tableau Administrator.
• Preparing Dashboards using calculations, parameters in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Did performance turning in tableau to improve report response time.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Created Forecasted Reports For the Upcoming Year to Observe Trends in Tableau.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

Environment: Tableau Desktop and Server 7 and 8, MS Office Suite, Oracle, and Windows 2008.

Confidential

SQL Developer

Responsibilities:

• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created database documentation for table and column dictionaries and other reference material.
• Implemented indexes on tables and views for optimum performance tuning.
• Involved in dimensional data modeling and story boarding ETL processes.
• Designed the ETL process using SQL Server 2000 DTS Packages as well as SQL Server 2005 crystal Packages which the data sources include Flat files, Access, Excel.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.

Environment: MS SQL Server 2008 R2/ 2005, SQL Server Management Studio, Crystal Reports 2008 XI.

Confidential

SQL Server Developer/Analyst

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Configured SSRS 2005 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, VB.NET, MS PowerPoint, MS Project