Edward Rogers IV
Virginia Beach
Summary
Results-driven Business Analyst with a proven track record at Spring Oaks Capital, LLC, enhancing call center collections by 30% through innovative SQL and ETL workflows. Skilled in data storytelling and stakeholder communication, I excel in delivering executive-level insights and optimizing data processes for strategic decision-making.
Overview
8
8
years of professional experience
Work History
Business Analyst
Spring Oaks Capital, LLC
10.2022 - Current
- Partnered with owners and C-suite leadership in the development of phone-centered skip-tracing SQL query and ETL workflows to feed inventory into model-driven calling (MDC), increasing monthly collections for the call center by ~30%.
- Designed and deployed 10+ interactive KPI dashboards in Sigma Computing (BI), reducing manual reporting time and managed monthly account reviews to align platform capabilities with organizational goals.
- Co-administered InterProse system of record containing 2.8M consumer accounts, ensuring company-wide data integrity, security, and accessibility for call center analytics and reporting.
- Owned and Delivered executive-level reporting including pacing, operations productivity, and batch summary analyses, providing portfolio performance insights to owners and C-suite leadership.
- Automated credit reporting processes using SQL queries and ETL workflows, improving efficiency and accuracy.
- Delivered ad hoc reporting across Operations, Data Science, Engineering, Compliance, and Litigation departments to support cross-functional business needs.
- Created and optimized SQL queries for datasets exceeding 1B rows, improving query performance significantly.
Landscaping Crew Leader
Simply The Best, LLC
06.2017 - 09.2022
- Implemented quality control measures through regular site inspections, checklists, and crew training, ensuring consistently exceptional finished landscapes.
- Managed inventory of materials efficiently to ensure availability when required.
- Conducted regular performance evaluations for crew members, identifying areas for improvement and developing personalized action plans accordingly.
- Resolved conflicts between crew members professionally while maintaining focus on project goals.
Education
BBA - Business Analytics
Old Dominion University
Norfolk, VA05-2022
Skills
- Sigma Computing (BI & Visualization Tool)
- SQL
- Data Validation & Cleansing
- Data Storytelling & Executive Reporting
- ETL Workflow Design
- Automation
- Microsoft Office Suite
- Stakeholder Communication
Timeline
Business Analyst
Spring Oaks Capital, LLC
10.2022 - Current
Landscaping Crew Leader
Simply The Best, LLC
06.2017 - 09.2022
BBA - Business Analytics
Old Dominion University
Similar Profiles
Allen BrockAllen Brock
Operations Manager at Spring Oaks Capital LLCOperations Manager at Spring Oaks Capital LLC
Derricka HenryDerricka Henry
Collections Specialist at Spring Oaks Capital LLCCollections Specialist at Spring Oaks Capital LLC
Alexis SaundersAlexis Saunders
Collections Specialist at Spring Oaks Capital LLCCollections Specialist at Spring Oaks Capital LLC
Gavin LavelyGavin Lavely
Surfing Instructor at 17th Street Surf ShopSurfing Instructor at 17th Street Surf Shop
Christine ShortsleeveChristine Shortsleeve
Driver at Uber EatsDriver at Uber Eats