John Frederick
Edina,MN
Summary
Skilled at overseeing complex, high-value technical projects with excellent planning competencies. Well-versed in building positive relationships with intradepartmental and interdepartmental stakeholders and outside customers and vendors. Strong data gathering, scope development and inventory coordination abilities.
Overview
12
12
years of professional experience
Work History
Senior Sourcing Consultant
WELLS FARGO
07.2022 - Current
- Developed Tableau and Excel dashboards to enable self-service analytics for the department
- Created and maintained weekly Gantt chart distributed throughout Sourcing department displaying every sourcing consultant, wealth management, office, and critical facility project through 2025
- Working with Ariba, Tableau, Excel, and Oracle systems
- Negotiated multi-million-dollar roofing, elevator, leasing and construction contracts with outside vendors and brokers
- Year-to-date top-10 producer in contracts written and published for the entire department.
Third Party Operations Support Analyst
USBank
09.2019 - 06.2022
- Solely responsible for department-wide distributed daily, monthly, quarterly, and ad-hoc reporting of all aspects of third-party mortgage operations, a multi-billion-dollar operation within USBank
- Served as owner of 27 financial analysis reports dealing with mortgage applications, locks, fundings, and commissions for account executives, clients, and regions
- Work closely with forecasting monthly and yearly projections for national sales team
- Handled monthly and yearly reviews of East and West sales regions
- Analyzing conventional, government, jumbo and HFA loans to assess potential for sales growth
- Working with Excel, Access, and Power BI systems
- Since beginning of COVID pandemic have produced daily report at 6 A.M
- For daily pricing call to maximize potential department revenue and income.
Senior Logistics & Systems Analyst
SLEEPNUMBER
10.2018 - 09.2019
- Responsible for analyzing coding for proper payment with ODFL, UPS, XPO, DLS, among others
- Analyzing daily rescheduling for XPO loads
- Closed loads and accepted tenders up 10% since takeover of those tasks with days to close load going down to an average of 1 day
- Handling weekly processes of unclosed loads, advance tenders, returns, and miscellaneous truck building
- Working with Excel, Access, Smartsheet, and TMS BluJay systems
- Answering vendor questions and concerns regarding loads and shipments.
Data Analyst
3M
04.2018 - 10.2018
- Responsible for analyzing changes in SAP order processing, buying, and requesting
- Required to scrub a bi-weekly excel spreadsheet ranging up to 19,000 rows by attributing the correct products to the correct sourcing groups within the 3M hierarchy
- Designate proper vendors to use for certain products based on percentage of orders to and from companies, closest maintenance plant, or pricing.
Private Client Associate/MLO/Personal Banker
USBANK
Minneapolis, MN
10.2012 - 12.2017
- Responsible for generating over $20M total revenue through mortgages, home equity loans, home equity lines of credit, and investments
- Generated own network of realty, business, and investment contacts throughout Twin Cities
- Adhered to legal federal regulations (FINRA, SEC, CFPB, etc.) and strict internal guidelines
- Responsible for yearly audits of data privacy, security, and knowledge of updated federal regulations
- As MLO, managed two three-individual teams and reported to Region Manager
- Go-to mentor for new staffing and potential promoted employees.
Education
Bachelor of Arts - Journalism
UNIVERSITY OF MINNESOTA
Creative Writing Program -
NORTHWESTERN UNIVERSITY
Skills
- Supplier Relationship Management
- Vendor evaluation
- Supply Chain Optimization
- Strategic Sourcing
- Procurement strategy
- Logistics Management
- Cost Analysis
- Pricing Analysis
- Inventory management skills
- Documentation skills
- Project Management
- Vendor Relationship Management
- Contract Negotiation
- Teamwork and Collaboration
- Problem-Solving
- Attention to Detail
- Multitasking
- Reliability
- Excellent Communication
- Organizational Skills
- Team Collaboration
- Relationship Building
- Adaptability and Flexibility
- Microsoft Office
- Team building
- Analytical and Critical Thinking
- Interpersonal Skills
- Analytical Thinking
- Strategic Planning
- Written Communication
- Data Analysis
- Financial Analysis
References
- Greg Schiveley, USBank TPO Sales Support Analytics Manager, 617-947-8111
- Chad Falkenborg, Lendtrust Vice President, 612-239-5561
Timeline
Senior Sourcing Consultant
WELLS FARGO
07.2022 - Current
Third Party Operations Support Analyst
USBank
09.2019 - 06.2022
Senior Logistics & Systems Analyst
SLEEPNUMBER
10.2018 - 09.2019
Data Analyst
3M
04.2018 - 10.2018
Private Client Associate/MLO/Personal Banker
USBANK
10.2012 - 12.2017
Bachelor of Arts - Journalism
UNIVERSITY OF MINNESOTA
Creative Writing Program -
NORTHWESTERN UNIVERSITY