Yiqing Geng Email & Phone Number

United States

- Perform Data extraction on a daily basis from multiple servers by SQL querying and provide the data to the cross-functional teams. - Build daily/weekly report/view for program performance and KPI for related agents.- Build SQL query to track any online payment/program issue, and send recommendation to agents for a better communication with borrowers.- Gather the required data and write DAX queries to create relationships, visualizations and build custom live reports using Power BI. - Work with accounting team to generate quarterly incentive forecast, portfolio forecast and current pipeline analysis.- Build unbilled review base on different programs and inform related investors the performance & billing book from prior month. - Operate the 1003 phone consent process for getting more dialable accounts, improve the efficiency of call center.- Meet the team regularly to discuss and identify business problems in customer’s standpoint to serve them better and improve business.

Shenyang

• Extracted thousands of customer and transaction data from last three months’ Excel files provided by the marketing department to conducting marketing analysis.• Utilized VLOOKUP and RANGELOOKUP to analyze consumer preferences for specific products and repurchase rate based on different regions and age groups and suggested the implication.• Cooperated with relevant departments to obtain cross-functional support so as to promote market operation effectively.

Denver

• Tutored students in Calculus III and Introduction to Differential Equations to enhance students’ understanding, boosting confidence in quantitative analysis skills.• Provided weekly group study sessions with designed activities to help students prepare midterm and final exams.

Master Of Science - Ms, Mathematics

Activities and Societies: Graduate Teaching Assistant: Tutor students in Calculus III and introduction to Differential Equations.

Bachelor'S Degree, Mathematics

Activities and Societies: Member of Organization Department(Chinese Student Union, University of Denver )• Organized the workshops.