SUMMARY

• Over 7 years of IT Experience in Business Intelligence and Data Warehousing applications in Retail, Insurance, Banking, Health Care Industries.
• Expertise in using Tableau 8.1, 8.2, 8.3, 9.0, 9.1(Tableau Desktop and Tableau Server).
• Expertise in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• All - encompassing experience in installation, configuration, upgrade (1, 3 and 5 node server cluster) and administration of Tableau Desktop/Server.
• Extensive experience working with TableauSoftware as a dashboard developer.
• Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Used Performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to improve the end user experience.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized usingTableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked with Different Databases like Teradata, Oracle, Microsoft SQL Server, Microsoft Access databases, Excel Spreadsheet etc.
• Involved in networking with Data Architects in building Views and Table structures for Tableau.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator experience as well as technical support, troubleshooting, report design and monitoring of system usage.
• All-encompassing experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Possess necessary skills to implement Tableau from a scratch and conduct user training and provide support.
• Well-versed in developingreporting applicationsusingCognos 8.4BI components (Framework Manager, Business Insight, Business insight advanced, Report Studio, Query Studio,Analysis Studio, and Cognos Connection).
• Expertise in Report building usingReport studio,Query Studio, andAnalysis Studio.
• Deliveredadvanced/ complex reporting solutionssuch asDashboardsand Standardized Reporting (including theburstingof reports globally) using Cognos. Created complexDashboardswith Area charts, Pie charts, Cross tabs and Multi promptsinReport Studio.
• Strong Inter personal communication skills, Ability to provide appropriate attention to details and effective troubleshooting skills, and ability to work in a team.
• Provided extensiveEnd User TrainingandSupport.

TECHNICAL SKILLS

BI Tools: Tableau (Desktop 7x to 9x, Tableau server and Tableau Online) Cognos 8.4 BI (Report Studio, Query Studio, Analysis Studio, Metric Studio, Transformer). Cognos connection, Frame work Manager, Query studio, Report studio.

ETL Tools: Informatica, Data stage.

Languages: SQL*Plus, PL/SQL, HTML.

Databases: Teradata, ORACLE 9i, 10g, 11g, MS SQL Server 2008/2005, and MS-Access.

OS: MS Windows NT/2003/XP/ME/95/98, Windows 7, Windows 8.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Tableau Developer/BI Consultant

Responsibilities:

• Perform data visualization development using Tableau to create complex, intuitive, innovative dashboards and reports.
• Define, design, construction, integration, testing and support of reliable and reusable software solutions, addressing business opportunities.
• Interpret written business requirement and technical specification documents.
• Create and maintain technical design documentation
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) inTableauDesktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Fine-tuned analytical, diagnostic and troubleshooting skills in quickly identifying root cause of business application issues.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Windows XP,Tableau9.1,TableauServer, Teradata, MS-SQL 2008 R2, MS-Access, MS Excel.

Confidential, Nashville, TN

Tableau Developer

Responsibilities:

• Developed various data connections from data source toTableauServer for report and dashboard development.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• TransformedTableauinto a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.
• Ensured projects were completed on time and within budget.
• Experience in Tableauserver maintenance and Tableauserver backup activity.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Environment Support to User community, Service Request & Resolution.

Environment: Windows XP,Tableau9.0/ 8.1,TableauServer, Teradata, Oracle SQLDeveloper, MS-SQL 2008 R2, MS-Access, MS Excel, oracle 10g.

Confidential, Sunnyvale, CA

Tableau Developer

Responsibilities:

• Worked a great extent with the design and development ofTableauvisualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc. inTableau7.0, 8.0 and 8.1.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across theTableauBI suite.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems.
• Extracted the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input toTableau.
• 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, trend Lines, statistics, and log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Defined best practices forTableaureport development.
• Assisting users in creating and modifying worksheets and Data Visualization dashboards.
• Created incremental refreshes for data sources onTableauserver.
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• InstalledTableauServer 7.0 in Dev, QA, UAT and Prod environments, upgradedTableau7.0 environment toTableau8.0. Defined and created procedures to installTableaudesktop in silent mode.
• DeployedTableauServer in clustered environment by adding worker machines.
• Built Stories in Tableau with various Data points to narrate the data to the end users.
• Provided 24/7 production support forTableauusers and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thruTableaudesktop.
• Worked on generating various dashboards inTableauServer using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Environment: Tableau8.1, 8.0, 7.0,TableauServer/Administrator, Microsoft Excel 2007, 2010, Teradata 13, Oracle 10g.

Confidential, Los Angeles, CA

Reporting Developer - Tableau

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Developed, Organized, managed and maintained graphs, tables and document templates for the efficient creation of reports.
• Mentored otherTableauusers, provided training and novice inTableau.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to TableauServers.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintained the accuracy of the core information content.
• Created visualizations for logistics calculations and departmental spend analysis.
• Used SQL Queries at the custom SQL level to pull the data inTableaudesktop.
• Validated the results inTableauby running SQL queries in Oracle SQLdeveloper.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Createdtableaufunctional design document.
• Performed performance tuning of the dashboard inTableaudesktop.
• Connected tableau server with SharePoint portal and setup auto refresh.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
• Performed Parallel Testing and Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the retrospective meetings and next sprint planning meetings.

Environment: TableauDesktop 7.0/7.0.1,Tableauserver 7.0,7.0.1, OBIEE 11g, Microsoft SQL Server, SharePoint, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Princeton, NJ

Tableau/Cognos Developer

Responsibilities:

• Built, published, customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Involved in Data Visualization development using Tableauto create complex, intuitive, and innovative dashboards.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 6.0.
• Extensively worked on Cognos 8.4 environment.
• Performed the distributed installation and configuration of Cognos 8.4 on new servers in Production, Testing and Development environments.
• Involved in Deploying reports, packages from Development to Production environment.
• Developed Standard Reports, Charts and Master Detail Reports using Report Studio.
• Created Active reports with different data decks and data cards.
• Create additional reports on an ad-hoc basis as requested by business users.
• Created chart, crosstab weekly, daily reports using summary page and page breakup functionality.
• Provided data profiling reports and troubleshoot anomalies discovered in data sets.
• Created SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.
• Created daily, weekly jobs in Cognos scheduler and published reports to SharePoint portal.
• Sent weekly BI team updated to the project manager.

Environment: Tableau 6.1,Cognos 8.4 (Report Studio, Analysis Studio, Event Studio, Metric Studio, Query Studio), Cognos Power Play Transformer v7.4, FM, RELAY, Share point, Oracle SQL server 9i, Teradata, Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Experienced in working with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Involved in designing Models using Framework Manager.
• Moving applications from one server to other using Deployment Manager.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Boards.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Also involved in planning a model which help the business in making suitable decisions.
• Experienced in creating security setup in Cognos 8 BI environment.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Environment: Framework Manager, Report Studio, Cognos Connection, Query studio, Analysis studio, Power play Transformer, Cube Reports, Oracle 9i.