Jonathan Barragan Email & Phone Number

Rialto, Ca, Us

Rancho Cucamonga, California, Us

Generated 20 weekly inventory reports by conducting daily cycle counts & tracking 165 SKUs, reducing shrinkage by 12%.Forecasted 165 inventory levels by monitoring inventory turnover in Excel & generating 15 purchase requisitions, minimizing stock outs by 15%.Analyzed Excel data from cycle counts, Gemba walks & sales data by identifying inefficiencies & tailoring 5 solutions, improving operational processes by 15%.Oversaw 75 inbound & outbound shipments by cycle counting & documenting 100+ orders to match with invoices/POs, decreasing inventory discrepancies by 20%.Processed 100 daily orders & reviewed costs for LTLs by comparing shipping rates on ERP, Shipstation, lowering shipping costs by 5%.Executed 2 weekly inventory projects by planning project documents & coordinating teams, achieving a 95% on-time completion rate.

Rancho Santa Margarita, California, Us

Trained 3 employees by supervising & correcting 25 closing & opening procedures, improving productivity by 15%.Resolved 35 customer complaints by proactively addressing concerns, decreasing negative reviews by 12%.Verified $3,000 weekly invoices by cycle counting 60 SKUs to identify discrepancies, minimizing billing errors by 10%.

Streamlined 50 client meetings for open houses by managing a digital calendar system, reducing scheduling conflicts by 15%.Communicated with 30 calls & 50 emails weekly by answering & redirecting inquiries to agents, reducing agent interruptions by 20%.Administered 4 online platforms by using AI to create compelling ads to enhance 35 property listings, increasing engagement by 15%.Administered 10 office supplies restocks on a weekly basis by ensuring uninterrupted workflow, reducing supply shortages by 25%.

Winona, Mn, Us

Managed a team of 10 by using SmartSheet to coordinate 120 tasks for a $50k project from initiation to close, generating $1M in revenue.Executed 10 RFxs sourcing a product portfolio of 600 SKUs by vetting 15 vendors, resulting in 5 new suppliers.Coordinated 2 requisitions, 3 work orders & 7 employee schedules by ensuring material & labor availability, implementing a $50k project in 1 day.Collaborated between 3 stakeholders, 5 departments & 3 vendors to implement a value stream map in Visio, creating $120k in customer cost savings.Maintained 4 Power BI KPIs by tracking 6 project schedules, expenses & risks, ensuring 6 projects under budget.Engaged 10 stakeholders by leading 12 biweekly meetings derived from PowerBI & SharePoint reports, delivering 6 projects on time.Automated data entry & analysis of 5 spreadsheets by creating 3 Excel macros & JavaScript programs, reducing project timelines by 12%.

Winona, Mn, Us

Delivered 2 Power BI reports by showcasing 4 cycle times to management & leading 4 process improvements, reducing labor costs by 30%.Trained 6 coworkers on 5 new process workflows by creating 5 SOPs & providing user training, driving up productivity by 20%.Visualized 12 CRM inventory reports using Power BI to identify & remove $60k of obsolete inventory, increasing return on assets by 10%. Analyzed 36 sales reports in Excel forecasting 4 customer trends to optimize 6 inventory portfolios, increasing 4 accounts’ sales by 47%.Processed 50 BOLs, 40 transfers, 30 invoices & 30 P.O.s weekly by managing 10 inventories for 7 clients, delivering to 10 sites.

Liaised between 3 business owners and 6 analysts by presenting 3 data-driven business strategies ensuring a 100% adoption rate.Promoted 4 growth strategies for a food and beverage start-up by researching 3rd party market data, influencing expansion into 2 new markets.

Davis, California, Us

Mentored a team of 7 during the onboarding process, developing 3 SOPs to track training progress reducing ramp-up time by 30%.Designed 2 surveys targeting 30 customers using segmentation analysis to optimize 2 marketing campaigns, increasing conversion rates by 10%.Developed 5 business process maps by interviewing 5 department leads, creating 3 user stories prompting research into 4 process improvements. Led a team of 7 to optimize the sales team’s workflow by drafting 3 data-driven reports allocating a $7,500 budget increasing sales efficiency by 15%.Created 10 ad-hoc reports and 20 bi-weekly PowerPoint presentations to leadership distilling 5 root cause analysis into solutions in 10 weeks.

Communicated with directors, staff, and clients to retain client loyalty to ensure successful organization of events at internal and external levels resulting in organization’s growth of 60% year over year.Created, hosted, and advertised 20+ social events for groups of 15 with 98% client satisfaction.Assisted in a virtual banquet during COVID-19, allowing members to accessmentorship, guidance, and networking safely and effectively as in person.Spearheaded and coordinated the collection and format of over 200+ pictures and testimonials in an online yearbook to commemorate graduating members.