PROFESSIONAL SUMMARY:

• Business Intelligence professional with over 8years of experience in Software Design, Dashboard development, Integration, Implementation of BI and Database Platforms.
• Involved in SDLC of Reporting Projects which includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollouts.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensively worked on Tableau 6.x/7.x/8.x (Desktop, Server, Reader), Micro Strategy, SQL
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Heat Maps, Symbol Maps, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expert in tableau server commands like synchronization and Tableau server backup activity.
• Improved Reports performance in tableau using extracts and context filters.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables, OLAP and OLTP data sets.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
• Team player with good communication and interpersonal skills. Productive interaction with business partners to identify business information needs for reports.

AREAS OF EXPERTISE:

Tableau 6.0/7.0/8.0/8.1

Tableau Server

Microsoft SQL Server

Oracle 8i/9i/10g/11g

MicroStrategy

SDLC

ETL

Teradata

Business Analysis

WORK EXPERIENCE:

Sr. Tableau Developer

Confidential

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Applied technical proficiency across different stages of the Software Development Life Cycle(SDLC) including requirements elicitation, application architecture definition and design.
• Created high level design artifacts and delivered high quality code deliverables for a module & lead validation for all types of testing and support activities related to implementation, transition and warranty.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Experience on writing SQL Queries.
• Strong verbal and written communication skills, ability to work effectively with user departments.

Environment: Tableau 8.1/8.0, Tableau Server, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7

Tableau Developer

Confidential

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards usingtableaudesktop.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Upgraded Workbooks and Dashboards from Tableau 6 to Tableau 7
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features ofTableausoftware like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW fortableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Effectively used data blending, quick filters, actions, hierarchies features in tableau.
• Executed and tested required queries and reports before publishing. Converted Metric insight reports to tableau reports.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.

Environment: Tableau 7 & 8 Desktop, Tableau Server, Oracle 11i, Informatica 8.x, Windows 2003/ XP

Business Intelligence Developer - Tableau

Confidential

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, Tableau Desktop 6 & 7, Micro Strategy 8.1.1, Desktop Reports, Web Intelligence Reports, Architect, Administration, Dashboard, MS SQL Server 2000, Confidential -SQL, Access 2000

Tableau Consultant

Confidential

Responsibilities:

• Interaction with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Involved in the design of the Application Business logic Components, which formed the architecture for distributed application development encapsulating business and data logic.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Implemented navigation and drill down features in Tableau dashboards.
• Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Created visually compelling and actionable interactive reports and dashboards.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Defined group/user level security standards for Tableau.
• Modified/maintained and created Products Universe.
• Created a component, which stores the total business logic of the portal, which contains many class modules related to business.
• Developed, deployed, and managed Commerce applications for the Web.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.

Environment: Tableau Desktop and Server, Business Objects 5.x, Erwin, Windows 2000, IIS 5.0, ASP, SQL Server 2005/2008, VB 6.0, COM, MTS, HTML, DHTML, MS Visual SourceSafe, VBA, Excel

Business Analyst/Reports Developer

Confidential

Responsibilities:

• Interacted with clients for Business Requirements during design & implementation phases.
• Migrated databases from SQL Server 2005& various other sources into SQL Server 2008.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, & import/export wizard while developing packages.
• Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• All data were migrated to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server.
• Involved in the Data Warehouse design process
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Web Intelligence Ad-hoc and canned reports in 3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard
• Developed Dashboards for the higher management of the company
• Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Involved in writing Confidential -SQL, stored procedures, views, triggers, used indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, Visual Studio, SQL, Confidential -SQL, MS Access, MSBI, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS.

SQL Server Developer

Confidential

Responsibilities:

• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Involved in debugging of packages and procedures and functions and troubleshoot jobs using the debugging tool.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in Database design, creation and maintenance of Databases.
• Worked on managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using Confidential -SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access