Personal Information
Name: Wellington Fan (he/him)
Email: winterbeef@gmail.com
Phone: 917 749 9002
Skills
- Python, Django, Flask, WSGI/ASGI
- MySQL, PostgreSQL, MS-SQL
- Redis, mongoDb
- React.js/Typescript, Javascript
- FastAPI, Postman, GraphQL
- Apache, NGINX, gunicorn
- ETL, data modeling, normalization
- AWS, Azure/Entrata, GCP
- Active Directory, LDAP
- DevOps, Docker
- Git, Gitlab, virtualenv, pyenv
- CentOS, Ubuntu, Windows, MacOS
Work Experience
Psyop
Position: Senior Software Engineer
Duration: 2007-2024
- Engineered the database infrastructure fueling all facets of the organization's production requirements. Orchestrated its deployment and monitoring.
- Led non-technical stakeholders through project planning, translating complex concepts into understandable roadmaps, milestones, releases and support.
- Designed novel ETL processes to extract data from various sources, transform it to meet business requirements, and load it into data warehouses for analytics and reporting.
Selected Projects
Distributed Database Scheme
Designed, deployed and supported a replication topology to support a geographically-distributed company. Minimized lag, improved recoverability, added fine-grained monitoring, and isolated performance-impacting operations from the read-write production pipeline.
Financials Reporting System
Spearheaded a project to design, build and manage ETL and data replication solutions, federating financial data from diverse sources into a data warehouse. These tools provided the Finance team with real-time reporting and analysis that was previously unavailable.
RBAC Account Management
Designed, developed and maintained the web application for managing Active Directory security principals. Freed our IT team from error-prone account management tasks by automated enforcing of security and organizational policies, auditing and monitoring, and providing controlled access to sensitive data to the Scheduling team. Extensible; communicating with multiple subscriber apps via pub-sub.
Production Forecasting Tool
Designed, developed and maintained an API that integrated resource utilization data from several disparate sources, providing real-time collaboration and analysis capabilities. This empowered management with an unprecedented ability to run scenarios, forecast and plan.
Application Licensing
Developed the backend services and React.js applications that interface with Autodesk and MS Azure/Entrata APIs to provide self-service requests for licenses.
Aspera Management
Developed the React.js applications that interface with Autodesk and MS Azure/Entrata APIs to provide self-service requests for licenses. Designed and developed the Django application to interface with the Aspera API.
