ALEMAYAHU ANBESSIE
Columbia,MD
Summary
Experienced Data Analyst and ETL Developer with 13+ years of expertise in data analysis, ETL development, ETL pipe line process, and large-scale data migration validation. Expert level system, integration and regression tests with water fall and Agile software development methodologies.
Overview
13
13
years of professional experience
Work History
Senior Data Analyst and ETL Developer
Johns Hopkins Health Plans
08.2023 - Current
- Led source-to-target data validation and reconciliation for large scale data using advanced SQL, identifying data inconsistencies and mapping issues to improve quality and reduce production defects.
- Translated complex functional requirements and mapping specifications into validated ETL workflows, ensuring accurate transformation logic, business rule enforcement, and regulatory data compliance.
- Leveraged SQL and Excel-based analysis to cleanse, transform, and validate complex healthcare datasets, improving data completeness, reconciliation accuracy, and reporting efficiency across multiple systems.
- Performed root-cause analysis on ETL transformation issues and data discrepancies, enhancing data pipeline stability and significantly reducing recurring production failures.
- Validated initial, incremental, and full data loads; identified discrepancies, performed root cause analysis, and resolved 100+ critical data issues.
- Led data quality management efforts, remediating 150+ issues and actively monitoring risks to ensure compliance and data integrity.
- Developed and executed complex SQL scripts on large datasets (600+ rows), ensuring accurate transformations and successful data migration.
- Owned validation of initial, incremental, and full ETL data loads, ensuring accurate processing, data integrity, and successful source-to-target reconciliation across healthcare systems.
- Collaborated with Agile cross-functional teams during sprint planning, defect triage, and troubleshooting to resolve data analysis and ETL issues, improving delivery timelines and high-quality data processing.
- Project: SYMPLR Payer Data Migration, MDM, FACETS, Availity Reporting, MC_400 Data Archival
Senior Data Analyst and ETL Engineer
Qualitest (Client: MultiPlan / Claritev)
08.2021 - 07.2023
- Worked with business stakeholders to understand functional requirements and mapping documents, translating them into clear test plans, scenarios, and validation approaches aligned with the requirement.
- Used advanced SQL to validate, reconcile, and analyze backend data in Oracle, identifying inconsistencies in source-to-target loads and ensuring accurate data movement across environments.
- Debugged data mapping issues and failed records by analyzing transformation logic and collaborating with development teams to correct and reload data into target systems.
- Designed and executed regression, integration, and data validation testing to support ETL pipelines and ensure reliable processing of healthcare claims and eligibility data.
- Validated HIPAA 5010X EDI 837 (Institutional and Professional) transactions to ensure compliance, data integrity, and proper handling of PHI across systems.
- Performed root-cause analysis on data issues, failed loads, and reconciliation gaps, driving corrections that improved overall quality and stability.
- Verified data mappings, schemas, transformation logic, and business rules (including Cigna ECSIF), ensuring accuracy in claims and eligibility workflows.
- Supported migration of 25X to 26X near real-time billing data pipelines and processed No Surprises Act (NSA) claims to ensure timely and accurate data delivery.
- Monitored ETL jobs and EMR executions in production, proactively identifying failures and data anomalies to maintain system reliability and data accuracy.
- Partnered with QA, business, and technical teams to resolve defects, improve traceability, and ensure CMS and payer deliverables met required standards.
- Collaborated with upstream and downstream teams to support onboarding, environment readiness, and smooth integration of healthcare data workflows.
- Project: Surprise Billing & Cigna–Duke Real Time Migration
Data Analyst and ETL Developer
HCL America
Richmond, VA
11.2019 - 07.2021
- Worked in an Agile/Scrum environment, actively contributing to all STLC phases by creating and maintaining test artifacts aligned with project delivery goals.
- Analyzed business requirement documents (BRDs) and translated them into detailed test plans, scenarios, and test cases to ensure full coverage of business needs.
- Executed functional, non-functional, smoke, integration, system, and regression testing, tracking and managing defects in Jira through resolution.
- Led data migration testing by validating record counts and data integrity, identifying discrepancies, and supporting resolution of data issues.
- Performed SQL-based ETL validation in Oracle environments to analyze and verify data accuracy across datasets and support backend testing efforts.
- Collaborated with cross-functional, onshore, and offshore teams to share knowledge, improve communication, and support consistent test execution.
- Demonstrated strong analytical and problem-solving skills, consistently delivering accurate, high-quality results with minimal supervision in fast-paced environments.
- Project: PRPRID and Data Integration Project for Advantasure
Data Analyst and ETL Developer
Technology Talent Network
Dayton, OH
10.2013 - 09.2019
- Reviewed BRD, FRD, and TRD documents to design detailed test plans and test cases, and managed test assets in Jira and HP ALM/Quality Center.
- Actively participated in daily standups, sprint reviews, and requirement discussions with stakeholders, ensuring clear communication and alignment throughout the testing lifecycle.
- Mentored junior team members and new joiners by sharing best practices, testing standards, and project-specific processes to improve team efficiency.
- Delivered onboarding and knowledge transfer sessions for new team members to ensure smooth transition and faster productivity.
- Validated ETL processes across heterogeneous data sources using Oracle and Teradata, applying analytical methods to ensure data accuracy and consistency.
- Played a key role within the QA team by supporting end-to-end testing activities, coordinating with stakeholders, and ensuring timely delivery of high-quality releases.
- Project: Data Migration Project for CareSource
Education
Bachelor of Science (B.Sc.) - Health Care Management
University of Maryland University College
Skills
- Data & Databases: SQL, Oracle, DB2
- ETL & Data Quality: ETL/ELT, Data Validation, Data Quality Management, Data Mapping
- Programming: Java, Python
- Data Integration: SFTP, Flat Files
- Tools: Informatica, Jira, Microsoft Office
- Operating Systems: Linux, Unix
- Methodologies: Agile, Waterfall
Timeline
Senior Data Analyst and ETL Developer
Johns Hopkins Health Plans
08.2023 - Current
Senior Data Analyst and ETL Engineer
Qualitest (Client: MultiPlan / Claritev)
08.2021 - 07.2023
Data Analyst and ETL Developer
HCL America
11.2019 - 07.2021
Data Analyst and ETL Developer
Technology Talent Network
10.2013 - 09.2019
Bachelor of Science (B.Sc.) - Health Care Management
University of Maryland University College