234991975-ranadheer-tableau-resume.doc 56131y

RANA Sr. Tableau Developer/ Data Analyst [email protected] 469-338-4542 PROFESSIONAL SUMMARY:  7+ years of working experience in IT industry as BI Developer, Tools including Tableau, QlikView and Hyperion with strong background in Databases and Data warehousing concepts.  Involved in creating Dashboards using Tableau Desktop, Tableau Server, Qlikview and Hyperion IR.  Converted Dashboards and reports from Hyperion 8.3.2 to Tableau 8.1  Worked closely with Business during conversion of Hyperion reports and dashboards to Tableau.  Created incremental refreshes for data sources on Tableau server.  Experience in Installation, Configuration and istration of Tableau Server in a multi-server and multi-tier environment.  Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End- and help them make effective business decisions.  Created Dashboard’s using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.  Experience in training Business s through online and in-class sessions.  istered , groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau7.0 to 8.1).  Excellent understanding of concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Teradata, MS Access and client/server applications.  Having 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.  Having strong analytical, logical, Communication and problem solving skills. Ability to adapt to new technologies by self-learning.  Experience in Insurance, Educational, Banking and Financial Service Domains and ability to analyze big data.  Extensively involved in the ETL layer development and knowledge on Cognita and Platfora.  Knowledge of QlikView, Hyperion, and OBIEE reporting tools. Supervised Vizql and WGSQL processes to test the system stability and performance.  Ability to work independently, excellent communication and strong team-building management skills.  Good knowledge on Data Quality Assessment & Data Cleaner Tool, Data Model Creation. Written SQL queries to test the OLTP & OLAP Databases based on changes of the functionality.

    

Knowledge on SSAS/SSIS and Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements. Extensively worked on databases like Oracle, SQL Server, DB2, and Teradata. Strong programming and debugging skills in PL/SQL, SQL and UNIX shell scripting. Expertise in writing SQL Queries, Dynamic-queries, and complex s for generating Complex Stored Procedures, -defined Functions, Views, Cursors and Triggers. Had an experience in leading a small team and Knowledge in Medical Information domain ( Health Insurance and Clinical Data concepts and terminology). Involved in requirement gathering from through meetings, understanding the business from end and technical perspective.

TECHNICAL SKILLS: ETL Tools

IBM Info Sphere / Web Sphere Datastage 8.5 /8.1/8.0 /7.5 (Designer, Director, and ), Info Sphere

Reporting Tools

Qlickview, Tableau, Hyperian IR, OBIEE

Database

Teradata, MS SQL Server 2005/2000, DB2, Oracle

Languages

SQL, PL/SQL, UNIX Shell Script, PERL, Teradata-BTEQ, TPT

Data Modeling Tools

Erwin 4.0/3.5, Star Schema, Snowflake Schema, OLAP, OLTP

Tools

TOAD, WinSQL, MS Office, Autosys, SQL*Plus, SQL*Loader

Operating Systems

Windows NT, UNIX

Professional Experience: Client: Cigna / ADI Strategies San Francisco, California

Jan 2013 to June2014

Tableau Developer/ Data Analyst Project is to Convert Hyperion IR 8.3.2 to Tableau 8.1 Developed New and Converted Hyperion Reports and Dashboards to Tableau in multiple Business areas like Claims, Policy and Billing, which helped the management to make better decisions. Dashboards/Score card was provided as the interface to run reports at various levels (summary/Detail reports/Snap shot of inventory calls) and show different views like Reports, pivots and charts. Converted Agent Reports and Dashboards to Tableau.

Responsibilities:  

               

Experience in deg and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's. Gathered requirements, analyzed and designed software solution based on the requirements. Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets. Defined best practices for Tableau report development and effectively used data blending feature in tableau. Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet. Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop. Creating s, groups, projects, Data connections, settings as a tableau . Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, activity, and customized views on Server Analysis. Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives. Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently. Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended. Had an experience in leading a small team and Knowledge in Medical Information domain ( Health Insurance and Clinical Data concepts and terminology). Having a experience with Big Data .

Environment: Tableau Desktop 8.1, Tableau server / , Hyperion IR, SQL developer. Client: Eastern New Mexico University NM

Aug 2011 to Jan 2013

Tableau Developer/ Data Analyst Worked in FUND Reporting Unit, which are used by Major Gifts Officers, Annual Fund Officers, Planned Giving Officers, and other management development staff to monitor the Fundraising progress to date, so that fundraising efforts can be analyzed in a uniformed manner across the university. Designed and developed complex Dashboards, Pivots, Reports, Charts and Data models using Tableau Designer. Published Dashboards on Tableau Server for the community to access through Web Portal. Responsibilities:  Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.  Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.  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 ed tableau dashboards on to server and provided production for tableau s.  Ability to work quickly and under tight delivery deadlines with focus on details.  Hands-on development assisting s 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.  Having experience in SME (Subject Matter Expert) in all BI tools. Environment: Tableau Desktop 8.0/7.0, Tableau server / , SQL developer, SSAS/SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access , Windows 2007 server, Microsoft office 2007. Client: CIT Group NJ Tableau Developer/ Data Analyst

Aug 2010 to July 2011

Risk Management Project: The role of this project is to CIT’s strategic goals and initiatives through identification, quantification and management of all types of risk throughout the organization. This project involves development of Qlikview dashboards for different categories of risk such as enterprise risk, Credit Risk, Policy Governance & Regulatory risk and Loan risk consolidating the relevant data in interactive way. Responsibilities  Involved in creating dashboards and reports in Tableau 6.1  Created report schedules on Tableau server  istered , groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1  Involved in requirements gathering, analysis, design, development, change management, Developed backup restore scripts for SQL Server as needed  Created tables, triggers and indexes for enforcing business rules  Wrote Complex Stored Procedures as well as analyzed and debugged existing complex stored procedures  Migrated SQL Server 2005 Database objects to SQL Server 2008  Implemented Triggers for checking complex business conditions, providing security for the tables.  Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.  Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.  Designed and implemented data access stored procedures and triggers for automating tasks. Job scheduling and alerts.  Designed SSIS packages to load data from CSV and excel files to the Staging Area in SQL server  Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package  Implemented Event Handlers and Error Handling in SSIS packages  Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio Environment: Tableau Server 6.1, Tableau Desktop 6.1Microsoft SQL Server 2008, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Excel, MS Word, SQL profiler, Windows. Lorven Consulting, Inc. May 2009 – June2010 QlikView Developer/BI Consultant  Extracted the data from various data sources such as databases, CSV files, and Excel documents transforming the data into standard format (QVDs) and load the data so that it is available for analyzing and creating reports.  Designed Schema using dimensions, fact, logical, physical, alias and extension tables.



Developed QlikView scripts to load the transformations and make enhancements to the interface of the desktop application.  Installed and configured QlikView 9.0. Assisted in upgrading from QlikView 8.2 to version 9.0.  Application processed tables with over 10 million records. Experience in scripting QlikView Set Analysis and Macros.  Eliminated synthetic keys using QVD concatenation and by renaming the fields.  Wrote scripts and created batch files for automatic running of QlikView scripts.  Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.  Designed interface and prepared layouts for the system using QlikView.  Involved in the developing of star schema and snow flex schema dimensional data model.  Used MS Access and QlikView extensively as reporting tools and to create build specifications and customized QlikView reports to interact with Hyperion IR. Environment: QlikView, Oracle 10g, PL/SQL, SQL*Plus, SQL Developer, MS Access. Lorven Consulting, Inc. April 2007-April 2009 PL/SQL Developer  Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.  Designed Web-based Internet applications linked to firm-wide SQL databases.  Creating and 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 analysis, coding, testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.  Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL* Loader to custom tables.  Worked on materialized views, DBMS_SCHEDULER for scheduling jobs and UTL_MAIL to send mails using oracle 10g.  Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.  Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.  Used Oracle Enterprise Manager, TOAD for developing and managing PL/SQL scripts. Environment: Oracle 10g, Pl/SQL, SQL *Plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, MS Excel, SQL*Navigator, Power Builder, Shell scripting