Ian Lehrer
I build AI-driven tools and automation systems that turn complex financial and operational data into clear, actionable outcomes.
Finance Meets Automation
📊
Finance + Data
Financial modeling, budgeting, and analysis at enterprise scale
🤖
AI & Automation
Python scripts and AI-driven tools that eliminate manual work
🏗️
Systems Builder
Dashboards, pipelines, and workflows designed for real users
🎯
Strategic Impact
Translating complex data into executive-level insights
WHAT I BUILD
Systems That Solve Real Problems
I focus on practical tools that create measurable impact.
🧠
AI Systems
Practical, AI-driven tools that transform raw data into fast, confident decisions.
- Forecasting models for operational planning
- Intelligent workflows for data processing
- Scalable automation for enterprise environments
- Real-world deployment, not just prototypes
⚡
Automation & Tools
- Python automation scripts and ETL pipelines
- Reporting dashboards with integrated analytics
- Process workflows that cut hours of manual effort
- Internal tools built for non-technical users
📈
Data & Finance
- Budget management across $400M+ portfolios
- Scenario modeling and predictive analytics
- Cost optimization and vendor performance
- Cross-functional strategic decision support
EXPERIENCE
Where I've Made an Impact
A track record of building systems, optimizing operations, and delivering measurable results.
Financial Operations Analyst
Hewlett Packard Enterprise
Operated as a finance–product bridge across a $400M global facilities portfolio (250+ sites), owning budget performance with 99.9% accuracy while translating financial data into decision-driving systems. Designed and deployed AI-driven forecasting tools and Python automations that reduced reporting time by 20+ hours per month and improved operational visibility. Led a $30M cost optimization initiative by applying data modeling, vendor performance analytics, and structured experimentation to influence capital allocation. Built predictive dashboards and scenario models that enabled leadership to make faster, data-backed real estate and spend prioritization decisions, while advancing digital transformation across global finance operations.
Valuation Analyst Intern
Capital Insight
Supported $10M–$100M M&A transactions in the food and hospitality sector by transforming financial data into structured valuation insights. Built dynamic Excel models to analyze revenue durability, margin profiles, and operating leverage, helping assess deal viability and growth potential. Synthesized financial statement analysis into clear, decision-ready outputs that informed pricing strategy, risk assessment, and capital allocation discussions.
Founder/Web Developer
Founded and led a web development and digital strategy firm serving small businesses, owning end-to-end product delivery from client discovery through launch and optimization. Designed and deployed high-performance, SEO-optimized websites that drove up to 200%+ increases in organic traffic within three months. Built data-driven marketing systems to improve conversion funnels, customer acquisition efficiency, and measurable ROI, translating digital performance metrics into scalable growth strategies for clients.
PROJECTS
What I've Built
A selection of tools and systems — from AI-powered automation to financial dashboards. More coming as I build in public.
Quarterly Reporting Automation
aI-Driven Forecasting Tools
Executive Dashboards
Value Realization Framework
Designed a structured value-measurement system spanning 7 quantitative and 3 qualitative impact pillars, enabling organizations to translate AI, operational, and strategic initiatives into measurable financial outcomes including cost avoidance, revenue acceleration, capital efficiency, and risk mitigation.
EDUCATION
Foundation
🎓
University of Arkansas
Bachelor of Science in Finance, Minor in Economics
Get in touch
Let's Build Something
I'm actively looking for my next role — whether it's in financial operations, AI-driven automation, or at the intersection of both. Let's connect.