Product Technology Manager
Chicago, Ma
- onboarded Berenberg and Deutsche Bank in the US and Europe, with over 150 published models using the Trefis software- designed and delivered the company’s first model transformation workflow redesign which allowed for user self-service to reduce company support costs and turnaround time for users- designed and delivered Trefis’ model sharing, permission, and management console which was essential to releasing the Trefis product to corporate clients who had to manage model access across multiple teams- delivered the data file uploader and benchmarks database allowing users to overlay data against their model’s inputs and outputs, supporting specific use cases requested by Trefis’ partners- designed and delivered model validation support, a first of its kind technology which can identify anomalies in a user’s spreadsheet model e.g. inconsistent formulas, unexpected results across time periods, outputs.- designed and delivered model analytics, a unique feature allowing a model’s output sensitivities and variances to be calculated for all inputs within the model- delivered interactive grid layout which allowed users to create a narrative for their models to use in presentations and reports- designed and delivered improvements in the logic for parsing excel model data including automated annualization of quarterly and semi-annual data to present an annualized model visualization; and handling of constants where data has become actualized in a forecast model for the purposes of visualization - these allowed the Trefis product to support the more complicated models of corporate clients such as T-mobile, 3M, and Duke Energy.- established Trefis' technical documentation, testing standards, and QA process which greatly reduced defects released into production and established a process for curating defects before developer action