Aaron Mayer

Aaron Mayer Email and Phone Number

Senior Manager - Data Risk and Privacy - Information Governance and Privacy @ PwC
Columbus, OH, US
Aaron Mayer's Location
Columbus, Ohio, United States, United States
Aaron Mayer's Contact Details

Aaron Mayer personal email

n/a

Aaron Mayer phone numbers

About Aaron Mayer

I am a senior manager at PwC within the Tech & Data division of Digital Assurance and Transparency. I specialize in computer assisted auditing techniques and have experience in a variety of programming languages and data analytics tools. I am also a CPA with significant prior experience working in the field of internal audit. Recently I have been focused on developing reporting dashboards to improve efficiency and decision making for both external and internal audit functions.Before becoming more involved with data analytics at PwC, I worked in Process Assurance providing internal audit services and testing ITGCs for SOX compliance and SSAE 16 reviews for external audit clients.Before joining PwC, I worked at OSU as a member of the Student Life Internal Control Team. My duties included coordinating monthly reconciliations of the general ledger as well as monitoring internal controls over segregation of duties, inventories, cash handling, payroll, procurement, AR, document management, PCI standards, and accounting processes. Also during this time, I became licensed as a CPA.Before that I served as the Fiscal Officer for Student Health Services (SHS). At SHS, I conducted a variety of accounting activities including preparing journal entries, conducting financial analysis, reconciling AR, and coordinating the budgeting process. I also played a key role in managing an upgrade to the medical billing software and documented all accounting procedures in a single manual.As a student, I attended Fisher College of Business at The Ohio State University where I earned a BSBA with an accounting specialization and a Masters in Accounting while working as an assistant manager at a pizza shop.

Aaron Mayer's Current Company Details
PwC

Pwc

View
Senior Manager - Data Risk and Privacy - Information Governance and Privacy
Columbus, OH, US
Website:
pwc.com
Employees:
284983
Aaron Mayer Work Experience Details
  • Pwc
    Senior Manager - Data Risk And Privacy - Information Governance And Privacy
    Pwc
    Columbus, Oh, Us
  • Pwc
    Digital Assurance And Transparency - Tech & Data Senior Manager
    Pwc Jan 2015 - Present
    Columbus, Ohio Area
    --Conducted data modeling to assist a large multinational automotive manufacturer anticipate data conversion issues associated with an SAP HANA upgrade incorporating 12 global instances of SAP--Develop reporting dashboards to help external audit teams and client management improve efficiency and decision making in areas such as audit scoping and risk management --Reconcile trial balances to underlying general ledger activity and search the general ledger activity for unusual or high risk activity using MySQL/Python data transformation scripts (SAS99 testing)--Reperform client calculations of items such as key client reports and billing errors from data sources containing millions of records--Use data visualization software to develop reporting dashboards to facilitate analysis of information from financial systems by management and audit teams to identify areas of significant, unusual, or high risk activity--Draw on background as a data analyst and CPA to reperform client financial statement consolidations and foreign exchange rate effect adjustments--Use knowledge of SQL and VB to analyze and write up client MS Access databases and SQL queries to identify potential risks or weaknesses that could affect data integrity--Make use of general programming knowledge to devise ways to transform and standardize data to ease analysis--Use software to identify key indicators in text and pdf files to convert them into a more readily analyzable tabular format
  • Pwc
    Process Assurance Experienced Associate
    Pwc Apr 2014 - Dec 2014
    Columbus, Ohio Area
    --Worked as an internal auditor on Internal Audit Services co-sourcing engagements and as an external auditor on SOX IT engagements in varied industries including insurance, manufacturing, and retail--Audited IT general controls including access controls, change management, the program development cycle, user provisioning/de-provisioning, and interface controls--Supervised the development of a comprehensive Payment Card Industry standards testing plan for a client based off of the PCI-DSS to ensure the integrity of customer payment card data--Analyzed and advised on potential risks and weaknesses in the business continuity and disaster recovery framework for a client--Evaluated a client's process to select and monitor third party IT service providers and cloud-based IT service providers to ensure the integrity of customer and employee data--Investigated the documentation of the planning, approval, and testing of a client's transition from one data center to another
  • The Office Of Student Life, The Ohio State University
    Resource Analyst, Internal Controls
    The Office Of Student Life, The Ohio State University Mar 2011 - Apr 2014
    Columbus, Ohio Area
    --Coordinated and reported on monthly sample based reconciliations of the Student Life general ledger--Used university financial reporting tools as well as subsidiary data sources to produce analysis that told a clear story--Produced benchmarks and metrics to increase accountability and fuel process improvement--Advised on and recommended ways that Fiscal Support Services could make the most of its limited resources by utilizing information technology and a pool of student assistants eager to obtain real world business experience--Produced training materials and supervised the training of new staff, including a rotating staff of student assistants--Worked with the process owners within Student Life to design and implement measures to strengthen internal controls and promote clearly defined business roles, segregation of duties, and consistent and well documented procedures--Developed and maintained the FSS reconciliations database and acted as a liaison to Student Life Information Technology--Coded and implemented an Access application to pull point of sale data from dozens of daily text reports, compile them into a database, and use that data to automate the journal posting process saving 100+ hours of work monthly--Coded and implemented applications to automate reconciliations and GL corrections saving dozens more hours monthly--Advised the units of Student Life on best practices regarding effective and efficient reconciliations of subsidiary computer systems to the general ledger utilizing computerized auditing tools to analyze large volumes of financial data
  • Student Health Services, The Ohio State University
    Fiscal Officer
    Student Health Services, The Ohio State University Feb 2010 - Mar 2011
    Columbus, Ohio Area
    --Prepared supporting documentation for journal entries made for SHS, an earnings unit of the university with a $16 million operating budget, to the general ledger and reviewed the resulting financial reporting for accuracy--Supervised internal controls on deposit tracking and billing to increase and maintain the accuracy of accounts receivable while instituting controls on physical inventories and other assets to safeguard university resources.--Conducted bimonthly budget meetings with the department managers from all seven functional areas of SHS to establish performance benchmarks and to help formulate and track departmental operating budgets--Designed custom metrics to track productivity as well as the profitability of specific projects and initiatives --Participated in interdepartmental workgroups studying the evolving role of the fiscal support center and the potential for increasing process efficiency while at the same time developing more robust internal controls methodologies--Documented all major SHS accounting processes in a 193 page procedure manual
  • Pizza At The Drake, The Ohio State University
    Student Manager
    Pizza At The Drake, The Ohio State University Nov 2005 - Aug 2009
    Columbus, Ohio Area
    --Supervised crews of 20+ workers at a university operated pizza shop on campus--Coordinated customer service to ensure utmost customer satisfaction--Conducted conflict mediation, hiring, training, and promoting activities

Aaron Mayer Skills

Accounting Internal Controls Access Sql Microsoft Excel Peoplesoft Microsoft Access Us Gaap Internal Audit Data Analysis Process Improvement Auditing Vba Hyperion Reports Report Writing Acl Coso Framework Risk Analysis Value Stream Mapping Visio

Frequently Asked Questions about Aaron Mayer

What company does Aaron Mayer work for?

Aaron Mayer works for Pwc

What is Aaron Mayer's role at the current company?

Aaron Mayer's current role is Senior Manager - Data Risk and Privacy - Information Governance and Privacy.

What is Aaron Mayer's email address?

Aaron Mayer's email address is ma****@****osu.edu

What is Aaron Mayer's direct phone number?

Aaron Mayer's direct phone number is +121274*****

What schools did Aaron Mayer attend?

Aaron Mayer attended The Ohio State University - The Max M. Fisher College Of Business, The Ohio State University - The Max M. Fisher College Of Business.

What are some of Aaron Mayer's interests?

Aaron Mayer has interest in Cooking, Vintage Lawn Furniture, Technology, Literature, Cinema.

What skills is Aaron Mayer known for?

Aaron Mayer has skills like Accounting, Internal Controls, Access, Sql, Microsoft Excel, Peoplesoft, Microsoft Access, Us Gaap, Internal Audit, Data Analysis, Process Improvement, Auditing.

Who are Aaron Mayer's colleagues?

Aaron Mayer's colleagues are John Nicholson, Varu Bartarya, Susanne Koch, Nikhil Sharma, かまちしげる, Ching Chuan Ong, Khaled Elhadad.

Not the Aaron Mayer you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.