VIKHYATH

ac2evl@r.postjobfree.com

503-***-****

SUMMARY:

7+ years of experience in Design, Analysis, Development, Dimension Modelling, Deployment and Testing. Experience in Data and Business Analysis. Worked on various versions of Tableau and Cognos BI in implementing complete life cycle for BI/enterprise system.

Over 5 years of experience in:

TABLEAU (8.2, 8.3, 9.3, 10.0, 10.2, 10.3) (Tableau Developer, Tableau Server)

Over 4 years of experience in:

COGNOS 10 (10.1/10.1.1/10.2) (Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Cognos Connection and Transformer)

COGNOS 8 (8.4/8.3/8.2)

Over 5 years of experience as a Business Systems Analyst in reviewing, documenting, analysing and evaluating Business and User needs. Implementing enterprise level business systems and data management

Familiar with Microsoft POWER BI

Extensive Experience in Tableau Desktop and Tableau Server in various versions of Tableau as a Developer and Administrator

Expertize in creating visual appealing dashboards and reports.

Proficient in Cognos 10 report Studio, in creating Active Reports

Very good knowledge of metadata modelling using Cognos Framework Manager.

Experienced in SQL Queries, Creating Views, PL/SQL Stored Procedures, Functions, Triggers, Cursors as per the business requirements

Worked on databases such as Oracle 10g/9i, SQL SERVER 2000/2005, DB2 and Teradata

Experience in Production/Customer Support, Deployment, Development and Integration.

Implementing projects and enhancements in Agile methodology with daily scrums

Good Knowledge of Sprint planning, conducting daily scrums, sprint reviews, sprint retrospectives, helping stake holders with user stories, preparing product backlogs, sprint backlogs and monitoring sprint progress with burn down charts.

Good skills in strategic planning of the project and execution

Good skills in designing infographics and Visio diagrams for workflow designs, presentations and Proof of Concepts

Possess good communication skills and comprehensive problem solving abilities. Able to manage communications among members at diverse situations in a team

Possess skills to influence situational awareness between the Business and the development team, team empowerment and to instill transparency into the team

Excellent management and decision making skills, positive attitude even in bleak situations.

CERTIFICATIONS & TRAININGS:

CSM – Certified ScrumMaster

Underwent Complete Tableau Training by Senturus

Attended workshops and training on Predictive Analytics using Alteryx, by BPM Northwest

TECHNICAL SKILLS:

Business intelligence tools

Tableau Desktop, Tableau Server, COGNOS BI Suite (Report Studio, Query Studio, Analysis Studio, Event Studio, Framework Manager), Nintex Workflows, Informatica

Databases

Oracle, SQL Server, DB2, Teradata

Data Bending Tools

Alteryx

Languages

SQL, PL/SQL, VBA, C, C++, C#.net

Querying Tools

Toad, SQL-Plus, AQT

ETL

Informatica

Data Modelling

Visio 2003, ER/Studio 3.5/4.0, Erwin 4.1

Other Tableau Plug-ins

Senturus BI Connector

Project Management

Microsoft Team Foundation Server (TFS), SharePoint, MS-Excel

SDLC Methodologies

Agile/Scrum, Waterfall Models, Iterative Models

EXPERIENCE SUMMARY:

Daimler Trucks NA September 2015 - Current

Portland, OR

Sr. Tableau Developer / Data Warehouse - Business Systems Analyst

Responsibilities:

Involved in integration, performance, and user acceptance testing for BI solutions and reports.

Creating the connection with DB2 to Tableau and executed custom SQL Expressions to ensure better performance

Created several Dashboards in Tableau Desktop as per the requirements and published them to internal team for review, further analysed data and customized the live dashboards using filters and actions

Wrote complex SQL in Advance Query Tool and connected that SQL to Tableau for better performance of the dashboards

Created Stacked Bars, Heat Maps and other several visualizations showing Actual vs forecast project budgets into Cost centres allowing business user to plan and understand controlling, functions and operations

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Converted charts into Crosstabs for further underlying data analysis in MS Excel

Tested dashboards to ensure data was matching as per the business requirements and eliminate errors and issues caused due to changes in underlying data

Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Involved in supporting the Business users technically with their monthly Financial Planning, Budgeting and Forecasting

Designed and built KPI’s for business users to determine and track the data transfers

Involved in full development lifecycle of projects using the BI tools like Cognos reporting, Framework Manager, Tableau and Informatica for ETL.

Worked on a POC for Senturus BI connector to Tableau, ran test cases by connecting Framework Manager to tableau.

Got trained and attended workshops on Alteryx for data blending and data prep and connecting the data to Tableau

Scheduled data refresh on Tableau Server for weekly and monthly increments to ensure that the views and dashboards were displaying the most recent data accurately.

The responsibly included to be the Business Systems Analyst for Financial Data Warehouse

Understanding the Business functions, analysing the requirements, defining proper scope for the project, preparing technical and functional documents.

Involved in ensuring operations, controls and support for the Business

Monitoring the existing developed applications, test the performance of various Data Engines.

Researched, attended several workshops and implemented In-memory applications/tools to give a faster and high performed data load results

Involved in enhancing the business requirements and analysing data from the DB2 Warehouse and the SAP source ERP system for designing, developing, testing, production rollover of reporting and analysis projects within Tableau Desktop.

Ensured better Team foundation in Microsoft Team Foundation Server, and followed agile methodology with Scrum Boards and Dashboards to track and monitor the progress of project, removing road blocks and accomplished successful sprints.

Designed a SharePoint site and developed workflows in Nintex to improve working relationship between IT Team and Business Users

Involved in weekly reconciliation of Data Warehouse with the ERP system to ensure successful ETL process

Environment: Tableau Desktop, Tableau server, SQL Server 2012, IBM DB2, MS Access, Advanced Query tools, Windows 2007 server, MS Office 2007, Alteryx, Senturus BI connector, SharePoint, Nintex workflows

Illumina April 2014 – August 2015

San Diego, CA

Tableau BI Developer/ Data Analyst

Responsibilities

Interacted with business users and performed Gap Analysis of Client requirements.

Involved in reviewing business requirements and analyzing data sources form Excel/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.

Responsible for upgrading the Tableau 8.3 to Tableau 9.0.3.

Setup Distributed server system (configure Tableau Server to include worker machines along with the Primary)

Written complex common table expressions to blend data and connected it to the Tableau data source

Worked closely with business power users to create reports/complex dashboards.

Effectively used data blending, filters, actions, and Hierarchies feature in tableau.

Created interactive dashboards by combining views and reports in Tableau Desktop

Created users using Tableau Admin and assigning privileges to create report/publishing reports to server.

Tuned the reports performance using Cache options/ Timely refreshes of data.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Responsible for creating /delivering monthly reports to business users.

Environment: Windows Server 2012, Tableau Desktop 9.0.3/8.3/8.2/8.0, Tableau Server, SQL Server 2008/2012, PL/SQL, MS-Access, MS Excel

AIG, New York City, NY January 2013 - February 2014

Tableau Developer & Cognos Developer / Business Analyst

Responsibilities

Developed complex reports using cognos report studio.

Created Framework Manager Model for the gathered requirements.

Performed end to end testing on reports.

Performed extensive testing on Cognos upgrade from 8.4 to 10.1

Developed Relational and Dimensional Models for reporting using Framework Manager.

Designed the framework for the report and developed dashboards using report studio

Analysed requirements for various reports, dashboards, scorecards and created proof of concept / prototype for the same using Tableau desktop.

Creating, publishing customized interactive reports and dashboards

Extensive use of data blending, filters, parameters, sets, groups etc., with best practices

Knowledge on installation, configuration, procurement assessment, machine uplifts.

Defined best practices for Tableau report development.

Mentored business power users to create reports/dashboards using tableau desktop.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

Published developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Responsible to facilitate load testing and benchmarking the load time of dashboards.

Environment: Windows Server 2012, Tableau Desktop 8.2/8.0, Tableau Server, Cognos, Oracle 9, IBM DB2.

Anthem Jan 2012 - December 2012

Atlanta, GA

Tableau / Cognos BI Analyst

Responsibilities:

Developed dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

Used Data Blending, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Integrated the tableau reports to SharePoint portals.

Created extracts and published to tableau server and also created schedule to refresh it.

Administered users, user groups and provided security within tableau portal.

Developed cognos Active Reports for Human Resource project.

Developed multi-dimensional cubes using transformer ad published cubes for analysis.

Designed complex reports using report studio and performed UAT.

Environment: Cognos 8.4, Tableau desktop, Oracle 11i, DB2, TOAD, Windows XP

HSBC Oct 2010 - Dec 2011

Chicago, IL

Cognos Developer

Responsibilities:

Mainly involved in interacting with the business users and gathering requirements, report design, report development, and support of all client/server layers and components of the data warehouse.

Involved building Multi-Dimensional Models (DMR) with Relational Data using Framework Manager, designed models and deployed Packages to the Report Servers.

Created new Query Subjects and arranged in different folder structure for Business View and also manually created the query subjects using the complex SQL.

Framework Manager Techniques were used to develop the models, implementing the logics which included joins, union, and multiple filters, within the Framework for the ad-hoc reporting to the end users

Moreover, trained the end users on how to use the reporting tool, which included building and customizing the ad-hoc reports.

Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.

Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model

Involved in developing List, cross tab, drill through, master-detail, conditional blocks, chart and complex reports which involved Multiple Prompts in Report Studio and report bursting

Also had to develop the new dashboard right from the start, which included gathering the requirements from end user and implemented and delivered in a time

Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.

Scheduled and Distributed Reports through Schedule Management in Cognos Connection.

Data is moved from one data source to another by using SSIS. Created Star Schemas using SSIS packages.

Obtained experience in Deploying reports, cubes and packages from Development to Production environment.

Customized Reports by writing complex custom SQL, XML,HTML, JAVASCRIPT

Worked with the Data analysis, development, SQL performance tuning, data warehousing ETL process, data conversions and user documentation.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio, Cognos Connection)

Contact this candidate