Kristopher Pasillas

Deliver-ItAnaheim, CA

Deliver-It is a regional shipping company specializing in final mile delivery.

Data Analytics Supervisor2023 - Present

Overhauled operations and finance reporting infrastructure across 12 distribution centers enabling better ability to manage key metrics such as cost/package (10% improvement) and stops/hour (5% improvement).
Developed automated Power BI-based reporting tools for use by finance executives allowing for real-time insight into regional- and individual-level delivery performance essential to company-wide restructuring and 25% reduction in overall costs.

Financial Analyst2022 - 2023

Oversee payroll process for more than 400 drivers including automating daily reporting using Python and SQL Server, achieving 50% savings by reducing time required and proactively flagging employee errors.
Designed Excel-based profitability models for analyzing new customer contracts, ensuring additional volume and service areas meet 40% target profit margin.

Destination AmericaCypress, CA

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

Yield, Inventory, and Revenue Optimization Data Analyst2020 - 2022

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.

Kristopher Pasillas

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

Education

University of California, Los AngelesLos Angeles, CA

Master of Business Administration2024

Bachelor of Arts in Political Science and History2007

Fullerton CollegeFullerton, CA

Completed courses: Computer Science, Calculus, Discrete Math2018

Experience

Deliver-ItAnaheim, CA

Deliver-It is a regional shipping company specializing in final mile delivery.

Data Analytics Supervisor2023 - Present

Overhauled operations and finance reporting infrastructure across 12 distribution centers enabling better ability to manage key metrics such as cost/package (10% improvement) and stops/hour (5% improvement).

Developed automated Power BI-based reporting tools for use by finance executives allowing for real-time insight into regional- and individual-level delivery performance essential to company-wide restructuring and 25% reduction in overall costs.

Financial Analyst2022 - 2023

Oversee payroll process for more than 400 drivers including automating daily reporting using Python and SQL Server, achieving 50% savings by reducing time required and proactively flagging employee errors.

Designed Excel-based profitability models for analyzing new customer contracts, ensuring additional volume and service areas meet 40% target profit margin.

Destination AmericaCypress, CA

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

Yield, Inventory, and Revenue Optimization Data Analyst2020 - 2022

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 | Excel | Power BI | SQL Server | Oracle | Snowflake | Swift | Google Analytics

Data Modeling | ETL | Business Intelligence | Data Science | Statistics | Data Visualization