Daniel Studer Email & Phone Number

Bellevue, Wa, Us

Design and implementation in AWS of a service-oriented platform to improve upon and replace the legacy product serving customer business objects (sheets) in the Smartsheet application. My focus was providing for resiliency and tracability of changes to customer data initiated from the new API. This platform now handles most sheet traffic.Design and implementation in AWS of a serverless application to improve upon and replace the legacy platform linking data between business objects (sheet links). I led the initial design of this new service getting buy-in from stakeholders within the company. Once the project started I led the implementation work as well. The rollout of this service helped us bring sheet link-related service-impacting events down from sometimes dozens in a day (easily the biggest pain point in engineering at the time), to one or two a month if any.Improved operation of the core Smartsheet application by expanding our runbook for various classes of production issue, and continuously adding to our production telemetry, allowing for better insight into and faster resolution of issues when they do occur.Multiple projects on the core legacy application to improve performance and capability, and protect against data loss. We increased various limits on business objects which had been imposed by shortcomings of the legacy system when I joined: for example we improved scalability enough to allow for up to 20,000 rows on a customer sheet, from the previous 5000.Led an effort to migrate some of the highest-traffic tables out of our core database. I identified the steps to take in production to complete this work successfully and without downtime, and implemented the changes to the product needed to facilitate the move. This effort was very successful (we migrated with no production incident or downtime) and as such, has subsequently served as a template for several similar efforts against other high-traffic tables on that database, in the years since.

New York, Ny, Us

Development of the client reporting solution for the Japan westbound business (domestic clients trading in overseas markets). Implemented new features and patched numerous defects which had been holding back the business before I joined, resulting in a doubling of revenue and enabling the business to onboard half-again as many clients, in my first year with the firm.Integrated the reporting solution for the westbound business into JPMorgan's global front and middle-office reporting tool. Upon completion, a single full-time employee now manages this part of the business (compared to three and a half when I joined).Development of the global allocation and order booking platform rolled out in Japan in 2015. Decommissioned Japan-specific platforms for order booking and client reporting, for the domestic business.Added functionality to Apache POI to encrypt older Office documents (versions 2003 and earlier) in conformance with the Microsoft RC4 CryptoAPI standard, a feature missing from the publicly-available version of POI. This fork of the project is now used by several applications at JPMorgan.

New York, Ny, Us

Development of order booking and allocation platform.Worked with business users of the system both locally and remotely to design and implement new features and resolve issues.Improved our product’s utilization of Morgan Stanley's proprietary JXB application framework. Refactored the existing codebase away from the deprecated JXB Flows paradigm, easing code readability and static analysis.

Six-month term as the business in Japan wound down.Development of the execution management platform: order monitoring, order management GUI, Bloomberg terminal interface.

Tokyo, Tokyo, Jp

Mizuho Securities (Software Developer)Application developer on the client’s front-office trading product, focused on adding more robust support for order routing globally.Mizuho Securities (Business Analysis)Analyzed requirements and deliverables for a test harness for the client’s high-frequency DMA proof-of-concept.Nikko Citigroup (Software Developer)Application developer on JASDEC-initiated stock dematerialization project (paperless trading).Designed and wrote the codec for packets sent to and from JASDEC, for dematerialization.