Kavana S P

Account:Nova.
Project : Currys

• Working as a team lead for one of the migration projects on the SAP BODS tool.
• Worked on multiple file transfer tools like(Filezilla,winscp,commandline etc) and scripts to make the code work in a higher version of BODS tools.
• Have a good knowledge of mainframe datasets which gained by working in current project
• Tested all flows end to end to ensure data integrity and accuracy
• Good hold on ETL transformations

Project: Claims Management System

• In AWS developed a detailed Data Migration plan, including scheduling, data mapping, data transformation and data validation.

• Successfully uploaded SharePoint data to AWS Redshift Data Warehouse, ensuring data accuracy and quality. Developed custom scripts using Python, SQL, PySpark to automate data migration and validation process, saving time and reducing errors via ETL and AWS Glue.

• Leveraged Redshift Spectrum on Redshift Cluster to query external data sources directly, eliminating the need for data replication and reducing storage costs.

• Monitored system performance and proactively addressed issues to ensure smooth operation and minimal downtime.

Belief in power of technology and analytics to improve outcomes.

Account: Tokio Marine Kiln
Project: Application manged services(AMS)

• Designed, developed, debugged and supported complex ETL processes in BODS and Talend, increasing efficiency by 50%.
• Worked closely with insurance data, including longitudinal claims and high risk conditions, improving processing speed.
Strong in troubleshooting ETL failures and resolve complex data issues,
decreasing failures by 80%.
Communicated with business customers to discuss the issues and requirements and translate them to technical solutions.
Created new mappings and updating old mappings according to changes in business logic.
• Production support has been done to resolve the ongoing issues. .Loaded XML source data to target database table.
Created Workflows, tasks and database connections. Developed complex mappings and tuned them for better performance.
Created the ETL runbook and actively participated in all phases of testing.