Summary
Overview
Work History
Education
Skills
Timeline
Generic

Alexander Boucher

Business Data Analyst
Somerdale,NJ

Summary

Analytical Data Professional with expertise in data analysis, reporting, and system design. Delivers actionable insights through effective data visualization and reporting tools. Collaborates across teams to adapt to evolving requirements while maintaining data accuracy and integrity using SQL and Excel.

Overview

11
11
years of professional experience

Work History

International Data Reporting Analyst (Contract via The Judge Group)

VANGUARD
03.2026 - Current
  • Developed recurring reports using Excel, SQL (AWS Athena), and Tableau dashboard data for international stakeholder decision-making.
  • Validated portfolio performance data and resolved discrepancies to maintain reporting accuracy and consistency.
  • Liaised between business and technical teams to meet data reporting optimization standards and enhance reporting accuracy.
  • Update requirements and procedural documentation in line with shifting client needs.

Technology Business Analyst II – Fortune 500 Company Contract

CONDUENT
05.2020 - 05.2025
  • Wrote and optimized complex SQL queries to collect, analyze, and integrate healthcare benefits datasets into stakeholder reports.
  • Trimmed 2.5 days of a 6+ day Annual Summary Report by converting resources from Oracle to SQL Server.
  • Created Excel data reports using formulas and pivot tables to display and analyze business trends for our client.
  • Cleaned data and provided RCA (Root Cause Analysis).
  • Conducted programming & testing (UAT; QA testing; Unit testing; Black box & Regression testing) of backend Visual Basic coding, data mining and modeling as needed.
  • Analyzed operational data to identify process gaps and recommend workflow improvements of projects in JIRA using Agile methodologies.
  • Gathered IT and business requirements, translating stakeholder needs into technical specifications cross-functionally.
  • Coordinated with multiple teams to facilitate HR Payroll conversion from PeopleSoft to WorkDay, ensuring seamless transition and minimal disruption.
  • ETL: Created and loaded batch files containing large numbers of records, debugging and testing file interfaces.

Medical Benefits Analyst – CWA

CAMDEN COUNTY SOCIAL SERVICES
09.2018 - 05.2020
  • Coordinated with employee representatives and employer stakeholders to renegotiate cost sharing of healthcare premiums.
  • Interpreted benefits policies to determine eligibility and maintain compliance with county social services requirements and state law.
  • Calculated cost-benefit analyses and cost sharing redistributions via Excel formulas and spreadsheets.
  • Created and reviewed contract documentation for accuracy, completeness, and timely benefit redeterminations.
  • Delivered speech presentations at employee meetings to inform of health benefit options and contract negotiation efforts.

Human Service Specialist II

CAMDEN COUNTY SOCIAL SERVICES
04.2017 - 05.2020
  • Processed welfare enrollments for ACA Medicaid, SNAP, and TANF to assess appropriate social service needs.
  • Verified eligibility and maintained accurate case documentation in compliance with HIPAA, CMS, Social Security, and agency standards.
  • Assessed client needs and coordinated appropriate social service referrals
  • Determined program eligibility and maintained accurate case documentation
  • Interviewed applicants to gather household, income, and support information

Health Benefits Analyst & Manager Escalations – Fortune 500 Company Contract

CONDUENT
07.2015 - 03.2017
  • Resolved complex health benefit issues (medical, dental, prescription, vision, Medicare, FSA, COBRA, and LTD) with precise plan interpretation.
  • Administered health, welfare, and retirement benefits inquiries through fast-paced HR service center workflows.
  • Managed Medicare Advantage and Medicare Supplemental plan enrollments, complying with CMS and SSDC.
  • Coordinated open enrollment and qualifying life events (QLE), complying with HIPAA, PPACA, COBRA, FMLA, ADA, and ERISA.
  • Remediated critical escalations made to third party entities and corporate executives.
  • Triaged and liaised urgent updates among policy holders, health insurance carriers, vendors, and service providers.

Education

Bachelor of Arts - Applied Communications

CEDARVILLE UNIVERSITY
Cedarville, OH
05.2001 -

Skills

  • Data Analysis
  • ETL Development
  • PL/SQL and AWS SQL
  • Oracle Database Management
  • JIRA Agile Methodology
  • Testing methodologies
  • Business Analysis
  • Requirements Gathering
  • Microsoft Excel, PowerPoint, Outlook
  • Data modeling
  • Customer Relationship Management
  • Oral and written communication

Timeline

International Data Reporting Analyst (Contract via The Judge Group)

VANGUARD
03.2026 - Current

Technology Business Analyst II – Fortune 500 Company Contract

CONDUENT
05.2020 - 05.2025

Medical Benefits Analyst – CWA

CAMDEN COUNTY SOCIAL SERVICES
09.2018 - 05.2020

Human Service Specialist II

CAMDEN COUNTY SOCIAL SERVICES
04.2017 - 05.2020

Health Benefits Analyst & Manager Escalations – Fortune 500 Company Contract

CONDUENT
07.2015 - 03.2017

Bachelor of Arts - Applied Communications

CEDARVILLE UNIVERSITY
05.2001 -
Alexander BoucherBusiness Data Analyst