Andrew Prairie

Indianapolis,IN

Summary

Skilled cost estimation professional with strong track record in delivering precise project assessments and budget management. Brings expertise in data analysis, risk assessment, and resource allocation. Known for strong collaboration within teams, adaptability, and achieving consistent results. Reliable and highly focused on meeting project deadlines and client expectations.

Overview

years of professional experience

Work History

Cost Estimator

SupremeX Inc.

Indianapolis, IN

08.2025 - Current

Prepare detailed cost estimates using raw material, labor, and production performance inputs for packaging products
Generate pricing and support quotes, bids, and customer proposals based on cost analysis
Analyze customer specifications, structural layouts, and job requirements to ensure accurate costing
Collaborate with sales, customer service, and production teams to align pricing with operational capabilities
Identify and evaluate cost drivers, improving estimate accuracy and supporting margin optimization
Assist in resolving pricing discrepancies and refining estimate assumptions
Support job costing analysis and financial reviews by comparing estimated vs. actual performance
Contribute to improving internal workflows and maintaining efficient turnaround times on estimates

Data & Claims Analyst

Trojan Roofing

Indianapolis, IN

01.2024 - 08.2025

Analyzed insurance claim data to identify underpaid items and boost supplement approval rates by over 25%.
Used CRM and digital tools to manage claims pipeline, track stages, and document damages.
Collaborated with project managers and sales teams to validate scopes, ensuring cost accuracy.
Created Excel-based tools for scope reconciliation and report generation.
Standardized documentation and trained new hires, improving claims submission efficiency.

E-commerce Data Analyst

Pristine LLC

Franklin, IN

05.2020 - 01.2024

Built and scaled an Amazon storefront, achieving over 98% customer satisfaction.
Developed Excel dashboards and SQL queries to monitor key metrics: conversion rates, inventory turnover, and refund patterns.
Forecasted demand using historical sales data and adjusted listings using BI insights.
Automated reporting tasks and basic ETL workflows using Python (pandas), reducing manual tasks by 30%.
Conducted A/B testing on product listings to increase visibility and improve ROI.

Skills

Languages & Tools:
SQL (PostgreSQL, MySQL), Python, Excel, Tableau, Power BI

Data Cleaning, ETL, Forecasting, Business Intelligence, Data Visualization, Dashboard Creation
Process Optimization, KPI Reporting, Workflow Automation, Inventory Analysis, Customer Insights

Timeline