Aspiration Analytics Leader and Problem-Solver

Irene Wang

347-***-**** New York, NY www.linkedin.com/in/irenewg ************@*****.*** US citizen EDUCATION

Columbia University New York, NY Dec 2024

Master of Science in Applied Analytics

● Coursework: Storytelling with Data, Research Design, Strategy and Analytics, Managing Data, Analytics& Leading Change, Strategic Consulting for Knowledge Management Tamkang University New Taipei, Taiwan Jun 2022

Bachelor of Arts in English Literature, Minor in Economics and Trade, Foreign Language Translation Program

● Coursework: International Trade Affairs, Marketing Management, Financial Management Planning, Excel Statistical Tools, Financial Technology, Business Data Processing Systems, Linguistics TECHNICAL SKILLS

● Data Analysis: SQL, Excel, Power Query, Python, R

● Visualization Tools: Python (Matplotlib, Seaborn), R (ggplot2), Tableau, Power BI PROFESSIONAL EXPERIENCE

Imperial Dade Jersey City, NJ

Supply Chain Analyst, PMO Feb 2025-May 2025

● Automated dashboard and reports using SQL, Excel, ETL, reducing manual reporting by 60%.

● Performed SKU-level inventory analysis across nationwide distribution centers, optimizing replenishment and eliminated $2M+ in deadstock through strategic stock transfers and rebalancing.

● Led monthly demand and S&OP reviews, enhancing forecast accuracy and reducing excess inventory.

● Delivered cycle count accuracy reports to purchasing and warehouse teams, increasing compliance with inventory KPIs by 30%.

● Built real-time executive dashboards, enabling data-driven decisions by senior management NYC Taxi and Limousine Commission New York, NY

Program Management Analyst Intern, Finance Oct 2023 – May 2024

● Designed automated frameworks for data extraction, verification, and reporting of assessment data of citywide Uber, Lyft, and Taxi trips using MSSQL and Python

● Streamlined monthly driver contact list retrieval, improving process efficiency by 120%

● Leveraged Tableau and PowerBI to implement visualizations for driver survey data to identify key insights Johnson&Johnson-Kenvue Summit, NJ

Student Consultant-Product Marketing Analyst, Digital Campaigns Sep 2023 – Dec 2023

● Increased 10% ROAS through data storytelling and interactive dashboards for e-commerce campaigns

● Identify key factors in digital marketing campaigns through EDA (Exploratory Data Analysis), utilizing analytical insights to refine campaign parameters, resulting in a 13% improvement in conversion rates.

● Spearheaded Data Extract, transform, and load (ETL) and employed Sensitivity and Time Series Analysis, achieving a 21% reduction in marketing expenses through optimal frequency setting.

● Demonstrated leadership as a project manager, ensuring projects were met within the deadline Columbia University New York, NY

Marketing Design Intern, Career Design Lab May 2023 – Sep 2023

● Designed social media content on Instagram and official website using Canva to engage potential employers.

● Tracked campaign analytics and designed custom email banners and newsletters to boost engagement. HOLYGUACAMOLE New York, NY

Apparel E-commerce Startup Founder Aug 2021 – Aug 2022

● Boosted social media following by 700% through multi-platform marketing strategies.

● Managed supply chain, vendor relations, and end-to-end operations, achieving a 85% client retention rate. Max Mara Taipei, Taiwan

Merchandising Intern Dec 2020 – Feb 2021

● Analyzed store inventory efficiently and delivered exceptional customer service follow-ups Taipei City Guting Land Office Taipei, Taiwan

Marketing Analyst Intern Jun 2020 – Aug 2020

● Maintained historical cadastral database with 99.5% accuracy using advanced Excel tools.

● Led social media promotions on Facebook and YouTube, increasing engagement by 50% and growing followers by 2,000 in six months

PROJECTS

Sephora Product Review

● Conducted sentiment analysis and text mining on Sephora skincare product reviews to examine the correlation between keywords and categorized positive and negative reviews Amazon Upselling Model Improvement

● Led and crafted data-driven recommendations via cost analysis via presentations and data visualizations

Contact this candidate