SUMMARY

• Around 9+ years of extensive IT Experience in Business analysis, Business intelligence, Data Warehousing, Data mining, Data analysis, and Business Intelligence applications in insurance, and Healthcare industries.
• Good experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various. Versions of Tableau 10.x/9.x/8.x/7.x
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Involved in generating proper data in excel for Tableau dashboard.
• Created customized and interactive dashboards using multiple data sources using Tableau, Good hold over SQL databases and using SQL queries with Tableau and Alteryx.
• Gathering business requirements from various users of different departments.
• Building, publishing customized interactive reports and dashboards, report scheduling using tableau server.
• Scheduled for auto refresh of dashboards on the application server.
• Designed and deployed rich graphic visualizations with drill down and dropdown menu option and parameterized using Tableau.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Good knowledge in rendering reports, managing subscriptions, creating reports in Tableau.
• Created Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Experience on creating Clipboards and Data Source Filters in tableau.
• Extensive experience on Data Blending in Tableau.
• Implementing Individual Axis, Axis Blending, and Dual Axis in Tableau.
• Worked on various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Formatted the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Provided Security while Publishing to theTableauServer.
• Developed, Designed and supported interactivetableaudashboard reports.
• Good working experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• Expertise in web integration of Tableau Reports with HTML or Asp.Net.
• Good experience working on Star Schema dimensional modeling, which includes understanding business processes, modeling, dimensions, hierarchies and facts.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.

TECHNICAL SKILLS

Languages: SQL, Python, ASP.Net, JSON, REST API.

Tools: and Skills: SSIS, HTML5, CSS3, JIRA, Angular JS, Tableau (Server, Desktop, Reports), PowerBI.

Database: Microsoft SQL Server, DB2, Teradata, Oracle.

Functional: Business Intelligence, ETL, SSIS, SDLC, STLC, Data Warehousing/integrity/mining/analytics.

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. Tableau Developer

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Effectively interacted with Business Analysts and Data Modelers to define requirement document and design processes for various data sources and reporting needs.
• Built and published customized Interactive reports and dashboards along with data refresh by using Tableau Desktop.
• Blended data from multiple databases such as MS excel and SQL database by assigning primary key from each database.
• Developed KPI’s and dashboards based on reports, spreadsheets, and charts.
• Created Cohort builder, Patient Viewer, Multiple myeloma dashboards for researchers, clinicians, etc.
• Created and modified some of the existing reports and dashboards
• Created Filters, Groups, Sets on Tableau Reports.
• Created, organized, customized analysis and visualized projects and dashboards to present to Doctors and Researchers.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Strong Dashboard design experience and passionate practitioner of effective data visualization.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Developing Inventory Control dashboards using Tableau to analyze vendor defects
• Writing SQL queries solved many critical requirements by digging the required data.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Published and shared views on Tableau server and Scheduled extract refresh and subscriptions.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Created Custom Admin Views dashboard by connecting to Workgroup database and allowed the users to audit the usage of Workbooks, Data Sources and Views.
• Created Actions in Worksheets and Dashboards and enhanced the user interactivity.
• Followed SCRUM (Agile) methodology and developed a dashboard with value added product.
• Worked on editing Data connections and changing data sources in Tableau.
• Extensively developed custom SQL queries.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Created demos in Tableau Desktop and published onto Tableau Server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Tableau Desktop 10.4, Tableau server, Windows XP, MSOffice (Word, PowerPoint, Excel, Visio), Oracle, SQL Server, Teradata.

Confidential, IL

Data Visualization/BI Developer

Responsibilities:

• Collaborated with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created and assisted users in Tableau dashboard development.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Created, customized & shared interactive web dashboards in minutes with simple drag & drop method and accessed dashboards from any browser or tablet.
• Build Tableau Dashboards on different sources like Oracle Database, Flat Files (excel, csv) and OLAP database.
• Created Tableau data extracts (. tde) files to import dashboard users from csv file to Tableau Server using Extract API.
• Involved in the creation of Users and User Groups in the Tableau server.
• Worked on Tableau Command line tools tabadmin for Configuration settings in tableau Server and tabcmd for users, group's creation.
• Worked on Motion chart and Drill down analysis.
• Developed Interactive (Dynamic) dashboards, Adhoc reports for users.
• Involved in the migration of OBIEE reports to Tableau.
• Creating data blending in case of merging two different datasets.
• Developed dashboards using various data sources such as Hartonworks Hadoop Hive and Cloudera Hadoop, Oracle, Netezza.
• Extensively developed custom SQL queries.
• Effectively involved in the maintenance of DataServer, metadata management, creating shared Data sources and publishing them to Tableau Server.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Environment: Tableau Desktop 10.2, Tableau server, Alteryx, Redshift, SAP HANA, SQL Server 2012, HRIS, MS Access, Windows 2007 server, Teradata, MS Office 2007.

Confidential, KS

Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Ensured on - time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Involved in requirements gathering, analysis, and functional specification documents.
• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirements.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Parameters and Actions. Setting the user permissions in Tableau Sever.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Prepared proof of concept for best practices in Tableau deployment.
• Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.
• Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop
• Involved in integration of Tableau JavaScript API Filters in web application
• Created dashboards and reports for ad-Hoc Reporting.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment: Tableau (Desktop/ Server), Teradata, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007

Confidential, Atlanta GA

Tableau Developer

Responsibilities:

• Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Hands-on experience in analyzing the data and writing Custom SQL queries for better performance, joining the tables and selecting the required data to run the reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Alteryx in Tableau Server.
• Developed Tableau workbooks from multiple data sources using data blending.
• Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Responsible for creating dashboards using bars, stacked bars, pie charts, scattered plots, line charts, Gantt charts, and maps.
• Created prompts, customized calculations, conditions and filters (Local, Global) for various analytical reports and dashboards.
• Created and modified interactive dashboards and developed guided navigation links within interactive dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports and dashboards.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and data marts.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• 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 analyse data in different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Used advanced Excel functions to generate spreadsheets and pivot tables.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment.

Environment: Tableau Desktop 9x, Tableau Server, SQL Assistant, SAP Lynx, SharePoint, Microsoft SQL Server, Terada, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Alteryx Designer, MS Access

Confidential

Tableau / Data Visualization Developer

Responsibilities:

• Developed different kind of dashboards by extracting data from different data sources.
• Attended meetings with developers, site administrators and business users as needed to discuss about Tableau.
• Managing the metadata associated with the ETL processes used to populate the Data warehouse.
• Created various types of charts to provide better data visualization.
• Used Tableau Desktop created interactive reporting dashboards by combining multiple views.
• Used different Mark types and Mark properties in views to provide better insights into large datasets.
• Reviewed business requirements and prepared the dashboards as per the requirements.
• Modified the existing dashboard as per the user requirements used Tableau Desktop for creating different interactive views and dashboards.
• 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 publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau Servers.
• Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 8.0, Business Objects 4.0, Oracle 10g, Crystal Reports 2008, MS Office Suite.

Confidential

BI Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• 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 use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site's financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Consolidate multiple data silos that exist on campus to one location.
• 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: Windows XP, Linux, Windows 7, SQL Developer, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB.