Rachit Jalali

Client Name: - CareFirst BlueCross BlueShield

Role: ETL Developer using Informatica PowerCenter

Domain: HealthCare and Health Insurance

Client is one of the Key players in the Health care and health insurance domain offering health services, care, facilities to the members. Client also provides health insurance to the members and sponsors various hygienic, health awareness programs.

Project Title: - Development for Enrollment and Billing & Production support

• Worked on multiple core jobs enhancements, i.e. Invoice creation for monthly/weekly premium and claims, Automation of Voluntary termination process, Automation of Invoice generation, Automation for claim settlement for Coordination of benefits.
• Helped in time and cost saving by automating manual work for client.
• Production database management by understanding the complete flow of the application.
• Modifying existing mappings, workflows as per business requirements. Developed complex mappings by extracting data from different relational sources using complex queries, loading data into intermediate staging tables, performing calculations on data for deriving columns.
• Worked with DBA/Tech Archs to create target tables, constraints, application users in lower & higher environments etc. Worked with Informatica Admin team to create relational connections in lower & higher environments, migration of code in SIT and Prod environments.
• Created SDS document, estimate sheet, STM and worked with QA team for SIT support.
• Monitoring production jobs to ensure on time successful execution of jobs, validating source/target data, fixing job failures by coordinating with command center, scheduling or Informatica admin teams.
• Documented system configuration, mapping and processes