KIRTI KUMARI

Work History

AON

7 2022 - 08.2024

Managed end-to-end ETL projects, utilizing stored procedures and coordinating efforts between onsite and offsite teams to ensure efficient data integration and transformation.
Configured and executed projects for high-profile clients including IBM, Invesco, KPMG, and PwC using Actian DataConnect, SQL, and stored procedures, ensuring seamless data integration and transformation.
Effectively managed client communication, building strong relationships and understanding project requirements.
Developed and maintained interactive dashboards and reports with Power BI to visualize data trends, track key performance indicators, and support business decision-making.
Analyzed and visualized data using Python, leveraging libraries such as Pandas and Matplotlib to derive actionable insights and enhance reporting capabilities.
Identified challenges and devised solutions in collaboration with the admin team and other stakeholders.
Implemented Actian DataConnect for automating data integration processes through shell scripting.
Loaded and transformed data from databases and exported data to various file formats, including XML, XLSX, XLS, and TXT.
Created benefits eligibility rules and events using SQL as per requirements.
Worked with tools such as Sequence Tickets, Easy Project, Workflows, ServiceNow, and managed migration tasks.
Collaborated with offshore and onshore teams to resolve technical issues, identify gaps in the current system, and ensure effective project lifecycle management.

AON

07.2021 - 07.2022

Designed and implemented ETL processes using SSIS and stored procedures to handle large datasets effectively
Utilized SQL to create eligibility rules, and events in Health and Benefits systems as per project requirements
Managed sequence tickets, workflows, mappings, and migration tasks to ensure smooth project execution
Debugged defects in exports and imports, if any, and documented root cause analysis to maintain client team metrics for ongoing improvement.

PROSPECTA SOFTWARE

08.2020 - 07.2021

Worked on Prospecta's flagship product, MDO, collaborating with developers and the BA team to build and enhance new features, improving user experience.
Conducted regressive testing and User Acceptance Testing (UAT) to identify and resolve bugs on the MDO platform.
Tracked project changes and deployment status using JIRA to ensure timely updates and efficient project management.
Demonstrated commitment to client satisfaction by delivering projects within the agreed timeframe and ensuring smooth go-live processes.