Thomas Butler

Project Manager @BeneSys, Inc.

Troy, MI, US

Analyze and define data sets from prior Third Party Administrators (TPA), then map data and provide ETL outline to programming team• Test SQL script outputs from Programming Team and identify inconsistencies between plan rules and actual operation – if inconsistencies are identified, provide direction on problem and solution• Conduct complete dataset comparisons via SQL, Excel, and other data tools for ETL validation - improved on prior spot checking standard• Supervise team of 3 analysts as Lead to work towards greater efficiency and accuracy in a unified fashion• Develop and maintain corporate dashboards via Tableau to monitor and improve individual and departmental performance and efficiency• Develop corporate standard templates for routine client mailings using mail merge fields to eliminate repetitive development time, dropped incidence of custom letter development from every client to 1 in 7 clients• Review client reports as produced by prior TPA and develop similar or better reports in proprietary BenefitDriven system• Study legal documentation from client Boards of Trustees (BOT) to understand plan rules and jointly design clarifying plan amendments with BOT where necessary• Create forms for inter-departmental communication in problem areas ensuring each team receives its necessary information; 1 such form eliminated 2 days’ development time• Coordinate automated SFTP transmission of enrollment files in EDI 834 format meeting HIPAA 5010 standards• Assist in the development of ACH and NACHA files and validate correct setup against specified file layouts, then coordinate delivery of these files via SFTP• Coordinate accurate and timely setup of employer websites for electronic collection of contribution reports and funds (via ACH)• Self-initiated bi-weekly meetings with management to set and monitor progress towards short-term and annual goals – this practice was later rolled out to entire department

Oakland University

Bachelor of Arts (BA), Major: Psychology, Minor: Spanish Language