Stephen Dragoni Email & Phone Number

New York City, NY, US

Warren, New Jersey, US

New York, New York, US

• 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.

• 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.

Hamilton, Bermuda, BM

• 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.