Ganga Sagar Pal
Lucknow
Summary
Resourceful PLSQL Developer known for high productivity and efficient task completion. Specialize in database design, query optimization, and performance tuning. Excel in problem-solving, critical thinking, and teamwork, ensuring successful project outcomes through effective collaboration.
Overview
3
3
years of professional experience
Work History
PLSQL Developer
Coforge
Greater Noida
03.2022 - Current
- Developed stored procedures, functions, and packages using PL/SQL to support the application development needs.
- Involved in Performance Tuning activities like creating Indexes, Partitioning Tables.
- Designed complex database objects like tables, views, triggers and indexes as per business requirements.
- Assessed code during testing stage to determine potential glitches and bugs.
- Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
- Created test cases for unit testing of new or existing PL/SQL code.
- Optimized SQL queries for better performance by analyzing execution plans and query optimization techniques.
- Identified and resolved various issues related to data integrity, security and performance tuning in Oracle databases.
- Performed debugging of existing PL/SQL code as part of bug fixing activities.
- Implemented exception handling mechanism using error logging package in PL/SQL.
- Participated in Database Design Discussions with Business Analysts and Application Teams.
- Analyzed user requirements and developed stored procedures to meet those requirements.
Education
Bachelor of Technology - Computer Science
Shri Ramswaroop Memorial University
Lucknow, India07-2022
Class 12th -
Kendriya Vidyalaya
Lucknow, India03-2017
High School Diploma -
Kendriya Vidyalaya
Lucknow, India03-2015
Skills
- SQL development
- Agile development methodologies
- Performance Tuning
- Code debugging
- Quality Assurance Testing
- Relational databases
- Java
- Database Development
- Jira and Confluence
- Data Validation
- Oracle platform proficiency
- Software development proficiency
- Database Design
- Data extracting
- Data integration
- Teamwork and Professionalism
Languages
Hindi
First Language
English
Proficient (C2)
C2
Project - SEI Technology and Investment Solutions
- For the past two years, I have worked on a project with SEI, a company that delivers technology and innovative solutions to help clients drive growth and make informed decisions. As part of the SEI Wealth Management team under ADS Cody, my primary responsibility has been to develop features for various firms, including trust companies, banks, and high-net-worth individuals (HNI), enhancing their experience on the SEI Wealth Management platform.
Timeline
PLSQL Developer
Coforge
03.2022 - Current
Bachelor of Technology - Computer Science
Shri Ramswaroop Memorial University
Class 12th -
Kendriya Vidyalaya
High School Diploma -
Kendriya Vidyalaya
Similar Profiles
Kushal SharmaKushal Sharma
Senior Application Support Engineer at COFORGESenior Application Support Engineer at COFORGE
Yaman AbidiYaman Abidi
Senior Associate – PMO at CoforgeSenior Associate – PMO at Coforge
Sandeep NegiSandeep Negi
Associate Manager at CoforgeAssociate Manager at Coforge