Open to opportunities

Joan Kowanda

@joankowanda

Message

Detail-oriented finance student skilled in financial analysis and data-driven decisions.

Indonesia

Message

What I'm looking for

I seek entry-level finance roles where I can apply analytical skills, Excel expertise, and clear communication to support financial decision-making and growth.

I am a finance student from Universitas Prasetiya Mulya with strong academic grounding in financial analysis, capital markets, and treasury management. I combine theoretical knowledge with practical internship experience to support business and client needs.

During my HSBC mortgage internship I performed advanced Excel work including pivot tables, what-if analysis, and VBA macros to implement interest-rate changes and optimize lending processes. I also prepared board-level presentations and supported customer communications via EDM and SMS notifications.

I have hands-on experience producing monthly financial statements and advising a small business as part of a community development team, and I contributed extensively to student finance organizations by creating over 100 design and communication assets to improve financial literacy.

My toolkit includes Microsoft Excel, PowerPoint, Bloomberg Terminal, Capital IQ, SPSS, Python, Canva and design tools; I bring analytical rigor, attention to detail, teamwork, and a focus on data-driven problem solving.

Experience

Work history, roles, and key accomplishments

Mortgage Intern

HSBC Indonesia

Jan 2025 - Apr 2025 (3 months)

Performed mortgage data entry and implemented interest rate changes using Excel (pivot tables, what-if analysis, VBA) to optimize lending performance and generate cost savings; prepared presentations for the Board summarizing project outcomes and recommendations.

Microsoft Excel VBA Data Analysis PowerPoint EDM SMS Coordination Financial Reporting

Design Staff

Indonesia Investment Banking Competition

Jan 2022 - Jan 2023 (1 year)

Produced over 54 design assets using graphic tools to convert financial data into visual narratives that increased financial literacy via social media.

Graphic Design Canva Affinity Designer Visual Storytelling Content Production Data Visualization

Creative Design Staff

Finance and Investment Society

Nov 2021 - Nov 2022 (1 year)

Created up to 60 visual communications (feeds, stories, reels, brochures) to raise financial education awareness by translating complex financial topics into accessible designs.

Graphic Design Adobe Photoshop Canva visual communication Content Creation Social Media Design

Finance Advisor (Community Project)

Community Development Finance Division

Feb 2024 - Present (1 year 8 months)

Prepared monthly financial statements (P&L, balance sheet) and collaborated in an 8-person team to provide financial advice to a small business, supporting decision-making and expense management.

Financial Statement Preparation P&L management Financial Analysis Team Collaboration Accounting

Education

Degrees, certifications, and relevant coursework

Universitas Prasetiya Mulya

Bachelor’s Degree, Finance and Banking

2021 - 2025

Grade: 3.33/4.00

Activities and societies: Relevant coursework: Security Analysis, Bond Management, Behavioral Finance, Treasury Management, Financial Management, Derivative Securities, Financial Statement Analysis, Capital Markets, and Investment.

Pursuing a Bachelor’s Degree in Finance and Banking with coursework in financial analysis, capital markets, and treasury management; achieved a 3.33/4.00 GPA over eight semesters.