Jonathan Bernard
RapisardaTreasury · SAP Finance · Applied AI
jrapisarda@bioinfosolutions.com
github.com/jrapisarda · linkedin.com/in/jrapisarda
Professional Foundation
Enterprise data and AI architect with more than 20 years spanning treasury, SAP finance transformation, data engineering and applied AI. Connects accounting and business workflows to system design, migration, governance and delivery. Leads AI-assisted engineering with explicit requirements, technical review, testing and traceable evidence — every claim in this record is backed by a private evidence file.
Career Experience
Founder & AI Solutions Architect
- Lead end-to-end architecture for agentic AI, LLM applications, retrieval-augmented generation and clinical-data integration; own requirements, technology selection and delivery acceptance.
- Delivered a three-product clinical-intelligence platform — ambient AI documentation, clinical-insight agents, Da Vinci/FHIR prior authorization — on a governed FHIR/HL7 Snowflake layer; production EHR integration in four months.
- Architected the OneTouch EHR clinical-intelligence data platform on Snowflake (Business Critical): four-database governance design separating landing, PHI vault, clinical star schema and physician-feedback stores; surrogate-key patient crosswalk with six dynamic masking policies (SSN, DOB, name, phone, email, address) and role-based access control.
- Built the AI layer in-warehouse: Snowpark Python FHIR bulk/incremental ingestion, a 16-procedure transformation engine to a clinical star schema, Cortex Search RAG with PII redaction before indexing, and a Cortex Agent clinical assistant (orchestrated on Claude) with six governed tools spanning care gaps, risk stratification, quality measures and panel analytics — 5,445 lines of SQL/YAML including an 895-line clinical semantic model.
- Architected deltaCMS, a single-sample colorectal cancer molecular-subtype classifier; recorded five-cohort benchmark of 1,356 correct across 1,440 samples (94.2% pooled) — a research benchmark, not a claim of independent clinical validation.
- Led an agent-orchestrated biomarker-discovery pipeline for a European pharmaceutical joint venture; prioritized candidates advanced into the sponsor's Phase 2 program.
- Directed quantum machine-learning research into higher-order gene interactions in oncology.
- Set architecture and product direction for an AI development team with agents responsible for implementation, independent technical review, tests and integration; repeatable acceptance criteria and evidence-preserving handoffs.
Founder & AI Engineer / Architect
- Built and deployed classification models, RAG and agentic workflows for SMB clients, with versioning, evaluation harnesses and model monitoring.
- Designed FastAPI/Flask services on the OpenAI API with Qdrant, Weaviate and Pinecone vector stores for semantic search and AI document processing.
- Architected a bioinformatics gene-expression warehouse: star schema, Python ETL, 50M+ precomputed gene-pair correlations with false-discovery-rate statistics.
- Developed and led an applied-AI literacy curriculum for a cohort of 45+ technologists and bioinformatics students.
Chief Executive Officer
- Founder-led neuro-AI therapy venture operated within the concurrent portfolio; corporate stewardship, product direction and clinical-adjacent data governance.
Chief Technology Officer
- Led R&D of AI/ML products on Microsoft Azure spanning model development, training, assessment and deployment.
- Directed customer data-management strategy, translating business requirements into product capabilities.
- Led distributed engineering teams delivering AI and data products against shared roadmaps.
Senior SQL BI / ETL Developer
- Owned SSIS architecture across multiple source systems; standardized ETL patterns.
- Improved data quality and interoperability for master data management through consistent integration design.
Senior Technical QA Analyst — Data
- Defined QA strategy for Informatica workflows and mappings; authored an Agile SDLC with executive sign-off.
- Built T-SQL suites for data, functional and performance testing.
Operational DBA
- Automated 20+ Pentaho ETL jobs at 99.9% job success across MySQL and PostgreSQL.
- 98.2% improvement in Pentaho ETL job efficiency; application performance up ~219%; Severity-1 incidents down ~70% year over year.
Senior Business Analyst
- Tested borrower-data masking and performed database mapping on a bespoke Java/SQLite application; HUD-related mortgage context.
Progressive Roles: BSA → Systems Owner → SAP Finance Lead → Data Team Manager
- Business systems analysis: configured and tested intercompany transaction posting in Axapta Financials.
- Technical ownership: Axapta and SharpOWL — backend SQL updates, new-company setup, production deployments; administered Citrix servers and web portal.
- SAP R/3 Finance Functional Lead (Vanguard, 2010): interpreted intercompany accounting, chart-of-accounts, profit-center and cost-center requirements; configured the project demonstration from scratch after seven days of advanced SAP training, supporting continuation with Cognizant.
- Data team management: led Finance and Data Conversion consultant teams; managed migrations through completion of Vanguard R1 — IHS Circle of Excellence Award, 2011.
- Led legacy migration from eight source systems; improved ERP performance ~90% through security re-architecture.
Senior Accounting Manager — Trust
- Managed treasury operations for 32 subprime auto-loan pools of ~$25M each — ~$800M aggregate loan value.
- Reconciled cash to deposits, managed overnight cash sweeps and balanced the general ledger under 14-day pool payment cycles.
- Supported NCUA-related compliance work; reconciled third-party insurance claims for a reinsured product.
- Supervised two direct reports; automated manual transaction posting with Paradata macros on Oracle R11i.
Chief Technical Architect Concurrent Venture
- Designed and built an experimental language-model search prototype for blind users: neural-network methods, semantic indexing, web data acquisition.
- Implemented a semantic store and n-gram indexing with Microsoft SQL and web crawling.
Selected Engineering Portfolio
OneTouch Clinical Intelligence — Snowflake platform
Governed clinical data platform: PHI vault with surrogate-key crosswalk and six dynamic masking policies, FHIR/HL7 ingestion (Snowpark), 16-procedure star-schema transformation engine, Cortex Search RAG with pre-index PII redaction, Cortex Agent clinical assistant with six governed tools, scheduled task orchestration and physician-feedback learning store; 895-line clinical semantic model (care gaps, risk tiers, quality measures).
deltaCMS — Colorectal-cancer analytics
Single-sample subtype classification, cohort evaluation and biomedical data processing. Recorded pooled benchmark: 94.2% across 1,440 samples (research benchmark).
BioInfo AI Studio
Source-linked knowledge transfer with exact source locators, content hashes, authorization metadata and revision/export integrity; qualified local ASUS GX10 adapter.
BSI Pricing Model / Auditkit
Canonical data staging, source-linked report verification, data-quality diagnostics and configurable pricing analysis.
Nexus & Keystone
Multi-agent research, citation checks, cost accounting and explicit verification gates for controlled engineering workflows.
Sepsis GEO ML & ROSIE AI
Biomedical research pipelines and client AI work; commercial delivery retained in the private evidence record.
JR Base OS / GX10 Tooling
Versioned local provisioning, loopback-only workstation integration, installation/recovery documentation and tested adapter lifecycles.
Technology & Domain Inventory
Finance & ERP
SAP R/3 FI/CO, chart of accounts, intercompany accounting, profit/cost centers, LSMW, Axapta, Oracle R11i, treasury, reconciliations, data conversion and migration.
Data Engineering
SQL Server, PostgreSQL, MySQL, Snowflake (Cortex Agent, Cortex Search, Snowpark, dynamic masking, tasks), SSIS, SSRS, Pentaho, Informatica, dimensional modeling, data quality, governance, XML, source-linked reporting.
Applied AI & Research
Neural networks, language models, RAG, multi-agent orchestration, semantic search, graph analytics, model evaluation, PyTorch, scikit-learn, XGBoost, LightGBM.
Platforms
Python, FastAPI, Flask, Node.js, React, Next.js, TypeScript, Rust, Tauri, Streamlit, Azure, AWS, Docker, Kubernetes, CI/CD, Git.
AI Frameworks
LangChain, CrewAI, AutoGen, OpenAI Agents SDK, Pydantic AI, Neo4j, Qdrant, Weaviate, Pinecone.
Industry Context
Accounting & finance, SOX controls, HIPAA-aware data handling, FHIR/HL7 & EHR integration, genomics, SCADA, mortgage/HUD, digital marketing.
Education & Development
MBA · B.B.A., Accounting and Finance · MIS training
Advanced hands-on SAP configuration training, Chicago (seven days; no certification claimed)
IHS Circle of Excellence Award — Vanguard program