Looking for a job

Victory Ilem-Iyam

@victoryilem-iyam

Message

I build data-driven financial and operational forecasts using SQL, Python, Excel, and Tableau.

United States

Message

What I'm looking for

I'm looking for an analytics or finance role where I can use SQL, Python, Excel, and visualization tools to improve forecasting, financial decision-making, and operational outcomes.

I'm completing an MS in Business Analytics at Carnegie Mellon’s Tepper School of Business, where I use SQL, Python, and Tableau to turn complex data into actionable forecasts. In a capstone for Therapeutic Early Intervention Services, I cleaned and integrated 14 years of client data and built caseload forecasting models across eight therapy types.

Previously, at Peachville Platinum Limited, I built financial models, analyzed cost variances, and managed AR/AP and rent revenue across a 3,000+ residential portfolio. I also apply machine learning to finance and operations projects, including value-factor timing and last-mile delivery analysis.

Experience

Work history, roles, and key accomplishments

Business Analyst (MSBA Capstone Project)

Therapeutic Early Intervention Services

Jan 2026 - Apr 2026 (3 months)

Identified a data gap in the original hiring-forecast approach and redirected the project to predict future therapy caseloads by service type, cleaning and integrating 14 years of client data using SQL. Built forecasting models across 8 therapy types using Python, reaching 89% accuracy for Nutrition and 65%/55% for Occupational and Physical Therapy respectively.

SQL Python Tableau Forecasting Data Cleaning Data Integration KPI Dashboards Stakeholder Communication

Junior Financial Analyst

Peachville Platinum Limited

Jan 2024 - Mar 2025 (1 year 2 months)

Built Excel-based financial models and ran cost variance analysis, identifying discrepancy drivers that cut delayed payments by 15%. Managed AR/AP and accrual-based rent revenue across a 3,000+ residential portfolio, using SAP S/4HANA for invoice processing and vendor payment tracking, alongside QuickBooks and Zoho Books.

Excel Financial Modeling Variance Analysis SAP S 4HANA Quickbooks Zoho Books Accounts Receivable Accounts Payable Budgeting

Finance Accounting Intern

Akem Homes Limited

Jun 2022 - Sep 2022 (3 months)

Generated and consolidated monthly financial reports using XLOOKUP/VLOOKUP, SUMIFS, and pivot tables, supporting audit prep and on-time reporting. Performed account reconciliations on monthly financial data across 10+ properties, identifying trends and discrepancies across transactions to support leadership decision-making.

Excel XLOOKUP V Lookups Sumifs Pivot Tables Account Reconciliation Journal Entries Invoicing Audit Preparation

Education

Degrees, certifications, and relevant coursework

Carnegie Mellon University - Tepper School of Business

Master of Science, Business Analytics

2025 -

Activities and societies: Student Ambassador

Pursuing a Master of Science in Business Analytics with coursework in data analytics, machine learning, and data visualization. Serving as a Student Ambassador.

Babcock University

Bachelor of Science, Accounting

2019 - 2023

Completed a Bachelor of Science in Accounting with coursework in advanced financial accounting, financial statement analysis, and financial reporting.