Data Analyst Python

Celeste Barrios-Cruz

312-***-**** ****************@*****.*** Chicago, IL

PROFESSIONAL SUMMARY & OBJECTIVE

Functional professional experience working directly with clients. Innovative thinker with extensive knowledge of data analysis with SQL, computer hardware, and software. Excellent communication skills to include relationship building, teamwork, and collaboration. Outstanding organization skills, problem-solving, and time management skills. Technical Skills

Programming Language: Python, C++, JavaScript, HTML5, CSS3, TypeScript Web Technologies/Development Frameworks: NumPy, Pandas, MATLAB, Flask, jQuery, AJAX, JASON, BootstrapUI, Angular7.0 Database: SQL, PostgreSQL, SQLite, SQL

Software: Microsoft Office (Word, Excel, PowerPoint), Google Developer Tools Tools/Methodologies: GitHub, GIT, Scrum, Agile Methodology, Agile Software Development, Project Management, Anaconda, Jupyter Notebook, Visual Studio, Software Development, Data Modeler, Tableau Development Projects

NBA All-Star Weekend Challenge: Answer the following questions given the dataset given about the NBA All-Star Game from the year 2000 – 2016.

Capstone Project: Web Scraping a Reddit Page for images of the popular baby yoda images and then inputting that into Postgres database using SQL then using data mining reach insights. Car Dealership: Created an ERD using lucidchart.com. Create a new database using the ERD. The files structure was composed of: the ERD, PDF, SQL code that would be used to create the new database. Weather App: Using live APIs from OpenWeather to allow myself access to the data. I used geolocation to in project was which was incredibly fun as it works in real time. This weather application includes Temperature and Weather Description using JavaScript. HTML/CSS were used to style as needed. Using Heroku I deployed and published the application. PROFESSIONAL EXPERIENCE

Coding Temple, Chicago IL

Data Analyst 2020-Present

• Developed backend applications using Python and Flask.

• Exported/Imported data between different data sources using SQL.

• Experience Object-Oriented Programing concepts with python.

• Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on SQLite, MySQL, and PostgreSQL databases.

• Responsible for Full Web UI Development on several projects using Angular 4 and above, AngularJS, JavaScript, HTML, CSS, third party Angular frameworks, JQuery and JSON.

• Python, NumPy, SciPy, Pandas packages to perform dataset cleansing, manipulation, and analysis Experienced in Python to manipulate data for data loading and extraction and worked with python libraries like NumPy and Pandas for data analysis

• Used Python libraries and SQL queries/subqueries to create several datasets which produced statistics, tables, figures, charts and graphs

• Experienced in designing ERDs for different business models (Database)

• Have experience in Agile Methodologies and sprints experience in a Python-based environment, along with data analytics Good Send, Chicago IL 2020

Application Developer

Using Angular, Firebase and Stripe Documentations I was on a team of one to help a charity GOODsend create a simple web application, which will serve as a portal for Beneficiaries of GOODsend. HTML/SCSS were used to style as needed. The interface should allow visitors to: Join the GOODsend Beneficiary waitlist a. Simple interface where they fill out an initial form, and join our waitlist. b. When they submit their information, they should see: i. How many others may be in front of them in the list. 1. Read the database and display to the Beneficiary how many have already joined the list before them. ii. A confirmation message, letting them know that our team will be in touch with them for next steps of the onboarding process 2. Allow any existing Beneficiary of GOODsend to login and: a. view/edit their personal information b. View their status with us: “Active, Maybe, Waitlist, etc” c. View the value of the current fund (should be live update), and how many beneficiaries are receiving funds from upcoming disbursement. i. We are using Stripe to collect donations. Because of this, we should be able to integrate with our Stripe account, to pull the live information of the fund value and display it here on the portal. d. Show the live update of per beneficiary for the upcoming disbursement e.3. Be notified when a registered Beneficiary updates their information in the portal. 4. Receive an email notification when someone joins the waitlist.

EDUCATION

University of Illinois at Chicago (UIC)

Bachelor of Math & Computer Science - Dec 2019

Contact this candidate