John Mercer, Cpcu, Are Email & Phone Number

Greater Philadelphia Area

• JLT Re was acquired by Guy Carpenter on April 1st, 2019
• Gained in-depth knowledge of the P&C reinsurance/insurance industry and contributed company and industry insight for Guy Carpenter’s largest global clients
• Worked with brokers, clients, and prospects on topics related to risk-based capital (BCAR, RBC, S&P), financial modeling, solvency, ratings advisory, corporate structure and strategy, regulatory compliance, M&A.
• Monitored (re)insurance industry trends using SNL/S&P Market Intelligence, A.M. Best’s BestLink, Moody’s RiskCalc and CreditEdge, Bloomberg, Capital IQ, NAIC data, SEC filings, regular meetings with rating agencies.
• Built dynamic visualization using Power BI, utilized artificial intelligence & machine learning capabilities such as natural language processing and sentiment analysis to generate insight
• Took the lead on coordinating a global team to create qualitative and quantitative financial reports and build tools and analytics used in presentations, published research, and c-suite level meetings

Greater Philadelphia Area

Greater Philadelphia Area

JLT Re's Strategic Advisory team helps global clients manage risk and grow their franchise value. Clients can rely on the team for expertise in navigating the regulatory, rating, and risk-adjusted capital impact of changes in strategy, market expansion, M&A, and corporate structure.

Malvern, PA

• Designed and implemented new tools and process improvements using MS Access, SQL, and VBA, to identify payer trends and reduce claim submission issues
• Analyzed payer history throughout the claim submission process to identify trends and determine the root cause of late or missing payments

• Maintained and organized course activities and manage grades and feedback for 120+ students
• Held weekly sessions tutoring students with Microsoft Access and Excel.

Hong Kong

• Taught and created lesson plans for primary 4 to primary 6 students

• Planned, developed, and implemented research projects for expansion into new markets
• Analyzed customer data to identify market trends and potential opportunities

• Analyzed customer contracts, valued at approximately $150M, to develop forecasts and implement pricing strategies
• Used a variety of tools, including MS Access, Excel, and VBA macros, to compile and organize large databases in order to create simple and readable reports and action plans
• Created performance targets and developed tools to maintain the profitability of various projects and contracts
• Communicated daily with major customers, suppliers, and high level managers

• Managed 12 employees responsible for assembling and shipping customer orders
• Created new inventory management processes which cut work time by 50%+
• Improved efficiency by designing and implementing new floor layouts
• Served as a communication liaison between suppliers, customers, staffing agencies, and union representatives

Master Of Science (Ms), Economics

Courses: Applied Microeconometrics, Advanced Macroeconomics Analysis, Health Economics, Experimental Economics, Urban Policy and Planning.

Mcom, Transport Management & Economics

Bsba, Information Management & Analysis

Concentration: Supply Chain Management and Operations