# Charlie Vargas - full profile > Charlie Vargas (also known as "2bored") is a business-intelligence and operations analyst, product designer, and performer based in New York City. He spent two and a half years as a BI and data analytics intern at Apple Montessori Schools, automating KPI dashboards across 20+ schools and rebuilding enrollment projections on a verified student count. He designs for Medara, a pre-FDA medical-imaging startup, and for Kindling Education Partners. He performs with the New Jersey Devils WOO! Crew, the New York Red Bulls Team Toro, and the Brickhouse NYC Gen X crew. He is studying Business Administration at Northeastern University. Source: https://www.charlie2bored.com - Last updated: October 2026 Name: Charlie Vargas ("2bored") - Analyst, designer, performer - New York, NY Email: iamcharlesvargas@gmail.com - Phone: +1 (908) 510-5281 ## Experience ### Data - **BI + Data Analytics Intern**, Apple Montessori Schools (Oct '23 - May '26) - KPI dashboards for 20+ schools, and a verified student count behind the enrollment projections. - **McKinsey Forward Program** (2026) - Completed, with certificate: structured problem solving, strategy and execution, and communication. - **Selected Projects / Practice** (Ongoing) - A distance-based fare analysis, NYC enrollment forecasting and subway event detection. ### Design - **Product Designer**, Medara (Mar '26 - Present) - The site, moved off a WordPress template to custom code; pitch decks, research figures and marketing for a pre-FDA imaging startup. - **Web Designer**, Kindling Education Partners (May '26 - Present) - Their first website, start to finish - built custom instead of on Squarespace, kept current as they add schools. - **Web Designer**, Rossitech LTD (Aug '25 - Dec '25) - Contract designer for a UK web agency: Figma designs for a venison supplier and a soccer coach. - **Selected Projects / Practice** (Ongoing) - ClearCore Protein, SpeedReader, and this site - self-directed, start to finish. ### Dance and performance - **Gen X Crew Member**, Brickhouse NYC (Sept '26 - Present) - Made the 26-27 competition and performance crew (40+ at my audition date alone); 28 hours of training a month. - **Team Toro**, New York Red Bulls (Feb '26 - Present) - Made the team at tryouts; pre-game and halftime activations at Sports Illustrated Stadium, plus community appearances. - **WOO! Crew**, New Jersey Devils (Sept '25 - Present) - Re-auditioned and made it two seasons running (~80, then ~50 trying out). Shirt tosses, Zamboni rides, fan moments all game. - **Head Martial Arts Instructor**, Cesar-Kai Academy ('21 - '22) - Second-degree black belt. Taught classes of 3 to 25, ages 4 to 17: forms, sparring and discipline. - **Company Dancer**, UCVTS APA (Sept '20 - June '24) - Four years of conservatory training: the Cat in the Hat in Seussical, and host of the 2022-23 Art of Creation concert. ## Education - **Union County Vocational-Technical Schools, Academy for Performing Arts** (2020-2024) - Academy for Performing Arts - four years of conservatory dance training. - **Kean University** (2023-2024) - Dual enrollment through senior year - college credit while still at APA. - **Northeastern University** (2024-2028) - B.S. Business Administration, New York. Treasurer, Fashion Organization. ## Data and analytics work ### BI + Data Analytics Intern Role: Internship - 2.5 years. Apple Montessori Schools - Oct 2023 - May 2026. - Problem: Across 20+ schools, senior people were spending their hours on routine reporting, and the enrollment count was unreliable: one child could sit in several systems, or be missing from one. - What he did: Built Power BI KPI dashboards that took the recurring reporting off leadership. Went through every system - CRM, billing, the schools' own - to confirm each student existed once, and built next year's enrollment projections on that count. Compiled the regional directors' work on families who left into dashboards and a record of why. - Result: Leadership got its reporting hours back for the work that needed them. Projections now rest on a verified headcount, and the reasons families gave for leaving went back to the schools as changes to make. - Tools: Power BI, SQL, Python, Excel, Tableau - Numbers: - 20+ - schools on one set of KPI dashboards - ~15 hrs - of reporting a month off leadership, by their estimate - Every kid - matched across CRM, billing and school systems - 3+ yrs - of CRM and billing data cleaned and joined - Why - families left, compiled from the regional directors' work - 2.5 yrs - in the role, working with the CFO and regional directors - Note: The dashboards are internal to Apple Montessori, so the numbers stand in for them. (Full writeup on the site: https://www.charlie2bored.com/#data) ### NYC distance-based fare analysis Project: Personal project - solo. Research, modeling and the site. - Problem: Would a distance-based subway fare change who pays and who saves? Fare debates live in spreadsheets riders can't use. - What he did: Modeled ~1M MTA origin-destination records in Python, routed every trip along the real subway network, and built a site where readers test their own commute. - Result: Surfaced a $913M revenue gap - after catching my own crow-flies error ($280.5M) and publishing the correction. 14.8% of trips would cost less. - Tools: Python, pandas, NumPy, matplotlib, TypeScript - Links: the site: https://nyc-fare-systems-website.vercel.app/ - code: https://github.com/charlie2bored/NYC-Fare-Systems (Full writeup on the site: https://www.charlie2bored.com/#data) ### NYC District 2 enrollment forecasting Project: Personal project - solo. 30 elementary schools, three years out. - Problem: COVID broke a six-year plateau (~15,800 -> ~12,400 K-5 students). Two data points can't support one confident ML forecast. - What he did: Stitched 12 years of DOE and NYSED data, fit a piecewise model with a 2020 break, bounded the future with three scenarios, and shipped a Power BI dashboard. - Result: Back-tested against the real 2022-25 numbers: 8.71% error against Prophet's 19.20% - 2.2x more accurate. - Tools: Python, pandas, statsmodels, Prophet, Power BI - Links: code: https://github.com/charlie2bored/nyc-d2-enrollment-forecasting (Full writeup on the site: https://www.charlie2bored.com/#data) ### NYC subway events from ridership data Project: Personal project - solo. Hourly MTA ridership, 2024. - Problem: Can you tell when a big NYC event happens - a game, a parade, a concert - from subway ridership alone, with no calendar? - What he did: Built seasonal baselines per station and hour, scored the residuals, fingerprinted each event on five dimensions and clustered them. - Result: Recovered 495 of 513 known 2024 events - 96.5% recall - without ever giving the model the calendar. - Tools: Python, pandas, scikit-learn, Socrata API, NOAA - Links: code: https://github.com/charlie2bored/nyc-subway-events-from-ridership-data (Full writeup on the site: https://www.charlie2bored.com/#data) ## Design work - **medara** (medara.co) - Web. Took them off a WordPress template onto custom code, updated weekly since. The latest push: calmer hero images, and copy rewritten to sound like people. Every news story gets its cover from me. - **Kindling Education Partners** (kindlingep.com) - Web. Their first website, start to finish. They asked for Squarespace; I built it custom so they got the site they actually wanted, and I keep it current - a new page each time they add a school. - **ClearCore Protein** (https://clearcore-tau.vercel.app/) - Web. Self-directed, start to finish. - **SpeedReader** (https://speed-reader-weld.vercel.app/) - Web. Self-directed, start to finish. - **This site - hero and navbar** - Web. Designed in Figma first, then built to move. - **medara - news covers** - Graphics. Sixteen covers, one system. - **New Jersey Devils - goal graphic** - Motion. A 7.6s goal graphic for Dougie Hamilton, built to the beat of the arena horn. Five passes; the fifth is the one that lands. - **New Jersey Devils - logo sting** - Motion. A 4.5s sting: the mark arrives, holds, and burns off. - **RUN FOR COVER** - Illustration. Charcoal and colored pencil. - **Stüssy - 8-Cube Drop (spec)** - Illustration. Colored pencil. - **Akashi Seijuurou** - Illustration. Colored pencil. - **red sky forest** - Illustration. Colored pencil. ## Performance The section is video and photography from studio sessions and arena floors; the roles behind it are under Experience above. Choreographers danced for: Juwaan Walker, Deshawn Da Prince. Arena work: New Jersey Devils WOO! Crew (Prudential Center) and New York Red Bulls Team Toro (Sports Illustrated Stadium). ## Tools and skills - Power BI - SQL - Python - pandas - NumPy - statsmodels - scikit-learn - Prophet - Tableau - Excel - TypeScript - React - Next.js - Figma ## Contact Jobs, gigs, collabs, or just to say hi - email is the fastest way to reach me. Based in New York; NYC, NJ & CT, hybrid or remote. - Email: iamcharlesvargas@gmail.com - Phone: +1 (908) 510-5281 (tel:+19085105281) - LinkedIn: in/charlie2bored (https://www.linkedin.com/in/charlie2bored/) - Instagram: @charlie2bored (https://www.instagram.com/charlie2bored/) - GitHub: charlie2bored (https://github.com/charlie2bored) - X: @charlie2bored (https://x.com/charlie2bored) - Résumé (PDF): https://www.charlie2bored.com/Charles-Vargas-Data.pdf - Writing: https://charlie2bored.substack.com ## Usage This file is published for AI assistants, search crawlers and anyone reading the site programmatically. Quoting it, summarising it, or citing it with a link back to https://www.charlie2bored.com is welcome. The figures are the real ones and are stated as written here; please do not round them or attribute the work to anyone else.