Glenn Gehrke

Experience

• 

  Weyerhaeuser

  May 1980 - Dec 2009

  Web Developer

  > Developed, supported PackagingDivision’s Financial Budgeting System, Mill Management System written in MS Access and MS Excel. Manufacturing forecast spreadsheet models were sent in monthly for upload to MS Access databases. Extreme MS Access reports were produced to manage division profitability reporting. > Project Lead/Lead Developer for creating a Java-based front end to an existing Health/Safety Tracking system. Successfully developed system from scratch and implemented on time and within budget. Managed development team of 4 technicians; both U.S. and Indian contractors.> Technical deployment Lead for implementing WorkBrain scheduling system at pilot plant sites. Co-development project with WorkBrain, Inc. Ontario Canada. In addition to successfully implementing this software, I wrote an MS Access-based ETL transaction validator that verified master configuration data and wrote corresponding SQL scripts for faster, accurate database loads.> Wrote company’s first XML web service in Microsoft .NET in 2003. Web service was designed to be a General Ledger account validator that interfaced with SAP Financials. Could be called from any consumer whether it be an MS Office app, other .NET apps, or JAVA-based systems.- Developed VB/SQL Server XML-based Order Status web application that allowed company customers view their order progress as it was manufactured and shipped. Leading edge web service technology was used to interface to other shipping providers allowing customers to track rail and shipping locations from one user interface. > Worked for project team that delivered custom Microsoft Access and Excel applications to solve a wide variety of business challenges. Wrote an MS Access application that preloaded and validated Materials Management transactions for preloading into SAP. Developed MS Excel Waterfall and Pareto Chart wizards.> Additional Work History available. Show less

• 

  Federal Way Public Schools

  May 2011 - Sept 2013

  Data Warehouse Developer

  > Deployed, configured, and administered MS SharePoint 2010. Developed Student Grades data warehouse using SSAS and MS SQL Server 2008R2. Built user analysis dashboards for direct drilldown into student grade information slicing by courses, teachers, marks, demographics. System was designed and implemented using SSIS to pull information from other applications and provide quick analysis of student and teacher performance.> Successfully lead project to implement Versi-Fit’s Ed-Vantage Student Information data warehouse software. This system worked in collaboration with the school district’s new EduPoint SIS project. Both projects went live in August of 2013.> Acted as Applications Architect to consult on selection of School District’s new SIS system from RPF’s of several vendors. > Provided data conversion consultation to DBA in charge of SIS implementation. Developed data extraction, validation tools using MS Access to help more complex data conversion tasks. Show less

• 

  Gehrke And Associates

  Jan 2014 - Sept 2015

  IT Consultant

  Provide expert level IT consulting to businesses that are looking to implement new COTS solutions into their company. Also provide web development and data warehouse solutions using MS SharePoint technologies.August 2015-September 2015 | Cosmo Specialty Fibers, Aberdeen, Washington> Contracted through Express Pro Employment Services to provide mill-wide IT support as the interim Mill IT Manager for Cosmo Specialty Fibers. Responsible for the entire network infrastructure including support for all servers, physical and virtual, MS Exchange Server, Avaya IP Phone communications system, SAP Financials and Mill Maintenance, Kaseya software management services, and other applications support including mill camera security. August 2014-January2015 | Costco Wholesale, Issaquah, Washington> Contracted to Costco through Beacon Systems to provide project management leadership for Release 3 implementation of SAP’s FICO enterprise solution set into Costco. Acted as Production Cutover Lead responsible for gathering task assignments from multiple staff groups required for successful planning and timeline execution.> Served as Technical Liason for R3 Mock1 Data conversion. Worked with Finance Functional Manager to build out data conversion tasks that would also be incorporated into Master Cutover plan. Instrumental in getting Mock1 Data conversion effort completed on time.> Acted as SAP Change Management Facilitator successfully developing processes in use today at Costco for management of SAP transports into production environment. Used ITIL Foundation v3 processes to establish SAP change management protocol. Show less

• 

  Costco Wholesale

  Jan 2014 - Jan 2015

  SAP Production Cutover Lead

  Responsible for gathering task assignments from multiple staff groups required for successful planning and timeline execution for bringing SAP FICO into production operation.

• 

  Cosmo Specialty Fibers, Inc.

  Aug 2015 - now

  Mill IT Manager