Rachel Smith

View Portfolio

Data Resume

RACHEL SMITH

DATA ANALYST | BUSINESS ANALYTICS | POWER BI | SQL | PYTHON

McMinnville, Oregon  |  503-435-9557  |  joylikerachel77@gmail.com |  linkedin.com/in/rachel-smith7

SUMMARY

Business Analytics graduate student with hands-on experience using Python, SQL, Power BI, machine learning, and natural language processing to transform complex data into actionable insights. Built an end-to-end procurement analytics solution for the Port of Portland, including automated PDF data extraction, interactive dashboards, clustering analysis, and a searchable document repository. Brings 8+ years of customer-facing and high-volume operational experience, with demonstrated success improving fulfillment speed, data accuracy, inventory processes, and customer outcomes. Master of Business Analytics anticipated December 2026.

SKILLS

Analytics & BI: Power BI, Tableau, Advanced Excel, KPI reporting, data visualization, forecasting, statistical analysis.

Programming & Data: Python, Pandas, NumPy, SQL, data cleaning, data modeling, database management.

Machine Learning & NLP: K-Means clustering, text embeddings, TF-IDF, natural language processing, predictive analytics.

Tools & Platforms: PyCharm, Jupyter Notebook, Anaconda, ChromaDB, Microsoft Azure.

PROJECTS

Port of Portland Procurement Analytics Platform | Academic Business Analytics Project

  • Collected, consolidated, and analyzed more than 1,400 government procurement documents to streamline the call-for-bid process and improve access to project information.
  • Designed an automated Python and Pandas workflow to extract, clean, validate, normalize, and structure data from unstructured PDF documents.
  • Built interactive Power BI dashboards tracking bid activity, engineer estimates, project timelines, contractor participation, procurement trends, and executive KPIs.
  • Applied K-Means clustering to compare engineer estimates with contractor pricing, identify pricing patterns, and surface potential outliers.
  • Developed a searchable document repository using ChromaDB and text embeddings, enabling rapid retrieval across thousands of indexed records.
  • Calculated an estimated 3.96× return on investment from improved reporting efficiency and reduced manual processing.

EXPERIENCE

Apparel Department Lead / Apparel Associate                                                                      Sep 2021 – Present

Walmart, McMinnville, Oregon

  • Use Walmart inventory systems, handheld TC devices, and RFID technology to perform inventory lookups, shelf audits, item-location verification, cycle counts, and discrepancy investigation.
  • Analyze inventory reports and on-hand quantities to identify replenishment opportunities, improve product availability, and support accurate merchandising decisions.
  • Process pricing changes, markdowns, and product updates through digital retail applications while maintaining data and transactional accuracy.
  • Improved fulfillment speed by 30% by identifying workflow delays and reducing customer wait time.
  • Maintained 99%+ transactional accuracy during peak periods by validating information and resolving technical and inventory issues in real time.
  • Recognized with company leadership and service awards for coaching team members and supporting performance during high-demand seasons.

E-Commerce Service Professional                                                                                       September 2021-2023

Walmart, McMinnville, Oregon

  • Maintain a 98% First-Time Pick Rate by ensuring accurate product selection, substitutions, labeling, and order staging in a high-volume fulfillment environment.
  • Create and track service tickets for missing or delayed orders, verify order and product data, and coordinate timely resolution across store teams.
  • Align daily inventory and order workflows with budget targets, service-level goals, and team performance metrics.
  • Keep customer wait times at three minutes or less while delivering professional support and resolving order issues.

Marketing Writing Intern | Lil’ Iguana Children’s Safety Foundation                                  June2022-Sept 2022

New York

• Created monthly newsletters and blog content focused on child-safety education for a nonprofit audience.

• Supported marketing communications by translating program information into clear, audience-appropriate content.

EDUCATION

Master of Business Analytics                                                                                      Anticipated Dec 2026

Oregon State University

Analytics & BI: Power BI, Tableau, Advanced Excel, KPI reporting, data visualization, forecasting, statistical analysis

Programming & Data: Python, Pandas, NumPy, SQL, data cleaning, data modeling, database management

Machine Learning & NLP: K-Means clustering, text embeddings, TF-IDF, natural language processing, predictive analytics

Tools & Platforms: PyCharm, Jupyter Notebook, Anaconda, ChromaDB, Microsoft Azure

Bachelor of Science, Business Marketing and Finance

Southern New Hampshire University

• Completed analytical projects involving datasets of more than 40,000 records using statistical analysis, visualization, and predictive techniques.

• Applied forecasting, budgeting, financial modeling, ROI analysis, customer segmentation, market research, and marketing analytics to business decisions.

Certification

Google AI

Power BI and scaling business data.

An elegant flat-lay composition of a silver laptop partially open, its screen filled with a complex yet clean data model diagram and interconnected flow arrows. Beside it lie a tablet showing a time-series forecast chart and a smartphone with a compact dashboard of key performance indicators. On the desk, a small acrylic stand displays an abstract business card layout with simple iconography hinting at email, phone, and web contact info, without legible text. Soft morning window light from the right creates gentle highlights and long, calm shadows across the wooden surface. Photographic realism, top-down perspective, minimalistic, conveying organized, accessible business intelligence.
A modern, glass-topped conference table covered with printed analytics reports: heat maps, bar charts, and forecasting graphs spread in an organized pattern. At the center, a slim tablet displays an interactive dashboard with glowing data visualizations. Two minimalist metal-and-acrylic nameplates on the table subtly include placeholder elements that imply “Rachel Smith” and “contact details” through icons and layout, without legible text. Overhead, cool white office lighting casts even illumination, creating crisp highlights on the glass and polished metal. Shot from a slightly elevated angle, photographic realism, with a professional, results-driven atmosphere suitable for a portfolio homepage hero image about transforming data into insights.

Transforming Data Into Business Decisions

I’m Rachel Smith, a data analyst who turns complex datasets into clear, actionable insights. Combining business operations experience with Python, SQL, Tableau, and Power BI, I design automated reporting and dashboards that support confident executive decision‑making.

View Portfolio

About

Analytics Skills and Toolset

Core strengths include data analytics, financial modeling, and process automation using Python, SQL, Tableau, and Power BI. I emphasize data integrity, clear executive reporting, and repeatable workflows that scale across teams and evolving business requirements.

View Skills
A modern, glass-topped conference table covered with printed analytics reports: heat maps, bar charts, and forecasting graphs spread in an organized pattern. At the center, a slim tablet displays an interactive dashboard with glowing data visualizations. Two minimalist metal-and-acrylic nameplates on the table subtly include placeholder elements that imply “Rachel Smith” and “contact details” through icons and layout, without legible text. Overhead, cool white office lighting casts even illumination, creating crisp highlights on the glass and polished metal. Shot from a slightly elevated angle, photographic realism, with a professional, results-driven atmosphere suitable for a portfolio homepage hero image about transforming data into insights.

Contact Rachel

Reach out to discuss analytics roles, consulting projects, or collaborations via 503‑435‑9557 or joylikerachel77@gmail.com.

← Back

Thank you for your response. ✨