Paul Shemchuk Email & Phone Number

Auburn, Washington, United States

• Led initiative to transform supply chain reporting for a complex manufacturing organization from manual reports based on excel & access databases to a enterprise data warehouse following industry best practices; saving the business over 5000 hours annually of manual work• Responsible for integrating data from multiple ERP & MRP systems, including SAP ECC, Infor LN, & SAP S4/HANA into a consistent data model, aligning different properties across the business • Served as primary domain consultant during agile data warehouse development, gathering requirements from 23 business units across 9 value chains, documenting over 100 complex business processes and translated business logic into data rule during data modeling and entity discovery phase• Established an enterprise data warehouse environment using SQL Server - responsible for design, development, implementation, and monitoring of over 100 fact and dimension objects following Kimball dimensional modeling methodology• Wrote & tested complex ETL packages from multiple systems using both on-prem and cloud sources, responsible for managing over 200 procedures, scripts, packages• Created a governance process that included both domain subject-matter-experts, multiple levels of leadership, and data developers; reviewed hundreds of change requests while only requiring one 30-minute meeting a month• Implemented a multi-platform strategy for end-user data consumption & visualization including Power BI / Fabric, Tableau, IBM Cognos, leveraging the strengths of each platform for the unique business reporting need• Built custom internal webapps with Python, utilizing libraries such as Flask, Plotly Dash, Streamlit, and Rshiny for Python

Auburn, Washington, United States

•Managed a portfolio of 34 projects transitioning statement of work to external suppliers; responsible for the resolution of complex chain issues•Led a team of 9 project managers across multiple business units•Designed and built a data pipeline for capturing, transforming, and visualizing data in Python, Power BI, and Tableau ecosystems•Developed and tracked performance metrics; KPIs to identify project schedule and cost risks•Supported projects with the development of dashboards, prescriptive analytics, demand forecasts, and performance evaluations•Led the creation of standard processes to ensure work movements are executed without impacting production•Created ETL procedures to extract data from Enterprise Resource Planning (ERP) systems and prepare datasets for reporting•Led implementation of Enterprise Project Web App; oversaw transition from unstructured, excel-based project management•Created management system and workflow supporting project initiation, status updates, and change log; ensuring external partners are meeting business expectations•Integrated across the portfolio with core teams on change management including schedule, cost, and statement of work•Oversaw projects in both planning and execution stages including onsite plan reviews, action item closure and supplier integration

Seattle, Washington, United States

•Strategically optimized real estate portfolio asset utilization and employee experience for a large tech client •Created strategic options for a global portfolio; 50 sites across 20 countries supporting lease decisions, site selection, and targeted growth areas•Prepared occupancy plans and business cases, including stack plans and block plans, understanding of business unit adjacencies and priorities•Developed a Power BI data ecosystem and repository for space, workforce, and strategic location planning; led sprints through dashboard development process and implemented visualizations to track space allocation, current headcount, and financial people forecasts•Developed a machine learning behavioral occupancy forecasting model in python to support strategic occupancy, incorporating employee sentiment, space utilization, and market trends•Partnered with data engineering teams to create ETL procedures to populate data warehouse with clean data •Prepared 5-year supply & demand scenarios including occupancy, utilization, capacity thresholds, and workforce planning•Analyzed internal and external data to support workforce strategy planning•Supported the re-entry and return to office from COVID-19 and integrated utilization behavior changes into real estate strategies •Negotiated capacity with Finance and Human Resources partners; managing between employee experience and cost effectiveness•Built data models from several sources to support forecasting and capacity planning; provided live reports to senior leadership

Auburn, Wa

•Solicited headcount projections and business plans to enable forecasting, developed proposals for stakeholders•Developed documentation to compare strategic solutions, identify risks and benefits, and presented recommendations for leadership approval•Created a database to support facility headcount forecasts, building capabilities, lease information, design density, and space utilization•Coordinated and provided information to update use and occupancy tracking system to identify cost and space allocation to the tenant•Led site studies/business scenarios and strategies to develop proposals and plans•Presented multiple business cases to vice president level executives that yielded annual savings of over $4.5M •Performed regional integration and site analysis on manufacturing processes and technology forecasts •Built relationships with internal organizations and senior level management to identify and assess impact to the business operating plan•Led long-range business planning of capital projects, covering portfolio of 5.8 million square feet with annual budget of over $25M•Executed agile work environment redesign, incorporating an unassigned workplace model leading to an increase in space utilization by 23%

Puyallup, Washington, United States

•Managed 20 direct reports within a 2.4M square feet site, responsibilities included facilities maintenance (HVAC, electrical, mechanical, plumbing, material handling, crane technicians) and Custodial Services•Responsible for ensuring the completion of all regulatory preventative maintenance work orders•Coordinated all activities to support operations; purchase requisitions, vendor management, invoicing, maintaining skill coverage and overtime assignments, budget forecasting, cost management, and long-range planning•Actively engaged in personnel development, training and leadership. Ensured goals were achieved and maintained balance between response to business partner requests, values of excellence, and cost effectiveness•Led regional response to the coronavirus pandemic for all sites within our portfolio, nearing 6 million square feet•Completely rebuilt every aspect of the Custodial program, including redefining responsibilities within standard level of service, negotiating requirements with business partners, and facilitating the signing of a new Service Level Agreement improving execution of current work statement and adding duties to effectively combat COVID-19 such as incident area deep cleaning and enhanced touch point disinfecting•Created Basis of Estimate for Custodial Services headcount using industry best practices and site knowledge, reduced headcount forecast by 50% without reduction of services. Custom methodology developed set to become standard across the enterprise•Designed and published documentation for janitorial operations including training materials, minute-by-minute job plans, management system, interactive building layouts, COVID-19 response guidelines, communication templates, and oversight reporting tools for leadership review•Implemented updated Custodial program, revised based on feedback after day-to-day operations, owned change management model through final approval

Auburn, Washington, United States

•Temporary assignment to lead Facilities Management organization’s response to 737 production suspension of operations•Led a team of (7) managers with a total of (247) direct reports•Developed program plan and management system for entire program response including work statement definitions, work package documentation, prioritization, execution and report-outs.•Collaborated with other departments for the development of work statement documentation for including Safety, Security, and Union Representation. •Responsible for ensuring all safety and workplace policy were not violated through the duration of the program.•Led weekly presentation to executives on program progress, opportunities, risks, and issues. •Collaborated with procurement team to create unique requisition process to support high demand for supplies •Supported negotiations with business unit directors on headcount availability and reassignment. •Owned the program through completion with multiple high value projects completed in 8 months on a portfolio over 5.8 million square feet

Renton, Wa

•Implemented approved real estate strategies and business group initiatives which affected building and line of business occupancy•Guided project management in delivery of work space and production environments; developed business cases and planning memos outlining project scope, timeline, milestones, and supported through implementation•Developed occupancy deliverables, migration plans, move phases, space allocation plans, stack plans, options and schematic plans to meet short and long-term client master strategic plan initiatives•Built relationships with the enterprise business groups, key stakeholders and received multiple accolades from VP level executives•Created presentations which effectively reported the bottom-up seat count projections by business unit, current state supply and occupancy information, actual seat demand versus projected seat demand at building, division, and business group levels•Prepared assigned account and business group reports per pre-determined frequencies; scheduled and facilitated meetings as needed•Developed a familiarity with the enterprise business groups, key contacts and, an expertise with the internal client processes; received multiple accolades from VP level executives•Created Space Governance model to manage campus consolidation, including developing standard kit of parts for furniture and leading workplace environment team•Integrated ad-hoc MAC work and space requests into tactical plan maintaining the strategic plan goal and objectives•Maintained and updated facility drawing changes in AutoCAD, responsible for creating polyline system for area identification and integration with CAFM system•Conducted annual audit of space class, area type, and occupancy, findings were reported to finance to ensure proper billing •Maintained value log of cost savings to client with annual submissions of over $1.4M cost avoidance due to effective implementation of space strategies and client trust in business case feasibility

Tukwila, Wa

•Provided consulting and analytics to clients on real estate strategy, leases, and transactions•Prepared financial and other analysis for a range of deliverables, including market plans, scenario options, process improvements, management practices, business unit communications•Researched, analyzed, and developed presentations for market area demographics to client executive steering committees•Managed analytical requests from Corporate Development executives such as market share analysis, competition analysis, business activity stats•Supported the implementation of real estate plans with an understanding of the client's strategic real estate goals. Assists with project initiation and scope definition, prioritization of assignments, and adherence to client-driven priorities, commitments, and milestones•Implemented due diligence activities and provides solutions to a variety of development project issues•Built a matrix that streamlined site selection process saving 3-5 months from average site selection timeline

Tukwila, Wa

•Responsible for a large, complex parking and transportation program, overseeing day-to-day operations and leading the upgrade of LUUM parking software•Created and completed projects to implement new program benefits; reducing process inefficiencies and streamlining program deliverables•Developed, recommended, and executed policies and processes for allocating monthly parking to eligible employees at client worksites regionally•Managed third-party vendors in the oversight of all day-to-day garage operations in coordination with client Property Management teams•Drafted and provided reports to county & state officials regarding program metrics. Received awards from State of Washington on program performance•Used a variety of tools to project parking utilization scenarios and develop strategies to further increase utilization and efficiency of leased and owned garages

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Business Administration - Emphasis On Data Analytics

Associate'S Degree, Business Management