Sam Castillo Email & Phone Number

Northampton, Massachusetts, United States

• Successfully pitched to Amazon Web Services to receive Startups Activate grant.• Created a website using S3, Wordpress, on www.FuturoInsight.com.

Austin, Texas, United States

• Analyzed large-scale travel data related to flight bookings, vacation rentals, hotels, and car rentals, handling data at a scale of hundreds of millions in revenue. Improved long processing time from 3 days to just hours, significantly accelerating data-driven decision making. • Identified global travel trends from over 100 countries, including United Kingdom, Norway, Italy, France, and Spain. Provided actionable insights that informed strategic planning and reporting. • Applied econometrics techniques and survey collection to provide insights to senior management. • Collaborated in agile environment using Jira with cross-functional teams to enhance data analytics capabilities. • Optimized data warehouse with advanced technologies such as Tableau, SQL, Python, and R. Overcame challenges of incomplete data by collecting 30% more data.

Austin, Texas, United States

• Developed educational content on AI and machine learning for business solutions. Enhanced client understanding and engagement, demonstrating strong communication and interpersonal skills. • Utilized social network analysis techniques with data from Facebook and Google Ads to identify new clients. • Applied statistical analysis and mathematical modeling, including customer profitability, insurance demand forecasting, and real estate pricing resulting in 18% improvement in prediction accuracy. • Contributed to open-source community and published an R package on the Central R Archive Network (CRAN), showcasing initiative in developing tools for data analysis. • Used video and voice systems to communicate with customers and manage business operations. Worked with technical writers to create educational content.

Austin, Texas, United States

• Managed large streaming datasets from search analytics, TV metrics, retail sales, and promotions. Supported strategic sales initiatives by identifying key trends in the healthcare sector. • Developed and maintained a data pipeline processing online shopping behavior into a database. Utilized Excel and SQL to curate data and integrate into predictive models.

Austin, Texas Metropolitan Area

• Automated data systems in healthcare using complex SQL scripts, reducing code length by 70%. Enhanced data retrieval efficiency, supporting data-driven decision-making. • Prepared data for AI/ML Initiatives using Python, improving data quality for advanced analytics.

Greater Chicago Area

• Engineered and optimized data pipelines for a dataset of over 10 million individuals. Increased the R-squared by approximately 13%. • Integrated medical data using various coding systems to create meaningful features for AI/ML models. Addressed challenges of sparse data by developing innovative data processing techniques. • Utilized distributed computing to efficiently handle large-scale data processing, optimizing system performance and enabling seamless integration.

Greater Boston Area

Used Rescue, Radar, and Emblem to conduct reserving studies Assisted account managers on $3M book of business for international airlines & hotelsOptimized big data framework and reduced costs by 50%Subject matter expert on predictive analytics tools

Greater Boston Area

Updated reserving analysis for property and casualty insurance companiesPerformed rate-filing reviews for New England carriersCaptive insurance feasability studies for firms located in Bermuda

Boston

Participated in research on health insurance plan design using analytics and machine learningPresented at end-of-internship event about how people with low back pain can reduce the need for surgeryAttended cross-disciplinary mentoring sessions with actuaries and data scientists

Amherst, Ma

Major in MathematicsClasses Tutored: Algebra, Calculus, Linear Algebra, Finance, Differential Equations, AstronomyPart-time peer tutoring (flexible schedule)Led group discussions (1-4 people) using whiteboards and laptopsTutored all undergraduate math courses

Amherst, Ma