DIVYA ANDAVARAPU

PROJECT 1 - MIRROR SWITCH DECOMMISSION - PL/SQL Developer - Oct 2022 - Jan 2023

• Worked in the ETL tool Talend for monitoring jobs, as a job is a collection of user-defined functions.
• Worked in troubleshooting the jobs and procedures to get the issue fixed.
• Worked with multiple teams as per business needs.
• Decommissioned the switch between Source and Destination integrations.

PROJECT 2 - PlanET - SQL Developer - Feb 2023 - Sept 2023

• Worked as a SQL developer for fixing the issues from customers.
• Created and reviewed existing stored procedures to fix issues like slow performance.
• Worked in performance tuning and created complex queries using the MS SQL Server tool.
• Migrated the procedures into reports and applied them in the test environment to test the requests from the customer.
• Deployed the reports in the PROD environment post UAT approvals.
• Worked for job daily monitoring, and if any issue comes, did troubleshooting, and helped the job to complete the daily runs successfully.
• Used to do all the checks for planET API post-prod deployments for 2 days.

PROJECT 3 - Musarubra - Trellix - Database Analyst - Oct 2023 - current

• Provided technical support to end users in the areas of query optimization and report writing.
• Created stored procedures, functions, views, triggers and indexes to support application development.
• Developed and maintained database systems to ensure high performance and availability of data.
• Investigated user reported problems with existing applications and took appropriate corrective action when necessary.
• Reviewed server logs on a regular basis to identify potential problems before they become critical.
• Wrote scripts and processes for data integration and bug fixes.
• Analyzed workflows and established priorities for daily operations.
• Responsible for retiring the CDS to move integrations from CDS to another platform by doing all the requirements gathering for all the integrations.
• Documented the issues which caused multiple teams to be involved so that we can avoid these types of issues in the future.

PROJECT - GOLDMAN SACHS - Product Engineer - Sept 2020 - Sept 2022

• Coordinated with team members to ensure timely completion of tasks.
• Worked closely with other teams to ensure smooth operation of the overall IT infrastructure.
• Streamlined production operations, resulting in increase in productivity.
• Utilized Unix and SQL to handle debugging and automation scripting tasks.
• Provided technical guidance for other team members.
• Provided KT to the junior developers to help their knowledge in terms of productivity and quality.
• Led cross-functional teams in systems integration projects.