• Developed 7 tailored Stored Procedures to address team requirements, optimizing workflow efficiency.• Facilitated knowledge exchange among team members, resulting in an 8% productivity increase.• Analyzed and transformed seven datasets, providing valuable insights for senior leadership in healthcare systems.• Constructed 4 user-friendly Dashboards, improving data visualization for informed management decision-making.

• Improved application performance by optimizing Oracle PLSQL queries, resulting in a 10% reduction in query execution time and enhanced system response time for end-users.• Led requirements gathering for a new application/system, involving the replacement of outdated middleware and database systems.• Partnered with infrastructure team members to devise workaround solutions for application limitations, resulting in a 10% increase in system functionality and user satisfaction.• Automated routine activities using Shell scripting and SQL, reducing time and effort by 7 hours per week.

• Mentored and supported 3 Junior resources to enhance technical proficiency, facilitating smooth execution of Business-as-usual activities.• Customized existing reports using Oracle BI Publisher to align with user specifications, resulting in a 15% increase in report accuracy and user satisfaction.• Directed initiatives on middleware platforms, overseeing the smooth migration of legacy systems and attaining a 20% enhancement in system performance and stability via effective SQL query optimization and database tuning• Implemented JDK version upgrades for the application to mitigate compatibility and vulnerability issues.• Designed and integrated triggers, packages, functions, and stored procedures to streamline data conversions and dynamically generate tailored database objects, leading to a 12% increase in database efficiency and performance.

• Crafted new Java code for 3 Existing interfaces as per the client requirement. • Compiled and maintained complete documentation for 7 components relative to the support of application. • Upgraded Customized Client Application (OMIPM versions from 3.3.17 to 3.3.20.1) and WebLogic servers to higher version patch (WebLogic Server from 11g to 12c). • Generated and deployed 15 PL/SQL and SQL queries, as well as 4 UNIX scripts, contributing to improved workflow efficiency.• Created indexes on tables to improve the performance by eliminating the full table scans and views to hide the actual tables and to eliminate the complexity of the large queries

• Oversaw the day-to-day business activities and conducted daily system health checks to monitor and maintain the existing client system.• Extracted data from the database according to client requirements, crafting 10-15 complex SQL queries per week.• Wrote Java code for 2 application components as per user’s requirements. • Complied approximately 15 reports from Oracle BI Publisher for user access.• Applied patch upgrades to WebLogic Server on a quarterly basis to optimize performance.