PROFESSIONAL SUMMARY:

• 8+ years of work experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools like Tableau Server, Tableau Desktop and SQL server.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Handled various responsibilities in Database issues, Data modeling, Data mapping, ETL Development, metadata management, and reporting solutions.
• Have strong understanding of Data Modeling concepts (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementation of Data warehouse.
• Experience in extracting and combining Data from different Data sources, different Databases and Data warehouses
• Extensive experience in Tableau Desktop workbook design, reports and dashboard design and Tableau Administration/server includes technical support, troubleshooting, user / group setup, permissions, security roles and monitoring of system usage.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps and forecasted reports.
• Extensively Used Data Blending to Join Multiple Data Sources and Rendering the data into visualization in Tableau
• Deep conceptual knowledge of Tableau architecture including VizQL server, Application Server Data Engine and Data server.
• Deep conceptual knowledge and hands on experience on Visualizations, Details on Demand, Information Designer, Automation Job Builder, Property controls, Action controls, filters and custom plugin, Library Administrator, ADS, In - memory Architecture.
• Created dashboards, reports, analytics and advanced data visualizations
• ­­ Designed and deployed dashboards, reports with drill down, drill through and Drop down menu option.
• Strong SQL skills including use of nested table expressions, unions, multi-table joins
• Excellent data skills, including the ability to analyze, visualize, and present data in a clear and concise manner.
• An excellent communicator with exceptional interpersonal skills, ability to interact effectively with clients, business users and peers to get the work done smoothly
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau's Advanced Capabilities.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions
• Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.
• Expertise in developing and coordinating automation tasks that enable the rapid and repeated delivery of custom reports. Also, created many Executive level and customer facing dashboards using Tableau 7.0, 8.0, 9.0., 10.

TECHNICAL SKILLS:

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.

Data Visualization: Tableau Desktop/Server/Reader 6/7/8/9, QlikView,Microstrategy, PowerPivot, Excel, SSRS, SSIS, DTS, SSAS, Visual Analytics, Crystal reports XI/2008, PostgreSQL

Relational Databases: MS SQL Server 2014/2012/2008 R2/2005/2000, Teradata, Oracle 9/10/11/12, MS Access

Tools & Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio 2005/2007/2010/2012

Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

Web/App Servers: IIS 5/6/7, Apache Tomcat

Operating Systems: Windows 2008, Windows Server, Data center, Windows NT, Windows XP, UNIX,LINUX.

Configuration Management Tools: Team Foundation Server, Visual Source Safe, Clear Case

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Tableau Admin/Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.
• Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.
• Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool.
• Building the customized and interactive dashboards using multiple data sources.
• Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.
• Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
• Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
• Used CA Clarity to populate dashboard and to submit timesheet approval.
• Involved in creating the report mock ups, proto types for the end dashboards and interacting with stakeholders for report change request and sign -off on the requirements.
• Acts as a Tableau Developer, experience in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Liaison between various cross functional departments, stake holders and business end users for the reports, dashboards clarifications, development, Usage of reports and end user tableau reports training.

Environment: Cloudera Imapala, Teradata, Hadoop, Business Rules Engine, Google Query, MS Visio, and MS Excel, Tableau 10x version (Desktop and Server),CA Clarity, Trello.

Confidential, Novi, Mi

Tableau Admin/Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
• Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.
• Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geocoding.
• Good Experience in working on Tableau data analysis as Tableau Analyst and building, developing the Tableau development dashboards as a Tableau Developer and Publishing the developed Tableau dashboards to Tableau server with security and authentication as a Tableau Administrator.
• Acts as a Tableau Analyst, for performing various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Systems\Sources GAP Analysis, Trend Analysis (Data vs Time).
• Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
• Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
• Involved in creating the report mock ups, proto types for the end dashboards and interacting with stakeholders for report change request and sign -off on the requirements.
• Acts as a Tableau Developer, experience in extracting, transforming, analyzing, visualizing, and presenting data from diverse business areas in novel and insightful ways to enable business executives to take informed action.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down. 
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment, and Users access.
• Used Teradata utilities multiload, fastload, tpump to load data.
• Liaison between various cross functional departments, stake holders and business end users for the reports, dashboards clarifications, development, Usage of reports and end user tableau reports training.

Environment: Tableau Desktop 9.0, SSRS, Oracle 11g, Microsoft Excel 2010, MS Access, Microsoft office 2010, Teradata.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Designed and created Microstrategy reports, objects (Attributes, Filters. Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Worked on drill through reports by creating HTML references.
• 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.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Installing JDBC SAP HANA driver for the connection and extracted data into Tableau.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau Server 8, Tableau Desktop 8, SAP Hana, SQL BI Suite (SSIS, SSRS, SSAS), Visual Studio 2010, Windows, Jira.

Confidential, San Ramon, CA

SQL BI Developer

Responsibilities:

• Involved in gathering Business Requirements and System Specification from users.
• Successfully implemented physical database on MS SQL Server 2000.
• Supported complex relationship using Triggers
• Facilitated simplified access of database for end users using De-normalized views and created Triggers on them to maintain to database integrity.
• Developed Stored Procedures and T-SQL queries to generate reports for the end users.
• Created views and various User Defined Functions for fast access of data from tables.
• Migrated DTS Packages of SQL Server 2000 to SQL Server 2005
• Created Ad-Hoc reports for business users using SSRS
• Created Drill down and Drill through reports in SSRS.
• Designed and developed Parameterized and cascading parameterized reports.
• Created various reports using Report Builder.
• Designed stored procedures to create reports.
• Tested OLAP cubes and SSRS reports for various business needs. 
• Involved in creating multiple level Cascading Prompt for both static and dynamic parameter
• Troubleshoot SQL Server performance issues for internal and external customers
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created SSIS packages with event handlers.
• Building of OLAP cubes with SSAS …
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, Infopath files, text files and Excel files.
• Scheduled the DTS package for migration data from old system to MS SQL 2005.
• Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Monitored and Tuned Databases, Indexes, Stored Procedures and Server Performance using Performance monitoring tools for MS SQL Server 2000 with the help of Administrator
• Participated in the Design, Creation and Maintenance of SQL Server database
• Involved in implementation, maintenance, and monitoring Database Back-ups, Database Space Management, Error Log monitoring, patch application, etc
• Involved in Optimization and Performance of queries and Used DBCC command to free SQL cache memory.

Environment: SQL Server 2000, T-SQL, VB 6.0, DTS, SSRS, SSIS, XML, Visual Source Safe, MS Office, Windows 2000.

Confidential, Aliso Viejo, CA

BI Developer

Responsibilities:

• Created custom functions, stored procedures and packages to retrieve the data from tables.
• Involved in creating synonyms to reduce the usage of base tables to securing the data.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Involved in writing UNIX shell scripts.
• Developed and deployed the User Interfaces using Oracle Developer 6i Forms.
• Developed and deployed the reports using Developer 6i Reports.
• Performed optimization of SQL queries (Used Explain Plan, TK-prof and Hints to tune SQL Queries)

Environment: Oracle 8i, PL/SQL, Sun Solaris 5.0, Forms 4.5i, Reports 5, TOAD, SQL * Loader.