Andrew Michael Email and Phone Number

Provide academic assistance, instruction, and coaching for both individual students and groups to promote student achievement in math and related subjects.• Mathematics (algebra, trig, calculus, linear algebra, probability & statistics, discrete math, foundations/concepts)• Software Development (Java, SQL, data structures & algorithms, C)• Data Analytics (Python, R)• Computer Information Technology (hardware, networking)

✦ TechnologyPostgreSQL, PL/PgSQL, Supabase, TypeScript, JavaScript, Node.js, Deno, GCP, Metabase, DigitalOcean, HuggingFace, Docker, Linux, Git, Caddy, vector database + vector search✦ Summary• Develop, design, and maintain the backend logic, backend API, API integrations, data schemas, and data processing flows for a cross-platform (iOS, Android) AI-powered mobile dating app (www.yougee.com)• Administrate a self-hosted Metabase server to support business intelligence, data visualization, and analytics• Pioneered the distinguishing feature of the app-- a multifaceted AI-enhanced matching algorithm and search engine that calculates match score rankings using aggregated embeddings of user content and attributes in a vector database (HuggingFace + pgvector), subject to admin-configurable weights• Ensured user safety by implementing semi-automated content moderation to detect and flag or remove potentially unsafe content in user uploads, including an admin-configurable policy matrix, data retention periods, and alerts• Enriched application functionality by integrating database activity with third-party providers (OneSignal, Revenuecat, HuggingFace, Google Vision) using serverless JS edge functions on an efficient Deno runtime

✦ TechnologyPostgreSQL, PL/PgSQL, PostgREST, Docker, Terraform, Make, Bash, Python, SciPy, NumPy, Fabric, Ansible, JavaScript, Node.js, OpenAPI, Linux, Git, DigitalOcean, Caddy, Nginx, Backblaze B2, AWS, Jira, Confluence✦ Summary• Develop the backend API, data models, and logic driving a complex mobile social media application (iOS)• Design scalable backend architecture from the ground up• Administrate infrastructure and orchestrate core backing services to provide a reliable platform for client-side developers• Produce and publish documentation: - hand-crafted documentation with usage scenarios, diagrams - exhaustive reference documentation generated from a formal spec - operations runbooks for administrative procedures✦ Accomplishments• Deployed cloud infrastructure using Terraform, provisioning and configuring application server environments using Bash and Python• Minimized environment divergence and reduced complexity by managing all configuration in declarative source code• Increased project portability by containerizing all services• Accelerated release cycles by automating development tasks, builds, and testing with GNU Make• Integrated Apple Push Notifications with database events using a PostgreSQL-backed Node.js task queue• Supported media uploads by adapting open-source TypeScript middleware for AWS S3 • Powered live messaging and data-driven reactive client UI with real-time event streaming and pub/sub change capture over websockets• Enhanced deployment process by implementing state-based database delivery using schema diffing tools to generate DDL for migrations• Bolstered data security by applying PostgreSQL row security policies to all service authorization logic• Analyzed performance under load and probed for concurrency defects by simulating high-volume traffic with realistic mock data using Siege and Python Mimesis• Collaborated to fine-tune user experience with affinity prediction using various machine learning techniques

• Designed, developed, and documented internal tooling for a deep-learning research project and entertainment media proof-of-concept• Developed a user-friendly image labelling application to streamline and enhance the client’s existing workflow for analyzing and processing large volumes of training data• Advised software and hardware selection to successfully migrate project infrastructure to a Linux environment