Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ankit Ghosh

Hyderabad

Summary

PLSQL developer with 4 years of experience in application development, specializing in database design, optimization, and maintenance. Proven ability in performance optimization and troubleshooting complex database issues, ensuring efficient data integration. Committed to leveraging PLSQL and database management skills to enhance organizational success and support business objectives.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Packaged Application Development Senior Analyst

Accenture
Hyderabad
09.2024 - Current
  • Working for an international banking client in Risk Technology, onboarding a new application for Enterprise Product Risk Management for the firm.
  • Developing PLSQL solutions to integrate data between upstream and downstream teams, ensuring accurate data validation for reporting.
  • Creating new tables, views, triggers, functions, procedures, and packages as per data models.
  • Transforming data, creating views for reporting downstream applications.
  • Working on performance enhancement, creating new indexes, and audit procedures for faster retrieval of data in the UI and reporting downstream applications.
  • Using Bitbucket and Git Bash for version control and deployment of code in other lanes of the environment.
  • Developing software applications using Agile methodologies and collaboration tools.

Senior Systems Engineer

Infosys
Bhubaneshwar
06.2021 - 09.2024
  • Handled all phases of Software Development Life Cycle, ensuring timely delivery under tight deadlines.
  • Developed backend application programs, including tables, views, functions, procedures, and packages.
  • Created packages to retrieve complex data from remote databases using joins and subqueries.
  • Generated unique keys through sequences to support primary and foreign key constraints.
  • Constructed SQL and PL/SQL programs for data retrieval with cursors and exception handling.
  • Utilized Global Temporary Tables effectively in data processing tasks.
  • Prepared unit test cases and conducted unit-level testing for business requirements.
  • Optimized migration scripts through code reviews, performance testing, and partitioning of large tables.

Education

B.tech - Electrical Engineering

Calcutta Institute Of Engineering & Management
Kolkata
07-2020

Skills

  • PLSQL development
  • Version control systems
  • Toad for Oracle
  • SQL Developer for Oracle
  • Performance Tuning , Optimization
  • Bitbucket , GIT bash
  • SQL programming
  • Python(Intermediate)
  • Unix Shell Scripting
  • Autosys Workload Automation
  • Data Warehousing

Certification

  • Infosys Certified Oracle PLSQL Technical Consultant.
  • Oracle Integrated Cloud Fundamentals Associate.
  • Hackerrank SQL Intermediate Skill Certification
  • Hackerrank SQL Basic Skill Certification

Timeline

Packaged Application Development Senior Analyst

Accenture
09.2024 - Current

Senior Systems Engineer

Infosys
06.2021 - 09.2024

B.tech - Electrical Engineering

Calcutta Institute Of Engineering & Management

Similar Profiles

CREATE PROFILE
Ankit Ghosh