Robert Benkeser Email & Phone Number

San Francisco, California, United States

San Francisco, Ca

San Francisco, Ca

Charlotte, Nc

• Coordinated UAT testing across several teams to ensure that new system functionality complied with the Foreign Account Tax Compliance Act (FATCA)• Created interactive FATCA job aids for the bank’s tax desk

Charlotte, North Carolina Area

• Leveraged my financial knowledge and Excel expertise to develop an Excel tool for sales associates nationwide that will determine whether a loan exceeds regulatory APR ceilings and calculate a rate and point combination to cure the violation. • Gave a presentation on capacity planning to senior executives that used statistical techniques to demonstrate how a pricing policy change would affect staffing.• Automated the production of our monthly pricing policy metrics and control charts through a combination of Excel VBA, SQL, and JMP scripting (JSL)• Supported a senior executive's presentation to China Construction Bank executives by preparing an analysis of the difference between fixed rate and adjustable rate mortgages depending on the movement of the underlying index over the term of the loan.• Overhauled SQL queries within the VBA code of two separate Excel reports to ensure that they captured all pricing policy violations.• Estimated the financial impact of system defects through SQL queries on an ongoing basis.

Charlotte, North Carolina Area

• Presented a nationwide vault forecasting strategy that I developed through statistical techniques, such as correlation coefficients, descriptive statistics, probability distributions, sampling, and data transformation, to senior executives.• Collaborated with the vault forecasting team, the Data, Analytics and Modeling team, as well as third-party consultants to judge the forecasting accuracy of the new forecasting engine.• Presented my statistical analysis of prepaid debit card ATM demand by product to senior executives and recommended marketing point-of-sale usage for problematic products to minimize cash outages.• Created an Excel tool through VBA for the vault forecasting team that used a statistical model to generate customized safety stock levels for vaults.• Automated the nationwide vault data validation process throughExcel VBA code, which saved vault analysts several hours per day.• Enabled the monitoring of millions of dollars of banking center excess cash bybuilding an Access database.

Los Angeles, Ca

• Tutored UCLA juniors and seniors from diverse socioeconomic backgrounds in advanced statistical techniques such as descriptive statistics, probability distributions, statistical t-tests, confidence intervals, ANOVA, correlation coefficients, multiple regression, and factor analysis.• Demonstrated STATA and SPSS programming techniques to students and assisted them in conducting research.

Fresno, California Area

• Spearheaded the creation of a more efficient, user-friendly sales report for use throughout the West Region that reconciled reporting inconsistencies.

Van Nuys, Ca

• Volunteered 300 hours of service to educate self-represented litigants from diverse socioeconomic backgrounds about their legal rights and responsibilities.• Assisted litigants with their legal paperwork, helping prevent wrongful evictions, reduce domestic violence, and provide stability for children caught in custody battles.

Westlake Village, Ca

• Ran a house-painting business that generated $50,000 in revenue.• Managed a team of five employees on multiple job sites.• Monitored revenues, expenses, and labor efficiency to ensure profitability.