Abhishek Ghosal

About Abhishek Ghosal

I’m a Technical Analyst at Tata Consultancy Services (TCS). I work mainly with SQL, PL/SQL, and Java, and I enjoy building and supporting data-driven backend systems that are accurate, scalable, and reliable.In my current role, I support Oracle E-Business Suite (EBS) applications, especially Order-to-Cash (O2C) and Oracle Trading Community Architecture (TCA). My daily work involves handling large volumes of customer and transaction data. I have debugged 75+ PL/SQL programs, validated and reconciled 50k records, and improved SQL query performance by 20–25%. My core technical skills include:SQL & PL/SQL for writing queries, procedures, functions, triggers, and improving database performance.Java for backend programming and object-oriented development.Database design and Data Validation for reliable enterprise systems.AWS (EC2, S3, RDS, IAM, SNS, SES) and OpenStack (Nova, Swift, Cinder) to manage servers, storage and databases for development and testing environments.I am also 3× Oracle Certified, with certifications in Oracle Cloud Infrastructure (OCI)(1Z01•••25), Oracle Data Platform(1Z01•••25) and Oracle AI Foundations(1Z01•••25). I also have hands-on experience with cloud platforms. During my cloud engineering internship at IEMA R&D, I worked with AWS (EC2, S3, RDS, IAM, SNS, SES) and OpenStack (Nova, Swift, Cinder) to manage servers, storage, and databases for development.Along with industry experience, I have a research background. I have published my Research Work in the application of mathematics to engineering systems and have filed a Patent related to energy-efficient system design for drones.I am mainly interested in Backend Development, Cloud Architect and Database-Focused roles, where I can use SQL, PL/SQL, Java, and Cloud technologies (AWS & OpenStack) to build scalable and reliable systems.

Experience

1. Technical Analyst

   Tata Consultancy Services

   Feb 2025 — Present · Hyderabad, IN

   Data and backend-focused Technical Analyst supporting Oracle E-Business Suite (EBS) with heavy use of SQL, PL/SQL & Java. Focused on data accuracy, backend performance, and stable enterprise systems within O2C and TCA modules. Debugged and analyzed 75+ legacy PL/SQL programs to understand backend logic and data flow, enabling 100% on-time delivery during the project transition phase. Performed SQL-based data extraction and validation on 50K+ records across O2C and TCA tables, achieving ~99% data accuracy. Optimized complex SQL queries using indexing and query tuning techniques, improving execution performance by 20–25%. Supported backend processing for Oracle EBS O2C and TCA modules, ensuring correct customer and transaction data flow. Created 60+ technical documents and MoMs explaining backend logic and data workflows, reducing requirement gaps by 30%.

Education

• Burdwan Town School

  X

• University of Engineering & Management (UEM)

  Bachelor of Technology

• Burdwan Town School

  H.S.