Walid Ghanem

Analyze complex business problems and determine an IT solution
Gather data and analyze business and user needs and define objectives and scope of business system.
Development of SRS documentation to be used by developers, testers and implemneters.
Work closely with managers and end users to determine best IT solution
Desing data model including tables, indexes (B Tree, Bitmap and Function Based), views and materialized views.
SQL and PL/SQL performance tuning and Application tuning using Cost-Based Optimization (CBO), Query Optimizer, SQL Profile, Explain Plan, SQL*Trace, TKPROF and AUTOTRACE.
Design Data warehouse including data model star/snowflake schema, ETL code using PL/SQL, Golden Gate Configurattion for Data Sync, partitioned fact tables and materialized views to enhance performance.
Collaborate with DBAs to enhance stability and identify bottlenecks.

Some of projects :-
NPHIES Integration
Integrate Oasis System with payers (insurance companies) to automate patient journey from Eligibility Check, pre Auth Request, Claim Submission to Payment Reconciliation

Pharmacy PDA — Control Items from receiving to Patient delivery
Control Drug transactions from receiving in hospital store till delivery to the patient using handheld computers like Zebra. Solutions consists of Android Application on the Handheld, APIs developed by Spring boot which connects to Oracle Database and PL/SQL Packages to handle drug transactions.

RSD Integration - Drug Track and Trace for pharmaceutical products
Integrate Oasis System with RSD system using RSD Rest APIs using PL/SQL Packages to notify Saudi Drug Authority about the current location of any Drug unit by GTIN and Serial No for Each Box.

Bupa Integration - Healthcare insurance Company Integration
Integrate Insurance processes with Oasis HIS System using Bupa Rest APIs starting by membership validation, pre-authorization approval requests till claim submission.

Pharmaflow Integration
Integration between hospital Drug stores, pharmacies and wards with Pharmaflow dispensing machine.

-Design data model including tables, indexes (B Tree, Bitmap and Function Based), views and materialized views.
-Developing functions, procedures, trigger and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Extensively use of PL/SQL like Records, PL Tables, Object Collections, DBMS Packages and Dynamic SQL, Transaction control.
Develop PL/SQL, Java programs, Rest APIs using Java, Jersey, Spring Boot … etc. to integrate with other systems/machines like Payment devices, Radiology Lab Analyzer, Pharmacy Dispensers, … etc.
SQL and PL/SQL performance tuning and Application tuning using Cost-Based Optimization (CBO), Query Optimizer, SQL Profile, Explain Plan, SQL*Trace, TKPROF and AUTOTRACE.
Design Data warehouse including data model star/snowflake schema, ETL code using PL/SQL, Golden Gate Configuration for Data Sync, partitioned fact tables and materialized views to enhance performance.
Collaborate with DBAs to enhance stability and identify bottlenecks.
Developing Shell Scripts for both Linux/Windows.
Creating and Modifying Forms & Reports in the operational system using Oracle Forms Builder and Oracle Reports Builder BI Publisher.

Manage the development team to produce web-based complete solutions using different technologies doing the following activities:
• Gathering and analyzing the user requirements
• Presenting proposals to clients
• Designing the database and developing the code for the solution using the appropriate technology and framework
• Testing the application for all aspects like usability, functionality, user friendly, performance, reliability …
• Implementing the applications
Some examples of these applications:
Learning Management system: Develop a solution using Moodle LMS for ACCL (Abdul Latif Jameel Continues Learning Center) to manage the learning process for Courses, instructors, trainers and exams
and get a full details statistics about all the activities in the learning process
Polyclinic System: Gathering the Customer requirements to develop a polyclinic system and begin the analysis of the system ( the project is just beginning)

Manage all the processes for the development life cycle of web applications and web sites using different technologies by directing the team doing the following activities:
• Gathering and analyzing the user requirements
• Presenting proposals to clients to enhance the benefits from the application
• Designing the database and developing the code for the site using the appropriate technology
• Testing the application for all aspects like usability, functionality, user friendly, performance, reliability …
• Implementing the applications
Some examples of these applications:
Web Based DBMS for Pharmacological Trading: to manage all the functional units: financial, inventory, payroll, purchase, sales, telesales, customers, suppliers, shipping management. Each company may have several nodes (branches) and each branch may have several stores and points of sale connected together via VPN. This Application has two releases .Net release and Oracle release. This includes writing DB procedures & triggers, creating classes, forms, web forms, reports and charts.
School Administration system: to manage courses enrollment, students fees, E-learning courses, teachers hourly rates, Exams control, Students assessment and online final results using PHP/MySQL Technology.
Library borrowing Application: to manage a DB for all published media on the library (Books, Journals, Audio, Video, …) with all info and e-doc for some of them. Managing the borrowing process using PHP/MySQL Technology.

Responsible for analysis and development of desktop/web applications using different technologies.
The detailed work activities were:
• examine existing business models and flows of data and discussing findings with the client
• Produce outline designs and costing of IT systems to discuss them with the client
• Creating logical and innovative solutions to complex problems.
• Drawing up specific proposals for modified or replacement systems.
• Presenting proposals to clients.
• Working closely with developers to design database and programming modules
• Meeting with clients to ensure user satisfaction
• Working closely with testers to drawing up a testing schedule for the complete system.
• Overseeing the implementation of a new system.
• Planning and working flexibly to a deadline.
• Writing user manuals.
• Providing training to users of a new system.
Examples of them :
Ready-made clothes manufacturing DBMS: to manage all the functional units: financial, inventory, payroll, purchase, sales, telesales, customers, suppliers, shipping management. Manufacturing management with all phases:
Raw material management, manufacturing orders, intermediate products, final products, quality management, outsourcing, … using .Net Technology. This includes writing DB procedures & triggers, creating classes, forms, reports and charts.
Real Estate Installments Management Application.
Point of Sale Application.

Responsible for analysis, designs, development, testing, maintenances, and implementation of a complete IT solution for the factory system including financial system (Accounting, Payroll, Customers/Suppliers, HR) and Manufacturing Process (Resource Planning, Product Cost, Orders Planning…) using client/server technology.
The detailed work activities were:
• Establishing a detailed program specification through discussion with different departments.
• Designing database and programming modules using UML
• Clarifying precisely what actions the program is intended to perform.
• Breaking down program specification into its simplest elements and translating this logic into a programming language.
• Combining all elements of the program design and testing it.
• Testing sample data-sets to check that output from the program works as intended.
• Reacting to problems and correcting the program as necessary.
• Installing the program and conducting final testing.
• Evaluating the program's effectiveness.
• Increasing program operating efficiency and adapting to new requirements, as necessary.
• Conducting user acceptance testing to ensure the program can be used easily, quickly and accurately.
• Recreating steps taken by the user to locate sources of problems.
• Writing detailed documentation for the operation of the program by users and computer operators.

Developing Applications in different fields using MS-SQL, Visual Basic, Microsoft Access, Visual C++, …
Some examples of these applications were:
DBMS for a furniture factory : the system manages the financial process, accounting system, stock control, import/export process, payroll, point of sale, production process, product manufacturing cycle, raw material cycle, production planning.
Programs for clinics, pharmacies, super markets…., using MS SQL Server & Visual Basic

implementing Telecommunication Network

Developing Database Applications using DBase III+, Microsoft Access, Visual Basic.