PROFESSIONAL SUMMARY:

• Around 7 years of extensive experience in Report design, Dashboard Development, Data Modeling, Business Intelligence and data quality testing.
• Hands on experience on Tableau 7/8.0/8.2/8.3 and Tableau Reader.
• Professional experience in Tableau Business Intelligence Suite including Tableau Desktop/ Server/ Online10.2,10.1,10.0,9.3,9.2,9.1,9.0,8.X,7.x,6.x,5.x,4.x. Business Intelligence Professional with in - depth knowledge and understanding of Tableau platform, architecture and implementation.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
• Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Installed Kerberos authentication and Apache ODBC Hive driver to connect Tabelau with Hadoop environment.
• Expertise in Teradata 13.10, Oracle, SQL Server, Informatica, SSIS, SSRS, SSAS, Microsoft Office Suite.
• Participated in Tableau 9.0 Beta release both in Tableau Desktop and Tableau Server
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.
• Developed business reports intelligence applications of Tableau Pivotal GreenPlum Database, MapR Hadoop Hive.
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Interact with Database, Informatica Administrators on environmental issues and work on fixing the issues.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Proficient in Oracle Database and UNIX Shell Scripting.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements
• Involved in Gathering/ analysis, Design, Development, Testing and Production rollover.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/NT/2003/2008, LINUX, UNIX

Languages: C, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005, MS Access 2000Visualization Tools: Tableau 8.1/8.0/7/0, OBIEE 10.1.3.4

OLAP Tools: Business Objects 4.1/4.0/ XI 3.1/ 6.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, CMC,CCM,LCM,Promotion Management Performance Management, Report Conversion tool, Import Wizard, Publishing Wizard, Upgrade Management Tool

BI Tools: SAP BW 7.0, BODS

Other Tools: Toad, Putty, Remedy, GIT, Sub Version

Rational Tools: Clear Case Explorer

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, Florida

Sr. Tableau Developer

Responsibilities:

• 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.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• 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.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Created Complex Dashboard, Reports using WEBI having multiple metrics and trends and created hyperlinks for each of the metric to open a detail report using Open Documents
• Experience on writing SQL Queries.
• Experience on BW Analyzer & Query Designer.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget.

Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS SQL Server 8.0/2005,XML, Tableau 8.1/8.0,SAP Business Objects 4.1/4.0, IDT, UDT, WEBI BI: SAP BW Query Designer, Analyzer

Confidential, Portsmouth, New Hampshire

Tableau Developer & Admin

Responsibilities:

• Defined best practices for Tableau report development.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad)
• Created extensive joins for data blending from several different data sources
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Built complex formulas in Tableau for various business calculations
• 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 Tableau Desktop
• Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS).
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Created and assisted users in Tableau dashboard development
• Also, designed & developed Oracle BI Dashboards. Established access rights for pages in the Dashboard for different user groups.
• Design & Customize Oracle BI Answer Views & charts, Create & save Filters, Create Charts & Tables in Oracle BI Answers.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains fields, map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.
• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Created several dashboards with various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period of time.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Migrated Reports & Universes from Development to Testing and to Production Environment using Import Wizard.

Environment: Tableau 7.0, Oracle Business Intelligence (OBIEE) 10.1.3.4, Business Objects 3.1, Universe Designer, Oracle 9i, Unix

Confidential, North-brook, IL

Sr. Tableau/ BI Developer

Responsibilities:

• Created dashboards to analyze, configure and capture operational performance, financial Performance, information security and Project Performance metrics
• Migrated deployments to controlled and non-controlled environments
• Used Actions extensively to link and filter sheets for easier navigation in Dashboards
• Interacted with business users to gather functional requirements and provide guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
• Published Dashboards onto Centralized Tableau Server location and from there consumers would choose viewing medium (laptop, pc, IPad)
• Worked closely with Data Warehouse team, ETL team and Project Managers for delivery requirements and estimates.
• Experienced in Automating and Scheduling the Teradata SQL Scripts in LINUX using Shell scripting.
• Assisted with the design and development of analytic datasets.
• Understanding and translation of various existing SSRS reports to Tableau dashboards.
• Developed and published interactive reports, also scheduled reports using Tableau Server.
• Publishing the developed reports to production Tableau server environment.
• Developed the application using Agile methodology and planned the scrum meetings
• Developed complex reports using Cognos, Business Objects XIR3/XIR2 Webi Rich Client and Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Sub reports and Grouping.
• Developed business rules for populating dimension tables, fact tables, and Aggregate tables.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Worked with databases like Netezza, Teradata, MS SQL Server 2008 R2, Oracle and tools like Aginity, notepad++, Toad, SQL Navigator, and Teradata SQL
• Created extensive integration of data and joins for data blending from different data sources
• Developed in-depth Dashboard Drill Down and Links to interrelated performance metrics
• Worked with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Collected data on various process measurements and formatted into graphs using Tableau Software.
• Performed User Acceptance Testing to ensure that developed systems satisfied needs of business clients.

Environment: Tableau Desktop 7.0, Tableau server / Administrator, tabcmd, PL/SQL, SQL developer, SQL 2008, Oracle 10g, SAS, Cognos, Informatica, Teradata, Metrics, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft office 2007

Confidential, Tempe, AZ

Jr. Tableau Developer

Responsibilities:

• Created workbooks and Dashboards using calculated metrics for different visualization requirements.
• 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 in Tableau 6.0, Created report schedules on Tableau server.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Helped customize Tableau Server with Company Logo and Company Pop-Ups.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics, Created and assisted users in Tableau dashboard development.
• Created a proof of concept for the optimal data integration process.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality during POC.
• Prepared graphical depictions of User stories, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams using MS Visio.
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Involved in creating and enhancing requirements, analysis and design using Rational Tools
• Interact with the developers and defined the needs to update the design of the Graphical User Interface.
• Helped QA team in testing SQL scripts and validated the enhancement of the project by creating test cases which were developed for Development team.
• Migrated Workbooks and Dashboards from Tableau 5.2 to Tableau 6.0.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case.

Confidential

Jr. BI Developer

Responsibilities:

• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2008 and 2012.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Developed critical SSRS reports using T-SQL stored procedures and complex SQL queries with custom coding for dynamic parameter change and formatting.
• Developed various trend reports using matrix reports and cascading prompts with charts and graphs to analyze the earned revenue and accounts receivables over a period of times.
• Deployed and shared the reports with rules and permissions defined on the report manager for data driven subscriptions.
• Participating in the SCRUM meetings and providing the updates and successfully delivering on the work in the sprint.
• Involved in developing and maintaining multiple Power BI dashboards/reports and content packs.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Experience in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop.
• Published the created dashboard reports in tableauserver.
• Experience in creating and publishing packages in Framework Manager, experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Designed different visualizations in Power BI according to the requirements.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.
• Implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Experience in Creating and managing relationships between tables in Power BI to calculate accurate results