Christian F. W. Schmidt Email & Phone Number

Vancouver, Wa, Us

Vancouver, Washington, United States

- Developed Azure Synapse Pipelines, SQL scripts, and Spark Notebooks for data ingestion, transformation, and provisioning from Kafka, Mongo, SQL Server, Data Lake and On-prem File-server sources- Designed, implemented, and documented Git version-control of Azure Synapse workspace and IaC templates for associated resources (Logic Apps, Spark Pools, Key Vaults)- Developed and enhanced Synapse workspace deployment pipelines and CI/CD system

Vancouver, Washington, United States

Contracted to our client, The Greenbrier Companies:- Designed, implemented, and documented Git version-control of Azure Synapse workspace and IaC templates for associated resources (Logic Apps, Spark Pools, Key Vaults)- Proposed, Proved, and Implemented a CI/CD system for the Greenbrier DataHub Synapse workspace (Dev to UAT) with Azure Pipelines and Repos- Developed a Production environment deployment pipeline with integrated access controls and manager sign-off pre-requisites that accelerated delivery to Production while improving security and auditability- Developed workspace naming conventions, organization standards, and best practices for Greenbrier DataHub in collaboration with key Data Services staff- Developed Azure Synapse Pipelines, SQL scripts, and Spark Notebooks for data ingestion, transformation, and provisioning from Kafka, Mongo, SQL Server, Data Lake and On-prem File-server sources

Vancouver, Washington, United States

Responsible for supporting the implementation, integration, use, and continuous improvement for farmland and timberland management business information system workflows.* Provided business analysis and project management for continuous improvement of resource information and business systems* Gathered business requirements through stakeholder interviews and cross-functional relationship development* Collaborated with Operations, IT, Accounting, and Resource Support teams to align software solutions and system development efforts with business needs and strategic direction* Provided direct support to internal customers on use of Company's resource information and business systems* Raised awareness and engagement across departments and functional groups of the value of data quality, governance, and change management processes.

Vancouver, Washington, United States

* Performed strategic planning and production schedule optimization for investment timberland across the Western U.S. and Canada* Met with Operations teams to gather business requirements, assess constraints, and develop assumptions for management planning models.* Analyzed and investigated root causes of changes in production forecasts, IRR, asset value, projected revenues, operating costs, and inventory distribution.* Provided decision support and business intelligence services for Operations and other groups within the Resource Support Team.* Designed ETL process connecting HFM's North American resource yield database to property management model software using SQL Server Integration Services and server-side SQL objects.* Designed and maintained automation solutions for data stratification, processing and analysis and system integration.

Portland, Oregon Area

* Performed strategic planning and production schedule optimization for investment timberland across the Western U.S. and Canada * Met with Operations teams to gather business requirements, assess constraints, and develop assumptions for management planning models.* Analyzed and investigated root causes of changes in production forecasts, IRR, asset value, projected revenues, operating costs, and inventory distribution.* Provided decision support and business intelligence services for Operations and other groups within the Resource Support Team.* Designed and maintained automation solutions in Python, SQL, and R for data stratification, processing and analysis and system integration.* Served on the Diversity and Inclusion Task Force (5/18-11/19) for our parent company - Researched and documented best practices for Recruitment and Induction - Developed recommendations to improve outreach, engagement, and recruitment with underrepresented communities

Portland, Oregon Area

* Performed strategic planning and production schedule optimization for investment timberland across the Western U.S. and Canada * Analyzed and investigated root causes of changes in production forecasts, asset value, IRR, projected revenues, operating costs, and inventory distribution.* Assisted Portfolio Analysts with financial analysis, valuation, and planning of asset Acquisition & Disposition.* Designed and maintained automation solutions using Python, SQL, and R for data stratification, processing and analysis and system integration.

Redding, California Area

Assisted with land acquisition research project for a private sector client.- Created Python/Arcpy scripts to extend capabilities of GIS and automate repetitive processes- Performed secondary research. Acquisition, QA/QC, and processing GIS data to meet project needs- Created audience-tailored maps for project team and client consumption

Kodiak, Ak

* Designed and administered company GIS. Established schema and usage standards* Conducted GIS database QA/QC, primary and secondary data acquisition* Performed spatial analyses & map making for executive office and Board of Directors* Planned, coordinated, and oversaw reforestation program - Designed planting quality testing program - Developed inferential statistical analyses and contractor performance reports* Administered timber harvest contract and regulatory compliance- Trained new employee in GIS/GPS and wrote critical workflow instructional documentation- Researched and wrote recommendations on purchase of hardware, software, and field equipment

Corvallis, Oregon Area

Assisted my future thesis advisor with research during summer-term.- Researched latest developments in transportation planning technology for potential applications in the forest products industry- Identified knowledge gaps preventing reduction of forest industry transportation costs- Synthesized and disseminated transportation technology information to other researchers (http://tpupdates.blogspot.com/)

- Designed and launched a prescribed fire effects monitoring program- Led and supervised field technicians conducting forest health and restoration projects

El Centro, Ca

Invasive species mapping and eradication. Wildlife and vegetation surveys. Ecological restoration projects.

Buffalo, Wy

Timber sale marking. boundary and resource marking and mapping, Land owner outreach and consultation.

Norwood, Co

Fire suppression and fire mitigation

Gunnison, Co

Fire mitigation and fire suppression

Touchet, Wa

-Stacked hay, laid and gathered irrigation pipe, put up fence-Drove tractor, draft horses, hay truck

M.S., Forest Engineering, Statistics

Activities and Societies: Major in Forest Engineering, Minor in Statistics-Major program of study focused on operations research.

Bs, Forestry

Activities and Societies: Xi Sigma Pi Society of American Foresters Colorado State Forest Service Volunteer Program