Paul Casella Email & Phone Number

Woodbury, Ny

Bethpage, Ny

• Reported monthly, quarterly, and annual financial and statistical auto insurance information to finance, actuarial, claims, state departments, and AIPSO to aid in business analysis and meet regulatory reporting requirements• Performed SAS programming (importing from Access databases) to query, clean, convert, merge, and summarize policy data• Wrote, edited, and ran SAS programs to calculate new statistical data not captured by the system … Show more • Reported monthly, quarterly, and annual financial and statistical auto insurance information to finance, actuarial, claims, state departments, and AIPSO to aid in business analysis and meet regulatory reporting requirements• Performed SAS programming (importing from Access databases) to query, clean, convert, merge, and summarize policy data• Wrote, edited, and ran SAS programs to calculate new statistical data not captured by the system (earned premium and exposures, loss ratios, frequency/severity, policies in force, claim counts)• Analyzed policy holder data using Excel and SAS to ensure accuracy and performed error corrections• Reported summaries of anomalies and inconsistencies found to management and statisticians• Studied AIPSO manuals to build and maintain Excel policy raters and data validation checks for CA, TX, NY, and small state business• Resolved Windows, e-mail, and Excel problems for my colleagues• Edited Crystal Reports forms, managed user access and password recovery, and printed checks• Explained program logic to auditors and assisted with ISO STAT reportingAd-hoc reports and projects included: • Analyzed technical requirements for daily NY DMV transaction reporting and incorporated them into a new SAS program with export to Excel and Text file to replace a paid 3rd party system• Analyzed underwriting department’s work flow as a member of the strategic management team and quantified labor productivity. Increased staff efficiency by eliminating several spreadsheets being kept that were a duplication of data entry. Instructed system programmer to incorporate new data entry screens into the database. Efforts helped reduce workforce and payroll costs• Improved claim count reporting accuracy by compiling 5 years of claims data and creating a new SAS database to calculate and track closed claims with/without payment and reopen claim dates Show less

Woodbury, Ny

• Investigated medical necessity of automobile personal injury claims and determined causality• Consulted with injured parties, secured medical information, monitored treatment, and paid bills• Answered phones in call center, took first loss reports from claimants, and set up claim files

Hauppauge, Ny

• Managed 3 product brands for New York territory of 300 stores and 3 distributors• Met with pet store owners daily, presented and demonstrated new products, wrote orders, and installed store displays• Processed damaged products and returns at distributor warehouse• Set up booths at trade shows, followed planograms, and promoted sales objectives

Hauppauge, Ny

• Created purchase orders, vouchers, and checked prices for 3000 SKUs• Created queries and exported data into Excel for reporting to executive management• Contacted overseas vendors regarding price discrepancies and shipment times• Managed international customer sales accounts and support• Met with international customers in office to present new products and discuss pricing• Calculated gross profit levels and created custom container order price lists for accounts•… Show more • Created purchase orders, vouchers, and checked prices for 3000 SKUs• Created queries and exported data into Excel for reporting to executive management• Contacted overseas vendors regarding price discrepancies and shipment times• Managed international customer sales accounts and support• Met with international customers in office to present new products and discuss pricing• Calculated gross profit levels and created custom container order price lists for accounts• Monitored warehouse orders and arranged container shipments• Initiated liquidation of dead stock by donating to animal shelters and creating ads on Craigslist• Filled in for the accounts receivable department processing payments Show less

Bachelor’S Degree, Business Computer Information Systems

Activities and Societies: hockey and softball intramurals Courses taken include: Java, C++, Database Design, SQL, Quantitative Methods.

Non-Degree Coursework, Operations Research - Linear Programming, Stochastic Processes, Graph Theory, Network Flows

Calculus Ii, Linear Algebra, Statistics