William Colson Email & Phone Number

Washington, District Of Columbia, United States

Oversees U.S. Monthly Oil and Gas Upstream programDevelops, reviews, and enhances business logic and data models for quantitative analysis of oil and gas production, reserves data, and US/regional statistical estimatesPrepares reports and presentations to brief senior government officials on a variety of oil and gas topics, covering analysis methods and conclusionsDiscovers and corrects information gaps/inconsistencies in publication dataResearches alternative data sources, methods, and models to supplement EIA statistical publicationsProvides directives to EIA Survey Operations personnel staffOperates as liaison between state agencies and federal officials on oil and gas data projectsAuthors technical documentation for EIA business systemsAnalyzes and reports on data system architecture to EIA supervisory staffMaintains and develops EIA Oracle database systemsMaintains and develops EIA SAS programming systemsMaintains and develops data visualization and analyis tools using Microsoft PowerBIMaintains and develops reporting and analyis tools using Microsoft AccessDesigns and implements data estimation models and methodsDesigns and implements ETL processes

Washington D.C. Metro Area

Designed and executed time and motion studies for USCIS Verification DivisionDeveloped data collection instruments supporting time and motion studiesDesigned and delivered staffing allocation model for USCIS Verification DivisionProvided COVID-19 impacts research and data analysis for FEMA Grants Programs Directorate, Monitoring and Compliance and Closeout Coordination BranchesPrepared reports and presentations to brief senior government officials on analysis results

Washington D.C. Metro Area

Responsible for maintaining and developing the EIA International Energy Statistics database (Oracle).

Washington D.C. Metro Area

Supported upstream oil & gas programs at the US Energy Information Administration (EIA). Developed and enhanced quality control data systems and applications supporting upstream oil and gas publications. Responsibilities included business process development, data management, risk assessment, database design, analytics dashboard development, training programs, and analysis and research.Designed and implemented a new production quality control system, reducing team resource costs by 30% and capturing previously missed, high risk data.Developed architecture using Oracle Database (SQL Developer), SAS (Enterprise Guide) for analysis and ETL, Microsoft PowerBI interactive reporting dashboards, and Microsoft Access (VBA) for workstations UIs. Replaced existing Excel-driven business processes.Responsible for debugging and enhancing legacy SAS EG Projects.Oversaw training program of oil & gas analysts.Led data quality improvement projects to ingest and clean external, 10m+ row data sets of well-level US oil and gas production.

U.S. Department Of Energy

Assisted the US Energy Information Administration at the Department of Energy in Washington, DC. Specifically, I supported the office of Oil, Gas, and Coal Supply Statistics, providing analysis on oil and gas reserves data.

Pineville, Nc

Charlotte, North Carolina Area

I assisted mineralogy students with their lab work--primarily in mineral identification techniques and other mineralogical information.

Bachelor Of Science, Geology

Education record