WellCare Health Plans, Inc. provides managed care health plans through Medicaid, Medicare Advantage and Medicare Prescription Drug plans for more than 4.4 million members across the country. WellCare Health Plans, Inc. is the holding company for several subsidiaries.

Protective Life Corporation is a financial service holding company in Birmingham, Alabama. The companys primary subsidiary, Protective Life Insurance Company, was established in 1907 and now markets its products and services in all 50 states. As of December 31, 2016, the corporation had more than 2,700 employees, annual revenues of $4.48 billion and assets of $75 billion.

Meijer Inc is an American super centre chain throughout the Midwest, with its corporate headquarters in Walker, Michigan, which is a part of the Grand Rapids metropolitan area. Founded in 1934 as a supermarket chain, Meijer is credited with pioneering the modern super centre concept in 1962. About half of the companys 242 stores are located in Michigan.

i worked for Wellcare project for 1 year as Tableau Developer.

in this project wellcare want to analyseEvery Month Cash inflow and Cash out flow. How much amount of Cash inflow come and how much Cash out flow they are using, they want clearly understand of capital expanses.

every Month Cash in flow > Cash out flow for sucess full business.

Based on analysis they take the decisions .

on total profithow much percentage they can invest there business improvement.

created new data source and replaced with existed data source, created schedules and extracted the data into Tableau data engine.

created complex formulas and calculations with in tableau to meet the needs of extracted the data into tableau data engine.

created out of box like donut chart, funeel charts and waterfall chart.

perform the unit testing what ever i develope the dash board in tableau check the values in sql server write the querries in sql server and see the results of values are matching or not.

created scheduled frequency and time to refresh data when sources are published or extracted to server.

on overall 5 years experience created lot of toughest scenario like Toggling Dashboard, Drill down Dashboard, Add The Refresh Button at Dashboard to set the Filters to default postionat One click to save the Users Time.

faced toughest scenario tlikeCountries wise sales show in Percent of Total, and end User want to see when he filter the countries want to see the every country Percent of total individually. when we show percent of total and add the filter the countries it cant show the individual because Percent fo total is Table Calculation it depends on the table structure. when select any one country in filter it show 100% its wrong output. In this case i use Fixed LOD to avoid this problem . what fixed going do is it fixed the denominator and when we use the any one country it show corrent value. because Fixed LOD exicuted before the Dimension filter so filter cant effect.

created sorting for measures- end user select any measure and want see that measure it descending order, ascending order.

i worked for Meijer for 1 year

analyze data of Meijer and create Dashboards, so that Dashboards and analye is help to meijer to looking for a way to generate dynamic, interactive reports to analyze this data in order to effectively manage its ordersm monitor sales performance, and increase overall customer satisfaction.

created action filters, paramters and calculated sets for preparing Dashboards and worksheets in Tableau.

developed visualizations using calculated fileds, dynamic sorting, filtering, paramter driven analysis.

Designed and Developed web reports using the features like charts, cross tabs, drill down to analyze the data.

Improved Report Performance uising extract connection and context filters, Apply button to Quick filter it can reduce multiple queries to data source, minimise the calculations, use the filter at data source level to select only required data.

I Worked for Protective Life Corporation for 2 years.

protective life corporation deals with different insurance policies for acquiring the customers there are multiple agents involved my prime role is to understand the business from all agents, calculating the premiums, repayment claims. How many customers acquired by each agent. The performance of the agents based on the premium amounts and also calculating the return on investment. Understanding the product of the insurances which product is sold the more customers and what age groups and gegrpahical map showing the business to understand which policy is given max revenues and less claims. So they can concentrate on those policies.

in this project created dashboard like insurance dashboard- this dashboard show there Policy Status, Key measure trend, Geo Analysis, Termination Reason. so this dashboard give complete information about the insurance policy which is inforce, cancellation, termination. Key mesure trend show years wise, week wise of sum assured, annual premium, amount of claims, policy count.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau desktop.

Resolved various performance issues and analysed the best process distribution for different projects.

Created calculated filelds and parameters along with the appropriate filters and plotted the mesures on the respective graphs with the base data.