Robert Hatfield Email & Phone Number

Nashville, Tn, Us

Los Angeles, Ca, Us

Los Angeles, Ca, Us

Develop back end data infrastructures to support the full array of software throughout the company. Designed, full ETL reporting systems to process TB of information daily to form end to end solutions for analytics and invoicing. Use technologies such as Python, Kafka, AWS, Jenkins, Spark, Airflow, Luigi, SQL, NoSQL to develop robust products that allow for the complete and unimpeded movement of data through the complete enterprise for internal and external customers. Well versed in Agile methodologies and environment.

Los Angeles, Ca, Us

Headed up and lead the Business Intelligence Department. Created and built from the ground up a complete reporting infrastructure for business analytics and client invoicing. Designed processes, procedures, and reporting to allow for insightful decisions based on accurate and complete data.Built a complete Business Intelligence Department from a one person team into a full robust department complete with automated procedures and technology to allow for consistent and democratized flow of information across the business.

Camarillo, Ca, Us

Designed and configured the data mapping and migration of claim and eligibility data from the IKA backup that was provided by the IT vendor to the Milliman MedInsight software through SQL queries and data validation.Designed and mapped the migration of MedInsight software through SQL queries to move data to the MediConnect Verisk Software.Developed and monitored the data validation of claims data working with various departments from claims to finance to make sure the data was consistent across all spectrums of the enterprise. Helped develop process and procedures for the IT department.

Woodland Hills, Ca, Us

Project Management for projects that consist of software ware upgrade/implementation, also managed projects of process/work-flow improvements for internal departments and enterprise wide. Developed processes and then lead the implementation for electronic delivery of data to government agencies to stay in compliance with new standards. Performed analysis and suggested solutions for improvement of existent processes to further the transition to a paperless environment enterprise wide. Data analysis of large data sets such as claims data, patient data, and demographic data. Summarized and presented the data to give analytical suggestions to department directors and executive management. Example developing a analysis and presentation of population mapping and visit volume to assist in the company goal of improved usage volume of services. Developed MS Access databases for multiple departments to improve data flow at an economical cost to the enterprise then acted as the database administrator for the created databases. Worked with IT on a continuous basis and became a liaison between IT and management for the definition and mapping of electronic data. Prepared complex reports ensuring full compliance with agency regulations and requirements.Designed and built a database repository for clinical, demographic, and eligibility data. The repository was used as a basis for multiple reports ranging from cost benefit analysis to utilization, and population studies. Query building and generation by using queries to manipulate and partition data for reporting purposes. For example used queries to find Medicare populations based upon their various diagnosis and then to analyze their utilization volumes for the company’s facilities and services.

Senior level support representative for clients and became a liaison for large and VIP accounts to allow them to have the most comprehensive support available. Performed as point person for conflict resolution for complaints from clients, by finding resolutions to difficult problems or work around processes to software bugs.Developed processes and presentations for the training of new employees. Developed procedures to for unusual issues and bugs within the software.Quality assurance of the software by working with the Q&A team in trouble shooting and resolving conflicts within the software. Became a go to point person for various subjects in the software and acted as the supervisor for the department when the management was not in house or available. Over saw up to 12 employees.