Programming Consultant with functional ,domain experience at Citi, specialized in data profiling, involved in Review and closure of DCRM,RBCM projects and regulatory reporting and with software expertise in ETL Abinitio ,Unix programming, PL/SQL, BigData Hadoop ,Sprint planning along with client communication, ensuring data integrity and compliance. Adept at UAT testing and production support, driving successful outcomes in high-pressure environments in high priority SDLC projects. Committed to delivering innovative solutions, and enhancing operational efficiency.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Programming Consultant ,Production IT L2 support
Citi
Tampa
08.2018 - Current
From March 2025 to date, I have been working on the DCRM process. The tasks included a process to ensure the remediated DCRMs, with the data profiling and review with report owners, to ensure the remediated DCRMs have addressed the data quality or problem, and have mitigated the issues. The results and report outputs are verified with their sustainability and integrity. By establishing these data checks as part of the review and closure, it's expected that from the DCRM inception until its fulfillment, data integrity has not been compromised, and thus we are able to adhere very well to the standards defined in the regulatory submission process.
From June 2020 until March 2025, I worked in the data acquisition module, involving data demand, requirements gathering and review, UAT product testing and defect closure, post-production monitoring of data, pre/post-rule reports, and Ab Initio ETL backend programming to ensure the BAU changes have the expected regulatory report data in line with the change requests, etc.
From Aug 2018 to June 2020, I worked in Regulatory Reporting NAM L2 support application, in which the role included end-to-end load and ETL job monitoring, resolving user ad hoc queries, and MSTR/UI interface report access issues. I provided support for routine software/infrastructure upgrades in the database and WebUI server upgrades, as well as quarterly SDLC weekend code releases with production checkout and post-Go Live job and data monitoring. Additionally, I offered support to the user and GRR operation teams to ensure the FCLA SLA is adhered to for all the daily, month-end, and quarterly processes that run in the BAU production environment seamlessly as expected.
Programming Consultant
Tata Consultancy Services Ltd.
Troy
10.2006 - 06.2017
Worked for the client, Kaiser Permanente.
From June 2009 to June 2017.
Kaiser Permanente Claims Connect (KPCC) is a national claims platform used to reduce the cost of processing a claim, improve auto-adjudication rates, and deliver an extensible solution that adapts to emerging business, regulatory, and compliance needs. Roles included Level 2 and Level 3 production support.
Customer interaction, requirement gathering, end-to-end testing coordination, and production code deliverables.
· Enhancement Activities for Adhoc Production Tasks and Production Fix tasks for Production issues impacting the Application job/performance etc.
· Maintenance activities like coordinating CRQ deployment and unit and peer testing.
· Provide support for Monitoring Accums Load process in KPCC database, ClaimsXten, Claims Reports, Common Extracts, Document Acknowledgment ScanLink Processer (DASP), DataMethods, Electronic Data Interchange (EDI), Epic Bridges for Data, Explanation of Benefits (EOB), EOB Part C, Finance, Healthcare Recovery Interface (HRI), Formworks, Kaiser Permanente EDI Gateway (KPEG), Optum EasyGroup, Paper Intake, and Remedy.
· Provide Training sessions to off shore support team in Chennai about new functional and support process system release.
Provides induction sessions to new members joining the project.
· Coordinates and provide updates in client weekly status meeting.
Business Objects Data Reporting, End User Business Objects, Financial Report Troubleshooting, etc. – Data extraction, code/SQL analysis, backend assistance, and enhancement for the MAS business team.
Assist Claims End: Back-end and front-end database; user provisioning assistance, KPIM user portal assistance for new claims user requests.