Johnny W.

Policy Researcher and Data Scientist at Lawrence Berkeley National Lab

San Francisco Bay Area

About

Software engineer with experience in building data platforms using cloud technologies and designing and developing API. Passionate about extracting business values from data through data transformation and analysis, and effective communication with stakeholders.

Experience

  • Policy Researcher at Berkeley Lab
    Mar 2023 - Present · 3 yrs 4 mos

  • Software Engineer at BlackRock
    Jan 2022 - Feb 2023 · 1 yr 2 mos

  • Project Engineer at BART
    Mar 2020 - Dec 2021 · 1 yr 10 mos

    Data Process Improvements - Developed Python scripts to automate and validate data integrity to and from various project reporting files - Developed Python scripts and utilized Excel VBA macros to streamlined project reporting process and ensured data quality for project reporting for stakeholders Reporting and Business Improvements - Developed a Monte Carlo simulation model within Excel workbook using VBA to assess projects’ risk and simulate the impact on budget and schedule - Tracked, analyzed, reported on over $600M of consultant work plans’ financial information monthly to identify fund-freeing opportunities

  • Project Management Intern at T-Mobile
    Jun 2018 - Aug 2018 · 3 mos

    - Maintained and automated data integrity between the regional’s project reporting database and reports given by T-Mobile’s vendors - Routed and validated lease agreements for the regional director and vice-president and ensured completeness and accuracy for each routed document.