SUMMARY

• Having 10+ years of experience in Business Intelligence and DWH/Database Applications with Strong abilities and Hands on experience in analysis, design, testing, development and implementation of client/server and web applications
• Experience with Tableau Desktop 10.x,9.x,8.x, Tableau Server, Cognos 10 Suite, Cognos 8.X Suite, Cognos Report Net 1.1.MR3 and Server Installation & Maintenance.
• Expertise in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Development, Testing, Deployment, Implementation and Production Support.
• Worked on Report conversion from Legacy Report solution and MS Excel based reports.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms
• 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 in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations
• UtilizedBest PracticesandProven Methodologyin modelling data, ETL (Informatica/Data Stage) and otherBI developmentprocess.
• Expertise in Data ware Housing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modelling.
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients.

PROFESSIONAL EXPERIENCE

Confidential, NYC

Tableau Consultant

Responsibilities:

• Worked with the design and business team to develop effective Tableau visualization solutions.
• Worked on requirement Analysis & Gathering and developed specification documents for reports as per the client needs
• Created actions, parameters, Filter and calculated sets for preparing dashboards and worksheets using Tableau.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created and published data sources with security for business users for Ad-hoc reporting
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Developed SQL scripts & PL SQL stored procedures for complex data analysis and developed tableau dashboards
• Created training documents & trained business users for tableau Ad-hoc reporting
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.

Environment: Tableau Server 10.1,9.3, Tableau Desktop 10.1,9.3, Oracle 11.2, Windows Server 2012 R2, SQL/PL-SQL, Pgadmin III, MS-Office

Confidential, Harrisburg PA

Tableau Consultant

Responsibilities:

• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Converted blue insight reports to tableau reports.
• Extracting data from different sources connecting them and used the same to create dashboard
• Prepared Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Worked on Tableau Server installation & Administration.
• Worked on groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks.
• Worked with ETL team to analyse reporting requirement and load data in Cloudera from sql server using SQL Server Integration Services (SSIS)
• Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
• Executed and tested required queries and reports before publishing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Environment: Tableau Server 9.0,9.3, Tableau Desktop 9.x, SQL server, SSIS, Cloudera, UNIX, Windows Server 2012 R2, Squirrel, SQL, Pgadmin III

Confidential, Piscataway, NJ

Tableau Consultant

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Coordinated with various internal/external system interface team for design/integration testing/ deployment and production issues
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Designed and development of dashboards using Tableau Desktop
• Project Delivery aspects like UAT, Production Migration and Production Implementation
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Effectively used data blending feature in Tableau.
• Created custom reports on ad-hoc basis bi-weekly and monthly
• Designed complex reports with data on demand, details on demand options
• Developed information links with multiple data tables using information designer
• Integrated multiple data tables from dimensional model data mart
• Prepared Test Plan and Plan System Integration testing and performed UAT test along with Business Users

Environment: Tableau Server 7.0, 8.0, Tableau Desktop 7.0, DB2 9.5.0.2, Oracle 10g, WAS 6.1, UNIX, Windows Server 2008, TOAD, SQL, PL/SQL, HP Vertica, Cloudera

Confidential, Des Moines IA

Sr. BI Consultant

Responsibilities:

• Interacted with the Business users and documented their Query, Business and Reporting needs, Analyzed the data and Business logic underlying the requirement.
• Involved in the entire project life cycle from evaluation, installation and development.
• Worked with SSIS/ETL and Data Team to define reporting database for reporting requirement.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Installed & prepared the Tableau server on Single Server Environment Worked on Tableau Desktop
• Professional to create worksheet, dashboards and published them to Tableau server for end user use
• Tested and validated the report output against the database to measure performance of reports
• Troubleshoot the errors during the upgrade process.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Tableau.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Created project documentation for the complete project life cycle.

Environment: Tableau Server v7/v6, Tableau Desktop v7/v6, SQL server 2008, SSIS, WAS 6.1, MS office ( word, Excel), Windows Server 2008, TOAD, SQL, PL/SQL

Confidential, Durham, NC

Sr. BI Developer

Responsibilities:

• Analyzing, Gathering requirements and developed specification documents for reports as per the client needs.
• Created prototype for report in legacy reporting solution/ MS Excel Reports and worked on the plan to build them in TIBCO spotfire and Tableau
• Defined best practices for Tableau report development.
• Extensively worked on Tableau Desktop, by creating Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Executive Dashboard reports, Spotfire workbook using Spotfire Professional
• Created Spotfire workbook according the Functional documents.
• Involved in Scripting of SQL for investigating, researching and verifying results of queries and reports.
• Created Views as per the business and reporting requirement.
• Administering the Servers, Troubleshooting, Performance Tuning and implementing security
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Unit testing, Integration testing and System testing of the reports in Development, Testing and Production environments.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Involved in Designing models using Framework Manager and deployed packages for reporting
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created database layer and business layer, defining appropriate relationship between tables, query subjects in Framework Manager
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Spotfire tools and the existing data model to other team members.

Environment: TIBCO Spotfire Professional 3.2, Cognos 8.4 (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer), Oracle 10g, TOAD, SQL, PL/SQL, Unix, Tomcat/Apache

Confidential, MI

Sr. Cognos Consultant

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Analyzing requirement BDM documents and creating the Framework manger model.
• Enhanced the data model, Designed and Developed technical solutions ( complying the underlying data model) for business users
• Installation & Configuring the Cognos 8.4 on windows Environment.
• Designing the logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Created Business layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Effectively used data blending feature in Tableau
• Developed Executive Dashboard reports, Tableau workbook using Tableau Desktop
• Design and Developed the Framework Manager models and Published into server.
• Developed List, Cross Tab, Drill Through, Master-Detail, Bar Chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.
• Applying the security to display data based on the user security.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Tableau 6, Cognos 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), PowerPlay Transformer 8.4, Oracle 10g, Windows 2003 Server

Confidential, Ridgefield CT

BI Consultant

Responsibilities:

• Analyzing requirement Specification document and preparing the Technical Specification document as per the Business requirement.
• Creating star schema grouping for better understanding of the model & facilitate multi-fact (cross-fact) reporting.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and packages from Development to Testing, Testing to Production environments.
• Trained End-Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 8.3 Suite, PowerPlay Transformer 8.3, DB2 8.1, Cognos Access Manger, Oracle 9i, Windows 2003 Server, Unix Shell scripting, SQL Server2005

Confidential, Virginia Beach VA

Cognos Consultant

Responsibilities:

• Designed models using Framework Manager and deployed packages to the Report Net Servers
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP).
• Involved in writing Stored Procedures and functions in Oracle PL/SQL.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 8 BI, Report Net, Framework Manager, Oracle 9i, DB2, Report Studio, Transformer 7.3, Analysis Studio, Cognos XML, Generic/Cognos JavaScript

Confidential

Cognos Consultant

Responsibilities:

• Involved in designing data model and report design.
• Understanding functional specification and preparing technical spec.
• Designed transformer model, dimension map, facts (regular/calculated).
• Created batch files (macros) to refresh the cube monthly.
• Deployed the cube from Testing Environment to Production Environment using Batch script.
• Writing and testing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).

Environment: Cognos Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1 DB2.0, Report Studio, Transformer 7.3

Confidential 

Cognos Developer

Responsibilities:

• Created catalogues with the help of Impromptu utilizing relational databases.
• Developed impromptu reports with various functionalities (Drill -- through, Cascading prompts) .
• Created templates utilizing Impromptu
• Created ad hoc reports utilizing Cognos Query.
• Created user prompts, conditions and filters to improve report generation.
• Created hierarchies to provide drill-down options for end-users.
• Enabled users to access the distributed HTML reports through local network folders, intranet and via e-mail.
• Analysis of Design Documents.
• Testing the Reports.

Environment: Oracle 7.3/8.1, PL/SQL, Cognos Transformer 6.x, Impromptu 6.x, Power Play 6.x, Cognos Upfront, Microsoft Access