Zhenyu He Email & Phone Number

Vancouver, BC, CA

加拿大 英属哥伦比亚 萨里

美国 德州 达拉斯

Greater St. Louis Area

• Led a team of 21 students with 3 sub-teams to provide trading schedule process optimization on both operational and strategical perspectives and perform risk analysis
• Built a linear optimization model using Pulp to increase operational efficiency
• Created a sensitivity analysis table and evaluated the effect on different constraints

Saint Louis, Missouri

• Assisted professor in teaching course by holding weekly office hours, providing assistance on an individual, small group, or class basis, and providing feedbacks to students to improve programming technique and.
• Tutored more than 150 students in E/R models, relational algebra, MySQL, and database normalization.

Greater St. Louis Area

• Provided consultancy services on transforming data from Postgres SQL to MSFT SQL server in the Extract-Transform-Load (ETL) process and data reporting process
• Participated in meetings with different stakeholders, gathering requirements and providing coaching and supporting to existing solutions
• Generated and debugged over 100 python and SQL tasks in the daily DAGs running to Apache Airflow, resulting in the successful DAGs task run rate increase from 60% to 100%
• Decreased data… Show more
• Decreased data refreshing time from 36 days to 4 hours on client’s complex reports among 1964 affiliates by designing and developing cloud reporting system on Azure and PowerBI, with support of MSSQL and PostgreSQL
• Successfully created and applied Row-Level-Security to the report ensuring HIPAA requirements are compiled among all the report viewers

St. Louis, Missouri

• Consultant For: Senior Service, Plus
• Created and managed Gantt chart to project timeline and assign team responsibilities;
• Evaluated the current services provided and corresponding target market capacity;
• Developed comprehensive marketing plan, complete with naming and marketing channel suggestions.

Kansas City, Missouri Area

• Communicated with stakeholders to gather high level requirements and work with team members and managers to determine options for developing projects: Incurator;
• Launched the research and development process for the website: grouppayless.com;
• Researched for competitive websites and develop a high level competitive analysis report to enhance the decision making process of management team;
• Led the project process to ensure the entire project is in good timeliness;
• Held the… Show more
• Held the daily meeting with team members, and assigned short and long term tasks for each team member.

Beijing City, China

• Created lectures to prepare aspiring business students for the GMAT.
• Demonstrated strong interpersonal and managerial skills by tailoring lessons to the needs of each student.
• More than 70% of one-to-one tutoring students gained the test score of 700+.
• Trained colleagues in utilization of training manual with optimum results.
• Awarded “Most Popular Teacher of the Year” for good feedback from students.

Beijing City, China

• Conducted market research based on student resources derived from delivering GMAT lectures at New Oriental Education and Technology to gain a clear view of customer behavior.
• Developed marketing strategy and forecasted income models to estimate growth opportunity of the startup business.
• Calculated profit ratio of investment and rate of investment to analyze company profitability.
• Researched and generated viable business plan to explain the business to investors.
• Recreated… Show more
• Recreated the business plan in visual form and liaised with fund-raising websites to expose business to more investors.

Master Of Science In Business Analytics, Financial Technology Track, 3.94

Activities and Societies: SMP Council

Bachelor’S Degree, Applied Mathematics And Computer Science - Business Management Concentration, 3.8

Activities and Societies: Tau Sigma, UW-Stout Hand Drumming Club, International Relations Club.

Bachelor'S Degree, Public Finance, 3.5

Activities and Societies: Minzu University of China Debate Team

Summer Course, Geography