Jorian Merrill Email & Phone Number

Irvine, Ca, Us

Irvine, California, United States

• Spearheaded the development of automated reporting systems for COVID-19, collaborating with four commercial laboratories and numerous state and local agencies, enhancing pandemic response capabilities.• Innovated the automation of laboratory intake processes across three facilities, significantly boosting volume capabilities and accuracy while reducing staffing requirements.• Established and managed a comprehensive patient registration website, integrating automated, HIPAA-compliant state reporting and efficient dissemination of test results to patients.• Oversaw operations as Fractional Vice President of ATCG Laboratory, leading a team of 12, and played a pivotal role in the successful completion and reporting of over 2 million infectious disease test results.• Provided expert consultancy in data management and automation for genetic laboratories, focusing on establishing and optimizing Laboratory Information Systems (LIS or LIMS) for enhanced data accuracy and reliability.• Assisted various organizations in building efficient teams and expanding testing capacities through advanced analytics and business intelligence reporting, ensuring compliance with stringent HIPAA guidelines and requirements.

Irvine, California, United States

• Instrumental in co-founding and establishing Nexsun Diagnostic Laboratories, steering the creation of a new genetic laboratory during the COVID-19 pandemic.• Played a pivotal role in the business planning, sourcing of equipment and personnel, and setting up both the physical and computer systems infrastructure for the laboratory.• Recruited, hired, and led a dynamic team of over 10 scientists and operations professionals, fostering a culture of high efficiency and customer satisfaction.• Designed and executed a state-of-the-art Laboratory Information System (LIS) to streamline commercial laboratory tests processing and provide insightful data to stakeholders.• Conducted extensive trend analysis, inventory management, and reviews of commercial operations.• Developed and deployed bespoke software solutions and data visualization dashboards, enhancing sales and business performance analysis for board members and stakeholders.

Costa Mesa, Ca

• Orchestrated report automation initiatives across multiple business units using Alteryx, PostgreSQL, Google Analytics, pixel tracking, streamlining data processing and reporting.• Spearheaded the analysis of media campaign performance for over 120 clients using advanced analytical tools including QlikView, Tableau, regression, attribution, and financial modeling.• Championed kanban-style process improvements, significantly enhancing the efficiency and workload management of a team comprising 8-10 data analysts and scientists.• Actively identified operational inefficiencies and developed effective solutions, resulting in greater data processing efficiency and improved report quality.• Facilitated team support, training, and mentorship, ensuring high-level strategy and process enhancements were effectively implemented.

Costa Mesa, California

• Engaged as a contractor to pioneer the development of a new data lake infrastructure, leveraging technologies such as Alteryx, SQL, and AWS Infrastructure to enhance business intelligence capabilities.• Played a consultative role across various business units, establishing a foundational data "truth" to guide organizational decision-making.• Designed and implemented multiple Tableau dashboards, providing critical insights into digital marketing performance, as well as tracking physical store inventory and revenue.• Worked collaboratively with leadership and stakeholders to translate complex data into actionable business strategies, ensuring a cohesive approach to data-driven decision making.

Portland, Oregon Area

• Spearheaded data warehousing and master data management initiatives, enhancing data accuracy and usability.• Led contract negotiations and vendor management, optimizing resource allocation and service delivery.• Implemented Kanban and ETL processes, improving workflow efficiency and data pipeline robustness.• Developed strategic data-driven solutions, aligning analytics with business goals for enhanced decision-making.

Portland, Oregon Area

• Launched Portland's first pour-over specific coffee shop, introducing a unique concept in a highly competitive market.• Curated a rotating menu featuring local roasters, contributing to a distinctive and dynamic customer experience.• Achieved noteworthy recognition as one of the "Top 10 Portland Coffee Shops" by Eater Magazine within the first year of operation.• Demonstrated expertise in contract negotiation and strategic planning, ensuring business growth and sustainability.

Portland, Or

• Led market analysis and strategic expansion planning for Knowledge Universe, the largest private Early Childhood Education provider in the U.S., with over 2,000 locations.• Developed and maintained pro forma models, performing IRR and NPV modeling to assess financial viability.• Conducted comprehensive expansion and new site analysis, optimizing retail site selection for growth.• Implemented geo-spatial and market analysis to guide existing portfolio optimization and M&A activities.• Utilized Office Suite, especially Excel and Access, along with Alteryx and Salesforce, to enhance data management and strategic decision-making processes.

Beaverton, Or

Chandler, Az

Business Administration, Finance

Activities and Societies: Arizona State Track and Field team, Decathlon

Associate'S Degree, Psychology