Royce Ramos

Data Analytics • Provide data analysis support to the Internal Audit team for analysis of audit data of multiple types via multiple platforms such as ACL, MS Excel, R, MiniTab and MS Access. • Automation support with batch scripting, Visual Basic and VBA. • Package results for auditors, typically in MS Excel in the form of raw data, charts, pivot tables, stratifications, histograms, etc. • Review and analyze SAP data tables and transaction codes across tens of thousands of tables, each table ranging from a few to several hundred fields, and ranging from a few records to over a billion records. • Provide statistical analysis and risk assessment of audit data using R, RStudio and MiniTab. • Generate ad hoc dashboards for visual analysis in MS Excel • Provide guidance for financial and IT audit data analysis methodologies • Review available testing methodologies and their applicability to audit data, such as duplicate testing, applying risk assessment for high risk transactions and vendors, Benford analysis, correlation analysis, stratification based on statistical review of data fields. • Create ad-hoc testing methodologies on a reactive basis for audit teams • Research proactive or real-time data mining strategies • Provide data analysis training support for the Internal Audit team IT Internal Audit • Assist in organizational, company-wide IT audits • Review of systems at the network, operating system, database and application levels. • Provide IT Sarbanes–Oxley (SOX) compliance audit support • Assist in reviews of change management, user account management, backup, restoration and recovery processes, physical security, automated job monitoring review, review of third party services, etc. • Provide data analysis support for IT audits • Identify inefficiencies in user account management review to allow for testing of entire populations as opposed to random or judgmental testing of user accounts. • Review scripting of Python, VB and VBA.