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 modeling suite used in client demonstration to pitch for projects• 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 • 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 modeling suite used in client demonstration to pitch for projects• 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 to understand trends and outliers, and experimenting with various forecasting methodologies such as regression• 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 substantiate the models Show less

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 • 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 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 • 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 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