AML INVESTIGATIONS & SQL PORTFOLIO

Follow the evidence.
Explain the decision.

I'm Brandon Candela. My background is in AML transaction monitoring. I build practical work samples that bring investigative judgment to adverse media, sanctions and crypto reviews.

Explore my workView my GitHub profile
Brandon Candela
BRANDON CANDELA · AML PROFESSIONAL
FOUR WORKING DEMOS

From an alert to a reviewable investigation

Try each project in your browser, then inspect the code and methodology. Each tackles a different part of an analyst's workflow.

Showing 4 projects

SQL · IDENTITY COMPARISON

Adverse Media Review Desk

Compare customer details with media subjects, document evidence gaps and preserve reviews for QC.

Try the demo →Code & methodology
What to explore

Compare name, date of birth and location without treating missing data as a mismatch. Review the SQL training rules and evidence summaries.

SANCTIONS · QUALITY CONTROL

Sanctions Review Desk

Investigate possible matches, compare identifiers, track information requests and review an assessment.

Try the demo →Code & methodology
What to explore

Move from party comparison to evidence, assessment and QC. Reviewers can inspect the rationale and request corrections.

CRYPTO · CASE REVIEW

Trace Desk AML Workspace

Review bounded USDT activity with pinned evidence, portable case files and analyst reasoning.

Try the demo →Code & methodology
What to explore

Follow the evidence across a bounded transaction review and preserve the case for another analyst.

ETHEREUM · TRANSACTION TRACING

Trace Desk: USDT Investigator

Explore a saved 15-address Ethereum case with transaction evidence, a relationship graph and a written report.

Try the demo →Code & methodology
What to explore

Inspect transaction hashes, transfer amounts and timing. Consider alternative explanations before drawing conclusions.

SQL YOU CAN INSPECT

Turn evidence into queryable information.

Adverse Media Review Desk uses SQLite / Cloudflare D1 for nine fictional training cases and 27 evidence comparisons. The working SQL connects cases to comparisons, summarizes evidence states and derives training review categories.

Group the fictional training cases by their SQL-derived disposition.

SELECT disposition, COUNT(*) AS case_count
FROM training_triage
GROUP BY disposition;

Code examples for inspection. These controls do not execute queries or screen live customers.

Read the SQL walkthrough and run the queries →

This is a small portfolio implementation, not a claim of production-scale SQL experience. Customer reviews are not stored in the shared training database.

The investigation comes first.

A matching name is a lead. Missing information is not a verified mismatch. My work samples emphasize supporting evidence, alternative explanations, unresolved questions and a clear handoff to QC.

I use AI-assisted development to translate AML workflow ideas into inspectable tools. The projects document their scope and limitations; none makes an automatic finding of wrongdoing.

EXPERIENCE BEHIND THE WORK

Financial crime judgment.
Technology delivery.

My experience spans AML investigations, KYC and enhanced due diligence, SAR quality control, team support and software implementation.

JUN – JUL 2026 · SHORT-TERM CONTRACT

Senior KYC Consultant Banco de la Nación Argentina

Brought in on a short-term contract to help the compliance team ramp up during an audit and heightened review period.

Contributions & delivery

Conducted periodic KYC, CDD and EDD reviews for high-risk clients, including PEPs and diplomatic account holders. Researched sanctions, adverse media and beneficial ownership using Moody’s, World-Check, Nosis and open sources.

Supported compliance reporting and portfolio analysis in Excel, documenting client risk and evidence gaps for the team’s review.

Moody’s · World-Check · Nosis · Excel

AUG 2025 – FEB 2026 · CONTRACT

Senior Anti-Money Laundering Consultant KPMG US

Supported transaction monitoring investigations and SAR quality control across consumer, high-net-worth and business banking portfolios.

Contributions & delivery

Analyzed KYC/KYB records, counterparties, adverse media and transaction behavior across cross-border payments, CTR activity, structuring and cryptocurrency exposure. Maintained investigation records and screening narratives in Actimize and LexisNexis.

Produced SAR-ready narratives and escalation documentation while reviewing supporting evidence and identifying documentation gaps before final disposition. Handled approximately 4–5 investigations daily.

NICE Actimize · LexisNexis · Transaction monitoring · SAR documentation

AUG 2023 – AUG 2025 · CONTRACT

Senior Anti-Money Laundering Consultant IBM Promontory

Supported high-risk private wealth and institutional client reviews across the U.S., LATAM and APAC, rotating through multiple AML functions.

Contributions & delivery

Managed KYC, CDD and EDD reviews covering beneficial ownership, PEP status, sanctions, adverse media and source of wealth. Led and trained more than 20 onshore and offshore analysts using job aids, review checklists and documentation standards.

Partnered with Compliance, QA, Operations and Technology to standardize procedures and improve GenAI-assisted KYC workflows, strengthening review consistency and team handoffs.

GenAI-assisted workflows · QA review · Analyst training · Process improvement

NOV 2022 – APR 2023

Project Manager Sodexis

Managed three concurrent global software implementation projects involving developers, business stakeholders and offshore teams.

Contributions & delivery

Led Agile sprint cycles and maintained Jira and Monday.com trackers, timelines and delivery milestones. Translated business requirements into functional specifications for Odoo ERP modules spanning CRM, Accounting, HR, Sales and Manufacturing.

Coordinated user acceptance testing and post-go-live handoff documentation, carrying requirements through implementation and operational transition.

Odoo ERP · Jira · Monday.com · Agile · UAT

FEB – SEP 2022

KYC Analyst Deutsche Bank

Supported KYC and AML reviews for international clients with complex ownership and cross-border activity.

Contributions & delivery

Coordinated client outreach, validated identity and beneficial ownership, and reviewed financial documentation including 10-K filings and Form ADV to assess customer risk.

Completed more than 20 reviews per month and synthesized findings into investigative summaries supporting risk decisions and regulatory documentation.

KYC / CIP / EDD · Ownership research · Financial document analysis

FEB 2021 – FEB 2022

Investment Operations Analyst Bank of New York Mellon

Supported institutional fund operations involving capital calls, redemptions and distributions.

Contributions & delivery

Coordinated with general partners, limited partners and counterparties to process transactions, reconcile exceptions and resolve discrepancies. Used Excel reporting to support operational review.

Managed more than $45 million in monthly transaction activity and maintained clear records supporting transaction accuracy and transparency.

Excel · Reconciliation · Fund operations · Exception management

Event production & bilingual communication

As a freelance production manager from May 2023 to January 2026, I supported international events including CES, InfoComm, FIME and Xponential, coordinating clients, exhibitors and technical teams in English and Spanish.

View full experience on LinkedIn →

TECHNOLOGY & ANALYTICAL SKILLS

Tools connected to practical work.

My résumé includes NICE Actimize, LexisNexis, CLEAR, Thomson Reuters, DDIQ, Moody’s RDC, Compliance Link, Aladdin, Excel and SQL. The experience above connects tools to specific roles where documented.

For a concrete SQL work sample, explore the portfolio’s SQLite queries, joins, CTEs and evidence summaries. The project demonstrates independent implementation rather than a claim about an employer’s database environment.

Explore the SQL examples →
CREDENTIALS & LANGUAGES

AML, risk and delivery.

CAMS

Certified Anti-Money Laundering Specialist

ACAMS
CRISC

Certified in Risk and Information Systems Control

ISACA
SIE

Securities Industry Essentials exam

FINRA · Exam credential, not a securities license
English + Spanish

Bilingual communication

Client conversations, stakeholder coordination and international events
Project management & Agile credentials previously earned

CAPM: Certified Associate in Project Management, Project Management Institute. Earned March 2023.

CSM: Certified ScrumMaster, Scrum Alliance. Earned March 2023.

View credential details on LinkedIn →

BUILDING COMMUNITY IN WYNWOOD

Bringing Miami's
tech community together.

I host a monthly tech networking event in Miami's Wynwood arts district, bringing together software engineers, cybersecurity professionals, founders, business owners and ecommerce entrepreneurs.

Attendees pitch their products, share ideas and build relationships. I bring people from different disciplines into the same room to talk about what they are building and where Miami's technology scene is headed.

50–100attendees per eventMonthlyproduct pitches · new connections · growing attendance

Part of Wynwood's next chapter

The event takes place near 545wyn, whose tenants include Gemini, Sony Music and Gensler. Nearby, reporting on Ken Griffin's proposed acquisition of the roughly 30-acre Mana Wynwood site points to potential technology or education uses, with parts of the transaction reportedly still pending. It is an exciting setting for conversations about Miami's future.

545wyn context ↗ · Mana Wynwood reporting ↗ September 2026 · Neighborhood context; no company sponsorship or affiliation implied.

Let's talk AML, investigations and data.

Role interests: AML investigations, crypto compliance, AML management and financial crime roles, including financial crimes QC, compliance operations, payments compliance and digital assets AML/KYC. Open to remote opportunities and roles in New York, NY.

Interested in my experience or a walkthrough of the projects?

Contact Brandon on LinkedInEmail Brandon

Brandon.d.candela@gmail.com

Explore GitHub