SUMMARY

• 8 years of extensive BI Experience in Enterprise Environment in Tableau 6.0, 7.0, 8.X, 9.X as a potential Developer and Analyst
• 5+ years working with Tableau Report Services document delivery
• Worked on the Dashboard development reports for KPIs for the top management in the giant insurance firm
• Extensive experience with SQL Server and T - SQL in constructing tables, views, triggers, indexes, functions, stored procedures, user profiles, relational database models and data dictionary
• Extracted data from SQL Server into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL
• Used Tableau Desktop for creating different interactive views and Dashboards
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down, Drop down menus with parameterization using Tableau
• Extensive experience in working on trend reports, service provider functionality, sample assessment, online business intelligence and capital markets
• Different data sources used for Dashboards include Oracle, Excel files, data Extracts, Custom sql files
• Performed data cleaning in Tableau using various features like Pivot, filters
• Implemented Tableau Reports in a variety of use cases requiring complex customizations and large data sets
• Skilled in Dimensional Modeling and ability to provide input in model development
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, fact and dimension tables modeling of data
• Familiar with entire software development life cycle (SDLC) and various project methodologies such as Agile and Scrum Methodology
• Effective communicator in both written and verbal and able to effectively interact with all levels of Management
• Excellent project management skills with demonstrated analytical, problem-solving, decision-making skills and the ability to drive results

TECHNICAL SKILLS

Reporting tools: Tableau, Cognos 8.4/8.3/, Report net 1.1

ETL Tools: Datastage 8.0/8.1, Informatica 7x

Languages: C, C++, VB. Net, HTML, XML, Java script

Databases: SQL Server, ORACLE 10g/11g, MS Access, Teradata and OLAP

Tools: Toad, SQL plus, SQL Developer, SQL Loader, IMPORT, EXPORT, Oracle Enterprise Manager, DBA Studio, Net8, FLEXCUBE

Operating System: Windows 10/ 8/7/Vista/XP, UNIX

PROFESSIONAL EXPERIENCE

Tableau Developer

Confidential - Dallas, TX

Responsibilities:

• Gathering user requirements analyzed and designed software solution based on the requirements
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level
• Creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Restricting data for particular users using Row level security and User filters
• Developing Tableau visualizations and dashboards using Tableau Desktop
• Working on Tableau workbooks from multiple data sources using Data Blending
• Providing production support for Tableau users

Environment: Tableau 9.3/8.3/8.2.4 , Oracle 11g database, Sales force, Sql developer 2010, JIRA, Windows Server R122012, Microsoft Excel and Access Database.

Business Objects /Tableau Developer

Confidential - Dallas, TX

Responsibilities:

• Supported Risk Management, Commercial Bank divisions of Chase as a BOBJ/Tableau Developer and Business Systems Analyst; and was involved in all phases of SDLC from data warehouse implementation to Business Intelligence report creation using BOBJ and dashboard development by creating data visualizations in Tableau 8.1.
• Involved in report and dashboard requirement gathering from the end users to define accurate requirements
• Good understanding of the customer business and implementing the same over to the reporting needs
• Implemented new universes using IDT and modified existing ones according to requirements and performed cardinality checks, resolving traps, using contexts, aggregate awareness, hierarchies and derived tables
• Performed report/universe optimizations in greatly reducing the run time of reports
• Created complex Web reports with multiple queries, custom sql, complex functions, merge dimensions, drilldown/up/across/through and complex filters
• Performed Admin tasks such as monitoring DB services, BO Server running with optimal performance, monitoring licenses, monitoring user activity/sessions, consulting SAP to define bugs in patches
• Migrated reports/universes from Dev to QA to Prod using import wizard
• 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
• Helped in testing and impact assessment on dashboards with changes to the data warehouse
• Created test documents that help in validating reports and dashboards in QA.
• Utilized Knowledge Link of Capital One to create and update logs for project maintenance.

Environment: SAP Business Objects BI 4.0 (CMC, Information Design Tool (IDT), Web I), Tableau 7.0/8.1 Server and Desktop, Oracle 10g and 11g, SQL Server 2012, Teradata, SQL/PLSQL, Windows Server/ professional, VISIO.

Tableau developer

Confidential - Erie, PA

Responsibilities:

• Participated in requirements gathering and translate business requirements into report visualization specifications design documents
• Created different views in workbook to visually analyze the data
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization
• Created many Dashboard reports for company's decision making purpose and made them Key Performance Indicators (KPI)
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Restricted data for particular users using Row level security and User filters
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Developed Tableau workbooks from multiple data sources using Data Blending
• Provided 24/7 production support for Tableau users

Environment: Tableau 8.3, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.

Sr. Oracle Developer

Confidential

Responsibilities:

• Designed Technical dashboard document using tableau desktop based on the business requirements
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Data blending implemented on Oracle database and generated interactive dashboards
• Generated tableau dashboards with combination worksheets for clear understanding
• Performed Tableau Admin related activities like Tableau Server installation, backup, upgrades performance tuning
• Created users, groups, security roles and SSL authentications
• Performance tuning of DB and Tableau Server, data sources, workbooks and extracts
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application
• Handled Tableau admin activities granting access, managing extracts and Installations

Environment: Tableau Desktop 8.1, Tableau Server, Oracle 11g, SharePoint

SQL Developer

Confidential

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures, packages and the necessary insight into the data
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX