WILLIAM HERNANDEZ
Concord,California
Summary
Dynamic R&D Finance Manager with a proven track record at PROTAGONISTS THERAPEUTICS INC., excelling in Clinical Trials Financial Modeling and Business Process Improvement. Achieved a 3-day reduction in close timelines through innovative accrual processes. Adept at variance analysis and fostering collaborative relationships to drive strategic financial decisions.
Overview
19
19
years of professional experience
Work History
R&D Finance Manager
PROTAGONISTS THERAPEUTICS INC.
04.2021 - Current
- Strategic partner to Chief Medical Officer and Clinical Operations Team to manage multi-year budget of approximately $200M across Phase 1, 2, and Phase 3 studies.
- Audit POs, invoices vendor management, variance analysis and report risks and opportunities to portfolio.
- Assist PM with contract negotiations and project financial analysis.
- Responsible for the Clinical Operations organization financial cycle which includes Budgeting, forecast, Month-end close accruals and variance analysis.
- Manage Financial oversight of CROs, Central Labs, Sample Analysis vendors for Phase 1-3 Clinical Trials.
- Redesigned and developed accrual process using Power Query for the accounting team, which resulted in reducing close processes timelines by 3 days while increasing accuracy of accrual calculations.
- Provide analytical support to the clinical operations team on contract negotiations enabling team to make data driven decisions and mitigate financial risks.
- Provide detailed financial analysis to empower Clinical Operations Organization and finance team to strategically manage risks and opportunities.
Finance Manager (Contract)
THE CLOROX COMPANY
01.2019 - 06.2020
- Led and helped innovate IT Financial Capitalization process improvements, documentation, and data analysis to drive efficiencies of daily operations.
- Support cost center(s) and project delivery with in-depth examination of budgeting, forecasting, accruals, general ledger activity (close), and contract terms, for both OPEX and CAPEX.
- Subject Matter Expert in financial implementation (capitalization) of SAAS solutions for enterprise-wide level projects with strong focus on SOX compliance and approval of work-breakdown structure.
- Continually improve FASB Software capitalization guidelines and interpretation for IT projects.
- Assist IT budget owners with analysis of expense forecast to identify cost savings to reach 2020 strategy.
Finance Manager
Genentech Inc.
10.2016 - 12.2018
- Designed, developed, and implemented reporting tools for the Real-World Evidence team with dynamic and insightful Excel Dashboards, leading to new development of the Medical Affairs’ reporting.
- Supported financial planning, month-end close and reporting activities for several designated groups including both short-term (budgeting and forecasting) and long-term planning.
- Regularly engaged with stakeholders to review status of spend compared to budget/forecasts.
- Managed month-end close activities through review of expense accruals/prepays, prepared journal entries for accruals for clinical studies, recodes and account reconciliations.
- Managed clinical studies accrual process from beginning to end.
- Prepared monthly financials and variance analysis, comparing actuals to latest forecast, and provided insight into remaining forecasted spend.
- Ensured contract policies and processes were followed in a timely and compliant manner, focused on the review of vendor agreements and statement protocols.
- Oversaw relevant systems, tools, techniques, databases, and data sets.
Senior Financial Analyst
GAP INC.
02.2011 - 05.2016
- Analyzed project portfolio and worked with Project managers to understand forecast and close variances.
- Performed Forecast and close activities for over 48 IT projects within Store, Corporate, and Supply Chain Organizations.
- Pioneered the development of monthly and quarterly financial reporting for over 200 domestic and International IT Projects.
- Reviewed maintenance contracts and created a maintenance contract database for visibility of business units’ prepaid balances and costs.
- Developed comprehensive knowledge on capitalization policy and procedures, adhering to the SOP 98-1 guidelines.
- Designed a financial model for IT assets enabling accurate visibility to the financial impact of our depreciation schedule.
- Developed dynamic financial model to provide IT Leaders with a project prioritization tool based on relevance and budget.
- Influenced Business Partners to utilize new reporting tools to form a comprehensive knowledge of their forecast.
Senior Financial Analyst
CISCO SYSTEMS
11.2009 - 02.2011
- Implemented financial models for Global Sales teams.
- Built financial Dashboards to measure product family performance and bookings status.
- Supported to worldwide channels Data Center Team on strategic programs and promotions.
- Developed reporting tools for consistency and efficiency for company’s $2 billion worldwide Contract Revenue portfolio.
- Prepared month-end accruals and Contract Revenue adjustments.
- Identified savings in the Value Incentive Program to fund Data Center Promotions.
- Developed changes to improve reporting packages workflow.
- Reviewed, audited, and tested reporting data accuracy and technical performance to ensuring optimal functionality.
- Created dynamic dashboards and metrics reports on Partner programs for senior level sales teams worldwide.
- Developed VBA macros to automate Pivot tables’ connectivity changes to its respective MS Access query to ensure reporting confidentiality.
- Developed and distributed partner rebates reporting packages and timely rebate payments for partners worldwide.
Senior Financial Analyst, Contract
GAP INC.
03.2008 - 09.2009
- Collaborated with Senior Director, Project Manager and Team Leads on monthly and annual labor forecasts.
- Prepared, reviewed, and distributed actual-to-forecast results to senior management and team leads.
- Reconcile month-end actualized labor reports to financial system and documented variances.
- Reviewed first iteration of forecast to ensure Capital and Non-capital labor is properly captured.
- Update approve-spend tracking report to calculate project labor and contingency budget.
- Audited third-party Timecard, Invoice and Accrual reports.
- Maintained contractors SOW tracking reports ensuring projected accounting dollars.
- Prepared monthly POs in Oracle Financials with validated labor hours.
Financial Analyst, Contract
SALESFORCE
09.2006 - 03.2008
- Reviewed, improved, and implemented operational processes for Alliances’ domestic and international business partners.
- Prepared travel & entertainment trend analysis, actual vs. forecast reports for department managers.
- Created department’s forecast revenue, budget and variance analysis models using Pivot tables, macros, and conditional sum formulas.
- Created Salesforce.com application reports to gain visibility on current pipeline and closed deals.
- Managed Revenue Share Master Database to calculate accruals and payments for partners worldwide.
- Reviewed contract agreements to calculate revenue share payments for domestic and International partners.
Education
Master of Science - Finance
Golden Gate University
01.2005
Bachelor of Arts - Finance
Golden Gate University
01.2001
Skills
- Clinical Trials Financial Modeling & Reporting
- Site Financial Management
- Business Process Improvement
- Variance Analysis
- Forecasting & Planning
- Software Capitalization
- Auditing
- Accounting
- Budgets
- Business Analytics
- Business Object
- Oracle Financials
- SAP
- Essbase
- Hyperion
- Excel VBA & Power Query
Timeline
R&D Finance Manager
PROTAGONISTS THERAPEUTICS INC.
04.2021 - Current
Finance Manager (Contract)
THE CLOROX COMPANY
01.2019 - 06.2020
Finance Manager
Genentech Inc.
10.2016 - 12.2018
Senior Financial Analyst
GAP INC.
02.2011 - 05.2016
Senior Financial Analyst
CISCO SYSTEMS
11.2009 - 02.2011
Senior Financial Analyst, Contract
GAP INC.
03.2008 - 09.2009
Financial Analyst, Contract
SALESFORCE
09.2006 - 03.2008
Master of Science - Finance
Golden Gate University
Bachelor of Arts - Finance
Golden Gate University
Similar Profiles
Anthony J. Varano, Jr.Anthony J. Varano, Jr.
Co-Founder, CEO & Investor at Cervello Therapeutics & Resero TherapeuticsCo-Founder, CEO & Investor at Cervello Therapeutics & Resero Therapeutics
Jennifer ClaytonJennifer Clayton
Vice President - Sales/Marketing/HR at Transdermal Therapeutics, Inc.Vice President - Sales/Marketing/HR at Transdermal Therapeutics, Inc.
ANA JAPARIDZEANA JAPARIDZE
HR Manager at Ariceum Therapeutics GmbHHR Manager at Ariceum Therapeutics GmbH
Brittany PyleBrittany Pyle
Police Officer at Oakland Police DepartmentPolice Officer at Oakland Police Department
Steve JuniphantSteve Juniphant
Estimatics Team Manager at State Farm Insurance CompanyEstimatics Team Manager at State Farm Insurance Company