SUMMARY:

• 7 plus years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 3 plus years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.0 and 8.1,9.0,10, 10.5 as a developer and Site Administrator.
• Certified as Tableau Qualified Associate.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Built dashboards to help reduction of Market budgets and increase ROI .
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Performed Performance Tuning for the existing Tableau dashboards.
• Used complex LOD Calculations, Table calculations and Action filters in creating those visualizations.
• Used Parameters and Layout Containers in tableau dashboards to toggle between sheets.
• Performed the Joins and Data blending to join the data in tableau from different data sources.
• Utilized Combination fields, Calculation fields, Hierarchies, Groups, Sets and different formatting styles in visualizations.
• Implemented the latest Tooltip visualization feature of Tableau 10.5 very effectively.
• Used all kinds of filters including and Data source filters context filters and all other kinds of filters based on the requirement.
• Extensive knowledge on healthcare data .
• Deployed Tableau dashboards and Created report schedules on Tableau server .
• Experience in working as Tableau Site Admin.
• Extensive experience working in Windows, LINUX environment.
• Extensive knowledge of DATAWAREHOUSING technologies.
• Experienced in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export and SSIS packages.
• Well appreciated for learning and applying of Data modeling using Schemas in short period.
• Having working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Hands on experience in handling and modifying statistical files (SAS) in SAS EG and using as input into tableau.
• Used different Data source servers like Teradata, SQL server, Oracle and Excel Data tables as inputs to tableau.
• Extensive knowledge in writing complex SQL Queries, Dynamic-queries, and complex joins for generating complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers .
• Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers using T-SQL .
• Good knowledge in Educational, Banking and Financial Service Domains.
• Extensively worked on databases like SQL Server and Oracle.
• Knowledge on Google API development skills, SQL Server, ETL processes SSIS, SSAS and SSRS .
• Having strong analytical, logical, Communication and problem-solving skills.
• Ability to adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Tableau 9.0/10.0/2018.1/2019.1

MS Excel: C, C++

PROFESSIONAL EXPERIENCE:

Confidential, CA

EMR Report Writer (Tableau)

• Responsible in understanding and analyzing data to provide Tableau reporting solutions for Decision Support Applications.
• Closely worked with business owners and users to understand the requirements
• Developed multiple Dashboard designs for focus groups to review.
• Connected Tableau with a variety of Data sources like SQL, Caboodle, Excel, Text files.
• Worked with Database developers and administrators in writing views, optimizing SQL data sources.
• Developed multiple Tableau Dashboards and visualizations for UC Davis Decision Support teams of School of Medicine and Primary care Networks.
• Developed Tableau Reports for Hospital Billing and Professional Billing Teams to support their analysis on Monthly charges, payments, RVUs and Visits.
• Built Summarized report views for CAOs .
• In the process of development, implemented a large variety of charts.
• Used complex LOD Calculations, Table calculations and Action filters in creating those visualizations.
• Used Parameters and Layout Containers in tableau dashboards to toggle between sheets.
• Performed the Joins and Data blending to join the data in tableau from different data sources.
• Utilized Combination fields, Calculation fields, Hierarchies, Groups, Sets, Action Filter and different formatting styles in visualizations.
• Implemented the latest Tooltip visualization feature of Tableau 10.5 very effectively.
• Used all kinds of filters including and Data.
• Extensively used Tableau Performance recorder in the process of Query Optimization and Performance tuning .
• Effectively used formatting features to great extent including mark labels, containers and annotations.
• Written Custom SQL queries in tableau to query the data.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL.
• Extensively used views for complex joins queries involving multiple tables from different databases.
• Deployed Tableau dashboards on Tableau Server and created monthly report schedules .
• Created and maintained User Groups and Permissions on Tableau Server.
• Worked closely with client teams to validate information represented in each report.
• Developed Tableau dashboards and visualizations for Decision Support application.
• Participated in weekly and monthly meetings to plan and execute the report development.
• Trained Technical and Non- Technical user groups in understanding and using tableau reports.
• Documented all the activities in a manner to support ongoing training and support of completed work.
• Provided Training sessions for users on Tableau reports and functionalities
• Environment: Tableau desktop 10.5,2018.1 Tableau Server 10.5, SQL Server, Epic Caboodle, Excel, Microsoft office, Visual Studio 17, MS Visio.

Confidential, PA

Tableau BI Developer.

• Gathered the requirements for tableau dashboards and prepared the requirements Documents.
• Converted the Business requirements to technical specifications and Use case Documents.
• Created the Tableau dashboards for analysis of providers performance.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Used MS Word and MS Visio to document the above.
• Good Business Knowledge of Insurance Industry and Claims data.
• Created Advanced cost report tool, Quality and Rx Dashboards in tableau for team.
• Advanced Cost Report gives a detailed cost analysis and RA Variance of Providers and Practices at different Categories and Members of the Practices.
• Implemented the drill down features using Sheet toggling and Action filters to navigate from one level to next level of analysis.
• Quality dashboards are created to see the lumpsum quality and Gaps reached by practices in different age groups for different Treatment Procedures
• Implemented a large variety of charts in Quality and ACR Dashboards including Scatter plots, Line graphs, heat maps, bubble charts, Bar graphs, heat maps, donut charts etc.
• Created Rx Dashboards used by Pharmacy teams to analyze the drug costs, Physicians prescribed and Members details.
• Implemented drill down features to find the costs from different types of drugs to Member level costs, it’s used to see the drug costs at different stores and Costs of different prescriptions of patients.
• Medicaid Analytics Dashboards will provide visualizations for teams in different locations to analyze different categories and sub-categories performances and trends in past two years.
• Created Scorecard views and drill down features in the visualizations.
• Effectively used formatting features to great extent including mark labels, containers and annotations.
• Used Tableau Pivot, Merge and Split features on data columns.
• Used Unions, Joins and Data blending to join data from different data sources like SAS, Teradata and Excel Data.
• Created Test case documents to do Tableau dashboard testing.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Scheduled data refresh on Tableau Server for monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• As a Tableau Site admin, Created Users, Groups, Projects and permissions in Medicaid analytics site
• Sent weekly status reports of Site Usage for analytics purposes.
• Worked and Prepared data in SAS EG to Aggregate and manipulate the data required for Tableau dashboards.
• In the process of data preparation wrote SAS Scripts including Proc SQL queries and Macros & schedulers to run data preparation every month.
• Used Excel Charts, Formulas and Pivot table features to great extent.
• Connected Tableau with Teradata and pulled data tables required from the server.
• Written Custom SQL queries in tableau to query the data.
• Prepared documents for all the Dashboards and maintained accuracy of information.

Environment: Tableau desktop 9.0,10.0,10.5, Tableau Server 10.0,10.5, Teradata server, Excel, SAS EG Microsoft office, MS Visio.

Confidential, Columbus, OH

Tableau developer.

Responsibilities:

• Created Dashboard reports for the department’s overall working progress in years by using the enrollment and claims data.
• Involved data designing, data mapping to perform various data base maintenance operations involving data profiling and data verification .
• Developed all the required stored procedures, user defined functions using SQL, Oracle to feed reports for better latency performance.
• Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
• Checked Performance Tuning of the Database by optimizing the queries with modification in SQL queries. Normalized tables established joins and created indexes wherever necessary.
• Building query execution plans and making sure each and every query is using appropriate indexes.
• Involved in backup and recovery strategies.
• Created various calculated fields to include the complex logic as a free hand SQL to get the results based on the business requirements.
• Converted complex business logic into SQL Stored Procedure and User Defined functions to achieve functionality required by end users.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Used SQL server data for the data sources.
• Closely watched and helped in the analysis process of eligibility criteria of the claims.
• Created Special technically directed documents for better acceptance of the reports.
• Created reports based on Claims Data and EMR data from the Medicaid data base.
• Created jump plots to analyze the company’s market.
• Created Numerous complex dashboards to show the visualizations required.
• Created dashboards to analyze performances of different levels of sales teams in different places of market by using LOD calculations and table calculations
• Defined best practices provided best Solutions for Tableau report development using a variety of charts.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Worked on motion chart, Bubble chart, Drilldown analysis using tableau desktop.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• As a part of internal usage, helped the company analyze staff performances by creating visualizations from the data stored in the form of ICD-9 codes, 10 codes and the CPT codes.
• Created report schedules on Tableau server
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Extensive knowledge on Tableau Server / Administration processes.

Environment: Tableau Desktop 8.0, Tableau server / Administrator, Oracle 10g, SQL Server, Microsoft Excel, MS Access,, Microsoft office 2007.

Confidential, Cleveland, OH

Tableau /SQL Developer

Responsibilities:

• Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
• Checked Performance Tuning of the Database by optimizing the queries with modification in T-SQL queries. Normalized tables, established joins and created indexes wherever necessary.
• Building query execution plans and making sure each and every query is using appropriate indexes.
• Involved in backup and recovery strategies.
• Created various calculated fields to include the complex logic as a free hand Sql to get the results based on the business requirements.
• Developed reports that provide users with drill up and drill down facility to achieve user requirements using Tableau.
• Created various attributes based on configurable and non-configurable data for filtering purpose.
• Created Report design documents with data mapping specifications.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Created User manual for all the three Operational Universes to facilitate the users and the for future development purposes.
• Created Report Requirements document for the canned Operational reports.
• Worked with Business analysts to study and understand the business scenarios of the existing systems, understood and validated the data by applying the current business rules.
• Created queries to extract data for multi-dimensional analysis.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: Tableau, SQL Server 2012, MS Excel 2007, Microsoft office 2007.

Confidential

SQL/BI Developer

Responsibilities:

• Participated in the full software development life cycle.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Provided technical documents and updated with recent changes and test cases
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Interaction and coordination with end users and management to identify Business system needs
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Effectively implemented changes in the .Net accordingly with the SQL Server migration and business enhancements.
• Created and manages reports subscriptions and schedules SSRS reports .
• Designed and implemented Ad hoc Reports, Extracting Data from an SQL Server database.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Created different types of joins like outer join, left and right joins.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition, MS Access, SSRS, MS Excel, & Windows 2003 server, TFS.