AYANA MERIN DOILY

AYANA MERIN DOILY

Data Quality Analyst
India
Malayalam, Hindi, English

About Me

Analytical and detail-oriented Data Management Analyst with 8 years of experience in data quality, governance, migration, and reporting across enterprise systems. Skilled in data validation, reconciliation, metadata mana…

Experience

Senior Data Engineering Analyst

Accenture
Mar 2022 - Present · 4 years 4 months

Assigned Systems of Record (SORs) across 8 regions in the healthcare domain, ensuring accurate data validation and reconciliation across geographies.
Analyzed business metrics used in SAS-based reporting, backtracked them to Oracle Clarity (IDR) source tables, and validated transformation logic.
Designed staging tables in Databricks replicating SAS intermediate transformations, enabling smooth migration of legacy Oracle/SAS processes.
Built dimension and fact tables in Databricks (DBX) aligned to healthcare reporting requirements, ensuring compatibility for downstream modeling.
Collaborated with data modelers to create robust data models, ensuring accurate joins between facts and dimensions.
Produced governance-compliant documentation (Test Plans, RTMs, Data Quality Reports).
Conducted data quality assessments and Power BI dashboard validations, reducing reporting errors by 15%.
Supported decommissioning of legacy Oracle & SAS systems (built in 2010) by migrating all ETL and reporting pipelines to Azure Databricks.
Supported data governance initiatives by preparing mapping documents, lineage reports, and metadata validation.

Senior Data Engineering Analyst

Accenture
Mar 2022 - Present · 4 years 4 months

Assigned Systems of Record (SORs) across 8 regions in the healthcare domain, Analyzed business metrics used in SAS-based reporting, Designed staging tables in Databricks, Built dimension and fact tables in Databricks, Collaborated with data modelers, Produced governance-compliant documentation, Conducted data quality assessments, Supported decommissioning of legacy Oracle & SAS systems, Supported data governance initiatives

Senior Technical Services Specialist – Data

IBM
Aug 2021 - Mar 2022 · 7 months

Executed ETL and data quality testing using Informatica DVO, ensuring compliance with transformation rules.
Partnered with business analysts to align data models and resolve discrepancies in mapping specifications.
Reported and tracked defects in Jira, improving data quality resolution turnaround.

Senior Technical Services Specialist – Data

IBM
Aug 2021 - Mar 2022 · 6 months

Executed ETL and data quality testing using Informatica DVO, Partnered with business analysts, Reported and tracked defects in Jira

Programmer Analyst

Cognizant
May 2018 - Aug 2021 · 3 years 3 months

Conducted data migration and reconciliation across Hadoop, Oracle, and Cassandra.
Validated KPI flows in BI dashboards (Power BI, Qlik, OBIEB), supporting data stewardship for Veeva Salesforce/Reltio datasets.
Delivered test plans and quality reports to ensure accurate and reliable business reporting.

Programmer Analyst

Cognizant
May 2018 - Aug 2021 · 3 years 3 months

Conducted data migration and reconciliation across Hadoop, Oracle, and Cassandra, Validated KPI flows in BI dashboards, Delivered test plans and quality reports

Software Engineer Trainee

Pumex Infotech
Jul 2017 - May 2018 · 10 months

Assisted in development and testing of front-end and back-end applications.
Participated in bug fixing, enhancements, and QA documentation.

Software Engineer Trainee

Pumex Infotech
Jul 2017 - May 2018 · 10 months

Assisted in development and testing of front-end and back-end applications, Participated in bug fixing, enhancements, and QA documentation

Skills

Business Intelligence Data Quality & Governance Data Management Platforms ETL & Integration Cloud & Big Data Scripting & Automation Defect & Project Management Tools Methodologies Data validation Reconciliation Metadata management Lineage tracking Oracle Teradata SQL Server Snowflake Hive Reltio Palantir Foundry Veeva CRM Informatica PowerCenter Informatica IICS Azure Databricks Hadoop Power BI Qlik Sense OBIEE Python Unix Excel Macros Jira HP ALM Rally Agile Waterfall SQL SAS Oracle Clarity Spark Cassandra Informatica DVO
Report this Profile?