A joint venture of Sykes Enterprises and Health Care Services is an integrated health management provider. The services include care management, benefit plan administration, insurance carrier management and spending account management. SHPS provide corporations and consumers with a single, comprehensive source of health management decision guidance.

       The Client required a comprehensive health care management data warehouse solution which will consolidate metrics related to all the fields of Business like insurance carrier management, Claim Management, Call management, Spending account management etc  

  Role / Responsibilities:

• Participate in Client meeting to gather the requirements and notify the status of the project.
• Distribute the work among the team members and work on the tasks along with them.
• Provide functional and Technical knowledge required for the development.
• Conducting the meeting with the team members regularly to get the update about the project.

Benefitfocus has two primary types of clients – partner insurance carriers and the employers that use products.  Benefitfocus seek long-term partnerships with insurance carriers. Together with the insurance carrier, we encourage the carrier’s employer groups to use the Benefitfocus Platform for benefit enrollment. We then are able to add significant value to the insurance carrier because we can transmit enrollment information to the carrier electronically, which allows the carrier to eliminate the manual and tedious process of “entering paper enrollment forms into their membership systems. The insurance carrier wants to have a high percentage of their employers use the Platform, so they can achieve substantial cost savings.

        Role / Responsibilities: 

• Getting the information about a particular feature that would be implemented during the release.
• Understanding the requirement and analyze them to see the best way to implement the code.
• Write the procedures/packages to meet the expected behavior.
• Preparation of Testing and releasing Issues.

This project is about purging the Audit data for all the master tables. In order to reduce the maintenance cost and storage cost involved with storing the Audit data in the test database Benefitfocus decided to delete all the data from about 520 Audit tables that gets records inserted as and when a record is been added or deleted from the master tables based or certain condition. This has to be done on all the test database environments of the application called eEnrollemnt.

Role / Responsibilities:

• Getting the information about deletion criteria to delete data from the audit tables.
• Wrote a single procedure to cleanse the 520 odd tables though the deletion criteria for different for different tables.
• Brought the deletion time from 4 hours/1 million to 4 min / 1 million
• Documented all the values like counts of records before and after purging ,time take for purging of each Audit  table
• Carried the purging in all 15 environments.

Benefitfocus HRInTouch creates a better way to manage all your benefits in one place. Whether you want to increase benefits participation, simplify enrollment, improve employee communication or support defined contribution plans, Benefitfocus helps to provide a comprehensive benefits program while engaging and educating employees.

Role / Responsibilities: 

• Getting the information about a particular feature that would be implemented during the release.
• Explain the resources about the technical/functional aspects of the feature.
• Write the procedures/packages to meet the expected behavior.
• Preparation of Testing and releasing Issues.
• Reviewing components that are to be delivered to the client.

This is a migration project from Java/Oracle platform to the Bigdata platform using Spark and Scala. These are health care models where each model output the health condition of the user or the riskt assiciated with the Insured. All the models were re-written using the spark framework and Scala as language. Have writtend around 120 models by myself and have acquired good understanding of the framework and the language.