Christopher B Johnson Email & Phone Number

Chicago, Il, Us

Amsterdam, Noord Holland, Nl

Created and maintained a large number of SSIS packages, SQL Server stored procedures, and Qlikview reports to assist the MidOffice team with daily operational tasks, including fees, invoice reconciliation, and P&L calculation.Created several python ETLs to transfer data between SQL Server, Hadoop, and/or internal REST APIs running on Java applications. Added Flask based web GUIs to some python processes for monitoring and user interaction.Contributed to back end and front end internal Java application development related to P&L calculation.Over time, I have transitioned more and more from writing SQL server ETLs and Qlikview reports to creating Python applications and writing Java for our internal applications.

Chicago, Illinois, Us

Managed and trained a team of analysts to match carrier commission statements with our submission records at GoHealth, to ensure we were paid for all policies we submitted Developed a script with R to automate a very large portion of our commission matching efforts using fuzzy name matching and other algorithmsWorked with a consulting firm and communicated internally with executive management to design and test MySQL data product to further automate our processCreated and edited SQL queries for internal and external reportsCreated an efficient process to maximize the number of submissions my team could reconcileOutreached to carriers to reconcile remaining submissions that were missing from statements, and retrieve payment on unpaid policies

Schaumburg, Illinois, Us

Responsible for communicating issues and progress on change requests to the client, as well as coordinating with other departments to ensure timely and accurate project completion. Ran standard reports and created custom reports for both my assigned client and internal coworkers using a variety of software including SQL, Microsoft Excel, Microsoft Access, and IBM Cognos.Expertise in finding and solving problems using data analysis. Worked with executive management and the client to create a complex report that reduced the monetary impact we owed the client for an issue by millions of dollars, with very thorough logging and documented rationale. Used SQL to find many global issues that impacted every client, as well as provide suggestions to management in other departments to solve the issues. Worked with multiple departments to improve monthly formulary change process to increase accuracy and efficiency as well as reduce costs. Received Everyday Hero award for coordinating a team of people to complete extra work in a short time frame to ensure government compliance. Received another award for exemplary training of coworkers on the SQL query tool Showcase.

Schaumburg, Illinois, Us

Worked with Microsoft Excel and a program called RxClaim that is used to process insurance claims. Checked that RxClaim was functioning correctly and ensured Medicare Part D members received letters regarding their medications when necessary. Fulfilled other data entry tasks, such as updating member Prior Authorizations and completing spreadsheets regarding formulary updates.

Bachelor Of Science (B.S.), Psychology

Master Of Science, Computer Science