AVIJIT GHOSH, Assistant Consultant, Senior Oracle SQL, PL/SQL Developer
Kolkata
Summary
- Oracle Certified Professional (OCP) with 8+ years of experience in PL/SQL development and database programming.
- Expertise in stored procedures, functions, packages, triggers, dynamic SQL, ref cursors, collections, and bulk operations.
- Skilled in performance tuning, query optimization, indexing strategies, and partitioning techniques.
- Passionate about clean coding practices, performance improvements, and continuous learning, I bring both technical depth and problem-solving mindset to every project.
- Also have work experience in Core Java for 2 years and Clearcase administrator for 6 years.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Oracle SQL, PL/SQL developer
TATA CONSULTANCY SERVICE LIMITED
Kolkata
06.2018 - Current
- I have worked in SQL, Pl/SQL programming language for the last 7 years (Since 2018) and involved with a lot of development activities and daily life data analysis activities.
- In my last project My role and responsibility was developing a lot of reports using SQL, PL/SQL, Core JAVA and JSP technology.
- As a SQL, PL/SQL backend developer, My work was Writing a lot of Package, Procedures, function, trigger and also worked on collection, dynamic SQL, ref cursor etc.
- I used to write a lot of complex SQL queries for data retrieval and manipulation as per requirements.
- Involved with migration related activities where my work was that understand the logic written inside package, procedure, function etc and analyze them and accordingly prepare a document so that java developer could convert them to java code.
- Now I am looking for a project where my Oracle SQL, PL/ SQL knowledge is required. Also want to learn new skills and can achieve organisation goal.
JAVA developer
TATA Consultancy Services Limited
Kolkata
10.2015 - 05.2018
- I worked as a JAVA developer for about 2 years.
- I was involved for developing Java application using Java code and JSP technology.
- I was also involved with migrating a Java application to use postgreSQL.
- Design a report frontend page with JSP page which used to display information retrieved from server side application.
ClearCase Administrator
CMC limited
Kolkata
08.2008 - 10.2015
- As a team member of ClearCase Administrator & Version Management Team, I was involved in managing lifecycles of all the files which all the development module was using.
- I was also involved in testing actives of any solution product.
Education
Bachelor of Technology - Information Technology
The University Science Instrumentation Centre (USIC)
Skills
- Oracle SQL, PL/SQL
- Core JAVA, JSP
Certification
- Oracle Certified Professional (OCP)
- Microsoft Certified: Azure Data Fundamentals (DP-900)
- Power BI Data Analyst (PL-300)
- Azure fundamental (AZ-900)
Languages
- ENGLISH, HINDI, BENGALI
Timeline
Oracle SQL, PL/SQL developer
TATA CONSULTANCY SERVICE LIMITED
06.2018 - Current
JAVA developer
TATA Consultancy Services Limited
10.2015 - 05.2018
ClearCase Administrator
CMC limited
08.2008 - 10.2015
Bachelor of Technology - Information Technology
The University Science Instrumentation Centre (USIC)