Hello
​
I am
Janice Feng
I Am...
-
A data-driven marketer
-
An analytical thinker
-
A cultural explorer
-
A fashion-trend follower
-
And, a foodie and food photographer! (the camera always gets the first bite 😋 )
My Work Experience
Background & Expertise
Senior Analyst, Media Analytics,
Merkle
2022 - Present
• Process paid media performance data through Python and SQL scripts on Databricks, creating reports through Power BI, Tableau and Powerpoint and presenting results and insights to clients in weekly status calls
• Develop and prepare full-year budget and sales forecast and ongoing forecast updates using regression models with relevant insights, analysis and reasoning for the forecast figures
• Improve campaign reporting through creating benchmarks for KPIs across performance marketing channels, objectives and subdivisions, enabling both internal and external stakeholders to measure digital success
• Ensure data accuracy across all clients and campaigns, acting as a data translator, troubleshooter and consulting guide through reporting
Digital Marketing Analyst,
Anova
2021
• Led the budgeting, planning and execution of Google Ads plans and content creation that integrated with company’s marketing initiatives to meet lead generation goals and better engaged with B2B clients
• Successfully increased company’s organic search ranking by 80% and reached a 10x ROI by using relevant keywords, landing pages, meta descriptions, title tags and outbound links
• Optimized the performance of paid search campaigns against KPIs by running A/B testing on ad copy, keyword and bidding strategies, landing page testing, audience & location & ad schedule targeting
• Collaborated with 7 departments, created personalized marketing campaigns and tracked project timelines for 3 new product launches
Social Media and Marketing Intern,
FaceTrace Beauty
2020 - 2021
• Create and manage the company’s social media content on Facebook and TikTok to engage with different customers
• Analyzed the viability of Amazon as an ecommerce sourcing partner by researching into the market share and revenue funnel of top selling makeup brands on Amazon as well as Amazon’s search filters and distribution network
• Used iMovie and Adobe Premiere Rush to edit the company’s “what is beauty” promotional campaign videos
China Property Equity Research Intern, Huatai Hong Kong
2019
• Reviewed company reports and financial statements for five HKEX-listed companies to be included in the 2019 quarterly equity research analysis reports
• Enhanced and updated existing financial models to produce projected valuations for five Chinese real estate developers
• Created a China Investment Property Map displaying major shopping centers and office buildings in 104 cities in China
Real Estate Underwriting & Analytics Intern, WeWork Shanghai
2019
• Prepared and presented to the WeWork Real Estate Committee the 2019 Pipeline Deal Study, which demonstrated trade-offs between capital expenditure and free cash flow by evaluating key financial metrics of 109 active deals
• Created and maintained market playbooks and deal memos for senior managers to propose new deals for executive approval
• Presented updates on West China deal flow, goals, and strategies for 2020 to senior WeWork management
• Updated the weekly deal pipeline and compiled meeting minutes for management
Education
What I’ve Learned
Columbia Business School
2020 - 2021
-
MS in Marketing Science
New York University
2016 - 2019
-
BA in Economics
-
Minor in Business of Entertainment, Media and Technology & Korean Language
Adventis’ Financial Modeling Certification (FMC®) Program
2019
-
Financial Modeling Course
-
Valuation Module
-
Leveraged Buyout Module
Yonsei International Summer School
2017
-
Intermediate Macroeconomics
-
Korean for Beginners III
My Skills
What I Am Good At
