SUMMARY

• Over 7 years of experience in design, development, implementation, and administration of various Business Intelligence tools and Web application environments.
• 3+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1and 8.2as a Developer and Analyst.
• Extensive working experience in creating visualizations and Dashboards usingTableau Server, Tableau Desktop and Tableau Public.
• Experience in TableauEnterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Designedanddevelopedvariousanalyticalreportsfrommultipledatasourcesbyblendingdataonasingle worksheet in Tableau Desktop.
• Designing outstanding visualizations using tableau software.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T - SQL.
• Expertise in designing and development of various dashboards, reports utilizingvarious TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Dimensional maps, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Publishing and presenting dashboards on web and desktop platforms.
• Creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.
• Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters.
• Experienced in Databases such as Oracle, Microsoft Access 2000, DB2 and SQL server2000/2005.
• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 6.0/ 6.5/ XIR2/ Crystal XI and Web Intelligence.
• Extensive experience working in Windows, UNIXenvironments.

TECHNICAL SKILLS

Programming Languages: C, C++, T-SQL, XML,HTML, JavaScript, JQuery, .NET (ASP.NET, C#, VB.NET), UML.

Business Intelligence tools: Tableau 6.0/ 7.0/ 8.0/ 8.1/ 8.2 , Informatica Power Center 7.1/8.6/9.1, Cognos8.1,8.2, 8.3, 8.4&10, Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI.

Data Base: SQL, Oracle 9/10gi, Server 2000/2005/2008/2008 R2/2012, MS Access2000, Teradata

Operating Systems: Windows 2000/2003 Server, Vista / XP, UNIX

SDLC tools: Perforce, Team foundation Server (TFS), HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, GA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• 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.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Windows Server Standard R2,, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX .

Confidential, Fargo, ND

TableauDeveloper

Responsibilities:

• Created dashboards according to user specifications and prepared stories to provide an understandable visions.
• Involved in gathering user requirements and in the Design Team
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop.
• Used Tableau visualization software to generate Tableau combination dashboards.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased 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 groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 6.1/7.0/8.0/8.1 , TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, Columbus, OH

SQL Developer

Responsibilities:

• Involved in gathering System Specification Requirements for the project.
• Used Business intelligence to perform Extensive Data Scrubbing on Name and Address of customers to meet new business requirement, and automated the process for new records with exception report generation to maintain data quality and consistency.
• Created database objects like User Defined stored procedures, UDFs to be used for ETL, Audit and maintenance tasks.
• Performed the query and database optimization using Profiler and Index tuning Wizard.
• Developed Cognos Packages to migrate data from Flat files, Access, Oracle to SQL Server Database pertaining to the Products cost to sales from previous years.
• Managed the connections to the servers for connectivity and also created linked servers for performance.
• Managed Users and their access to specific database resources based on schemas and user groups.
• Performed report testing and Verification as per internal reporting system requirements.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Performed intensive data quality testing on various Data Migration processes and wrote various post scripts to perform data correction.

Environment: MS SQL Server 2005/ 2008 R2, Crystal Reports 2008 XI, Oracle 9.2, Cognos8.1, 8.2, 8.3 & 8.4.

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 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.