Kristopher Pasillas

Fullerton, CA   |   kris@kris-p.net   |   GitHub   |   LinkedIn

Education

University of California, Los AngelesLos Angeles, CA

Master of Business Administration (Fully-Employed Candidate)Expected Completion: 2024
Bachelor of Arts in Political Science and History2007

Fullerton CollegeFullerton, CA

Completed courses: Computer Science, Calculus, Discrete Math2018

Experience

Destination AmericaCypress, CA

Destination America is a guided travel specialist operating across North and South America.

Yield, Inventory, and Revenue Optimization Data Analyst2020 - Present
  • Leveraged six years of individual customer data to statistically forecast trip region and departure date demand for the contracting and pricing of more than 2,500 departures per year.
  • Designed and built new reporting platform based on Power BI, Oracle, Snowflake, and other technologies, allowing for deeper insight into sales trends and increasing update frequency from weekly to hourly.
  • Spearheaded analysis project of five competitor companies for use in setting departure schedule and designing new products, using Python to automate weekly gathering of data from company websites and integrate into existing data model.
Inventory Management Administrator2017 - 2020
  • Led the release of several key reporting features four months ahead of schedule, providing hourly insight into impact of COVID-19 on departure-level demand and profitability.
  • Developed VBA programs to automate Hawaii product inventory management functions, eliminating the overselling of room allotments and reducing time required from 1-2 hours to 10-20 minutes per day.
  • Achieved a 15% reduction in late cancellation penalties while processing 30% more departure cancellations than previous year.

Resurge International (formerly Interplast)Sunnyvale, CA

Resurge International provides reconstructive surgeries for the poor in developing countries.

International Services and Communications Coordinator2012 - 2014
  • Oversaw annual travel and supplies budget of $250K, reducing expenses by 10% by sourcing reusable materials and leveraging supplier relationships to secure discounts on accommodations.
  • Built and maintained database housing 10 years of patient records as part of ongoing assessment program and future trip development, as well as for use in social media and donor outreach.
  • Streamlined volunteer preparation process for 15 trips per year to nine different countries by contracting with third-party visa specialists and creating a safety and logistics manual, saving dozens of collective hours per trip.

United States Peace CorpsZombodze, Swaziland

Peace Corps Swaziland is an HIV/AIDS-focused partnership with the Swaziland Ministry of Health.

Peace Corps Volunteer2009 - 2011
  • Led the development of libraries at two local primary schools by securing donations of 2,000 books and partnering with the National Library Service to design trainings for teachers and students.
  • Overhauled the records system of the largest HIV/AIDS clinic in the country, in partnership with the clinic’s nurses and doctors, increasing intake efficiency for the hundreds of patients seen per day.
  • Produced a series of video interviews featuring volunteers showcasing their community and the projects they were involved with that have received thousands of views on YouTube from potential donors and future volunteers.
  • Led in-depth dialogues with high school students during weekly life skills classes, covering sensitive topics such as HIV/AIDS, poverty, and gender relations.

Skills

SQL   |   Python   |   VBA   |   Swift   |   Excel   |   Power BI   |   Access   |   Oracle   |   Snowflake   |   Google Analytics
Data Modeling   |   ETL   |   Business Intelligence   |   Data Science   |   Statistics   |   Data Visualization