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.
• Deep experience with the design and development of Tableau visualization solutions.
• 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.
• Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and COGNOS.
• 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, Graphs and 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.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment.
• Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2.
• Experienced in tuning long running SQL queries for better performance.

TECHNICAL SKILLS

Languages: HTML, PL/SQL, SQL, XML, Java/J2EE

Applications: Oracle SQL Developer

Reporting tools: Microsoft SQL Server 2012/2008-R2/2008/2005, R2 SSAS/SSRS/SSIS, Tableau Desktop 7/8, Tableau Server 6/7/8, Tableau Online, Tableau Public, Tableau Reader,TabCmd SAP BO, Cognos

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008/ R2

RDBMS: MS Access, Teradata

Packages / Tools: MS Office, Toad, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Sr. BI/Tableau Report Developer/Admin

Responsibilities:

• Created dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Developed interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Worked on creating complex calculated fields, mapping, hierarchies and dual-axis bar chart with multiple measures.
• Created drill through reports in dashboard.
• Expertise on data blending in case of merging different sources.
• 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.
• 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.
• 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 v8.2/v8.1, Tableau Desktop v8.2/v8.1, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, Sanjose, CA

Sr. BI/Tableau Report Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for BML eBay & PayPal.
• Worked on various data sources such as Oracle, Teradata, SQL Server, DB2
• 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 KPI's.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments.
• 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.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in
• Generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Expertise on resolving issue with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• 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.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2012Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, Austin, TX

Tableau BI Developer

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Deep experience with the design and development ofTableauvisualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Worked on migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: TableauDesktop 7.0/6.0, Tableauserver / Administrator, tabcmd, SQLdeveloper, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft office 2007

Confidential, Houston TX

Tableau Developer

Responsibilities:

• Worked closely with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of TableauServer in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in Tableau environment.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Pushed all the created stored procedures and functions to the development, training and production servers.
• Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent.
• Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.

Environment: Tableau Desktop 5/6, Tableau Server 5/6, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Oracle 10g, Erwin r8, C#.

Confidential, NJ

Jr.Tableau Developer

Responsibilities:

• Worked as Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Worked in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.
• Worked on Informatica Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Actively involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• Used Informatica Power Center for extracting Oracle, flat files for Data Extraction.
• Developed Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy & Sequence Generator.

Environment: Tableau Desktop 5,Teradata, Oracle 8.0, PL/SQL, SQL Server 2008, MS SQL, Informatica 7.1

Confidential

Database Developer and Admin

Responsibilities:

• Carried out detailed study of business, data analysis and configured the material management module to user specification.
• Developed and maintained logical schema, physical records and SQL queries for ORACLE application.
• Tuned Oracle for performance improvement and resolved network configuration and connectivity related problems.
• Created triggers and stored procedures based on the functionality.
• Located and corrected problems involving file operations, process management, I/O operations and memory management for pre-compilers and SQL*net modules.
• Involved in developing ER diagrams.
• Designed and implemented utilities which automated several DBA functions.
• Developed the user interface and menus using triggers, functions and procedures.
• Constructed several normalized database tables with different constraints to maintain integrity.
• Established customer support tracking database.
• Represented the team in documenting and maintaining the changing requirements, design review feedbacks and work discussions with the client.
• Generated Reports and Charts using BO.

Environment: PL/SQL, Developer 2000, Oracle 9i, Windows XP, Business Objects Enterprise 6.