Kody Parman
Oregon
Summary
Business Intelligence Analyst with a strong background in data analysis, reporting, and visualization. Experienced in utilizing tools such as PowerBI, Excel, and Snowflake to transform raw data into meaningful insights. Excellent communicator with a track record of working collaboratively with cross functional teams to translate business needs into data-driven solutions.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst
Pacific Cycle - Schwinn and Mongoose
04.2023 - Current
- Utilize Power BI to design sophisticated data models, develop dynamic dashboards, and provide analytical support for a variety of departments.
- Introduced and Implemented new tools such as Tabular Editor, Dax Studio, and Power Automate to enhance reporting and analytics capabilities.
- Design and write complex SQL queries in Snowflake by utilizing window functions, CTE's, and joins.
- Perform ETL processes to integrate data from various internal and external sources, ensuring data consistency and accuracy for analysis.
- Collaborate with departments to automate recurring processes, streamlining workflows and enabling departments to gain actionable insights from their data, improving decision-making and efficiencies.
- Manage and deploy critical reports that track key KPI's, provide actionable insights, drive cost savings, and maximize operational efficiencies. Examples include building a dashboard to identify billing discrepancies, leading to significant cost recovery; deploying a daily email report to track sales versus multiple goals and budgets; and creating a report that highlighted the need for safety stock, maximizing revenue by reducing order cancellations.
Product Manager
Beacon Athletics
08.2021 - Current
- Analyze item sales by pulling data from database to measure product performance.
- Develop and maintain key business insights such as conversion rates, cancelled orders, and other ad hoc analysis.
- Provide sales & marketing insights such as campaign and promotion performance.
- Manage pricing for 2000+ skus to meet revenue and profitability goals. Exceeded target product margin plan by 1.5% in 2022 which was $400,000 in additional margin dollars.
- Assist the supply team with demand forecasts on inventoried and dropship products.
- Run weekly product development meetings to prioritize projects that has the most impact for the company and our customers.
- Manage product lifecycle which includes product development to end of life.
Direct Sales Supervisor
Beacon Athletics
10.2018 - 08.2021
- Analyzed and reported on all essential metrics for our team including revenue, margin, and other KPI’s.
- Work directly with the inventory manager to forecast key products, manage backorders, and plan for future promotions.
- Responsible for all selling and customer service activities for the Customer Service/Direct Sales Group.
- Work directly with the marketing team to enhance the overall customer experience including catalog and website improvements and recommendations.
- Manage four team members and responsible for all training such as process and product training.
- Assist in all areas of the Company whenever necessary to elevate sales and the customer service process.
Education
Bachelor of Science - Business Management
Edgewood College
Madison, WI05.2015
Skills
Power BI
Excel
SQL
Power Automate
Sharepoint TeamsOneDrive
Python
Problem Solving
Organization
Collaboration
Communication
Project Management
Certification
- SQL & Database Bootcamp-Udemy
- Data Analysis & Visualization using Python, Excel, PowerBI & Tableau-Udemy
- Python Certification-One Month
- Analyst Builder - Python
- Analyst Builder - Pandas
- Supervisory Leadership Series- WI school of Business
Timeline
Business Intelligence Analyst
Pacific Cycle - Schwinn and Mongoose
04.2023 - Current
Product Manager
Beacon Athletics
08.2021 - Current
Direct Sales Supervisor
Beacon Athletics
10.2018 - 08.2021
- SQL & Database Bootcamp-Udemy
- Data Analysis & Visualization using Python, Excel, PowerBI & Tableau-Udemy
- Python Certification-One Month
- Analyst Builder - Python
- Analyst Builder - Pandas
- Supervisory Leadership Series- WI school of Business
Bachelor of Science - Business Management
Edgewood College
Similar Profiles
Selena MaganaSelena Magana
Warehouse Lead at Pacific CycleWarehouse Lead at Pacific Cycle
Todd KniggeTodd Knigge
Senior Demand Planner at Pacific CycleSenior Demand Planner at Pacific Cycle
Marilyn treeceMarilyn treece
Deductions Analyst at Pacific CycleDeductions Analyst at Pacific Cycle