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

Building database-driven applications that demonstrate core data architecture skills: secure data handling, workflow automation, and production system deployment.

Unbreakable Password Generator

HTML5 CSS3 JavaScript Crypto API Chrome Extension Open Source
Unbreakable Password Generator interface showing offline operation and zero network requests Unbreakable features: Privacy First, Cryptographically Secure, Fast & Simple, Open Source, Works Everywhere, Zero Trust Unbreakable Password Generator 5-star rating on Chrome Web Store Unbreakable appearing in Chrome Web Store search results with 5.0 star rating

100% offline operation • 5.0★ rating on Chrome Web Store • Zero network requests verified • Discoverable via Chrome search

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. Approved and available on the Chrome Web Store with a 5.0★ rating.

Impact & Features

  • Google-approved Chrome extension with 5-star user rating
  • Cryptographically secure using Web Crypto API with rejection sampling
  • Zero network requests—verifiable via browser dev tools
  • Open source (MIT License) for complete transparency and auditability
  • Cross-platform: Desktop, mobile, tablet on all major operating systems

Status: ✓ Live on Chrome Web Store (5.0★) | ⏳ Apple Safari Coming Soon

Compound Central Pharmacy

HTML5 CSS3 JavaScript Node.js MySQL Database-Driven Client Project
Compound Central admin dashboard showing refill request tracking with status filters Secure admin login interface for Compound Central Pharmacy Compound Central Pharmacy branding and refill request form Prescription refill form with validation and user-friendly interface

Full-stack application with admin dashboard, database backend, and public-facing forms

Database-driven pharmacy management application handling prescription refill requests for active healthcare business. Built complete system including MySQL database, Node.js backend API, secure admin dashboard, and public-facing forms. Production application processing real customer prescriptions with status tracking, authentication, and business workflow automation.

Database & Application Features

  • MySQL Database: Normalized schema for prescription requests, customer data, and status tracking
  • Admin Dashboard: Real-time request monitoring with status filters (Pending/Ready/Picked Up)
  • Secure Authentication: Password-protected admin access with session management
  • RESTful API: Node.js backend handling form submissions, database queries, and status updates
  • Form Validation: Client and server-side validation protecting data integrity
  • Mobile Responsive: Optimized for healthcare providers accessing on mobile devices
  • Business Logic: Automated timestamp tracking and workflow status management

Why Database Architecture Matters Here

This project demonstrates core database analyst skills: schema design, data normalization, query optimization, secure data handling, and building applications that healthcare businesses rely on for daily operations. Similar architectural thinking I apply to EZ-CAP and healthcare claims systems.

Status: ✓ Production Database Application Live

Live site URL withheld to protect active business from spam submissions

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

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