Francisco Yepez Email & Phone Number

Los Angeles, Ca, Us

Rosemead, California, United States

• Served as the single point of contact for all technology-related problems encountered by Panda Restaurant Group associates by responding to incoming telephone, voice mail, email, chat, and in-person requests for assistance related to problems with hardware, software, network, and other computer-related technology• Logged and tracked all calls using the ServiceNow ticket tracking system

Montebello, California, United States

• Responsible for records management, data integrity, monitoring, and maintenance of the EZ-CAP providers database• Performed data cleanup through report analysis, resolving discrepancies and missing information• Developed Python scripts to extract, transform, and load provider data from the National Plan and Provider Enumeration System (NPPES) API to Excel spreadsheets, reducing weekly data cleanup time from 8 hours to 2 hours

Los Angeles, California, United States

• Led the design and development of Python-based ETL pipelines for the data science team, facilitating the collection and analysis of historical stock market data essential for informed stock trading decisions• Developed a batch data pipeline to extract stock ticker symbols from emails and SMS, retrieve stock market data via the TwelveData API, and save results in a Amazon S3 bucket before being loaded into a PostgreSQL database for analysis• Streamlined workflows by implementing automation of ETL pipelines through scheduled Cron jobs, resulting in a notable 50% reduction in manual data processing

Los Angeles, California, United States

• Assembled, calibrated, tested, and repaired robotic end-of-arm tooling• Soldered components on printed computer boards (PCB) based on schematic requirements, saving the company $150 per board on rapid prototyping costs• Took initiative to learn wet lab manufacturing techniques and provided part-time assistance to the laboratory department, saving the company $35,000 in labor costs

Monterey Park, California, United States

• Provided customer service to all Care1st Medi-Cal and Medicare members, associates, providers, and plan partners• Educated members about Medi-Cal, Medicare and Care1st Health Plan policies and procedures regarding eligibility, enrollment, claims, authorizations, and referrals

Burbank, California, United States

• Reviewed health insurance applications for quality control verification and eligibility for various Kaiser Permanente coverage plans

Bachelor Of Science, Software Engineering

Associate Of Science, Computer Programming