pro
Simone Santia
Data audits, SQL datasets & reliable workflow automation
New to Contra
Simone is ready for their next project!
Dispatch Guard — data-to-dispatch control room
0
1
Migration Control - every row accounted for
0
1
Member-data audit — synthetic demonstration. A Python exercise reconciles 10 input rows into 6 normalized records and 4 quarantined rows. It standardizes email text and flags malformed addresses, future open dates and conflicting duplicate IDs. Ambiguous records remain visible for review rather than being silently merged or deleted. These are synthetic records; email syntax checking does not prove deliverability.
0
42
SQL join integrity — synthetic demonstration. A SQLite exercise preserves 4 source deals and the 45,000-cent total while a naive association join inflates the sum to 80,000 cents. Ambiguous primary links, missing references and a null amount are surfaced. Equal-value legitimate deals remain distinct; reruns produce identical output. This is a local technical exercise, with no customer data or live HubSpot connection.
2
54