Back to Developers
Akhila Johny

Akhila Johny

Benefit Analyst

Bengaluru, India 9+ yrs exp 90 · Outstanding

About

7 year experienced Benefits Analyst with a demonstrated history of working in the US healthcare industry. Skilled in data analysis, business analysis and Advanced MS excel, with a strong background in Handling benefit renewal, issue logs and manual testing. Proven ability to support audit processes and manage Large /Small group plan using applications like JIRA, WPD, Salesforce, InterAct and Mainframe. Proficient at team leadership and Deadline management with a career goal to leverage analytical skills for strategic business solutions.

Skills & Expertise (15)

SQL Advanced
8.5/10
5
Years Exp
Advanced MS Excel Advanced
8.2/10
5
Years Exp
Data Analysis Advanced
8.1/10
5
Years Exp
Business Analysis Advanced
8.0/10
5
Years Exp
MySql Advanced
7.5/10
4
Years Exp
Project Management Advanced
7.3/10
5
Years Exp
Time management Advanced
7.0/10
5
Years Exp
VBA Advanced
7.0/10
4
Years Exp
Jira Advanced
7.0/10
5
Years Exp
Team Leadership Intermediate
6.5/10
4
Years Exp
Salesforce Intermediate
6.5/10
3
Years Exp
MS PowerPoint Intermediate
6.0/10
5
Years Exp
Tableau Intermediate
6.0/10
3
Years Exp
Mainframe Intermediate
5.5/10
3
Years Exp
Data Analysis & Visualisation

Work Experience

Benefit Analyst

Carelon Global Solutions

Jan 2021 - Present

Designed and executed SQL queries to extract insights from relational databases, enabling data driven decision making. Managed benefit configuration processes, including creating new variations and updating bagging changes per customer requirements. Validate the claim details and Adjudication information in WGS mainframe, raising tickets for necessary updates. Supported audits for Medicare Supplements and Large/Small Group Plans. Implemented data updates and insert operations to maintain accurate and up-to-date datasets. Utilized applications such as JIRA, Interact, Salesforce, and WPD for workflow management. Collaborated with business owners, product managers, and stakeholders to capture, prioritize, and manage expectations. Assisted in gathering and documenting business requirements to support solution design. Performed data analysis using Excel formulas, conditional formatting and data validation to ensure accuracy and actionable insights in recurring and ad hoc reporting. Collaborated with technical team to analyze and modify VBA macros for automation process. Facilitated effective communication between stakeholders including business teams, development teams and management. Co-ordinated requirements and implementation process with cross functional teams to ensure seamless execution. Contributed to documentation and knowledge repositories to support future development and training. Provided support in optimizing workflows and identifying process enhancements. Analyzing and producing business performance reports and production reports.

Process Associate

UST Global

Jan 2018 - Jan 2021

Analyzing and reviewing Benefit summary, CEP, Requests, etc., given by client. Coding each benefit by category wise with the WPD Application. Create the new Contract Code and Variation if needed. Validate the claim details and Adjudication Info in WGS mainframe. Handling Issue logs, Defects, APP issues etc. Resolving Hard Edits and Soft Edits in ISG GF variations. Supporting for Med Supp and Large/Small Group plans. Creating the reports for the weekly and monthly quality and performance of the team.

Data Validation - Associate

Benefitalign Technologies

Jan 2017 - Jan 2018

Compile and generate spreadsheets capturing key data related to company’s active contracts. Analyzing Benefit summary given by client. Fetching all respective data from Database. And updating the DB if it requires. Analyzing and reviewing Benefit summary. Creating test cases for Functional and User Acceptance Testing. Involved in creating test plan strategy, test scenarios, test cases and maintenance documents, test execution, defect fixes. Create pivot tables and modify spreadsheets to achieve analytical goals. Reviewing work products and deploying the application in the test environment and initiating the process of user acceptance testing. Doing business analysis and predicting the next quarter plan values and fetch that into DB. Taking care of different carriers such as UHC, Aetna, Humana, Anthem, Kaiser Permanente etc. Handling Database manipulations.

Education

Bachelor of Technology - Ilahia College of Engineering & Technology

2012 - 2016 · Afghanistan

Certifications

No certifications added yet