Jacob Anderson Email & Phone Number

Phoenix, Arizona, United States

⬝ Managed security over the state's financial system, in which over 700 security, business, and workflow access requests were processed using CGI, SAP infoAdvantage and Microsoft Excel. ⬝ Supervised the ADOA security email inbox, where over 150 customer matters and requests were either delegated or resolved using GMail and other systems needed to resolve matters.⬝ Analyzed and audited monthly and quarterly employee access rights to ensure active users had the correct security access and non-active users were removed from the system using CGI and Microsoft Excel.⬝ Reviewed and revised several Quick Reference Guides to ensure they were up to date and available on the state’s training website using Microsoft Word, Adobe Publisher and Six Sigma.

• Created and reconstructed several IT Financial reports, in which KPIs and filters were modified, assigned by the Cost Transparency and Bill of IT groups as user stories through our Rally Software, using Apptio, along with Excel for reconciliation and validation purposes.• Oversaw and executed the monthly Cost Transparency and Bill of IT operations processes, to ensure daily IT financial data was loaded, modeled, and reconciled by the end of month close utilizing Apptio, Alteryx, Informatica, and Excel. • Tracked and redirected user stories and backlog items to other colleagues on the team to maximize everyone's workload and minimize wasted time using Rally Software and Microsoft Outlook.

Phoenix, Arizona, United States

• Constructed and rebuilt dozens of financial reports, requested by the Cash Management, Fiscal Operations and Revenue Fuel Tax Admin (RFTA) groups via our ManageEngine ticketing system and GMail in which tickets would be prioritized by urgency, time of receipt, and risk, using SAP infoAdvantage and Excel.• Acted as ADOT’s daily ETL monitor to ensure that the Arizona General Accounting Offices (AGAO) ETL files are delivered on time and accurately to our Microsoft SQL and Cognos Ad Hoc Servers for users to access.• Presented Wrike, Clickup, and Smartsheet as potential project management tools to C-level audiences in an effort to merge our project plans and dashboards into one system, which led to Smartsheet being chosen.• Built and implemented a data dictionary dashboard of our previously undocumented financial database system using Tableau, Excel, and Google Sheets.• Developed multiple daily and monthly standard work procedures and process flows for my own team, along with RFTA, using Visio and Lucidchart in conjunction with our organizational goal of ensuring processes are sustainable, replicable, continuously improving for future onboarding and cross-training.• Coordinated, deleted and consolidated hundreds of reports to reduce our agencies reporting footprint by 75%, within infoAdvantage, in a statewide collaboration effort to prepare for our reporting system upgrade migration.

Phoenix, Arizona, United States

• Performed data analysis, and recommended improvements to accounting processes in reviewing Fuel Tax Revenue reports from the 2018-2019 fiscal years.• Created custom reports and/or accrual basis reports, or running system generated reports for an end user in SAP Webi.

Phoenix, Arizona Area

• Monitor the bakery area to locate expired or nearly expired bakery goods for markdown or throw away and use various sales reports to identify sales opportunities showing an attention to detail and maximize sales.• Often assist store managers and other departments when finished with daily tasks which demonstrates the ability to multi-task in a fast-paced environment.

Bachelor Of Science - Bs, Applied Mathematics, 3.18 Gpa

Activities and Societies: Next Generation Service Corps

Minor, Economics

Certificate, Cross-Sector Leadership