Gray Guo Email & Phone Number

New York City Metropolitan Area

New York, NY

• Automated production of PowerPoint slides using R, allowing the modeling team for a large financial institution to produce model summary slides for business discussion and review, R code became part of standard.
• Onboarded new data feeds using User Stores to automate a bank’s capital planning forecasts with technology team operating in Sprint cycles and implemented data quality checks to enhance reporting process… Show more
• Onboarded new data feeds using User Stores to automate a bank’s capital planning forecasts with technology team operating in Sprint cycles and implemented data quality checks to enhance reporting process controls
• Developed models using R and Excel for financial products that were statistically strong and intuitive from a business perspective by analyzing over a decade of historical data, interviewing key business stakeholders.
• Constructed robust and adaptable models in Excel for a large financial institution that forecasted balances and revenue over 9 quarters, and executed analyses such as sensitivity testing and back-testing to.

New York, NY

• At a global financial institution, created and tested merge solution between client’s two liquidity databases in order to bypass different adjustment process and unify database for liquidity reporting
• Performed UAT testing on delivered enrichment tags by creating a completeness check that cross referenced 500,000+ of items across databases before approving tags to production
• Wrote SQL queries to perform extraction of relevant subsets of data from a program-wide database, and… Show more
• Wrote SQL queries to perform extraction of relevant subsets of data from a program-wide database, and organized large amounts of data in Excel to allow for convenient filtering and usability Show less

Ithaca, New York

• Used vlookup, index, match, array and offset functions to retrieve specific data points for various analyses
• Implemented dynamic charts, histograms and text with data validation and conditional formatting to create flexible and user friendly models
• Built a structured decision model to determine optimal healthcare plan based on individual income and risk level using one and two-way data tables
• Formulated and solved a portfolio optimization problem using nonlinear programming… Show more
• Formulated and solved a portfolio optimization problem using nonlinear programming models from Excel solver and automated the process by recording macros
• Collaborated with a team of four to create a custom algorithm using VBA to help a fictitious bank find optimal money replenishment schedules for ATM machines Show less

Ithaca, New York

• Analyzed data sets using various supervised and unsupervised learning methods including linear and logistic regression, KNN, decision trees, random forests, and clustering
• Tested the accuracy of different models using cross-validation methods to help decide the optimal amount of model flexibility
• Worked with a partner to create different linear and logistical regression models using twitter reactions of the GOP debate to predict a candidate’s popularity

Engineer'S Degree, Operation Research And Information Engineering With Minor In Dyson Business School For Engineers

Activities and Societies: Pi Delta Psi, Mutual Investment Club of Cornell, Barbell Club at Cornell, CAPSU

High School

Activities and Societies: NHS, FBLA, Science Research, Science Club, Mentor Group Volunteer work, tennis team, track team, SAT mentor