RAFAEL C.
DELGADO

• Built an AI-assisted financial intake pipeline that extracts, validates, and routes invoice and purchase order data into accounting workflows.
• Designed rule-driven pricing matrix overriding fixed profit logic based on product price tiers, with deterministic rounding and separation of canonical vs computed pricing.
• Implemented time-window controls across Accounts Payable and Accounts Receivable workflows with idempotent safeguards for audit consistency.
• Engineered high-speed PDF → structured data ingestion system with validation rules to ensure financial data accuracy.
• Designed and optimized self-referential chart-of-accounts schema (parent/subaccount model) with targeted indexing for fast traversal and aggregation.
• Implemented Stripe subscription billing and automated AR ledger generation ensuring transactional integrity across the billing lifecycle.
• Reconciled payment data across Clover POS, internal systems, and QuickBooks, improving financial visibility and reducing discrepancies.
• Designed scalable backend APIs and data pipelines emphasizing correctness, observability, and performance.

• Engineered high-throughput background processing pipelines handling tens of millions of records using Redis-backed Sidekiq workers.
• Reduced multi-second query paths (~30s) to sub-second latency through targeted index redesign, execution-plan analysis, and access-path optimization.
• Designed idempotent job workflows and concurrency safeguards to prevent duplicate processing of financial and transactional data.
• Implemented priority-segmented queue architecture (critical / important / default) with dedicated worker pools, improving SLA reliability.
• Tuned Sidekiq concurrency, bulk enqueue, and batching strategies to increase queue throughput under heavy load.
• Built and maintained OpenSearch indexing pipelines supporting 40M+ searchable records with near-real-time ingestion.
• Partnered cross-functionally with Product and GTM to deliver data-heavy features in a fast-moving startup environment.

• Designed and implemented scalable backend services and REST APIs supporting high-volume transactional workloads.
• Diagnosed and resolved database performance bottlenecks through query refactoring, composite indexing, and query-plan optimization.
• Investigated complex production incidents and implemented durable fixes to improve system reliability.
• Mentored junior engineers and enforced structured code review practices.
• Contributed to system architecture decisions focused on long-term scalability and predictable performance.

• Led Ruby on Rails development initiatives delivering scalable web solutions aligned with dynamic business needs.
• Applied Test-Driven Development (RSpec) to ensure long-term code reliability and maintainability.
• Enforced CI/CD and code review practices supporting consistent deployments.
• Proactively monitored application health using AppSignal and resolved production issues.
• Mentored team members and served as technical liaison with clients.

Manager of technical department for digitalization and optimization of business processes. Platform architect between City Hall and State Government, designed and developed business process platforms.

Managed IT infrastructure across multiple branches (California, Miami, Puerto Rico, Mexico). Developed ERP systems, implemented Twilio SMS platform, and created B2C platform using Ruby on Rails.