Cole Hancock Email & Phone Number

Cedar Park, Tx, Us

Austin, Texas, United States

•Coordinated, developed, and implemented data analysis using standard statistical tools, methods, and techniques to determine payment rates and pricing for various agency programs.•Developed, implemented, and maintained rate methodologies and rate calculations.•Evaluated statistical methods and procedures used to obtain data to ensure validity, applicability, efficiency, and accuracy.•Wrote and executed SQL queries to retrieve claims data for use in fiscal estimates.•Employed SAS software in order to conduct statistical analysis on complicated external claims data in order to develop fiscal estimates and rate creation methodologies.

Austin, Texas, United States

Sunspot, New Mexico

• Oversaw Dunn National Solar Telescope operations and operated 5 highly technical instruments daily.• Troubleshot software and mechanical failures immediately to maintain production schedules.• Analyzed quarterly production statistics and suggested improvements to increase data production quotas.• Authored long-term & short-term schedules in accordance with client availability.• Analyzed quarterly production statistics and suggested improvements to increase data production quotas.• Regularly wrote scripts in a custom language to automate camera triggering to appropriate timing.• Consolidated & moved large datasets through CLI and used Excel for data tracking and complex optical calculations.• Maintained databases of production amounts, clients, and technology inventories using.• Regularly wrote scripts in a custom language to automate camera triggering to appropriate timing. • Performed routine system health checks and maintenance.

Sunspot, New Mexico, United States Of America

• Elected as a board member for the Sunspot Community Center Nonprofit.• Led the effort to renovate and refurbish abandoned facilities for organization and communal use.• Recorded minutes for board meetings while planning future events and fundraisers.• Establish effective schedules managing human resources efficiently.• Maintained constant communication on project requirements, progress, and reminders with everyone involved.• Planned new meetings and coordinated team schedules through effective digital communication.• Liaise with vendors and contractors to provide optimal service.

Hobart, In

• Repaired manufacturing equipment and employed root-cause analysis to prevent further failures.• Analyzed and troubleshot manufacturing equipment, software, and services to ensure reliability.• Cooperated with appropriate stakeholders to ensure that all products were developed to the proper specifications.• Diagnosed hardware, software, and electrical problems to discover underlying issues.• Documented consistent hardware failure and suggested improvements to manufacturing process to avoid risk.• Communicated technical solutions and instructions over phone, email, and verbally to coworkers.• Communicated with all steps of the manufacturing process in order to ensure correct production standards.

Valparaiso, Indiana

• Oversaw the operation of the Valparaiso University telescope nightly and led a team of 3 in its operation.• Converted raw data into a usable format through reduction and calibration techniques.• Performed statistical analysis using data warehouse programs, Microsoft Excel, and other custom software.• Utilized data repositories and trend analysis methodologies to explain physical phenomena.• Researched previously published analytical reports for better insights on data results and direction.• Authored advanced analytical reports with suggestions for future project pathways.• Presented complex data results to audiences of varying familiarity.• Wrote scripts to backup data and upload to a secure server.