Data Consultant
CurrentOngoing data science consultant to ticket broker firm providing data structure builds and analysis on purchasesData Engineering- Designing SQL database schema that reflects RDBMS principles and implementing ETL process to map historical purchase data into schema.• Successfully migrated historical data from dozens of excel sheets into comprehensive RDBMS with multiple tables in 3rd normal form.- Researching and creating API calls to capture, process and store real-time data• Successfully constructing automatic ETL process using SQL and API calls to capture, process, and store real-time data. Data Science- Creating KPI metrics combining processes like purchases, sales, and available credit.• Decisions utilizing KPIs have created thousands of dollars of value in increased profits and savings.• Current projects include: cleaning all historical purchase data, building dashboards for dynamic aggregations of KPI metrics, making statistical comparisons to answer questions about historical revenue patterns using Python data stack