FREDRICK STRAHAN
Cordova
Summary
Results-driven data professional with experience supporting evaluation and HR-related data systems, specializing in transforming complex datasets into actionable insights. Proficient in Power BI, Python, and data reporting, with a strong ability to build interactive dashboards, automate workflows, and ensure data accuracy and integrity. Adept at collaborating with cross-functional teams, including Human Resources and teacher licensure, to deliver timely, data-informed solutions. Passionate about leveraging data analytics to uncover meaningful trends, improve organizational decision making, and drive strategic outcomes.
Overview
4
4
years of professional experience
Work History
Advisor Employee Performance and Support
Memphis-Shelby County Schools
2024.09 - Current
- Develop and maintain interactive dashboards in Power BI to monitor evaluation metrics, enabling leadership to track performance trends and make data-driven decisions.
- Automate data processing and reporting workflows using Python, reducing manual data preparation time and improving data accuracy across evaluation datasets.
- Collaborate with Human Resources to support reporting needs, delivering ad hoc analyses and insights that inform compliance and certification tracking.
- Manage data validation, quality assurance, and permissions for sensitive personnel data, ensuring integrity, security and alignment with organizational policies.
- Design and manage structured datasets by integrating data from multiple sources, ensuring consistency with data standards and improving accessibility for cross-functional teams..
HR Data Specialist
Memphis Shelby County Schools
2023.08 - 2024.06
- Recommended upgrades that improved completion time of audit in response to yearly LEA compliance audits concerning over 7,000 teacher's license; Reduced time spent on Audit.
- Performed statistical analysis methods to understand past performances dealing with, number of new teachers, percentage of new teachers by school, and total number of permit teachers, to gain key insights.
- Maintained Relational Databases that optimized storage, retrieval and processing of evaluation, benefits, compensation and teacher licensure data.
- Utilized statistical tools, quality control techniques and data mining processes to properly identify and staff teachers within a separate database; Data is reported to the State Department.
- Performed data cleaning techniques with the use of Excel spreadsheets, and Python programming(Pandas, NumPy) that provided reliable, relevant, and accurate data to stakeholders.
- Gathered, cleaned, analyzed, interpreted, and reported teacher data in regard to the years of teaching experience from permit teachers, for school years 2023-2021.
- Monitored multiple KPI's to determine if schools are reaching their evaluation completion goals.
- Collaborated with the IT department to maintain and repair (when necessary) data export and import for PowerSchool.
- Created appropriate documentation that allows stakeholders (IT and Research department) to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary
- Created and maintained Standard Operating Procedures (SOPs) for various data projects and processes for performance management. Outlined data model for the compilation of all data reporting for the EPS team.
HR Licensure & Compliance Specialist
Memphis Shelby County Schools
2022.10 - 2023.08
- Worked with 170+ schools within the district to develop procedures for sustainable compliance rules and regulations
- Collaborated with administrators and teachers to ensure that teachers held the correct teaching endorsement, and taught the correct teaching subject.
- Identified over 400 plus teachers from the 2022-2023 school year, whose license was set to expire, to effectively communicate weekly messages via email, on ways to renew, reactivate, and advance their teaching license, in order for teachers to remain in compliance.
- Held weekly meetings for new hires to inform employees on the process of obtaining a teaching license, and staying in compliance with State rules.
- Studied past and current licensure data to understand trends on how many teachers converted from permits to a professional license, number of out-of-state educators, and the number of permit teachers; Accurately reported numbers within compliance audits.
- Maintained highly proactive working relations with departments within Human Resources to coordinate efforts to ensure candidates were successfully onboarded
HR Licensure & Compliance Associate
Memphis Shelby County Schools
2022.04 - 2022.10
- Communicated with 30+ candidates on a weekly basis to guide them in the process of obtaining an initial level Tennessee teaching license.
- Detected deficiencies in workflow process and proposed proactive adjustments resulting in reduced time spent on vetting qualified candidates.
- Managed large data sets within iCIMS Applicant Tracking System to ensure qualified candidates were vetted and processed by the staffing team to aid in filling vacancies for the district
- Researched and analyzed the State Department's website to accurately relay information to educators, qualified candidates, colleagues, and upper management.
- Worked within Excel spreadsheets to extract, transform, and load licensure information into HR's main database
- Responded to multiple questions via email, phone calls and weekly meetings regarding Educator licensure information
Education
BA - Business Administration
University of Memphis
Memphis, TN05.2020
Skills
- Data Validation
- KPI's
- Python Programming
- Metrics
- Microsoft Excel
- Python
- Power BI
- R Programming
- SQL
- Microsoft SQL Server
- Relational Databases
- RDBMS
- Descriptive Analysis
- Statistical Analysis
- Database Management Systems
- Story Telling
- Data Wrangling
Links
http://www.linkedin.com/in/fredrick-strahan-a4434b180
Timeline
Advisor Employee Performance and Support
Memphis-Shelby County Schools
2024.09 - Current
HR Data Specialist
Memphis Shelby County Schools
2023.08 - 2024.06
HR Licensure & Compliance Specialist
Memphis Shelby County Schools
2022.10 - 2023.08
HR Licensure & Compliance Associate
Memphis Shelby County Schools
2022.04 - 2022.10
BA - Business Administration
University of Memphis