Derrick Mueller Email & Phone Number

Seattle, WA, US

Seattle, Washington, United States

• Working in Data Science – Finance, supported Revenue Analytics team with additional Data Resources and Skills
• Led Revenue Validation Initiatives, comparing commission level data to Book of Business data, finding data validation opportunities and collaborating with Data Engineering to resolve.
• Subject Matter Expert for Policy Level Data/ Book of Business in support of Revenue Analytics and Reporting
• Lead analyst on the Revenue Recognition and Reporting Project automating the ingestion and processing of carrier commission statements into the Data Lake. Developed a data pipeline and SQL logic to normalize data (10M.

Seattle, WA

• Managed a small team (1 Direct Report). Primarily responsible for preparing and analyzing monthly and quarterly management reports and key financial metrics.
• Spearheaded the creation of 2 monthly Excel reports (Monthly Management Packet and Executive Flash Report), which detailed company performance across several Key Performance Indicators.
• Support company’s reinsurance process. This includes reporting of reinsurance premiums and losses and providing data to support the reinsurance renewal process.
• Combining data from multiple sources, created a Loss Incurred Study, in which insured losses were reviewed and cut by several different attributes. Eventually turned into a “Top 20 Largest” Monthly report.

Seattle, WA

• Supported Safeco’s National Agency Management (NAM) department, providing sales directors with both monthly reporting and ad hoc insights/SQL work.
• Created an elasticity-adjusted forecast to accurately plan for year end results while taken into account future change in price, using Hyperion Essbase. Also accounted for different lines of business and their specific.
• Quickly created a national report based on a new fee program targeted at Motor Vehicle Reports. This involved both getting access to the data as well as gaining knowledge of the tables in a very short time frame..
• Pulled data from different sources (Data Warehouse using SQL and Salesforce) to create a holistic “Summary Packet” containing all pertinent information for all agents in a Territory Manager’s territory. Also created a.
• Ad hoc SQL and modeling work, usually with very tight timeframes.

Seattle, WA

• Responsible for the administration, reporting, and payment of Safeco’s $5M Discretionary Compensation program for independent agents.
• Wrote/Maintained main data query in SAS Enterprise Miner (later translated into SQL) that pulled all relevant production data for all independent agents nationwide.
• Developed models and dashboards in Excel to calculate and project end of year bonus payments for all participating agents, with upper management-facing reports.
• Created a calibration tool using Excel VBA to assist Safeco Territory Managers set up appropriately designed bonus programs. This enabled Territory and Region Managers to create better calibrated bonus programs to.

• Responsible for all pre-settlement reporting of claims applicable to Hartford's Reinsurance Treaties, with a concentration in Asbestos, Environmental, and Toxic Tort claims. Determined any potential reinsurance impact.
• Assisted in the implementation of a new reinsurance diary system, which encompassed all aspects of the business, from accounting to detection. Determined how the system could be used in the Pre-Settlement Reporting.
• Created a measurable statistic for reinsurance correspondence turnaround time. This involved taking a very large spreadsheet of records, and transforming it into a workable format.

• Contract Employee through Corestaff Services
• As a member of the Sales Efficiency and Support Team, tracked active employee numbers and maintained the effects of new hires and attrition.
• Created a database/spreadsheet for Market Segmentation Project, segmenting worldwide adspace customers by spending level and Ad Agency used, allowing for Account Executives to adjust their customer service level.

• Responsible for notifying reinsurers regarding applicable claims under Safeco's reinsurance treaties.
• Created and maintained a Reinsurance Database using Access. The database kept track of 3400 reported claims, and produced claim volume reports.
• Collaborated with other departments to put together the Underwriting Exhibit for the reinsurance broker for Safeco’s Property Catastrophe Treaty
• Created a Reinsurer listing using Microsoft Excel. The listing contained financial information for reinsurers, (such as financial ratings and surplus). Used the v-lookup function to create a report by individual company.

Mba, Finance

Bachelor Of Arts, Finance / Management Information Systems