• I am responsible to update the grants database, ensuring compliance with USAID/OTI and DAI standard practices and regulations.
• I collaborate with USAID/OTI on customization and localization of the grants database.
• I review and monitor activity database information for accuracy, consistency and completeness to ensure database integrity.
• I am responsible to synchronize master activity database between USAID/OTI and DAI office databases on a weekly basis.
• I train staff on the use of the grants database.
• I support and advise in the planning and implementation of additions, deletions and major modifications to the IT infrastructure.
• I support and advise the administration and maintenance of computers, servers, peripherals and software
• Implementation of data guard for High availability of Database.
• Support the Program Director in working closely with field offices to ensure that information is communicated to field teams in a timely manner and required reports are completed and distributed on schedule.
• Liaise with Finance Section on a weekly and monthly basis to financially reconcile grants and upload financial data in the Database.
• Serve as the point of contact with the donor on database specific, GIS, and online database issues; liaise on any database modifications, changes and need for troubleshooting.
• Assist all departments with any grant database reporting needs.
• Conduct routine data quality checks to ensure accuracy and up to date data.
• Other special projects and reporting as necessary to ensure proper grant implementation and operation.
• Installed, Configured and supported inter office LAN and WAN network.
• Installed, Configured and supported windows file server and Print server.
• Configured the DHCP Server, DNS Server, and Proxy Server on windows.
• Server management, controlling unauthorized access from department to department critical resources.

• Design and Development of standardized database systems for new projects.
• Extraction of data from project level database on weekly bases to upload on OTI Website.
• Administration of Project database (Performance Tuning)
• Train the PDOs, GOs and GAs that how to use database and generate reports.
• Responsible for Backup and Recovery.
• Implementation of data guard for High availability of Database.
• Support the Program Director in working closely with field offices to ensure that information is communicated to field teams in a timely manner and required reports are completed and distributed on schedule.
• Liaise with Finance Section on a weekly and monthly basis to financially reconcile grants and upload financial data in the Database.
• Provide uploaded Database to all staff and the donor on a weekly basis.
• Serve as the point of contact with the donor on database specific, GIS, and online database issues; liaise on any database modifications, changes and need for troubleshooting.
• Assist all departments with any grant database reporting needs.
• Conduct routine data quality checks to ensure accuracy and up to date data.
• Other special projects and reporting as necessary to ensure proper grant implementation and operation.
• Responsible to assign codes to new grants.
• Responsible to send requests to Office of Transition Initiative (OTI) for new user accounts and OTI Information Management System access.
• Installed, Configured and supported inter office LAN and WAN network.
• Installed, Configured and supported windows file server and Print server.
• Configured the DHCP Server, DNS Server, and Proxy Server on windows.
• I was accountable for providing real time support to client computes
• I had resolved all major issue of client sides like login error, printing dilemma, and connectivity problem
• Server management, controlling unauthorized access from department to department critical resources.

• Design and Development of standardized database systems for new projects.
• Extraction of data from project level database on monthly bases to send to Database Coordinator Islamabad.
• Undertake Monthly review meetings with project coordinator of project under way to ensure consistency of data/ information between program and database.
• Preparation of summary and detailed report (Monthly Data Collection, 3W & 4W Matrices, Output Tracker etc)
• Responsible for data cleaning i.e. to check invalid, out of range, out
Layer, duplicate values
• Responsible for data Standardization i.e. column merging, data
Merging
• Responsible for the oversight all database activities and managing all database staff in main base as well sub bases.
Responsible to apply scoring criteria to select potential beneficiaries and Generate Potential beneficiary’s lists, Distribution lists and Payment sheets etc.
• Handled large data entry operations.
• Trained the data entry operators and database supervisors.
• Monitoring & facilitation visits for effective and smoothness of day to day database activities at all bases.
• Prepare log sheet before dispatch data to Islamabad.

• Design and Development of standardized database systems for new projects.
• Undertake Monthly review meetings with project coordinator of project under way to ensure consistency of data/ information between program and database.
• Preparation of summary and detailed report.
• Responsible for data cleaning i.e. to check invalid, out of range, out
Layer, duplicate values
• Responsible for data Standardization i.e. column merging, data
Merging.
• Responsible for the oversight all database activities and managing all database staff in main base as well sub bases.
• Prepare Weekly and monthly reports.

• Design and developed data entry software (by using MS Access 2007) for our organization for large data entry Through Bar code scanner.
• Design and assign coding schemes for district, Towns, profession, medical centers etc.
• Responsible for data cleaning i.e. to check invalid, out of range, out
Layer, duplicate values
• Responsible for data Standardization i.e. column merging, data
Merging
• Preparing data reports daily, weekly, monthly basis and site wise
Creating charts graphs and pivot tables in excel
• I was responsible for development of new procedures and packages for implementing the new requirements of database data entries.
• To collect data from all districts then merge & import to main Database for analysis.
• Prepared questioners error report filed supervisor wise.
• Analyze and generate different types of Reports of Seven Districts data at PDCU Karachi.
• Handled large data entry operations.
• Trained the data entry operators and data editors.
• Monitoring & facilitation visits for effective and smoothness of day to day database activities at Data Management Units
• Manage and update the website of Sindh AIDS control program (SACP).