Daniel Lee Email & Phone Number

Berkeley, California, United States

- Spearhead the multi-phase migration of 520k titles from SMP Press to the new ArrangeMe platform - completing 1 month ahead of deadline- Refactor critical fulfillment and email systems using an event-driven pub-sub (AWS SNS, SQS, Lambda) to improve performance and reliability and to reduce costs- Upgrade legacy architecture (monolithic Rails apps) to microservices architecture (Docker, Faktory, AWS SNS/SQS, Lambda, MongoDB)- Develop internal APIs to facilitate the importing and processing of catalog meta data and media- Build features that utilize asynchronous background processing of meta data and media assets to reduce the time products are made available on our e-commerce site from 7+ days to within 24 hours- Develop and upgrade components in the Page Designer of the Salesforce ecommerce platform to meet the needs of our Marketing and Merchandising users- Collaborate with Lead Designer in implementing UI design changes of the platform rebranding- Collaborate with cross functional teams, including Product Managers and stakeholders to ensure the smooth delivery of features and projects

Berkeley, California, United States

- Design and implement our copyright watermarking feature for all digital products by integrating third party PDF libraries (ghostscript, prawn) - Refactor the SMP Press search tool to optimize search results for over 1 million titles- Develop front end UI tools that support Catalog Team in publisher updates and data facetization- Implement database design best practices for performance and to ensure data integrity- Write Ruby ETL scripts to migrate data from spreadsheets, CSV files, and legacy databases- Write MySQL stored procedures to provide efficient reporting solutions- Champion strong test coverage, resulting in 90%+ test coverage in all applications- Participate in code reviews to ensure good quality commits

Toronto, Ontario, Canada

- Design and build dashboards that effectively display key business metrics- Assist clients in troubleshooting performance, functional, and design issues.- Write custom SQL/shell scripts to increase functionality in client dashboards.- Serve as primary QA Analyst for numerous OLAP features in Dashboard 4.0.

San Francisco, California, United States

- Collaborate with 2 senior developers to create a new Cerebro Research Database to store brain imaging data.- Enhance database functionality by creating user-friendly reporting tools, such as Excel data import and export feature, and Advanced Search Form that allows users to build and execute complicated queries.- Integrate YUI Library to provide highly interactive UI.- Design and implement data import scripts and stored procedures.- Create Perl script query tool for users to conveniently retrieve medical data.- Write scripts to read, parse, and import data from DICOM images into database.- Continued development and maintenance of PCDB and MSKDB.

San Francisco, California, United States

- Design and implement the Prostate Cancer Imaging Research Program Database (PCDB) which supports more than 50 users and stores data belonging to over 4000 patients, 6000 prostate exams, and 1000 tissue samples.- Design and implement database (MSKDB) for Musculoskeletal and Quantitative Imaging Research.- Generate customized SQL reports for physicians and researchers to assist with data analyses and preparation of NIH grant applications.- Maintain research group website using Drupal CMS.