Lan Gao

1. Designed and built enterprise platforms including Inventory Control, Order Tracking, Business Management, and Financial Management systems 2. Architected a custom AI-driven logistics engine that leverages LLMs and the Google Maps API to automate field service engineer routing. This solution optimized dispatch logic for 500+ monthly incidents, achieving a 30% improvement in response efficiency and a 15% reduction in operational travel costs 3. Developed scheduled backend automation using AWS Lambda and CloudWatch to execute nightly batch processing for inventory and data synchronization, ensuring high data integrity across enterprise systems 4. Rebuilt backend payroll and time management systems, optimizing data accuracy and processing efficiency 5. Architected the migration of legacy Jade views to a modern Angular framework, optimizing frontend-backend communication to achieve a 40% improvement in query performance

1. Associated to build a mobile app based on Swift and Node.js, and scaled product for both Android and iOS 2. Created the event tracking plan for the app, implemented events with SDK in the code, and tracked by Segment 3. Tested events and generated data analysis views in Mixpanel, helped the sales team make business decisions

1. Assisted iterations of a data visualization & analysis platform, including maintaining a cache to reduce the request time, and providing users with different data source connections such as databases, files, etc. 2. Developed a Login Center based on the RBAC model and integrated multiple login methods independently, which improved the ease of utilization of the SaaS platform 3. Collaborated closely with the product owner to support argent client requests and maintain development docs

As a research manage deep down into retail industry: 1. Conducted consulting supports to clients including timely communication and proposal for improvement o Provided improvement plan to clients from Shell on sample conditions and recruiting half samples offline in advance. Implementation of this plan resulted in fieldwork time-saving by half o Conducted marketing analysis and provided the recommendation to a client in the food retailing field to adjust the number of competitive brands in a food concept test 2. Responsible for three projects management at the same time o Achieved on time delivery of a database improvement o Introduced Vlookup and time function in excel to draw flow charts for project management, time allocation, and cross-sites communication(India / UK / USA) o Trained an automatic advertising coding platform resulting in a save of the hands-on time by 75% through effective planning 4. Independently designed and produced an online survey 5. Clean up and analyze the raw data o Used SPSS and Excel for data cleaning of 1200+ open-ended answers (error rate < 5%) o Created multiple cross tables using Syntax sentences and analyzed the correlation between indicators and results 6. Conducted market research results analysis and supported clients with feasible strategy plans to make smarter business decisions on brand engagement, product innovation and customer value faster o Proposed changes in an L'Oréal advertisement based on loss of attention, story development and scenes o Prepared and analyzed consumer behavior and attitude survey data on Dyson Air Purifier in support of the identification of targeted customer segmentation for the product overseen

As a research assistant: 1. Conducted subsequent tabulation-related SPSS syntax in data-cleaning achieved 50% efficiency gain 2. Use Tableau to check Disney movies data, rationalize the inspection order, and improve efficiency of interns by 20% 3. Created data visualization for movie box and performance score in different customer segmentations (age, gender, times viewed, etc.) in support of decision-making on campaign spot plan