SUMMARY

• Over 6+ years of experience as BI Developer which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining application.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering / Analysis, Design, Development, Testing and Production rollover.
• Extensively involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Expert in Tableau Desktop and Server Administration and version upgrades activities.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher - level data analysis and data management services.
• Handled Tableau POC activities to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to help them make effective business decisions.
• Exeperience in P2P.
• Enforced Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Improved Reports performance in tableau using extracts and context filters.
• Expert in Tableau Desktop for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie and Bar Charts, Page Trails and Density Chart.
• Expert in creating Calculations (Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Experience in developing Data marts like Snowflake & Star schema
• Expertise in understanding dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• 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.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
• 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.

TECHNICAL SKILLS

BI Tools: Tableau, Microstrategy, Web-Intelligence, Report Conversion tool, Desktop-Intelligence, Import wizard, Microstrategy.

ETL Tools: Informatica, Microsoft SQL Server Integrated Services.

Databases: SQL Server, Oracle, MS-Access, DB2, Teradata.

Scripting Languages: C, C++, HTML, SQL, PL/SQL and XML.

Data modeling: Power Designer, Erwin, ER Studio, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Tableau Developer

Responsibilities:

• Involved in gathering and analyzing business requirements from clients and end users.
• Making use of dynamic connection to extract data from several servers for the creation of Dashboards in Tableau
• Working closely with Customer Service to understand their need for TableauDashboard.
• Performance Tuning of Tableau Dashboards to work effectively.
• Formatting of TableauWorksheets for better look and feel as per the requirements.
• Publishing the new Reports on TableauServer.
• Created Tableau scorecards, dashboards, heat maps using show me functionality.
• Developed the presales dashboard with the tableaudesktop advanced functionalities such as conditional color coding, conditional display, sheets swapping, and reports swap, common base analysis, dynamic hierarchy, Top-N analysis, and secondary tableaucalculations.
• Working with various products of tableausuch as tableaudesktop, tableaureader and tableau server\site.
• Generation of Tableauextracts and implementation of different calculations, visualizations in the tableaulay out design.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Expertise in creating sets, joins, bins and calculated measures.
• Strong understanding of data warehouse concepts, ETL, star schema, snowflake, data modeling experience using normalization, business process analysis, reengineering, dimensional data modeling, fact and dimensions tables, physical and logical data modeling.
• Experience in implementing data blending, replace references, customized queries and advanced visualizations in tableau.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Team player and self-starter with good communication skills and ability to work independently and as a part of the team. Experience in working with big projects.

Environment: Tableau Desktop 8.2, 8.3, Tableau server/Administrator, oracle DB2, Hadoop, MS SQL Server.

Confidential, Charlotte, NC

Tableau Consultant.

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Report Development Documents.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Worked closely with business 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.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views Confidential once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Make use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in mobile devices like IPADS.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Desktop 8.1, 8.2, Tableau server/Administrator, SQL developer. Business Objects, SQL, PL/SQL, MS Project.

Confidential, ATLANTA, GA

Tableau Developer

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).
• Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.
• 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 trainings 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.
• 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.
• 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/7.0, Tableau server / Administrator, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

• Involved in the gathering of business requirements and translating them to the report specifications for the conversion of Actuate Reports to Tableau platform.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• 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.
• 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.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views Confidential once.
• 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.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Created Test Cases and documented the Test Results.
• Responsible for designing of the Imports and Exports module for the sales and purchase orders of the products and was also involved in deployment of the whole project.
• Requirements gathering and analysis from Business users.
• Reports built with extensive use of Set Analysis to have multi facet analysis of data.
• Process follow ups and sanity checks on deliverables for production deployment.
• Overridden various methods like On Read, Fetch, Start, Obtain Select and On Rowto get the right functionality.
• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls
• Created configuration files to include the libraries ROL in the Actuate reports.
• Converting existing MS Access/ Spreadsheet Reports to Actuate e.Reports
• Write java code for running the actuate reports using IDAPI (information Delivery API) calls provided by Actuate.

Environment: Oracle, Tableau Server 6.1, Tableau Desktop 6.1 Business Objects from 6.5 /3.1 RUP Methodology, MS VISIO, MS Project.

Confidential

SQL Developer

Responsibilities:

• Involved in installing and configuring the SQL server.
• Participated to gather requirements and converting them into database related modules.
• Analyze and debug existing complex store procedures.
• Created DML and DDL statements, tables, view, store procedures, triggers, functions etc.
• Comprehensively used joins, subqueries, complex queries to generate the reports.
• Helped team lead for backup and recovery of database.
• Scheduled daily and weekly jobs and alerts through SQL server agent.
• Designed new SSIS packages and modified existing SSIS packages, deployed SSIS packages using various sources for ETL load.
• Created multidimensional reports using SSRS and SSAS.
• Developed and modified existing OLAP cubes for better performance using ETL tool.
• Generated ad-hoc reports for higher management level using SSRS.
• Worked closely with data warehouse team to deliver best Business Intelligence solutions.

Environment: Windows Server 2003, SQL Server 2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.