• Consult with CEO and president.• Produce reports on company’s KPIs (number of calls handled, inventory turns, shipped not billed etc.)• Design and develop corporate reports including Gross Margin, Employee Metrics and Inventory Reordering using data from an SAP Business One system. • Provide quick turnaround ad hoc reporting to management. Reports range from revenue received from clients to plotting the distance between our customers and subcontractors. • Utilize MS SQL and Excel VBA to automate processes.• Customize SAP Business One using B1UP.• Change data in SAP Business One using DTW.• Serve as onsite Excel guru to support users company-wide.

• Property Facultative underwriting: Wrote a profitable book of mostly new business.• Spreadsheet development: Updated and improved pricing spreadsheets and clean-up tools using MS-Excel, VBA and SQL.• Designated departmental MS Excel expert in recognition of technical prowess.• Participated in cross-office planning meetings, including presentations of pricing spreadsheets.

• Oversaw installation of RMS software package over four server clusters with numerous virtual machines.• Acted as point of contact with external vendors and internal IT team.• Worked with systems department to fix issues caused by catastrophe models hogging network resources.

• Pricing tool development: Single-handedly designed and created automated modeling and pricing spreadsheets using MS-Excel and VBA. • Reinsurance underwriting: Managed all steps of the underwriting process including running analysis, recommending participation or declination, and preparing documentation.• Interviewed users and analyzed requirements to produce specifications. • Produced full user documentation.• Provided departmental support for MS-Office products.• Liaised with software vendor. Provided requirements and tested changes to the system.

• Produced and underwrote new and renewal treaty business. • Developed analysis tools in Excel and VBA.• Established relationships with clients that created business opportunities and raised market awareness. • Wrote the department’s first SQL queries, allowing underwriters to evaluate the quality of data provided. • Designed Liberty Mutual Re’s audit form for performing underwriting audits on clients’ portfolios.

Facultative Underwriter¬–Property Department July 1998–January 2000; October 2002–December 2006• Developed pricing spreadsheet in MS-Excel used throughout the company.• Underwrote predominantly US-domiciled original insureds covering worldwide locations. • Analyzed facultative risks for catastrophe exposures using RMS RiskLink and AIR Clasic/2.• Tasked with the analysis of the current state of the portfolio and its historical development. • Utilized catastrophe models to analyze the catastrophe exposure to the company on an annual basis and for individual events. • Produced reports for company management.Treaty Analyst January 2000–October 2002• Responsible for assessing wind and earthquake exposure and using that information for pricing purposes. Analyst Programmer September 1995–July 1998• Designed and wrote Electronic Data Interchange systems for claims and premium processing.