Data Quality Anal

Riya Pandey

**********@*******.*** https://www.linkedin.com/in/riyapandey731 571-***-****

EDUCATION

American University, Washington, D.C. May 2024

Master of Science; Majystor: Analytics Specialization: Data Science University of Nebraska-Lincoln, Lincoln, NE May 2019 Bachelor of Science; Major: Actuarial Science; Minor: Statistics ACTUARIAL EXAMS

Exam 1: Probabilities (P) March 2021

Exam 2: Financial Mathematics (FM) October 2018

SKILLS

R, SQL, Python, VBA, Power BI, Tableau, Microsoft SQL Server, Predictive Analysis, Machine Learning WORK EXPERIENCE

American University, Washington, D.C.

Data Quality Analyst August 2022 – Present

● Assists in root cause analysis, investigating 2000+ data errors or anomalies, and assists in the implementation of solutions to correct data problems

● Conducts data cleaning, analyzing and testing with SQL (10,000 records per week) to resolve data issues in the CRM, improving data accuracy by 100%

● Performs ETL of 100K+ records from multiple sources in preparation for analysis and reporting, reducing time by 40% for business operations team from data compiling

● Develops and maintains a database in Excel, using VLOOKUP, to identify trends and increase the efficiency of projects

● Deliver actionable insights through the use of data visualization like Power BI National Rural Electric Cooperative Association (NRECA), Arlington, VA Underwriting & Actuarial Analyst August 2019 – July 2022

● Performed post-retirement welfare benefit actuarial valuations and roll-forward disclosures using actuarial software such as ProVal and LynchVal to provide management with statistical findings and conclusions

● Analyzed 30+ medical claims data weekly to identify underwriting patterns that were used for predictive modeling purposes

● Used analytics tools like pivot tables and VLOOKUP in Excel on a daily basis to manipulate large amounts of business data (10,000+) in order to perform analysis

● Assisted in communicating business solutions to maximize risk adjusted profit and developed actuarial reports to help business effectively manage portfolios

● Conducted data analysis, using R, to identify trends and relationships in order to develop actuarial models

● Collaborated with multiple company leaderships to develop strategies based on actuarial findings and recommendations to create client reports

● Supervised 2+ incoming junior analyst on the functionality of multiple statistical tools, ensured they exceed client expectations, and served as a mentor to assist smooth transition to the NRECA family Flagstone Financial Management, Lincoln, NE

Financial Planning Intern May 2018 – December 2018

● Collaborated with the Director of Financial Planning to integrate multiple data sources for each client file to break down bottlenecks in our financial planning business process

● Performed administrative tasks, completed financial market research, and communicated with potential clients

● Utilized advanced Excel to develop detailed spreadsheets to identify trends and develop forecasts for building supplies and usage

● Completed in-depth small business valuations, monitored and analyzed financial data trends, and worked on the development of new financial models

● Investigated investment opportunities, monitored the performance of all portfolio, and reviewed monthly financial statements

Contact this candidate