PROFESSIONAL SUMMARY:

• Over 8+ years of professional experience in Business Intelligence, Software Design, Modeling, Development and Implementation in Information technology wif skills in all phases of Data Warehouse lifecycle development.
• 5+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 10.1/ 9.x/8.x/7.x as a Developer and Admin.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color - coded tabs etc. in Tableau 10 desktop/Server.
• Extensive working experience in creating visualizations and Dashboards using Tableau Desktop.
• Proficient in designing and creating various Data Visualization Dashboards, worksheets and analytical reports to halp users to identify critical KPIs and facilitate strategic planning in the organization utilizing Tableau Visualizations according to the end user requirement.
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Strong experience in SQL and PL/SQL stored procedures and functions.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Defined best practices for Tableau report development.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9 desktop/Server.
• Involved in installation ofSAP HANA 1.0.17in two environments.
• Excellent knowledge on Tableau Architecture and new features.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
• Prepared different highly formatted financial reports such as consolidated income statements and balance sheets using Crystal Report and Ad-hoc reports using Web Intelligence.
• Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility.
• Publishing and presenting dashboards on web and desktop platforms.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• Experienced wif ETL tools like Informatica, SSIS, SSRS, SAS.
• Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
• I used SQL, Cloudera Hadoop and Hive, Apache SOLR, MapReduce, Amazon Redshift.
• Ability to handle multiple tasks and work independently as well as in a team.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature inTableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.

TECHNICAL SKILLS:

visualizations/Reporting tools: Tableau Desktop/ Server 10.310.1//9.3/9.1/9.0/8.0 Tableau reader/Public

Programming/Scripting Languages: SQL, TSQL,PL/SQL

Databases: Microsoft SQL Server 2012/2008/2005,IBM, Postgre SQL, DB2, Teradata, Postgres Sql, SAS MS Access 2003, Oracle11g/10g/9i/8i.

Methodologies: Waterfall, SCRUM and Agile, Complete Software Development Life Cycle, Iterative, Scrum.

Operating Systems: Windows/Mac

Web Tools: PowerShell, Batch, Python.

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

Tableau Developer/Admin

Responsibilities:

• Upgraded Tableau Server from 9.3.8 to 10.1.6
• Migrated the server from a VM to Physical server to improve the performance.
• Responsible for interaction wif business stakeholders, gathering requirements and managing the delivery.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboard using KPI’s.
• Enabled SSO to SAP HANA data source from Tableau environments.
• Experienced in writing scripts to remove inactive users on the server.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style.
• Created scripts to send automated alerts when ever restore or backup fails.
• Create, customize & share interactive web dashboards in minutes wif simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along wif user acceptance test and data accuracy test.
• Coordinated database middleware issues wif DBA's, query performance wif System Architects
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level. Defined best practices for Tableau report development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.

Environments: TableauDesktop10.1/9.3, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.

Confidential, Farmington hills, MI

Tableau Developer/Admin

Responsibilities:

• Responsible for interaction wif business stake holders, gathering requirements and managing the delivery.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Created and updated server architecture for scheduling tasks
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Building, publishing customized interactive report sand dashboards, report scheduling using Tableau server.
• Creating users, groups, projects, Data connections, settings as tableau administrator.
• Developed Dashboards using OLAP cubes.
• Extracted data from the database using SAS/Access, SAS/SQL procedures to create datasets.
• Ad-hoc ETL, Reports requirement runs.
• Extensive usage of Amazon web services(AWS) for connecting to the data sources on cloud using Amazon redshift services
• Use of Java script for creating the client side validations in the webpages wif dashboards.
• Use of Java script for embedding the dashboards on the webpages.
• Involve dincreatingdashboard sand reports in Tableau9.3andMaintainingserveractivities, user activity, and customized views on Server Analysis.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for logistics calculation and department spend analysis.

Environments: TableauDesktop9.0/9.3.0, Tableauserver/Administrator, SQLdeveloper, SSIS, OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential, Broadway, NYC

Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Hands-on development on assisting users in creating and modifying worksheets and data visualization dashboards.
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Involved in license management SLA's wif Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Ad-hoc ETL, Reports requirement runs.
• Created visualization for logistics calculation and department spend analysis.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly wif other production systems.

Environments: TableauDesktop9.0/8.3, Tableauserver/Administrator, SQLdeveloper, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential, Quincy, MA

Tableau Consultant

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implement info graphics and Dash boarding for data visualization.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Published Workbooks and Dashboards to theTableauserver.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Adadmin and Tabcmd commands in creating backups and restoring backups of Tableaurepository.
• Experience in converting OBIEE content into Tableau BI content.
• Experience in providing Tableau server and tableau desktop training.
• Experience wif Teradata.
• Experienced wif trouble shoot of Teradata connection.
• Tested reports and uploaded tableau dashboards onto server and provided production support for tableau users.

Environment: Tableau7.0/6.0,Tableauserver, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows2003/XP, UNIX.

Confidential, Santa Monica, CA

Tableau Developer/Admin

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 inTableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.
• Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.
• 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.
• Involved in license management SLA’s wif Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Migrated Workbooks and Dashboards fromTableau7 toTableau8.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environments: Tableau server/Administrator, Tableau Desktop v7/v8, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential

PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, DynamicSQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, and Indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 6i.
• Designed and Developed Reports using Oracle Discoverer 9i.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Provided Productions support and ongoing user support for the application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, TOAD, Oracle, Application Server 9i and UNIX.