KIRTI KUMARI
Data Analyst
Gurgaon
Summary
Detail-oriented and analytical professional experienced in streamlining processes, managing complex data systems, and implementing solutions to enhance operational efficiency. Skilled in data analysis, business process improvement, and leveraging tools such as Power BI, ETL tools, Excel, SQL, and Python to extract actionable insights. Proven ability to drive data-driven decision-making and improve business outcomes.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work History
SR. Configuration Analyst - I
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.
Configuration Analyst - I
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.
Technical Support Trainee
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.
Education
Bachelor of Technology - Computer Science And Engineering
08.2017 - 06.2021
Skills
Data Analysis
Power BI
SQL
Python Programming
ETL
Advanced–Excel
User Acceptance Testing
Business Intelligence
Problem-solving aptitude
Adaptability
Languages
English
Hindi
Odia
Interests
Fitness and Weight Training
Creative writing
Literature Enthusiast
Timeline
Configuration Analyst - I - AON
07.2021 - 07.2022
Technical Support Trainee - PROSPECTA SOFTWARE
08.2020 - 07.2021
Lovely Professional University - Bachelor of Technology, Computer Science And Engineering
08.2017 - 06.2021
SR. Configuration Analyst - I - AON
7 2022 - 08.2024