Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic
Srinivas Annam

Srinivas Annam

Hyderabad

Summary

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.

Overview

10
10
years of professional experience

Work History

Senior Associate

Cognizant Technologies Services
10.2022 - Current

OBIEE Engineer

Milestone Technologies
12.2021 - 09.2022

Senior Associate

Tata Consultancy Services
10.2018 - 12.2021

Oracle D2k Programmer

Haritha Enterprises
02.2018 - 10.2018

Oracle Programmer

Suryalata Spinning Mills
07.2016 - 03.2017

Oracle D2k Forms, Reports Developer

Sathguru Management Consultants Pvt Ltd
Hyderabad
02.2015 - 08.2016

Education

B.E./B.Tech. - Computer Science

Sphoorthy Engineering College
Hyderabad

Skills

  • D2K forms and reports
  • PL/SQL developer
  • Oracle SQL, PL/SQL
  • SQL performance tuning
  • Table partitioning
  • Collections
  • Performance tuning
  • SQL querying
  • Problem solving
  • Partitioning and indexing
  • Oracle forms and reports
  • SQL query optimization
  • Triggers, procedures, and functions
  • SQL development
  • Snowflake scripting
  • DB migration (Sybase to Oracle)
  • Teradata to Snowflake

Projects

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.

Timeline

Senior Associate

Cognizant Technologies Services
10.2022 - Current

OBIEE Engineer

Milestone Technologies
12.2021 - 09.2022

Senior Associate

Tata Consultancy Services
10.2018 - 12.2021

Oracle D2k Programmer

Haritha Enterprises
02.2018 - 10.2018

Oracle Programmer

Suryalata Spinning Mills
07.2016 - 03.2017

Oracle D2k Forms, Reports Developer

Sathguru Management Consultants Pvt Ltd
02.2015 - 08.2016

B.E./B.Tech. - Computer Science

Sphoorthy Engineering College
Srinivas Annam