SUMMARY

• Around 4+ years of Data warehousing experience with Business Intelligence Tableau 9.0/8.0, SAS, OLTP and OLAP Microsoft SQL Server, Microsoft Excel as a Developer.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Expertise in developing the Reports, Dashboards, resolving Performance issues and implementing best practices usingTableau.
• TableauSMEwithstrongexpertise in reports development using various reporting tools like Tableau.
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server
• Installed, configured and administered various Cognos components such as the Cognos BI server,
• Framework Manager, Transformer and Cube Designer.
• Developed and designed various dashboards, reports utilizing Tableau Visualizations 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 according to the end user requirement.
• Created Dashboards using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• Good understanding of business process in Financial, Insurance and Healthcare areas.
• Experience in creating and scheduling extracts and data sources in Tableau.
• Experience in performance tuning of tableau dashboards for better performance.
• Experience in creating complex calculated fields, advanced conditional formatting and using various functions in Tableau.
• Experience is creating different charts in Tableau desktop including donut, control and waterfall charts.
• Involved in creating Dashboards usingTableauDesktop,TableauServer and other BI Tools.
• In-depth knowledge onTableauDesktop,TableauServer andTableauReader.
• Developed the packages in Framework manager and published into theCognosconnection server.
• Experience in designing and developingTableauvisualization solutions and data modeling using Relational databases (RDMS).
• Experience in handling data from various source systems such as Flat files, Oracle, MS Access and Excel files.
• Experience in gathering customer requirements, writing test cases and partnering withdevelopersto ensure full understanding of end requirements.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Triggers, User Defined Functions.
• Experience in Oracle and SQL server development.
• Experience in investigating application defects and providing resolutions.
• Involved in Performance tuning and Data validations.
• Excellent communication skills, problem solving skills and Analytical/Design skills.

TECHNICAL SKILLS

Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2RDBMS

SQL,PL/SQLData Modeling tools: Star Schema Modeling, Snow Flake Modeling

Visualization Tools: Tableau 8.1/8.0/7/0

Other Tools: Toad, Putty, Sub Version, Clear Case Explorer, SAS, OBIEE 10.1.3x/11g

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Tableau Administrator / Developer

Responsibilities:

• Experience in gathering business requirement and translating them into technical specifications and design.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Utilized advance features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Understanding existing business model and customer's new requirements.
• Expertise in creating Tableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports usingTableauDesktop.
• Executed and tested required queries and reports before publishing dashboards.
• Created incremental refreshes for data sources onTableauserver.
• Coordinated database middleware issues with DBA.
• Integration of Tableaureports with Asp.Net web applications and usage of JavaScript API for performance improvement
• Experience in web integration of TableauReports with Asp.Net
• Involved in developing and designing websites on Asp.Net Framework
• Involved in integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports
• Defined and created procedures to installTableaudesktop in silent mode.
• Implemented best practices forTableaureport development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableaurepository.
• Involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings throughout the project life cycle.
• Created workbooks and Dashboards using calculated metrics for different visualization requirements.
• Performed an evaluation of Tableau platform in the enterprise data architecture
• Collected, Analyzed and documented requirements specifications from the users to design a robust implementation plan.
• Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created dashboard views from provider information data to members
• Extensively created visualization dashboards for the claims
• Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Involved in creating dashboards and reports inTableau8.3. Created report schedules onTableau server.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Incorporated a regional and national comparative / benchmark metrics to give context to Horizon performance
• Created extensive custom joins for blending data from several different data sources
• 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
• Created workbooks and Dashboards using calculated metrics for different visualization requirements

Environment: TableauDesktop 8.2,Tableauserver / Administrator, Informatica Power center 9.1, Windows/UNIX, SQL, Unix Shell Scripting, Oracle, ETL.

Confidential, Philadelphia, PA

Tableau Administrator / Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE. This is done to improve Report performance.
• Effectively used data blending feature intableauand defined best practices forTableaureport development.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Access dashboards from any browser or tablet.
• Involved in installation ofTableaudesktop 7.0,Tableauserver Application software
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tabcmd to schedule the report's and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• CreatedTableauscorecards, 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.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
• Deep experience with the design and development ofTableauvisualization solutions.
• Provided 24/7 production support forTableauusers.

Environment: Tableau Desktop 8.0/ 7.0, Oracle10g/9i, Crystal Reports, Spot fire, SQL Server 2008/2012.

Confidential

Tableau Developer

Responsibilities:

• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• 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.
• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Web Intelligence and Deski (Desktop Intelligence) using Business Objects XI R2andR3.
• Develop Ad-hoc Business object reports according to user’s requests.

Environment: Tableau, Tableau server, CrystalReports, Xcelsius, Web Intelligence 4.1/4.0/3.1, MS Excel, SQL Server, HANA DB.

Confidential

Jr. Tableau Developer

Responsibilities:

• Deep experience with the design and development ofTableauvisualization solutions.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Preparing Dashboards using calculations, parameters inTableau.
• Understanding of relational database structures, theories, principles, and practices.
• Installed patches on server and documented upgrade plan formTableau6.0 toTableau6.1
• Built complex formulas inTableaufor various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Organized Error and Event handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers in SSIS.
• Created and assisted users inTableaudashboard development.
• Created SQL Queries for testing thetableauDashboards.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services (SSRS)
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions
• Assist in the problem identification, analysis, design and implementation of development as required. Involved in SSAS cube design and development
• 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: TableauServer 6,TableauDesktop 6, MS SQL Server 2008, Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS, Visual Studio 2010, Windows