Gurpreet Singh Email & Phone Number

Greater Chicago Area

• Planning, development, analysis and implementation of procedures and processes to ensure accurate healthcare claims and enrollment data are submitted as part of Risk Adjustment Data Validation (RADV)• Advanced Teradata coding, Visual Basic, excel skills used for full project/software development cycle• Designed a company initiative named Quality Improvement Strategy Project for Enterprise Pharmacy that identifies population health concerns and provides data for pharmacy outreach• Design, develop, test, tune SAS database code and perform statistical analysis to optimize business processes• Automated the patient lab data collection process to create SQL tables and query the results for management review

Chicago, Illinois

• Gained actuarial pricing skills by building raters for Life Sciences Group based on actuarial methodology• Key contributor in the creation and automation of profitability analysis for the organization apart from estimating the impact of various rate or algorithm changes on the book of business.• Organized large data sets using SQL code which allowed introduction of visual analytics through Tableau and thus helped the senior leadership across diverse MGU’s by delivering desired matrices

Northbrook, Il

 Built Report Year Triangles in Tableau for key claims metrics after decoding FDW data, something that has been desired by the leadership for years. Develop new methods to merge different universes within Business Objects to capture desired data and lead training sessions on Business Objects and Business Solutions with various departments across the organization Contributed to the Continuous Improvement project by working with an outside consulting firm to increase productivity in field based employees Developed various for a big company initiative and used SQL for validation of the data. Worked along with outside partners to ascertain accuracy of data and meet deadlines.Notable Achievements Recognized by senior leadership for solving a complex issue for the Casualty team. The project was attempted several times over 6 years without results. Quickly solved the issue by using data mining techniques to match data between two different data sources resulting in more comprehensive reporting detail for leadership. This solution has been deemed as a revolutionary achievement in changing the way business will be done at Allstate.

Northbrook, Il

 Lead analyst for major analytical initiatives within Subrogation CSA  Built and customized analytical solutions for critical problem areas in Subrogation Collaborated with team to build a strategy for improving customer experience score using data & text analytics. Supported regional CSA offices with analytical solutions that help foster efficiency in the work environment Notable Achievements Introduced predictive modeling techniques to the business area by using SAS software, compared Decision Tree and GLM for accuracy of the model. This introduction showcased the need for Triaging inputs for improved efficiency which resulted in increased revenue and quicker collections on subrogation claims.  Pioneered the use of Text Analytics to improve the arbitration statistics of Allstate versus the industry average. Text mined unstructured data using Attensity software and leveraged that with structured data for analysis that helped the CSA’s to focus on desired areas.

Schaumburg, Il

 Daily activities included calculating reserves for existing products, performing research studies, and statistical analysis Strong comprehension of the loss emergence process & the need for IBNR reserves, which has allowed learning common methodologies for projecting ultimate losses Extensive work on line of business reviews, ULAE and ALAE reserve calculations, Asbestos & Pollution reserving, and calculating anticipated Salvage & Subrogation. Collaborated with outside auditors and internal Zurich departments across the globe to examine and interpret data for accurate reporting  Actively performed quarterly close operations by using all major applications to secure, analyze, and report data Proficient in mainframe programming and ResQ accompanied by a strong knowledge in trouble shooting with Visual Basics

Ms, Risk Management And Actuarial Science

Master Of Science, Risk Management And Actuarial Science