John Koclanis
Summary
Experienced with data analysis, market research, and pricing strategy. Utilizes analytical skills to forecast pricing trends and optimize revenue. Knowledge of financial modeling and competitive analysis to support business goals.
Overview
8
8
years of professional experience
Work History
Pricing Analyst
Smithfield Foods
Lisle, IL
12.2023 - Current
- Analyzed pricing data to identify trends and recommend adjustments for competitive positioning.
- Developed pricing models using advanced Excel functions to enhance accuracy in forecasting.
- Collaborated with cross-functional teams to align pricing strategies with market conditions.
- Trained junior analysts on analytical tools and best practices in pricing strategy development.
- Adjusted prices via pre-set schedules, supply management department costs and other factors on regular basis.
- Prepared detailed reports on pricing performance metrics for senior management review.
Package Handler / Team trainer
UPS
11.2017 - 04.2019
- Excelled in a high-pace teamwork environment with ability overcome obstacles to achieve timely goals
- Communicated with multiple departments to ensure quality & time sensitive production goals
- Quickly developed multi-departmental skillset that elevated my responsibilities and team value
- Promoted as a team leader, training new hires according to company methods & operating standards
- Became team quality control leader detailing proper methods, safety and operating procedures.
- Showed strong ability to adhere to company detail- oriented goals and time commitments
- Received safety awards for achieving safety goals according to OSHA safety compliance
Education
Bachelor of Science - Information and Decision Sciences
University of Illinois Chicago
Chicago, IL05.2023
Skills
- Software skills: Microsoft Office (Excel, Powerpoint & Word)
- VLookups, Pivot Tables, VBA Macros
- DBMS: MS Access, MySQL, SQL Server
- SAP ERP experience
ACTIVITIES AND ACHIEVEMENTS
- Moraine Valley 2019 President’s List
- Greater Chicago Food Depository, volunteer
- Member of the Carl Sandburg High School swim team
- International Student Affairs member at Moraine Valley Community College
- Trained in Piano for 6 years winning multiple achievement awards
- Trained in Taekwondo for 6 yrs reaching 2nd degree Black Belt with multiple regional championships & National Championship
Languages
English
Native or Bilingual
Timeline
Pricing Analyst
Smithfield Foods
12.2023 - Current
Package Handler / Team trainer
UPS
11.2017 - 04.2019
Bachelor of Science - Information and Decision Sciences
University of Illinois Chicago