Brian Chan Email & Phone Number

Seattle, Wa, Us

Cupertino, California, Us

- Pipelines and SPA Site Development: Led the creation of robust pipelines and responsive Single Page Application (SPA) websites for the Siri annotation grading program. Incorporated comprehensive performance metrics to continuously enhance analysts performance. - AWS Glue Workflow Optimization: Orchestrated the optimization and standardization of AWS Glue job submission workflows, resulting in the seamless generation of systematized cloud jobs. This initiative significantly improved efficiency and scalability.- Technologies Utilized: Proficiently leveraged AWS services, including Glue, Athena, API Gateway, Lambda, Kinesis, and S3, alongside frontend technologies such as React, Next.js, Vue, and backend development with Flask.

Seattle, Wa, Us

- Data Warehouse Pipeline Development and Marketing Automation: Pioneered robust data warehouse pipelines and automated marketing operations, enhancing efficiency and decision-making.- Airflow for Google Ads Optimization: Strategically leveraged Airflow for daily Google Ads updates, aligning campaigns with MLS listings and maximizing ROI from commission-based advertising.

Mountain View, Ca, Us

- Advanced Toolset Integration: Leveraged an array of cutting-edge tools and technologies, including Kubernetes (Borgmon), Blaze, BigTable, Colossus, and the Google Visualization API (gviz).

Develop an internal dashboard charting app called Unidash.- The purpose of this role is to unify internal dashboard apps, and to promote internal dashboard app consumption (vs paying license fees for 3rd party solutions). - Develop internal charts/widgets in Hack, ReactJS, Javascript, CSS, and HighCharts. - Using the engineering build stack to contribute changes to the www repo. Using tools like arc, hg, t, flow, jest, crud, fbide, etc.

Cupertino, California, Us

Handle Maps tiles validation and automate the QA workflow.- Performed global-scale Map tile check in Spectrum using Groovy, Hadoop, and Python.- Wrote Python library files to auto-populate optimal zoom, polygon and tile info for the POIs testcase files. This automation process reduces at least 50% of the manual effort. - Wrote a parser in Python to convert numerous types of tile testcase files to/from csv files, thus enabling QAs to directly modify in csv/excel, saving overall QA time. - Created a dashboard in Django to measure internal testrun pass/fail rate. Charts are primarily developed using HighCharts.

Mountain View, Ca, Us

Developed internal App Engine applications, and managed business intelligence projects.- Sole engineer to build an App Engine internal application in Python/jQuery/CSS/CloudSQL to gather improvements/new ideas on existing workflows from all vendor staffs around the world. The ranking of these ideas is determined by the users' rating and comments. These ideas will then go through an internal approval process to get reviewed/implemented.- Build an internal web tool in PHP/MySQL/jQuery/Bootstrap/HighCharts on the LAMP stack to track Cost-per-unit metrics. This tool measures and analyzes vendor productivity. - Build a variety of metrics charts with complex SQL queries from internal marketing and sales data to generate business intelligence. These charts are used to gauge the market direction and to make strategic planning.- Build various tools to automate existing workflows using trix, pipewrench, plx, cns, etc.

Cupertino, California, Us

Developed an internal website and various automation tools for the iOS wireless division.- Design and maintain an internal website for an organization of 400+ QA/Dev members. Such visualization tool gives daily insight to the upper managers to discover bottlenecks early on in project cycles.- Developed a heat-map visualization tool for automated build tests. Software managers can then easily spot out the most critical bugs and prioritze accordingly.- Developed an Excel import/export tool to interact with the company's centralized bug tracking system. This significantly speeds up many of the existing QA work flows.- Created many project specific charts using HighCharts (http://www.highcharts.com/).- Designed and maintained the underlying MySQL and PostgreSQL databases.

Santa Clara, California, Us

- Developed automation workflows. My work group has 10 engineers handling project specification gathering, scheduling, implementation, training and support. - Developed a python error checking tool written in object oriented fashion to check for disconnected nodes/edges in a given graph/tree. - Developed a python conversion tool in object oriented fashion to convert Microsoft Word files to internal XML files using an open source python xml library. - Responsible for development, deployment, and support of a database-driven, .NET WinForm application to access huge amount of register information, and to dynamically generate internal documents.- Handling DBA tasks on SQL Server 2008 involving user account management, backup/restore tasks, replication setup, and procedural/functional programming.

Davis, California, Us

- Being the sole programmer, database admin, and IT support for a group of ten people. Owning all aspects of projects, including design, implementation, and database administration. - Developed the entire Lab Management System web application in LAMP (PHP, Python and MySQL) to keep track of DNA experiments and handle DNA analysis using BLAST. - Regularly communicated with researchers to establish requirements and ensure satisfaction. - Worked extensively with PHP, Python and MySQL. - Sysadmin'ed 3 Linux Ubuntu web servers.

Sunnyvale, Ca, Us

- Created a visualization tool to monitor the status of the mail servers worldwide. - Created graphical reports by using PHP and MySQL.

Davis, California, Us

- Created a bio-informatics visualization tool in Python called ContigViewer, available at http://www.atgc.org/Py_ContigViewer/. Involved GUI development as well as implementing complex algorithms.- Created a clustering tool called Graph9 based on adjacency matrices, available at http://www.atgc.org/BlastParser/Graph9_Program.html. - Created a GUI tool in Python to plot geo locations: http://www.atgc.org/geolocate_1_2/index.htm

Bs, Computer Science

Ba, Mathematics