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 efficiency;• 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 • 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 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• Designed visual documents for internal developers and clients to faster understand the newly designed system and solve potential issues• Developed a decentralized application, a task management tool, on Ethereum blockchain as a personal research project Show less

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 • 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 daily meeting with team members, and assigned short and long term tasks for each team member.• Performed the regular database maintenance to ensure the usability of the website;• Analyzed the traffic data from Google Analytics to provide management team and project team useful information. Show less

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 • 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 the business plan in visual form and liaised with fund-raising websites to expose business to more investors.• Established the connection with 8 interested investors and secured the opportunity of being invested. Show less

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