Christopher Light

Senior Business Systems Analyst

Healthcare data • SQL and data warehousing • Business intelligence • Data quality

Roseville, Californiacplight1@proton.me916-524-9449

Profile

Business systems analyst with experience translating stakeholder needs into ETL specifications, testing BI deliverables, and improving data quality across healthcare payer, insurance, and public agency environments. Works with Oracle and SQL Server data, reporting teams, and business partners from requirements through release.

Areas of expertise

Business intelligence & dataAdvanced SQL, Oracle, SQL Server, data warehousing, data marts, ETL requirements, data governance, data quality, data validation, BI testing and QA, reporting requirements, and requirements analysis
Delivery and qualityHealthcare specification gap analysis, ETL specifications, business and technical documentation, process documentation, and stakeholder collaboration
Systems and toolsCognos, Power BI, Excel, Power Query, Informatica validation, SSMS, TOAD, SQL Developer, Confluence, Jira, PowerShell, Smartsheet, and SharePoint
Domain experienceHealthcare payer and APCD data, insurance, and public agency records
CybersecurityDomain and vulnerability scan evaluations, CVE and threat communication, endpoint protection, security hardening recommendations for SCADA, PLCs, and VNC, access control for confidential records, cybersecurity training, and coordination with cyber liability insurers

Professional experience

Senior Business Systems Analyst

Western Health Advantage · Sacramento, CA

  • Research and extract data from Oracle data warehouses and Microsoft SQL Server using advanced SQL.
  • Support data pipelines, marts, and reporting for regulatory, operational, and financial analytics.
  • Translate business requirements into ETL specifications and analyze gaps in healthcare specifications.
  • Set quality standards, test BI developer work before release, and validate data accuracy.
  • Document processes, mentor junior analysts, and coordinate with stakeholders, BI developers, IT teams, and project managers.

View full job description →

Business Data Analyst

ACWA JPIA · Roseville, CA

  • Developed SQL Server and Cognos queries and ad hoc reports for executive reporting and insurance operations.
  • Managed a two-year migration of the property database to a new software solution.
  • Administered access to more than 10,000 confidential records for 400 public agencies.
  • Calculated replacement costs for member agency property with insurable values exceeding $13 billion.
  • Evaluated vulnerability scans and cyber risks; coordinated with agencies, insurers, IT providers, and CISA on security and disaster recovery planning.
  • Used QGIS, ArcGIS, and CPUC data to map wildfire risk in California; created PowerShell scripts, tutorials, and operating procedures.

View full job description →

Data Analyst

ACWA JPIA, via River City Staffing · Roseville, CA

  • Maintained agency property data, calculated insurable values, and developed Cognos and Excel reports.
  • Gathered requirements, analyzed root causes, improved business processes, and trained Member Services staff.

View full job description →

Earlier experience

Sales leadership, business development, software sales, and enterprise IT operations

Credentials and training

Certifications: CompTIA Security+, CompTIA A+, Microsoft Technology Associate Database Fundamentals, Microsoft Office Specialist Excel 2016 Core Data Analysis.

Additional training: CompTIA Linux+, business and data analysis, SQL Server administration, SQL data models and data warehousing, advanced Excel, Python, Power BI, and C++.

Previous MCSA Windows and CompTIA Network+ credentials are expired.

Education

Bachelor of Science · Frostburg State University
English Literature major, Computer Science minor · National English Honor Society