TED GUST

480-***-**** - Cell

ad2kic@r.postjobfree.com

www.linkedin.com/in/tedgustbusinessanalyst

An accomplished Business/Financial Analyst/SAP Consultant with over 20 years’ experience in all facets of Accounting, Finance and Systems implementation/integration. Highly knowledgeable in the following areas:

•Governance and Compliance experience

•BRD-Partnering with business teams at various levels writing clearly defined requirements.

•Manage UAT/Defect tracking and create test scripts for multiple applications.

•Change Request Management

•Project Management-managing multiple Finance/Systems related projects

•Process documentation and improvement for Business standards

•Manage defects and enhancement for SAP and other software applications.

•Ability to adapt to change of processes with no impact to quality of work.

•Risk Management Framework-Analysis, Mitigation and Monitoring

•Financial Reporting, Variance Analysis, Consolidations, Modelling

•Intermediate/Advanced Excel-Pivot Tables, V-lookups, Macros, Cond. Formats, Modeling

•Training end-users on how to best utilize enhancements of software packages.

•SAP S4/Hana and ECC 6.0 for FICO

EXPERIENCE:

Sr Technology Business Services Consultant-Wells Fargo 07/19-12/20, 01/22-8/23

• Perform comprehensive reviews of all Information Security Practices to ensure that the Application Teams have met the required security practices completely and accurately prior to implementing code releases in accordance with RCSA principles utilizing ServiceNow.

• Ensure high quality reviews of Information Security practices so no risks are introduced into systems.

• Leveraged partnerships across teams throughout the entire bank to mitigate risks found throughout the execution of this control.

• Adapt to constant process changes while continuing with the highest level of accuracy.

• Partner with Application Security Champions to ensure that application teams obtain correct guidance regarding Information Security Practices.

• Followed Agile methodology and best practices.

Technology Controls Associate-Wells Fargo 02/21-01/22

• Performed the execution from end-to-end of 2 Compliance Controls that focused on both User Access and Activities and mitigating gaps and weaknesses within these controls.

• Worked in/mapped large excel data files from SAS Grid that contained potential violations. My role was to analyze this data and work with respective Direct Managers to mitigate these issues, also collect evidence on activity violations that had already occurred in accordance with RCSA principles.

• Collaborated and Led the Revocations process for Access violations that had occurred in prior cycles to ensure that all access was compliant per DSOD regulations.

• Resolved complex situations regarding user access and security administration issues utilizing tools such as uDeploy and TFS, AIMS and Group Grabber.

• Updated monthly Metrics Reporting and Execution Narratives on both controls.

• Supported the execution and documentation of risk assessments that were in-scope for this control across all business units within the bank.

• Created process documentation for both controls to ensure consistency on how the controls run by any user.

• Created/maintained User Stories with JIRA. Participated in daily scrum sessions to go through tasks on these controls, highlighted accomplishments and issues that needed full team or outside collaboration to resolve.

• Worked on quarterly audits with IT COSO to ensure that the controls I managed were always in compliance.

• Followed Agile methodology and best practices.

Enterprise Solutions Integrator-Avnet 4/18-6/19

Analyze, design and configure packaged software products to meet business needs on SAP and non-SAP applications on both front/back-end uses. (SAP, IDOCS, Fieldglass, Concur, Ariba, D2L, Workday, Serengeti)

Partnered and leveraged with teams in multiple departments to gather requirements for defects and enhancements to ensure complete resolution.

Ensure the overall effectiveness of Finance/HR and Legal software systems and proactively evaluate, recommend and implement cost effective solutions.

Solved highly complex and unusually challenging technical problems. Identified gaps within specific processes to increase user effectiveness, efficiency, accessibility and accuracy.

Created functional design specs and managed UAT including writing test scripts within the assigned applications on all Project related enhancements/upgrades.

Ensured correct tools were used as business requirements changed.

Followed Agile methodology and best practices.

SAP FI Consultant-Illumiti 4/17-2/18

Global SAP S4/Hana implementation project for large mining company in Phoenix, AZ and in Africa. I was responsible for A/P, A/R and Treasury work streams in conjunction with outside SAP Consulting firm.

Responsible for creating Blueprints with Business Partners-ensured that all processes were identified, and any custom T-codes were best defined to move into SAP standard configurations when possible.

Worked with FC Consultants to create FDS Docs, present them to the Customer and obtain sign-off.

Managed Integration and UAT Testing environments with Project Team and the Customer to ensure all functionality worked correctly, especially where application crossed into other work streams. Wrote/executed test scripts within the accounting modules I managed on SAP for this project.

Responsible for deployment of all functionalities within my assigned work streams in both Phoenix and the Mine site in the Congo of Africa.

Responsible for the development and documentation implementation of the BCP program including governance policies processes and standards for both US based and DRC locations in Africa.

Ensured that all training documents were completed and presented to all Business Users and addressed any issues immediately to reduce and down-time after Go Live.

The largest development managed was A/P Workflow which was successfully deployed in both Office locations utilizing a HR structure to minimize the need for constant table updates.

Followed Agile methodology and best practices.

Project Analyst-Wells Fargo 2/11-11/16

Performed Month-end close process, Monthly Forecasts, Financial Reporting and Modeling, Annual Budgets, Variance Analysis for Projects in excess of $100M.

Performed all month-end close activities including reconciling all GL accounts.

Partnered with multiple Business groups for Forecasting/Budgeting and created files in SharePoint to be updated during the process which increased overall efficiencies on both side and enabled the Business to see financial results in real time.

Created a Financial Modeling Tool to track all project details which auto-populated multiple summary reports for different Management levels. This tool is being used on all Projects within the Wells Fargo International Group and shared at the executive level.

Financial Reporting Developer-Alarm Point Systems 1/10-11/10

•Worked on two projects in the software industry developing Financial Reports, charts and alerts on a client-based project.

FP&A Manager-NEC Corp of America 08/07-10/09 Responsible for all Accounting & Finance related activities including: Month-end Close, G/L and GAAP review/analysis, Asset/Liabilities review/analysis, Monthly Forecasts, Bi-Annual Budgeting, Cash flow Analysis, Inventory and Warranty Reserve Analysis (Monthly), Supply Chain Management, Sales Incentive plans, Management, Royalties analysis/processing for 12 Business Units.

•Reduced month-end close process by 3 days to 1 days, created/posted all Journals entries and had full management responsibility of both Profit & Loss Statement and Balance Sheets for 12 Business Units.

•Managed and maintained all Monthly/Quarterly/Annual Financial Reporting and Analysis including consolidations for 12 BU’s and 5 Cost Centers.

•Created highly analytical Monthly Reporting Package/Weekly Flash Report for Senior Management to help manage their lines of business more effectively.

•Partnered with BU Managers and advised them on financial strategies to achieve Revenue, Profit and ROI /EV goals.

•Updated Budget/Forecast process to include pipeline information from Salesforce.com as the basis.

•Created Blueprints with Business Partners to ensure that all processes were identified, and any custom T-Codes (SAP short-cuts) were best defined to move into SAP standard configurations when possible.

•Responsible for the development and documentation implementation of the BCP program including governance policies processes and standards.

•Finance Lead on SAP implementation team-upgrade to ECC 6.0.

Manager of Financial Projects-Chas Roberts Air Conditioning 1/05-09/06

Largest HVAC Company in Arizona with Revenues of $300M

Implemented and managed new software/systems for procurement to properly track and analyze $8,000,000 Inventory portfolio, set-up, manage and maintain new labor tracking system (converted to time clocks). These two changes related to cost savings in excess of $1M per year.

Developed new bidding process and assisted with revising purchasing process to ensure accuracy and competitiveness.

Managed the Payroll/Benefits Department for 1,600 employees with a weekly payroll.

Managed all Audits for Payroll, Benefits, Inventory and Costing.

Worked on various Financial Analysis projects as needed for the CEO, COO, and CFO.

EDUCATION:

Bachelor of Arts in Economics with emphasis in accounting

Ripon College, Ripon WI

Software Applications

Microsoft Office, Service Now, PAC2000, SD Elements, Threadfix, uDeploy, TFS, AIMS, Group Grabber, Threat Modelling Tool, FSR Pipeline, HP ALM, SAP S4/Hana & ECC 6.0, SQL, Ariba, Concur, Workday, Fieldglass, D2L, Middleware, TOAD, Salesforce.com, Oracle, ADP.

Contact this candidate