Andrew Zhang

Experience

• 

  Rural Education Action Program (Stanford University)

  Jun 2019 - Aug 2019

  Data Analyst Intern

  • Examined the current migration patterns of primary caregivers and their babies in northern Shaanxi through qualitative and quantitative data• Designed protocol instructions, field interview scripts, and data collection sheets for counties, townships, and villages in rural China• Interviewed local caregivers about their infant’s future education using Mandarin and local Chinese dialects• Analyzed data to find a correlation between baby migration/environment and health/nutritional complications• Detailed challenges, solutions, and experiences in the field for future survey groups to recreate and improve upon• Traveled alone to various parts of China to conduct the study and integrated into Chinese culture to further understand our environment Show less

• 

  Children's Hospital of The King's Daughters

  May 2022 - Jun 2022

  Information Services Intern

  • Shadowed information service executive board members and analysts and grasped overarching ideas on the company’s structure• Learned from different information system sectors ranging from technical programming to higher managerial tasks• Attended board meetings discussing daily tasks and future activities that run and help the hospital innovate

• 

  Volvo Penta of the Americas

  May 2022 - Aug 2022

  Industrial Sales Intern

  • Created a company market share evaluation for multiple market segments using Power Systems Research data and presented it using Microsoft Power BI• Mapped all the sold North American engines and current dealers to plan for future dealership locations• Established a North American industrial electric dealership standard and its supporting documents to further the company’s product base• Learned the fundamentals of communication in a professional workspace

• 

  Elevance Health

  Jun 2023 - Aug 2023

  Software Engineer Intern

  • Streamlined development processes by automating daily microservice dependency updates for a medical case management platform• Implemented an automated, efficient Spring Batch back-end process to make 100k+ daily case assignments to Model of Care programs for Medicare• Eliminated the need for manual, error-prone dependency updates to 100+ repositories and saved developers hours per day on performing daily bulk case assignments• Explored product management and agile development through discussions with Scrum Masters, RTEs, and Engineering Project Managers Show less

• 

  EY

  Jun 2024 - Jul 2024

  Technology Consultant Intern

  • Recommended several tech stack plans and presented a client deck on low code for a large civilian government agency• Designed and implemented a portal, backend system, and visualizations for government agencies to gauge their AI use cases’ risk and create possible mitigation strategies using Power Platforms• Curated an executive level newsletter sent to an internal EY team regarding a week-long DEI symposium