SUMMARY

• Over 5 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience inTableauDesktop,TableauServer andTableauReader in various versions ofTableau6,Tableau7 andTableau8.
• Involved in Requirements gathering and analysis, Design, Development, Testing and Production, rollover of Reporting and Analysis of projects.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Expertise in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables. Extensive experience on building dashboards usingTableau.
• Skilled inTableauDesktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes
• Skilled and experienced in using appropriate calculations, parameters, report types, dynamic attributes, sets, cubes, filters withinTableau
• Well versed on Data filter, Combined Data Stream, Overriding methods, Bursting Techniques, Page level security techniques. Conditional report designing, Adhoc reporting
• Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML & drivers setup activities
• Proficient in Designing, Creating and Maintaining Catalogues in Impromptu, Models and Cubes in Power play, Creating and Publishing packages in Cognos 8 and Report Net.
• Experienced in designing Business Models and Packages to meet complex reporting requirements using Framework manager in Cognos 8 and Report Net.
• Designed, developed and supported production environments using Cognos 8, Report Net, Impromptu, Cognos Powerplay, Transformer, Impromptu/ Powerplay Web Reports, Powerplay Enterprise Server, Cognos Upfront and Access Manager.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and DE normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Extensive experience in monitoring the database server for deadlocks, long running queries and tuning the same to improve performance.
• Explore to Data Warehousing (Start Schema, Snow Flake schema, fact and dimensional tables) and software development life cycle (SDLC)
• Business Research - feasible study, table content, secondary research, primary research, data analysis and report writing.
• Ability to manage multiple and varied tasks with enthusiasm, deal with tough and demanding work priorities, prioritize workload with attention to details.
• Flexible and versatile to adapt

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential, Boston, MA

Responsibilities:

• Involved in SDLC which includes gathering of business requirements, design document and planning development and publishtableaudashboards.
• Extensively used advance chart visualizations inTableaulike Dual Axis, Box Plots, Bullet Graphs, and Tree maps, Bubble Charts, etc., to assist business users in solving complex problems.
• Develop prioritization scorecard to provide transparency around how to prioritize Request For Proposals (RFPs) to better support revenue goals and the chances of winning.
• Prepare RFP prioritization dashboards and the win rate on prioritized RFPs vs de-prioritized RFPs.
• Created calculated fields to calculate the no. of RFPs, win percentage, prioritization and client breakdown ratio.
• Develop a marketing framework, strategy and process that support the firm's strategic plan and revenue goals.
• Concentrate on the focus products and support and develop dashboards for the effective release of the products.
• Upgrade collateral around specific investment management products through deep understanding of data visualization usingTableau.
• Providetableauvisualizations to monitor the timing of launches to meet client expectations for product offerings.
• Used filters to filter mandate amount based on region globally.
• Used Excel sheets and csv files to generatetableaureports.
• Blended data from multiple databases into one reports from selecting primary keys from each database for data validation.
• Involved in analysis of key performance indicators (KPI) for winning percentage to better understand the business.
• Extensively used trend lines and reference lines.
• HandledTableauadmin activities creating projects, users and synchronizing.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Working knowledge in SQL query rewriting and optimization using Oracle, SQL Server databases.
• Worked in agile team setting and knowledge of other BI tools Micro strategy and OBIEE.

Environment: TableauServer 8.3,TableauDesktop 8.3, SQL Server, Oracle, MS Office, Windows 7.

TableauDeveloper / Consultant

Confidential, New York, NY

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers andexecutives.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created reports and dashboards using Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,Maps.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableauserver.
• Created new Schedule's and checking the task's daily on the server.Experience in standardizingTableaufor shared service deployment.
• Extensively used data blending, embed functionalities inTableau.
• DeployedTableauServer in clustered environment by mapping server nodes to primary machine.
• Involved in creating dashboards and reports inTableauand Maintaining server activities, user activity, and customized views on Server Analysis.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Designprocess for various Sources and Targets.
• Defined best practices forTableaureport development and effectively used data blending feature in tableau.
• Created users, groups, projects, Data connections, and settings as atableauadministrator.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly

Environment: TableauDesktop / Server 7.0, Teradata, Microsoft office 2007, SQL, PL/SQL, T-SQL.

BI Developer

Confidential, Philadelphia, PA

Responsibilities:

• Worked on Full life cycle development (SDLC) involved in all stages of development, Created different types of reports in SSRS such as parameterized and cascaded parameterized reports.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Worked on different types of reports in SSRS like Drill Down and Drill Through.
• Wrote complex queries, CTE's (Common table expressions), stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Designed reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Access, TOAD, Windows.

TECHNICAL SKILLS:

Operating Systems: Windows Server/7, UNIX, Linux

Languages: T-SQL, PL/SQL, C, C++, Java, HTML, XML

RDBMS MS SQL Server2008,2008R2,2010, DB2:

BI Tools: Tableau8.x/7.x/6.x, T-SQL, SQL BI Suite (SSRS, SSIS, SSAS)