Data Analyst Des Moines

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

Contact this candidate