Tricia Bleavins
Utah • 217-***-**** • ***********@*****.*** • LinkedIn • GitHub
Strategic data analyst and Six Sigma Green Belt specializing in SQL-driven analysis, executive dashboards, and operational performance insights across manufacturing, retail, and business environments. Converts complex data into decision-ready intelligence that strengthens revenue performance, cost control, and operational efficiency. Designs rigorous SQL analyses and Tableau dashboards that bring clarity to business performance and KPI visibility. Recognized for disciplined documentation, metric integrity, and collaborative problem-solving across teams. RELEVANT SKILLS & EXPERTISE
Tools/Languages: SQL (SQLite, BigQuery), Spreadsheets, Tableau, R (RStudio), Advanced Excel & Google Sheets, C, Python (pandas), Six Sigma Green Belt
Data Management: Data Collection, Data Cleaning, Data Structures, Data Analysis, Data Visualization, Data Ethics, Complex Queries, Joins & Data Aggregation, Executive Dashboard Design, Transformation & Exploratory Analysis, Financial Modeling, Pivot Tables & Structured Reporting
Software Platforms: Microsoft 365 Suite, Google Workspace, Slack, Zoom, GitHub, VS Code, Kaggle, Loom Strengths: Problem-Solving, Cross-Functional Collaboration, Attention to Detail, Project Management, Communication, Teamwork, Analytical Thinking, Innovation, Strategic Thinking, Operational Efficiency, Stakeholder Management, Process Improvement & Performance Optimization, Executive Reporting
DATA ANALYSIS PROJECTS
Executive Profitability & Customer Risk Analysis — SQL, Tableau, Python & Excel GitHub 02/2026
● Analyzed 9,995+ transactional records across customers, products, and orders using SQL, spreadsheets, Python, and Tableau to evaluate profitability, customer risk, and revenue performance
● Cleaned, structured, and validated raw business data using SQL and spreadsheet workflows (Excel & Google Sheets) to ensure accuracy and identify potential data gaps before analysis
● Developed KPI and profitability analysis identifying loss drivers, high-risk customers, and revenue concentration trends impacting overall business performance
● Built executive-level dashboards and visual summaries in Tableau to communicate insights and support data-driven decision-making
● Designed a structured reporting workflow simulating real-world business review and performance analysis processes used by leadership and sales teams
RELEVANT EXPERIENCE
Learning Associate-Data Analyst • Merit America, Remote, Utah 11/2025 - Present
● Completed an intensive 19-week data analytics program integrating Google Data Analytics Professional Certificate coursework with career coaching and professional skill development.
● Built proficiency in SQL and R programming for data collection, transformation, and visualization to support data-driven decision-making.
● Delivered a capstone project applying the full data analysis process — from asking questions to visualizing insights using real-world business scenarios.
● Strengthened professional skills in communication, collaboration, time management, and project organization using tools such as Google Workspace, Slack, and Zoom.
Active Career Break- Family Care 01/2013 - 11/2025
● Provided full-time family care while independently managing household financial operations and administrative oversight Food Service Coordinator • Hucks Food and Fuel, Decatur, IL 01/2012 - 01/2013
● Managed inventory levels using daily counts and sales patterns to forecast product needs, reduce waste, and ensure consistent stock availability
● Analyzed ordering and usage trends to optimize replenishment schedules, improving cost control and minimizing stockouts
● Streamlined food preparation workflows by tracking order volume and adjusting processes to improve speed and efficiency
● Maintained accurate records of inventory, waste, and sales activity, supporting more informed operational decisions
● Built and maintained Excel-based tracking and reporting for inventory, sales patterns, and ordering trends to support cost control and operational planning
Assembly Test Specialist • Caterpillar, Inc., Decatur, IL 09/2007 - 04/2009
● Applied Six Sigma Green Belt methodology to support process improvement initiatives within a high-volume mining truck assembly environment, reinforcing structured problem-solving and performance optimization discipline
● Followed defined build specifications and testing procedures for 40/50- and 60/70-ton mining trucks, strengthening attention to detail and accuracy—key skills for validating and interpreting technical data
● Monitored part usage and organized the work area to maintain efficient workflow, demonstrating process tracking, inventory awareness, and the ability to identify inefficiencies through observation
● Documented issues, maintained a clean and compliant workspace, and adhered to safety and quality standards, reflecting strong data integrity habits and commitment to reliable, repeatable processes Administrative Assistant • Mari Mann Herb Co., Decatur, IL 08/2005 - 08/2007
● Managed and maintained inventory and sales datasets, applying data cleaning and data validation techniques to support accurate trend analysis and forecasting
● Processed accounts receivable and purchase orders, analyzing financial transaction data to identify cost-saving opportunities and optimize vendor performance
● Developed and streamlined a data filing system, facilitating database management and improving data accessibility for operational reporting
● Collected and interpreted customer and event data (from cooking classes and garden tours), generating insights used to drive customer engagement strategies
● Reconciled financial data from credit card deposits, maintained an audit-ready database, and produced regular reports to inform decision-making
EDUCATION & CERTIFICATIONS
Introduction To Computer Science (CS50x) • Harvard University, Virtual Google Data Analytics Certificate • Merit America, Virtual B.S. Management and Organizational Leadership • Millikin University, Decatur, IL Six Sigma Green Belt • Caterpillar, Inc., Decatur, IL A.A.S. Network Technology • Richland Community College, Decatur, IL A.S. Computer Information Systems: Microcomputer Specialist • Parkland College, Champaign, IL A.S. General Science • Richland Community College, Decatur, IL