SUMMARY:

• 8 years of Experience in analysis, design and development of reports using Tableau, Oracle SQL, PL/SQL and Data analysis.
• 4 years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Involved in Tableau Server Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc.,
• Experience working in various industry sectors such as Health care, Retail and Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Utilized all Tableau tools including Tableau Desktop, Tableau Public and Tableau Reader.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Created and maintained various reporting dashboards to consolidate multiple views for internal and external purposes.
• Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
• Experienced with creating database triggers, views, packages and stored procedures in PL/SQL and T-SQL.
• Built and expanded reports available for both internal support and external customer/ carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes.
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts.
• Tackle the most difficult of challenges and know how to get to the best solution.
• Excellent communicator - ability to tell a story through data.
• Experience with analysis, data, databases, and business intelligence.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Excellent with Actions and Quick Filters.

TECHNICAL SKILLS:

Reporting tools: Tableau Suite of Tools 9.0, 8.2, 8.1, 8.0, 7, 6, 5.1 includes Desktop, Server, Online and Public and Administration of Tableau Server.

Data modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema modeling, Snowflake modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWI, Oracle Designer and MS Visio.

Database: Teradata14.10/14/13, Oracle-11/10g/9i, MS SQL Server- 2012/2008/2005, DB2, MS Access.

SQL Programming: SQL, TSQL, PL/SQL.

Tools: & Languages: Teradata SQL Assistant, SQL Navigator, SQL Developer, TOAD, HP Quality Center, C#, Java, JavaScript, .NET, HTML, SQL.

PROFESSIONAL EXPERIENCE:

Confidential

Tableau Developer/Administrator

Responsibilities:

• Interacted with business lines to gather the requirements of highly interactive business dashboards and Experience in designing and development of Tableau visualization solutions.
• Created new projects, groups and setting permissions for the user groups on server.
• Worked extensively with Data extracts of excel and Scheduled the extract refresh tasks and troubleshoot various refresh schedule failures.
• Involved in the upgrade of Tableau server to its new version 9.0.5
• Have experience in designing and development of Tableau visualization solutions
• Added new features to the upgraded version of Tableau server by contacting the vendor and adding workbooks provided by the Tableau support.
• Modified the existing dashboard as per the user requirements Used Tableau Desktop for creating different interactive views and dashboards.
• Generated user statistics information for the Projects, workbooks and views on the server for project leaders to provide better understanding and utilization.
• Educated non-technical people to use Tableau for their daily reports by attending an IT Roadshow.
• Involved in creating dashboards and reports in Tableau 8.2 and 9.0.5 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Create, customize and share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards and workbooks from Tableau Desktop to Tableau servers.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Implemented Dimensional Star and Snow-flake models.

Environment: Tableau Desktop 9.3, 9.1, 8.2, Tableau server / Administrator, MS Excel and SQL, Oracle 10g, MS SQL Server 2008.

Confidential, Atlanta, GA

Sr. Tableau Developer/Administrator

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• 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.
• 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 and effectively 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.2 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.

Environment: Tableau Desktop 9.0, 8.2, Tableau server/Administrator, Oracle 10g, MS SQL Server 2005, MS Access, Windows.

Confidential, NY

Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1.
• Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements. Used Tableau Desktop for creating different interactive views and dashboards.
• 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.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 7.0, 6.0, 5.1, Teradata 13, Oracle 10g, Crystal Reports 2008, MS Office Suite.

Confidential

Tableau Consultant

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan from Tableau 6.0 to Tableau 6.1
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill through using Microsoft Reporting Services.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau 6.0, 5.1, Oracle 10g/9i, SQL, PL/SQL, MS Access, SQL Server 2008, DB2, BUSINESS OBJECTS XI 3.1 SP2 (Designer, Info view), MS excel 2000, Unix-sun Solaris 5.11 server.

Confidential

Informatica Developer

Responsibilities:

• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server and Flat files and load to Oracle database as per business requirements.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing and data movement.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Performed unit testing to validate mappings and populate the database.
• Worked with QA Team and provided production support by monitoring the processes.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.1, Erwin, SQL Server, Oracle 10g, UNIX Shell Scripting.

Confidential

Informatica Developer

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
• Worked on Informatica 8.6.1 client tools Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems.
• Designer, Workflow Manager and Workflow Monitor. Involved in design and development of complex ETL mappings.
• Performed Unit testing of the mappings developed & also created Low Level Designs for the mappings.
• Implemented partitioning and bulk loads for loading large volume of data. Developed Mapplets, Worklets and Reusable Transformations for reusability.
• Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts.
• Played a key role in all the testing phases and responsible for production support as well. Involved in development of the Code and executed Unit Test Cases.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: InformaticaPower Center 8.6.1/8.1.1, Oracle 10g, Flat Files, ERWIN, Autosys.