Andrew P. S. Email & Phone Number

Kirkland, WA, US

Menlo Park, CA, US

* Project lead to improve "freshness" of data to ML models, saving $500M/year in 2023. Mapped all 20,000+ critical paths for data flows to ML training, and drove effort to improve reliability and performance of these data flows.* Migrated 2.5 million cpu-days and 440 PB worth of daily data warehouse workload from Hive from Data Warehouse to Spark and/or.

Fremont, California, US

Improve the execution of Hive data pipelines moving trillions of records, petabytes of data, and migrate them to run using more modern engines like Spark or Presto. In the first two months, saved almost 2000 CPU-days/day equating to ~ $1.5 million saved per year, and directed pipeline owners where possible on how to self-migrate, saving even more. Applied.

Advancing oversight capability of Amazon Pets group through the use of advanced analytics, data analysis, predictive modelling to optimize various supply chain costs, promote in-stock metrics, and understanding parity with competitors.

Kirkland, Washington, US

Classified marketing leads for Microsoft’s C+E division to find ways to increase Known Leads, MAQLs, and SQOs.Reported on trends with Microsoft’s marketing lead funnel metrics from Marketo

Seattle, WA, US

 Developed risk reduction models to predict credit default potentials among Brooks customers. Used Python, scikit-learn, logistic regression.  Doubled loading speed for reports and dashboards through code improvements. Reduced EDW loading time by 90% by rewriting SQL stored procedure transforms for data quality/efficiency. Established unit testing of.

Seattle, WA, US

 Led team of six developers to build clinical data warehouse upon IBM Netezza. Loaded, transformed billions of records, hundreds of tables, transforms, for clinical, financial, patient safety, and research projects. Doubled daily EDW refresh speed by rewriting SQL, reorganizing data structures, job steps. Coordinated with upstream teams from Epic, Cerner.

Seattle, WA, US

 Drove 100x increase in real-time EDW load performance of discrete clinical events using C#, micro-batching to SQL Server.  Architected financial, clinical data marts in SQL, SSAS, SSIS, including one for the Harborview Budget Director and the Daily Flash Report using SSRS and later Tableau

Tempe, AZ, US

 Created an estimated savings of $200K per year by improving nursing student admission processes and increasing speed of admissions by writing a web-based system to automate the complex processing of incoming Nursing students, using Java, JSP, Spring, Maven, Oracle, calling on various university and external web-APIs for coursework, grades, immunizations.

 Helped design and build Head2Head.com, a fantasy football site for TimeWarner. Gathered technical specifications. Developed conceptual/logical/physical data models. Worked closely with graphics designers and implemented use cases. Followed Agile project management on all projects and led scrum.  Designed and optimized databases on MS SQL Server, MySQL.

Tempe, AZ, US

Reduced form handling errors by 90% by designing and building a complex student form tracking system in C# for ASP.NET to handle many time-consuming tasks within the College of Liberal Arts and Sciences.

Armonk, New York, NY, US

Developed SQL Server monitoring, anomaly & fault detection software for IBM clients. Written in C# and ASP.NET using a SQL Server database, the system monitored 3000 databases on 200 SQL Servers to managed data integrity for Honeywell, Moody’s Investor Services and American Express.

Master Of Science (Ms), Data Science

Professional Cerificate In Data Science, Data Science

Bachelor Of Science (Bs), Computer Science