Senior Oracle Developer
Ajman University of Science & Technology
مجموع سنوات الخبرة :16 years, 6 أشهر
Gathered, analyzed end users requirements and prepared Gap Analysis Report between existing system modules/processes and university requirements.
Involved in all phases of software development life cycle (SDLC) including: analysis, design, development, testing, implementation and support.
Ensured high quality delivery during all phases of the SDLC and ensured a right balance is maintained between quality, functionality, schedule and cost.
Assisted the project managers and IT manager with weekly and monthly status reports of application development, SDLC phase risks, and opportunities and on project status and completions.
Used best-practices when developing any piece of code.
Created detailed system design and architecture to support new system implementation efforts.
Translated university requirements and design specifications into technology solutions (Oracle Forms applications) and performed risk analysis related to these solutions.
Developed and maintained technical documentation including but not limited to design specifications, architectural diagrams, user guides, etc.
Worked with end-users, developers and DBA to research, document and resolve Oracle system issues.
Supported, advised, assisted, guided, and resolved problems for AUST’s clients to increase application availability, redundancy, scalability, and performance.
Provided solutions that reduce the need for customizations.
Performed Unit Testing and integration testing of developed system components to ensure the quality of delivered solutions.
Participated in training activities of new employees in the sector and/or the projects.
Managed users, roles, privileges, schema, object, and sessions.
Designed and supported integration between different applications and solutions in the university.
Participated in Upgrading client server application from version 4.5 to the latest oracle version 10G and Database from 9i to DB 11G,
Participated in data migration activities and developed the code for Data Migration/ Data Conversion for multiple modules.
Managed multiple tasks and projects simultaneously with attention to detail and quality, prioritizing workload efficiently.
Customized, modified, built, developed and designed forms and reports for SAS, SIS, HR and other ERP systems.
Developed various number of daily, weekly and monthly custom reports for the university to meet the requirements of various functions using Oracle 10g Reports.
Generated various reports on PL/SQL with output format in Excel/pdf/html.
Collaborated with team members to evaluate and recommend new software development technologies and development processes.
Designed, developed, tested, and implemented enhancements and maintenance to existing and new databases and applications in a client/server environment to fulfill university objectives related to new research or analysis opportunities.
Worked with various teams to identify and resolve performance issues within Oracle application environments at all levels including network, database, operating system, and application servers.
Maintained the security layer on the database and application le
Developed new PL/SQL procedures, functions, and triggers and also updating the old ones based on the change requests.
Developed managerial & Technical skills coordinating with my line manager & HR department(learn Java technology)
Participated in requirement gathering, analysis, design, development, performance tuning, code review, writing unit test scripts and supporting existing AUST applications
Generated and customized reports from AUST’s applications as per requested. According to AUST’s requirements.
Participated in migrating Data from SQL Server Database to Oracle Database.
I have been involved in developing many systems from scratch (Alumni System, Training System) using Oracle Database, Oracle Forms & Reports 4.5 including requirements definition, design, data conversion, testing, documentation, supervision, and progress reporting.
in
Student Information System (SIS)and Student Accounting System (SAS) Modules: Campuses and Buildings, Course Catalog, Faculty Load, Class Schedule, MajorSheets, Timetable, Academic Affairs, Admission and Registration, Student Information, Grade Recording, Registration Transactions, Academic Follow-up, GPA and AGPA Calculation, Graduation Procedures, Student Accounting, Financial Law, Revenue Calculations, Book System, Exemption and Scholarships, Finance Student Exception, Finance Resource Link, Student Academic Evaluation, Academic Staff Evaluation, Training & Short Courses, Financial Aid, Accommodation System(Hostel), Student Finance, Human Logic Web Admission, Alumni Association, Education continues center, Online Registration System.
in