Ryan Strahm Email & Phone Number

Chicago, Il, Us

Chicago, Il, Us

• Cooperate with financial auditors to complete integrated audits delivering comprehensive process analysis over the information technology general controls in place at entities.• Conduct tests of controls, designs, and effectiveness for systems as a part of PCAOB audits for companies across various industries.• Prepare workpapers to document results of audits, facilitate receival of necessary evidence to perform corrective action, and present relevant conclusions to management team and external control owners. • Support public sector advisory engagements as a borrowed resource to complete comprehensive system analyses and gain experience outside of commercial auditing.• Administrate on-site and virtual system walkthroughs to gather evidence for audited companies.• Communicate with internal auditors, IT specialists, and subject matter experts to gain understanding of risks and mitigating controls in place within the IT environment.

Indianapolis, In, Us

• Assembled Tableau dashboards, custom Snowflake SQL queries, and various scripts with the purpose of streamlining Ivy Tech’s transition from Pentaho to Tableau.• Resolved over 150 Information Technology Service Desk tickets to troubleshoot user issues, convert custom Pentaho reports to Tableau, and identify weaknesses in the queuing methodology.• Collaborated with independent contractor through Microsoft Azure DevOps to organize the conversion of queries and launch of IvyAnalytics.• Attended daily and weekly sprint review meetings with the Office of Information Technology, OneBridge, and Chief Data Officer as a part of Agile system development to ensure communication of progress, issues, and goals.

Indianapolis, In, Us

• Obtained PCI and FERPA compliance in order to oversee front desk operations, handle cash, and accept credit cards.• Improved Excel financial records to accurately keep track of daily transactions and more quickly view specific measures.• Operated telephone daily to field students’ questions regarding account status, balance due, and various inquiries regarding the institution.

Louisville, Ky, Us

• Worked with customer representatives to analyze customer usage and forecast changes, notifying customer representatives of missing items and placing orders for replacements.• Established a refreshable database of over 50 customer contracts to view liability on $20 million worth of inventory.• Mastered PowerQuery and PowerPivot to summarize over 50,000 item sales across a 24-month period.• Produced new, macro-based Excel indexing sheets to inventory missing items for customers.• Improved existing Excel analysis sheets by taking advantage of VBA functionality for sorting and consolidating large amounts of data.• Created tool that will be used in weekly sales strategy meetings to more accurately predict company decisions regarding $8 million+ of liability across customers.• Impacted the Data Engineer by assisting with the efficiency of processing large files for tracking customers’ items.• Operated SAP software to view invoices and ascertain item usage.