Business Intelligence Data Scientist
Resume:
Chakilam Arun Kumar
E-Mail: ****.*********@*****.***
Cell: +1-412-***-****
PROFESSIONAL SYNOPSIS
A Dynamic & Result-Oriented Professional with More than 8.5 years of IT and US Healthcare experience encompassing a wide range of skill sets roles and industry verticals.
Experience in requirements gathering, analysis, preparing technical and program specifications, coding, development, code review, coordination with stakeholders, production promotion and post-production support.
Skilful in handling the critical business requirements by providing quicker and better solutions.
Worked in various modules of HealthEdge, Facets 4.7.1. like Member/Subscriber, Claim, Provider and Networks
Have good knowledge in writing SQL queries in different RDBMS systems, efficient query designing, and Performance Tuning.
Experience in developing reports using PowerBI, SAP Crystal reports.
Experience on Integrated Tool like Talend.
Developed many reports related to Health Equity by working with business and derived key factors that impact Health Equity.
Experience on different RDBMS systems like Snowflake, SQL Server and Oracle PL/SQL Developer.
Experience in working on UHG Proprietary data warehouse Clinical data model & Facets.
Expert in identifying high risk members early by accessing data from claims and clinical models.
Collaborative & Team Oriented, Ability to plan, organize & keep going when things get difficult, Self-Motivated, Lifetime Learner.
TECHNICAL SKILLS
Facets Modules: Member/ Subscriber, Claim, Provider and Networks.
Modules: HealthEdge, Community Care, ICUE, Facets, Pathways.
Programming Languages: Java, Python, R.
RDBMS Systems: Snowflake, SQL Server and Oracle PL/SQL Developer.
Reporting Tools: PowerBI, Tableau, SAP Crystal Reports 2013.
Integrated Tools: Talend
Reporting Portals: CMC (Central Management Console)
Operation Systems: Windows 7, Windows XP
Tools/ Packages: Microsoft Office and Notepad++.
FUNCTIONAL/ TECHNICAL CERTIFICATIONS
Name of Institution
Certification Name
Year Of Completion
America’s Health Insurance Plans (AHIP)
AHM -250 (Professional, Academy for Healthcare Management)
2017
Lean Kanban University
Team Kanban Practitioner (TKP)
2018
Tableau
Tableau Desktop Specialist
2020
EDUCATIONAL QUALIFICATIONS
Bachelor of Technology in Electronics and communication Engineering Department – 2011-2015, HMTK– Affiliated to Jawaharlal Nehru Technological University, Hyderabad.
CAREER HIGHLIGHTS
Company Name: UnitedHealth Group, Pittsburgh PA USA
Current Role: Sr. Data Scientist
Duration: August 2016 - Till Date
Notable Achievements & Team Activities:
I received the STAR Award as a reward for my performance in CSP team at UHG.
Successfully completed migration of FL, RI & WA reports, by playing a key role in all the plans/ states migration.
First person to become the SME for various process like Healthy first steps process, HRA – Health risk assessment/HARC reporting, Member/Provider letter reporting, new members reporting, EDI 834 daily/monthly files generation.
I was appreciated being a quick learner and delivering multiple medium/ complex reports within the initial month(s) of joining the team.
Organiser for Team outings and activities.
Projects Experience:
#3
Project Name: C&S Utilization management
Role
Sr. Data Scientist
Organization
UnitedHealth Group
Team Size
1
Environment
Software
Database: Snowflake / Oracle
BI Tools: PowerBI, SAP Crystal Reports 2011
Integrated Tools: Talend
Proprietary Applications: Clinical data model, CSP(Facets), Helios & Community Care, HealthEdge, Health Equity
O/S: Windows 7
Hardware
Client/Server Architecture
Duration
Aug 2016 – Till Date
Project Description:
This project is about stratifying pregnant members into healthy and high risk and re-stratify members who might jump to higher care levels using various predictive measures made by the predictive model generated using Talend and various findings found using reports generated using SAP Crystal Reports.
After passing through many steps pregnant members are identified using Claims data from CSP and analyze membership and their clinical activities from Clinical models, Finally Talend is used to create a predictive model using clinical activities that will flag High Risk Members.
The goal of this project is to make sure high-risk pregnant members are well maintained by enrolling them in special wellness programs that are provided for free of cost by UHG in partnership with state health departments. This project helps UHG save huge dollar amounts since we can give special attention to high-risk pregnancy members' by making sure their newborn baby is not admitted/transferred to NICU (Newborn Intensive care unit) after birth. On an average, UHG incurs a cost of more than 3500$ per day for NICU admits
Roles and Responsibilities:
Has been part of the project ever since its initiation and performed development for states namely – North Carolina (NC), Maryland (MD), Nebraska (NE), Washington (WA), Wisconsin (WI) and Mississippi (MS).
As part of C&S Utilization management project, I will flag potential high-Risk pregnant members by firstly identifying pregnant women by investigating health care utilization from CSP & Clinical applications and designing a predictive model to stratify a pregnant woman into healthy or high risk by accessing clinical data from the UHG proprietary applications
Participating in requirements review and clarifications meetings with Onshore Analysts and clarifying the requirements gaps (if any) during U.S. business hours.
Integration of data from CSP & clinical applications and build a prediction model using Talend and SAP Crystal reports based on past healthcare utilization and clinical assessment responses that include member's financial status, lifestyle and periodic health status that helped to flag high risk patient.
Scheduling the developed reports in production server using CMC reporting portal.
#2
Project Name : CareOne to ICUE Migration Project (Community and State BI)
Role
Data Scientist
Organization
UnitedHealth Group
Team Size
3
Environment
Software
Database: Oracle/SQL Server
BI Tools: SAP Crystal Reports 2011
Proprietary Applications: CareOne, ICUE
O/S: Windows 7
Hardware
Client/Server Architecture
Duration
Apr 2017 – Oct 2017
Project Description:
CareOne application is developed and maintained by UnitedHealth Group, which consists of different modules developed for UHG’s Health plan and it is a proprietary application for strategic platform. As part of standardization, this business is getting migrated ICUE Platform. In this process of migration, the reports (parallelly all other parts of migrations like data etc.) from CareOne will be migrated to ICUE platform.
Roles and Responsibilities:
Analyzing the existing CareOne reports and preparing the Software Specifications Document (SRS).
Preparing mapping documents for – CareOne to ICUE.
Participating in requirements review and clarifications meetings with Onshore Analysts and clarifying the requirements gaps (if any) during U.S. business hours.
Reports Development in Crystal, and SQL in Oracle. Real Time testing of projects with business users and Code Reviews and Coordination of Deliverables.
Scheduling the developed reports in production server using CMC reporting portal.
Creating templates and checklists to reduce development effort and minimize defect chances.
Worked on migration of more than 40 reports of different plans with a very minimum number of defect injection.
Submitted couple of ideas and patterns (DP) which results in huge cost savings in the project.
#1
Project Name : Community and State Strategic Platform (CSP) Reporting Project
Role
Data Analyst
Organization
UnitedHealth Group
Team Size
2
Environment
Software
Database: Oracle
BI Tools: SAP Crystal Reports 2011
Proprietary Applications: CSP
O/S: Windows 7
Hardware
Client/Server Architecture
Duration
Aug 2016 – Till date
Project Description:
Community and State Strategic Platform (CSP) is UHG proprietary application, which is vital for UnitedHealth Group operations. Community and State Strategic Platform (CSP) is a complete end to end Healthcare Insurance Management system that supports Community & State’s Health plans.
Roles and Responsibilities:
Analyzing the CSP report requirement and preparing the Software Specifications Document (SRS).
Participating in requirements review and clarifications meetings with Onshore Analysts and clarifying the requirements gaps (if any) during U.S. business hours.
Reports Development in Crystal, and SQL in SQL Server. Real Time testing of projects with business users and Code Reviews and Coordination of Deliverables.
Scheduling the developed reports in production server using CMC reporting portal.
Worked on 40 reports of different plans with a very minimum number of defect injection.
PASSPORT & VISA DETAILS
Passport No.
N2721353
DOB: 21/01/1994
Country
Valid From
Valid Up to
India
09/09/2015
09/08/2025
VISA
Valid From
Valid Up to
USA - L1B
09/15/2022
04/30/2025 – Change of Status to H1B on 02/03/2025
USA – H1B
02/04/2025
PERSONAL DETAILS
Present Address
Full Name:
Chakilam Arun Kumar
Current Location
Pittsburgh, PA, USA
US Address
100 Chatham Park Drive, Apt 209,
Pittsburgh, PA, USA, 15220
Home Country Address
Full Name:
Chakilam Arun Kumar
Current Location
Hyderabad, Telangana, India
Permanent Address
Hno:11-3-416/6, Parsigutta, Ambanagar, Beside Bethany gospel church
Hyderabad - 500061
Personal Email Id’s
****.*********@*****.***
Contact Numbers
Mobile: +1-412-***-****
I hereby declare that the above written particulars are best of my knowledge and belief.
Date: 2/3/2025
Place: Pittsburgh, PA, USA Chakilam Arun Kumar
Contact this candidate