Isaac Robert Email & Phone Number

Chicago, Il, Us

Greater Chicago Area

- Run and create reports using SQL to analyze Medicare and Medicaid claims, expenses, and revenue- Perform detailed analysis on different benchmarks such as admits, out of network visits, length of stay, etc. and suggest ways to mitigate claims and increase revenue based on results from the analysis- Monitor different incentive and shared savings programs to ensure results are up to standards and data between entities lines up

Chicago, Il

- Worked on various client teams and the defined benefit and defined contribution retirement plans associated with those clients.- Ran valuation reports to ensure all retirement plans were fully funded in the present and future.- Tested the legality of retirement plans against rules and regulations created by the IRS by running “non-discrimination” testing.- Provided necessary certification of retirement plans required to maintain the status of a qualified plan.- Provided analysis and relevant documents for frozen and/or terminating retirement plans.- Proposed new retirement plan design scenarios and suggestions for incoming clients.- Headed the administration project work of a 13,000 participant annuity buyout from PPG Industries.- Suggested potential new annuity buyout clients based on data reports created using SQL.

Chicago, Il

- Worked with the Boeing consulting team to form monthly reports informing the Boeing management of results, trends, and actions to be taken regarding the various health programs and performance guarantees implemented for the Boeing membership.- Primary tasks involved work with mostly Microsoft Excel, Microsoft PowerPoint, and SQL coding, as well as weekly meetings to track the progress and results of our programs and performance guarantees.