SOPHIA HSU, MBA

510-***-**** acvq76@r.postjobfree.com San Ramon, CA

Summary of Qualifications

Finance and Accounting professional with 15+ years experience in banking, high-tech, life science, social media, and retail industries offering expertise in the following areas:

Strong banking/financial service system analysis experience; General accounting, US GAAP, accounting policies and procedures, billing, revenue recognition, cost accounting, financial reporting and analysis, SEC/ bank regulatory filing and reporting, FP&A budget formation and forecasting, audit, global consolidation, foreign currency, General Ledger, Accounts Payable, Accounts Receivable, federal and state income taxes, treasury, cash management, fixed assets, payroll, Stock Based Compensation administration and accounting (ASC 718), allocation, multiple state sales and use tax, strong large ERP system skills, ERP conversion (R12, Netsuite), IFRS convergence, XBRL, Cross-functional collaboration.

Professional Experience

Consulting Projects:

Wells Fargo Bank March 2016 – May 2016

Sr. Consultant

Completing complex reporting requests. Analyzing amounts reported to explain significant variances in reported amounts. Evaluating proposed reporting changes and integrating the changes into reporting process. Working with the loan systems (Loan IQ) of record to ensure accurate GAAP and regulatory reporting. Reviewing data from the general ledger and loan systems to ensure accuracy and explain variances. Processing monthly GL close entries.

Completed Q1 FFIEC 009 CER report (Loan IQ at $92 billion). Completed Q1 RC-D, RC-D and SEC 1.50s schedules. Updated regulatory reporting compliance and desktop procedures.

Accela Inc. Aug. 2015 – Oct. 2015

Sr. Accounting Consultant San Ramon, CA

Two-year external audit PBC (book and tax) for multiple legal entities in preparation of planned IPO. Reconciliation of Trial Balance account balances and variance analysis between two ERP systems, i.e., MS Great Plains and NetSuite relating to migration to NetSuite.

Union B ank Jan. 2015 – July 2015

Sr. Regulatory Reporting Analyst San Francisco, CA

Preparation of regulatory reports - ensure the accurate and timely preparation and filing of various financial regulatory reports for the bank and holding company in compliance with all regulatory requirements, company policies and procedures, and generally accepted accounting principles, US Intermediate Holding Company (IHC) implementation and compliance project, RWA for Basel Advanced methodology, Basel II, TIC, BEA, Cayman reporting.

Recommend procedural changes / process improvement opportunities to streamline process, anticipate problems, enhance accuracy, completeness and timeliness of the reporting process. Met all due dates.

Direct experience with analysis of financial data such as loans, leases, credit cards.

Charles Schwab Corporation December 2014 – Jan. 2015

Sr. Regulatory Reporting Manager San Francisco, CA

Reports include annual, quarterly, monthly and weekly reports including the Call Report (FFIEC 030, 031, 041), FRY-9C, FRY-9LP, FR2900, FR2420, FR2052, Regulatory compliance requirements for CCAR, DFAST (Dodd-Frank Act Stress Test), Basel III and LCR; enhanced controls and developed streamlined reporting processes.

Maxim Integrated Inc. (Nasdaq: MXIM) March – August 2014

Sr. GL Manager San Jose, CA

SAP Data Warehouse experience. Oracle Business Intelligence experience. Month-end close, quarter-end close, Opex and B/S flux analysis, PBC preparation, external auditors support,

Interact with foreign subs and third party accounting services; international consolidation and intercompany reconciliation, IFRS statutory financial audit, ERP data dump analysis, Annual Report preparation

Interface with the International Shared Service Center (SSC) on month end close tasks

ERP migration (Oracle R12 to SAP), acquisition integration and cutover; Support Oracle R12 sub-ledgers (payables, receivables, cost management, cash management, General Ledger, Consolidation); WebADI templates, T&E on Concur and Wells Fargo, 2014 W9 and 1099 MISC preparation.

Bank of the West Sept. – Nov. 2013

Regulatory Reporting Analyst San Ramon, CA

Prepared regulatory reports for financial institutions, i.e., FDIC Call Report, Fed FRY9-C, and subsidiary schedules, in compliance with legal and regulatory requirements, company policies and procedures, and US GAAP. Oracle HFM, Smartview and Jack Henry e-filing.

Yelp, Inc. (NYSE: YELP) May – July 2013

Senior Revenue Consultant San Francisco, CA

Managed billing process for national brands advertising billing on Oracle R12.

Created and implemented controls around billing process deploying templates to automate and validate billing process. Devising and improving billing control process and related flowchart.

Reviewed all media I/O contracts for billing terms, owned and maintained searchable contract database, and assessed impacts of terms and conditions on revenue.

AP Pharma, Inc. (OTC:APPA) Nov. 2012 – May 2013

Interim Accounting Manager Redwood City, CA

SEC reporting, XBRL tagging, setting up budgets, establishing procedures, process improvements in full accounting cycle (GL, AP, Purchasing, FA, payroll, etc), managed month-end financial close.

Reviewed, approved and posted month-end journal entries, reviewed and approved account reconciliations. Prepared annual audit and tax PBC and lead schedules. Reviewed 10K/10Q workbook. Concur setup.

Property tax filing and audit preparation. Multiple state sales and use tax. Form 1099, Form 3922.

FriendFinder Network Inc. Nov. 2011 – July 2012

Finance Manager Sunnyvale, CA

Managed revenue recognition and accounting for this $350 million publicly traded internet social media company.

Reconciled and booked revenue from on-line subscription e-payments; calculated transactions fees and chargebacks from payment processors/banks and gateways. Revenue recognition SOX compliance.

Managed all cash accounts and related interbank transfers related to revenue and payouts processes

Various Consulting Projects: June 2010 – October 2011,

Nov. – Dec. 2014

Twitter, United Healthcare, Curexo Technology Corp, Ducati North America, Questcor Pharmaceutical, Modcloth

Supervised, mentored and developed a team of direct reports and managed the team to ensure work was properly allocated and completed in a timely and accurate manner.

Balance sheet and P&L accounts reconciliations (PP&E); Capital lease (FAS 13), FMV, IRR calculation and Asset Retirement Obligation, Flux analysis of PP&E accounts, Fixed Asset Roll-forward and reconciliation to GL. Oracle R12.

Performed cost accounting functions, preparing cost accounting journal vouchers including cost of sales, warranty provision, labor and overhead absorption; analyzed other cost of sales and set cost standards.

Met tight deadlines and managed GL, financial reporting, and support of budget and forecast activities. Developed and maintained key efficiency performance metrics for the department.

Directed monthly close process, ensuring all journal entries were reviewed and posted, balance sheet accounts were reconciled and fully analyzed and reported to management in a timely manner.

Prepared Multiple state sales and use tax filings. Managed payroll using ADP and reconciled with GL.

Created monthly management financial reporting package and executive summary schedules.

Managed customer billing and receivables reconciliation; created templates for data analysis & migration.

Served as the primary contact for general ledger details and related deliverables with external auditors PricewaterhouseCoopers for annual audit planning and PBC schedules.

Prepared schedules to support state and federal income tax returns, working with E&Y for tax provision.

Reviewed government and health organization contracts and transcribed data to templates.

Performed financial statement analysis and produced company budget and financial forecast for VC investors and BOD. Maintained capitalization table.

Administered stock option plan and expense recognition (Black Scholes) FAS123R, ADP PayXpert processing; managed 401(k), HSA and FSA plans.

EPSON RESEARCH & DEVELOPMENT, INC. 1997 – 2008

Accounting Manager (1997 – 2008) San Jose, CA

Hired as employee number two and reported to the Executive Vice President; later reported directly to the President; established and directed all finance, accounting, tax, and insurance operations for this $25 million dollar subsidiary with 120 employees in five states and a Canadian branch office.

Managed team of three direct reports including a Financial Analyst, GL Accountant, and Payroll Administrator. Indirectly managed two Accountants based in Canada. Provided professional development for team members including feedback, mentoring, coaching, and driving goal achievement.

Owned month-end close process and preparation of monthly consolidated US GAAP financial statements. Implemented and maintained accounting and general ledger system; assured accurate and timely delivery of account analysis and reconciliation including inter-company accounts.

Implemented ERP systems: Platinum for Windows, Hyperion Pillar, Hyperion Enterprise, and Fixed Asset system. Trained new and existing users and resolved questions and problems.

Provided quarterly forecasts and annual budgets, and analysis, proactively ensuring financial health of organization. Utilized advanced Excel functions including Vlookup, Pivot tables and function formulas to analyze and present financial information.

Partnered with PwC and Deloitte and Touche in preparing corporate income taxes for Federal and multiple states. Managed APA transfer pricing agreements and renewals. Worked with PwC on R&D tax credits.

Implemented and maintained Sarbanes Oxley (J-SOX) compliance.

Education

MBA Finance, Haas School of Business, University of California at Berkeley, CA

Training & Memberships

2013-2016 Institute of Management Accountants (IMA) continuous CPE training

2012: Oracle Financial Applications R12, Supply Chain; Oracle SQL, Oracle Financial Applications 11i (E-Business Suite

Computer Skills

Hyperion Financial Management, Oracle PeopleSoft, SAP R3, SAP Business Object, WebAmmo, Oracle R12, Oracle BI, Hyperion DRM, Discoverer 4.0, FFIEC regulatory reporting: Jack Henry, Axiom, FiRE; PL/SQL, Hyperion Enterprise, Hyperion Pillar, Hyperion Smartview, SharePoint, Toolbox

Microsoft Office 2013 (Word, excellent Excel Pivot and Vlookup, Smart Pivot, Access, PowerPoint, Outlook)

MS Great Plains, NetSuite, QAD, MAS 200, Platinum for Windows, Epicor ERP, QuickBooks Enterprise 11.0.

Contact this candidate