Seoyoon Ham

nformation Analyst Intern @ United Nations | Seeking 2026 Full-time in Risk management/Compliance & Audit | Python, SQL, CPA Eligible

New York, New York, United States

About

Mystery novels and crime dramas have been my closest companions. Genuinely enjoyed spotting anomalies, identifying hidden foreshadowing, and piecing together the truth before anyone else. Today, I have translated that investigative passion into a career focused on uncovering discrepancies within data and mitigating risks in the complex business world. Across my recent professional experiences, "Risk" has been the definitive common theme: • Automotive Retail & Services (Mavis Tire): Supported operational and IT risk management by overseeing enterprise database backup processes through Veer and Idera, while managing employment data across 3,500+ stores in MS SQL Server. Integrated Python-based automation to improve monitoring efficiency and strengthen data reliability. • International Organizations (United Nations): Developed a Conflict Risk Tracking Dashboard focused on the 2025 Iran protests and U.S.–Iran nuclear tensions by synthesizing fragmented geopolitical risk signals into a structured analytical framework. Utilized Power BI, Tableau, and think-cell to visualize escalation patterns, monitor emerging risks, and translate uncertainty into decision-supporting insights. To convey risk signals effectively, I developed fluency in the technical languages —Python, SQL, Java, and C—using coding as a means of systematically detecting anomalies and substantiating findings with objective evidence.

Experience

  • Political affairs : Information Analyst Intern at United Nations
    Oct 2025 - Mar 2026 · 6 mos

    - Performed risk monitoring by cleaning and consolidating multi-source, real-time datasets from relevant UN entities - Cleaned and translated the gathered datasets into pivot tables and dashboards (Power BI, think-cell, PowerPoint) to deliver timely SDG progress for senior leadership briefings - Improved analytical judgment and data evaluation skill by determining relevant datasets to use in a country-specific slide decks. - Applied strong verbal communication skill in weekly team meetings by clarifying data quality control methodology

  • IT Security & Compliance Internal Auditor at Mavis Tire
    Jun 2025 - Sep 2025 · 4 mos

  • Data engineer at dotori
    Mar 2025 - Jun 2025 · 4 mos

    - Extract, clean, normalize college Common Data Sets using Python(pandas, dataframe) and Excel to establish data pipelines. - Use regex expression to extract specific tables, texts, and checkboxes and convert parsed data into JSON files for backend integration. - Conducted web crawling using Selenium and BeautifulSoup to automatically extract dynamically rendered U.S. college rankings from Niche.com and QS Ranking - Build and automate a weighted regression-based scoring system to classify user–school fit to enhance decision support. - Predefined and reused common functions to ensure consistent coding style with co-developers and maintain code readability. - Implemented fallback functions or manually entered data to handle exceptions when extraction failed due to formatting inconsistencies or OCR limitations. - Conduct market and competitor analysis to support strategic planning, business development, financial forecasting. - Collaborate cross-functionally in weekly meetings by sharing current workflows and proposing new product features.

  • Tax Preparer at Volunteer Income Tax Assistance
    Dec 2024 - Apr 2025 · 5 mos

    • Demonstrated strong attention to detail by collecting and handing financial data of 20+ members simultaneously per week • Utilized DrakeTax software to organize W-2, Form 1099, Business expenses, Health Insurance data and conducted quality reviews between co-workers to ensure accuracy • Researched unfamiliar tax and governmental regulations and provided summaries to the tax manager • Led a meeting with members to clarify tax procedures, identify missing documents, and guide them on record tracking for next year • Built strong relationships with taxpayers by listening to their Broadway experiences and post-COVID industry challenges

  • College Leaders At the United Nations, Vice Captain at United Nations
    Nov 2024 - Jan 2025 · 3 mos

    • Designed eco-tourism in Peru to reduce developing countries’ reliance on the primary sector, based on Social Impact Bond- Green Fund model • Redefined “success in economic development” through measurable indicators, demonstrating core internal audit skills in evaluating performance and compliance. • Conducted in-depth analysis of financial regulations, tax policies, and investment impacts to ensure long-term viability • Developed fund allocation plan with NPV analysis and Generative AI insights to optimize sustainable tourism investment • Led the preparation of the Q&A session and persuaded UN officials on the viability and purpose of the profit distribution plan