Casey Wilmot

• Python

• SQL

• PowerShell

• HTML

• PHP

• DAX

• Troubleshooting and problem-solving

• Strong communication and customer service skills

• ETL development

• Scripting

• Automation: Task Scheduler, Power BI, Power Automate, SSIS

• Data visualization with Power BI

• SQL Server administration

• Server administration

• Version control with Github

• Flexibility and adaptability

FCR

2020 - Current

• Collaborated with management, clients, and stakeholders to provide tools for business decisions

• Developed Python scripts to collect and clean data from various REST APIs and store them in SQL Databases to improve operating efficiency

• Automated data processes using tools such as Python, Flow, and task scheduler to reduce time cost and increase data availability

• Maintained development server and SQL server to ensure confidentiality, integrity, and availability of databases

• Conducted troubleshooting on databases, Python scripts, SQL queries, and BI dashboards/analytics to implement changes

• Programmed Python ETL processes to automate reporting frequency from weekly occurrences down to hourly updates using APIs

• Developed and implemented robust data pipelines, using Microsoft gateways and automations for Power BI, to construct datasets, reports, and dashboards that improved data accessibility and informed decision-making across the organization. Additionally, played a key role in maintaining these data solutions to ensure data accuracy, reliability, and security.

• Administered Power BI, Windows Server, and SQL Server to manage all reporting functions, ensuring reliable data storage and effective report delivery.

• Provide technical support for our internal team members as well as external clients, ensuring timely and accurate delivery of reports to stakeholders.

Oklahoma Department of Human Services

2012-2017

• Conducted investigations and assessments on cases of child abuse and neglect, working closely with law enforcement and other agencies to ensure the safety of children.

• Managed a caseload of 8-13 families per week as a Child Welfare Worker, ensuring the safety and well-being of children while working with parents to address concerns and establish goals. 

• As a Supervisor, oversaw a team responsible for the safety of 45-55 families and approximately 60-90 children a week, providing guidance and support to ensure compliance with agency policies, best practices, and approving all final decisions on child safety.

• Managed and reveiwed case files, ensuring that all necessary documentation was accurate and up-to-date. I also maintained confidential records and communicated with clients, workers, and stakeholders regarding case updates.         

• Collaborated with interdisciplinary teams to develop case plans and identify resources for vulnerable families. I also attended court hearings and provided testimony as needed.

• Facilitated trainings for new employees and provided ongoing coaching and support to my 6 member team. I also conducted worker evaluations to highlight success and recommendations for growth.

• Utilized data analysis to monitor trends and outcomes, making recommendations for program improvements and identifying areas for additional support.