Afrid Mohammed

Oracle PL/SQL Developer having 2+ years of experience in Oracle PL/SQL development and optimization, with proficiency in Oracle and SQL Server. Skilled in writing and analyzing complex SQL queries, including stored procedures and triggers, and experienced with SQL and PLSQL Developer. Strong expertise in creating optimized PL/SQL code, complex SQL joins, updates, and selects, with a track record of reducing query execution time. Knowledgeable in RDBMS of Oracle Database, indexes, partitions, and index access methods, fixed bugs as reported and resolving database issues, having developed and optimized over 50 PL/SQL scripts.

Inventory Management System (Supermarket) –, Description: Comprehensive ERP Solution: The system integrates essential business modules including Inventory Management, Sales and Purchase Management, Accounting, and Finance Management to streamline and automate supermarket operations., Operational Efficiency: Designed to improve efficiency and provide real-time data insights, the software supports better decision-making and enhances overall management capabilities. Seamless Management: By handling daily business requirements effectively, the software ensures smooth and efficient operations, benefiting the overall management and functionality of the supermarket.

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Wrote SQL, PL/SQL programs required to retrieve data using cursors and exception handling.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Creating the indexes for performance issues to search the data quickly.
• Employed strategic problem-solving to enhance SQL query and procedure performance, addressing and resolving technical issues as they arose.
• Resolved numerous customer-raised tickets by understanding requirements and timelines, and making respective changes to database records.

I hereby declare that the above given information is true and to the best of my knowledge - Afrid Mohammed