At CAMS, Karachi, Sindh, Pakistan.
Working on the development and maintenance of the Student Management System (SMS), Payroll Management System, Library Management System & General ledger (GL).
Main responsibilities include:
Upgrade, maintain and troubleshoot Oracle Forms and Reports.
Resolve issues with Oracle 6i Forms/Reports application, such as workstation using side printers for slip printing and other reported problems.
Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built-in as well as User-defined functions and procedures.
Create Database Objects like Stored Procedures, Views, Triggers and functions.
Create PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
Create stored procedures and functions to support efficient data storage and manipulation.
Developed List of values to populate data in certain conditions based on Record Groups.
Developed various new reports from scratch utilizing Oracle Reports Builder for day-to-day validations.
Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus.
Providing support to end-users as required.
Conducting periodical meetings with high level management to discuss the development and maintenance processes.
Participated in coding, testing, and designing, debugging, configuring, and documenting new and existing software applications.
Develop new application Digital Planner from Scratch to till end. This System which automates the complete lifecycle of School and College Curriculum activity Important information, including Student E-diary, Course Plan, Course Outline —ASP.net C#.
Develop Bio-metric Attendance Management System from scratch to till end as a team leader. This is a complete web-based Attendance Management System which offers employee scheduling, time & attendance (time clock, timesheet), human resource management (HRM).— ASP.net C#.
Develop Time Management System for a law firm. This firm charge client to hourly basis and system working with time and calculate the minute/hours and charge to client with automated process.
Develop various new Forms, Reports from scratch utilizing Oracle Forms and Reports Builder. ORACLE 6i and 11g.
Create Database Objects like Stored Procedures, Views, Triggers and functions.
Create PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
Create stored procedures and functions to support efficient data storage and manipulation.
Developed List of values to populate data in certain conditions based on Record Groups.
Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
Developed MyCAMS a portal that links students, many of your student records are maintained on the portal by the Registrar and available for viewing. Important information, including attendance & financial records and grade submissions also develop online payment integration with HBL payment gateway. — PHP, HTML, CSS, and JavaScript.
Develop new module (Faculty Payroll) in existing application (cPlan) for Account department. This system is being developed to every one of Faculty members Salary, Tax record keeping. — VB 6and MS SQL Server.
Develop new module in existing application (CBE Exam Management System) This System which automates the complete lifecycle of CBE Exam Management System. Revolutionizes the entire examination process by diligently meeting the requirement of the college. — ORACLE 6i and 11g.
Develop new module Exam Management System from scratch to till end. This System which automates the complete lifecycle of Exam Management System. Revolutionizes the entire examination process by diligently meeting the requirement of the School and college. — ORACLE 6i and 10g/11g.
Awarded for completing the Oracle Developer Live: Java Innovations March 2021 workout