Joshua R Schoonover
ad5q6p@r.postjobfree.com Cell: 515-***-****
SUMMARY OF QUALIFICATIONS:
** ***** ** ******* **********
** ***** ** ***** *****/pivot tables experience
* ***** ** SAP experience
8 years of Risk Management experience
8 years of Audit experience
3 years of Tableau experience
2 years of SQL/Teradata Server experience
EXPERIENCE
Wells Fargo, West Des Moines, Iowa November 2023 – April 2024
Senior Lead Data Analyst
Provides analysis of operational risk associated with people, process, and systems to ensure maximum business results and effective risk mitigation strategies
Partners with Business Risk and Control team officers, senior associates, and applicable central technology controls teams
Performs reviews of new products, solutions, projects, and program requirements, evaluating control strength and associated risks
Reviews mitigation/remediation plans and provide counsel on mitigation effectiveness and alternative mitigation approaches
Led Access Management process for multiple business units within Data Management & Insights
Wells Fargo, West Des Moines, Iowa June 2021 – November 2023
Control Senior Associate Commercial Banking
Provides analysis of operational risk associated with people, process, and systems to ensure maximum business results and effective risk mitigation strategies
Partners with Business Risk and Control team officers, senior associates, and applicable central technology controls teams
Performs reviews of new products, solutions, projects, and program requirements, evaluating control strength and associated risks
Reviews mitigation/remediation plans and provide counsel on mitigation effectiveness and alternative mitigation approaches
Supports the development of a strong risk and control culture within the group
Developed and implemented risk mitigation strategies to address known gaps and deficiencies in an effective and timely manner
Wells Fargo, West Des Moines, Iowa October 2018 – June 2021
Analytic Consultant 3 Vulnerability Risk Operations
Acted as an internal consultant within technology and business groups by using quality tools and process definition/improvement to re-engineer technical processes for greater efficiencies
Managed large-scale cyclical weekly forecasting data, rendering data into actionable items which are passed to other teams within the department which enables those units to directly and quickly resolve detected vulnerabilities.
Manage weekly Production process for Vulnerabilities, utilizing Excel, which provides all the departments their outstanding vulnerabilities and workflow to follow
Engaged in large-scale infrastructure system-scanning which seek out known vulnerabilities which are aggregated into large datasets for further analysis by the assessment team
Providing weekly system ‘patch-forecasting’ for several related teams in the cybersecurity department, rendering QUALYS data into actionable items which are assigned to the appropriate teams based on logic-table-driven waterfall
Developing and implementing highly variable system-vulnerability data analytics, including topology assessments, threat-rating analyses, and action-plan reporting for team-members receiving vulnerability data
Maintained daily and weekly excel based reports using macros, pivot tables, and Vlookups
Created VBA macros and shortcuts to increase speed and accuracy of process, necessitated by large (>700k rows) Excel data sets
Kemin Industries, Des Moines, Iowa (Contract) April 2018 – June 2018
Data Risk Analyst
Discovered meaningful market information from large volumes of data and presented to senior executives
Interpreted, analyzed, compared, and drew conclusions from extracted market data
Performed data mining techniques to identify trends and risk management in data sets
Developed reports in Excel based on queried data, and presented in PowerPoint
Department of Veterans Affairs, Des Moines, Iowa April 2015 – May 2017
Senior Auditor
Prepared and examined, or analyzed accounting records, financial statements, or other financial reports
Prepared detailed reports on audit findings and reported to management
Supervise auditing of establishments, and determine scope of investigation required
Developed and implemented risk monitoring and risk reporting processes and controls
Collected and analyzed data to detect deficient controls, fraud, and non-compliance with federal contracts and laws
Analyze the financial details of past, present, and expected operations to identify development opportunities and areas where improvement is needed
Department of Defense, Des Moines, Iowa April 2008 – March 2015
Budget Analyst
Finance Supervisor 2013 / 2015
Served as Defense Travel System Accounting subject matter expert for command.
Managed and motivated a team of up to 4 members
Implemented SAP based GFEBS software and served as primary point of contact on system and help desk.
Analyzed project management financial and equipment reports in SAP and reported to senior management
Developed and trained employees on SAP financial systems
Performed price and cost analyses SAP based supplies and equipment contract proposals
Developed and trained employees on SAP financial systems
Examined estimates for completeness, accuracy, and risk with federal regulations
Maintained and granted user access in multiple DOD based financial systems based on users roles
United States Army, Fort Riley, Kansas March 2003 – April 2008
Accounting Officer
Advised military members in areas such as compensation, and special military pay
Pulled daily financial results and completed daily report
Conducted analysis, reviews, and special studies of over $100,000,000.00 military budget
Responsible for conducting a variety of internal audits and reported to Brigadier General’s staff
EDUCATION
MBA, Business Management, Grantham University
BA, Business Management, Purdue University