Patrick Rock Email & Phone Number

Omaha, Ne

I am a Business Intelligence Developer at Werner Enterprises, Inc where I use SQL to develop Tableau data sources, develop business intelligence solutions in Tableau and Microsoft Reporting Services, administer Tableau Server, develop workflow and ETL solutions in Alteryx, and program ETL and automation solutions in python. I develop advanced queries using SQL Server, DB2, and PostgreSQL.

Greater Omaha Area

Developed business intelligence reports for operations managers to determine performance of carriers and results of cost savings projects. Developed Analysis Services data warehouse cubes to facilitate self-service reporting.Developed Tableau dashboards for sales and operations managers and administered the Tableau Server dashboard host.Updated existing production reports to Microsoft Reporting Services.

Greater Omaha Area

Produced and analyzed medical expense reports for company leadership in order determine causes of changes in medical expenses and target medical expense savings initiatives.Produced and analyzed ad hoc financial reports for commercial group health insurance, Medicare, and Medicaid.Collaborated with IT department on behalf of the finance department on the Mutual of Omaha health insurance conversion by testing and validating data transfers and writing business requirements for reporting… Show more Produced and analyzed medical expense reports for company leadership in order determine causes of changes in medical expenses and target medical expense savings initiatives.Produced and analyzed ad hoc financial reports for commercial group health insurance, Medicare, and Medicaid.Collaborated with IT department on behalf of the finance department on the Mutual of Omaha health insurance conversion by testing and validating data transfers and writing business requirements for reporting purposes. Show less

Greater Omaha Area

Managed the commercial health insurance system offset process for the Accounts Receivable department.Improved the commercial health insurance system offset process by re-engineering and implementing Microsoft Access databases that automated the process and stored the claim information for reporting purposes.Collaborated with the Claims Research Team to re-engineer the system offset process workflow and data requirements.