Sr. Risk And Audit Consultant Resume
San Jose, CA
SUMMARY
- Project Management (PM) and/or Audit Engagement Management at several companies including Cisco, Arista, Tesla Motors (Manufacturing, Inventory, Suppliers), AMLLP, IBM, HP, LiveWorld, Wireless Online, DCAA (Defense Contract Audit Agency under DoD), Britton Lee (Physical Inventory and PI Instructions), Consulting assignments and Public Accounting firms.
- Received 4 Awards for Internal Controls Testing and Remediation (IBM), and developing Audit Leads (DCAA).
- 10+ years in Cost or Project Accounting: Construction, WBS (work breakdown structure), % of Completion, standard, process (including yields) and job or project costing, including Inventory, Reconciliations, Physical Inventories, Valuations and various Variance Analyses. Asset Management, long / short term, including Physical Inventories
- 15+ years in Financial Analysis; Budgeting, Forecasting (Revenue, Expenses, other), Planning (FP&A), Intercompany issues and International Consolidations; Accounting and SEC (External) Reporting under US GAAP and/or IFRS.
- 10+ years of Revenue Recognition: ASC 606 (New Rev Rec rules - seminars, prep), ASC 605-25, VSOE, TPE (3rd Party Evidence) or BESP (best estimate selling price); ASC 985-605, ASU 2009-13&14, (formerly SOP 97-2, SOP 81-1; EITF 09-3, EITF 08-1, EITF 00-21; SAB 104, SAB 101 and related pronouncements).
- 12+ years managing teams of up to 16 direct reports, including hiring and professional development. Skilled in negotiations, General Ledger and full cycle Lease accounting processes, including M&A (mergers & acquisitions), team and total quality management styles.
- 12+ years analyzing systems, internal controls, policies and procedures, and recommend (in written reports or audits) improvements for economy and efficiency, including Sarbanes Oxley 404 (from start to finish: risk assessment through remediation of gaps or issues) audits with PCAOB and other related guidance; Internal (COSO), IT (COBIT) or Operations Audits. Performed, assessed, made recommendations related to ISMS models such as ISO 27001, SSAE 16 (SOC1 - formerly SAS 70 Type II), and SOC2 (IT - AT101) Audits.
- 4 ERP selections or implementations, (Oracle Financials, NetSuite, and 2 other ERP systems), including selection, IT controls assessment and conversion. Participated in or Led SOX audits (including Flowcharts, Narratives, RCMs - risk control matrices, Gap Analyses, Remediation) of IT areas (including security, internal controls, applications, spreadsheets). Use of Pert Charts and Critical Paths for various projects or audits.
- 12+ years’ experience with Microsoft Office (advanced Excel, such as Pivot Tables, VLookUps, etc.; Word, PowerPoint, Visio…), Sharepoint, Client Portal (CCH product), Concur, Egnyte, Live Link, EDM (Electronic Data Management), Oracle (v.11i & v. 12) Financials, ADI & Discoverer, Wdesk/ Webfiling (took tutorials on their site), XBRL (took classes/ seminars), SFDC (salesforce.com), SAP, NetSuite, Adaptive Planning (Insights), WebEx and WebEx Connect, Cognos Impromptu (BI), Propel (HP product) Project Management Tracking S/W, Hyperion Essbase/ others, Accounting Research Manager (ARM-CCH), GQL (related to SQL), Planview, Coupa and some custom software.
TECHNICAL SKILLS
- Pivot Tables
- VLookUps
- Word
- PowerPoint
- Visio
- Sharepoint
- Client Portal (CCH product)
- Concur
- Egnyte
- Live Link
- EDM (Electronic Data Management)
- Oracle (v.11i & v. 12) Financials
- ADI & Discoverer
- Wdesk/ Webfiling (took tutorials on their site)
- XBRL (took classes/ seminars)
- SFDC (salesforce.com)
- SAP
- NetSuite
- Adaptive Planning (Insights)
- WebEx and WebEx Connect
- Cognos Impromptu (BI)
- Propel (HP product) Project Management Tracking S/W
- Hyperion Essbase/ others
- Accounting Research Manager (ARM-CCH)
- GQL (related to SQL)
- Planview
- Coupa and some custom software.
PROFESSIONAL EXPERIENCE
Sr. Risk and Audit Consultant
Confidential, San Jose, CA
Responsibilities:
- Internal Audit function augmentation, controls testing for various clients.
- Software conversion testing (for completeness, accuracy, etc.) by major categories and accounts for both attribute and variable items primarily to determine accuracy and completeness of Financial Statements post conversion.
Revenue Analyst
Confidential, Foster City, CA
Responsibilities:
- Centrify: Analysis and support for 3 years of International (UK, Germany) Financial Statements related to statutory audit filings, using NetSuite, Adaptive Insights (Planning) and other software.
- Confidential: Assist with Analyses, Implementation and Upgrades for New Revenue Standard rules under ASC 606, using Oracle (Cloud), advanced Excel (Pivot tables, V-LookUps, etc.)
- Formally document new Revenue policies, assess impacts, document or revise related financial or banking institution processes, identify key revenue metrics, Review Contracts, contract verbiage, and SEC Reporting changes and centralize new documentation related to ASC 606, Revenue from Contracts with Customers
Sr. IT Internal Auditor
Confidential, CA
Responsibilities:
- IT Application Controls (ITAC - Cloud): Reviewing work papers, meetings with client, testing application controls (custom software, Documentum, SAP, etc.) for major auto manufacturer, for FYE 3/31/XX and similar activities. Use of advanced Excel.
- Supervise and mentor junior staff regarding ITAC, Internal Controls and related issues.
Project Forecasting & Business Analyst
Confidential, Santa Clara, CA
Responsibilities:
- Financial Analysis & Forecasting (expense, costs, revenue, other) for a major project, using historical and projected data.
- Participated in Budgeting and Forecasting for IT & other dept.’s, General Ledger accounting (Oracle - Cloud), and GDB (global digital bank).
- Assisted with Audit Support: SOX Audits and Processes, including Mergers & Acquisitions (M&A), Revenue Cycle and Process under ASC 606 (New Rev Rec rules), related Testing, RCM’s and Flowchart Updates, Cost Accounting & Variance Analyses; documentation or revision of related banking or financial institution processes
- Employed Planview, Oracle, advanced Excel, Hyperion and Coupa for Forecasting (FP&A) purposes.
Sr. Business Process Consultant
Confidential, San Jose, CA
Responsibilities:
- Management consulting regarding offerings to customers or stakeholders: improving Services available, such as Information Business Enablement, InfoSec (information security) GRC (global risk & compliance); desktop, technical, ERP (Oracle - Cloud, PeopleSoft) or other support services, and additional topics.
- Assisted client (Fannie Mae, VA area) with defining and/or transforming Information Security (InfoSec), Technical support and related services, including General Ledger and Lease accounting, Processes related to SOX, Mergers & Acquisitions (M&A), Internal Controls, various types of Audits and Audit Support, to clients and stakeholders.
- Teams operate virtually throughout the US. Extensive use of PowerPoint, also advanced Excel, Word, Google Apps, WebEx, Expensify, specialty software.
Sr. IT, Internal & SOX Auditor (PM)
Confidential, Santa Clara, CA
- IT Internal, SOX and External, SOC2 /SOC1 audits including (not limited to) ITGC’s, Change Management, Security, Computer Operations, Application Controls, Processing Integrity, General Ledger (Oracle, Hyperion, SAP, Cloud based s/w. others) and Lease accounting, and other IT areas for clients (Marvell, Yahoo, others).
- Recommended, as part of financial, internal and SOX audits, better processes, controls or Best Practices to clients for achieving goals in internal controls, technology or accounting.
- Employed Sharepoint, advanced Excel, eAudit, and other specialty software.
Sr. SOC
Confidential, San Jose, CA
Responsibilities:
- Preparation (including Narratives, RCM’s related to SOX processes and audits) for ISO 27001. SOC1 (SSAE16) and SOC2 Audits from Management's Perspective in the Governance, Risk & Compliance (GRC) areas.
- Participated in or led SSAE16 audits or SOC1 (on Service Organization Controls), and SOC 2 (AT101), Type 2 audits (Security, Availability, Processing Integrity, Privacy, and/or Confidentiality) - at Server farms or Data Centers, eg. -IT and Technical related, including, but not limited to, General Ledger (Oracle, Hyperion, others) and Lease accounting, Control Environment and Risk Assessment, Logical and Physical Access, Data Centers, Cloud Storage and Systems, Network Infrastructure, Application Development, Change Management, (of software, eg.) Computer Operations, Data Transmission, Data Backup and Recovery, Business Continuity, Secure Storage, Media and Document Destruction.
- SOC 1 audits were called SAS (Stmt. Of Auditing Standard) 70 Type 2 audits. Sharepoint, Excel, other software used.
SOX Analyst (PM)/-Internal Auditor
Confidential, Santa Clara, CA
Responsibilities:
- Revised, updated and, in some cases, re-wrote Narratives (Q2C, Rev Rec, SEC Reporting, Payroll, others), identifying Control Points and Control Activities to conduct Walk Throughs and be tested for client company’s (Vocera) annual SOX compliance. Oracle Cloud ERP, advanced Excel used.
- SOX Implementation team Project Management (Policies, Walk Throughs, Flowcharts (Visio), Risk Control Matrices, Gap Analyses, Narratives, Testing, Remediation for HR, Payroll, Procure to Pay, Design to Build (Inventory, Manufacturing, Cost Accounting, Standard Costs), Order to Cash (Revenue Cycle, Sales and Forecasting Process, Commissions…), ToD & ToE (Test of Design & Test of TEMPEffectiveness), Record to Report (including SEC Reporting, General, GL and Lease Accounting, Portfolio Mgt), Combinations or Mergers & Acquisitions (M&A), ITGC’s (IT General Controls), other areas) using Excel, Word, Visio. SFDC, Adaptive Planning (Insights) and NetSuite (Cloud) workflows and ERP re-implementation, including International Consolidations module, and as it relates to SOX Controls (IT Application Controls).
- SOX testing, analysis and recommendations of all cycles including Revenue (Revenue Recognition, Credit Analyses, Treasury Cycle including financial or banking institution processes, Accounts Receivable, Deferred Revenue, Warranty Reserves, etc.), Periodic Close, SEC Reporting, Inventory, BoM’s (Bills of Material), Accruals, Accounts Payable, Purchasing, and Financial Statements, and other areas. Recommended Process Improvements. Used Oracle-Cloud, Hyperion, Excel and other software.
Change Management PM
Confidential, San Jose, CA
Responsibilities:
- Change Management Finance for Cisco International: processes and process improvement (manual or automated), training & communications for Support the Business (STB) - Global Tax & Customs (GTC) department, mostly for emerging market, acquired Entities (M&A related), Brazil (CE - Country Enablement) and other countries.
- Project Team Management participation (Using Propel Project Mgt. S/W tool) included Brazil, ROW, BRIC (Brazil, Russia, India, China), BRCM & 26 Bridge countries, other Entities around the world that were being implemented or enabled through Cisco International (CI); Financial & Cost Analyses, Forecasting (Revenue, Costs, Expenses, other), Mergers & Acquisitions, Budget vs. Actuals (BvA’s), Variance and Ad Hoc Analyses.
- Use of Pert Charts and Critical Paths for various Projects. Took online training for Hyperion Essbase used in analyses; used Oracle v.11i and v. 12, Visio and Excel.
Financial Planning & Analysis Manager
Confidential, Santa Clara, CA
Responsibilities:
- Financial Planning and Analysis; SOX Implementation (including the Revenue cycle and Revenue Contracts, including Commissions, HR Cycles, IT General Controls), Internal Controls, Processes documentation and improvement.
- Designed Forecasts and Budgeting Process; worked with Sales Team and Budget owners on their respective Forecasts, Sales Metrics, Costs and Expenses, SFDC.
- Member of ERP (mid-tier - chose NetSuite -Cloud) Selection committee, including Needs Analyses, all Demos and Final selection.
- Prepared, Reviewed and/or Performed Deferred Revenue, Revenue Recognition, Cash / Treasury / Portfolio Mgt or Analyses, Warranties, Consolidations, Inventory Reconciliations, Standard Costs, Physical Inventory, Month-Quarter-Year End Close, SEC Reporting and Research, Treasury and Credit Risk activities including financial or banking processes, General Ledger and Lease Accounting, Financial Statement preparation; Financial Audit support, and other activities.