Work Experience
Assurance Intern September 2012 – March 2013
- Prepared lead schedules for year-end audit of 2012-2013 to scope all accounts and transactions with significant impact on American Water Work’s Balance Sheet and Income Statement
- Reconciled, verified in Aura system and consulted with senior staff if an account above materiality in the lead schedule was tested
- Performed substantive analytics and test of details over Account Receivable, Property Plan & Equipment, Revenue Summary, and Depreciation Expense of PECO
(Risk consulting firm providing services in investigations, due diligence, cyber-security and compliance)
Forensic Accounting Intern September 2011 – March 2012
- Summarized and documented corresponding evidence; reported to senior with pertinent information
- Scheduled out bank statements; utilized Pivot Table and Excel to help flag suspicious transactions in fraud case
- Conducted a preliminary research for a prospective case through Edgar and Factiva; compiled findings and reported to manager
IT Compliance Intern October 2010 – March 2011
- Performed execution of SOX controls and testing in following areas: Logical Access, Change Management, Segregation of Duties, Application Development and Information Security
- Utilized advanced Excel skills to query and analyze information for data validation across multiple databases including PeopleSoft and Active Directory.
- Performed privileged access reviews on quarterly basis, in conjunction with senior management to validate access appropriateness
- Created process flow diagrams in Visio of various IT applications and mapped SOX controls to determine potential gaps in internal control
- Facilitated meetings with application owners to identify control gaps and document control environment
- Collaborated with IT units and Internal Audit to verify and validate audit findings and deficiencies