Kishorekumar Arumugam

Results-driven Data Analyst specializing in healthcare analytics and process optimization. Experienced in analyzing complex medical claims data, validating data integrity, and developing robust SQL-based solutions to streamline operations. Skilled at transforming business requirements into actionable insights that improve claims accuracy, strengthen regulatory compliance, and boost overall efficiency.

A collaborative and analytical professional with a deep commitment to leveraging data for smarter, evidence-based healthcare decisions.

Data Analyst - EXELA TECHNOLOGIES (Source HOV INDIA PRIVATE LIMITED)

• Developed and executed advanced SQL queries (DML/DQL) in SSMS 2012 to ensure data quality and integrity across critical health insurance projects.
• Managed production releases by preparing CCDs in TIMO and coordinating seamless cross-functional deployments.
• Collaborated with Business Analysts and QA teams to achieve regulatory compliance and optimize claim processing workflows.
• Implemented KomodoFCB Business Rules to accurately translate client requirements into robust database configurations and validations.
• Demonstrated strong problem-solving and data management skills within high-impact healthcare technology initiatives.
• Designed and implemented stored procedures for ETL processes, extracting and transforming XML data into relational databases per project specifications.
• Authored sub-queries and joins to manage complex queries across multiple tables, with proficiency in DQL, DML, DDL, and TCL commands.
• Led end-to-end SDLC for database solutions, optimizing SQL development, testing, and deployment in healthcare projects.
• Developed comprehensive reporting frameworks that produced actionable project status updates and visually engaging dashboards in Excel.

Data Analyst - BLUE CROSS BLUE SHIELD OF NORTH CAROLINA (BCBSNC)

• Analyzed medical claims data to optimize direct payments, reimbursements, and cost management for a wide range of illnesses and injuries.
• Designed and implemented document validation systems to detect valid versus erroneous submissions, significantly improving claims accuracy and operational efficiency.
• Managed processing of complex healthcare forms, including CMS1500 (33 fields), UB04 (81 fields), and Dental (58 fields) for single, multi, and voucher group submissions.
• Collaborated with Business Analysts using the FCB tool to translate customer requirements into accurate technical specifications.
• Developed and maintained SQL-based applications that enabled efficient healthcare claims processing and delivered robust, business-driven solutions.

SSLC - Shri Ganga Matriculation School (2012-04)

HSC - Shri Ganga Hr. Sec School (2014-03)

B.E. - Computer Science and Engineering - Kongu Engineering College (2018-05)