Zain ul abadien
Oracle Database Developer | Administrator at PRAL, FBR- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
PRAL, FBR
-
Pakistan
-
IT Services and IT Consulting
-
500 - 600 Employee
-
Oracle Database Developer | Administrator
-
Jun 2021 - Present
Coordinated with the front end design team to provide them with the necessary stored procedures and packages, functions and the necessary insight into the data. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for Reporting purposes on the refresh of Oracle supply packages. Created indexes on the tables for faster retrieval of the data to enhance database performance. Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, and AUTOTRACE. Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. Creation of database objects using oracle tools like Toad, PL/SQL Developer ,SQL Developer and SQL* plus. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Used advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL Collaborated with product management to design, build and test systems. Experience in Database Application Development, Query Optimization, Performance Tuning Configuring IRIS National Income Tax / Sale Tax Returning System. Moving the data from the staging area to production. Maintain and secure databases to ensure efficient operating for all users. Perform routine tests and produce reports. Coordinating with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. Involved in the continuous enhancements and fixing of production problems. Create a complete DNFBP Module. Show less
-
-
-
Inbox Business Technologies
-
Pakistan
-
IT Services and IT Consulting
-
500 - 600 Employee
-
Associate Technical Consultant
-
Sep 2019 - May 2021
Created scripts to create new tables, views, and queries for new enhancement in the application using TOAD, PL/SQL Developer, SQL Developer. Created indexes on the tables for faster retrieval of the data to enhance database performance. Experience in Database Application Development, Query Optimization, Performance Tuning, and DBA solutions and implementation experience in complete System Development Lifecycle. Designed and developed OAF forms & reports. Configure, test, deploy, support, and troubleshoot application systems to meet business process requirements. Analyze and document customers’ business needs, application system requirements, configurations, workflows, processes and procedures. Evaluating existing IT infrastructure and recommending system improvements. Developing and configuring customized ERP solutions. Writing programs and scripts to design user-friendly interfaces and optimized functionalities. Deploying ERP solutions and ensuring seamless system integration. Running diagnostic tests and resolving issues to enhance performance. Providing ERP end-user training and technical support. Documenting ERP processes and preparing deployment progress updates. Module on which I working are HR Module Finance Module LMS Module Show less
-
-
-
Masood Textile Mills Limited
-
Pakistan
-
Textile Manufacturing
-
700 & Above Employee
-
Assistant Officer
-
Jan 2018 - Nov 2018
As surveillance officer my responsibilities are Design a security plan and implement it through CCTV cameras. Collecting evidence of illegal activity or collecting information that may be used as evidence in legal proceedings. Conducting internal investigations of employee misconduct or work performance issues. Reporting security breaches or safety hazards to supervisors. Monitoring the activities of guards in real time using computers to help identify any problems that may arise. Show less
-
-
Education
-
Government College University, Faisalabad
Bachelor of Science - BS, Computer Science -
Govt College of Technology Faisalabad
DAE, Electrical and Electronics Engineering