John Gabriel Ibarra

**** ******* **.

Riverside, Ca. 92507

626-***-****

acvw78@r.postjobfree.com

EDUCATION

University of California, Riverside 900 University Ave. Riverside, California 92521

Major: Sociology/Administrative Studies: Management Information Systems, 2016

Overall GPA: 3.4 Major GPA: 3.0

East Los Angeles College, 1301 E. Avenida Cesar Chavez Monterey Park, California 91754

Associates of Arts in General Studies: Social & Behavioral Science, 2014

Associates of Arts in General Studies: Natural Science, 2014

RELEVANT COURSEWORK

Financial Accounting 1 & 11

Introduction to Computer Science

Introduction to Business Information Systems

Database Administration

Data Analysis

EXPERIENCE

Applications Specialist Intern (P.T.), OMNITrans, San Bernardino, California 92411 March 2016-Present

Perform system monitoring, analysis and diagnosis utilizing Transit Master Computer Aided Dispatch (CAD) and Automated Vehicle Location (AVL) systems under the Trapeze Intelligent Transportation System (ITS). Assist Applications Specialist in the daily duties of bus flashcard configuration updates, MDT file updates utilizing Transit Master FTP Server and/or physical onboard Integrated Vehicle Logic Unit (IVLU)/Mobile Data Terminal (MDT) system updates, update the transit internal/external announcement files utilizing Transit Master Annunciator/Route Manager, compile multiple performance reports i.e. Off Route Report, DVR Functionality Report. Establish and maintain effective working relationships with any and all company employees, managers, directors and vendors.

Financial Data Analyst Intern (P.T.), West Pak Avocado Inc., Murrieta, California 92563 June 2015-March 2016

Documented the daily, weekly, and monthly sales actuals, sales forecasting, employee payroll and inventory updates. Performed stored procedures, and assisted in company financial data analysis for up to date inventory categorization utilizing Microsoft Visual Studio, SQL Server Management Studio, SQL Server Integration Services and Excel under Oracle database.

Marketing/Database Intern (P.T.), StealStreet.com, Duarte, California 91010 March 2015-June 2015

Facilitated the implementation and monitoring of social marketing via Facebook, Instagram and Pinterest, seasonal and event promotional e-newsletters, through platforms such as Canva, Photoshop, Hootsuite, Tailwind Analytics, Google Analytics and Volusion. Assist in database organization among various vendor merchandise for up to date inventory categorization through Microsoft Excel. Assist in operational order fulfillment via StealStreet.com and Fulfillment By Amazon(FBA) protocols.

SKILLS

I am proficient with Microsoft Office Suite and similar applications. Through my experience with all of my internships, I’ve acquired basic knowledge in T-SQL DML, Microsoft’s SQL Server Management Studio, SQL Server Integration Services, Visual Studio, Excel, Power Point and Access. I also have acquired the basic knowledge and understanding of ESRI ArgGIS Suite and JMP through coursework at UC Riverside. University leadership skills exhibited through UC Riverside Campus Apartment Resident Association. I can speak basic Spanish.

HONORS & ACTIVITIES

University of California - Riverside, C.A.R.A. Family Housing President, 2015-2016

University of California - Riverside, Deans Honor List, 2014

Contact this candidate