Naveed Hussain

Utilized data warehousing concepts to streamline Data Management Processes.
I having performing my duties at Allied Bank Ltd. as vendor for Database Architecture & Integration by our company.
Designed, developed, and maintained databases to ensure data integrity and performance and data mapping. Query Optimization. Packages, procedures, functions, Jobs, Indexing, Partitioning, View, Cursor, Loop, External Tables, Parallel Quries and Bulk collect. Created front-end forms and reports tailored to the needs of end-users and management. Developed and monitored ETL processes to ensure accurate and efficient data transfer.
Involved in developing new modules and maintaining existing ones to enhance system functionality.
Used Oracle APEX 21.2.0 for application development and deployment.

Managed the design and development of PL/SQL programs, including packages, triggers, stored procedures, and functions, Jobs, Indexing, Partitioning, and Views.
Forms and Report Development.
Proficient in SQL optimisation and advanced SQL queries.
Led a team to achieve desired results within the time frame.
Utilised front-end development skills.

Tools/Technology/Environment: PL/SQL, SQL, Oracle, PL SQL Developer, Toad
Analyzed and gathered data for new software requirements.
Designed, developed, and checked the database for Production Management.
Developed front-end forms and reports meeting user and management requirements.
Actively involved in creating procedures, functions, packages, triggers, and jobs scheduler for email alerts.
Implemented and maintained existing software.
Created and optimized SQL queries, indexes, complex views and materialized views.

Roles and Responsibilities:
Creating PL/SQL tables, packages, procedures and triggers with the use of cursors
Created multiple complex oracle queries that were used to fetch and manipulate data in Procedures/functions etc.
Working on enhancements raised in the project and business requirements of the
application
Troubleshooting and fixing the error if found in diferent environments like Test, Quality Assurance and Live
Created Dynamic LOVs.
Created indexes on the tables for faster retrieval of the data to enhance database
performance
Worked on cursors and ref-cursors
Create Jobs Scheduler to run the alert Procedures.

Roles and Responsibilities:
Analyzing and Data gathering to meet the requirements of the new demanding software
Design, Developed and check the Database.
Design Front end Forms, Reports which meet the requirements of the end users and managements.
Development of multi - Software to meet the needs of the company,
Create Procedure, Functions, Triggers, Jobs
Email Alerts by Oracle
Implementation of new system and teaches the end user of this new system and maintaining existing Softwares for the better production.