PROFESSIONAL SUMMARY:

• Over 8+ years of professional experience in Business Intelligence, Software Design, Modeling, Development and Implementation in Information technology with skills in all phases of Data Warehouse lifecycle development.
• Proficient in designing and creating various Data Visualization Dashboards, worksheets and analytical reports to help users to identify critical KPI(Key Performance Indicators) 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.
• Worked with SQL server and Oracle databases as the backend and have knowledge in writing various queries, triggers and stored procedures in SQL Server 2008/Oracle 10g. .
• 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.
• Involved in installation of SAP HANA 1.0.17 in two environments.
• 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 Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• Experienced with ETL tools like Informatica, SSIS, SSRS.
• Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

TECHNICAL SKILLS:

BI Tools: Tableau Server6/7/8, Tableau Desktop 6/7/8/9, Tableau Online, Tableau Public, Tableau Reader, QlikView, OBIEE 10g,11g, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), TabCmd

Database/ERP: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access, OLAP, OLTP, SAP.

Tools: and Packages SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, MS Office (Word, Excel, PowerPoint), Adobe Acrobat, Visio, JIRA, TOAD.

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

Operating Systems: Windows 2000/2003, 2008 Server, Windows 95/98/2000/XP/7/Vista/8, UNIX, LINUX.

Methodologies: SDLC, Scrum, E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE:

Tableau Developer/Admin

Confidential, Santa Monica, CA

Responsibilities:

• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Experience in standardizing Tableau for shared service deployment.
• 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.
• 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.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

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

Tableau Developer

Confidential, New York, NY

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.
• Created incremental refreshes for data sources on Tableau server.
• Involved in license management SLA's with Tableau support.
• 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 with other production systems.

Environment: s: TableauDesktop9.0/8.3, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Tableau Developer/Admin

Confidential, Farmington Hills, MI

Responsibilities:

• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Developed Dashboards using OLAP cubes.
• 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 with dashboards.
• Use of Java script for embedding the dashboards on the webpages.
• 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.

Environment: s: TableauDesktop9.0/8.3.0, Tableau server/Administrator, SQL developer, SSIS, OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Tableau Developer/Admin

Confidential, Boise, ID

Responsibilities:

• Migrated the server from a VM to Physical server to improve the performance.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• 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.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style
• Created scripts to send automated alerts whenever restore or backup fails
• Involved in creating dashboards and reports in Tableau8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Coordinated database middleware issues with DBA's, query performance with System Architects
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level 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

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

Tableau Developer

Confidential, Bloomsburg, PA

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.
• Developed business process and technical design documentation for each reporting service developed in this project.
• 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.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Developed unlinked, on - demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Published views and dashboards in Tableau Server for auditor review.

Environment: Tableau Server 7, Tableau Desktop 7, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, Oracle 11g, Toad, MS Office, Visual Studio 2010.

Tableau Developer

Confidential, Washington, DC

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL design, development, testing, and production rollover of reporting and analysis projects within
• To know the user's distribution i.e. least and most concentration heat maps were designed which enables the end user to infer through the color in Heat Map.
• Involved in creating a dual - axis and dual maps with multiple measures.
• Automated the data extracts and subscriptions with Tab-Cmd tool.
• For further data analysis charts are converted into Crosstabs which can be used in MS Excel.
• To determine profit generation by using data from Oracle SQL Server, bullet graphs were used, which allow people who are colorblind since it restricts colors.
• Created YoY and QoQ comparison charts using Line Graph to better understand the performance of claims over a period of time
• Created bar chart showing the claims closed by week filter by sales rep.
• Created report showing the average time to settle a claim (in days) using line chart.
• Created parameters to give ability to users to dynamically change the filters and see resulting numbers.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Interacted efficiently in meetings, review analysis and user group discussions and communicated well with business clients and suggested modifications for their requirements.

Environment: Tableau Desktop 8.3/9.0, Oracle 11g, SQL Developer, Toad, Microsoft Office Suite (Excel, Word, Access, Visio), JIRA

Tableau Developer

Confidential, Morris Plains, NJ

Responsibilities:

• Created time series dashboard using context filter on weather data.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop - down menu option and Parameterized using Tableau.
• Created different types of charts, plots and maps based on nature of data.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.

Environment: Tableau 9 (Desktop/ Server), MS Excel, MS SQL