Hayat Mohammad Khan

Working as a Senior Database and Security Consultant:

•MCB 60TB DB migration from IBM AIX Power 8 to Oracle 19c Exadata X8-2using Incremental XTTS migration approach.
•Physical standby preparation on Exadata and ZFS storage
•Migration and DB support for SNGPL from IBM AIX Power 7 to Exadata and Standby site preparation, IDM App & DB installation
•MIB DB migration from Sun T7 to T8
•OCI Content Management
•JAZZ ODI Active / Passive Cluster database Operations

Oracle Database Certification Track
•Taught Oracle Forms

in Information Security:

•Design and develop secure aggregation scheme for Smart Grid which will support :
•Fault tolerance
•Non-Technical loss detection using ARIMA and Machine Learning techniques
•Support multi party computation and resist against colluding parties
•Support statistical operations on cipher text data
•Data analysis using Oracle, and algorithm development through Python, Java

Senior Database

in the IT Department managing Databases& Applications Operations:

•Upgrade 11.2.0.3 to 11.2.0.4 and Apply Latest Security Patches
•Mediation DB \[RAC AIX Two Nodes with DR Site\]
•Online Bank Collection \[Windows Based, Singe Node with DR Site\]
•CNIC Verification \[Windows Based, Singe Node with DR Site\]

•Legacy Oracle 10g and 11g RAC DBs on RAW & GPFS Migration to Oracle EXADATA X4-2
•DB and Storage setup on Exadata X4-2
•Export Data using Data Pump and GG to Target DBs
•Testing and Verification on Exadata
•Complete Migration in less downtime using GG

•Eagle Eye Database migration from Oracle 10g RAW to Oracle 11gR2 RAC with GPFS
•Installation of Oracle 11gR2 with GPFS on IBM P7
•Migration of 10g Data to new Database
•Integration of Micro Strategy with new DB
•Patch update to 11.2.0.4

•ZTE Customer Care 10g Database upgrade to Oracle 11gR2 with ASM
•Installation of Oracle 11gR2 with ASM on IBM P7
•Migration of 10g Data to new Database
•Integration with Weblogic 11g and Other Application/DBs
•Create Disaster Recovery site with Single Instance

•Manager operations of Business Critical Applications
•SIEBEL CRM, ERP SAP, Billing & Customer Care, In-House Application
•24/7 Robust support structure
•Ensure Disaster Recovery Sites
•Preparation of SOP for troubleshooting and Performance Enhancement
•Implementation of Oracle DB Security Hardening.
•Designed the technical for each database
•Extract existing data for security Verification
•Produce report and mark each weak area score
•Implement and Secure weak area
•Implementation of CRM Project and managing its Database and Applications Servers layer.
•Designed the technical architecture of CRM Project
•Installed and Configured numerous SIEBEL Enterprise Components
•Managed the migration of legacy data
•Hardening of Database Layer by using Node addition/removal approach
•Switchover to DR Site, and use for 48 Hours
•Migration of Data Centers
•Participated in the development of the migration plan
•Participated in the preparation and verification of the new site
•Performed health Checks on Servers and managed backup of existing databases and application servers before physical migration
•Verified the integrity and started all the business applications after the physical migration
•Upgraded legacy Databases and Application servers for Billing and Customer Care Systems
•Participated in the deployment of upgrade plan preparation
•Preparation of test cases and its execution on test environment
•Deployed disaster recovery site and redirect end user traffic before start of upgrade process
•Upgrade of existing setup, fixed post upgrade issues
•Disaster Recovery Sites Preparation for all important Projects
•Preparation of disaster recovery sites for production critical applications
•Perform DR Drill to verify disaster recovery sites functionality
•Design and Implementation of ERP SAP IT Setup Systems.
•Design the technical blueprint of ERP SAP Infrastructure
•Install and configure three system SAP Landscape
•Helped in migration of legacy data
•Implementation of High Availability features in System landscape
•Manage the operations of all sap servers
•Implementation of Employees Separation Scheme Project.
•Collection and verification of Employees Master Data
•Software development for exist package calculation
•Development of tracking system for each Applicant case status
•Implementation of PTCL Payroll and MIS system
•Design and Develop HR Payroll and Management information system
•Develop process for monthly payroll execution and submission its data to finance department
•Employees Qualification, Family, Training, Punishments, Awards etc features development

in Pakistan Revenue Automation Private Limited:
•Development of Sales Tax Refund System
•Development of Centralized Sales tax refund system
•Bill of Imports, Bills of Exports, Monthly Sales Tax Return Submission
•Development and Administration of Tax Survey Project System
•Development and Administration of Centralized Repository for Tax Survey Project
•Development of Reports for Top Management
•Merging of data collected from different sources
•Development and Administration of Tax Return System
•Development of Income Tax Return Data Entry System
•Provide facility for Individual, Business Forms return data entry
•Development and Administration of National Tax Registration System
•Development of Centralized Repository for National Tax Number Generation
•Data duplication checks preparation
•Development and Management of CBR MIS System
•Develop Management Information System for Director of Training

at APCOM, PTCL