Rachita Jain
Gurgaon
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Analyst
AXA XL
07.2023 - Current
- Developed and maintained automated dashboards in Power BI, achieving real-time insights and reducing report generation time by 40%.
- Automated key actuarial processes, leading to a 35% decrease in manual processing time and improved reporting accuracy.
- Collaborated with cross-functional teams to enhance process efficiency, reducing weekly data processing time from 10 hours to 6 hours.
- Utilized SQL and Python for advanced data analysis, identifying trends that improved accuracy by 25%.
- Conducted regular data quality checks, decreasing discrepancies from 20 to 12 instances per report.
- Engaged in scenario analysis with large data volumes, refining risk assessments and investment strategies regarding TP solvency.
Application Development Associate
Accenture Solutions
07.2021 - 07.2023
- Executed SQL procedures to enhance resource allocation by 18% through driver performance analysis.
- Created automated scripts processing over five million records, cutting weekly processing time by six hours.
- Optimized Power BI dashboard to pinpoint hiring trends and networking opportunities across sectors.
- Facilitated distribution and tracking of over 4,000 files on SharePoint.
- Analyzed customer feedback data, boosting satisfaction scores by two points.
- Conducted quality checks on large datasets, enhancing data reliability by 15%.
- Achieved Rookie Star of the Month for outstanding performance in FY22 Q2.
Programmer Analyst Trainee
Cognizant
11.2021 - 06.2022
- Designed scalable solutions enabling 50+ users to independently access and analyze data.
- Automated data collection processes with Python scripts, reducing manual entry efforts by 30%.
- Maintained high-quality deliverables while adhering to project timelines and standards.
Data Analyst Intern
Blitz Jobs
05.2020 - 07.2020
- Aggregated data from multiple online sources, compiling information on over 500 startups to identify emerging opportunities in technology, healthcare, and fintech.
- Leveraged Power BI to create interactive dashboards that visualized growth metrics and sector performance across over 50 sectors.
- Enabled stakeholders to assess trends and make informed business decisions based on comprehensive data insights.
Education
Bachelor of Technology - Computer Science
University Of Petroleum And Energy Studies
07-2021
Skills
- Python libraries: Pandas, NumPy, Matplotlib
- Power BI
- Intermediate Excel
- SQL
- Data analysis and visualization
- Version control: GitHub
- Problem solving
POSITIONS OF RESPONSIBILITY
- OPEN Community, UPES lead student developer (January 2018 – March 2021)
- Led a cross-functional team (development, engagement, and engineering) and contributed to conceptualizing an organizational structure for open source in India
- Facilitated 'The Mentorship Program,' which was a 2-day boot camp, by mentoring over 100 students interested in the field of analytics, including group discussions headed by a panel of four judges
Certification
- Data Science with Data Visualization in Power BI from Ivy Pro School
- Business Analytics course by the University of Pennsylvania from Coursera
- Microsoft Excel: For Home and Office course from Udemy
Accomplishments
- Recognized as a Dean's List nominee and awarded a merit certificate for academic achievements
- Recipient of an INR 5,000 scholarship for securing a 10 CGPA in Class X
SOCIAL WORK
- Member |Jain Charitable Trust, Muzaffarnagar (2022–present)
- Helped in organizing blood donation camps, free education workshops, and free medicines camps in rural areas
- Volunteer at Girl Up, Together, 2020
Timeline
Senior Analyst
AXA XL
07.2023 - Current
Programmer Analyst Trainee
Cognizant
11.2021 - 06.2022
Application Development Associate
Accenture Solutions
07.2021 - 07.2023
Data Analyst Intern
Blitz Jobs
05.2020 - 07.2020
Bachelor of Technology - Computer Science
University Of Petroleum And Energy Studies
Similar Profiles
SHREYA BHATTSHREYA BHATT
Senior Credit Control Analyst at Axa XL, XL India Business Services LTD.Senior Credit Control Analyst at Axa XL, XL India Business Services LTD.
Sohit KhandelwalSohit Khandelwal
Deputy Manager at Axa Xl, XL Business India Pvt LtdDeputy Manager at Axa Xl, XL Business India Pvt Ltd
Pankaj PahwaPankaj Pahwa
Delivery Lead at AXA XL - Division of AXA GroupDelivery Lead at AXA XL - Division of AXA Group
EMMA DAVIESEMMA DAVIES
Senior Property Treaty Underwriter at XL Catlin Re / AXA XL ReSenior Property Treaty Underwriter at XL Catlin Re / AXA XL Re
Kuljit SinghKuljit Singh
Head (Director), Business Transformation & Risk Control at AIS Info SourceHead (Director), Business Transformation & Risk Control at AIS Info Source