Andrew Larson Email & Phone Number

Denver, Co, Us

Denver, Co, Us

Minneapolis, Minnesota, Us

Richmond, Virginia, Us

- Managed and mentored junior engineers while delivering platform enhancements for the MLOps platform at a major fast food chain. This involved use of both Airflow and Databricks for orchestration, as well as AWS services like Sagemaker, Glue, Anthena, and Redshift.- Supervised and directed migration of major enterprise ML pipelines from Airflow to Databricks including adding CI/CD, SRE reporting, and observability using several third party tools including MLFlow, GitHub Actions, and Arize.

Richmond, Virginia, Us

Client Work:- Built data warehousing solution from scratch for major fleet card provider. Included building dimensional data model, client interviews to evaluate business logic, and assisting non-technical users with the use and maintenance of the model.- Orchestrated major data migrations for state government and start up clients. Involved complex SQL logic and working with analysts and stakeholders to determine requirements. In one case, the migration involved moving 200+ tables and views, and building repeatable incremental loads from an application back-end database to a data warehouse.- Independently managed data migration project for major telecom company during changing customer management systems. Involved building custom Python code, API interaction and payloads, and data quality management. Resulted in the migration of more than 30 million records to new system of record. - Build custom solutions for ingesting application marketing and ad campaign data from APIs for major social media providers including Facebook, BingAds, and Apple Search Ads. Utilized Matillion for orchestration, and Python for calling API end points.

Richmond, Virginia, Us

Client Related Work done on MS Azure Stack:- Developed SSIS packages for ETL in an enterprise setting. Involved merging various applications and database types into single system of record, and vast data cleaning.- Contributed to architecture strategy to build reporting and visualization layers for a Fortune 50 company to ensure non-technical users can analyze data accurately, and simply.- Utilized and developed Python classes to facilitate ingestion of new data sources and types into a major enterprise database system.Internal Development:- Competed in CapTech's Innovation Challenge for wearable technology. Built Python classes to interface between device and Azure Cosmos DB. Raspian OS development for Python environment control and start scripts on boot. Developed sales pitch for the team's wearable technology.- Contributed research to lunch and learn giving an introductory look at machine learning and CapTech's Advanced Analytics service offering to facilitate growth of contributors in the Data and Analytics practice area.

New York, Ny, Us

- Utilized Machine Learning techniques to improve load modeling for use in Platts' forecasts through use of LASSO and Ridge models, as well as regularization and cross-validation protocols- Contributed writing and analysis for Platts' products including the Power Burn Daily Analytics Report, Monthly Load Report, and various other products related to power markets. Maintain and run AuroraXMP model long term and short term power price forecasting- Improved process flow and centralization of data resources for use in analysis of power market fundamentals by integrating SQL queries into excel to remove manual data collection and aggregation

Denver, Colorado, Us

- Developed and evaluated rates and reimbursement methodologies for outpatient hospitals and free-standing emergency departments though SQL queries of Medicaid claims data, and statistical analysis of historical financial data- Provided stakeholders, providers, and department staff with data reports and analysis of cash flow to Medicaid providers resulting from changes in reimbursment methodologies- Managed and coordinated outpatient cost settlement payments with hospital providers and internal HCPF staff

Golden, Co, Us

- Provided research support for NREL technical reports related to the economics of renewable energy including: electricity market design and revenue sufficiency, clean energy manufacturing supply chains, and carbon capture and storage - Data analysis including statistical modeling of energy data including operational characteristics of generators in various service areas, price and load data, and market structures to assess generator revenues and costs- Assisted with the preparation of a scoping workshop with over 30 attendees to assess and develop a research agenda for overcoming the operational and investment challenges associated with increased use of natural gas under deep decarbonization

- Developed the Resilience Inventory for use in guiding QER 1.2 analysis of resilience activities to identify gaps and strengths- Edited and finalized case studies for the Climate Action Champions program for publication by the White House- Assisted with various projects including updating the DOE powerpedia page for state Technical Assistances requests, and maintaining event listings for use by DOE staff in planning speakers

New York, New York, Us

- Engaged in analysis of metrics related to the proposed and final EPA regulation on existing power plants (better known as the Clean Power Plan) including comparison of IPM model runs and technical support documents associated with the rule- Contributed to the publication of a white paper by EDF, including data analysis and graphics creation- Provided research support for the Director of Regulatory Affairs and Strategic Partnerships for briefings, talking points and memos including financial and energy data research related to the operation of utilities and regulation of the electric power sector

Tempe, Az, Us

- Duties included compiling news clippings for the federal affairs staff, engaging in research projects assigned by the director, and general clerical work- Prepared presentation materials for the Director and assisted at events hosted by organizations of which SRP is a member including the Large Public Power Council’s Post-Election Forum- Prepared memos relating pending legislation to SRP's goals, and attended congressional hearings on areas of interest to SRP

Walla Walla, Wa, Us

- Full time position heading the Policy Debate Team jointly with the Director of Debate- Duties included scheduling, budgeting and monitoring students at eight regional and national tournaments throughout the year- Assigned research and drills to undergraduate students for the 2013-2014 debate season, evaluated and graded assignments- Researched and produced arguments and strategies for the year’s topic- Assisted in the planning and hosting of the two major regional tournaments hosted on Whitman’s campus with over 40 teams in attendance- Coached students to elimination rounds at the Cross-Examination Debate Association national tournament and to qualification at the National Debate Tournament

Us

Intern for Matt Compton. Planning and organizing campaign events. Staffing the office and making phone calls to donors. Preforming opposition research.

Meridian, Idaho, Us

Managing and operating food distribution sites to low income neighborhoods for the Foodbank's Picnic in the Park program.

Masters Of Public Policy, Public Policy Analysis

Bachelor Of Arts (B.A.), Economics

Political Economy