SUMMARY OF QUALIFICATIONS

• 20+ years of experience as senior financial analyst for international banking, finance, and technology companies.
• Developed and managed systems for business performance analysis, risk management, regulatory reporting, budgeting, and financial accounting,
• Adept with data management and business intelligence (BI) reporting tools including Microsoft Office Excel and Access, PowerPoint, Power Query, VBA, SQL, and cloud apps. Designed and built data management systems and dashboards using interfaces with corporate legacy systems.

EMPLOYMENT HISTORY:

Confidential

Responsibilities:

• Option Trading for own account. Developed database model to interface with TD Ameritrade options trading platform. Actively traded defined risk options.
• Spanish Studies while living in San Miguel de Allende Mexico for three years. Now resident in San Francisco, California USA.
• Developed a revenue recognition model for cloud SaaS company. Model interfaces with Netsuite to forecast future revenues and for variance analysis with general ledger reports. Model is automated with menu - driven, user-friendly interface. Developed using Excel VBA, pivot tables, and user-defined functions.
• Worked with project team to implement accounting enhancements to legacy systems, and to satisfy regulatory reporting requirements.
• Designed and built an automated system to extract charge-off data and to interface with data warehouse.
• Wrote business requirements and systems design documents that complied with accounting and regulatory rule changes, and with CCAR and Basel III reporting requirements.

Confidential

Finance and Systems Consultant

Responsibilities:

• Designed and built reporting systems for bank assets, and to satisfy regulatory reporting requirements including SEC and Federal Reserve Reports. These systems provide:
• Completely automated processes for interfacing with back office systems. Eliminated manual procedures and multiple isolated spreadsheets.
• User friendly, menu driven reporting. The ability to “click down” from high level summary reports to lowest contract level to facilitate auditing and Sarbanes-Oxley 404 requirements.
• Solved a previously intractable problem of reporting and forecasting contingent contractual obligations with VISA merchants totaling $2 billion.
• Worked closely with managers and staff to resolve accounting, budgeting, and forecasting issues and to create practical system solutions. Wrote business requirements document and system specifications.
• Designed, built, and documented a fully automated MS Access system using VBA and SQL queries to consolidate independent contracts into an integrated menu driven reporting system.
• Using new system, provided portfolio measurement, FP&A reports, treasury (cash payment forecasts), and data extracts for ad hoc reporting including Dodd-Frank compliance.
• Gathers critical key financial information from 52 portfolio companies representing over $1 billion under management. Automates a formerly manually intensive data gathering process and calculates cash burn rate and runway.

Confidential

FP&A Manager

Responsibilities:

• Produced management accounting reports for Singapore based global logistics company with annual revenues of $1.5 billion. Served as interim controller during transition.
• Managed expenditures, made accounting entries, conducted monthly financial statement consolidation and closing, including interfaces with accounts receivable and payable, general ledger, and production systems.
• Managed the FP&A processes and supported systems needed to gather annual budgets and period forecasts. Explained variances and generated key performance indicator reports (KPIs).
• Worked with controller to define a system solution to manage a high volume of billing transactions. Using MS Access and Excel, designed, built, and implemented an accounts receivable management system with data interfaces to seven diverse client systems.
• Worked with CFO to design suite of financial reports for Board of Directors presentation. Created extract from the Oracle standard costing system for variance and performance analyses
• Managed the budgetary (FP&A) process for an IT division with annual operating and project expenses of $14 million and staff of 95 FTEs and contractors. Actual performance within 2% of annual budget for 3 years.
• Worked closely with unit managers to assemble annual budget proposals. Prepared monthly forecasts and FP&A reports for operating units and for more than 50 systems development projects. Created standardized Excel templates containing staff and project details to facilitate planning.
• Created analyses of performance and financial issues. Made formal presentations to managers at weekly staff meetings.

Confidential, San Francisco

Financial Analyst, Systems Developer, and Risk Manager

Responsibilities:

• Created financial analyses and reports for London UK financial business and for regulatory reporting including Basel requirements.
• Managed risk measurement unit. Created risk model for asset/liability management and for reporting treasury activities in all traded currencies.
• Created an automated customer activity system in the Milan, Italy branch. This allowed the branch to become a primary dealer in Italian government bonds and the most profitable in the European division.
• Designed, developed, and implemented a back office system for London derivatives portfolio. System provided management, treasury, and risk reports, and posted to general ledger.
• Designed, developed, and implemented a system to measure and track customer collateral balances for European multi-currency derivatives risk exposure.
• Served as project manager during global conversion of legacy back-office securities management system to new application software. Wrote business requirements documents (BRDs) and systems specifications. Designed extracts to data warehouse for all reporting purposes including financial accounting, regulatory reporting, and risk management. Performed user acceptance testing, wrote test scripts of securities trades and verified results.