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 administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user 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 Business users through online and in-class sessions.
• Administered user, user 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, al, Banking and Financial Service Domains and ability to analyze big data
• 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.
• Extensivelyworked on databases likeOracle, SQL Server, DB2, and Teradata. Strong programming and debugging skills inPL/SQL, SQL and UNIX shell scripting.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.

TECHNICAL SKILLS:

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

Reporting Tools: Tableau, Qlickview, 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:

Confidential, San Francisco, California

Tableau Developer/ BI Consultant

Responsibilities:

• Experience in designing 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 user 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 andeffectively 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 users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user 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.

Environment: Tableau Desktop 8.1, Tableau server / Administrator, Hyperion IR, SQL developer.

Confidential

Tableau Developer

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 usingTableauserver.
• 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 uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users 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.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, SQL developer, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, NJ

Qlikview Developer/ BI Consultant

Responsibilities:

• QlikView designing and modelingusing multiple data sources relational designs.
• Designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Involved in Performance tuning at database level, Script level and Application level.
• QlikView Administration - Creating scheduled jobs for QVD extracts and report plus reloads.
• Gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and Subject matter Experts (SMEs).
• Converted the huge tables into multiple QVDs, so that only the recent ones needed to be refreshed for data accuracy.
• Involved in the developing of star schema and snow flex schema dimensional data model.
• Developed KPI’s and set analysis applications.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.
• Done Optimization of the QlikView Application by removing unnecessary fields, avoiding complex joins, avoiding date functions, avoiding conditional functions inside the application using mapping load.
• Follow a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensures that critical requirements are not missed.

Environment: QlikView, Oracle 10g, SQL Server, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Confidential

QlikView Developer/BI Consultant

Responsibilities:

• 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 user 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 User 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 user build specifications and Customized QlikView reports to interact with Hyperion IR.

Environment: QlikView, Oracle 10g, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Pl/Sql Developer

Responsibilities:

• 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 & 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.