Dylan Rozansky
Department Data Analyst at Michigan Department of Education- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SAS Enterprise Guide 1: Querying and Reporting
SASOct, 2022- Nov, 2024
Experience
-
Michigan Department of Education
-
United States
-
Government Administration
-
100 - 200 Employee
-
Department Data Analyst
-
Jul 2022 - Present
• Build and assess the readiness of 5 different grant applications through user testing within SIGMA, NexSys, and GEMS. • Organize 115+ alternative education waiver applications and 460+ grant applications into Excel spreadsheets to streamline the review process for department consultants. • Create queries in SAS to retrieve data requested by Educational Experience Unit staff for further analysis to build toward MDE’s mission and goals. • Facilitate the distribution of over $52… Show more • Build and assess the readiness of 5 different grant applications through user testing within SIGMA, NexSys, and GEMS. • Organize 115+ alternative education waiver applications and 460+ grant applications into Excel spreadsheets to streamline the review process for department consultants. • Create queries in SAS to retrieve data requested by Educational Experience Unit staff for further analysis to build toward MDE’s mission and goals. • Facilitate the distribution of over $52 million in grant funding moving from grant application systems to districts throughout the State of Michigan. • Analyze and prepare data into a presentable form within Excel through various formulas, pivot tables, and infographics for use by consultants and upper management. Show less • Build and assess the readiness of 5 different grant applications through user testing within SIGMA, NexSys, and GEMS. • Organize 115+ alternative education waiver applications and 460+ grant applications into Excel spreadsheets to streamline the review process for department consultants. • Create queries in SAS to retrieve data requested by Educational Experience Unit staff for further analysis to build toward MDE’s mission and goals. • Facilitate the distribution of over $52… Show more • Build and assess the readiness of 5 different grant applications through user testing within SIGMA, NexSys, and GEMS. • Organize 115+ alternative education waiver applications and 460+ grant applications into Excel spreadsheets to streamline the review process for department consultants. • Create queries in SAS to retrieve data requested by Educational Experience Unit staff for further analysis to build toward MDE’s mission and goals. • Facilitate the distribution of over $52 million in grant funding moving from grant application systems to districts throughout the State of Michigan. • Analyze and prepare data into a presentable form within Excel through various formulas, pivot tables, and infographics for use by consultants and upper management. Show less
-
-
-
Govern For America
-
United States
-
Civic and Social Organizations
-
1 - 100 Employee
-
Govern for America Fellow
-
Jun 2022 - Present
• Fellow within GFA, a national non-profit pairing young professionals with state government departments. • Participate in quarterly 3-day conferences with workshops that range from working with trauma-informed communities to analyzing data from an equity-based lens. • Fellow within GFA, a national non-profit pairing young professionals with state government departments. • Participate in quarterly 3-day conferences with workshops that range from working with trauma-informed communities to analyzing data from an equity-based lens.
-
-
-
First Ward Creative Arts Academy
-
Charlotte, North Carolina, United States
-
2nd Grade Teacher
-
Jun 2020 - Jun 2022
• Instruct classrooms with sixteen to twenty-five 2nd grade students in Math, Literacy, Science, and Social Studies • Work with students with reading and math skills ranging from entry level kindergarten to 3rd grade • Serve as Multi-Tiered Support System grade level liaison by progress monitoring students below grade level • Facilitate synchronous and asynchronous distance learning through development of online resources and library for Canvas and troubleshooting families’… Show more • Instruct classrooms with sixteen to twenty-five 2nd grade students in Math, Literacy, Science, and Social Studies • Work with students with reading and math skills ranging from entry level kindergarten to 3rd grade • Serve as Multi-Tiered Support System grade level liaison by progress monitoring students below grade level • Facilitate synchronous and asynchronous distance learning through development of online resources and library for Canvas and troubleshooting families’ technological issues for the duration of the 2020-2021 school year Show less • Instruct classrooms with sixteen to twenty-five 2nd grade students in Math, Literacy, Science, and Social Studies • Work with students with reading and math skills ranging from entry level kindergarten to 3rd grade • Serve as Multi-Tiered Support System grade level liaison by progress monitoring students below grade level • Facilitate synchronous and asynchronous distance learning through development of online resources and library for Canvas and troubleshooting families’… Show more • Instruct classrooms with sixteen to twenty-five 2nd grade students in Math, Literacy, Science, and Social Studies • Work with students with reading and math skills ranging from entry level kindergarten to 3rd grade • Serve as Multi-Tiered Support System grade level liaison by progress monitoring students below grade level • Facilitate synchronous and asynchronous distance learning through development of online resources and library for Canvas and troubleshooting families’ technological issues for the duration of the 2020-2021 school year Show less
-
-
-
Teach For America
-
United States
-
Education Administration Programs
-
700 & Above Employee
-
2020 Corps Member
-
May 2019 - Jun 2022
• Attended intensive 6 week program focusing on how to be a classroom learner, with focuses on delivering content to all learners, gathering and analyzing formative/summative data, social-emotional learning, and creating an equitable classroom • Received ongoing mentoring by TFA coach, who was a successful classroom instructor, on how to consistently improve and create equity within the classroom • Attended intensive 6 week program focusing on how to be a classroom learner, with focuses on delivering content to all learners, gathering and analyzing formative/summative data, social-emotional learning, and creating an equitable classroom • Received ongoing mentoring by TFA coach, who was a successful classroom instructor, on how to consistently improve and create equity within the classroom
-
-
-
Bluford-Peeler Elementary School
-
Greensboro, North Carolina, United States
-
Kindergarten Paraprofessional
-
Jan 2020 - Jun 2020
• Prepare daily materials for Kindergarten classroom of fifteen 5 to 6 year old students • Small group instruction; typically 1 to 5 students at a time, both in-person and through video call platforms • Substitute taught Kindergarten to 5th grade for 1 to 3 days, both planned and unplanned teacher absences • Develop skills in classroom management and socioemotional relationship building with students • Facilitate distance learning through development of online resources and resource… Show more • Prepare daily materials for Kindergarten classroom of fifteen 5 to 6 year old students • Small group instruction; typically 1 to 5 students at a time, both in-person and through video call platforms • Substitute taught Kindergarten to 5th grade for 1 to 3 days, both planned and unplanned teacher absences • Develop skills in classroom management and socioemotional relationship building with students • Facilitate distance learning through development of online resources and resource library and troubleshooting families’ technological issues Show less • Prepare daily materials for Kindergarten classroom of fifteen 5 to 6 year old students • Small group instruction; typically 1 to 5 students at a time, both in-person and through video call platforms • Substitute taught Kindergarten to 5th grade for 1 to 3 days, both planned and unplanned teacher absences • Develop skills in classroom management and socioemotional relationship building with students • Facilitate distance learning through development of online resources and resource… Show more • Prepare daily materials for Kindergarten classroom of fifteen 5 to 6 year old students • Small group instruction; typically 1 to 5 students at a time, both in-person and through video call platforms • Substitute taught Kindergarten to 5th grade for 1 to 3 days, both planned and unplanned teacher absences • Develop skills in classroom management and socioemotional relationship building with students • Facilitate distance learning through development of online resources and resource library and troubleshooting families’ technological issues Show less
-
-
-
Falkener Elementary School
-
Greensboro/Winston-Salem, North Carolina Area
-
Elementary School Teacher
-
Aug 2019 - Dec 2019
• Instructed a classroom of up to twenty-six 5th grade students in Math, English, and Science • Achieved 2nd highest percentage among 5th grade classes of students reaching personal targets on Interim Benchmark Assessment 1 • Collaborated with a team of five 5th grade teachers to create lessons in content areas that were engaging, challenging, and met all Common Core Standards, as well as all levels of learners’ needs • Instructed a classroom of up to twenty-six 5th grade students in Math, English, and Science • Achieved 2nd highest percentage among 5th grade classes of students reaching personal targets on Interim Benchmark Assessment 1 • Collaborated with a team of five 5th grade teachers to create lessons in content areas that were engaging, challenging, and met all Common Core Standards, as well as all levels of learners’ needs
-
-
-
University of Miami, Department of Geography and Regional Studies
-
Coral Gables, Florida, United States
-
Research Assistant
-
Jan 2019 - May 2019
• Constructed digital catchment area maps on ArcGIS around Primary Health Centers for Bauchi State, Nigeria to help new mothers and children under 1 year old receive vaccinations • Cleaned up previous data used by the Nigeria’s Vaccination Tracking System in Excel to import into ArcGIS with greater fidelity • Prepared presentation on Microsoft PowerPoint showing methodology, findings, and next steps • Constructed digital catchment area maps on ArcGIS around Primary Health Centers for Bauchi State, Nigeria to help new mothers and children under 1 year old receive vaccinations • Cleaned up previous data used by the Nigeria’s Vaccination Tracking System in Excel to import into ArcGIS with greater fidelity • Prepared presentation on Microsoft PowerPoint showing methodology, findings, and next steps
-
-
-
Herbert Wellness Center
-
Coral Gables, Florida
-
Facility Supervisor, Front Desk, Pro Shop and Operations
-
Aug 2015 - May 2019
*Promoted to Facility Supervisor in May 2018 - supervise 4-6 students every shift and ensure the facility is properly functioning while responding to guests concerns and inquiries, setting up for various events, and ensuring customers who are injured receive proper treatment *Assist guests in locker, sporting equipment, and towel checkout; handle monetary transactions for purchases of apparel and sporting equipment *Promoted to Facility Supervisor in May 2018 - supervise 4-6 students every shift and ensure the facility is properly functioning while responding to guests concerns and inquiries, setting up for various events, and ensuring customers who are injured receive proper treatment *Assist guests in locker, sporting equipment, and towel checkout; handle monetary transactions for purchases of apparel and sporting equipment
-
-
-
NOAA Oregon Sea Grant, Haystack Rock Awareness Program
-
Cannon Beach, Oregon
-
Summer Scholar
-
Jun 2018 - Aug 2018
*Conducted a month-long survey which received 136 responses focusing on human dimension research relating to the value and use of Haystack Rock to both those living in the region and tourists *Presented human dimension research at an Oregon State University symposium and poster session *Served as an interpreter and naturalist at Haystack Rock - indicating to visitors where the various marine birds nested and organisms living in the rocky internal environment *Held outreach event at the… Show more *Conducted a month-long survey which received 136 responses focusing on human dimension research relating to the value and use of Haystack Rock to both those living in the region and tourists *Presented human dimension research at an Oregon State University symposium and poster session *Served as an interpreter and naturalist at Haystack Rock - indicating to visitors where the various marine birds nested and organisms living in the rocky internal environment *Held outreach event at the Oregon Coast Aquarium demonstrating for visitors why micro plastics are such a hazard on local beaches Show less *Conducted a month-long survey which received 136 responses focusing on human dimension research relating to the value and use of Haystack Rock to both those living in the region and tourists *Presented human dimension research at an Oregon State University symposium and poster session *Served as an interpreter and naturalist at Haystack Rock - indicating to visitors where the various marine birds nested and organisms living in the rocky internal environment *Held outreach event at the… Show more *Conducted a month-long survey which received 136 responses focusing on human dimension research relating to the value and use of Haystack Rock to both those living in the region and tourists *Presented human dimension research at an Oregon State University symposium and poster session *Served as an interpreter and naturalist at Haystack Rock - indicating to visitors where the various marine birds nested and organisms living in the rocky internal environment *Held outreach event at the Oregon Coast Aquarium demonstrating for visitors why micro plastics are such a hazard on local beaches Show less
-
-
-
Miami-Dade County Sea Turtle Conservation Program
-
Miami-Dade County, Florida
-
Research Assistant
-
Sep 2017 - May 2018
*Conduct nighttime lighting surveys using a hand-held spectrophotometer in an effort to reduce the number of sea turtle disorientations in the municipalities of Miami Beach, Surfside, and Bal Harbour *Examine 20+ buildings (such as hotels and condominiums) in the three municipalities to determine light sources creating problems for sea turtles *Built a risk assessment on ArcGIS and WebGIS focused on where loggerhead nests should be relocated to reduce chance of hatchling… Show more *Conduct nighttime lighting surveys using a hand-held spectrophotometer in an effort to reduce the number of sea turtle disorientations in the municipalities of Miami Beach, Surfside, and Bal Harbour *Examine 20+ buildings (such as hotels and condominiums) in the three municipalities to determine light sources creating problems for sea turtles *Built a risk assessment on ArcGIS and WebGIS focused on where loggerhead nests should be relocated to reduce chance of hatchling disorientation *Prepare written recommendations for the buildings with harmful light sources based on the disorientation reports Show less *Conduct nighttime lighting surveys using a hand-held spectrophotometer in an effort to reduce the number of sea turtle disorientations in the municipalities of Miami Beach, Surfside, and Bal Harbour *Examine 20+ buildings (such as hotels and condominiums) in the three municipalities to determine light sources creating problems for sea turtles *Built a risk assessment on ArcGIS and WebGIS focused on where loggerhead nests should be relocated to reduce chance of hatchling… Show more *Conduct nighttime lighting surveys using a hand-held spectrophotometer in an effort to reduce the number of sea turtle disorientations in the municipalities of Miami Beach, Surfside, and Bal Harbour *Examine 20+ buildings (such as hotels and condominiums) in the three municipalities to determine light sources creating problems for sea turtles *Built a risk assessment on ArcGIS and WebGIS focused on where loggerhead nests should be relocated to reduce chance of hatchling disorientation *Prepare written recommendations for the buildings with harmful light sources based on the disorientation reports Show less
-
-
-
Denver School of Science and Technology
-
Denver, Colorado
-
Teacher and Homeroom Advisor
-
Jun 2017 - Jul 2017
*Created and implemented lesson plans and taught middle school math to 60 incoming 6th, 7th, and 9th graders in STEM summer school *Advised a group of fifteen 10-13 year-old students and their parents in transition to middle school by teaching and explaining the systems and procedures of the school *Attended leadership and teaching workshops as well as lectures on educational advocacy *Presented to 600 district teachers regarding methods for improving teaching style from an alumnus… Show more *Created and implemented lesson plans and taught middle school math to 60 incoming 6th, 7th, and 9th graders in STEM summer school *Advised a group of fifteen 10-13 year-old students and their parents in transition to middle school by teaching and explaining the systems and procedures of the school *Attended leadership and teaching workshops as well as lectures on educational advocacy *Presented to 600 district teachers regarding methods for improving teaching style from an alumnus point of view Show less *Created and implemented lesson plans and taught middle school math to 60 incoming 6th, 7th, and 9th graders in STEM summer school *Advised a group of fifteen 10-13 year-old students and their parents in transition to middle school by teaching and explaining the systems and procedures of the school *Attended leadership and teaching workshops as well as lectures on educational advocacy *Presented to 600 district teachers regarding methods for improving teaching style from an alumnus… Show more *Created and implemented lesson plans and taught middle school math to 60 incoming 6th, 7th, and 9th graders in STEM summer school *Advised a group of fifteen 10-13 year-old students and their parents in transition to middle school by teaching and explaining the systems and procedures of the school *Attended leadership and teaching workshops as well as lectures on educational advocacy *Presented to 600 district teachers regarding methods for improving teaching style from an alumnus point of view Show less
-
-
-
Equilibrio Azul
-
Puerto Lopez, Ecuador
-
Research Intern
-
Apr 2017 - May 2017
*Monitored different sea turtle nests, each nest containing 150+ eggs *Aided in the tracking of eight different day-old endangered sea turtles in an effort to understand the first few years of a sea turtle's life *Placed and checked camera traps to monitor which animals live in the dry forests of one of the less studied areas in Machaililla National Park *Documented lack of enforcement of Ecuadorian conservation laws by reporting 500+ sharks of different species illegally captured by… Show more *Monitored different sea turtle nests, each nest containing 150+ eggs *Aided in the tracking of eight different day-old endangered sea turtles in an effort to understand the first few years of a sea turtle's life *Placed and checked camera traps to monitor which animals live in the dry forests of one of the less studied areas in Machaililla National Park *Documented lack of enforcement of Ecuadorian conservation laws by reporting 500+ sharks of different species illegally captured by local fishermen Show less *Monitored different sea turtle nests, each nest containing 150+ eggs *Aided in the tracking of eight different day-old endangered sea turtles in an effort to understand the first few years of a sea turtle's life *Placed and checked camera traps to monitor which animals live in the dry forests of one of the less studied areas in Machaililla National Park *Documented lack of enforcement of Ecuadorian conservation laws by reporting 500+ sharks of different species illegally captured by… Show more *Monitored different sea turtle nests, each nest containing 150+ eggs *Aided in the tracking of eight different day-old endangered sea turtles in an effort to understand the first few years of a sea turtle's life *Placed and checked camera traps to monitor which animals live in the dry forests of one of the less studied areas in Machaililla National Park *Documented lack of enforcement of Ecuadorian conservation laws by reporting 500+ sharks of different species illegally captured by local fishermen Show less
-
-
-
University of Miami Rosenstiel School of Marine and Atmospheric Science
-
Coral Gables, Florida
-
Research Assistant for PhD candidate
-
Aug 2016 - Dec 2016
*Compiled academic research to present to NOAA as suggestions in their latest regulation update *Analyzed Florida's fishing regulations and policies regarding lobster capturing methods in coastal waters *Compiled academic research to present to NOAA as suggestions in their latest regulation update *Analyzed Florida's fishing regulations and policies regarding lobster capturing methods in coastal waters
-
-
-
Denver School of Science and Technology
-
Denver, Colorado
-
Teacher and Homeroom Advisor
-
Jun 2016 - Jul 2016
*Created and implemented lesson plans and taught middle school math to 60 incoming 6th, 7th, and 9th graders in STEM summer school *Advised a group of fifteen 10-13 year-old students and their parents in transition to middle school by teaching and explaining the systems and procedures of the school *Attended leadership and teaching workshops as well as lectures on educational advocacy *Created and implemented lesson plans and taught middle school math to 60 incoming 6th, 7th, and 9th graders in STEM summer school *Advised a group of fifteen 10-13 year-old students and their parents in transition to middle school by teaching and explaining the systems and procedures of the school *Attended leadership and teaching workshops as well as lectures on educational advocacy
-
-
-
Denver Zoological Foundation
-
United States
-
Museums, Historical Sites, and Zoos
-
200 - 300 Employee
-
Volunteer Staff
-
Jun 2012 - Aug 2015
*Pachyderms: assisted in daily cleaning and maintaining hippo and rhino health *Commissary: prepared and delivered food for variety of animals *Education Animal Department: assisted in daily cleaning and husbandry tasks *Interpretive Stations: talked with the guests about different animals *Zoo Camp: assisted counselors with children from ages of 5 years to 13 years *Pachyderms: assisted in daily cleaning and maintaining hippo and rhino health *Commissary: prepared and delivered food for variety of animals *Education Animal Department: assisted in daily cleaning and husbandry tasks *Interpretive Stations: talked with the guests about different animals *Zoo Camp: assisted counselors with children from ages of 5 years to 13 years
-
-
Education
-
2015 - 2019
University of Miami
Bachelor of Science - BS, Majors - Marine Sciences and Biology; Minors - Ecosystem Science & Policy and Chemistry
Community
