AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF34556
profile image
Gangapuram B AXF34556 Active
PLSQL developer in Bengaluru
Having 6+years of Experience in Application development and Maintenance/Support projects using SQL,PL/SQL and Unix shellscripting with extensive understanding of different Application development tools and technology. Having good experience in SQL and PLSQL development using ORACLE 10g, ORACLE 11g and ORACLE 12C, ORACLE 19C.
Industries : IT Services Software
Share
Hire Gangapuram B
Download PDF
Availability
Full-time
Total experience
6 years
Technical skills
PLSQL
6 Years & 5 Months
SQL
6 Years & 5 Months
ODI
3 Years & 1 Months
unix
2 Years
Shell Scripting
2 Years
SQL
Projects
Citi
September-2024 to March-2025
Description
Citibank, is the primary U.S. banking subsidiary of Citigroup, a financial services multinational corporation.Citibank was founded in 1812 as City Bank of New York, and later became First National City Bank of New York.The bank has branches in 19 countries.The U.S. branches are concentrated in six metropolitan areas, New York City, Chicago, Los Angeles, San Francisco, Washington, D.C., and Miami.As of 2023, Citibank is the third-largest bank in the United States in terms of assets.Citi leverages its global network while maintaining a strong local presence in India. They offer expertise in various financial areas, including foreign exchange, cash management, and global liquidity management.
Roles and Responsibilities
Creating Indexes for performance issues to search the data quickly. Creating Triggers for enhanced validation and business logic management. Creating Functions, Procedure and sequences whenever used. Writing Queries, Sub-queries, Joins. Used Pragma Autonomous Transaction to avoid mutating problem in database trigger. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Using set auto trace on and explain plan for query optimization. Creating Cursors for dynamic operations at various levels as per the requirement. Analyzed slow-running queries using Explain Plan and optimized SQL joins and subqueries. Based on the mapping document we will create tables and write triggers for enhanced validation and business logic management.
Technologies: PLSQL, SQL
Industry: IT Services Software
Credit suisse
November-2023 to March-2024
Description
Credit Suisse is a global investment bank and financial services firm founded and based in Switzerland Headquartered in Zurich ,it maintains offices in all major financial centers around the world and provide services in investment banking ,private banking ,asset management ,and shared services it is known for strict bank-client confidentiality and banking secrecy .The Financial stability board considers it to be global systemically important bank credit Suisse is also a primary dealer and Forex counterparty of the Federal Reserve in the United states.
Roles and Responsibilities
Creating relational tables like, parent Tables with Primary keys and child Tables with Foreign key relationship. Creating integrity Constraints like not nulls, default values and check constraints where ever necessary. Creating Indexes for performance issues to search the data quickly. Creating Triggers for enhanced validation and business logic management Creating Stored Procedures for performance issues i.e. retrieving data or inserting data into the database will be quickly when comparing to normal insertion or selection or updating or deletion. Designed and implemented error-handling frameworks using exception procedures for better debugging. Creating Cursors for dynamic operations at various levels as per the requirement. Automated data validation and report generation using shell scripts and PL/SQL blocks.
Technologies: PLSQL, SQL
Industry: IT Services Software
Work history
Consultant specialist • September-2024 to February-2025
Description: Creating Indexes for performance issues to search the data quickly.Creating Triggers for enhanced validation and business logic management.Creating Functions, Procedure and sequences when ever used. Writing Queries, Sub- queries,Joins.Used Pragma Autonomous Transaction to avoid mutating Problem in database Trigger.Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.Using set auto trace on and explain plan for query optimization.Skilled in creating ODI interfaces, packages, scenarios, and integrating with PL/SQL-based validations and workflows.
Lead support Engineer • November-2023 to March-2024
Majesco
Description: Developed and optimized stored procedures, functions, triggers, and views for core banking modules.Handled large-scale data migration using SQL Loader and automated backend jobs with UNIX shell scripts.Improved query performance using Explain Plan, Oracle Hints, and indexing strategies. Implemented business logic through stored procedures and used Pragma Autonomous Transaction for exception handling.Participated in Agile ceremonies, sprint planning, and collaborated with cross- functional teams.Hands-on experience in Oracle Data Integrator (ODI) for designing and implementing ETL solutions including data extraction, transformation, and loading between
Lead consultant • December-2021 to April-2023
Genpact
Description: Designed PL/SQL packages for banking data workflows and validations. Implemented exception handling and optimized query performance. Developed triggers, materialized views, and procedures for finance modules. Worked in Agile mode with Jira for daily stand ups and sprint cycles. Automated data loads using SQL Loader and optimized data flows using Explain Plan and indexing strategies. Integrated UNIX shell scripts for batch j o b e x e c u tio n a n d ale r tin g.W o r k e d in A gile s p rin t s h a n dle d U A T issue fixes and production releases.
Senior PLSQL Developer • March-2021 to July-2021
Wipro
Description: Involved in all day to day activities related to database like data consolidation, data migration scripting.Worked on PL/SQL queries for creating data validation rules.Created complex views, materialized views on multiple tables as per customer requirement.Involved in creating Indexes for faster retrieval of data.Created PL/SQL stored procedures, functions and packages for calculation and database tables joins.Modified existing procedures, functions as per the Project requirements.Worked on SQL* Loader to load data from flat files obtained from various facilities every day.Created Cursors for dynamic operations at various levels as per the requirement.Used bulk collect for mass
Software Engineer • March-2019 to February-2021
TCS
Description: Creating Cluster tables along with index those columns are common in all the tables.Creating Indexes for performance issues to search the data quickly.Creating Triggers for enhanced validation and business logic management Creating Functions, Procedure and sequences whenever used. Writing Queries, Sub-queries, Joins.Using Optimization Hints to improve the query performance. Monitoring the jobs in UC4 Tool. Checking log files in the WINSCP Tool. Creating HPSM
Software Developer • October-2017 to February-2021
Cognizant
Description: Monitoring and Handling the errors and incidents and do further Investigation.Ordering the certificates in ServiceNow for the client’s authentication Purpose. Track the incident Activities and communicating with other teams which is related to the problem. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application Using set auto trace on and explain plan for query optimization Using Optimization Hints to improve the query performance.Resolved production issues by modifying backend code as and when required. Extensively used bulk collection, for all statement in PL/SQL objects for improving the performing.
Education
Masters degree in Computers
Sri Venkateswara University
2012 to 2015
Language
English - Advanced