Edgar Ortega Email & Phone Number

Sunnyvale, Ca, Us

Remote

• Gathering and presenting data on crop breeding programs for planning and logistic purposes• Operating and creating dashboards using BI tools like Spotfire and Tableau• Used Python to create specialized apps to automate the QC of spreadsheets and highlighterrors, transform data to make it compatible with different tools or dashboards, and tobatch/un-batch data as needed by users• Automating yearly LRP revision tasks. Decreased time needed for coworkers to complete their tasks from weeks to hours.

• Worked with 3 other captains to lead a cohort of 20 students in developing their data analytics skills• Taught the following: SQL, Excel, Python, Tableau, Google Analytics• Assisted students with data projects• Mediated meetings/info between small business client and the students assisting them

Redwood City, California, United States

• Advancing equal rights for the Palestinian people through education, advocacy, and support• Using Python/Pandas to analyze natural language data from field surveys• Cleaning and reformatting datasets to be compatible with visualization so ware• Creating data visualization dashboards using Google Data Studio (English & Arabic)• Collaborating with project team to customize and adapt data presentations for varying audiences

San Francisco Bay Area

• Coordinated with a team of 5 to analyze and visualize crime data in San Francisco neighborhoods using Tableau and Python; presenting our findings to 10+ other data professionals• Wrote detailed SQL queries to retrieve required data• Gained actionable insights into COOP’s website traffic data using Google Analytics• Analyzed Facebook Ads data using Excel; used vlookups, pivot tables, slicers, and formulas• Presented to client our findings on digital marketing strategy, customer personas, and branding • Allocated 30+ hours a week polishing skills in data analytics, Python, SQL, Tableau, Excel, and Google Analytics

Redwood City, California, United States

• Assembled tax returns for businesses and wealthy individuals• Used tools such as Excel, word, and Adobe to modify tax returns and facilitate our workflow• Coordinated seamlessly with other team members when tackling larger tax returns• Assisted the company successfully through 4 tax deadlines in 2020

Santa Cruz, California, United States

• Worked in a team of 4 to maintenance aging dormitory buildings• Managed our own time and priorities with minimal supervision• Completed the maintenance for all 7 buildings within 3months• Fixed plumbing, wall scaffolding, broken desk/bed frames, lighting

Santa Cruz, California, United States

• Worked primarily in the Barbary Coast restaurant located within the boardwalk• Utilized customer service skills• Learned to adapted in a varying work environment• Coordinated with different teams to maximize food sales and improve guest satisfaction