Matthew Spear Email and Phone Number

- Develop sql scripts for claim analytics using pl/sql devloper, sql server, and netezza. - Create automated ETL processes using Python and SSIS.- Bulid reporting packages in SSRS and Qlikview.

•SQL Developer and Project Management•Develop user interfaces for associates with new project implementations. •Support Coordination of Benefits, Subrogation, Mass Tort, and Pharmacy departments with their data and reporting needs. •Coordinate with teams across the country to ensure projects are on time and of the highest quality. •Lead new initiatives to ensure peak efficiency addressing department needs.

•Maintain relational databases consisting of client data.•Use Microsoft SQL Server and Microsoft Access to develop SQL queries and procedures to create investigations for the Research Analyst teams. •Oversee analyst team’s success across developed queries using linked Excel reports and created SQL reporting tables. •Create reports and spreadsheets ad hoc that meet the needs of upper management.•Moderate focus groups of research analysts for new query developments or improvements. •Participate in meetings with management of different departments to provide additional support and progress on existing issues.

•Investigate high dollar paid insurance claims to determine the payer position between insurance companies within the bounds of Medicare and state law. •On a regular basis contact large insurance companies, attorneys, and providers to explain who the primary payer among firms is for particular claims. •Accountable for having a complete understanding of Medicare and state statutes in regards to insurance primacy. •Participate in projects to analyze the probabilities of claim overpayments.•Train the department on new databases and dashboards used by the company •Create queries to help identify overpaid claims.

•Responsible for maintaining lost revenue due to delinquent loan accounts at or below specific company targets. •Examine the risk of each delinquent account to determine the prospect of absolution. •Contacted clients to assess their financial situation. Provided solutions within company guidelines and policies to assist in meeting their financial obligations to the company. Also counseled clients to better understand their own financial position.•Educate new employees on the company’s policies and in-house database systems.• Researched and applied state and federal laws to preserve the company’s integrity when dealing with clients, attorneys, and trustees. •Sell current products created by the company to help loan absolution.

•Served as a liaison for customers when situations developed that required senior management approval. •Doubled as a sales and customer service representative in order to provide superior service to bank cliental. Duties included opening new accounts, processing new consumer and mortgage loan applications, leasing deposit boxes and promoting other bank services. •Participated in training classes pertinent to the banking industry to gain knowledge and a better understanding of the services offered. Provided exceptional customer service to better assist the needs of the bank’s customers.•Served as a guide for new employees on the bank’s guidelines and systems.