• Bid Preparation and Cost Estimation: Spearhead the preparation and analysis of both informal and formal bids from initial sketches to detailed project drawings and documentation, utilizing Microsoft Excel for precise cost estimations.• Technical Drawing and Design: Produce shop drawings and project specifications using AutoCAD and SolidWorks, tailored to client and project requirements.• Project Coordination and Client Relations: Act as the primary liaison between engineering, sales teams, and external parties (suppliers and contractors) to ensure seamless project execution and adherence to schedules, enhancing overall operational efficiency and client satisfaction.

• Generated and automated daily sales analysis report from ERP system using VBA Macros to speed• up the daily routes for product managers• Created an executable program for generating stock report using Python to help product management team gain comprehensive view of warehouse inventory level when replenishing• Employed Power BI to evaluate and review sales performance and promotion effectiveness to improve inventory planning, demand forecasting, and allocation• Collaborated with product team and sales team to streamline processes for businesses, using tools like VBA Macros and Python for inventory and demand insights• Analyzed deeper relationship between the product brand and price sensitivity to adjust productlisting price and promotion strategy

• Home Rehabilitation Projects: Prepared 3D models and design sketches for multi-family homes using Autodesk AutoCAD, including the Yongqing Fang Renovation in Guangzhou, CN.• Construction Planning: Created specifications, cost and material estimates, and structural drawings for rehabilitation projects.• Quality Assurance: Examined drawings for conformity and errors, and interpreted blueprints to ensure design accuracy and adherence to project plans.

• Structural Designs: Managed BIM projects including Apple Inc.'s California headquarters, utilizing Autodesk AutoCAD and Civil 3D.• Compliance Research: Conducted research on precast concrete per CSA standards, submitting reports for CSA approval.• Fieldwork Experience: Supported design and construction projects through hands-on precast engineering tasks.• Quality CAD Preparation: Prepared CAD files and drawings on time and budget, adhering to client standards.• Innovation in Technology: Programmed TEKLA Open-API applications in C++ and C# to enhance BIM project management.• Process Automation: Created automated MS Excel applications in Visual Basic for the CPCI Precast Concrete Plant Audit Program.