Financial Analyst II - Insurance FP&A
San Francisco Bay Area
Financial Analyst II - Insurance FP&A
San Francisco Bay Area
Advanced Microsoft Excel skills including Pivot Tables, Charts and graphs, complex formulas, and macros. Proficient with Microsoft Word, Powerpoint, Access. Oracle Financials, Peoplesoft Financials, Hyperion Pillar
(Insurance industry)
April 2004 — Present (5 years 8 months)
Insurance Services Analyst (September 2007 – Present)
In addition to previous duties, responsible for the other departments in Insurance Services including Underwriting and Actuarial. Entire budget for Insurance Services is approximately $600M a year.
• Responsible for educating Insurance Executives on expense management.
• Developed cost/benefit analysis for expansion/relocation options for Las Vegas Claims Call Center and Las Vegas Underwriting location.
Claims Budget Analyst (March 2004 – September 2007)
Responsible for monthly reporting, including Operating Expenses, Benefits Realization, and LAE Expense Analysis.
• Created and managed the $300M budget and forecast for the Claims Department.
• Developed benefits realization process for 2004 reorganization project (BPR) and report results on monthly, quarterly, year to date, and project to date time periods.
• Produce and deliver quarterly and monthly presentations on the fiscal results of the Claims Division.
(Insurance industry)
October 2002 — February 2004 (1 year 5 months)
As one of two Senior Analysts in the Logistics Division Finance department, responsible for monthly reporting, including reporting monthly financials compared to Budgets and Forecasts.
Responsible for monthly reporting of financials and units shipped as compared to forecasts and budgets for worldwide distribution centers and all brands of Gap Inc.
Responsible for monthly reporting of metrics for all global distribution centers and brands resulting in a monthly score for each and for the entire Logistics Division.
Assist in the half-year and annual budget process to create charts, graphs and slides for presentation to brand directors, Logistics Division VP, CFO, and CEO.
(Retail industry)
September 2002 — January 2004 (1 year 5 months)
As one of two Senior Analysts in the Logistics Division Finance department, responsible for monthly reporting, including reporting monthly financials compared to Budgets and Forecasts.
• Responsible for monthly reporting of actual units shipped and received by worldwide distribution centers.
• Responsible for monthly reporting of financials as compared to forecasts and budgets for all distribution centers and all brands of Gap Inc.
• Responsible for monthly reporting of metrics for all global distribution centers and brands resulting in a monthly score for each and for the entire Logistics Division.
• Assist in the half-year and annual budget process to create charts, graphs and slides for presentation to brand directors, Logistics Division VP, CFO, and CEO.
(Public Company; 501-1000 employees; IACI; Internet industry)
July 2002 — June 2003 (1 year )
As one of two analysts for the finance department, performed monthly variance analysis for Jeeves Solutions division of the company. Met with managers on a regular basis to assist with departmental business decisions.
Created various reports and models as requested by management, including a bonus restructuring model.
Created and updated competitive analysis model, which was distributed to upper management company-wide and provided an in-depth analysis of where the company stood financially in relation to other companies similar in business and size.
Continuously updated the Pillar budget files to ensure accurate forecasting and model during the quarterly review process.
(Insurance industry)
July 2001 — June 2002 (1 year )
As one of two analysts for the finance department, performed monthly variance analysis for Jeeves Solutions division of the company. Met with managers on a regular basis to assist with departmental business decisions.
Created various reports and models as requested by management, including a bonus restructuring model.
Created and updated competitive analysis model, which was distributed to upper management company-wide and provided an in-depth analysis of where the company stood financially in relation to other companies similar in business and size.
Continuously updated the Pillar budget files to ensure accurate forecasting and model during the quarterly review process.
(Internet industry)
April 1999 — March 2002 (3 years )
Promoted to Senior Revenue Analyst in June 2000. Was the business lead for integrating ZDNet Accounts Receivable system onto Oracle Financials.
Developed Global Naming Conventions, ensuring accuracy of customer database for merging the two companies, converting existing AR information from PeopleSoft Financials into Oracle Financials.
Managed the monthly close, ensuring timely delivery of revenue source information from outside departments.
Maintained and tested various enhancements to the Oracle AR system.
Billing Analyst (April 1999 to June 2000)
As a billing analyst, performed various billing functions including account reconciliations, invoice and credit memo creations.
Worked closely with the sales team to ensure accurate billing.
Received Q2 2000 CNET Achievement Award for contributions to the implementation of Oracle Financials, including developing invoicing standards and revenue recognition standards.
(Public Company; 10,001 or more employees; WSM; Retail industry)
1998 — 1999 (1 year )
As the financial Analyst for the Expense Payables Department, provided standard and ad hoc reports to the accounts payable manager.
Provided standard monthly reports on various aspects of the payables department, ranging from expense report violations to department productivity statistics.
Daily responsibilities included resolving past due invoices, auditing the accuracy of the accounting clerks and verifying transmission of positive pay data.
Integral in the P&L variance analysis performed at month end, including targeting large variances for review, accruing various expenses, providing explanations for large variances in the P&L statements, and ensuring accurate accounting for expenses items.
(Insurance industry)
April 1997 — August 1998 (1 year 5 months)
As the financial Analyst for the Expense Payables Department, provided standard and ad hoc reports to the accounts payable manager.
Provided standard monthly reports on various aspects of the payables department, ranging from expense report violations to department productivity statistics.
Daily responsibilities included resolving past due invoices, auditing the accuracy of the accounting clerks and verifying transmission of positive pay data.
Integral in the P&L variance analysis performed at month end, including targeting large variances for review, accruing various expenses, providing explanations for large variances in the P&L statements, and ensuring accurate accounting for expenses items.
(Educational Institution; 10,001 or more employees; Higher Education industry)
August 1995 — April 1997 (1 year 9 months)
Certificate In Finance , Corporate Finance , 2002 — 2008
BA , Political Science , 1991 — 1995
Photography, Sports, Travel, Dogs