Feroz Ahmad

• Having more than 3 years of experience as Oracle (PL/SQL) developer along with Windows
• Proficient In writing SQL queries, Cursors, Sub programs like Procedures, Functions, Packages and Triggers in PL/SQL
• Having good knowledge of Index by table, nested table, varray, refcursor, and pl/sql record
• Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
• Having good knowledge of using bulk bind process and avoiding mutating errors
• Good knowledge about schema objects like views, sequences, indexes, synonym and external tables
• Having good skills in using SQL
• Loader and UTL_FILE package
• Having good knowledge of displaying data from multiple tables using joins
• Having good Knowledge of Exception handling and error logging process.
• Maintained existing software systems by identifying and correcting software defects.
• Developed scalable and maintainable code, ensuring long-term stability of the software.
• Collaborated with clients to define solution requirements.
• Updated old code bases to modern development standards, improving functionality.

Description: Developed stored procedures, triggers, and functions using PL/SQL to manage data integrity and automate business logic , a software solution tailored for microfinance companies, ensuring efficient data storage and retrieval. Optimized SQL queries and database performance to enhance system responsiveness and scalability, resulting in improved user experience .

Responsibilities and Achievements:

• Collaborated with cross-functional teams including software engineers, business analysts, and quality assurance testers to understand requirements and implement database solutions accordingly.
• Provided technical support to client microfinance companies, diagnosing and resolving database-related issues promptly to maintain high system availability and reliability.
• Created PL/SQL stored procedures to automate data manipulation tasks, improving efficiency and accuracy in data updates and retrievals.
• Participated in agile development processes, attending sprint planning meetings and contributing to backlog refinement sessions to prioritize and estimate database

• Completed comprehensive training in PL/SQL development, gaining proficiency in writing and optimizing SQL queries, creating stored procedures, triggers, and functions, and managing database performance
• Enhanced database performance by optimizing SQL queries and indexing strategies.
• Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Developed custom database objects, stored procedures and delivered application support.

• Coordinating with clients to start projects and manage relationships with stakeholders until the projects are completed
• Inspection of pipelines by visiting the sites throughout the country and reporting inspected results to the project manager
• Identification of defects in Pipelines by visiting sites and partnering with concerned team members to draw action plans to resolve the identified defect
• Coordinating with the ground team and executing rectification of defects.