Amy Clarke

Contact information

Policing and Criminal Investigation Graduate with Python and SQL skills.

Education:

Highschool:

College:

University:

Policing and Criminal Investigation BSc Hons (2:1)

For my 10,000-word dissertation I:

• Gathered my own data set using a questionnaire and sent it to multiple police forces around the UK.
• Analysed the large data set using both quantitative and qualitative analysis.
• Used SPSS to visualise my findings and portray these to anyone who was reading.
• Took raw data and used the information to spot trends and make predictions.
• Have a lot of experience using Microsoft Teams.

Coding:

Diary

This is a simple HTML and CSS website I created to document each day of my coding journey which I, and others, can look back on to see my progress. This was also created to hold myself accountable to code every weekday.

Amy's Coding Diary

Python

Throughout these courses I have been able to:

• Using many different packages such as: Pandas, CSV, Datetime, SMTP, Requests, BeautifulSoup, Flask, Selenium confidently for pulling and cleaning data sets.
• Used BeautifulSoup to gather my own reviews from Vinted.
• Use PyCharm and Jupyter Notebook comfortably and professionally.
• Find, prevent, understand and fix errors made in my own code and others.
• Read, write and update JSON files.
• Gather data from companies using their API.
• Visualise large amounts of data in Tableau and create interactive dashboards to better show the patterns and trends to other people.

SQL

Skills acquired:

• The ability to create datasets and tables confidently.
• Use a wide range of different functions to analyse large data sets.
• Finding answers to given business questions within large groups of data.
• Analyse my own Vinted reviews to spot trends and patterns.
• Use MySQL Workbench and command line interchangeably, or separately with confidence.
• Select different MySQL window functions to further aid my analysis.
• The ability to join multiple different tables and view them as its own table to make analysing easier and neater. This also uses less code.

Work Experience

Buying and Selling

Online Sales Entrepreneur 650+ sold

2019-Present Day

Overview: I buy items from places such as charity shops, car boots and Ai Express for a low price and resell on Depop, Vinted, Facebook marketplace and Ebay. Items sold usually consist of vintage, in fashion clothing and decorative items. Sales have increased dramatically in 2021-current day. Buying and selling consists of taking professional images with my camera with the correct background to reach the target audience for the items. Research is also done on TikTok, Aliexpress and trending items on Depop/Vinted, taking time to discover which items are popular makes it easier to find, buy and sell items.

Skills Learned:

• Providing accurate answers to questions from suppliers and customers.
• The ability to generate new ideas such as new marketing tactics.
• Independently being able to think and make responsible decisions.
• Putting systems and order in place to ensure routine tasks are carried out efficiently.
• Managing funds and allocating spending effectively and responsibly, ensuring price is beneficial.

Tesco

Sales Person, Christmas Staff

December-January 2022/2023

Overview: My role was to work the tills, help customers and stock the shop floor over the Christmas and new year period.

Skills Learned:

• How to work under stressful and time limited conditions.
• Handling potentially dangerous situations professionally and safely.
• Balancing working full time with learning a new skill (Python development).

Bargain Booze

Store and stock clerk

February-June 2021

Overview: I served customers and worked the tills, including cashing up and closing the store at the end of the night. Keeping the shelves fully stocked and the shop floor clean was also part of this job role.

Skills Learned:

• Dealing with people sensitively and tactfully whilst trying to reach agreements that satisfy different and correct needs.
• Willingness to make sudden changes when unexpected circumstances arise.
• The ability to stay focused and achieve targets when faced with difficult situations.
• Working collaboratively with colleagues to achieve common goals.