Transforming data from payer files into the internal standard format and developing concept mapping for retrieval of enrollment and claims data.
Developing mapping documents involving case statements of medium to high complexity.
Setting up templates for the validation of payer data before it is loaded into production.
Communicating regularly with other team members to understand nuances of each contract/payer, and each contract/payer is different from the other.
Working closely with Data Engineering and Quality teams. Helping them in understanding any particular business requirement.
Ensuring prompt resolution of bugs related to contracts on SLAs. Responsible for reporting and assessing gaps in the ongoing process of data ingestion.
Managing and organizing data for payer information repositories and records. Using RegEx and SFTP UI for adding distribution rules to distribute data into Azure storage.
Responsible for ingesting Quality and Financial data, sent by payers, into the internal systems for analysis purposes. This data is used by the entire organization for any decision-making purposes.
Business Analyst
Bharti AXA General insurance company (now ICICI Lombard General insurance company )
Mumbai
05.2019 - 03.2022
Interact with the business users, collect and document business requirements and functional specifications in BRD for proposed plan. Obtain sign off for BRD from stakeholders for the proposed solution and forward to technical team. Provide sign off for FRD prepared by the technical team for development of systems.
Develop comprehensive test cases or user stories at the application and multi-application levels. Assuring system readiness by actively integrating with IT team in the process of UAT during various stages of the development lifecycle.
Assessing readiness and deviation of product/project performance based upon test and review results and specifications of application. Documenting the sprint workflows, timeline and providing regular sprint reviews to the stakeholders.
Conducting ongoing analysis of existing products, associated target markets/competitors to provide in-depth industry, market and competitive analysis to assist in the identification and evaluation of new product opportunities.
Responsible for reporting and assessing a log of proposed enhancements, major complaints and identified gaps for existing products to ensure continuous product portfolio improvements. Ensuring compliance of products and processes as per regulatory through regular follow ups.
Adhering to TATs as per SLAs, synchronizing with TPA and working with sales and operations to ensure that business requirements are met and customers are provided with high levels of service.
Master data management of repositories and records of IRDAI's product related circulars and other notifications.
Preparation of product filing documents to be sent to regulatory and responding to the regulatory queries.
Creating monthly retail health insurance renewal data to assist customers in renewing their policies on time.
Education
MBA - Insurance Manangement
Pondicherry Central University
Pondicherry
05-2019
BBA -
Sri Sathya Sai Institute of Higher Learning
Ananthapur
05-2017
Skills
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
SQL
Azure DevOps
Snowflake
Power Automate
Databricks
Basic Power BI
RegX
Timeline
Senior Business Analyst
Providence India
10.2022 - Current
Business Analyst
Bharti AXA General insurance company (now ICICI Lombard General insurance company )