Ben Hamm Email & Phone Number

Austin, Tx, Us

Austin, Texas Area

Austin, Texas Area

Austin, Texas Area

● Developed and coordinated master data management program focusing on new claim payer data warehouse (HealthRules). ● Met with over 20 users and trained them on new enterprise data warehouse and desired business rules. ● Lead 5-member data architecture team to create new enterprise data warehouse from HealthRules claim system. ● Created flattened views of data for easier data consumption from business power users. ● Added controls to ETL processes leading to new overall architecture for ETL within department to keep record counts within transformation steps to ensure data quality from start to end. ● Lead and assisted reporting team on new HealthRules data, discussing best practices to follow and implementing release management. ● Train team on business needs and better understanding business role ensuring trust and utilization by business users.

Austin, Texas Area

● Collaborated with data warehouse team to define use of business rules to increase quality and query performance while eliminating hard coded values. ● Discussed data needs with business users to ensure report is current with business operations and prioritizing open request. ● Implemented release management process ensuring reports coming from department have been reviewed and signed off on how it was built, resulting in exceptional quality and positive cross-training tool for team members in all areas of the business. ● Configured and implemented Service-Now ITIL ticketing system for all IT, used enterprise wide as workflow/ticketing system. ● Created Service Catalog for ITS departments defining what tasks require changes and/or releases. ● Configured SLA's in system to help track turnaround times, and built controls using javascript Service-Now widgets.

● Trained 5 new employees on department standards and data warehouse use. ● Designed .NET applications to track claim work flow and open pends. Developed all layers of application, data layer through presentation layer, resulting in claim staff streamlining work flow allowing management to get real time status updates on outstanding pends and staff workload. ● Assisted business users on ad-hoc analysis/reports, including helping define needed business rules and specific criteria business needs satisfaction. ● Automated standard/routine reports running from MS Access. ● Used SQL Server and VBA to automate report output, formatting. and distribution notifications. ● Created audits checking for routine reports that show they have not run when scheduled.

Bba, Business: Mis

Activities and Societies: Bowling Team

Education record