SUMMARY

• Over 8+ years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau.
• Extensive experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Deployed the reports andScheduled Reportsfor the use of end users and customers
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and SAP BO.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphsand Breaks.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Expertise in working with all modules of SAP Business Objects XIR3/XIR2/6.X/5.X,Crystal Reports 2008.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinSAP BO.
• Installation, configuration and administration of Crystal reports and SAP BO.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
• Strong working knowledge in software development methodologies like Rational Unified Process (RUP), Agile, Waterfall across the span of various projects
• Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2
• Excellent data-analysis skills and ability to translate specifications into a working Universe and Report
• Experienced in tuning long running SQL queries for better performance.

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 / 9.0/9.1 , 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, Aster;

OPERATING SYSTEMS: Windows 2000/2003 Server, Vista / XP, UNIX

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

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

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 9.0, 9.0.1, 9.0.2, 8.1/8.2, Windows Server Standard R2, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX .

Confidential, SFO

TABLEAUDEVELOPER

RESPONSIBILITIES:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard 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 creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures and also used small multiples.
• 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 AnalysisServices.
• 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.
• MonitoredVizQL 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.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• 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 v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, HARTFORD, CT

TABLEAU CONSULTANT

RESPONSIBILITIES:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL queries to import data from sql server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

ENVIRONMENT: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential, NY

SQL DEVELOPER

RESPONSIBILITIES:

• Involved in different phases of SDLC process of design, development and testing of License Information Repository application using SQL Server.
• Participate in up gradation and migration of data from SQL
• Modified a number of existing stored procedures based on the changes made to existing tables.
• Migrated DTS packages to SSIS packages.
• Worked with slowly changing dimensions type 2.
• Created SSIS packages to perform cube processing from staging to Analysis Services Cube.
• Developed aggregated queries to populate the fact tables.
• Created a MOLAP Cube on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart.
• Handled millions of records on changing dimensions as well as facts in SSAS.
• Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005 Reporting Services.

ENVIRONMENT: SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP.

Confidential, Atlanta, GA

SQL DEVELOPER

RESPONSIBILITIES:

• Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
• Provide database coding support to application development team.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Design and develop data transformation processes.
• Design and develop SSIS packages for data transformations and importing into new database.
• Design T-SQL code blocks.
• Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
• Provide database coding support to application development team.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Implement application database objects such as tables, stored procedures, user defined functions, views.
• Provide database coding support to application development team.
• Maintain SQL Scripts for changes in database objects.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.

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