SUMMARY:

• Over 12 years of experience in Business Intelligence and data visualization tools with Specialization on Tableau 8.x/9.x/10.x and Cognos 7.x/8.x/10.x/11.x.
• 6+ years of working experience in Tableau Desktop and Tableau Server.
• 10+ years of working experience in Cognos8 & 10 BI tools using Cognos Framework Manager, Report studio, Query studio, Active Reports, Workspace and Workspace advanced.
• Expertise in installation of Tableau server in Standalone and distributed environment on AWS EC2 instance and Windows.
• Expertise in creating highly interactive Data Visualization Dashboards using Tableau Desktop.
• Developed highly interactive Data visualization Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Experience in Upgrading the Tableau servers from 8.x to 9.x and 9.x to 10.x.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Experience in using Tableau Server by managing & setting permissions, publishing various data sources and workbooks to Tableau Server.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Frame Work Models in Cognos 8 & 10 against data sources like Oracle, SQL Server, DB2, Teradata, and Greenplum.
• Developed cognos reports using System Development Kit (SDK) by java scripts.
• Developed Cognos multidimensional models (DMR) and published packages and developed cognos dashboards with list, charts, and crosstab.
• Experience in Designing Transformer models and developing for corporate data for building cognos Multidimensional and Dynamic Cubes.
• Experienced in creating Tables, Stored Procedures, Views, Indexes and writing DDL, DML and DCL commands in both SQL Server and Oracle. Achieved Drill Up and Drill Down in Report studio reports using DMR modeling.
• Implemented dynamic data source switching concept and Dynamic column sorting in cognos reports.
• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.
• Domain knowledge in Financial, Banking, Pharma, Insurance, Retail and Healthcare.
• ETL implementation using SQL Server Integration Services (SSIS) and Informatica.
• Good understanding of Project Management process.
• Ability to learn any new technology within a short span of time.
• Given support for US/EMEA clients, and solved critical issues in production environment.

TECHNICAL SKILLS:

Data Visualization Tools: Tableau 8.x/9.x/10.x

Business Intelligence Tools: Confidential Cognos 8.x/10.x/11.x ( Framework Manager, Report studio, Query studio, Active reports, Power play Studio, Analysis Studio, Workspace, Workspace Advanced, Transformer Cubes)

ETL Tools: Informatica Power Center 9.x

Databases: Oracle 8i/91/10G, Teradata, DB2, SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Brenham, TX

Tableau Consultant

• Actively worked with Business Partners and Designers to get the Requirements and create High level Design documents.
• Attended SCRUM meetings related to Projects every Business Day. Active participation in Retrospective Planning Meetings.
• Installation and configuration of Tableau Products such as Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD on AWS EC2 Instance.
• Presented demos to the business users to expose the proficiency of upgraded versions of Tableau.
• Primary contact for On - call/Production support and Service Management
• Utilized Tableau 10 new features such as cross data base join and cross data base filter.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Implemented Automation of Tableau dashboards bursting.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Designed and developed Tableau Dashboards with Custom SQL queries.
• Working as a mentor to guide and motivate the team to reach solutions on time.
• Providing strategic solutions and troubleshooting the BI issues.
• Responsible for providing access to users and stakeholders across all environments.
• Worked on bugs and enhancements to existing Cognos Reports and models in Cognos Framework Manger.
• Created Indexes and Views using SQL to enhance the performance of the reports.

Environment: Tableau 10.2, AWS, Teradata, Oracle 11G, Windows 7.

Confidential, Boca Raton, FL

Tableau Consultant

Responsibilities:

• Involved in gathering Business Requirements and prepared BRDs and Technical Design documents.
• Installation of Tableau desktop and Tableau server on AWS Virtual private Cloud on EC2 instance.
• Used AWS Cloud Formation templates to automatically deploy a standalone or cluster (distributed) architecture for Tableau Server into your AWS account.
• Designed and developed Tableau Dashboards for Loyalty and Non-loyalty using custom Teradata SQL.
• Used advanced chart visualization in Tableau using the Show Me button. Acquainted with Donut chart, box plots, tree maps, heat maps, dual axis, bullet graphs and assist business users in solving complex problems.
• Trained over 100 end users across 10 departments on how to use created Tableau workbooks and interact with Tableau Server.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created Parameters to achieve desired functionality in tableau.
• Implemented Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created conditional filters and Action links to filter the data on dashboard.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created tables, views in Teradata, according to the requirements.
• Recommend best practices in Data modelling to build and maintain Cognos Framework Manager Models, metadata packages and Transformer models.
• Created Multidimensional reports by through DMR models.
• Used render variable, block, conditional block and Conditional Formatting in Report Studio in generating cognos reports as per the user requirements.
• Bursting & scheduling the reports for daily run/monthly/weekly according to client requirement.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.

Environment: Tableau 9.1/10.3, Cognos 10.2(Framework Manager, Report Studio, Metric Studio, Analysis Studio, Cognos Work Space), Teradata, Oracle 11G, Motio CI, Windows 7.

Confidential, Austin, TX

Senior Tableau Consultant

Responsibilities:

• Work with the line of business to define the business strategy and create a centralized reporting capability for users to perform analytical and ad-hoc reporting.
• Worked in multiple phases of Software Life Cycle starting from the requirement analysis to production and post production support.
• Installation of Tableau desktop and Tableau server on AWS Virtual private Cloud on EC2 instance.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Used advanced chart visualization in Tableau using the Show Me button. Acquainted with Donut chart, box plots, tree maps, heat maps, dual axis, bullet graphs and assist business users in solving complex problems.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Developed highly polished executive level dashboard prototype for the Operations Research Consulting group which provides BI for different Healthcare modules to implement their decision support systems for developing competitive Healthcare services and optimizing the data between partner healthcare’s, etc.
• Created DMR model with Dimensions and Hierarchies for providing drill downs & ups in Analysis Studio.
• Created and published packages for different subject areas with best practice, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Created list, crosstab and chart reports and implemented drill-though conditions and Master-Detail relationships.
• Created multiple Report Pages using Page Breaks and grouping/sorting.
• Created Burst Reports, distributed and scheduled reports in Cognos Connection.
• Used various kinds of prompts like Value Prompt, Date and Time prompt, Cascading Prompts, etc. for better performance, also worked with customized prompts using HTML Items.
• Extensively used filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Performed Unit testing of the developed reports before moving the reports in to QA.
• Coordinated with the line of business users for User Acceptance testing prior to releasing system changes to production.
• Involved in deployment of reports and packages from DEV to UAT and from UAT to PROD.

Environment: Tableau 9.2,Cognos 10.2.2(Framework Manager, Report Studio, Cognos Work space advanced),Oracle 11g, Motio CI,Windows 7.

Confidential, Boca Raton, FL

Senior Tableau developer

Responsibilities:

• Involved in gathering Business Requirements and prepared BRDs and Technical Design documents.
• Designed and developed Tableau Dashboards for Loyalty and Non-loyalty using custom Teradata SQL.
• Used advanced chart visualization in Tableau using the Show Me button. Acquainted with Donut chart, box plots, tree maps, heat maps, dual axis, bullet graphs and assist business users in solving complex problems.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created Parameters to achieve desired functionality in tableau.
• Implemented Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created conditional filters and Action links to filter the data on dashboard.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created tables, views in Teradata, according to the requirements.
• Recommend best practices in Data modelling to build and maintain Cognos Framework Manager Models, metadata packages and Transformer models.
• Created Multidimensional reports by through DMR models.
• Used render variable, block, conditional block and Conditional Formatting in Report Studio in generating cognos reports as per the user requirements.
• Bursting & scheduling the reports for daily run/monthly/weekly according to client requirement.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.

Environment: Tableau 9.1, Cognos 10.2(Framework Manager, Report Studio, Metric Studio, Analysis Studio, Cognos Work Space), Teradata, Oracle 11G, Motio CI, Windows 7.

Confidential

BI Consultant

Responsibilities:

• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings.
• Effectively used data blending feature in tableau to get data from Sql Server & MS Excel.
• Created out of the box charts for complex end user Requirements. Converted Heat map to funnel chart, Pie chart to a donut chart, Bar chart to a waterfall chart and many others.
• Executed and tested required queries and data before publishing Dashboard.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.1.
• Deep experience with the design and development of Tableau visualization solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Worked on technical design specs for Framework manager, and reporting per the requirements.
• Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design. Transition the same knowledge to the team for full support.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, business layer and presentation layer defining the cardinalities and appropriate relationship between query subjects.
• Created parameter files and parameter mappings for automation using macros.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Deploying reports and packages from development to QA and QA to production environment.
• Presented demos to the business users to expose the proficiency of upgraded versions of Cognos tools.

Environment: Tableau 9.1, Confidential Cognos 10.2 ( Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos workspace Advanced),Teradata and Windows 2008.

Confidential

Senior BI Developer

Responsibilities:

• Actively worked with Business Partners and Designers to get the Requirements and create High level Application Design.
• Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with customers and inside partners to accumulate necessities and set milestones in the research, advancement, and execution periods of the project lifecycle.
• Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created cubes using packages which are built in framework manager.
• Created and supported cognos Transformer models based on the dimensions, levels and measures required for the analysis studio.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, business layer and presentation layer defining the cardinalities and appropriate relationship between query subjects.
• Created Standard Reports using Report Studio, like Dashboards, List Reports, Crosstab Reports and Chart Reports and Ad- Hoc Reports using Query Studio
• Created reports which involved Multiple Prompts, Filters, multi-query reports.
• Modify the existing report based upon the change request by the client.
• Implemented drill through on columns and cells to get the detailed information, and also used style, render variables formatted the reports using layout component reference and Classes.
• Developed complex reports using Drill through, conditional blocks and render variables.
• Involved in status calls for requirement gathering and updating the requirements in the Design document and publishing the updated document into share point.
• Involved in unit testing of reports and model.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Environment: Tableau 8.3/8.4, Confidential Cognos 10.1(Framework Manager, Report Studio, Query Studio, Powerplay Transformer), SQL Server 2005, Windows7.

Confidential

Senior BI Developer

Responsibilities:

• Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment.
• Created users, users groups and maintained user access rights in Tableau.
• Created Architecture Design documents and Technical Specifications Documents.
• Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh.
• Implemented Tableau Mobile across several lines of businesses.
• Implemented Tableau BI application creation, Tableau Administration, Installs and Server side functionalities.
• Provided technical support to all team members during project execution.
• Performed reports/dashboards performance optimization.
• Involved in User Training of Tableau dashboards.
• Created intuitive ways in Dashboards to implement multi-level drill through's, Ranking, Dual Axis, Geo Coded Mapped views and Histograms
• Validating & troubleshooting migrated metadata models and reports in Cognos 10.1 environment.
• Designed the Cognos Framework Models and Packages using Cognos 10.1.
• Developed different types of reports with Multi - Logical Pages, Multi- Logical Queries, Different Layouts and Multiple Report Objects using Cognos 10.1.
• Developed complex dashboard reports using report studio.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created reports by using Query calculations and Layout calculations.
• Developed list, cross tab, drill through, master detail, chart, complex report which involved multiple prompts, conditional blocks in report studio.
• Coordinated in moving the Packages, Reports, and Cubes from Development environment to STAGE and Production Environment.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.

Environment: Tableau 8.1/8.2, Confidential Cognos 10.1/8.4(Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio), Powerplay Transformer, Oracle 10g, Windows 2008.

Confidential

Senior Cognos Developer

Responsibilities:

• Involved in requirement gathering and preparing the both functional and technical documents for all reporting needs.
• Designed the Cognos Framework Models and Publish into server.
• Developed different types of reports with Multi - Logical Pages, Multi- Logical Queries, Different Layouts and Multiple Report Objects using Cognos 10.1.
• Created reports by using Query calculations and Layout calculations.
• Created new reports using conditional format, applying sort, ranking to data and bursting reports.
• Created reports using page breaks, drill-thru, and master/detail functionality.
• Create cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
• Designed the reports to audit the report user's activities and reported this on a monthly basis to the Users.
• Assisted users in troubleshooting their reports.
• Execute performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Write different stored procedures, triggers in PL/SQL as per functionality.
• Coordinate with Development Team tasks& Deliverables and work on high priority issues.
• Interact with the End users on a regular basis for resolving issues pertaining to the reports.
• Extensively worked on Peregrine tickets to get it resolved the issues in Production.

Environment: Cognos 10.1, Cognos SDK, Teradata 12.0, Informatica 8.5, BI Query 8.5, Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Involved in requirement gathering and preparing the both functional and technical documents for all reporting needs.
• Created Technical design document for Report studio reports based on Functional specifications.
• Designed the Cognos Framework Models and Packages using and Cognos 8.3.
• Defining appropriate relationship between query subjects and making joins in Framework Manager.
• Created IQD files using Framework Manager relational model.
• Developed and Publish the Packages into Cognos Connection and keep the version.
• Worked on Page explorer, query explorer, and condition explorers were used to manage the content of the reports in Report Studio.
• Developed dashboards comprising of list reports, cross-tab reports and chart reports using filters, calculations, complex expressions, and conditional formatting.
• Developed Multi-page reports, Drill through, and master-detail reports using Report Studio.
• Created list page headers and sub headers to lists using block in report studio list reports.
• Created Table of contents page in report studio to develop the report in PDF format and provides drill through operations to respective content entries were used to navigate through reports instantly.
• Used table properties like merging selected cells and splitting the merging cells, and group or ungroup selected data for lists in report studio.
• Worked on query join logic, various types of prompts like value prompt, search & select prompt, Text Box prompt and Date & Time prompt.
• Developed different types of List, Cross tab and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports.
• Developed the various report with conditional formatting by using conditional explorer
• Designed the reports to audit the report user's activities and reported this on a monthly basis to the Users.
• Assisted users in troubleshooting their reports.

Environment: Cognos 8.3(Framework Manager, Report Studio, Analysis studio), Oracle 10g, Informatica 7.1 and Windows 2003.

Confidential

Cognos Developer

Responsibilities:

• Faced client in gathering the business requirements by understanding the existing system and the way of reporting the data.
• Analyzed the existing reports and consolidated the reports making into a standardized format.
• Designed the report layouts as per the business requirements.
• Worked on Query Studio and Report Studio.
• Created new Catalogs using the Impromptu software and used them for reporting purposes in Cognos Impromptu.
• Created reports using Conditional blocks, style variables.
• Developed the various report with conditional formatting by using conditional explorer
• Prepared the technical specification document based upon the business logic and the report items.
• Prepared project related documents which describes the development of the process.
• Created Impromptu Catalog by adding tables and data files, & creating new joins.
• Created Prompts, Calculations, Conditions & Filters and creating New Jobs using Impromptu Administrator.
• Created Models by using various data sources in Power Play Transformer.
• Created User Classes and Users in Access manager and provided the user credentials.
• Used Power Play Enterprise Server to publish the cubes and Impromptu reports to the Upfront.
• Build Transformer models using Cognos 7 series.
• Create catalogs and reports in Cognos Impromptu, design the cubes using Power play Transformer and build &testing of power play cubes.
• Publish reports on Cognos Upfront and create users, user classes, user groups and grant permissions using Access Manager Administration.
• Migrated the Impromptu catalogs from Cognos 7.3 to Cognos 8.
• Create simple list, grouped list, cross tab, grouped cross tab reports by using report studio.
• Create relational, OLAP models in Framework Manager and publish the packages.
• Designed the transformer model by identifying the dimension, hierarchy and the measures.
• Implemented Drill through from Analysis Studio to Report Studio.
• Prepared the following business/technical writing of requirements, design, templates, development standards documents and detailed design documents.
• Prepare Quality Documents and also give project induction and knowledge transition to new joiners.

Environment: Cognos 8.1MR2 (Framework Manager, Report Studio) Cognos EP Series7 (Impromptu), Oracle 8 and Windows 2003.