Samuel Farris
Senior Business Analyst at HopperBlue LLC- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Thai Professional working proficiency
Topline Score
Bio
Credentials
-
Tableau Desktop Specialist
Tableau SoftwareFeb, 2019- Nov, 2024 -
Statistics and R
edXFeb, 2018- Nov, 2024
Experience
-
HopperBlue LLC
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Senior Business Analyst
-
Jun 2022 - Present
Hopper Blue is a small consulting firm that works with Cisco, Lenovo, Meraki, Dell, and Microsoft. • Cisco – Verizon data alignent and matching 25k accounts. Created an app to visualize the matching• CDW - Nutanix matched data alignment for sales synergy
-
-
Business Analyst
-
May 2019 - Apr 2023
Hopper Blue is a small consulting firm that works with Cisco, Lenovo, Meraki, Dell, and Microsoft. • Cisco – Lenovo two-year sales flow for all of Americas for YoY analysis ◦ Extracted, cleaned, and matched sales data using, fuzzy matching, MS Access queries, and SQL Server ◦ Created and maintained a database (1.05M unique points) for Tableau analysis and bookings reports ◦ Designed and maintained dashboards and workbooks for executives to analyze sales flow between segments• CDW (Canada) - Lenovo - SHI - Meraki Renewal scorecard workbooks for sales managers◦ Matched sales data between CDW and partner vendors (18 months of sales data)◦ Created a raw and weighted score cards◦ Planned and made, clear and concise workbooks to help facilitate sales opportunities between partners.◦ Analyzed past sales and current pipeline sales to prioritize customers. Show less
-
-
-
Indorama Ventures PCL
-
Thailand
-
Chemical Manufacturing
-
700 & Above Employee
-
Investment Relations Intern
-
May 2018 - Aug 2018
Indorama is a Global 2000 Petrochemical Company - Data Visualizations for management discussion and analysis (MD&A): • Analyzed data from 2012-2018 (80,000 observations), formatted and cleaned for Tableau • Using Tableau created and designed executive dashboards. Elements included: bar, bullet, pareto, pie, and sunburst charts; heat and tree maps; and scatter plots. Analyzed EBITDA, ROCE, and production. Output was used in quarterly reports for investors - Report Writing: • Translated and summarized Institutional investor reports from Thai to English. Assisted in writing MD&A • Updated production capacity forecasts for quarterly reports Show less
-
-
-
National Security Education Program
-
United States
-
Higher Education
-
1 - 100 Employee
-
Boren Fellow
-
Sep 2017 - Aug 2018
Awarded a Boren Fellowship for studying advanced Thai language at Chulalongkorn University. This program is through the National Security Education Program (NSEP). While there I was able to increase my American Council on the Teaching of Foreign Language (ACTFL) level from 2+ to 3. In addition, I worked as an investment relations intern at Indorama Ventures. Awarded a Boren Fellowship for studying advanced Thai language at Chulalongkorn University. This program is through the National Security Education Program (NSEP). While there I was able to increase my American Council on the Teaching of Foreign Language (ACTFL) level from 2+ to 3. In addition, I worked as an investment relations intern at Indorama Ventures.
-
-
-
Bangkok Christian College
-
Bangkok Metropolitan Area, Thailand
-
Math Teacher Grades 5 and 6
-
May 2015 - Aug 2016
Bangkok Christian College – Established in 1852; the oldest private school in Thailand • Created engaging math curriculum for all of grade 5 and 6 • Presented at parent conference innovative programs being introduced into the classroom • Evaluated students’ performance and provided feedback to both the parents and students Bangkok Christian College – Established in 1852; the oldest private school in Thailand • Created engaging math curriculum for all of grade 5 and 6 • Presented at parent conference innovative programs being introduced into the classroom • Evaluated students’ performance and provided feedback to both the parents and students
-
-
-
Farris Huong Export Import LLC
-
Phnom Penh, Cambodia
-
Co-Owner
-
Mar 2014 - Dec 2015
Exported and sold handmade Cambodian scarves • Managed all aspects of starting a business in a foreign country: registration of company in Cambodia and the US, planning and executing our business plan, tax registration, export licensing, creation of an e-commerce website, delivery and production of goods, field research of various products, and marketing • Developed and created Khmer Youth Education Fund, an NGO registered with the Cambodian government, that used proceeds of scarf revenue to help poor rural students afford school fees and uniforms • Assisted over 500 students in Kamchay Mear province in Cambodia through a planned partnership with local village leaders • Managed and trained a team of two Cambodian employees Show less
-
-
-
Thai Christian School
-
Bangkok Metropolitan Area, Thailand
-
Math Teacher Grades 4,5, and 6
-
May 2014 - Apr 2015
• Created engaging math curriculum for all of grade 4, 5, and, 6 • Evaluated students’ performance and provided feedback to both the parents and students • Created engaging math curriculum for all of grade 4, 5, and, 6 • Evaluated students’ performance and provided feedback to both the parents and students
-
-
-
HopperBlue LLC
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Part time consultant
-
Oct 2012 - Dec 2014
Hopper Blue is a small consulting firm that works with Cisco, Lenovo, and Microsoft. • Analyzed and validated (using logic tests) clients’ data and creating pivot tables • Extensive use of advanced excel data visualization to help clients analyze sales data Hopper Blue is a small consulting firm that works with Cisco, Lenovo, and Microsoft. • Analyzed and validated (using logic tests) clients’ data and creating pivot tables • Extensive use of advanced excel data visualization to help clients analyze sales data
-
-
Education
-
University of Michigan - Rackham Graduate School
Southeast Asian Studies, Thai Language, Southeast Asian Politics -
Chulalongkorn University
Thai Language and Literature -
Whitman College
Bachelor of Arts, Economics -
CIEE Cambodian Studies
Cambodian history, culture and regional geopolitics -
City, University of London
economics -
Francis W. Parker School