Tevin Styles
no image
Tevin Styles

Tevin Styles (470) ------------: Python, SQL, JavaScript, jQuery, CSS3, HTML5, Angular, TypescriptData Analytics: Pandas, NumPy, Ski-Learn, Matplotlib, Tableau, ETLTechnologies: Flask, Web API, Bootstrap, SASS, Web Forms, Json, AjaxDatabase: MySQL, PostgreSQL, SQLite, SQLTools: Jupiter Notebook, Tableau, Visual Studio, Anaconda, Google Developer Tools, PhotoshopSoftware: Google Analytics, Microsoft Office, Excel, Various POS, CRM, Salesforce, G Suite, GIT: ------------/tstyles588EXPERIENCECoding Temple- Data Engineering 2020?Data Analysis, Data Wrangling, and the development of algorithms in Python for data mining and analysis.?Python NumPy, SciPy, Pandas packages to perform dataset manipulation? Responsible for creating/maintaining SQL Queries, Custom Queries, Views, and Stored Procedure's?Gathering a massive amount of data and implementing into BI Tools?Data Analysis and development of algorithms in Python for data mining and analysis?Cleaning up large data sets and performing them in Tableau to predict and present to a client?Proficient using Python, SQL, and data analytics tools such as Panda's, NumPy,Ski-learnAmazon Warehouse Associate, Jefferson, Ga – Logistics 2019-2020?Figure out the return on investment on 750 SKU's given individual costs, profit, product turnaround over specific periods, and capital investment scenarios.?Gathering a massive amount of data and implementing it into B.I. Tools to figure out cost analysis on products?Created SQL queries to assist front-end tools to issue SQL commands matching the business requirements to the report's Data on Providers.?Present results to upper management to help make purchasing decisions based on the results of the data?Pushed/expected to meet quotas and exceed standards dailyRECENT DATA ANALYTICS PROJECTPython Shopping Cart?Using Python and your knowledge of object-oriented-programming, build out auser-input-based shopping cart program. ?Upon Start-up, the user should see a message stating that their cart is empty and that the total price of their cart equals 0.00$. Show the user a list of instructions on how to operate the program.
?Allow the user to add items to their cart by entering the name of the item and then the price that goes along with the said item. As items are added to the cart, each item should be displayed for the user, and the price of the cart should increase depending on what has been added. ?The users should be able to remove items from the cart one at a time based on the name of said item, with the price decreasing based on the price that the user saved for that item, or all at once with the price then returning to 0.00$. ?Once the user enters the quit command, the program should display a check out screen, showing the user the final cart standing, with all items and the new final price.Python Blackjack ?Using Python and Object-Oriented-Programming, make a program that simulates the gambling game of blackjack. Generate a deck with 52 cards, each card is saved as a tuple. Assign each card a suit+name and value based on the tuple indices. Create a "Deck" object that contains the list of tuples which acts as the deck for the game. ?Using an object-oriented-programming, create a Parent "Player" class and two separate child classes that inherit from it. One class for an Artificial-intelligence-dealer and another for a User-input controlled player. Give the Dealer a Class-Method that randomly deals a starting hand to both the Dealer and Player from the deck. Once these cards are removed from the "Deck" object, they can no longer be pulled from it again. ?From there, give the Player the options to hit, stand, bust, and win via blackjack using User-Input. Using If/Elif Python statements, have your programproceed differently based on what the user tells it to do. Pokemon API Project?Using Python, Object-Oriented-Programming, and Web-Scraping, create a program that allows users to fill out a dictionary or Pokedex of dictionaries (Pokemon with different types, abilities, moves, weight, and height). ?Create a Pokemon object-model/class that every Pokemon the user adds to their Pokedex will follow (a dictionary model for filling in different attributes with names and values). Make a separate Pokedex object where you will connect a free online API of data for each Pokemon to pull data for your program for each Pokemon based on their name. This is where Web-Scraping comes into play. ?Once your API is connected, allow the user to input a Pokemon's name (make sure there are no typos, or the program will not run). The User input will serve as the value for your Pokemon's "name" dictionary index and allow the API to pull in the rest of the values to fill out the dictionary. Create one Class-methodfor the Pokedex object that shows all the Pokemon the user passes into the Pokedex and another that sorts them out based on their 'Type' attributes.PostgreSQL Car Dealership Project?Using PostgreSQL, work collaboratively with all members of your team of 10 todevelop a project plan for filling out a SQL Database that represents an imaginary Car Dealership. During this portion of the Project, discuss the best way to set up your Postgres databases. Consider Primary Keys for each table-set and Foreign-Keys that would connect each table and allow them to pull information to and from each other. ?Fill out the database with ten different imaginary customers (create custom data to run queries on). Separate information into 6 different tables. (I.E. Customer Attributes, Car Attributes, Maintenance, and Payment Attributes,), and using Postgres "insert into" statements, create new records for your tables. ?After filling out your database, log out multiple queries to access and manipulate your data.
?Write a transaction that increases the payment amount for a customer if they do not pay on time. ?Write a query that displays the current amount due (current record of the payment amount and ?Write a query that shows all customers with a credit score above 650.Extensive Work w/ Pandas, Numpy, and Matplotlib?Given CSV files, acces and modify data in Data Warehouses as needed using pythons Pandas tool to organize the data into easily readable tables .?Via Data-mining, clean your data by dropping any unneeded rows or columns, changing names in parts of your dataset if need be, and saving any changes made into a new CSV file. ?Use Python Package Matplotlib to visualize your data into graphs and charts sothat it can be presented and discussed. (Use Bar graphs, Scatterplots, Line graphs etc.)?Notice trends and drow conclusions based on your Datasets and discuss and review them with other members of your analysis team.