- Streamlined merging efficiency by 45% for over 238,000 rows by optimizing T-SQL queries and database operations between two HR databases.- Updated database scripts and objects in T-SQL and SSIS to prevent unwanted data replication and database migration.- Modified an adhoc monthly scheduled package in SSIS to remove duplicate cornerstone accounts. - Developed an adhoc SSIS package to pull and update missing email and activity pointer records.

- Resolved a bug where uploaded project icons were not being correctly displayed on the user interface on Django- Helped design and implement a Stripe billing payment portal responsible for displaying billing detail with a separate payment portal.

- Created a pitch deck and led a team of three to give potential investors a brief overview of humanID - Facilitated and set up sales calls with potential clients and humanID’s cofounders- Researched potential clients and performed marketing outreach

- Pitched long/short positions in mutual funds/ETF's for the organization's semesterly portfolio - Researched healthcare and clean energy and evaluated future potential for growth- Worked closely with other analysts to create coherent and well-researched pitches

- Overhauled and revised surveys collecting responses to JOL's- Conducted research regarding JOL's and identified areas lacking research and data- Engaged in group discussion on improvements to presentations and surveys

- Created a pitch that helped to re-establish mental health services offered by Justice Centre - Performed needs assessments- Analyzed NGO engagement and contacted potential partners- Completed due diligence in preparation, performing research tasks, taking notes, andfacilitating discussion and decision processes- Shadowed professionals in interviewing clients

- Provided administrative support to several NGO programs affiliated with HandsOn Hong Kong- Stepped in as temporary volunteer leaders- Responsible for providing notes- Evaluated the viability of certain NGO partnerships with HandsOn Hong Kong