Ernie Rico

MySQL Database Engineer at ProspectDB
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Los Angeles County, California, United States, US
Languages
  • Spanish -
  • English -
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Certified Scrum Product Owner(CSPO)
    Scrum Alliance
    May, 2016
    - Nov, 2024
  • M102: MongoDB for DBAs
    MongoDB, Inc.
    Sep, 2015
    - Nov, 2024

Experience

  • ProspectDB
    • United States
    • Advertising Services
    • 1 - 100 Employee
    • MySQL Database Engineer
      • Apr 2015 - Present

      On boarding customers with sampled data tailored to their specific needs, provide count statics that are too complex to be coded by a software program. Customized the database when customers need to join with their own cross references. Post processed the results of the query with a real time validity checking system before giving it back to the customer.Troubleshooted slow queries. ● Used customers suppressions list in my queries and imported data provided by customer into new tables in mySQL. ● Designed tables with unique indexes and query indexes depending on how we can identify rows. ● Updated database with new tables that joined with customers data. ● Worked closely with sales team to gather all information needed to provide the most accurate data available. ● Returned the requested data plus related amendments.. ● In charge of returning samples after the customers were interested in original counts. ● A sample involves exporting the results from the query then running that data through a real time status (LI-checker). ● Formulate outputs as excel including custom coding of excel functions to further aggregate data. Show less

  • CaliContractors
    • Tarzana, California
    • Sales and Customer Service Supervisor
      • Nov 2013 - Apr 2015

      Managed teams of people from sales to customer service, field technicians and fulfillment. Worked with difficult customers, resolve their requirements and finalize sales. Closing jobs with material cost and taking payments. Make sure online reviews were satisfactory. As a Manager I had to bridge communication gaps between customer and technician going out of my comfort zone and learning the technical details. I took what I learned and explained the line items of the cost to the customer and made the project a success. ● In charge of 58 employees which included 8 offices employees and 50 field technicians across 26 states in 45 cities. ● Managed a 2,000 line phone system with heavy traffic of incoming calls. Show less

  • Fire Energy USA Inc.
    • United States
    • Renewable Energy Semiconductor Manufacturing
    • 1 - 100 Employee
    • Account Manager
      • Feb 2011 - Nov 2013

      Maintained old existing clients with fast turnaround on orders from single solar systems to entire business buildings. The full ready to use solar system included electrical drawings, mounting gear, solar panels and inverters. Responsible for providing preliminary design to our in house Electrical Engineer which included customers specifications: size system and roof layout to get appropriate material need to get project the done. ● Manage and establish new accounts supplying full turnkey solar materials. ● We supply accounts from 5 Kw systems up to 10 Mw systems. Show less

Community

You need to have a working account to view this content. Click here to join now