Zachary Braunstein
East Brunswick,NJ
Summary
Detail-oriented Accounting and Business Analytics professional with expertise in using decision frameworks in Excel, AI workflow automation, and predictive analytics in R and Python. Skilled in visualizing complex data through BI software and ensuring accuracy in financial statements and audits. Committed to enhancing business operations while maintaining compliance and integrity.
Overview
1
1
Certification
6
6
years of professional experience
Work History
Business Analyst & Consultant
Pittsburgh Management Consulting
Pittsburgh, PA
09.2024 - 12.2025
- Built a comprehensive, integrated Excel dashboard for a large consumer goods retailer in PA, tracking key performance indicators and variances across their sustainability efforts, to reduce carbon footprint across 45 locations, leading to enhanced spend precision and cost reduction across utilities and natural resources needed for operations.
- Researched use cases for supply chain optimization, supporting strategy for a Fortune 500 biotechnology client by analyzing existing systems to identify improvement areas and determine optimal vendor fit under budget constraints.
- Analyzed sector and company-specific process inefficiencies in a regional engineering firm's campus recruitment pipeline, leveraging student sentiment survey from 53 students to develop tailored recommendations that enhanced competitive positioning and the job/internship process.
- Drafted client reports and collaborated with consultants to present findings clearly to professional audiences, including senior stakeholders, on a weekly basis.
Founder
ZB Detailing
Shrewsbury, NJ
06.2020 - 08.2022
- Founded and operated small business serving 20 clients in tri-state area; established feedback systems to enhance service satisfaction, managed inventory replenishment of detailing supplies for value creation, and oversaw financial management including budgeting and growth opportunity assessments
- Implemented strategic procedures to service additional detailing clients daily while assessing consumer needs to guide product offerings
- Developed and maintained social media page to foster positive presence and reputation, increasing recurring revenue and lifetime value while ensuring quality work
Education
Bachelor of Science - Business Administration
University of Pittsburgh
Pittsburgh, PA05-2028
Skills
- Microsoft Excel (Intermediate)
- Wave Accounting
- SAP, Zapier, QuickBooks, Bloomberg
- SQL, R, Python, Tableau Analytics Tools with Machine Learning capability
- Payroll, A/R, A/P, Account Reconciliation
- Variance Reporting, Budgeting, Cost Control, Audit
- Attention to Detail, Organizational Skills, Team Collaboration, Time Management, Managerial Ethics, Leadership
Activities
Team Captain, High School Varsity Track and Cross Country
Affiliations
- Volunteer, East Brunswick Youth Council
- Volunteer, National Honor Society
- Brother, Alpha Epsilon PI
Certification
- QuickBooks ProAdvisor Client Advisory Services Foundation Certified showing competency across AI in Accounting, Intuit Bookkeeping, QB Certification Level I, Client Communication & Financial Statement Analysis
- Bloomberg Financial Spreadsheet Analysis across Macros, Fixed Income & Equities
- EY Audit Job Simulation - Forage
- SAP End to End Business Processes in SAP Business Suite Certified
- Zapier AI Agents, Intermediate Zaps, MCP Integration & Governance Certified
Timeline
Business Analyst & Consultant
Pittsburgh Management Consulting
09.2024 - 12.2025
Founder
ZB Detailing
06.2020 - 08.2022
Bachelor of Science - Business Administration
University of Pittsburgh