Kelsea Elam
Essington,PA
Summary
Data-focused Business Analyst with 7+ years of experience supporting full SDLC delivery in data-intensive environments. Skilled in SQL-based data validation, requirements refinement, and QA testing within data warehouse ecosystems. Experienced in translating business needs into testable requirements and data logic, with exposure to API-driven architectures and modern data pipelines.
Overview
8
8
years of professional experience
Work History
Business Analyst
School District of Philadelphia
Philadelphia, PA, USA
01.2024 - Current
- Collaborate with stakeholders and technical teams to refine business requirements into detailed, testable user stories, acceptance criteria, and validation logic supporting enterprise reporting systems
- Translate complex regulatory and reporting needs into data warehouse specifications, mappings, and transformation logic for PIMS and internal analytics
- Write and execute SQL queries (Oracle) to validate large-scale datasets, investigate discrepancies, and support data quality across warehouse tables
- Analyze data across multiple systems to identify anomalies, inconsistencies, and patterns impacting reporting accuracy and business workflows
- Partner with data engineering teams to validate data pipelines, troubleshoot integration issues, and ensure data integrity across fact and dimension models
- Develop and execute test cases, UAT scenarios, and regression testing aligned with business requirements and system integrations
- Perform data reconciliation between source systems and warehouse outputs, identifying root causes and resolving data quality issues
- Document data mappings, lineage, business rules, and validation logic to support transparency and traceability across systems
- Support implementation of new reporting processes by gathering requirements, mapping data flows, and validating outputs across integrated systems
- Communicate technical findings and data insights clearly to both business stakeholders and engineering teams
Business Analyst
YPrime
Wayne, PA, USA
11.2020 - 09.2023
- Gathered and refined business and functional requirements, translating them into user stories, acceptance criteria, and technical documentation for software development
- Supported API upgrade initiatives, documenting data interactions and ensuring alignment between system integrations and business requirements
- Collaborated with cross-functional teams to support full SDLC delivery, including requirements, testing, and validation
- Developed and executed test cases and validation scenarios, ensuring system functionality aligned with business rules and expected outcomes
- Led defect triage efforts, analyzing system issues and coordinating resolution across development and QA teams to support timely releases
- Facilitated Agile ceremonies (sprint planning, grooming, retrospectives) to ensure alignment and delivery across multiple development pods
- Conducted stakeholder workshops to elicit requirements, map workflows, and align product enhancements with business objectives
- Produced dashboards and reporting insights to support decision-making and performance tracking
Business Analyst
Verista
Wayne, PA, USA
08.2018 - 03.2020
- Translated client business processes into functional specifications, traceability matrices, and validation documentation for regulated systems
- Developed and executed test scripts, validation protocols (IQ/OQ/PQ), and test cases to ensure system accuracy, data integrity, and compliance
- Partnered with clients to gather and document business and technical requirements for system implementations
- Identified risks and process gaps, recommending improvements to validation and documentation practices
- Collaborated with QA, validation, and engineering teams to support testing, issue resolution, and audit readiness
- Ensured alignment between system behavior, data outputs, and regulatory requirements
- Analyzed regulated system workflows to identify compliance risks and process inefficiencies, recommending standardized validation and documentation improvements across projects.
- Translated client business processes into functional specifications and traceability matrices to support system implementation and validation activities.
- Partnered with pharmaceutical and life sciences clients to gather, analyze, and document business and technical requirements for validated systems.
- Developed detailed test scripts and test cases for manual testing of GMP/GLP-regulated systems, ensuring accuracy, traceability, and compliance.
- Conducted informal and formal testing phases (IQ, OQ, PQ) to verify system functionality and data integrity in alignment with client specifications.
- Applied critical and creative thinking to identify defects, assess risks, and confirm that systems operated as intended under diverse user scenarios.
- Collaborated with cross-functional teams—including QA, Validation, and Engineering—to document test evidence, deviations, and validation summaries.
- Supported continuous improvement of validation and documentation processes, contributing to audit readiness and regulatory compliance.
Education
Master Certificate - Data Science
Eastern University
Wayne, PA12.2025
Bachelor of Arts - Africology and African American Studies
Temple University
Philadelphia, PA05.2018
Skills
- SQL
- Python
- Numpy
- Pandas
- Matplotlib
- R
- Data Analysis
- Requirements Gathering
- User Acceptance Testing
- Team Collaboration
- Technical Writing
- Microsoft Office Suite
- Power BI
- Tableau
- Visio
- Microsoft SQL Server
- Oracle SQL Developer
- Postgres SQL
- Jira
- Confluence
- Visual Studio Code
- Azure DevOps
Timeline
Business Analyst
School District of Philadelphia
01.2024 - Current
Business Analyst
YPrime
11.2020 - 09.2023
Business Analyst
Verista
08.2018 - 03.2020
Bachelor of Arts - Africology and African American Studies
Temple University
Master Certificate - Data Science
Eastern University