- Data analysis for different data set extraction- Prepared different data stats through IBM Cognos BI tool for higher management analysis- ETL, data cleansing, data purging and Archiving, Integration and Data migration.

♦ Project: Emirates Identity Authority, UAE (Back Office & Portal Application)♦ Key Achievement: - Work on different stories related to new DB development - Work on DB Patches and Hotfixes - Provide the production support - Work on release management for production deployment - Resolved implementation and post-production issues - Data migration through Informatica into Main Database from different data sources♦ Project: Vision eForm (Online Individual Visa System, Dubai UAE)♦ Key Achievement: - Work on different DB development releases and patches - Provide the production support - Work on release management for production deployment - Work on Vision eForm baseline DB scripts - Data cleansing of the different Database schemas in data quality activity through Informatica♦ Project: Legacy & Vision eDnrd (Online Establishment Visa System, Dubai UAE)♦ Key Achievement: - Work on different DB development releases and patches related to Vision and Legacy eDnrd - Design and develop VAT engine for Legacy and Vision eDnrd - Data Migration of VAT data of missing months through Informatica ETL development - Different monitoring job development through Informatica for management stats analysis - Implement DBMaintain tool for DB scripts auto deployments - Provide the Legacy and Vision eDnrd production support - Work on release management for production deployment - Work on Payment receipt module - Work on Fee Calculation Engine - Work on rest service development for Smart Channel Integration - Work on Vision eDnrd baseline DB scripts

♦ Project: Centralized Transport Department Automation System - Punjab.♦ Key Achievements: - Re-design and implemented RTA (Regional Transport Authority) and PTA (Punjab Transport Authority) user level changes in Route Permit, Fitness Certificate modules. - Designed and developed new stand types in Bus Stand Module. - Implemented different district data access restriction logic in different modules of CTDAS.♦ Project: Centralized Driving License Information Management System – Punjab.♦ Key Achievements: - Re-design and implemented the Traffic Violation Module. - Implement multiple booth Data handling in CDLIMS project. - Implemented different district data access restriction logic in different modules.♦ Project: LeasSoft Asset – Contract Management System (CMS)♦ Key Achievements: - Analysis and work on CMS calculation engine. - Work on different patches and hotfixes.

♦ Project: Hospital Management Information System.♦ Key Achievements: - Re-design and implemented IPD and OPD medication process in HMIS. - Implemented new features in ECHO, ETT and Pharmacy Modules. - Designed and developed the Inpatient Status Dash-Board.♦ Project: Motor Vehicle Registration System – Punjab & NWFP.♦ Key Achievements: - Implemented new registration rules in Taxation module for Excise and Taxation Department, Punjab - Designed and implemented With Holding and Income tax rules in Taxation module for Excise and Taxation Department, NWFP - Developed Defaulter notices printing module - Developed Falcon Control Terminal Module which provides stolen vehicles search facilities for the Punjab Police - Provided technical support to Excise and Taxation Departments of major district of Punjab - Plan and implemented Database Backup and Recovery for corporate sites of Excise and Taxation Department of Punjab - Fixed the critical issue related Registration Book Printing for all corporate sites of Punjab

♦ Project: Falcon Control Terminal – Punjab.♦ Key Achievements: - Implement and design the interface for data migration utility from MS SQL Server to Oracle database through Oracle Heterogeneous Services and end-user can data migrate after login into FCT application at any time. - Designed and implemented advanced search functionality in FCT application. - Optimize the PL/SQL packages, procedures, and functions for FCT Web-based application version - Develop the different reports for FCT application report module.