Senior Oracle Developer
SamaPay For E-Payment
Total years of experience :16 years, 6 Months
Design and build reports (Central Bank statistics, Biller statistics, Merchant statistics, Cards statistics, Clearing, reconciliation…….)
Oracle integration.
Write procedures for send important reports by Email
Update System's packages according to business s' requirements.
Database Monitoring: (
- Create rman and DMP backup scripts
and check backup daily.
- Check Capacity Planning (Tablespaces, Disk
group space, archive log ..)
- Implement and maintain database security
(create and maintain users and roles,
assign privileges)
- Implement and create OBJECT for development
team
- Check Listener, DR daily)
Tracking stuck transaction's.
- Execute Backup Plans (Daily, Weekly).
- Extracting reports and Finance Statements by Core Banking System.
- Supporting Bank's Systems (Core banking, Archiving and others).
- Lead Team for design and developed exclusive Application to process finance reconciliation between The tow partner : first the our company and all banks (BBSY, BBSF, SIIB, BYBLOS, CBS … )
- Design and develop procedures for load data from external Files using utl file package.
- Write complex queries, views, inline view, functions according to accountants requirements and extracting data to XLS files
- Manage and release the application to training, UAT, production environment
- Provide technical and functional directions for users application
- Developing and maintaining Health Insurance, Divan Section in Syrian engineering syndicate
- Design and development reports according to business needs.
- Write Queries and create Views, Temporary tables, functions to retrieve Complex Data from DB.
- Write procedures for exporting, importing data to XLS files.
- Write Procedures for Merging and Synchronizing Data Between Main Head And all Branches.
- Developing and maintaining Payroll system and HR system for General Aviation Company.
- Participated in analysis, design, coding, testing and implementation of major blocks for the syndicate ERP system developed by the Global (Syrian IT Company), this system is responsible for automating the engineering syndicate process
and will be distributed over 14 engineering syndicate branches in the country.
- Create and maintain database objects: Tables, views, Procedures, functions, packages, Constraints, indexes, sequences, triggers and synonyms.
- Designing and building all migration procedures and testing scripts responsible for moving data from diverse old legacy systems and integrating them into the new ERP system.
- Write Merge statements to synchronize data between central instance and remote instances.
- Create Scripts for daily backup Database.
- Provide daily production support of ERP system
- Implementing advance search application to facilitate extracting data and export result with many formats : csv, pdf, html
- Designing, coding, testing and implementation of Land register
management system for : General Agency for Palestinian refugees
- Create and maintain database objects: users, tablespaces, tables, views,
synonyms, sequences, procedures, functions.
- designing and implementing the reports related to the Human Resource Management system
- Designing and building procedures for migrating data from old system into the new system.
- Manage daily backup database.
First Project : Ministry of housing
- Developing, coding, testing of Financial systems (Payroll system, warehouse management system, budget system).
- Create and develop Database objects as: tables, views, procedures, functions, packages, Sequences, synonyms, and Triggers.
- Developing Forms and procedure for initiating script 's salary domiciliation.
- Create procedure and scripts for migration data form MS Excel and MS Access to financial system.
- Building and developing reports as Ministry needs.
Second Project : Ministry of Defense - Social Military Establishment
- Developing, coding, and testing of warehouse management system.
- Create and maintain Users, Tablespaces, tables, views, procedures, functions, Sequences, and triggers.
- Create indexes to enhance performance of system.
- Write queries, views, inline view, functions according accountant needs and export data to csv files.
- Developing and designing statically reports.