Currently an Extern @The Lean Startup Co·🟢 Open to work

Junior business analyst building finance and product skills

I combine hands-on ops experience with financial modeling, analytics, and data visualization to strengthen my resume and prepare for product roles.

LinkedIn Message Me

Work samples

Projects include externships in operational strategy and value investing, DCF and ratio models for Attronica and Kohl’s forecasts, and dashboards built with Power BI and Tableau.

Amazon Operational Strategy & People Analytics Externship
Amazon · Oct 2025 · ✅ Verified by Extern
Amazon Operational Strategy & People Analytics Externship
Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90.You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely.It’s part research, part strategy—and all about learning how people data drives big decisions.
Data AnalysisAI & MLPythonStrategyPresentation Skills
Yinan Value Investing & Financial Modeling Externship
Yinan Zhao · Jun 2026 · ✅ Verified by Extern
Yinan Value Investing & Financial Modeling Externship
Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.
Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel
Attronica
Aug 2026
Attronica
Built A/V division DCF model using projection and discount-rate assumptions to support growth investment decision; Developed an 8-ratio financial analysis to benchmark profitability, liquidity, and efficiency against peer companies; Analyzed 3 years of financial statements to assess revenue, working
Yinan Zhao
Aug 2026
Yinan Zhao
Modeled Kohl’s operating forecast through FY2030 across revenue, EBITDA, assumptions, and free cash flow; Drafted an investment memo synthesizing valuation, operating drivers, and risks into a concise recommendation; Evaluated revenue, inventory, SG&A, leases, and EBITDA drivers impacting earnings a

About me

I combine hands-on ops experience with financial modeling, analytics, and data visualization to strengthen my resume and prepare for product roles.

I am Illia Legenko, a junior at Florida International University studying Business Analytics and Finance. I work as a Facility Operations Assistant and previously supported operations analysis at EVA Trading House. I build financial models, analyze data with Python and SQL, and create dashboards in Power BI and Tableau to turn numbers into decisions.

Externships

Corporate Strategy Externship Mentored by Eric Ries

The Lean Startup Co

Experience

Facility Operations Assistant

Florida International University · March 2025 – Present

Business Operations Analyst

EVA Trading House · Apr 2022 – Jun 2023

Education

Florida International University

Bachelor of Business Administration in Business Analytics and Finance · Class of 2027

Skills

Bloomberg TerminalExcelPythonPower BITableauSQLPowerPointLucidAI

Back to work

Amazon · Oct 2025 ↗

✅ Verified by Extern

Amazon Operational Strategy & People Analytics Externship

Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90.You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely.It’s part research, part strategy—and all about learning how people data drives big decisions.

Data AnalysisAI & MLPythonStrategyPresentation Skills

Overview

The work compiled role definitions and operational handoffs at an Amazon Fulfillment Center, collected and cleaned employee voice data from Glassdoor and YouTube, and analyzed sentiment and keywords across that corpus. The project grouped feedback into themes, mapped root causes with a 5 Whys tree, segmented the workforce by cohort, and produced a pilot-ready five-slide intervention brief.

Amazon Operational Strategy & People Analytics Externship

Google Slides

Access

What I've accomplished

I produced a structured workforce spreadsheet, a cleaned CSV of Glassdoor and YouTube feedback, sentiment- and theme-tagged analysis (including visualizations), a theme-by-segment frequency table, a root-cause tree, and a five-slide pilot brief with a standardized digital coaching protocol.

Project breakdown

View all work

Back to work

Yinan Zhao · Jun 2026 ↗

✅ Verified by Extern

Yinan Value Investing & Financial Modeling Externship

Gain insider experience in value investing by analyzing leading stocks alongside seasoned investor Yinan Zhao. Learn how professionals leverage financial modeling in Excel, interpret alternative data, evaluate market trends, and craft persuasive investment recommendations. Build real-world skills essential for careers in finance, equity research, and investment banking.

Investment AnalysisFinancial Statement AnalysisFinancial ModelingData AnalysisExcel

Overview

The externship produced a full equity research package on Kohl's (KSS). Work included a Stock Card with ownership signals and a growth thesis, a verified company 10-K, a consolidated research spreadsheet mapping risks and drivers, a historical financial model with line-by-line driver defenses, multi-year forecasted financials, and a three-scenario investment memo with a $25 base-case price target.

Yinan Value Investing & Financial Modeling Externship

Google Docs

Access

What I've accomplished

I produced a complete equity research package on Kohl's, including a Stock Card, verified 10-K, risk and driver research spreadsheet, a driven historical model with tied statements, FY2026–FY2030 forecasts, and a three-scenario investment memo with a $25 base-case target.

Project breakdown

View all work

Back to work

Aug 2026

Attronica

Built A/V division DCF model using projection and discount-rate assumptions to support growth investment decision; Developed an 8-ratio financial analysis to benchmark profitability, liquidity, and efficiency against peer companies; Analyzed 3 years of financial statements to assess revenue, working

Overview

View all work

Back to work

Aug 2026

Yinan Zhao

Modeled Kohl’s operating forecast through FY2030 across revenue, EBITDA, assumptions, and free cash flow; Drafted an investment memo synthesizing valuation, operating drivers, and risks into a concise recommendation; Evaluated revenue, inventory, SG&A, leases, and EBITDA drivers impacting earnings a

Overview

View all work

Work samples

Amazon Operational Strategy & People Analytics Externship

Yinan Value Investing & Financial Modeling Externship

Attronica

Yinan Zhao

About me

Amazon Operational Strategy & People Analytics Externship

Overview

What I've accomplished

Project breakdown

Understand the Operational ChallengeI mapped roles and responsibilities within an Amazon Fulfillment Center, documenting how each function interacted and why it mattered for operations.

Collect & Clean Employee Voice DataI collected, cleaned, and structured employee voice data from Glassdoor and YouTube, turning messy reviews and transcripts into analysis-ready datasets and examples.

Find Sentiment & Keyword Patterns in Employee Voice DataI cleaned noisy employee feedback using Python and produced a cleaned_text column ready for analysis.

Uncover Themes & Root Causes in Employee Voice DataI identified three core themes in employee feedback and prepared a sentiment-tagged summary and root-cause analysis for the top priority theme.

Segment the Workforce & Identify PrioritiesI segmented employee feedback into labeled cohorts and flagged which groups experienced the most recurring pain points.

Yinan Value Investing & Financial Modeling Externship

Overview

What I've accomplished

Project breakdown

Pick Your StockI selected Kohl's (KSS) as my Russell 2000 Value pick and prepared the Project 1 stock deliverable.

Read the 10-KI located and confirmed the company's Form 10-K filing as required for the Project 2 assignment.

Map the RisksI completed and locked a final qualitative analysis template for Kohl's, synthesizing press releases, filings, and investor materials into a structured research spreadsheet.

Build the ModelI defended a locked driver set and documented the rationale behind each assumption for a historical financial model of a retail company.

Set Your Price TargetI built a five-year, driver-linked financial projection model for Kohl's Corporation covering income statement, balance sheet, and cash flow.

Attronica

Overview

Yinan Zhao

Overview