Charlie Chen

Charlie Chen Email and Phone Number

Business Intelligence Analyst @ Perpetua
New York, NY, US
Charlie Chen's Location
New York, New York, United States, United States
Charlie Chen's Contact Details

Charlie Chen personal email

n/a
About Charlie Chen

I am a graduate student at the University of Southern California, Marshall School of Business, currently pursuing a specialized degree in Marketing Analytics. I am passionate about using both creative and analytic problem-solving skills in the technology and CPG industries. Data science skills:Data Tool: Python, R, Tableau, SAS, SQL, Google AnalyticsProgramming Techniques: - Machine Learning Modelling- Data Scraping- Data Visualization- Text mining (Word2Vec, Sentiment Analysis)

Charlie Chen's Current Company Details
Perpetua

Perpetua

View
Business Intelligence Analyst
New York, NY, US
Website:
perpetua.io
Employees:
98
Charlie Chen Work Experience Details
  • Perpetua
    Business Intelligence Analyst
    Perpetua
    New York, Ny, Us
  • Full Glass Wine Co.
    Business Intelligence Analyst
    Full Glass Wine Co. Jul 2024 - Present
    Los Angeles, Ca, Us
  • Flywheel
    Business Intelligence Analyst
    Flywheel Oct 2022 - Jul 2024
    Baltimore, Md, Us
    Omnicom Group's Largest acquisition to date: $835 Million•Led feature analysis for eCommerce advertising software, collaborating with engineers and product teams. Mapped user journeys for the new Search Insights feature, tracking user interactions, enrollments, and keyword monitoring to measure efficiency and impact•Developed interactive dashboards and customized reports in Looker Studio and Tableau using SQL and Google BigQuery to analyze billions of rows from Amazon Marketing Cloud and Seller/Vendor Partner API, and delivered eCommerce insights to stakeholders•Conducted ad hoc analysis for Perpetua, a SaaS company merged with Flywheel, leveraging SQL to extract, analyze data from various sources, and uncover actionable insights. Developed dynamic reports and self-service dashboards to support strategic decision-making and enhance operational efficiency across the organization
  • Das42
    Associate Analyst
    Das42 Jun 2022 - Sep 2022
    New York, Ny, Us
    • Built tabbed and interactive dashboards using Looker and Snowflake to perform exploratory analysis and influence the sales-related decision making• Designed and implemented ETL jobs and transformations to populate a data warehouse using AWS S3 Bucket, Snowflake, and Airflow; resulted in automated application performance and smooth data retrieval from a database or other data storage
  • Dekra North America
    Business Analyst Intern
    Dekra North America Jan 2022 - May 2022
    Atlanta, Georgia, Us
    • Cleaned and updated survey data through Python scripts to evolve the centralized datasets hosted on MS SQL; expected to increase data efficiency by 40%• Collaborate with cross-functional departments to enhance the quality of proprietary reports using Tableau; expected to improve client satisfaction by 30%
  • University Of Southern California
    Graduate Teaching Assistant
    University Of Southern California Aug 2021 - Dec 2021
    Los Angeles, Ca, Us
    Teaching Assistant for Applied Business StatisticsProfessor: Inga Maslova
  • Dell Technologies
    Channel Inventory Control Intern
    Dell Technologies Jun 2020 - Aug 2020
    Round Rock, Texas, Us
    • Developed an in-depth understanding of datasets relations by drawing entity-relationship diagram among Dell, North America retailers, and E2Open, a B2B supply chain software • Analyzed the GIM team’s inventory data for inconsistencies and removed noise from data with Python Pandas library on Jupyter notebook• Created a master mapping file by reconciling external and internal inventory data flows to improve the SKU mapping process by 80% and reduce 20 hours/week on manual mapping• Prepared technical documentation that covered project summary, code explanation, and future opportunities which E2Open and Dell’s data science team can implement and scale
  • Carrier Corporation
    Marketing Communications Intern
    Carrier Corporation May 2019 - Aug 2019
    Us
    - Ran usability, compatibility and interface tests on Carrier's Transicold legacy and upcoming version of website- Organized a list of solutions for websites' improvement to lower the bounce rate by 10% and increase the average session duration by 20%- Developed a series of online internal training courses for sales teams and dealership network across the country to optimize the efficiency of product training and reduce the annual training expenditure by $15,000
  • The University Of Texas At Austin
    Marketing Strategist
    The University Of Texas At Austin Aug 2018 - Apr 2019
    Austin, Tx, Us
    -Update, expand, and improve upon Peer Lead Undergraduate Studies (PLUS) social media accounts (Facebook, Twitter, etc.)-Stay up-to-date on social media marketing trends and new social media technologies, incorporating them into PLUS portfolio as appropriate-Develop marketing items (training materials, flyers, brochures, etc.)
  • Mccombs School Of Business, The University Of Texas At Austin
    Stewardship Student Assistant
    Mccombs School Of Business, The University Of Texas At Austin Aug 2018 - Dec 2018
    Austin, Tx, Us
    -Using Microsoft Excel and Word to consolidate and track data-Maintaining, updating, and printing condolence communications-Supporting the stewardship department on various tasks, including data entry and file organization/management
  • Undergraduate French Society
    Public Relations Director
    Undergraduate French Society Aug 2018 - Dec 2018
    -Coordinate, develop, and maintain the Undergraduate French Society’s social media presence-Plan, implement and coordinate the UFS’s marketing, and public relations programs to advance the goals and mission of UFS -Draft press releases, periodic reports, and constant social media posts to improve UFS accessibility and transparency-Establish, nurture and maintain positive external relationships with other student organizations and sponsors-Attend the Undergraduate French Society weekly Meetings and Staff meetings-Manage the Undergraduate French Society brand
  • Earthx
    Marketing Intern
    Earthx May 2018 - Aug 2018
    Dallas, Tx, Us
    • Performed the marketing research and SWOT analysis on major IMPACT investment forums around the world. This research was used for senior managements to make strategic decisions for the future project planning• Evaluated the official website and remodeled the official website by upgrading the website information, and providing the essential resources to create the approachable webpage, and optimize the website for investors and cleantech startups • Conducted industry research for over 100 companies related with agriculture and blue technology which helped E-capital summit to expand into different dimensions, and increased the number of attendees by over 250%

Charlie Chen Skills

Data Integration Data Warehousing Sharepoint Salesforce.com Google Looker Studio Sales Looker Microsoft Powerpoint Matlab Snowflake Cloud Data Analysis Jira English Snowflake Tableau Pycharm Html Oracle Sql Developer Microsoft Office Microsoft Word Data Modeling Microsoft Excel Marketing Pl/sql Google Bigquery Social Media Marketing Apache Airflow Preset.io Sql Python Articulate Storyline Rstudio Research Preset Marketing Strategy Data Migration Mandarin Amazon Marketing Cloud Aws S3 Erd Draw.io

Charlie Chen Education Details

  • University Of Southern California
    University Of Southern California
    Marketing Analytics
  • The University Of Texas At Austin
    The University Of Texas At Austin
    Management Information Systems

Frequently Asked Questions about Charlie Chen

What company does Charlie Chen work for?

Charlie Chen works for Perpetua

What is Charlie Chen's role at the current company?

Charlie Chen's current role is Business Intelligence Analyst.

What is Charlie Chen's email address?

Charlie Chen's email address is ao****@****kra.com

What schools did Charlie Chen attend?

Charlie Chen attended University Of Southern California, The University Of Texas At Austin.

What skills is Charlie Chen known for?

Charlie Chen has skills like Data Integration, Data Warehousing, Sharepoint, Salesforce.com, Google Looker Studio, Sales, Looker, Microsoft Powerpoint, Matlab, Snowflake Cloud, Data Analysis, Jira.

Who are Charlie Chen's colleagues?

Charlie Chen's colleagues are Christin S., Aline Gobbi, Claire Lee, Margarita Evtimova, Dan Hendry, Andrei Markov, 小川敬史.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.