Aishwarya V S

Client: QBE Insurance.

• Handled incidents, problem records, and JIRAs to rectify defects and enhance code functionality through backtracking, debugging, and root cause analysis.
• Analyzed current workflows, devising enhanced strategies to boost efficacy and output through performance tuning.

- Significantly reduced query run time by segmenting complex queries into smaller components and leveraging temporary tables for optimization.

- Enhancements (add new process, change functionality, SSIS package building): Altered/Created stored procedures, introduced new fields or new logic in SP and SSIS packages as part of enhancements based on business requirements.

- Fragmentation: Managed query overruns by checking data fragmentation levels, further administering index-rebuilding operations, and updating statistics to ensure sustained query performance.

• Conducted impact analysis on existing systems in order to identify areas of improvement or potential risks.

- Implemented logging mechanism in all stored procedures to capture ObjectName, Starttime, Endtime, and RecordCount for efficient performance monitoring during daily batch/load runs.

- Performed root cause analysis on reported bugs in order to develop effective solutions that meet customer expectations.

• Participated in code reviews with team members in order to ensure best practices were followed throughout development process.

- Streamlined operations through the implementation of an effective maintenance plan that included identifying and integrating missing indexes, optimizing execution flow from sequential to parallel, and incorporation of delays in SSIS packages to minimize overruns or deadlocks.

• Developed custom dashboards using Power BI for visualizing large datasets.