Database Analyst | SQL Developer | Healthcare IT Specialist

15+ Years Database Expertise | EZ-CAP Systems | Healthcare Data Integration | Available for Remote Roles

Get In Touch LinkedIn Articles GitHub

Professional Summary

Database and application support professional with 15+ years of experience in healthcare IT operations. Specialized in SQL development, database administration, and healthcare data systems including EZ-CAP, HEDIS measures, and Medicaid claims processing. Currently expanding skillset into full-stack web development to complement database expertise.

Core Competencies: SQL Development • Database Administration • Healthcare Data Systems • EZ-CAP/EDI • SSRS/SSIS • UAT Management • Vendor Coordination • Data Quality • Process Improvement • HIPAA Compliance

Currently seeking: Remote database analyst or SQL developer role in healthcare IT

Why Hire Me?

15+
Years in Healthcare IT
100%
EZ-CAP Expertise
8
Major Healthcare Orgs

🎯 What Sets Me Apart

  • ✓ Deep EZ-CAP Knowledge: 15+ years as Subject Matter Expert - I know this system inside and out
  • ✓ Bridge Builder: Translate technical complexity into simple terms for stakeholders at all levels
  • ✓ Problem Solver: Reduced incident resolution times while supporting thousands of daily patient records
  • ✓ Collaborative: Proven track record working with offshore teams, vendors, and cross-functional departments

Technical Skills

Database & Development

  • SQL Server, T-SQL
  • Stored Procedures
  • Database Design
  • Query Optimization
  • Backup/Recovery
  • Data Migration
  • ETL Processes

Reporting & BI Tools

  • SSRS (SQL Server Reporting Services)
  • SSIS (SQL Server Integration Services)
  • Crystal Reports
  • Ad-hoc Reporting
  • Data Warehousing

Healthcare Applications

  • EZ-CAP (Subject Matter Expert)
  • EDI Processing
  • HEDIS Measures
  • Medicaid Claims Systems
  • PCG, DataWing, WebStrat

Web Development

  • HTML5/CSS3
  • JavaScript (ES6+)
  • Node.js & Express
  • MySQL/PlanetScale
  • Responsive Design
  • Netlify Deployment
  • RESTful APIs

Tools & Technologies

  • Microsoft SQL Server
  • UAT Environment Management
  • Microsoft Visio
  • Git Version Control
  • VS Code
  • Postman

Documentation & Design

  • Microsoft Visio
  • Adobe Creative Suite
  • Technical Documentation
  • Process Documentation
  • Training Materials

Additional Competencies

  • Vendor Management
  • Incident Management
  • User Training
  • Cross-functional Collaboration
  • HIPAA Compliance

Certifications & Credentials

Healthcare IT Certifications

  • EZ-CAP 6X Certified
  • EZ-CAP 5X Certified
  • Data Elements Certified
  • Crystal Reports Certified

Compliance & Governance

  • HIPAA Compliant Data Management
  • Healthcare Data Governance
  • Protected Health Information (PHI) Handling
  • Healthcare IT Security Best Practices

Healthcare Systems Experience

  • EZ-CAP System Specialist (15+ years)
  • Healthcare Database Architecture
  • Clinical Data Integration
  • Multi-Facility Data Coordination

Recent Projects

Expanding my skillset by building full-stack web applications. Still learning, but enjoying the journey from database backend to complete web solutions.

Unbreakable Password Generator

HTML5 CSS3 JavaScript Crypto API Offline-First Open Source

Offline-first password generator built on zero-trust principles. Generates cryptographically secure passwords without ever touching the internet. 100% client-side JavaScript—no servers, no logging, no data collection.

Impact

Open-source project demonstrating security-first development and cryptographic implementation. Zero server dependencies ensure complete user privacy.

Status: ✓ Completed

Portfolio Website

HTML5 CSS3 JavaScript Responsive Design Netlify

Custom-built portfolio site featuring responsive design, mobile-optimized navigation, and analytics integration. Built from scratch to showcase technical skills and professional experience.

Impact

Mobile-first design with strategic navigation improvements. Analytics-driven UX optimization to reduce bounce rates and improve recruiter engagement.

Status: ✓ Live

Compound Central Pharmacy

HTML5 CSS3 JavaScript Mobile-First Client Project

Mobile-responsive site for compounding pharmacy serving healthcare professionals and patients. Currently live and facilitating customer inquiries and prescription orders.

Impact

Delivered production-ready mobile experience for active healthcare business. Mobile-first approach ensuring accessibility for healthcare providers on-the-go.

Status: ✓ Mobile Live | ⚠ Desktop In Progress

Peptide Sciences 101

HTML5 CSS3 Educational Research Phase

Educational resource site about peptide research. Currently on hold while researching legal/regulatory compliance requirements for health-related content.

Status: ⏸ On Hold (Legal Review)

Learning in Public: I'm a database expert expanding into full-stack development. These projects represent real work as I build my web development skillset alongside my 15+ years of database expertise.

Professional Experience

Freelance

Web Developer & Personal Trainer (Self-Employed)

Orange County, CA (Remote)

Aug 2025 - Present
  • Completed web development contracts building custom applications using Node.js, Express, MySQL (PlanetScale), HTML/CSS, and JavaScript
  • Developed full-stack web applications with RESTful APIs, database integration, and responsive front-end designs deployed via Netlify
  • Self-taught web developer applying database expertise to modern web technologies and cloud platforms
  • Providing personal training services while maintaining and expanding technical skillset through freelance projects
  • Currently completing SQL Fundamentals certification (Coursera) to refresh and formalize database skills

AltaMed Health Services / AlturaMSO

Sr. Database Analyst

Los Angeles, CA (Hybrid)

Mar 2020 - Jul 2025
  • Partnered with stakeholders across all organizational levels to evaluate, recommend, and implement technical solutions aligned with business objectives and healthcare compliance requirements
  • Streamlined incident management workflows, reducing resolution times and minimizing downtime across critical healthcare applications supporting thousands of daily patient records
  • Served as primary point of contact for external applications and databases integrated with EZ-CAP (PCG, DataWing, WebStrat); coordinated vendor communication for issue resolution, system patches, and upgrades
  • Performed SQL Server monitoring, backup/recovery strategies, user security management, and database performance optimization
  • Developed and enhanced SQL scripts, stored procedures, triggers, and jobs to support operational workflows and reporting requirements
  • Created comprehensive technical documentation including process flows (Microsoft Visio), user guides, and standard operating procedures for EZ-CAP system and database workflows
  • Led management and scheduling of all User Acceptance Testing (UAT) environments using SQL; ensured data integrity during each testing cycle
  • Managed all EZ-CAP configuration, installations, patches, hotfixes, support, training, and version upgrades

Southern California Physicians Managed Care Services

Sr. Database Administrator

San Diego, CA

Apr 2019 - Aug 2020
  • Managed database servers including SQL Server monitoring, backups, security, and script development
  • Administered EZ-CAP/EDI system including configuration, patches, support, and training
  • Created custom data load formats for third-party software integration
  • Developed ad-hoc triggers, jobs, and stored procedures upon request

AltaMed Health Services

Analyst, Database Applications

Monterey Park, CA

Jun 2018 - Jun 2019
  • Collaborated with staff to evaluate, recommend, and analyze database solutions supporting business requirements
  • Served as point of contact for third-party applications/databases integrated with EZ-CAP (PCG, DataWing, WebStrat); worked with vendors to troubleshoot issues and apply patches/updates
  • Led maintenance and scheduling of UAT environments using SQL; ensured data integrity and proper refresh cycles
  • Performed standard DBA tasks including SQL Server monitoring, backups, security, and script development

Golden State Medicare Health Plan

PM Data & Analytics / Call Center Manager

Seal Beach, CA

Mar 2017 - Jun 2020
  • Managed all database servers including SQL Server monitoring, backups, security, and report generation
  • Administered EZ-CAP/EDI system: configuration, installations, patches, hotfixes, support, training, and upgrades
  • Served as one of two responsible for submitting all data for HEDIS measures (monthly and quarterly)
  • Created custom data load formats for various third-party software applications
  • Developed ad-hoc triggers, jobs, and stored procedures to support operational needs

* Full-time Mar 2017 - Jun 2018; Consulting Jun 2018 - Jun 2020

SynerMed

Database Application Analyst

Monterey Park, CA

Mar 2015 - Jan 2017
  • Collaborated with cross-functional teams to evaluate database solutions and support third-party applications integrated with EZ-CAP
  • Maintained and scheduled UAT environments; ensured data integrity and proper refresh cycles

* Company closed operations in Jan 2017

Citra Health Solutions

Sr. Client Support

Valencia, CA

Oct 2012 - Mar 2015
  • Supported EZ-CAP application and integrated third-party applications including installations, database maintenance, and system configurations
  • Provided customer training via WebEx and GoToMeeting; collaborated with overseas development team (Inteq Solutions, Hyderabad, India)
  • Developed training materials and technical documentation to support knowledge transfer

Orange Health Solution

Sr. Client Support

Valencia, CA

Jan 2011 - Oct 2012
  • Provided technical support for EZ-CAP and integrated healthcare applications; managed client communications and troubleshooting
  • Supported database maintenance, system configurations, and training documentation

What Colleagues Say

"

James has an incredible ability to break down complex EZ-CAP issues and explain them clearly. His expertise saved us countless hours and prevented major production incidents.

"
TM
Tech Manager
Healthcare Organization
"

Working with James on database integration projects was seamless. He communicates effectively with both technical and non-technical stakeholders.

"
PM
Project Manager
Managed Care Services
"

James is the go-to person for EZ-CAP questions. His documentation and training materials made onboarding our team much smoother.

"
DL
Department Lead
Health Plan
"

I highly recommend James. Exceptional customer service, technical and a good team player.

"
VP
Vice President of Analytics
AltaMed Health Services

Ready to Strengthen Your Healthcare IT Team?

Looking for a database analyst with 15+ years of healthcare IT experience, EZ-CAP expertise, and a proven track record across multiple major healthcare organizations?

Let's Connect Download Resume