Experience

Keyri

• United States
• Computer and Network Security
• 1 - 100 Employee

• Full Stack Engineer

  • Jan 2022 - Present

  Full stack development with an emphasis in server side architecture and API build out. Full stack development with an emphasis in server side architecture and API build out.



BBVA Compass

• Full Stack Application Developer

  • Jun 2013 - Dec 2021

  • Responsible for the creation, oversight, and betterment of the bank’s cloud based Third Party Risk Web Application • Built with Bootstrap, Node.js, MySql, MongoDB, ASP, and PHP with API integration points into JIRA and Google (Gmail)• The application coordinates efforts between Vendor Risk Management, Procurement, and Line of Business users to ensure due-diligence is performed for vendor selection and purchase request fulfillment; and quantify the bank’s Third Party Risk to senior management and external regulators. Currently being used by 230 unique users per month• The application features user rights management and verification, customized e-mail reminders and reports, excel reporting, API integration points, and a custom easy to use extract-transform-load process with robust data integrity checks, error reporting, and fail safes, for importing data from core systems• Worked on several efforts to automate manual bottlenecks in retail loan origination through the integration of Third Party API calls, SQL Server, MongoDB, and PHP. Total cycle time dropped 2.6 days after full roll out and implementation• Worked with Line of Business to develop reporting needs, build queries, and create a custom cloud-based dashboard application replacement for MicroStrategy using Backbone.js, D3.js, and Bootstrap to understand throughput and bottle necks of the Commercial Loan Origination program• Developed full-stack web application in Node.js and MongoDB to aggregate information from asset managers and underwriters for 2014 European Central Bank Audit. The application incorporated task completion reporting, audit logging, and the ability to export results to excel for ad-hoc reporting Show less

• Database Analyst II / Application Developer

  • Aug 2011 - Jun 2013

  • Built screen scraper in Ruby to extract data from uncooperative third party vendor to load into database for later analysis and reporting• Created MySQL database backed, Microsoft Access Front end application to manage collateral document warehouse inventory. Was responsible for the design, maintenance, customization and reporting responsibilities associated with it• Built numerous ad-hoc web applications to assist in the collection of data from Relationship Managers for the execution of ongoing Note Sale initiatives. Was nominated for employee of the month on first iteration for decreasing the information collection phase of the note sale by 6 weeks from the prior sale. Automated the 4th iteration of the web-application creation by incorporating mongoDB• Created web application to assist with the monitoring of tax and insurance compliance of BBVA Compass’ portfolio of distressed real estate assets• Performed ad hoc queries and analysis requiring extensive excel capabilities, SQL manipulation, quantitative analysis, and miscellaneous scripting abilities Show less



Berkadia Commercial Mortgage LLC

• 1 - 100 Employee

• Operations Analyst

  • Mar 2010 - Aug 2011

  • Worked with S&P, Fitch, and Morning Star Ratings Agencies; Investors, Senior Management, Asset Managers, and other end users to quickly and accurately provide, model, aggregate, and interpret business critical information • Substantial ad hoc Microsoft SQLServer database analysis • Collaborated with internal compliance and asset administrators to develop Web based, SQL driven Cognos reporting applications • Was responsible for creating, updating, and maintaining accuracy for presentations given to ratings agencies and investors • Streamlined the production of monthly excel based business reports through efficient VBA and formula utilization • Developed a versatile Visual Basic function to accurately model the effects of Waterfall Principal Pay down, Loss Corrosion, and ASER Recovery on variable sized debt stacks Show less



Fresenius Medical Care

• Germany
• Hospitals and Health Care
• 100 - 200 Employee

• Operations Analyst

  • Oct 2008 - Mar 2010

  • Was responsible for modeling, analyzing, compiling and various sources of information to project the future cash flows, IRR and other financial metrics for potential facility openings, relocations, closures, and other capital intensive endeavors for committee • Maintained, streamlined, and distributed a battery of excel financial reports to assist field operators maximize their area’s performance, and alert them to potential issues and opportunities • Responsible for the quarterly modeling and forecasting of primary revenue drivers on a Division with $2 Billion per annum in net revenue • Oversaw the development, performance, and accuracy of the month end close flash model; and performed forecast variance analysis, reconciliation, and contributed commentary where necessary Show less



KeyBank Real Estate Capital

• United States
• Banking
• 1 - 100 Employee

• Account Manager

  • Nov 2007 - Oct 2008

  • Compiled and modeled financial information on underperforming loans to quickly demonstrate the cause of performance issues for executive management • Modeled cash flows of underperforming properties in excel to demonstrate the effects of waterfall debt structure across multiple levels of mezzanine debt, LIBOR, complicated legal documents, and to show the amount of revenue required to prevent the loan from defaulting• Modeled the performance of loans in excel to assist executive management in determining the feasibility of complicated loan modifications• Oversaw all loan level transactions on a portfolio of 549 CMBS loans valued at $2.886 Billion consisting of office buildings, retail centers, industrial parks, and multi-family complexes• Maintained borrower compliance for all loan documents by reviewing mortgages, promissory notes, leases, and pooling and serving agreements• Reconciled multi-million dollar escrow accounts and disbursed replacement reserves in accordance with mortgage imposed constraints and budgetary requirements Show less

• Surveillance Analyst

  • Jan 2007 - Oct 2007

  • Performed financial analysis of operating statements and rent rolls for a portfolio of over 1,200 commercial real estate loans informing investors of significant performance issues • Monitored operating statement variances, communicated with borrowers to clarify unusual revenue or expense items, and notified the asset managers of any outstanding need