William Balsells

Leverage Oracle SQL, Microsoft Access, and Microsoft Excel to query, extract, and join large-scale insurer datasets, performing complex data validation to identify discrepancies in reported information. Developed a VBA Data Validation Macro that optimized the data review lifecycle, reducing manual processing time by 30% (21 days). Lead data projects and participate in the design, testing, and installation of automated data collection systems to improve workflow efficiency.

RESEARCH DATA ANALYST II at CALIFORNIA DEPARTMENT OF INSURANCE (2023-01 – Present)

• Leverage Oracle SQL, Microsoft Access, and Microsoft Excel to query, extract, and join large-scale insurer datasets, performing complex data validation to identify discrepancies in reported information.
• Developed a VBA Data Validation Macro that optimized the data review lifecycle, reducing manual processing time by 30% (21 days).
• Lead data projects and participate in the design, testing, and installation of automated data collection systems to improve workflow efficiency.
• Apply statistical methods to produce comprehensive reports and tables, ensuring data integrity for management needs and research projects.
• Act as a technical liaison to communicate validation findings and project status to insurers and internal stakeholders, maintaining detailed documentation of all technical specifications.

SPECIAL PROJECTS ADMINISTRATOR at AMERICOR (2021-01 – 2023-12)

• Extensively utilized Excel to manage, sort, and distribute high-volume datasets to management and external organizations.
• Designed and maintained Google Data Studio/Google Sheet dashboards to monitor daily departmental operations and key performance indicators (KPIs).
• Managed and updated creditor and settlement data within the CRM system, ensuring data accuracy and high-fidelity documentation for the negotiations team.
• Translated complex project statuses and development issues between technical teams and creditors to ensure seamless implementation of new data protocols.

Masters of Science in Computer Science – GEORGIA INSTITUTE OF TECHNOLOGY (2027-01)

Bachelor of Science in Applied Mathematics & Statistics – CALIFORNIA STATE POLYTECHNIC UNIVERSITY, POMONA (2017-01 – 2021-12)