Dhana Priya S A

Project name: JP Morgan - BFSI

• Using Informatica Power Center for extraction, transformation, and load (ETL) of data
• Created and maintained Control-M job schedules, defining job dependencies, triggers, and calendars to ensure timely execution.
• Monitored Control-M job executions, proactively identifying and resolving issues to minimize job failures and delays, and ensuring SLAs were met.
• Hands-on experience in Informatica monitoring to monitor the workflows and worked in troubleshooting the workflows if they failed.
• worked in Unix (putty) for changing the file permissions, or to modify the file if required.
• Conducted performance testing of ETL processes to identify and address defects and performance bottlenecks proactively.
• Provided support for production ETL jobs, monitoring job executions, investigating and resolving issues, and implementing enhancements to meet SLAs.
• Worked on Oracle SQL queries to perform data transformations, aggregations, and validations during the ETL process.
• worked with the team on the liquibase setup.
• Worked in open bridge with Clients(JPMC) to meet the target.
• Documented technical specifications, design documents, and operational procedures to ensure clarity and consistency in ETL development and maintenance processes.

Project name : Ahold Delhaize - Retail/HR & finance

• Hands-on experience in Mendix (App development)
• Involved in the process of analyzing business requirements and understanding the functional workflow by running the SOP for users by updating the profile changes and creating the profile in Visual Studio 2018 based on a bulk request
• Perform DML & DDL Operations as per business requirements
• Developed custom reports for the project using SSMS and SQL Server Reporting Service
• Monitored performance and optimized SQL queries for business-related incidents
• Investigated and reduced incidents by establishing detailed tracking and reporting frameworks
• Developed reports and views for the data analysis
• Worked on Confluence page documentation for applications.

• Monitoring ADF pipelines and SSMS involved in Troubleshooting if necessary
• Responsible for performing data analytics and generating insights as per business requirements using Power BI
• Utilized SQL, data warehousing programs, Tableau, and other dashboard/Visualization tool sets for data intelligence and analysis
• Supported technical team members for developing new entities during Client requests
• Coordinated with team members in coding, review of designs, and test results
• Involved to work in the server in case of issues through Virtual Machines
• Involved in Debug and resolving issues effectively and efficiently in ADF pipelines
• Providing operational reports on a daily basis before EOD
• Supported other ETL developers providing technical assistance, troubleshooting, and alternative development solutions
• Extracted data from existing data sources, developing and executing reports by using MS Excel, SQL, and Power BI.