Patrick Serrano Email & Phone Number

Pittsburgh, Pennsylvania, United States

Conduct a segmentation analysis within the under-44 demographic to identify priority segments for targeted marketing efforts.Identify and understand the banking needs and preferences of customers under the age of 44 through detailed primary and secondary research.Conduct research and identify key marketing strategies to target the under-44 demographic more effectively, aiming to boost customer interactions through various channels.Conduct a comprehensive analysis to identify and recommend products or services that align with the preferences of younger customers, aiming to enhance customer engagement.This project was undertaken as part of the coursework for 94-808, Management Consulting, a graduate-level course at Carnegie Mellon University.

San Diego, California, United States

• Lead a team of 12 student researchers in fine-tuning a Llama-2-70b Large Language Model for novel literature review parsing and comprehension. • Investigated advanced techniques in hallucination mitigation, generative clustering, and topic modeling for robust LLM applications.

• Performing high-level market research and financial data analysis to assess potential return on real estate investments, informing key business decisions.• Creating new metrics to score the potential desirability and risk of real estate properties in L.A. County and Orange County areas.• Assisting in creating models to help price our portfolio of different commercial and residential properties.• Conducted extensive data cleansing and preprocessing, significantly enhancing the quality and accuracy of the company's financial datasets.• Delivering high-impact reports and presentations to a variety of stakeholders, breaking down complex analysis into understandable insights.• Regularly monitoring and reassessing investment portfolios, ensuring their alignment with changing market dynamics.

Los Angeles, California, United States

• Creating dashboards to let management understand the seasonality of orders for various restaurants the company owns.• Conducting cost-benefit analyses of future investments and predicting future cash flows• Designing and executing comprehensive digital marketing strategies, driving online presence and customer engagement for multiple restaurants.• Managing inventory by using predictive modeling to anticipate demand and adjusted stock levels accordingly.

San Diego County, California, United States

Covid-19 Modeling• Created applications in Python, Java, and R to aggregate data and created hierarchical models• Web Scraping using Beautiful Soup and Selenium packages with Python• Created deep learning machine models to predict key economic indicators.• Submitted a paper to a high impact Information Systems Conference.

San Diego County, California, United States

Predictive Artificial Intelligence for US Navy• Text Mining using NLTK and other NLP packages in Python• Developing AI models for NLP. Models include k-nearest neighbors, neural nets, k-fold cross-validation, etc.

Los Angeles County, California, United States

• Increased Overall sales by ~20% over the next 8 months through marketing and expanded their online presence• Optimized their supply chain by arranging a Vendor Managed Inventory with their supplier

South Pasadena, California

• Supported the Senior Controller in their daily duties in managing the Finance Department.• Assisted the Underwriter in reviewing Insurance Applications and helped write policies.• Preformed Quality Control procedures on new policies

Master Of Science - Ms, Information System Management (Mism)

CMU is globally renowned in the study of information systems, data analytics, and cybersecurity. CMU is highly ranked in Information.

Bachelor Of Science - Bs, Management Information Systems

Minor, Computer Science