Ayan Khan

Experience

• 

  Program Council at SMU

  Oct 2022 - now

  • Led all operational efforts of organization across 5 cross-functional teams – managed membership of 86members and integration of $90,000 annual budget • Planned 8 large-scale campus events across 5 cross-functional teams, achieving a cumulative event attendance of 3766 students – led concept development, event logistics, and staffing of 70+ members• Directly managed budgets totaling $17,000 across 2 events – accounted for all expenditures by organization• Managed arrangements with 9 vendors – managed corresponding organizational and financial deadlines

  • President

    Nov 2023 - now

  • Programming Chair

    Dec 2022 - Nov 2023

  • Associate Member

    Oct 2022 - Dec 2022
• 

  Consult Your Community

  Feb 2023 - now

  Senior Business Analyst

  • Provided pro-bono consulting services to local businesses with a team of 5 analysts• Aggregated and analyzed media data to construct 3 new marketing strategies, increasing average userengagement by 200% through algorithm optimizati

• 

  Tina Ngo Designs, LLC

  May 2023 - Aug 2023

  Operations Intern

  • Developed pricing model based on data collected from over 130 artists and 600 art pieces; used quantitativeand qualitative sale measurements to advise clients on artwork pricing• Provided website design and maintenance for 3 domains, including updates and troubleshooting

• 

  FGIII FINE ART PRODUCTIONS

  May 2023 - Aug 2023

  Operations Intern

  Partner Company of Tina Ngo Designs

• 

  Dallas Asian American Historical Society

  Jun 2023 - Aug 2023

  Project Management Intern

  • Managed a team of 14 interns across four separate projects over a three-week timeframe• Resolved critical issues regarding development of 2 art pieces – including installation and assembly of 888 small paper figures; design and preservation of tapestry; and solving miscellaneous design challenges

• 

  Southern Methodist University

  Aug 2023 - now

  Residential Assistant

  • Served as a resource for crisis response and conflict mediation for 20 floor residents and 279 community residents across 3 buildings• Coordinated building maintenance, security protocol, and policy violations across 3 university departments

• 

  Code17Tek

  May 2024 - now

  Software Engineer Intern

  • Designed relational database schema and developed interfaces to link the database with backend services• Implemented Fast API based python backend to interface with AWS database• Implemented vector database layer over PostgreSQL database on AWS RDS, storing frontend user input toenhance recall performance• Implemented ETL process through a robust data pipeline, cleaning, embedding, and storing user input data