Home Research Tech Projects Teaching Resume Contact

Career Timeline

Feb 2026 – Present

Senior Salesforce Developer

The Small-Medium Business Help Desk (SMBHD) Chicago, IL

  • Lead a team of four junior developers across multiple concurrent client engagements: conducting discovery sessions, translating business requirements into technical specifications, defining acceptance criteria, and reviewing all pull requests before deployment
  • Drive architecture decisions and present solution designs to client stakeholders through formal readback presentations
  • Architect and deliver complex third-party integrations using layered design patterns and entity-specific services for bidirectional data synchronization
  • Lead developer for ISP Experience Cloud implementation, including custom design to match existing website theme—public buy-flow and customer portal to pay invoices and manage tickets
  • Mentor junior developers through peer-programming sessions, coaching on Apex design patterns, REST/SOAP API integration strategies, and Salesforce best practices
  • Manage project delivery timelines, coordinate cross-functional dependencies, and serve as the primary technical point of contact for client escalations
  • Serve on company AI Commission evaluating tools and defining governance frameworks for responsible AI integration
Oct 2023 – Apr 2025

Lead Salesforce Developer

ASCM Chicago, IL

  • Led the end-to-end architectural design and delivery of a custom bidirectional integration between Salesforce and Maple LMS (Moodle), replacing a fully manual provisioning workflow with 100% automation—reducing fulfillment time from days to seconds
  • Orchestrated technical delivery across multiple external vendors and internal teams: delegated deliverables, defined acceptance criteria and unit testing requirements, and enforced Salesforce best practices
  • Architected a zero-touch fulfillment engine handling over $20mm in annual B2B/B2C sales volume, automating the entire course provisioning and enrollment lifecycle
  • Engineered a rate-limited Asynchronous Apex Queueable Chain pattern to manage the LMS REST API provisioning lifecycle (User Lookup → User Creation → Enrollment), decoupling business logic from transaction boundaries to respect governor limits under high-volume conditions
  • Designed a trigger framework for high-volume B2B roster uploads that intelligently routes bulk requests to deferred Batch Apex while processing individual transactions in real-time
  • Built a custom Lightning Web App providing a real-time integration pipeline dashboard with granular enrollment tracking, failure diagnostics, and automatic retry capabilities
  • Created comprehensive technical documentation and trained cross-functional teams on new systems, workflows, and operational procedures
May 2021 – Feb 2023

Salesforce Developer

CapTech Consulting Richmond, VA (Remote)

Global Chemical Distributor ($17bn+ revenue) — Schema Migration & Digital Transformation

  • Core developer on large-scale Salesforce schema restructuring, redesigning custom object architectures for suppliers, order quantities, and logistics workflows across North American supply chains
  • Developed and optimized Batch Apex jobs to process millions of records—implementing robust error handling, logging, and retry logic to ensure data consistency between legacy and restructured schemas
  • Partnered directly with client data stewards and director-level stakeholders to map complex source-to-target field transformations across chemical classification hierarchies
  • Ensured the integrity of safety-critical data throughout the migration, including hazardous materials transportation compliance and regulatory reporting data

Global Hotel Company ($5bn+ revenue)

  • Built custom Lightning Web Components to automate complex “days of work” calculations for new hotel openings, significantly reducing manual data entry
  • Designed and customized Salesforce Surveys in Experience Cloud with custom Apex backend logic

Additional Consulting Engagements

  • Key member of the proposal-writing team, refining technical sales language, rhetoric, and positioning for contracts and SOWs valued at over $10mm
  • Led client demos at sprint boundaries and worked across distributed Agile/Scrum teams
Feb 2021 – May 2021

Salesforce Developer

Nitel Telecommunications Chicago, IL

  • Developed within a highly unconventional Salesforce org where all business logic—UI behavior, automation, and data processing—was implemented entirely in backend Apex with no declarative automation
  • Diagnosed and resolved chronic CPU timeout errors in production by refactoring inefficient Apex and restructuring SOQL queries, reducing execution time and stabilizing system performance
  • Deepened fluency in Apex execution contexts, bulkification patterns, and CPU/heap profiling under tight governor limit constraints
Jun 2019 – Feb 2021

Salesforce Developer / Administrator

Magnet 360 (Mindtree) Minneapolis, MN

  • Selected for an intensive 100-day Salesforce development bootcamp in India; led the Capstone implementation project
  • Migrated Visualforce pages to responsive Lightning Web Components and converted legacy processes to Flows for a Fortune 500 client
  • Streamlined Salesforce reporting processes within an Agile team, improving operational efficiency by 70%
  • Delivered code in a CI/CD DevOps environment across engagements ranging from assessment and data migration to full implementation

Projects

2026

Salesforce AI Development Skills for Claude Code

Live Demo — One-Shot Experience Cloud Site
  • Three production-grade MCP skills (Apex, LWC/Experience Cloud, Flows) enabling Claude Code to architect and deploy full Salesforce solutions from a single prompt
  • One-shotted a complete Experience Cloud website—custom Lightning theme, guest user access, and Experience Builder configurability—in a single deployment
  • 92 instruction-oriented reference docs (28K+ lines) distilled from official docs, PDFs, and real project patterns via a research-to-distillation pipeline with parallel AI research agents
  • MCP server exposing skills as tools to any AI client (Claude Code, Cursor, Copilot) via BM25 search across all bundled knowledge
2025

CPS Selective Enrollment Admissions Simulation

github.com/andrewdhood/cps_match
  • Monte Carlo simulation in Python modeling 22,000 students across 11 schools
  • MLE recovery of hidden population parameters from truncated distributions

Technical Skills

Apex

Triggers Queueable Batch Future Schedulable Governor Limits SOQL/SOSL

Platform

Sales Cloud Service Cloud Experience Cloud CRM Analytics CPQ Flows DevOps

Web

LWC Visualforce HTML/CSS JavaScript REST APIs SOAP APIs

Languages

Python NumPy Pandas Scikit-learn Matplotlib Flask Java SQL R C/C++ MATLAB

Tools

Postman Git GitHub VS Code IntelliJ Gearset Data Loader SFDX Jira Confluence

Certifications

Platform Developer 1 Administrator AI Associate