William Wortham Email & Phone Number

Portland, Oregon, Us

Portland, Oregon, Us

Portland, Oregon, Us

Provided Technical and Functional support as lead support analyst for Columbia’s enterprise Allocation and enterprise Planning applications supporting 24 daily active users.- Made sure SLAs were met for daily working data. - Debug Azure pipeline jobs, SQL batch jobs, and application specific batch jobs.- Engaged, as a product owner, in Columbia’s Agile project to implement Microsoft Dynamics 365 and conversion to Azure Cloud.- Advocated for Allocation and Planning applications by pushing for enhancements and giving input into affects of bugs and deployments.- Collaborated with cross-functional teams to tap into accurate sources of enterprise data for applications and reports.- Engaged in code review activities with integration developers to identify and modify lines of Python code within the ETL Databricks notebooks to sync code to business requirements.- Planned, presented, and secured funding for project consisting of goals, tasks, schedules, and required resources to implement necessary enhancements to make the allocation/planning application’s data accurate to enterprise reporting.- Engaged in and managed project by leading enhancement prioritization sessions with the business, managing the Azure Dev Ops board, delegating developer resources to enhancements, and giving regular executive updates to share wins and pain points.- Wrote queries to combine data from Azure Data Lake and on-prem SQL services to align data between systems for 2.8 millions units worth of records.- Identified systematic opportunity to add additional batch job that cut the time it takes an allocation to reach the DC from upwards of 2 days to an average of 24 hours.- Collaborated with supply chain partners to implement SAP job that reduced "duplicate" freight resulting in $800k freight saving.

Portland, Oregon, Us

Bridged the gap between the businesses Supply Planning team and the technical development team supporting the businesses applications used to set up future inventory contracts based on actualized and projected demand data.- Developed Tableau reports to create efficiencies and present accurate data across multiple use cases. - Created tactical dashboards that were used to improve backlog cleaning/prioritizing practices, and higher level interactive dashboards that provided access to detailed supply and demand data.- Created processes and set standards in transitioning SQL data to Azure.- Collected reporting requirements and converted into ETL documentation for development.- Engaged in Enterprise Data team's sprints to assist in transitioning Supply/Demand data to Azure.- Lead weekly information sessions with business to create transparency between business and technical teams during data and report transition phases to Azure.

Cincinnati, Ohio, Us

- Continue to develop and implement VBA Macros within Database tool to increase accuracy and speed of creation of documents.- Analyze and create new processes to prepare Product Development team for software and systems transition.- Update Excel based live negotiation tool with new seasons style data in order to have accurate costs to obtain best deal.- Lead training sessions to instruct Developers on new processes and tools.

Cincinnati, Ohio, Us

Create Database for Product Developers to input/distribute style attributes to cut hours worth of repetitive work:- Create database on Excel platform to store departments style information.- Create multiple VBA Macros to distribute style information to multiple excel documents.- Communicate with large group of Product Developers to include necessary functionality.- Train Developers to use tool.- Cooperate with contracted consultants to allow database to inform pricing/negotiating tool.

Portland, Or, Us

-Work with team to create positive and accepting environment within dorm community-Participate and lead in meetings to brainstorm creative ideas to improve quality of dorm life-Actively coordinate time schedules in order to meet time requirements-Communicate with all members of the dorm in order to provide a safe and welcoming community

Bellingham, Us

Assisted in operations, marketing, and production of product. Developed new products by attending planning meetings and events to course the future for the company. Currently assist with business contacts and minor involvement in company activity.