Nicholas Axl Andrian Email & Phone Number

Indonesia

Jakarta, Indonesia

• Utilized pandas, openpyxl, and python-telegram-bot to create a bot, handling over 300 queries daily for freight schedules, estimated stuffing dates, and supported ports.
• Integrated the workplace Google Sheets as a data source, enabling instantaneous real-time schedule updates without local file dependencies, cutting 10% of additional workload
• Implemented robust schedule and stuffing query functions with filtering options for month, direct transit, and destination for both customer and internal usage, boosting work efficiency by 60%
• Created Flask-based webhooks, maintaining bot uptime at 100% and doubly reducing response times over the default polling

Berkeley, California, United States

• Created a Next web-app for a prompt engineered GPT-4 student ambassador chat system, handling over 150 monthly user interactions
• Integrated Pinecone's vector database as the backend storage solution for efficient retrieval of document embeddings and query responses for the chat bot, providing 80% more contextually accurate responses
• Captured and collected user feedback through suggestion prompts and updated the Pinecone database to compoundly improve response accuracy
• Polished and updated the main informational website built on React with the help of feedback from conducted weekly live user tests. Did the same for the UI and UX design of the ambassador chat system, increasing web.
• Integrated custom search APIs (SerpAPI) into the results to reduce hallucinations from generating fake links by 90%

• Lead a team of 5 in developing our website and registration infrastructure with automation through Integromat and Airtable
• Enhanced operational efficiency by 50% through integrating SQL to streamline the management of participant and sponsor data
• Reached out and secured funding from 20+ sponsors across different verticals, raising over a collective $38,000 in prizes
• Organized a team of 11 judges and led them to determine our judging criteria, set up a modified version of Gavel for judging
• Enhanced sponsor visibility and participant learning by coordinating workshops featuring their products throughout the event
• Created our project judging criteria, set up our online judging platform and lead the judging team

Garuda Hacks is Indonesia’s premier hackathon, where the world’s greatest talents come together to innovate and create impactful projects that utilize technology to solve Indonesia’s most pressing issues.This year, we acquired over 2100 participants all over the world. Making us the largest hackathon to have originated from Indonesia.Learn more at.

• Managed personalized email campaigns via MailChimp, reaching over 1000 customers and increasing open rates by 5%.
• Mentored in SQL query optimization, handling a 10,000+ entry customer database to ensure efficient storage and retrieval of marketing data.
• Tracked engagement for 3 marketing campaigns to identify key factors that lead to increase in conversion rates
• Assisted in refining email strategy, using A/B testing on 300 emails to monitor click rates between the two

Diablo Valley College Chapter

• Took charge in maintaining club membership and fees
• Collected general meeting data and showcased it every week to the officer board to maximize memberretention
• Lead marketing efforts and workshops that boosted membership by 60% by the end of my year
• Created and moderated our online community on slack during the covid online transition

Diablo Valley College Chapter

• Updated the main website and fixed several bugs and front-end errors left behind from previous officers
• Updated several communication methods online during the COVID-19 era

Bachelor Of Science - Bs, Data Science

Associate'S Degree, Computer Science