Pokisa Edwin

Designed and maintained Power BI dashboards tracking 20+ performance indicators, enhancing data visibility and reducing reporting turnaround time by 40% for leadership Analyzed 50,000+ housing and community investment records using Python and SQL to identify funding disparities and optimize program allocation, improving resource targeting by 25% Designed an Excel-based funding allocation and forecasting model projecting funding balances across FY2026-FY2031, distributing personnel costs across multiple funding sources to support strategic budget planning

Community Development Analyst - Cook County - Chicago, IL

(2025-09)

• Designed and maintained Power BI dashboards tracking 20+ performance indicators, enhancing data visibility and reducing reporting turnaround time by 40% for leadership
• Analyzed 50,000+ housing and community investment records using Python and SQL to identify funding disparities and optimize program allocation, improving resource targeting by 25%
• Designed an Excel-based funding allocation and forecasting model projecting funding balances across FY2026-FY2031, distributing personnel costs across multiple funding sources to support strategic budget planning

Data Science & IT Consultant - Northwestern University Information Technology - Evanston, IL

(2022-08 - 2025-06)

• Diagnosed and resolved technical issues for 30+ faculty, staff, and students weekly, maintaining a 90% first-contact resolution rate and minimizing operational disruptions during academic programming
• Managed audio-visual infrastructure across 50+ classrooms, ensuring 95% system uptime and supporting the reliable delivery of lectures, events, and campus operations
• Led onboarding and training for 5+ new technicians each quarter, standardizing troubleshooting workflows and improving team productivity and technical proficiency by 20%

Strategy & Operations Intern - P33 Chicago - Chicago, IL

(2024-06 - 2024-08)

• Developed an automated organizational KPI dashboard integrating Airtable APIs, consolidating metrics from 5 internal teams and improving leadership reporting efficiency by 30%
• Conducted donor pipeline analysis and market research, identifying 50+ prospective partners to support expansion of Chicago's technology ecosystem initiatives
• Coordinated corporate sponsorship engagement for TechChicago Week, collaborating with 10+ partners and improving event operations and sponsor satisfaction

Consulting Extern - PricewaterhouseCoopers - Chicago, IL

(2023-07 - 2023-09)

• Evaluated 10+ potential partnership opportunities for CareerVillage, conducting strategic analysis that increased partner engagement by 25%
• Designed AI-driven outreach workflows, improving communication efficiency and scaling partnership development processes
• Delivered client presentation outlining partnership strategy and implementation plan, leading to execution of 5 new collaborations

Project Manager - Davis Projects for Peace - Doldol, Kenya

(2022-06 - 2022-09)

• Led the Amani ya Yaaku project, creating a cooperative business model that increased honey and beadwork sales by 20% while promoting sustainable entrepreneurship and cultural preservation in the Yaaku community
• Managed a team of 5, improving sales and marketing processes by 30% and expanding awareness of Yaaku culture through targeted outreach initiatives

Bachelor of Arts - Data Science - Northwestern University (2025-06)