Kyle J Ho

Kyle Ho DATA ANALYST - Portland, Oregon Linkedin Tableau Portfolio I am detail-oriented, self-directed, curious analyst with a growth mindset. I have spent the past few years using those analytical skills to help a technical department optimize and I am looking to bring that attitude and success forward. I am comfortable with SQL, Python, MS Office and Tableau. Skills Tools and Technologies: Excel (pivot tables, visualizations, statistical analysis, dashboard construction), SQL (writing queries, joining tables), Tableau, Python (pandas, seaborn, web scraping, NumPy), MS Office Approaches/Methods/Techniques: data cleaning, data discovery, data exploration, data modeling, presentation design, A/B testing, statistical analysis, dashboard construction Experience Thinkful Data Analyst ● ● ● ● Portland, Oregon Mach 2020 - Present Performed statistical analysis within excel and python. Created dashboards in excel and Tableau. Utilized SQL to join multiple databases. Performed A/B tests, correlation testing, and used statistics to determine confidence levels. Excel and Pivot Table Analysis: ● Wrangled information spread across several worksheets made up of over 100,000 transactions across 50 locations into a single page using VLOOKUP. ● Identified the weakest branches using pivot tables. ● Identified the 400 cars losing money year over year saving over $200,000. SQL and Tableau Analysis and Visualization: ● Using PostgreSQL I created an excel worksheet that published metrics for each car released in the US from 1984 to the present. ● Identified the cars with the modern cars with the lowest upkeep. ● Constructed visualizations in tableau to explain the difference between different models. Python Scripting and Visualization: ● Wrote a python script that pulled descriptive information on 20K machines across 1,200 separate bars and arcades, within 70 markets. ● Wrangled those records into a pandas dataframe to allow easy exploratory data analysis and visualizations in seaborn. ● Attempted to prove that pinball machine density could be correlated to crime in a city. Columbia Distributing Lead Draft Technician ● ● ● ● Portland, Oregon October 2015 - Present Streamline annual reports using Excel and Zoho’s suite, for special events, routine maintenance, and new installations. Oversee a team of 2 direct reports: including scheduling, monitoring effectiveness, accurate billing, and other miscellaneous duties. Provide a hands-on technical introduction to new sales staff. Quote, order and install complicated draft beer systems in the metro area. Education University of North Carolina at Asheville BA Mathematics - Pure ● Magna Cum Laude ● Recipient of 2011- Joseph M. Parsons Scholarship Graduated 2011