Hi, I’m Charles!
with background in Computer Science
I hold a Bachelor's degree in Computer Science from Northwestern University, where I developed a strong technical foundation. These skills have been critical for creating automated workflows and implementation of advanced algorithms to produce data-driven strategies.
a data storyteller, a data strategist..
and Business Strategy
I was part of strategic consulting project with Bain & Company where I gained my first-hand exposure on what goes into designing complex corporate strategies. I’ve also done business development work with the State of Illinois and City of Chicago.
through these experiences, I’ve developed a unique “blend of technical capacity and business sense”
which allows me to not only extract and analyze data, but also contextualize it within the broader business landscape to make actionable recommendations.
Projects
Everything’s designed with scalability and performance in mind.
Reporting for Leadership
Designed automated solutions for recurring Product Sales reports (daily/weekly/monthly) using Power BI, Power Automate, and OpenAI LLM to output key takeaways.
Impact Assessment - Free Tier
Developed simulators to assess and evaluate the financial impact of product management proposals, such as adjusting the free tier size and bundling products within other offerings.
Product Upsell Recommendation
Analyzed over 25M transaction records to conduct market basket analysis (products purchased together) and built a recommendation model to identify upsell opportunities for each customer.
Routing Service Performance
Conducted a thorough analysis of slow performance issues with the A to B route calculation on AWS. Improved calculation speed by 40% with the routing algorithm team.
Tee Time Finder (Torrey Pines)
Developed a Python script on AWS which monitors available tee times at a popular golf course. Text notifications are sent whenever a new slot opens up. Personal project.
Machine Learning for ETL
Utilized machine learning model to extract language and product details from 12,000+ file variations, and provided metrics which helped re-evaluate the business model and prioritization of the localization program.
API Cost Reduction
Analyzed usage logs to identify inefficiencies in the caching behavior of the core API service handling multi-billion requests monthly. Achieved a 65% improvement in service efficiency by eliminating all redundant requests (304 status code).
Customer Churn Prediction
Implemented a churn prediction model using Random Forest, leveraging historical usage telemetry to identify key patterns and forecast churn. Developed insights to proactively identify and take action on at-risk customers, improving retention strategies.
Product KPIs Dashboard
Presented business-critical metrics and key performance indicators by retrieving and aggregating data from various sources such as Redshift and Microsoft SQL Server.
Customer Recommendation
Provided customer recommendations using NACIS codes and the D&B database through analysis of the existing customer base for a product. “Most actionable intelligence the sales team’s ever received”
Minimize ad-hoc requests
Created 20+ automated reporting solutions and systems to minimize time spent on ad hoc data & analysis requests.
Object Tracking from Video feed
Implemented YOLOv8 model to track vehicle entry and exit at a popular surf spot to predict optimal arrival time to minimize wait time for parking which can take ~2hr during peak hours. Personal Project.
Good Design Practice
Transforming complex information into visual stories that engage, inform, and inspire action.
Spreadsheet Fundamentals
Avoid hard-coding values. Adhere to expected formats and utilize conditional formatting
Highlight Bar Chart
Highlight elements related to the key takeaway to direct attention
Visualize Information
Provide context using visualization. When providing the list of top selling products, include a chart to show the scale
Active Filters Display
Display the [Filters applied] within the dashboard so users can grab screenshots with full context
Annotate Key Anomalies
Tell a story with data visualization. Anticipate the questions
Emphasize Key Metrics
Deliver quantifiable value to drive and inspire action. Harness the power of effective design to maximize the impact
Data driven Visuals
Balancing the analytical and the aesthetic is the ultimate expression of genius
Clear Title and Subtitle
Both serving different purposes but working together to drive home the point
-
Surf
No bad day can’t be fixed by saltwater and sun.
-
Jiu Jitsu
Best way to stay humble.
-
Golf
My sweetest pleasure and most bitter pain.
-
Space
I keep looking up. Just in case.