Summary
Overview
Work History
Education
Skills
Work Profile
Job Profile
Languages
Timeline
Generic

VENKATESH KOTHAPALLY

Hyderabad,India

Summary

Looking forward for an opportunity in a challenging environment, where I can utilize my experience in contributing effectively to the success of the organization.

Having Around 1.5+ years of professional experience as Oracle SQL, PLSQL Developer, which includes Analysis, Application Programming, Unit Testing, implementation. Understanding the business requirement and worked as a part of team and individual as well. Having Good Experience in Oracle 10g, 11g (SQL, PL/SQL). Proficient in writing of Stored Procedures, Functions, Packages, Cursors, views using Oracle PL/SQL. Having knowledge in SQL Functions, Constraints, Ranking Functions. Experience in creation of Tables, Synonyms, Views, Sequences and Indexes. Good Exposure in using SET Operators, Joins, Sub Queries. Extensive knowledge in Oracle cursor management, Exception Handling. Having experience in converting flat file data into tables. Having Good Knowledge of DDL, DML, DCL, TCL Commands. Having basic knowledge on Unix Shell Scripting. Having knowledge on Performance Tuning. Having experience in developing stored procedures using dynamic SQL. Good interpersonal skills, committed, result oriented, Hard working with a quest and Zeal to learn new technologies. Proficient in analyzing client's business process and delivering the accurate solution to incorporate the same business logic in software product. Having rich experience in product Customization right from requirement analysis to Documentation, & Testing. Having experience in interacting with the clients over call. Having proficient knowledge in understanding new technologies accomplishing projects goals successfully. Excellent analytical, technical, communications and interpersonal skills with leadership qualities.

Overview

1
1
year of professional experience

Work History

Consultant

Capgemini Services Pvt.
10.2021 - 04.2023
  • Worked as Consultant for Capgemini Services Pvt., Hyderabad from Oct 2021 to April 2023.

Education

Master of Science - DATA SCIENCE

Lewis University
Romeoville, IL
12.2024

Bachelor of Science - Computer Science

JAGRUTI DEGREE AND P.G COLLEGE
05.2017

S.S.C -

ZPHS SIDDIPET
01.2012

Skills

  • SQL
  • PL/SQL
  • Unix (Basic Knowledge)
  • SQL Developer
  • Toad
  • Loader
  • Putty
  • Winscp
  • PLSQL Developer
  • Windows Family
  • Unix
  • Weblogic (Basic Knowledge)
  • Oracle 10g
  • 11g

Work Profile

Sanofi Pharmacy PROJECT, 10/2021 - 04/2023, Sanofi, Oracle 11g, SQL Developer, Sanofi is a healthcare company, which is engaged in the discovery, development, manufacturing and marketing of a wide range of medicines and vaccines., Creating packages, procedures, functions using advanced PL/SQL coding to implement the complex business logic as per client requirement., Understanding the business requirement and worked as a part of team and individual as well., Developed the code as per Functional Specification Document., Writing complex queries using multiple tables., Having good knowledge on Dynamic SQL., Debugged and Monitors the performance of the queries developed in procedures., Created Constraints, Indexes on Table columns., Interacted with the clients directly and understood their requirement and developed the new CR’s as per the client requirement., Analyzed, developed Packages, Procedures and Functions as per the requirement., Analysis, design, develop, coding, Implementation and documentation for the requirements., Involved in writing unit test cases., Performed unit testing by writing wrappers

Job Profile

Capgemini Services Pvt., Hyderabad, 10/2021, 04/2023

Languages

English
Professional Working
Hindi
Full Professional
Telugu
Native or Bilingual

Timeline

Consultant

Capgemini Services Pvt.
10.2021 - 04.2023

Master of Science - DATA SCIENCE

Lewis University

Bachelor of Science - Computer Science

JAGRUTI DEGREE AND P.G COLLEGE

S.S.C -

ZPHS SIDDIPET
VENKATESH KOTHAPALLY