Edgar Zapata

Wichita Falls, TX 940-***-**** ad31za@r.postjobfree.com linkedin.com/in/edgarmzapata54 github.com/ezapez EDUCATION

Midwestern State University Wichita Falls, TX

Bachelor of Science in Computer Science Expected: May 2024 Relevant coursework: Software Engineering, Advanced structures & Algorithms, Spatial Data Structures, Database Management System, Object-Oriented Programming, Comp lang Programming C#, Intro to Cyber Security SKILLS & CERTIFICATIONS

Programming: C++, C#, Python, Java, Javascript, Flutter, Dart, HTML, CSS, VHDL, x86 Assembly, SQL, Liquid CSS Database: Microsoft SQL Server, MariaDB, MySQL, SQLite, Teradata Tools: Docker, Microsoft Azure, Nginx, Splunk, Wireshark, Catalyst, MISP Operating Systems: Linux, Mac OS, Windows

Certifications: CodePath Intermediate Cybersecurity RELEVANT EXPERIENCE

Comcast - Enterprise Data Analytics Intern Remote June 2023 - August 2023

● Employed SQL to clean and prepare 3 million+ data entries in Comcast's Teradata database for analysis, to create a Tableau dashboard

● Utilized Pandas and Seaborn in Python to analyze rate and volume data, uncovering notable patterns for further evaluation

● Designed a Tableau dashboard using cleaned SQL data to showcase metrics on distinct data attributes, offering stakeholders insights on trouble calls

Pierce Arrow Inc. - System Engineer Henrietta, TX August 2022 – June 2023

● Designed a Power Platform calendar app automating HR approval emails, real-time request updates, and dynamic calendar adjustments for approved leaves, simplifying employee time-off requests and enhancing efficiency

● Built System Engineer request form on Power Platform for business equipment and Pierce Arrowhead website issues; integrated into a team channel for employee access, stored data in a restricted-access SharePoint, and automated email notifications for ticket statuses Open, In Progress, and Resolved Pierce Arrow Inc. - System Engineer/IT Intern Henrietta, TX May 2022 – August 2022

● Redesigned and modeled two existing Python automation, to make a more straightforward SQL automation using Business intelligence tools

● Implemented stored procedures and scalar functions for the company's Microsoft SQL Server

● Deployed a Shopify website and created custom code using Liquid CSS and JavaScript to display variant descriptions and lead times for 30 products

PROJECTS

Wordle V1.0 Backed Dev GitHub

● Developed Wordle web app using JavaScript as the frontend to display a Global map

● Built Backend using FastAPI framework to deploy coordinates and outline of countries

● Calculated distance from two countries using python to display how close the user is to the target country

● Utilized: JavaScript, Python, FastAPI

QuizMeApp Flutter Dev GitHub

● Built frontend using flutter to display interface for teachers to create quizzes

● Programmed a login and signup page using Google’s authorization tools

● Configured Backend using Firebase as a database to store Teachers' quiz data

● Utilized: Flutter, Dart, Firebase

Contact this candidate