Rebecca Fanning

Rebecca Fanning Email and Phone Number

Business Analyst and Service Manager - Reinsurance @ Sapiens
Hoffman Estates, IL, US
Rebecca Fanning's Location
Hoffman Estates, Illinois, United States, United States
Rebecca Fanning's Contact Details

Rebecca Fanning personal email

n/a
About Rebecca Fanning

rebeccafanning2016@gmail.com | Broadly experienced professional with a Masters degree in Applied Mathematics and distinguished achievement in mathematics and programming. Professional expertise in data analysis/mining/manipulation, actuarial/statistical analysis, business analysis for predictive modeling, and financial analysis, including experience with large data sets and relational databases. Exceptional analytical and problem-solving skills. Results-driven team player with proven record of understanding, solving, and explaining complex issues and processes. Passion for learning new concepts and techniques with ability to learn quickly. Strong accuracy, attention to detail, and thoroughness.

Rebecca Fanning's Current Company Details
Sapiens

Sapiens

View
Business Analyst and Service Manager - Reinsurance
Hoffman Estates, IL, US
Website:
sapiens.com
Employees:
5255
Rebecca Fanning Work Experience Details
  • Sapiens
    Business Analyst And Service Manager - Reinsurance
    Sapiens
    Hoffman Estates, Il, Us
  • Sapiens
    Business Analyst / Service Manager - Reinsurance
    Sapiens Feb 2020 - Present
    Holon, Israel, Il
  • U.S. Bank
    Data Reporting Analyst/Product Owner
    U.S. Bank Jan 2017 - Oct 2019
    Minneapolis, Mn, Us
    • Managed and expanded vital monthly business reviews and data maintenance for Collateralized Debt Obligation (CDO) and Escrow lines of business. The process included databases in SSMS and Access, multi-source data pulls into Excel via SQL and VBA, and automated Power Point updating.• Summarized collateralized loan obligation (CLO) monthly market news, highlighting what is most pertinent for the CDO group as a securitization trustee bank.• Managed on-going comprehensive competitive analyses for asset- and mortgage-backed securities used by the structured finance group as a key decision making tool for strategy and direction.• Built automated data collection process for quarterly Marketing Shufflrr refreshes.• Developed and maintained database of CLO market data on new deals, risk retention, and refinancings.• Built automated data retrieval and reporting tools for users.• Maintained M&A law firm referral database and KPI reporting for Escrow group.• Managed Corporate/Muni/Escrow and CDO line of business past due tickler reporting.• Maintained delinquent, critical tickler reporting across Corporate Trust which was relied upon by senior management.• Facilitated projects in an Agile environment for building Tableau dashboards.
  • Zurich Insurance Company Ltd
    Business Systems Analyst - Predictive Modeling
    Zurich Insurance Company Ltd 2014 - 2016
    Zurich, Zurich, Ch
    • Facilitated, created, and modified predictive modeling project artifacts, including business requirements for scoring engines, requirements for ETL transformations, and data requirements.• Performed and refined testing between statistical model expectations and results from replicated model calculations and logic in Excel and VBA.• Translated ETL requirements into IBM Rational Software Architect for several projects.• Co-led and enhanced data mapping efforts into Hadoop for multiple predictive analytics data sources.• Created detailed process documentation, trained several peers, and contributed to best practices protocols.• Worked in close liaison between data scientists and developers.
  • Zurich Insurance Company Ltd
    Senior Financial Analyst - Quantitative Analytics
    Zurich Insurance Company Ltd Jan 2010 - 2014
    Zurich, Zurich, Ch
    • Developed and automated sales funnel performance analysis against top tier competitors, which provided findings and detailed heat maps. Tools used include MS Access/VBA, Excel, and Business Objects.• Created a broad analysis of company-wide PEO and Temp Staffing business that included many KPIs, using data from pricing database and Business Objects Actuarial and Monthly Premium & Loss data marts.• Undertook a complex analysis of policy and premium retention in conjunction with analysis of new business quality, taking into account portfolio characteristics across policy origination years.• Expanded and automated monthly performance reports for gross written premium, actual price/technical price, rate, and retention. Tools used include MS Power Point and think-cell for data visualization.• Re-engineered Workers Comp reports, gaining a deeper understanding of rating and pricing tools.• Streamlined M&A Target Assessment Analysis used by corporate M&A group.
  • Quebecor World
    Pricing Analyst
    Quebecor World 2007 - 2009
    Montreal, Quebec, Ca
    • Established and streamlined a consistent pricing data collection process using Excel, MS Access and VBA, including Benchmark Assessment used for analysis of business viability.• Analyzed/modeled pricing data using Analysis of Variance, Linear and Logistic Regression in R and SAS.• Maintained pricing database by importing and manipulating data for use in reporting and analysis.• Created quarterly report packet detailing compliance and results, especially pricing levels to benchmark across various factors.
  • Aon
    Senior Financial Analyst - Risk Services
    Aon 2005 - 2007
    London, Gb
    • Reengineered and automated Time Tracking Utilization reporting using Microsoft Access, PeopleSoft Queries, and Field Systems for use by Managing Directors and Practice Group Leaders, including consultation regarding results. • Developed, monitored, and reported Aon Value Exchange Pricing Checklist Renewals and Accepted Revenue submissions for managers, Risk Consultants, and Service Management Team.
  • Aon
    Financial Reporting Accountant - Warranty Group
    Aon 2004 - 2005
    London, Gb
    • Researched and established analysis of reinsurance structures for credit insurance, specifically a surplus relief vehicle, which was then adopted by managers and auditors.• Improved process of general ledger balance sheet account reconciliations to comply with Sarbanes-Oxley, including research and resolution of long-term balance sheet discrepancies.• Discovered accounting errors in surplus relief vehicle based on its time structure, which made a difference between profit and loss.• Created quarterly capital expenditure report and contributed to quarter close, budget, and balance sheet/P&L variance analysis.
  • Cna Insurance
    Actuarial Analyst For Cna Reinsurance
    Cna Insurance 2002 - 2004
    Chicago, Illinois, Us
    • Developed models for reinsurance treaties with features such as retrocessions, sliding scale and profit commissions, loss corridors, and carry-forwards.• Allocated periodic aggregate IBNR/bulk reserves from underwriting and accident year levels to reinsurance treaty level for business lines using Microsoft Access Profit Model.• Prepared actuarial reports summarizing profitability of business units, including narrative summaries and financial results.• Collaborated with underwriters, claims personnel, and pricing actuaries to identify trends and issues impacting profitability.
  • Cna Insurance
    Accountant Ii For Cna Reinsurance
    Cna Insurance 1999 - 2002
    Chicago, Illinois, Us
    • Developed organizational grids with treaty structures and terms for several large clients.• Collaborated with accountants and brokers to resolve issues, such as accuracy and automation of premium/loss reporting and experience adjustments.• Processed and reconciled periodic activity and loss experience adjustments for Excess of Loss and Quota Share treaties, including treaty slip and contract analysis.
  • Stein Roe And Farnham, Inc.
    Compliance/Financial Reporting Accountant And Treasury Analyst
    Stein Roe And Farnham, Inc. 1997 - 1999
    • Developed and maintained fee and expense accrual rate analysis.• Improved process of maintaining expense ratios and caps (proportional and fixed dollar).• Performed SEC, tax, and prospectus compliance on funds.• Developed organizational grid for trust and master-feeder structure of funds and portfolios.• Prepared financial statements, board meeting materials, and dividend recommendations.• Coordinated/delegated/reviewed external audits and surveys from mutual fund data firms.
  • Ismie Mutual Insurance Company
    Staff Accountant – Investments/Reinsurance
    Ismie Mutual Insurance Company 1994 - 1997
    Chicago, Il, Us
    • Implemented, tested, and maintained interfacing investment portfolio software, Portfolio Dynamics, for use in portfolios with cash, stocks, bonds, overnight funds, and mortgage-backed securities.• Improved reinsurance recoverable reconciliations to general ledger and bordereaux.• Prepared schedules for annual/quarterly GAAP and statutory (P,F) statements.

Rebecca Fanning Skills

Finance Financial Analysis Financial Reporting Business Analysis Mathematical Statistics Insurance Analysis Property And Casualty Insurance Complex Analysis Learn New Software Quickly Collaborative Problem Solving Tenacious Work Ethic Teamwork Process Improvement Problem Solving Critical Thinking Accounting Analytical Skills Analytics Business Process Improvement Commercial Insurance Management Pricing Risk Management Underwriting

Rebecca Fanning Education Details

  • Depaul University
    Depaul University
    Applied Mathematics
  • Wisconsin School Of Business
    Wisconsin School Of Business
    Finance - Investments
  • University Of Wisconsin-Madison
    University Of Wisconsin-Madison
    General
  • Assumption High School - Wisconsin Rapids
    Assumption High School - Wisconsin Rapids

Frequently Asked Questions about Rebecca Fanning

What company does Rebecca Fanning work for?

Rebecca Fanning works for Sapiens

What is Rebecca Fanning's role at the current company?

Rebecca Fanning's current role is Business Analyst and Service Manager - Reinsurance.

What is Rebecca Fanning's email address?

Rebecca Fanning's email address is re****@****bal.net

What schools did Rebecca Fanning attend?

Rebecca Fanning attended Depaul University, Wisconsin School Of Business, University Of Wisconsin-Madison, Assumption High School - Wisconsin Rapids.

What are some of Rebecca Fanning's interests?

Rebecca Fanning has interest in Swarm Theory, Kaggle Competitions.

What skills is Rebecca Fanning known for?

Rebecca Fanning has skills like Finance, Financial Analysis, Financial Reporting, Business Analysis, Mathematical Statistics, Insurance, Analysis, Property And Casualty Insurance, Complex Analysis, Learn New Software Quickly, Collaborative Problem Solving, Tenacious Work Ethic.

Who are Rebecca Fanning's colleagues?

Rebecca Fanning's colleagues are Peter Lewis, Subrata Sabat, Archana K V, Maor Ben-Ami, Gutierrez Pedro, Kavitha S, Barry Macdougall.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.