Ashu Thakur

PL/SQL and SQL Developer with 5 years of experience in healthcare payer data on the Facets platform for EmblemHealth. Owns the ID card and welcome kit processes (up to 200K members per run) and handles enrolment scrubs across Medicare, Medicaid, commercial and government-sponsored plans. Reduced a mass-member ID card job from 6 hours to 2 hours through performance tuning.

Promoted twice at Cognizant and mentors 4 associates. Oracle SQL/PL/SQL certified, with working knowledge of Python and Power BI.

Associate at Cognizant Technology Solutions, India | Client: EmblemHealth (2024-09 – Present)

Lines of business: EmblemHealth Small Group, Large Group and Essential Plan; ConnectiCare; Individual Direct Pay; Child Health Plus; City of New York; Medicare; Medicaid; IB Dual.

• Own the ID card process end to end in PL/SQL, processing up to 200K members per run; analyse business change requests and implement new or modified logic in the existing process.
• Reduced ID card job runtime from 6 hours to 2 hours (about 67% faster) for mass-member processing through PL/SQL and SQL performance tuning.
• Own welcome kit processing across all lines of business.
• Process LOB enrolment inbound scrubs: vendor files (including.txt files such as EMIS/ARMS, CNY Active Retiree and HHC class enrolment) go through business rules, member match, data filtering, plan/class application and Ops review reports, then load to Facets via MMS0.
• Built automation to trigger ID cards and welcome kits for mass member populations, from 1 to 100K members in a single trigger.
• Developed PCP attribution, auto PCP assignment and default PCP assignment processes.
• Support renewal extracts, effectuation and cancellation processing for Individual Direct Pay (IDP) and Child Health Plus (CHP).
• Mentored 4 associates.

Programmer Analyst at Cognizant Technology Solutions, India | Client: EmblemHealth (2022-09 – 2024-09)

Programmer Analyst Trainee at Cognizant Technology Solutions, India | Client: EmblemHealth (2021-09 – 2022-09)

Data Science Intern at Yantra Byte (2020-06 – 2020-07)

• Python for data analysis using Pandas, NumPy and Matplotlib.

B.Tech in Electronics & Communication Engineering – KIET Group of Institutions, Ghaziabad (AKTU) (2017 – 2021)