Senior Associate with extensive experience in Oracle SQL and PL/SQL development at Cognizant Technologies Services. Demonstrated expertise in SQL performance tuning and problem-solving, significantly enhancing database efficiency. Skilled in database migration and SQL query optimization, consistently delivering solutions that drive business success. Proven ability to lead database projects, ensuring timely and budget-compliant completion while providing technical support to clients and staff.
Project1:
Client: JP Morgan Chase & Co.
JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2.6 trillion and operations worldwide The Firm is a leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co serves millions of consumers in the United States and many of the world's most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands.
Responsibilities:
Created tables, added constraints, and DDL script; created SQL queries, procedures, and functions using PL/SQL; created the PL/SQL code and SQL queries; performed unit testing on sample data; development and enhancement of Oracle forms; development of reports using Report Builder; designed low-level design documents as per the application functionality; DB enhancements; DB scripting; migrated DB objects from Sybase to Oracle; Sybase exit; written audit table, triggers, indexes, views; Autosys job scheduled; UAT, Prod deployments; Sybase exit; DB migration; schema migration;
Project2:
Client: Humana Health Insurance
Humana Inc. is a for-profit American health insurance company based in Louisville, Kentucky. It has been the third largest health insurance in the nation. Humana started out in the 1960s as a nursing home company, and quickly grew to be the largest in the United States. Thirty years later, the company’s name had officially changed to Humana, was the largest hospital operator in the county, and had created its own health insurance plans. Soon after, Humana decided to focus entirely on its managed healthcare plans, letting go of its hospital division. To this day, Humana Inc is a Fortune 500 company based in Kentucky and one of the largest health insurance companies in the nation.,
Responsibilities:
Application Enhancements, Customization, Configuration setup., Support on PLSQL, Incident break fixing, Problem Solving, Incident management, Work Force Management, Root cause analysis, Debugging PLSQL Packages, Extended support during Humana Bid Filing Season. Discussing with different teams., Preparation of test cases, Patch creation, Prod, QA Deployments.