Kaviyanjali B

Data Engineer with around 2 years of IT experience in data warehousing, ETL/ELT, SAP data integration, SQL development, and reporting solutions. Experienced in end-to-end data pipelines from SAP ECC through Xtract Universal, Amazon S3, and Amazon Redshift. Strong in complex SQL, source-to-target mapping, data lineage, validation, reconciliation, Oracle business logic analysis, data migration, and Python automation.

Experienced in reporting datasets, business-rule implementation, pipeline troubleshooting, and collaboration with SAP, ABAP, and business teams.

Software Engineer – Data Engineering - Persistent Systems

(2026-06)

• Work on end-to-end ETL/ELT pipelines with SAP ECC as the source, using Xtract Universal for extraction and Amazon S3 and Amazon Redshift for processing and reporting.
• Develop and enhance Amazon Redshift views and reporting datasets using complex SQL, joins, CTEs, window functions, aggregations, and business rules.
• Perform source-to-target mapping, data lineage analysis, row-count validation, duplicate analysis, reconciliation, and data-quality checks across Oracle and Redshift.
• Analyze Oracle views, procedures, packages, and database logic to understand business rules and implement reporting logic in Redshift.
• Work with SAP ECC data for material, customer, sales, inventory, and backlog reporting, collaborating with SAP Functional and ABAP teams.
• Diagnose ETL workflow and job failures using Xtract Universal, JS7, TWS, Linux, SSH, and Shell script analysis.
• Work on Oracle-to-Redshift data migration, including loading, validation, business-rule implementation, and reporting enhancements.
• Develop Python automation for Excel processing, validation, report generation, file handling, and recurring email distribution.
• Validate Power BI data sources and datasets, investigate discrepancies, and ensure reporting data is accurate and consistent.
• Perform root-cause analysis, testing, issue resolution, and stakeholder communication for data and reporting requirements.

Associate Software Engineer – Data Engineering (Contract Consultant) - Persistent Systems

(2025-09 - 2026-06)

• Work on end-to-end ETL/ELT pipelines with SAP ECC as the source, using Xtract Universal for extraction and Amazon S3 and Amazon Redshift for processing and reporting.
• Develop and enhance Amazon Redshift views and reporting datasets using complex SQL, joins, CTEs, window functions, aggregations, and business rules.
• Perform source-to-target mapping, data lineage analysis, row-count validation, duplicate analysis, reconciliation, and data-quality checks across Oracle and Redshift.
• Analyze Oracle views, procedures, packages, and database logic to understand business rules and implement reporting logic in Redshift.
• Work with SAP ECC data for material, customer, sales, inventory, and backlog reporting, collaborating with SAP Functional and ABAP teams.
• Diagnose ETL workflow and job failures using Xtract Universal, JS7, TWS, Linux, SSH, and Shell script analysis.
• Work on Oracle-to-Redshift data migration, including loading, validation, business-rule implementation, and reporting enhancements.
• Develop Python automation for Excel processing, validation, report generation, file handling, and recurring email distribution.
• Validate Power BI data sources and datasets, investigate discrepancies, and ensure reporting data is accurate and consistent.
• Perform root-cause analysis, testing, issue resolution, and stakeholder communication for data and reporting requirements.

Trainee Python Developer - Pixstone Images Pvt. Ltd.

(2025-02 - 2025-07)

• Developed Python-based automation solutions using PyCharm to streamline production workflows and reduce repetitive manual activities.
• Built data processing and reporting solutions using Python, SQL, Pandas, Matplotlib, and REST APIs.
• Developed Flask applications integrating APIs and databases for automated workflows and reporting.
• Automated email notifications and report distribution and performed data validation and database operations using SQL and Python.

Data & Analytics Trainee – SQL / Oracle PL/SQL - Virtusa Consulting Services Pvt. Ltd.

(2023-05 - 2023-08)

• Developed SQL and Oracle PL/SQL solutions for data processing, validation, reporting, and database operations.
• Worked with procedures, triggers, cursors, packages, joins, subqueries, views, and query optimization.
• Performed database analysis and data validation to support reporting requirements.

Bachelor of Technology (B.Tech) - Information Technology - Agni College of Technology, Anna University (2019 - 2023)