Loren Lenzen

Experience

• 

  Sigma-Aldrich

  Jan 2003 - Jan 2010

   Reviewed new products against local, national, and international regulations Developed proof of concept for automated compliance review by translating DEA, CDSA, BATF, CWC, and HTS (Chapter 29) schedules to SMARTS queries Worked with the Product Safety group to create 120000 MSDSs by utilizing proprietary QSAR analysis software, internal data, and open source software Created Java and VBA GUI clients that dramatically reduced screening time for above projects  Synthesize over 400 organic fine chemicals in gram to kilogram scale for a catalog of over 40,000 compounds. Provide ideas for process improvement. Develop new synthetic routes and products.  Write preparatory procedures. Participate in extensive safety and ISO training.

  • Compliance Specialist

    Jan 2008 - Jan 2010

  • Chemist

    Jan 2003 - Jan 2008
• 

  Sigma-Aldrich

  Jun 2010 - May 2015

  IT Administrator, Product Information Management

   Administrator of the enterprise marketing database (“CorpBase”) with over 200 active users as a member of the Marketing and IT departments Developed PL/SQL packages, stored procedures, and functions for >100 table Oracle database Made extensive use of SQL, PL/SQL, XML, XSLT, Unix shell scripting, and VBA for database, client, and XML publishing development Administrator of the digital asset management system containing 375,000 images Administrator of the WorldServer translation management system Maintain data for over 500,000 product detail pages, the online product catalog, facets, parametric filtering, and print publications Worked with product line managers to model vendor data for use at Sigma-Aldrich Managed the addition of an average of 75 new products a day by standardizing over 500 transform and load cycles Created 100 product facets as part of an ongoing project to create a specific set of search facets for each product line Created extract models for use in web publishing and the Endeca search engine Created strategy and guidelines for consolidation of marketing master data into SAP environment Created strategy and developed tools for content auditing and curation Chief steward of product information in enterprise system Established data quality standards and data management policies Managed data usage guidelines for print/web publication Managed strategy for print publishing projects Managed project teams around publication projects Provided support for data entry, data migration, and acquisition integration projects Supported customers’ procurement systems by maintaining a cloud distribution system for marketing data Automated common data reporting, data quality, and governance operations Trained in constraint programming and data modeling for the implementation of the Tacton product configurator Show less

• 

  Maritz

  Nov 2015 - now

  Oracle Developer/Analyst