SUMMARY

• Around 7 years of extensive experience in IT with full System Analysis & Design, Development, Administration, Integration, Implementation, Performance Tuning and Maintenance of Business Intelligence and the related Database Platforms.
• 5 years of extensive Tableau Experience in Tableau 8.x/9.x /10.x (Desktop, Server, Reader) as a Developer and Analyst.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• End to end experience in designing and deploying data visualizations using Tableau.
• Applied different filters like normal filters, quick filters, context filters, sharing filters, and use as filters, user filters.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report.
• Expertise in designing and development of various dashboards, reports utilizingvarious TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters as per the business/client requirement.
• Experience in configuring reports from different data sources using data blending
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Worked on various heterogeneous sources like Oracle, SQL, XML files etc.
• Experience in Performance tuning of targets, sources, mappings, and sessions.
• Worked with development teams and database administration staff to enhance database and application performance.
• Proficient Star Schema dimensional modeling, which include understanding business processes, modeling dimensions, hierarchies and facts.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Excellent understanding of relational database concepts and dimensional modeling techniques, Star and Snow-flake schema.
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Experienced inTableauServer administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Experience working in a matrix environment and expertise in delivery processes such as Agile and waterfall.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop v8.x/v9.x/v10.x, Tableau Server v6.x/v7.x/v8.x, Tableau Online v9.x, Crystal reports XI/2008, BO Web intelligence

Databases: Teradata, MySQL, MS SQL Server, Hive, ORACLE, MS Access, Amazon Redshift.

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, JIRA

Programming Languages: SQL, PL/SQL, HTML, Java/J2EE, ASP.net, C#

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project.

Operating System: MAC, Windows XP/7/8/10

PROFESSIONAL EXPERIENCE

Sr. Tableau Developer/Admin

Confidential, NJ

Responsibilities:

• Extensive experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau Desktop using various sources such as Oracle.
• 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.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created stories in Tableau using Story functionality.
• Responsible for developing Dashboards and preparing ad-Hoc Reporting.

Environment: Tableau Desktop10.x,9.x, Tableau server, Oracle 11g & 12c, MS Access.

Tableau Admin/Developer

Confidential, Portland, OR

Responsibilities:

• Work with internal management and team members to understand and clarify reporting requirements / needs.
• Collaborated with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Embedded Tableau reports/dashboards on to the external web pages.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Actively involved in the creation of users, groups, projects, workbooks, and the appropriate permission sets for Tableau server logins.
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.

Environment: Tableau (Desktop/Server), Teradata, MS SQL Server, SQL, Teradata SQL Assistant, Java API, Putty, UNIX, Microsoft (Word, Access, Excel, Outlook).

Tableau Admin/Developer

Confidential, Oakland, CA

Responsibilities:

• Worked closely with project Business Analyst, Data Architect and ETL Developer to ensure that the end to end designs meet the business data requirements.
• Involved in performing extensive GAP as there were numerous 'As-Is' and 'To-Be' conditions in the project.
• Published customized interactive reports and dashboards to Tableauserver.
• Extracted data from various sources like SQL Server, data files, Oracle by the use of data blending and joins.
• Translating business requirements into Business Object Reports and Dashboard design -Communicated with stakeholders, business groups as well as participated in meetings and user group discussions.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating New Schedule's and checking the task's daily on the server.
• Defined best practices for Tableaureport development.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Modifying and creating Interactive Dashboards Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Deep understanding of relational database structures, theories, principles, and practices.
• Responsible in generating dashboards with quick filters, parameter and sets to handle views more efficiently.
• Managing Production, Test and Development environments including installation of patches, security administration and access controls inTableau.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau8 desktop/Server.
• Creating navigation pages such as Table of Contents (TOC) which had all the links to various reports.
• Assisting users with questions and issues using Tableau.
• Checking the task's on the server daily and creating New Schedule's.
• Maintaining the data efficiently by defining it with T-SQL database objects such as tables, joins, views, triggers, procedures, functions.
• Provided 24/7 production support for Tableauusers.
• Deep experience with the design and development of Tableau visualization solutions.
• Coordinated with Clients for feasibility study of the project in Tableauand drawing up the timelines as per project requirement.
• Extensive experience with the design and development ofTableauvisualization solutions.

Environment: TableauDesktop 9.0/8.3, Oracle10g/9i, Crystal Reports, SQL Server 2008/2012, MS Visio, MS Excel.

Tableau Developer

Confidential, Cleveland, OH

Responsibilities:

• Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
• Created dashboards for the clients to measure performance of their services and financial management.
• Created views and dashboards on end client's sales data. Produced powerful dashboards telling story behind the data in an easy way to understand format such as pie, bar, geo, and line charts.
• Developed Scatter Plots and Area Maps to show investment/ROI by states.
• Developed Geo/Area Maps to show Finance details by states.
• Created Shared data sources for the users.
• Installed and Configured Tableau 8.0 on multiple environments.
• Verified the runtime user permissions on the Database.
• Design, develop and support complex performance and capacity charts and reports using Tableau Tool.
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Created calculations this includes from basic arithmetic calculations to complex Mathematic calculations.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important projects & business stakeholders throughout the project life cycle.

Environment: Tableau Software 8.0, 9.0, Microsoft office, SQL Server 2008.

Tableau Developer

Confidential, ATL, GA

Responsibilities:

• Extracted & analyzed the data from EPIC and used Tableau for creation of Cost Saving Analysis visuals across numerous business dimensions and deducted the total savings possible.
• Analyzed various spend trends over time and researched the various data anomalies and the specifics.
• Designed various business metrics such as avg Cost per Case, avg Cost per Item, Cost per Case Analysis, case counts etc. to measure business performance.
• Mapped the various expense factors for surgeries such as HIP & KNEE Replacement, Cataract & Analyzed cost by comparing surgeons, Medical Centers, Surgery Items and found out the possible savings.
• Met with various SME's, Surgeons, Regional Managers for data categorization & data quality enrichment.
• Wrote numerous SQL queries involving joins, unions and views for data extraction and data cleansing before analysis.
• Performed the data quality checks by writing SQL queries and validated report counts.
• Presented the visuals and assisted the management for taking the appropriate business measures
• Took active part with the DBA's in creation of materialized views used for Tableau data extracts.
• Prepared Quarterly Analysis and examined whether the cost savings actually happened as per earlier analysis outcome.
• Created V lookups, Pivots for extensive data analysis in Microsoft Excell.
• Created various Reports for Daily, Weekly, Monthly Reports featuring: Supply Chain Inventory Reports, Surgery Cost Reports by Medical Centers, Vendor Cost Analysis Reports etc.

Environment: Tableau Desktop 8.0, Tableau server, SQL developer, SQL 2012,Oracle 11g, JavaScript API, Microsoft Excel, MS Access.

Tableau / SQL DEVELOPER

Confidential

Responsibilities:

• 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.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to- date live data and sent those into production after editing.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server), Oracle, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIOControl-M, Erwin, Teradata SQL Assistant, Teradata Administrator, IMS, SQL, Share Point, Agile-Scrum, Autosys

PL/SQL Developer

Confidential

Responsibilities:

• Worked as developer of a team, responsible for the design and development of an ORACLE application.
• Primary responsibilities include - system analysis, coding, debugging and deploying.
• Worked with the project manager to understand the scope of each phase & module and further understand & implement the Object Model & Database design specifications, Domain Model.
• Framing the business logic plus code for accessing data stores.
• Documented all changes throughout the development of the database.
• Develop validation routines for complex business rules and data handling.
• Created numerous forms and reports using Forms and Oracle Reports.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Extracted, transformed, and loaded to integrate data from data source to operational data store, data warehouse and data market.
• Worked with business users in requirements gathering and data analysis.
• Designed, developed and maintained ETL data integration process with BI and IT team.
• Developed business development strategy for new business opportunities
• Designed and maintained all databases required for development and production environment
• Analyzed business unit's performance & compared the performance with the projections
• Assisted the DBA with creating partition schemes to improve the performance of queries.

Environment: Oracle, SQL*Plus SQL, SQL* Loader, PL/SQL