Cesar Lopez Email & Phone Number

Portland, Oregon, United States

• Create, update and manage transit data for clients ranging from small businesses to governmental organizations using General Transit Feed Specification (GTFS) producing software.
• Ensure GTFS data is validated and meets basic compliance standards before being pushed into production on trip planning applications such as Google Maps.
• Use SQL queries and Excel to troubleshoot and make post export modification to GTFS files so the data can be successfully ingested by CAD AVL systems and other real time data tools that track on time performance for.
• Maintain integrity of client's GTFS data through communication on Zendesk, email or using web tracking software such as Versionista to search for schedule changes.
• Provide trainings for clients that are new and current users of GTFS software on best practices of the software to ensure a better overall experience when making updates to their feed.
• Generate website timetable displays, verify timetables have no errors and hand off to websites team to upload into client's website.

• Develop dashboards to display workflows and activity of sales department.
• Mentor tech interns to assimilate and thrive in company environment.
• Use Hubspot and Python to find, import, and assign leads to our sales dept.
• Guide our marketing team on understanding data that is presented to them to make stronger decisions for more effective campaigns.
• Assist the GIS team with creation of markets to better designate leads and information to the teams that can best utilize them.

Portland, Oregon Area

• Use Postgresql to pull data for our sales and marketing teams to search areas of opportunity to acquisition new units and have a stronger market presence.
• Build dashboards using Looker to track trends of current Business Development Representatives and assist with making better business decisions with current and future potential leads.
• Assist Direct Mailing team by helping raise quality of data pulls for executing successful targeted campaigns.
• Use QGIS and CartoMaps spatial software for analyzing and visualizing data on creation, growth and opportunity in New Markets.
• Work with the Real Estate team to track and develop guest experience in Vacasa units as well as areas of possible opportunities for growth of real estate brokerages.
• Use PostGIS database extender to solve location intelligence challenges.

Portland, Oregon Area

• Assisted analysts in providing direction to make stronger business decisions to optimize business growth.
• Worked with QGIS spatial mapping software to give a better guidance to company representatives of market trends in specific regions and how to find better methods to gain a stronger presence in those markets.
• Conducted weekly audits of Sales and Marketing Dashboard to reflect any changes.
• Helped build, find, & define KPIs for relevant & assigned projects

Portland, Oregon Area

• Created targeted lesson plans catered to preparing students for the GED exam
• Led impactful workshops to guide students on to their career path post schooling
• Maintained library database and managed library budget
• Assisted faculty in the supervision of students

Beaverton, OR

• Assisted GIS Manager and Specialists in updating utility maps for the city employees.
• Conducted editing sessions on ArcGIS 10.3 software to query, update, attribute, georeference and digitize previous projects designed by the city engineers on AutoCAD software.
• Used “as-built” models to digitize and update building footprint, water lateral and sewer maps using orthophotos and Lidar maps. Verified updates through use of Google Maps.
• Updated the city’s sidewalk ramp map through visual analysis for recommendations on repairs.

Arcata, CA

• Assisted directors by managing databases containing tram, testing and student schedules.
• Handled confidential information and set up appointments in person, by phone call and email.
• Drove the tram to transfer students and faculty around campus and pick up parcels for directors.
• Assisted students and professors by proctoring exams, note-taking and scribing.

Arcata, CA

• Received and made food orders with a team of student assistants.
• Gained leadership experience by coordinating entire food stations primarily at the peak of business hours.
• Interviewed and trained perspective employees.

Bachelor’S Degree, International/Global Studies, 3.7 Gpa

Activities and Societies: Model United Nations Conference Delegate 2013, Vice President of Humboldt State Lacrosse Club 2012- 2013 (member.

Certificate, Geographic Information Science And Cartography, 3.6 Gpa

This was a one year certificate that allowed students to get an in depth understanding of GIS and how to apply it to real life challenges..