John Mikolaicyk
Oneonta
Summary
Finance-focused with a recently completed MBA in Finance from Hofstra University's Frank G. Zarb School of Business and progressive experience in marketing analytics and operations planning within a complex manufacturing organization. Strong interest in financial markets, wealth management, and long-term client relationships. Seeking to begin a career at Morgan Stanley with the goal of earning required licenses, continuously expanding financial expertise, and growing into roles of increasing responsibility while helping clients make informed financial decisions.
Overview
3
3
years of professional experience
Work History
Operations Planner
Amphenol Aerospace
Sidney
07.2025 - Current
- Forecast monthly revenue by analyzing production capacity, plating throughput, and order readiness to determine what can realistically be shipped within each period.
- Build and maintain planning models that translate operational constraints into revenue expectations against monthly targets.
- Self-taught advanced use of large internal data reports and leveraged AI tools (including ChatGPT) to design Excel macros and automated workflows that consolidate, clean, and reshape data into decision-ready dashboards not previously available.
- Developed new reporting views that surfaced hidden bottlenecks, risks, and opportunities across machining, plating, and backlog - improving visibility for operations and leadership.
- Own and manage the buyer backlog for a major customer program, ensuring parts are ordered at the right time to balance on-time delivery with inventory and working capital efficiency.
- Serve as the division's point person for plating status and exceptions, tracking parts through plating, identifying failures or delays, and actively driving resolution to protect delivery and revenue.
Marketing Analyst
Amphenol Aerospace
Sidney
12.2024 - 07.2025
- Analyzed sales trends, customer demand, and market data to support strategic planning and reporting.
- Built and maintained Excel-based dashboards and reports to track key performance indicators.
- Supported cross-functional teams by translating data into actionable insights.
Marketing Trainee
Amphenol Aerospace
Sidney
10.2024 - 12.2024
- Supported senior analysts in data collection, reporting, and market research activities.
- Developed strong foundational skills in data accuracy, reporting discipline, and process documentation.
- Military High Speed
Professional Baseball Player
Windy City Thunderbolts
04.2024 - 09.2024
- Chicago, IL
Professional Baseball Player
Williamsport Crosscutters
07.2023 - 09.2023
- Williamsport, PA
Education
MBA - Finance
Hofstra University
Uniondale, NY12.2025
BBA - Business Management
Hofstra University
Uniondale, NY05.2022
AS - Business Administration
Herkimer County Community College
Herkimer, NY05.2020
Coursework - Finance
Rochester Institute of Technology
Henrietta, NY05-2019
High School Diploma -
Oneonta High School
01.2018
Skills
- Financial Markets
- Revenue Forecasting
- Data Analysis
- Excel Automation
- Operations Planning
- Client Communication
- Compliance Awareness
- Data visualization
- Excel modeling
Timeline
Operations Planner
Amphenol Aerospace
07.2025 - Current
Marketing Analyst
Amphenol Aerospace
12.2024 - 07.2025
Marketing Trainee
Amphenol Aerospace
10.2024 - 12.2024
Professional Baseball Player
Windy City Thunderbolts
04.2024 - 09.2024
Professional Baseball Player
Williamsport Crosscutters
07.2023 - 09.2023
MBA - Finance
Hofstra University
BBA - Business Management
Hofstra University
AS - Business Administration
Herkimer County Community College
Coursework - Finance
Rochester Institute of Technology
High School Diploma -
Oneonta High School