Andrew Vance
Work Preferences
RemoteIn-PersonHybridOpen to roles
💪Skills and Strengths
My Neuro-exceptional talent
My neurodiversity gives me a unique way of thinking about problems and allows me to think outside of the box when looking for solutions. My mind has always been driven by finding answers to unambiguous questions. Along with how my mind thinks, my neurodiversity also allows me to work well under pressure, having found that tight deadlines and structure allow me to work my best. And while I have found that I work the best under pressure, that does not mean it is the only environment that I work well under. My mind is very adaptable in the way it thinks as well as the environment I work in, leading to a very "go with the flow" work style.
Technical Skills
Python
Intermediate
Intermediate: I can independently use this tool or own a project, but I have to learn more to master this tool fully.
Tableau
Intermediate
Intermediate: I can independently use this tool or own a project, but I have to learn more to master this tool fully.
Microsoft Excel
Advanced
Advanced: I am an expert with this tool, I am competant mentoring others as well as leading projects.
GitHub
Beginner
Beginner: While I've used it before, I require consistent guidance or mentorship to use this tool fully.
Top 5 Soft Skills
AdaptabilityWorking Under PressureStrategic ThinkingLogical ReasoningCritical Thinking🧠Inclusion Essentials
Environments I'm comfortable with
🚀Experience
Check out my work
Worked for 8 months from Jun 2021 to Feb 2022 Jun 2021 Feb 2022 8 months | Data Analytics Fellowship - Springboard Analyzed airline data to determine ways to increase airline efficiency by looking into the causes and impacts of flight delays producing data cleaning techniques and preliminary analysis using Excel Produced final analysis and visualizations with Tableau finding Airlines experiences the most delays, influenced by a larger than average ration of late aircraft delays to overall delays ● Researched pulsar dataset to predict pulsar classification through the creation of alogarithmic regression model ● Conducted initial analysis using Python including libraries such as Matplotlib, Seaborn, Pandas, and NumPythat created logarithmic regression model to predict classification using the Statsmodel Python package ● Visualizations were created using Python and Tableau providing analysis which concluded variables Excess Kurtosis and Skewness have the highest correlation to classification ● Regression model successfully predicted pulsar classifications with an R-Squared value of 0.71 |
Working since Mar 2021 Mar 2021 Current | Marketing Administrator - Meacham/ Oppenheimer, Inc ● Increase company’s industry visibility through successfu lmarketing campaigns expanding toi ndustries and businesses regionally ● Communicate with real estate agents to create a marketing strategy for each listing producing marketing materials and emails for featured properties |
Worked for 1 years, 0 months from Jan 2019 to Jan 2020 Jan 2019 Jan 2020 1 years, 0 months | Assistant Video Editor - Grokker ● Maintained company’s monthly video schedule by producing featured video packages using Adobe Premiere ● Created XML metadata for delivery to top SVOD platforms including Roku, Comcast ,and Amazon and increased subscriber engagement by creating video content for marketing campaigns Extensible markup language XML |
Worked for 2 years, 0 months from Jan 2018 to Jan 2020 Jan 2018 Jan 2020 2 years, 0 months | Production Assistant - KSBW Ensured smooth onset operations to deliver clean and professional broadcasts to viewers through floor directing and camera operation ● Delivered timely video packages to producers for quick production and broadcast planning |
🎓Education and Credentials
Attended for 28 years from 2022 to 2050 2022 2050 28 years | Data Analytics Certification - Springboard Certificate |
Attended for 14 years from 2021 to 2035 2021 2035 14 years | Business Intelligence Analysis Certification - UC San Diego Extension Certificate |
Attended for 10 years from 2021 to 2031 2021 2031 10 years | IBM Data Analyst Certification - Coursera Certificate |
Attended for 4 years from 2012 to 2016 2012 2016 4 years | San Jose State University Bachelor's degree - Cinematography/Film/Vide Production |