Arsalan Khan

Involved in the development and modernization of HMIS (Hospital Management
Information System) in collaboration with Shaukat Khanum Memorial Cancer Hospital,
transitioning legacy systems from Oracle Forms & Reports to Oracle APEX.
• Designing and developing scalable, web-based applications using Oracle APEX, Oracle SQL,
and PL/SQL.
• Contributing to the redesign and enhancement of core hospital modules including
Registration,
OPD/IPD, Emergency, Billing, Pharmacy, Lab, Radiology, HR/Payroll, Accounts, Inventory,
OT, Blood Bank, and Wards.
• Implementing new features, workflows, and system customizations based on business and
management requirements.
• Developing interactive reports, dashboards, and data-driven solutions to improve decision
making and operational efficiency.
• Ensuring performance optimization, data integrity, and smooth system functionality during
the migration and post-deployment phases.

An MIS Assistant (Management Information System Assistant) is responsible for managing, analyzing, and reporting organizational data to support management decisions. The role includes preparing reports, maintaining databases, ensuring data accuracy, and assisting in the development and support of information systems.

In my role as an MIS Assistant, I am responsible for generating reports, managing databases, developing SQL queries, maintaining hospital information systems, and providing technical support to users. I also assist management by providing accurate data analysis and reports for decision-making purposes.

A Junior Oracle Developer is responsible for assisting in the development, maintenance, and support of Oracle database applications and systems. The role includes writing and optimizing SQL and PL/SQL code, maintaining database objects, troubleshooting issues, and supporting database-related projects to ensure efficient system performance.

In my role as a Junior Oracle Developer, I am responsible for developing and maintaining SQL and PL/SQL programs, creating and optimizing database queries, supporting Oracle database applications, troubleshooting technical issues, and assisting senior developers in implementing database solutions. I also contribute to system enhancements and provide accurate data solutions to support business operations and decision-making.