➢ A supply chain is a network of facilities and distribution options that performs the functions of procurement of materials, transformation of these materials into intermediate and finished products, and the distribution of these finished products to customers.

➢ Understand demand pattern plays key role for success of industry.

➢ New products arrival, trend and season changes customer demand.

➢ SAP provides solution to forecasting, planning and optimization by considering sales history and all above facts.

➢ Data Consolidation Module (DCM) is a major business initiative in Supply Chain Operations.

➢ DCM is a planning legacy system that gathers information from multiple systems and processes the inbound data and sends the outbound data in a format that is acceptable by SAP system.

➢ DCM is critical in terms of production planning pertaining to factories and equipment’s over a period of time and to use this capacity information to derive production schedules in SAP which will be more accurate and realistically achievable .

➢ This Project is developed for Bank Tabungan Negara which is a banking service provider in Indonesia. This project has various modules like, cash receipt, cash payment, transfer module.

➢ Analyzing the business requirements of the projects by studying the Business Requirement Specification document.

➢ Creating indexes on the tables for faster retrieval of the data to enhance database performance.

➢ Creating database objects like tables, views, materialized views, procedures, packages using oracle tools like TOAD.

➢ Implementing several triggers to maintain Database Security by auditing log table to track information about users.

➢ Writing complex SQL queries including sub queries for faster data retrieval from multiple tables.

➢ Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

➢ Using for all and Bulk collect to fetch large volumes of data from table.

➢ Using Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Master Health was designed and developed for Indo-American Cancer Hospital (A Super specialist Hospital offering distinguished medical and theraphatic services around the clock). This project is basically providing sophisticated software for the automation of the various transactions in the hospital. It includes total 27 modules like Security, Registration,
Doctor Ap pointments, Inpatient, and Outpatient, Investigative lab Services, Housekeeping, Radiology, O peration Theatre, Finance and Accounting with Reports.