SUMMARY:

• A Senior IT Professional with good working experience in IT industry as BI Developer, Tools expert including Tableau Developer, Tableau Admin, QlikView with strong background in Databases and Data warehousing concepts.
• Over 3 years working on Tableau 7.0 to 8.1, Tableau Desktop, Tableau Server
• Involved in creating Dashboards using Tableau Desktop, Tableau Server, and Business objects.
• Worked closely with Business during conversion of Business objects reports and dashboards to tableau.
• Created incremental refreshes for data sources on Tableau server.
• Experience in Installation, Configuration and administration 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-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).
• Used data Zen and tableau to implement flexible views of dashboard
• 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.
• Extensively worked on databases like Oracle, SQL Server, and DB2. Strong programing and debugging skills in PL/SQL.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Created relationship between two different Data Source's by using Data- blending.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tab CMD and Tableau server backup activity.
• Improved Reports performance in tableau using extracts and context filters.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills

TECHNICAL SKILLS:

Reporting tools: Tableau 8.0,8.1 Tableau Desktop, Tableau Server, Tableau Admin, Qlick view

Business Analysis: Requirement analysis, business rules, data flow diagram, flowcharts, business process modeling & improvement, functional requirement Analysis, source to target mappings, gap analysis, cause and effect analysis, decision tree.

Software Packages/ Processes Model Tools: MS Office Suite 9X/2000/XP (PowerPoint, Word, Excel, Access, and Outlook), Novell GroupWise, Banner, Lotus Notes, MS Outlook, MS Project, MS Visio, Rational Rose; Rational Requisite Pro, Business Objects 6.5, Borland

Methodologies: Test Director, Mercury, Silk Testing, Win Runner and Load Runner

Office Suite: MS Office, MS Excel, MS Word, MS Visio, Star Office, Open Office

Databases: Oracle 10g/9i/8i/8.0/7.0, Sybase 12.x/11.x, Disaster recovery, MS Access 7.0/2000, Erwin 3.5/3.x, SQL, XML, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000 and Sun Solaris 2.x.

Operating Systems: WIN XP, WIN 2000, Windows NT 4.0, Linux, Unix

Data modeling: ER Diagrams, Conceptual, Logical & physical modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Senior Tableau Developer/Admin

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in analysis of Key Performance Indicators (KPI's) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting s to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Extensively used Tab Admin and Tab CMD commands in creating backups and restoring backups of Tableau repository.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Environment: Tableau Desktop 8.0, 8.1, 8.2, Tableau Server, Tableau Admin, SQL Server, T-SQL, SQL Server Management Studio, Microsoft Excel

Confidential

Senior Tableau Developer/Admin

Responsibilities:

• Developed various dashboards illustrating data visualizations using Tableau Desktop
• Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different data sources.
• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Extensively used Tab Admin and Tab CMD commands in creating backups and restoring backups of Tableau repository.
• Worked on Data Zen and had a good knowledge in creating the dashboard which best suites the requirement.
• Understanding of relational database structures, theories, principles, and practices.
• Monitored VIZQL server, Application Server and Tableau Data server activity to track performance and system availability
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, and SQL Server 2008.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA's with Tableau support.
• Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.

Environment: Tableau Desktop 8.0,8.1,8.2, Tableau server, Tableau Admin, Oracle SQL developer, SQL Server 2008, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007

Confidential, Houston, TX

SQL Server/BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user .
• Involved in Physical / Logical design of database, creating and managing the database and all the Database objects.
• Designed and developed forms using Visual Basic with ODBC.
• Designed and developed reports using Crystal Reports.
• Developed E-R diagrams (logical and physical using Erwin) mapping the data into database objects.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance
• To understand the source system & the reports currently in use. Talking extensively with the customer and business users to know their requirements.
• To prepare the detailed Requirement Analysis document for the reports.
• Updated the existing universe for end users adhoc analysis by adding new dimensions and measures.
• Worked with business analyst to refine the report requirements.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms/reportsfor various modules. Createddatabases, loaded initialization data, generated users, and assigned roles.
• Worked on Tableau trial version, like creating reports using SQL, plotting the charts and analyzing the data.

Environment: Tableau, SQL Server 2005, T-SQL, XML, Windows 2000 Server, Erwin, PL/SQL, ODBC.

Confidential

SQL Server/BI Developer

Responsibilities:

• Analyzed the source system, application and Requirements and have prepared understanding documents
• Communicated with the Clientsto get the Requirements in a clear understandable way
• Developed reports based on requirements
• Developed complex SQL stored procedures to run the reports
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, cursors and Indexes using T-SQL.
• Created jobs using MSBI Packages and executed the same
• Experience in Data Conversion andData Migration using MSBI and MSBI services across different databases like Oracle, MS access and flat files.
• Expert in creatingParameterized Reports.
• Handled Configuration Management in the project
• Handled Projects processes like metrics collection, effort tracking and senior management reporting
• Prepared status reports like daily status report and Weekly status report for the project for the Reporting Module

Environment: SSRS, MSBI, TFS, SQL Server 2005, T-SQL, XML, Windows 2000 Server

Confidential

SQL Server/BI Developer

Responsibilities:

• Performed creation, manipulation and support for SQL Server databases.
• Involved in creation of tables, indexes, sequences, constraints, functions, triggers, views and joins.
• Helped in integration of the front end with the SQL server backend.
• Created triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL server, and also wrote stored procedures for application developers.
• Planned the complete backing up of database and restored the database from disaster recovery.
• Designed logical and physical data models using Erwin.
• Involved in migration of data (Import & Export of data) from one server to other servers using tools like data transformation services (DTS).
• Written complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of TSQL queries.
• According to the business requirements made the documentation of the performed tasks.
• Extensively used SQL profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler, Erwin, T-SQL, XML.