Kokila S

• Developed and created Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL
• Extensively performance tuning SQL and PL/SQL tuning and Application using XPLAIN and DBMS Utilities
• Utilized JIRA, GIT, GIT HUB, Bit bucket for version control, ensuring efficient collaboration across a distributed team of developers
• Created Alteryx workflows for Database Migration project
• Developed the SQL code in Alteryx tool and created monthly task to the team and ensure the deliverables on time
• Managed servers using WebLogic application and part of all deployments activities and resolved the production issue

Linux Migration

• Analyzing and understanding the coding in existing technology and implement in proc technology
• Wrote Functionality document and UTP for the program before starting development
• Ensure proper usage of cursors, bulk operations and memory management
• Wrote SQL, PL/SQL, programs required to retrieve data using cursors and exception handling
• Handled multiple tables in program to maintain records (master table, transaction table, work table & history table)
• Perform data loads and routine updates on an ongoing basis
• Improved the experience of software users by soliciting feedback and making software improvements
• Replace Windows-specific APIs with equivalent Linux-compatible functions
• Debugged and resolved any compilation errors due to platform changes
• Perform unit testing and regression testing on SQL execution and transaction handling
• Updated or rewrite any batch scripts (windows) into shell scripts (Bash/Ksh) for process automation
• Used GDB (GNU debugger) and Linux tools like strace, dmesg for debugging issues
• Troubleshoot memory leaks, segmentation faults and performance bottlenecks

SharePoint GDPR

• Ensuring GDPR General Data protection Regulation) compliance involves handling data securely, implementing privacy measures and supporting data governance
• Identified PII stored in SQL Server databases and classify data using Table partitioning methods
• Work with business teams to map data flow and identify data process activities
• Handled millions of records using those records created tables, views, index and applied SQL query optimization, performance tuning techniques for the fast retrieval of data
• Enforce role-based access control RBAC using SQL server roles & permissions
• Maintain Data Processing Agreements(DPA) and compliance documentation
• Regularly review and update GDPR-related database policies

• Analyzed database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports
• Perform data loads and routine updates on an ongoing basis
• Managed test plans, test cases, and defect tracking using JIRA
• Logged and tracked defects using JIRA, ensuring timely resolution
• Performed database testing using SQL queries to validate backend data integrity

Investment Banking

• Created tables and modified table structures by adding new column to existing table and populate data into that column
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries
• Data validation/Reconciliation report generation
• Revised, modularized and updated old codebases to modern development standards
• Convert the functional requirements into technical document as per the business standards

• Rectifying the data quality issue in the collateral management system which occurs due to the data migration from one application to another for one of the leading bank in Australia