| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateJOHNFREDERICKEMAIL AVAILABLEPHONE NUMBER AVAILABLEEdina, MN Street Address
Bold ProfileSkilled 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. Organized with extensive knowledge and success in client education. Adept at mathematical accuracy and following financial regulations. Proven track record of providing financial services to clients while managing complex transactions.PROFESSIONAL SUMMARYWELLS FARGO - Senior Sourcing Consultant07/2022 - CurrentUSBank - Third Party Operations Support Analyst09/2019 - 06/2022SLEEPNUMBER - Senior Logistics & Systems Analyst10/2018 - 09/2019WORK HISTORYDeveloped Tableau and Excel dashboards to enable self-service analytics for the departmentCreated 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 brokersYear-to-date top-10 producer in contracts written and published for the entire department.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 USBankServed as owner of 27 financial analysis reports dealing with mortgage applications, locks, fundings, and commissions for account executives, clients, and regionsWork 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.MFor daily pricing call to maximize potential department revenue and income. Responsible for analyzing coding for proper payment with ODFL, SKILLSSupplier RelationshipManagement 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 Underwriting knowledge Regulatory Compliance Sales Forecasting Customer service-focused Loan OriginationResidential mortgage lendingregulations Document Review Data Entry NMLS Registration Financial History Review Income Evaluation Application verification Terms Definition Financial transactions expertise Financial analysis aptitudeUNIVERSITY OF MINNESOTAMinneapolis, MNBachelor of Arts: JournalismNORTHWESTERN UNIVERSITYEvanston, ILCreative Writing ProgramEDUCATION3M - Data Analyst04/2018 - 10/2018USBANK - Private Client Associate/MLO/Personal Banker Minneapolis, MN 10/2012 - 12/2017UPS, XPO, DLS, among others Analyzing daily rescheduling for XPO loadsClosed loads and accepted tenders up 10% since takeover of those tasks with days to close load going down to an average of 1 dayHandling 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.Responsible for analyzing changes in SAP order processing, buying, and requestingRequired 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 hierarchyDesignate proper vendors to use for certain products based on percentage of orders to and from companies, closest maintenance plant, or pricing.Responsible for generating over $20M total revenue through mortgages, home equity loans, home equity lines of credit, and investmentsGenerated own network of realty, business, and investment contacts throughout Twin CitiesAdhered to legal federal regulations (FINRA, SEC, CFPB, etc.) and strict internal guidelinesResponsible for yearly audits of data privacy, security, and knowledge of updated federal regulationsAs MLO, managed two three-individual teams and reported to Region Manager Go-to mentor for new staffing and potential promoted employees. REFERENCESGreg Schiveley, USBank TPO Sales Support Analytics Manager, 617-947-8111 Chad Falkenborg, Lendtrust Vice President, PHONE NUMBER AVAILABLE/pre> |