skills john smith johnsmithgmailcom jonsmithcom githubcomjosmth languages sql python java powershell javascript visual basic matlab data alteryx dbt mysql mssql tableau ssrs power bi experience etl developer company remote mar 2022 present supported senior dbas onsite server migration bulk scripting frontend reporting backend connection files reviewing security models refactored 30 sql stored procedures optimizing queries adding relevant documentation correcting business logic reflect new manufacturing processes consolidated data pipelines optimize reduce redundant server traffic increase maintainability improve sql server job runtime supported internal ticketing system committing business logic changes existing data pipelines communicating customers maintaining internal configuration tables reduced errorprone config managing process reduced manual attention needed 15 hoursweek automating 90 config table alignment external customer data maintained data pipelines transfer 1mm records 10 minute cadence support tactical strategic operational business decisions data analysis engineer company b city st june 2021 feb 2022 automated 100 hoursweek business processes using python visual basic scripts sql alteryx implemented operations improvement tool data mining script generate daily kpi reports plant superintendents used debrief shift changes produced sites first machine learning model alteryx predict quality based operating conditions prevent loss profit opportunity 40mday built tableau dashboards make advanced process control footprint missed target kpis plant feedstock datadriven basis develop continuous organizational improvements process engineer company ccity st aug 2019 may 2021 established processing project upgraded lowvalue plant feedstock resulting 5mmyear profit eliminated 50 hoursyear manual data entry analysis automating longrange planning lrp process integrating vba existing business processes investigated viability projects designing process studies collecting analyzing plant data establish strong business case investment education state b university coursework computer science state university bachelor science chemical engineering feb 2022 may 2019