Lauren Zessemos

I’m a detail-oriented Database Administrator with hands-on experience maintaining product databases and performing web scraping for data collection. I specialize in quality assurance and data standardization to ensure accuracy and compliance across large datasets. Recently, I went back to school to strengthen my data analytics skills, earning certifications as a Microsoft Office Excel Core Specialist and Tableau Desktop Specialist, along with completed coursework in SQL and ongoing development in Power BI.

I enjoy transforming raw data into insights that guide clear, informed decisions, and am eager to apply my analytical strengths to support data-driven decision-making in a Data Analyst role.

Database Administrator, Jointly, Remote 06/2021-11/2023, 04/2024-02/2025

• Maintained and updated a comprehensive product database, ensuring accuracy and consistency across a large inventory of products.
• Collected detailed product information through web scraping and manual research from verified sources, enhancing the database’s comprehensiveness and accuracy.
• Conducted rigorous quality assurance checks on incoming and existing data in order to uphold naming conventions and product integrity.
• Standardized product names and descriptions in compliance with state-specific regulations and labeling requirements.
• Ensured consistent taxonomy and nomenclature for all product categories, streamlining internal processes and improving clarity for app users.
• Collaborated with cross-functional teams to resolve data discrepancies and streamline workflows, resulting in improved data accuracy and more efficient processes.
• Designed and implemented training materials, including visual guides and product descriptions, to enhance team knowledge and maintain alignment with industry standards.
• Built and maintained an interactive, state-by-state US dispensary directory in Google Sheets using advanced formulas, macros, and VLOOKUP to support Marketing and Sales initiatives.
• Supported administrative and project tasks using Google Sheets, Excel, Confluence, and Jira, improving operational efficiency and cross-team collaboration.

Account Coordinator, CannaContent, Remote 02/2024-06/2024

• Ensured timely project completion through proactive client communication, regular updates, and collaborative problem-solving.
• Built a custom Notion hub to organize client-specific data projects, contacts, meetings, and team roles, streamlining collaboration with Monday.com workflows.

Freelance Administrative Professional, Upwork, Remote 12/2020-03/2023

• Provided comprehensive administrative support to multiple clients by coordinating workflows and streamlining operations, improving efficiency and client satisfaction.

Visual Presentation Lead / PCR, Verilife, Romeoville/North Aurora, IL 07/2018-11/2020

• Developed a system using Excel and pivot tables to streamline menu updates by product type and attributes, improving efficiency.
• Managed dispensary visual presentation, including display cases and marketing materials, enhancing the customer experience.
• Oversaw tracking, inventorying, and display of ancillary items, ensuring accurate stock levels and appealing presentation.
• Coached team on menu, ancillary, and visual maintenance, boosting team efficiency and engagement.
• Supported migration from Bio-Track to NAV POS, ensuring smooth transition with minimal disruption.
• Implemented POS-integrated online ordering system to automate low-stock inventory adjustments, reducing manual errors and improving inventory accuracy.
• Collaborated with back-of-house staff to manage operations, product inventory, delivery intake, and order entry, improving workflow and accuracy.
• Maintained comprehensive knowledge of products and conditions to assist patients with selection, enhancing customer satisfaction.
• Built client rapport through education and advocacy, enhancing trust and engagement.

Trivia Host / Manager, Chicago Trivia Guys, IL 06/2016-10/2020

• Hosted live trivia games at multiple venues, engaging large audiences and creating energetic atmospheres using PA systems and crowd interaction techniques.
• Supported company success by coordinating sales, executing marketing initiatives, and managing administrative operations efficiently, contributing to the company's growth and operational efficiency.

Office Administrator, Hines Building Supply, Wheaton, IL 05/2015-06/2016

• Managed all office tasks, including Accounts Receivable, Payroll, supply ordering, issuing waivers, petty cash, and customer service, ensuring smooth daily operations.
• Coordinated communication with offsite Accounts Payable and HR teams, improving interdepartmental collaboration and efficiency.

Human Resources Generalist, All-States, Inc, St. Charles, IL 09/2010-05/2015

• Managed employee records, benefits administration, and payroll, with accuracy and timeliness.
• Processed and maintained payroll journal entries, ensuring compliance and accuracy.
• Implemented and enforced company policies and procedures, improving compliance and efficiency.
• Updated employment posters regularly to maintain labor law compliance, reducing legal risk.
• Maintained OSHA and worker’s compensation records, ensuring workplace safety compliance.
• Assisted the Safety Committee by organizing meetings and coordinating safety training, improving safety protocols.

Columbia College Chicago - Chicago, IL Bachelor of Arts

Film and Video with a concentration in 3-D Computer Animation

College of DuPage - Glen Ellyn, IL Associate of Arts

General Degree, Graduated with high honors as a Phi Theta Kappa member