Open to opportunities

Jaime McDonald

@jaimemcdonald

Message

Professional data analyst specializing in pricing, BI, and process automation.

United States

Message

What I'm looking for

I seek analyst roles emphasizing pricing, BI, automation, and reporting in collaborative teams where I can improve processes and deliver actionable insights.

I am a data analyst with 7+ years applying mathematical, statistical, and programming skills to pricing, business intelligence, ad-hoc reporting, data management, and process improvement. I combine technical proficiency with creative problem-solving to deliver accurate, actionable insights.

My experience includes senior pricing and pricing operations roles where I automated database updates, created Access and SQL processes, developed interactive Excel reports with Visual Basic, and managed coupon and price-change workflows. I have produced regular executive reports and maintained pricing component databases used by 15+ users.

Earlier, I supported regional transportation planning by designing tools in Excel and Access, building Tableau dashboards to visualize population, transit ridership, and freight flow trends, conducting field studies at 100+ sites, and generating monthly commuter reports for multiple agencies.

Experience

Work history, roles, and key accomplishments

Pricing Operations Specialist

CompuGroup Technologies

Sep 2019 - Mar 2020 (6 months)

Verified and reviewed pricing accuracy in merchandise advertising, approved and released price changes, and managed weekly coupon creation-to-release processes to ensure promotional integrity.

Pricing Analysis Excel Access SQL Quality Assurance Process Management Reporting

Senior Pricing Analyst

Thermo Fisher Scientific

Nov 2015 - Apr 2018 (2 years 5 months)

Automated and managed daily pricing database updates for 15+ users, created Access processes with SQL, and produced weekly/monthly pricing accuracy reports consumed by company directors.

SQL Excel Visual Basic Pricing Automation Reporting Data Management Rebate Processing

Data Analyst

Southwestern Pennsylvania Commission

Feb 2008 - Nov 2015 (7 years 9 months)

Researched, compiled, analyzed and presented regional transportation planning data, developed Excel/Access tools and Tableau dashboards to automate reporting and visualize changes in population and transit ridership.

Tableau Excel Visual Basic SQL Data Analysis GIS Field Data Collection Reporting Dashboard Development

Education

Degrees, certifications, and relevant coursework

Pennsylvania State University, University Park

Bachelor of Science, Mathematics

Completed a Bachelor of Science in Mathematics with a minor in Statistics, including coursework in regression analysis, stochastic modeling, ANOVA, group theory, and mathematical modeling.