Dalvir Kaur
Ontario,Canada
Summary
Data Analyst with 5 years of experience in statistical analysis and HR metrics, proficient in AI-driven solutions, and passionate about leveraging data-driven research strategies.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
Marsh McLennan
01.2022 - 08.2023
- Played a key role in designing and maintaining database systems, improving data completeness by 15%
- Optimized data storage and retrieval processes, enhancing overall data management efficiency
- Developed and implemented an automated utility tool for RxDC reporting, reducing the time spent on preparing cover letters and narratives by 99%, streamlining the process.
- Conducted quality checks, enhancing data accuracy by 7.5%
- Worked with Life & Disability RFPs and market proposals, verifying benefits and premiums.
- Managed Life & Disability RFP processes, including gathering client census data, plan designs, rate information, historical claims data, and additional materials for renewals and new client proposals.
- Developed and implemented an automated utility tool for RxDC reporting, reducing the time spent on preparing cover letters and narratives by 99%, streamlining the process.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
Team Lead HR
Pacific, an Accesshealthcare Company
07.2018 - 12.2021
- Implemented data-driven initiatives that boosted employee retention rates by 15% within one year and increased employee satisfaction by 10%.
- Led the integration of advanced technologies into the HRIS, reducing error rates by 25% and streamlining data processes.
- Analyzed compensation benchmarks to restructure the framework, resulting in a 12% reduction in expenses, and negotiated vendor contracts that saved 15% annually.
- Designed tailored training modules for managers, leading to a 25% improvement in survey utilization and accuracy, and developed a communications strategy that increased survey participation by 20%.
- Stayed updated on HR trends through conferences, applied data visualization techniques for better decision-making, and enhanced HR processes with strong analytical skills.
- Trained new team members by relaying information on company procedures and safety requirements.
- Promoted a positive work environment by fostering teamwork, open communication, and employee recognition initiatives.
Education
Graduate Certificate - Research Analyst
Humber College
Graduate Certificate - Business Analytics
Conestoga College
04.2024
MSc - Finance
National University of Ireland
03.2018
BBA -
Lovely Professional University
08.2024
Skills
- Tableau, MangoDB, MS Project, HR Analytics Software
- Database Design, Data Storage Solutions, Data Flow Modeling
- Data Visualization and Presentations, Data Analysis
- Python Programming
- Python, SQL
- Arc GIS
Certification
Introduction to the City of Kitchener’s Open Data Workshop - Using Arc GIS
Technicalexpertise
Python, SQL, Tableau, and data processing
Projects
Capstone Project: Prediction of Stock Prices using the CAPM Model.
- Developed a predictive model using the Capital Asset Pricing Model (CAPM) to analyze stock price movements.
- Conducted extensive data analysis to evaluate market risks and expected returns.
Languages
English
Full Professional
Timeline
Data Analyst
Marsh McLennan
01.2022 - 08.2023
Team Lead HR
Pacific, an Accesshealthcare Company
07.2018 - 12.2021
Graduate Certificate - Research Analyst
Humber College
Graduate Certificate - Business Analytics
Conestoga College
MSc - Finance
National University of Ireland
BBA -
Lovely Professional University
Similar Profiles
Sean MaherSean Maher
Reinsurance Claims Accounting Analyst II at Marsh McLennanReinsurance Claims Accounting Analyst II at Marsh McLennan
John M. KernJohn M. Kern
Commercial Lines Account Executive, Team Lead at Marsh & McLennanCommercial Lines Account Executive, Team Lead at Marsh & McLennan
Tyson PorlasTyson Porlas
Personal lines client manager at Marsh & McLennan MMAPersonal lines client manager at Marsh & McLennan MMA