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.
• 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.
• 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.
• 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

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

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.
• 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

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

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.

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.

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.
• Prepared assigned account and business group reports per pre-determined frequencies; scheduled and facilitated meetings as needed

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.
• Implemented due diligence activities and provides solutions to a variety of development project issues

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