Will Hii, Pe Email & Phone Number

New York, Ny, Us

• Led implementation and configuration of Project Management Information System (PMIS) tools such as Procore and Sharepoint for owner program management on several major $1B+ construction programs in aviation, roadway and rail.• Design business controls solutions for program managers on processes and workflows for design and construction submittals, correspondence, document control, cost control and schedule controls.• Design data solutions, querying complex data sets and develop dashboards to provide cost, schedule, CapEx, OpEx business intelligence reporting to project executives in PowerBI and Google Looker studio.• Schedule Consultant and data expert for WSP@Google on external workforce for Global Real Estate Workspace Services (REWS) business controls team. • Developed cost control, earned value management and resource tracking PowerBI dashboards for New York Penn Station Reconstruction design project management team.

New York, Ny, Us

PMIS/Software Implementation/Product Development:• Managed implementation of Sharepoint site and developed PowerBI dashboards for $800M roadway project; Arizona DOT’s largest urban freeway roadway reconstruction major design-build project.• Reviewed, monitored, and analyzed financial performance, project costs, schedule, labor compliance, and other performance parameters.• Tracked actuals against budgets, conduct variance analyses, report project financials, and respond to queries from project teams.• Designed and developed simple PowerApp forms for data input into source databases and integrate with PowerBI dashboards• Developed and maintained advanced project management performance tracking dashboards with custom KPIs and metrics using tools such as PowerBI and Google Looker Studio.Schedule and Business Controls:• Schedule management controls analyst on the external workforce for Google. Working with Google’s global real estate and workspace development portfolio central schedule controls team. • Tracking and managing schedule and financial data for a portfolio of over 400+ global development projects within various spreadsheets and databases.• Support business control processes and data management for Capital Planning, OpEx management and OpEx forecasting for Google’s Real Estate division.Engineering Design:• Supported transportation design engineering group on an as-needed basis on various tasks due to specialized expertise in drainage and GIS solutions.

New York, Ny, Us

Program Management/Project Controls:• Led the implementation of Project Management Information System (PMIS)/Project Controls Suite with a user base of 100+ end users on an $800M+ Major Design-Build urban freeway reconstruction project for owner-side program management.• Primary point of contact and technical subject matter expert throughout the development and operations of the PMIS tool• Designed solutions and directed Product and Engineering teams to develop new features within the PMIS system• Conducted walkthroughs and training sessions on technical aspects for end-users• Gathered requirements from project owners and translated them into technical and business requirements• Drove the implementation of new product features and managed bug report triage and escalation using DevOps• Developed executive-level management dashboards and reports using PowerBI and GIS• Work with APIs to ingest data from SQL databases and GIS REST API databases• Designed and documented automated workflows for construction package submittal and review processes• Analyzed and compiled project data from multiple sources to perform project performance forensic analysis and provide relevant conclusions/recommendations to the project executives• Supported schedule management, project cash flow reporting, and assisted project PMs with financials, staffing projections, legal coordination, risk management, and change order management• Designed and developed a schedule audit analyzer tool using Power BI which extracts, transforms, and compares XML data directly from multiple Primavera P6 XER filesEngineering Design:• Scoped, planned, and designed drainage systems for public sector projects, overseeing junior engineers and collaborating with project managers and stakeholders

New York, Ny, Us

Engineering Design:• Transportation drainage project engineer on major design-build projects, final design, scoping design review, and drainage floodplain studies• Used GIS and CAD software to convert survey large data sets of points and break lines into 3D terrain surfaces for floodplain modeling and grading design.• Served clients from government agencies ie., DOTs, Flood Control Districts, counties, and cities• Prepared conceptual engineering and feasibility studies, detailed engineering designs, and construction specifications and contract documentsProgram Management:• Assisted in the development of RFQ/RFP procurement documents (Technical Provisions and Design-Build Agreement) on $800M urban freeway reconstruction design-build project• Facilitated RFP evaluation processes and procedures for the selection of Contractor/Developer• Served as Right-of-Way coordinator, developing various tracking tools and dashboards to spatially monitor the acquisition and demolition of $30M+ parcels impacted by the project• Functioned as core support engineering staff providing General Engineering Consulting (GEC) services for the owner during procurement of Design-Builder

New York, Ny, Us

•Designed drainage structures to mitigate drainage impacts.•Analyzed hydrology/hydraulics for project sites.•Delineated watersheds, FEMA floodplains, and flood zones as part of floodplain studies. •Prepared CLOMR and LOMR for submittals to FEMA.•Prepared drainage plans and drainage reports for roadway improvement projects.•Performed cost and quantity estimates as part of drainage construction documents.•Developed project scoping documents and estimated staff labor hours.•Assign tasks to and coordinates with CAD technicians and administrative staff.

New York, Ny, Us

Founded an eCommerce online retail store specializing in direct-to-consumer home furniture products using multichannel e-commerce marketplaces. Generated over $450,000+ in total revenue to date through 3000+ individual customer orders.• Hired and directed staff contractors to manage and develop e-commerce store• Coordinate and build relationships with wholesale suppliers• Product/Inventory management of up to 2000+ unique SKUs• Shopify website development and design• Facebook Marketplace, Facebook Shop, Instagram Shop setup and management• Automating business processes using Shopify apps, Zapier, Google Suite, Python, and Javascript• Marketing and Facebook Ads management, creative development, and product listings• Web and data scraping• Customer Service• Accounting and Business Development Strategy to remain relevant• Email/SMS remarketing campaigns using various Shopify apps- Projects completed: • Owned and developed Facebook marketplace messenger chatbot with Javascript• Owned and developed a python bot script to automate purchase orders with suppliers• Customized process to automated tracking number extraction using Zapier and email parsing• Automated order fulfillment• Automated stock inventory updates• XML data feeds for product listings

Raised capital, acquired and manages a blended residential portfolio of fully stabilized cash flowing units yielding $200k+ in annual recurring rental revenue. The portfolio consists of residential and commercial multi-family, single-family, and condominiums operated as a mix of long-term and short-term rentals. As an owner-operator, I implemented various automation software and workflows to streamline management processes and allow for remote management of assets.Real estate property management/investing experience:• Led investor partnering round • Set up business structure with LLCs, trusts, and banking• Project management of BRRRR deals. Tracking construction and property management cost, schedule, and delivery from various teams.• Coordinating remodeling, repairs, and maintenance• Hired and directed the property management team• Real Estate Underwriting (Cap rate, NOI, Cash on Cash analysis)• Obtained financing (conventional, commercial, DSCR)• Real Estate acquisition (via conventional and wholesale)• Insurance claim for substantial damage - Xactimate and fire restoration• Property listing on marketplaces and lease preparation upon successful tenant screening• Implementing automated tenant management systems and project management systems• Vacation Rental - Multi-Platform Listing set up and automation, Copywriting, Interior Design, Pricing automation, Guest Management, Vendor Management, Inventory and supplies, Quality Control• Manipulate and access MLS data to research potential deals• Leverage GIS and county assessor knowledge to perform research

Phoenix, Az, Us

Engineer in stormwater department working on large master plan residential subdivisions and some site development work. Primary clients were nationally known home builders such as Shea Homes and Beazer Homes. • Performed drainage analysis for large residential master-plan community projects(>1000 lots).• Attended meetings with clients, stakeholders and project managers to discuss technical aspects of the project.• Performed Hydraulic & Hydrologic modeling with XPSWMM2D, RiverFlow2D, HECRAS, HEC-1, ArcGIS and Rational Method.• Analyzed and designed erosion protection and scour mitigation structures.• Designed onsite and offsite Retention/Detention basins, Catch Basins, Scuppers, Storm Drains and other drainage structures.• Prepared technical reports from preliminary to final engineering (PDR, FDR, CLOMR, LOMR etc.). • Prepared exhibits using ArcMap and AutoCAD Civil 3D 2015.