Felicia Walcott
347-***-**** · ********.*******@*****.*** · LinkedIn
SKILLS
Programming & Analytics: SQL, PostgreSQL, Python (Pandas, NumPy, Scikit-learn), R, Scala, Excel (Advanced Functions, Pivot Tables, VLOOKUP, Dashboards)
Data Visualization & BI: Tableau, Power BI, ggplot2, Shiny, KPI Dashboards, A/B Testing, Data Storytelling & Reporting Automation
Data Management & Warehousing: ETL/ELT Pipelines, dbt, Snowflake, Data Modeling (Star & Snowflake Schemas), Airflow, AWS (S3, Glue, Lambda), GCP, Data Governance & Validation
Statistical Analysis & Machine Learning: Regression, Classification, Clustering, Naïve Bayes, KNN, Forecasting Models
EDUCATION
Brooklyn College, Fine Arts 2010
EXPERIENCE
Huntington Learning Center Brooklyn, NY
Learning Data Analyst April 2017-present
● Collected and analyzed standardized test data using SQL and Python, applying statistical analysis to identify learning gaps, forecast improvement opportunities, and recommend interventions that increased student performance outcomes.
● Built ETL workflows with dbt and Snowflake, transforming raw assessment data from AWS S3 into structured, analytics-ready models, incorporating dimensional modeling (Star schema) to support progress tracking and reporting scalability.
● Designed Tableau dashboards and Excel KPI trackers to monitor student performance trends, enabling instructors and administrators to make timely data-driven decisions that improved curriculum planning and intervention effectiveness.
● Applied A/B testing frameworks to evaluate instructional strategies, uncovering optimal learning methods that improved student engagement and contributed to a 93% two-grade-level advancement rate within six months.
● Implemented data governance processes to validate and standardize academic reporting workflows, ensuring accurate and consistent communication of student progress metrics across parents, teachers, and administrators.
● Delivered clear presentations and data storytelling to non-technical stakeholders, effectively communicating academic insights, performance trends, and program outcomes that aligned learning strategies with measurable goals.
ARCH FOR KIDS Program Data Analyst Brooklyn, NY
Program Data Analyst April 2014-June 2023
● Analyzed large structured and unstructured datasets from student participation records using SQL and Python, uncovering engagement trends that improved program design and boosted workshop attendance by 20%.
● Optimized SQL queries and reporting workflows for complex participation data, applying performance tuning techniques that reduced retrieval times and accelerated reporting efficiency for program leadership teams.
● Automated recurring reporting tasks with Python and Excel, consolidating attendance metrics and curriculum feedback, saving 15+ instructor hours monthly and enabling more timely program adjustments.
● Conducted trend and demographic analysis to uncover disparities in student engagement, generating insights that guided equitable program expansion and improved accessibility across multiple community centers.
● Partnered with educators and administrators to translate complex datasets into actionable recommendations, ensuring programs were aligned with both academic standards and evolving community goals.
● Delivered presentations and data stories to non-technical stakeholders, communicating program outcomes and performance insights that informed strategic planning and resource allocation decisions.