Automated Compliance Reporting Pipeline for Securities Transactions

Create a comprehensive Python script using SQLAlchemy and Pandas that automatically generates regulatory compliance reports by parsing transaction logs, detecting potential anomalies, and producing standardized SEC-compatible XML exports. Implement multi-stage validation checks that cross-reference transaction metadata against predefined compliance rulebooks, with automatic flagging of suspicious activities. Include logging mechanisms that preserve an immutable audit trail of all processing steps.