Jonathan Lopez

Jonathan Lopez Email and Phone Number

Software Engineer @ Phase Two Consulting
Moreno Valley, CA, US
Jonathan Lopez's Location
Moreno Valley, California, United States, United States
Jonathan Lopez's Contact Details

Jonathan Lopez personal email

n/a
About Jonathan Lopez

As a Data Engineering professional at UC Riverside, the fusion of data warehousing and ETL processes has been the cornerstone of my role, demonstrated by the development of comprehensive data models and reporting systems. My competencies include data integration, automation, and constructing ETL pipelines, all within Google Cloud Platform's suite of services.The execution of automated query monitoring and alert systems showcases my ability to enhance operational efficiency and supports swift decision-making for executives. Our team's dedication to technical innovation and safety in data-driven environments underpins our mission to deliver impactful data engineering solutions.

Jonathan Lopez's Current Company Details
Phase Two Consulting

Phase Two Consulting

View
Software Engineer
Moreno Valley, CA, US
Employees:
5
Company phone:
+95 1 827 5639
Company email:
contact@cs.ucr.edu
Jonathan Lopez Work Experience Details
  • Phase Two Consulting
    Software Engineer
    Phase Two Consulting
    Moreno Valley, Ca, Us
  • University Of California, Riverside
    Data Engineer Intern
    University Of California, Riverside Apr 2023 - Present
    Riverside, California, United States
    School of Business Dashboard | Freelance Project | Apr 2024 - Aug 2024:Designed and developed a dynamic, user-friendly dashboard using Looker BI tovisualize marketing data for UCR School of Business stakeholders.Created a data model for data integration from UCR SBB marketing reports and usedPython to automate and streamline dashboard reporting and analytics.Query Monitoring System | Freelance Project | Oct 2023 - Apr 2024:Constructed and maintained alerting system using Python, JSON, and GCP includingBigQuery, Pub/Sub, and Cloud Run.System integrated with Gmail API in order to send email alerts detailing query detection.ETL Pipeline | Freelance Project | Apr 2023 - Oct 2023:Built an automated ETL Pipeline using Python, SQL, and GCP including Cloud Storage,Dataflow, and BigQuery.
  • Northwest Mosquito & Vector Control District
    Vector Control Technician 1
    Northwest Mosquito & Vector Control District Jul 2022 - Oct 2023
    Corona, California, United States
    Employed research-based decision making to select appropriate IPM techniques, mitigating the risk of vector-borne illnesses. Leveraged FieldSeeker GIS software to transfer accurate historical data on pesticide applications. Massaged the resulting dataset using SQL to enable me to conduct in-depth data analysis for future treatment planning. Conducted data-supported public health campaigns, targeting neighborhoods identified through the analysis of historical and surveillance data for West Nile Virus prevention. Partnered with field personnel to execute large-scale pesticide treatments, ensuring adherence to protocols and conducting post-treatment testing based on abundance reports.
  • Riverside University Health System
    Sr Lab Assistant
    Riverside University Health System Feb 2022 - Jul 2022
    Riverside, California, United States
    Developed accurate patient metadata and implemented stringent data quality checks, including consistency checks for patient contact information and format validation for dates of birth, to safeguard the database from errors and inconsistencies. Preserved data integrity during the upgrade by conducting comprehensive testing, including bug identification, and verifying the accuracy of patient metadata in the LIMS database, ensuring adherence to regulatory requirements. Skilled in concurrently processing biological samples in multiple sections under BSL-2 protocols, adhering to CLIA compliance and achieving daily testing deadlines while ensuring optimal accuracy.Conducted comprehensive QA testing during STARLIMS updates, efficiently identifying and reporting bugs to facilitate a smooth upgrade process.Responsible for promoting a safe work environment by adhering to chemical safety protocols and maintaining up-to-date Safety Data Sheets (SDS).
  • The Good It Company
    It Support Technician
    The Good It Company Jan 2022 - Jun 2022
    Los Angeles, California, United States
    Delivered exceptional technical support to a remote client base, efficiently resolving service issues and requests via an automated ticketing system.Utilized strong troubleshooting skills to diagnose and resolve common computer system issues, ensuring optimal user experience.Streamlined the onboarding process by setting up user accounts and ensuring access to essential company applications.Provided comprehensive technical support on a broad range of company products, fostering a productive work environment for clients.
  • Northwest Mosquito & Vector Control District
    Laboratory Assistant
    Northwest Mosquito & Vector Control District May 2016 - Feb 2022
    Corona, California, United States
    Utilized data engineering best practices, including data cleansing and validation, to ensure data integrity and accuracy in datasets submitted to the statewide database. Implemented a weekly data migration process to efficiently transfer substantial amounts of data to the statewide database. Conducted data analysis on efficacy studies to identify areas for improvement, leading to the development of innovative and more efficient prototypes. Launched a cost-effective 3D printing program, informed by data-backed cost comparisons of external suppliers and internal fabrication, to optimize supply chains and reduce reliance on traditional equipment.Improved district productivity by developing and delivering training programs to swiftly integrate and equip new staff ranging from seasonal employees to interns.
  • Altura Credit Union
    Member Service Representative
    Altura Credit Union Jul 2015 - May 2016
    2847 Campus Parkway Riverside Ca
  • Altura Credit Union
    Mailroom Clerk
    Altura Credit Union Apr 2015 - Jul 2015
    2847 Campus Parkway Riverside Ca
    Efficiently processed incoming public inquiries and staff mail, including opening, logging, date stamping, and sorting into designated categories for accurate delivery to departments and staff.Utilized various mail sorting techniques to ensure timely and secure distribution.Assisted in streamlining and improving the unit's mail management system for increased efficiency.Received and logged incoming U.S. mail, FedEx deliveries, supplies, and branch bags, ensuring proper processing and distribution.
  • Thousand Oaks Surgical Hospital
    Pacu Assistant
    Thousand Oaks Surgical Hospital Sep 2014 - Jan 2015
    Thousand Oaks
    Provided personalized attention and support to patients during admission and discharge, ensuring a smooth and comfortable experience.Offered emotional support and assistance to patients' families, fostering a positive and reassuring environment during a vulnerable time.Assisted medical professionals by effectively managing clerical duties, including creating patient charts, filing medical documents and time cards, answering phones, and maintaining accurate inventory of medical supplies.
  • Ucr Transportation And Parking Services
    Event Staff
    Ucr Transportation And Parking Services May 2013 - May 2014
    Riverside
    Effectively managed teams of up to 8 members, delegating tasks and ensuring project completion.Collaborated closely with supervisors to ensure project goals were achieved on time and within budget.Prioritized safety by implementing protocols and ensuring a safe environment for both customers and staff during events.De-escalated customer disagreements with patience and professionalism, fostering a positive experience for all attendees.
  • Mt. San Jacinto College
    Theater Tech Assistant
    Mt. San Jacinto College Aug 2011 - Apr 2012
    San Jacinto
    Ensured adherence to strict deadlines in a fast-paced theatrical environment.Contributed to the smooth operation of theatrical productions.Gained proficiency in lighting, set design, costume design, and tailoring.Organized and maintained a system for plays, books, and scripts, facilitating efficient access for staff and artists.Ensured the upkeep and organization of costumes and theatrical equipment.

Jonathan Lopez Skills

Outlook Microsoft Office Microsoft Word Team Management Project Management Microsoft Excel Administrative Assistance Interpersonal Skills Telephone Skills Powerpoint Symitar Calendaring Inventory

Jonathan Lopez Education Details

Frequently Asked Questions about Jonathan Lopez

What company does Jonathan Lopez work for?

Jonathan Lopez works for Phase Two Consulting

What is Jonathan Lopez's role at the current company?

Jonathan Lopez's current role is Software Engineer.

What is Jonathan Lopez's email address?

Jonathan Lopez's email address is j.****@****lth.org

What schools did Jonathan Lopez attend?

Jonathan Lopez attended University Of California, Riverside.

What are some of Jonathan Lopez's interests?

Jonathan Lopez has interest in Health.

What skills is Jonathan Lopez known for?

Jonathan Lopez has skills like Outlook, Microsoft Office, Microsoft Word, Team Management, Project Management, Microsoft Excel, Administrative Assistance, Interpersonal Skills, Telephone Skills, Powerpoint, Symitar, Calendaring.

Not the Jonathan Lopez you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.