Andrew Lui Email & Phone Number

San Francisco, California, Us

Purchase, New York, Us

PepsiCo is an American multinational food, snack, and beverage corporation. As a Business Intelligence Engineering Manager in PepsiCo's eCommerce group, I:- Lead the development, strategy, and rollout of new self-service analytics tool (ThoughtSpot) from proof of concept to general adoption for sales, marketing, and supply chain stakeholders- Partner with Product to design tool-agnostic data architecture that combines data from internal and external data sources for consumption by reporting and data science functions- Set standards and best practices for analytics engineering and business intelligence teams by writing best practices documentation and training junior engineers on SQL query optimization (e.g. Snowflake clustering) and dbt best practices (incremental models, defer)- Manage and mentor teams of 3-5 engineers to deliver data and reporting capabilities- Build internal developer tools for data unit and integration testing (dbt test, Monte Carlo) to ensure data quality and report uptime for downstream users as well as faster development

Purchase, New York, Us

PepsiCo is an American multinational food, snack, and beverage corporation. As a Senior BI Developer in PepsiCo's eCommerce group, I:- Lead junior developers in designing and building end-to-end BI solutions across multiple databases (SQL Server, Snowflake). - Set standards and best practices for user-friendly visualizations and scalable data warehouse design to drive decision-making for sales, marketing, and finance teams.- Mentor and teach junior developers in BI best practices for dbt and Tableau.

Purchase, New York, Us

PepsiCo is an American multinational food, snack, and beverage corporation. As a BI Developer in PepsiCo's eCommerce group, I:- Design and build end-to-end BI solutions across multiple databases (SQL Server, Snowflake). - Develop user-friendly visualizations and self-service tools to drive decision-making for sales, marketing, and finance teams.- Gather requirements, present products, and solicit feedback from business stakeholders for continued improvement.

New York, Ny, Us

AIG is a multinational insurance corporation that provides insurance products for commercial, institutional, and individual customers. As a technology analyst for AIG, I:Rotation 2: Warranty Services - Service Genie- Provided AWS administration support (IAM, instance creation) for development of an Alexa Skill (app)- Presented architecture and technical aspects of conversational AI to business, security, and legal stakeholders at bi-weekly sprint demos- Improved speech recognition and intent matching capabilities of conversational AI by managing training data- Wrote 100+ test cases for 10+ user stories; performed QA and UAT on test casesRotation 1: Information Security Office - Monitoring Tools (Splunk)- Coordinated load balancing, networking, and decommissioning requests for 170+ servers across different regions- Wrote Python and shell scripts for server backups and mass editing of configuration files- Used R to analyze platform metadata and create quantifiable metrics for overall platform health- Created and managed dashboards, reports and other visualizations for users across multiple business functions- Wrote, reviewed, and managed documentation (runbooks and other) of internal processes

New York, Ny, Us

AIG is a multinational insurance corporation that provides insurance products for commercial, institutional, and individual customers. As a summer analyst for the Data Solutions team at AIG, I:- Assisted with internal compliance for data governance and standards- Used D3.js to visualize data flows throughout the entire organization- Compiled quarterly data governance reports on all departments for Data Governance team

New York, Ny, Us

The General Studies Program at NYU Tandon offers students who do not meet the traditional admissions requirements with an opportunity to obtain a science, engineering, humanities, and management-based education in a supportive environment.As a research assistant for the General Studies Director, I:- Used R to analyze possible relationships between student success and prescreening factors (SAT, GPA)- Created logistic regression model to predict graduation rates based on categorical and numeric variables- Complied and visualized results, such as boxplots and model summaries, in report to professor

New York, Ny, Us

Herio Capital is a financial technology company focused on providing loans to small businesses. As a summer analyst at Herio, I:- Underwrote small business loans by analyzing credit, cash flows, and other qualitative and quantitative factors- Coordinated with 4 other analysts to manage over 1,200 applications- Used VBA to optimize certain aspects of the underwriting process, such as email generation and data entry

intersective is an education startup that aims to connect students, educators, and professionals and create work-integrated learning experiences through its online platform. This online platform allows student teams to work on projects while being mentored by working professionals and monitored by school administrators. As an Analytics Intern at intersective, I: - Prototyped analytics models to assist administrators in understanding student behaviour - Created SQL statements to gather student information from the platform's database- Analyzed collaboration engagement of 300+ students in 5 different programs

New York, Ny, Us

Palladia is a non-profit that aims to serve the underserved of New York. It offers mental health services, rehabilitation programs, as well as housing assistance for those in need.As a marketing intern at Palladia, I:- Used social media (Twitter, Facebook) to engage with community member and raise awarness on issues such as poverty, drug abuse, and violence against women- Designed donor reports and fundraising material