Senior Data Analyst

• Jun 2022 - Present

Data Analyst

• Mar 2020 - Jun 2022

Junior Data Analyst

• Jul 2019 - Jan 2020

Analyst at intensive school that tasks students with real world data problems. Companies and government agencies provided data and goal framework. Findings and recommendations were presented for each problem case. Amazon customer reviews analysis. Paper books vs digital book reviews ● Automated building of PostgreSQL database and tables using Python and its packages ● Report built in Jupyter Notebook with Bokeh interactive plots for visualization of findings and hosted on a static webpage Electric scooter data analysis and density recommendations for Metro Nashville Department of Transportation ● Wrangle large datasets for efficiency and data validation with Python pandas ● Plotting and visualizations of geospatial data for presentation ● Added value by recommending optimal scooter ride counts and distributions across Nashville Store metrics analysis and market predictions for Johnston & Murphy(Genesco) ● built functions to automate combinations of split-apply-combine process then communicated logic and reasoning of approach with visualizations using digital illustration software ● Added value by zeroing in on independent variables which had positive/negative correlations with net profit fluctuations Donation patterns and predictions analysis and recommendations for Anonymous non-profit organization during Hackathon Web-scraping data(advertisement, employment, weather, etc.,) for EDA **Some of the work mentioned can be accessed directly by the links below** Python, GIT, PostgreSQL, Excel, Tableau, PowerBI, Jupyter Lab/Notebook, HTML, CSS, JavaScript Show less

Quality Assurance Specialist

• Jun 2015 - Nov 2018

Akzo Nobel, Nashville TN - Quality Assurance/Product Analysis Work as a quality assurance lab technician for a powder coating manufacturer. Test sample particle sizes, test sample color spectrum and gloss. Cross examination of results against product standards lets us know which components to add or remove and which adjustments to make on the floor. Extensively manipulate corporate SAP software and excel to log and analyze QA product testing data. Recording, analysis, and storage of: • product sample color and refraction data with spectrometer hardware and software • particle sizes and textural data using particle measurement systems • chemicals analysis data of sample using X-ray fluorescence (XRF) spectrometer Using SAP software to run analysis on data collected Added value by correcting product chemistry and particle size during real-time production through visual and numeric representation of the data Excel, SAP Show less

Air Purification/Smelting Operator

• Aug 2011 - Sep 2015

Led and trained teams in the art of maximizing production output safely. Attention to streaming real time data from the production floor allowed for optimal reaction times to bottlenecks in the production process. Collection and analysis of production data allowed for optimization of equipment. • Maintained air filtration systems by collecting samples and analyzing ratios of pressure, airborne pollutant and particulate matter within them. Stored analysis data of samples on company database with detail and care as the EPA frequently audited. • Retaining output data of industrial voltmeter readouts of the hall-heroult smelting units and real-time kg/hr production rates • Provided value by adjusting production and environmental equipment based on analysis of historical data • Operated cranes and heavy equipment Excel, SAP Show less

Sales Analyst/Customer Service

• Aug 2006 - Feb 2011

Maintained hardware and software POS systems and data collection. Emphasis on safe storage and transfers of sensitive customer data. Provided reports on weekly performance. Assisted with customer service. • Optimized staffing and services by collecting historic company data, analyzing, and reporting on it monthly • Planned and set up business POS systems hardware and software architecture • Business setting interpreter Russian/English for a large Russian client base in the Sacramento area Show less