• Automated daily ETL processes using complex SQL, PowerShell, and Python, reducing manual tasks for the bank. • Led migration of local databases to AWS, troubleshooting on Redshift and Snowflake, and liaising with IT for solutions. • Developed and version-controlled SQL/Python scripts using Git. • Enhanced database performance by monitoring execution times and optimizing queries. • Built an NLP-based fraud detection model for analyzing payment messages. • Delivered ad-hoc projects including SWIFT data parsing, QA sampling, country identification, activity tracking, and repeat offender monitoring. • Trained compliance team members on code logic and structure.

• Created weekly/monthly transaction monitoring reports from 10,000+ daily transaction data.• Visualized the results using Tableau and Excel VBA to create insightful dashboards and pivot tables.

• Monitored transactions according to OFAC and MOFA practices. Recorded Suspicious Activity Report (SAR) to support AML process and prevent any suspected or known criminal violations or suspicious activity.• Processed remittances according to high-time-pressure schedules; assisted business clients sending large international payments of up to 2 billion dollars; accepted other banks’ transactions serving as an intermediary.• Coordinated activities between Corporation Business teams and offshore branches for domestic currency reimbursement project worth $200,000 per month in revenue.

• Constructed a labor insurance premium calculator using MS Excel VBA to improve work efficiency.• Analyzed and amended contracts returned by governmental authorities to meet regulatory requirements.