18+ years of experience in IT Industry including
- System Analyzing, Designing Development
- Database Administration
Presently Working as Sr. Software Engineer
Thesis on identifying and prioritizing the Requirement Engineering problems through system defects
MAJOR SKILLS
- System Analyst/Programmer
- Oracle Developer Forms/Reports ( 10g,9i, 6i )
- Database Administration of Oracle 10g,9i
Responsible for System Analysis, System Designing, System Development, and the modifications of the Textile Custom ERP. Core responsibilities to System Analysis, Design and implement enhancements, and communicate HR and Payroll System, Stitching System, and Export System to end users. Provide end-user support to the Textile ERP Application.
Tools Used: Oracle 10g/11g Database, Oracle 6i/10g Developer Suite
Responsible for the Database Administration, Installation and Configuration of Oracle9i/11g/12c Databases. Implement the database backup strategy. Involve in performance tuning of Queries and Software Development of Different Modules
Achievements:
Installation and Configuration of Oracle 11g Database Server for Port Qasim Authority Official Website
Migration of Oracle 9i Server to Oracle 11gServer
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 Server2016
Tools Used: Oracle 12c/11g/9i Database, PL-SQL Developer, Oracle 6i/10g Developer Suite
Responsible for database migration from TERADATA Database to Oracle Database for KP (USA Hospital Network) using Oracle SQL/PL-SQL Queries and AMS System/JIRA. Work on Oracle to SQL Server and Oracle to MySql Database Migration
Achievements: Migration of KP Teradata Database to Oracle Database 12c
Tools Used: Oracle 12c Database, SQL Developer, JIRA, GIT LAB
Responsible for System Analysis and design physical and logical flow of the applications and to implement, enhance and communicate Human Resource and Payroll on System to end users. Design utility for data loading from MS Excel. Worked on Oracle EBS and Oracle Custom Application Integration. Responsible for the 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.
Tools Used: Oracle 9i/10g/11g Database, Oracle 6i/10g Developer Suite, MS Project 2003, MS Visio 2003, ORACLE JDEVELOPER ADF
Manage Team of developers and assign tasks. Responsible for designing physical and logical flow of the applications. Implement and communicate systems with management and end users. Provide end user Support. Design technical diagrams such as architectural design and entity relationship diagrams (ERD) and DFDs. Analyze, develop and implement 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 with Oracle10g
• 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
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 such as:
• Atlas Batteries (Pvt.) Ltd.
• MaxCo Textile Industries (Pvt.) Ltd
• Shirazi Investments Limited
• TRG (Pvt.) Ltd
• ColorItal (Pvt.) Ltd
Tools Used: Oracle 9i Database, Oracle Developer 6i (Forms/Reports)
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