BILAL AHMED KHAWAJA

Responsible for the enhancement, development and modifications of the Textile
Custom ERP. Core responsibilities to implement, enhance and communicate HR
and Payroll System, Stitching System to end users. Provide end user support to
the Textile ERP Application

Responsible for Database Administration, Installation and Configuration of Oracle9i/11g/12c Databases. Implement database backup strategy. Involve in performance tuning of Queries and Software Development of Different Modules.
Develop Dashboards for Cargo System and It complaint Support System on Power BI.

Achievements:
• Installation and Configuration of Oracle 11g Database Server for Port Qasim Official Website
• Migration of Oracle 9i Server to Oracle 11g Server
• Installation and Configuration of Oracle 9i/11g Database Server
• Installation and Configuration of Oracle11g Backup Database Server
• Installation and Configuration of Oracle10g Application Server
• Configure Power BI Report Server with SQL Server 2016

Tools Used: Oracle 19c/11g/9i Database, PL-SQL Developer, Oracle 6i/10g Developer Suite

Managing and Leading the Technical Team of Developers. Meeting with Management for meeting Deadlines and Project Planning. Reviewing Employee's Performance appraisal. Resume screening and filtering for new hiring of employees. Conducting Training Sessions for team technical review and technical upgrade. Responsible for database migration from TERADATA To Oracle using Oracle SQL/PL-SQL Queries and AMS System/JIRA. Worked on Database migration of KP (USA Hospital Network) from TeraData to Oracle. Attend Amazon Online Training for Databases Migration

Achievements: Migration of KP Teradata Database to Oracle Database

Tools Used: Oracle 12c Database, SQL Developer, JIRA, GIT LAB

Responsible for designing physical and logical flow of the applications and to implement, enhance and communicate Human Resource and Payroll Management System to end users. Design utility for data loading from MS Excel. EBS AND CUSTOM APPLICATION INTEGERATION. Responsible for Post Order Costing Module System designing, development and implementation. Provide end user support to the Textile ERP Application.

Tools Used: Oracle 10g/11g Database, Oracle 6i/10g Developer Suite

Responsible for designing physical and logical flow of the applications and to implement and communicate Group Health Systems and Group Life System with management and end users. Provide end user Support to Group Health Takaful Application. Develop software development project plan and responsible for reports development and QC of the GROUP LIFE SYSTEM.

Tools Used: Oracle 9i/10g/11g Database, Oracle 6i/10g Developer Suite, MS Project 2003, MS Visio 2003

Manage Team of developers and assign tasks. Responsible for designing the physical and logical flow of the applications. Implement and communicate the ERP System with Management and the End users. Provide End User Support. Design technical diagrams such as architectural design and entity relationship diagrams (ERD) and DFDs. Analyze, develop and implement the HOSIPITAL ERP SYSTEM modules such as:
• Inventory Management System
• Patient Cash Information System
• Company / Private Inpatient Billing System
• Company OPD Billing System
• Operation Theater Information System
• MS Office integration withOracle10g
• SMS System
• Machine Integration with Oracle10g through HL7 and XML
• LAB Information System
• Bar Code System
Configure Oracle 10g Database Server. Create and Import/Export Database Users. Manage Database and its Objects such as Tables, Indexes, Procedures and Triggers. Design and implement database backup strategy. Develop Database DDL Audit log.

Tools Used: Oracle 10g Database, Oracle 10g Developer Suite, Erwin 3.5, MS Visio 2003

Responsible for the development and enhancement of E.R.P product modules such as Sales, Purchase, Cash Management System, Fixed Assets, Plant Maintenance, System for different companies such as:
• Exide Batteries Pakistan Ltd
• Atlas Batteries Pakistan Ltd
Assist DBA in database related activities in Windows 2003 Server /LINUX 7

Tools Used: Oracle 9i Database, Oracle Developer 6i (Forms/Reports)

Responsible for the system design, development, enhancement and implementation of different modules such as Accounts Payable Information System, Airline Invoicing System

Tools Used: Oracle 9i Database, Oracle Developer 6i (Forms/Reports)

Responsible for the design, development and enhancement of HRMS product modules such as Time Management System & HR Management for different companies

Responsible for designing physical and logical flow of applications; communicate systems with management and end users. Design technical diagrams such as architectural design and entity relationship diagram and technical documents such as software requirement specification. Manage Database and its Objects. Devised and implement database backup strategy. Network configuration of oracle on server as well as client side. Analyze and develop Management Information System (MIS) modules such as:
• General Ledger System
• Employee Attendance Management System
• Store Stock Management System
• Garments Production Information System

Tools Used: Oracle 9i Database, Oracle Developer 6i (Forms/Reports), Erwin 3.5