Shahzad Asghar Arain, Database Information Management officer

Shahzad Asghar Arain

Database Information Management officer

UNHCR -The UN Refugee Agency

Location
Switzerland
Education
Master's degree, Computer Science
Experience
21 years, 11 Months

Share My Profile

Block User


Work Experience

Total years of experience :21 years, 11 Months

Database Information Management officer at UNHCR -The UN Refugee Agency
  • Switzerland
  • My current job since June 2015

Directs and manages the activities pertinent to data Management systems and the standard functions performed by the Information Management
- Provides robust data management practices and develops and oversees processes in the Health Information Management department in order to attain HMC strategic goals and to meet the standards set by the
designated accrediting bodies regarding all Medical Record and Health Information Management services.

Data Management:
1.Responsible for overall data management including developing and managing of data collection, analysis and reporting
tools by using MS access, Excel and PHP -MySQL
2. Draft regional inter-agency data protection and information sharing protocols.
Responsible for capacity building of Non -IT staff to use information management effectively
Data Analysis:
3.Responsible for Collecting, collating and carrying out complex data and trend analysis in support of management & interagency
staff requests.
4. Gather data necessary to accomplish analysis from a number of sources, accumulate it together in prearranged format and
enter the data in several data analysis software i.e. Excel, SPSS, Tableau
5.Support the Office in the analysis of processed data and information and perform data quality and consistency control.
Web Management:
6. Managing and updating UNHCR global web portal.
7. Liaising with country programs to improve interoperability and accessibility of web products
8. Developing web-based tool for risk assessment and reporting.
Data collection and Monitoring:
9.Trained field staff to used mobile based tool data collection and monitoring i.e. ODK, Kombo Toolbox
Coordination:
10.As a global IMO responsible for creation of Information management network and develop strategy for establishment of
communication channels between inter-agency and government counterparts
11.In coordination with key partners, develop and implement a strategy for building protection information management
capacity in UNHCR.
12.Provide direct and remote support to field operations with protection information management systems to support both
cluster and refugee operations
Repotting: Developing weekly and monthly dashboards and reports
Develop and deliver technical guidance to support development of indicators and data collection methodology is necessary to
support UNHCR operations globally and at field level. • Develop and deliver technical guidance and support on protection
information management in UNHCR operations in both cluster and non-cluster contexts. • Develop and deliver training to field
and headquarters staff in protection information management, in collaboration with relevant technical staff, global clusters,
field clusters and the global learning center.

Information/Data Management Officer at The United Nations Children's Fund (UNICEF)
  • Kenya
  • March 2014 to June 2015

Responsible for overall database management and Oracle ERP implementation unit and supervising staff included ERP experts, data collectors, data entry, data coders and data analyst
Responsible for writing standard operating protocols for data coding cleaning, merging, reporting and analysis and ensuring RHIA and IDC10 standards

Monitoring of Child protection Information Management System and deployment of ERP in Five countries included Kenya, South Sudan, Ethiopia, Rwanda, and Uganda

A detailed analysis of current information and case management system practice in use and lessons learned that would be shared with the global level to inform development of next generation CPIMS and Progress a capacity building component that focuses on trouble shooting and problem solving field specific needs based on location and a rapid review of current operations. This would involve identifying areas for increased cooperation between ProGress (UNHCR ERP) and CPIMS (UNICEF ERP)and associated procedures (registration etc.) ideally leading to efficiency gains. The development of a guidance set and a series of recommendations for implementing child specific IMS in refugee settings including implications for protocols, especially in consideration that the new version of ProGres is currently under development. This guidance should enable staff to assess the implications of adapting an IMS alongside ProGres

Information/Database Management Officer at The United Nations Children's Fund (UNICEF)
  • Philippines
  • January 2013 to March 2014

Assessment and situation analysis and mapping: Ensured the preparation of the child protection and education assessments and analysis along with periodic updates as necessary. Seeks to promote both stand-alone child protection and education needs assessment and integrated assessment in inter-agency initiatives in other initiatives to map out priority child protection gaps and identify key resources and assets, while considering the impact of the emergency on existing protective systems. Supported the mapping of institutional response capacities and activities, including

Data collection of child-protection and education specific 4Ws.
Analyzed qualitative and quantitative data in SPSS
Developed monitoring formats for field staff
Development of a monitoring & evaluation framework for results based
Management
Developed smart phone based data collection tool to collect health facilities data
Planning: Contributed in development of the work plan and monitors
Compliance to ensured objectives and targets are met and achieved. Liaised closely with field coordination, security and supply section and emergency focal points and provides inputs to contingency, mission and supply planning.
Prepared GIS base monitoring maps to helps team in trend monitoring
Prepared sectorial input to the programme and other relevant documentation UNICEF/government/and other partners in the development of child protection strategies, methodologies and identification of new approaches for improving programme delivery
Monitoring: Establishes systems and undertakes field visits to capture the situation of child protection sector and monitor the progress of partners. Identifies gaps and problems and proposes remedial action.
Tracks the overall progress made of the UNICEF child protection programme, partnerships and supplies ordered and in the pipeline, and facilitates budget tracking and implementation.
Coordination: Provided technical support in the maintenance of appropriate coordination system for child
Evaluation assessing the appropriateness, relevance, efficiency and effectiveness of CIDA's Country Programme in Tacloban

Database Information Management officer at The United Nations Children's Fund (UNICEF)
  • South Sudan
  • June 2013 to December 2013

Security assessment of Child protection IMS web site and discovers critical XSS vulnerability
Assets Humanitarian data web portal and discovered and reported open path vulnerability
Managing Information Management System (CPMIS)
Generating different reports from MIS data bases
Developed and linked GIS maps from MIS database
Trained Field staff for data entry in MIS
Customized database and linked with supplement applications
Developed contact management system for clusters
Developed web based 4W data management System
Analyzed data in SPSS, Excel, EPIData
Developed data management software in MS Access
Responsible for data cleaning merging and improves the capacity of stakeholders in analysis and decision-making through Strengthened collection, processing, interpretation and dissemination of information at the intra- and inter-cluster level.
Monitoring and Reporting: developed simple, user-friendly reporting formats with consultation of stakeholders; reporting formats included provision for gender and age dis-aggregation of data and reporting on particularly vulnerable groups

Chief Monitoring Evaluation and Reporting Officer at Caritas Swiss
  • Pakistan - Islamabad
  • June 2012 to June 2013

Developed the overall framework of the monitoring and evaluation activities; with the responsibilities and prepared the work plan and the detailed budget for the monitoring and evaluation activities;
Supervised the work of the Monitoring and Evaluation office staff; provided guidance and technical support
Guided and coordinated the programme log frames including:

(i) Provided technical advice for the revision of performance
Indicators
(ii) Ensured that realistic intermediate and end-of-programme
targets were defined;
(iii) Conducted a baseline study on monitoring and evaluation in the
Kohistan district;
(iv) Identified sources of data, collection methods and resources
needed and related cost
(v) Contributed to the development of the Field Implementation Plan (FIP)

Established contacts with other monitoring and evaluation stakeholders

Regular visits to the fields to support implementation of monitoring and evaluation, checked the quality of data produced, and to identify where adaptations might be needed; monitor the follow up of evaluation recommendations with Programme Managers;

Developed field complaints mechanism, related processes and procedures to ensure that departments and programmes have access to and are able to respond to community feedback

Coordinated the preparation of all monitoring and evaluation reports; guide staff and executing partners in preparing their progress reports in accordance with approved reporting formats and ensure their timely submission


Facilitated 3 high level donor visits to the project areas in Northern Sindh including ECHO, DFID and USAID

Developed the capacities on Information Management of the newly inducted staff members of Caritas Swiss

Information Management officer at United Nations Office for the Coordination
  • Pakistan - Islamabad
  • December 2011 to June 2012

Developed web based information management systems
Data Analysis and monthly report generating in SPSS and STATA
Integration GIS & IM databases
Revise the information needs of all key stakeholders that need to be integrated into the local database.
Refined the methods for regular information collection for special studies arising from project needs.
Ensured gender segregated data is maintained in the data base
Developed SOP on data entry points, Data access policy and statistical analysis (where and when).
Defined the principal automated outputs that the system should provide, based on funding agency and ministry requirement sand related to results, objectives, impact, lessons learned and corrective actions needed
Defined the choice of software according to database requirements, degree of user friendliness, possibilities of updating thedatabase and the technical facilities available in the field
Developed the ToRs (terms of references) for more than 6 national level and 01 international level consultancies
Developed the "consultants monitoring format" to monitor the overall progress of the consultants
Planed and coordinated with service providers to ensure high availability of ICT support and services for the 24/7 Operations Room
Carried out managerial responsibilities at the unit level relating to compliance with administrative requirements,
Migration of FoxPro database to Mysql
• Data Analysis in SAS and Matlab
• Oversee the retrieval and dissemination of records/documents from the archives and records centre
• Providing expert advice on complex information management systems analysis and design; identifying the need for new systems responding to requests from users developing plans for feasibility assessment, requirements specification, design, development and implementation, including project plans, schedules, time and cost estimates, metrics and performance measures.
• Designing and implementing superior analytics, decision - making and operational reporting tools using components such as Data Governance, Master Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring and Data Mining; utilizing the SharePoint Business Intelligence suite of tools
• Guiding, trains and supervises professional and general service staff in the various information management functions
• Develop and design online information management system in (PHP/Mysql)
• Developing GIS maps in Arcgis
• opentext management

Database Manager at Canadian International Development Agency (CIDA)
  • Pakistan - Islamabad
  • June 2006 to December 2011

Software and Database Development
• Designed and developed online MIS system for National Aids Control Program
• Developed MS Access data entry software for National Referral Laboratory
• Developed Barcode enabled software for surveillance project
• Developed many supplement software and MIS during project
• Developed data collection tools for PDA’s and smart phones
• Developed data validation software in MS Access

Website Management
• I was responsible for updating and maintain of HASP Project website including email management, content modification and backups
• Developed website in Drupal open source
Network Administration
• Installation and designed of LAN and Wi-Fi network with network admin
• Troubleshooting network and system issues (Windows, software installation)
• Installation, Upgrading, Repairing And Maintenance of PC
• Managing and configuration of active directory and managed Print Server
• Helping out administration to procurement of new hardware and software
• Planed and managed the communications, networking, routing and security aspects. Installation of new servers and new products, Overall to maintain the smooth services and to lead the Customer support/Network department, also involved in Management decisions
• Successfully recovered systems from major hacker attacks and virus outbreaks
Data Management and Information Management
• Data Analysis, Data coding, Database security and integrity, database development, data cleaning
• Data Analysis and monthly report generating in SPSS and Excel
• Supervised data entry process included developing of data receiving and entry report formats
• Trained data entry staff in data coding, data entry and barcode scanning
• Barcode generating and printing management
• Analyzing the National data sets by using SPSS, EPIINFO
• Cleaning and Analysis of SPSS data set’s
• Prepared National Data Flat files for report.
Monitoring and Evaluation

• Developed M and E report formats
• Conduct filed visits to ensure data collection quality
• Supervised field interviews of sex workers
• Generated Excel reporting formats for M and E
• Coordinate the M and E (Monitoring and Evaluation) and reporting templates, tools, protocols, and appropriate indicators and mechanisms for implementing project monitoring plans, in cooperation with specialists of the CIDA Operations Department and CIDA partners
• Support training in M and E for Project staff, especially with regard to basic M and E concepts, data collection
GIS
• Developed GIS maps in ArcGIS 10
• Generated buffer analysis
• Trained field staff for GPS point collection and Google earth integration
• Used Google maps for generating Spot lists
• Printed GIS maps from Plotter
Managerial tasks
• Carried out managerial responsibilities at the unit level relating to compliance with administrative requirements, programme planning, policy and procedure recommendations, budgeting, human resources and facilities management included
Trainings: Conducted more than 100 trainings and trained 1000+ staff on different themes (Data/Information management, data collection, SPSS, Excel Analysis, EPIINFO, M&E)
Planning :Planed and established Central data coordination unit and 4 state level data coordination units include Hardware software Procurement, Liaison with government counterparts
Staffing : Hired and supervised 10 database administers, 200 data entry officers, 50 Data coders, 100 data collectors, 5 Data analysts, 4 GIS officers, 2 Information management officers

Health Information and Data Collection Supervisor at The Aga Khan Hospital
  • Pakistan - Karachi
  • May 2002 to August 2006

I joined the team to help create an ICD/RHIA computer-assisted coding tool for other health information professionals. I successfully mapped codes to help meet productivity goals and provided document review and analysis for the linguist and machine learning team.
Develop and oversee processes in the HIM Department: ensure that HIM processes and controls are evaluated against the organization’s internal and external information needs on an ongoing basis
- Take steps to actively move forward from paper based health record to a fully integrated electronic health record environment.
- Serve as an internal consultant on health information management issues including release of information, confidentiality, information security, information storage and retrieval, and record retention as well as authorship and authentication of health record documentation, standardization of medical vocabularies, and use of classification systems
Supervised data entry staff during data entry
 Analyzed data in SPSS
 Established the baseline data of the project target areas through a participatory approach
 Organized the more than 350 community organizations to pursue the targets of the project
 Developed the community based monitoring and evaluation framework and then strategy for proper project implementation
 Conducted the training needs assessment of the community members focusing the project thematic areas
 Collaboration with international data management units & principle investigators for information dissemination, technical focus and operations.
 Designing of VB & SQL database systems, SOPs for operation, training & management.
 Maintaining all systems includes: Supervision of all staff including data supervisors, data analysts, senior data operators, data operators.
 Overseeing double data entry systems
 Ensuring data integrity/quality, Reports/log sheets generation; checking Archiving of all forms/data.
Supervise and ensure compliance to meeting deadlines with respect to data collection, documentation, and reporting
• Lead and guide the department in the establishment of private and secure document management practices
• Manage health information according to standard policies and procedures
• Present complex statistical information to a variety of audiences
• Oversee developing annual reports within the department
• Help in data management, analyses and dissemination
• Assist in developing strategies related to common diseases
• Provide input into the process of understanding and assessing the health needs in the field
• Provide advice on epidemiology, health intelligence, statistics and statistical techniques, health data sets, research methods and survey design
• Provide input into the process of understanding health needs in the field, addressing health inequalities, determining priorities for action, assisting wider understanding of the characteristics of the local population
• Help in understanding the characteristics of the local population
• Ensure the generation of correct information that follows confidentiality guidelines
• Ensure that staff meet the department’s mission and vision
• Plan objectives and work commitments for multidisciplinary projects

Meet deadlines with respect to data collection, documentation, and reporting
• Submit timely annual reports within the department and quarterly newsletters
• Develop evidence based public health policies
• Ensure accuracy of information

Education

Master's degree, Computer Science
  • at Fedaral University Islamabad
  • January 2010

M.phil

Master's degree, Computer Science,Data,information Management
  • at Sindh University Jamshoro
  • March 2002

I have done my M.sc in computer Science with 2.7 GPA recently completed M.phil in software engineering from Federal University Islamabad with 3.5 CGPA

Specialties & Skills

Data Analysis
Data Management
ICT Security
Health Information Management
IT Management
Marketing Research
Database Administarion
Data Analysis
Programming
Health information management System
Data Mining
Web Development
planning and implementation
Data Management
MIS (Management Information System)
Data Center
Reporting
Information Security

Languages

English
Expert
Urdu
Expert
Arabic
Intermediate
Hindi
Expert

Training and Certifications

Advance Data Analysis Techniques for Health and Surveillance data (Training)
Training Institute:
National Institute of Health Islamabad
Date Attended:
April 2008
Duration:
36 hours
English Language report writing (Training)
Training Institute:
National institute of Modern Languages
Date Attended:
September 2010
Duration:
72 hours
Certified Coding Specialist (Training)
Training Institute:
The Aga khan University
Date Attended:
September 2013
Duration:
40 hours
Registered Health Information Administrator (RHIA) (Training)
Training Institute:
The Aga Khan university
Date Attended:
March 2012
Duration:
36 hours
Prince 2 (Training)
Training Institute:
Oranet Training Consultants
Date Attended:
April 2013
Duration:
72 hours
Certified Ethical Hacker (Training)
Training Institute:
Sir Syed Khan University Karachi
Date Attended:
April 2005
Duration:
72 hours
Diploma Associate Engineer (Petroleum) (Certificate)
Date Attended:
February 1996
Valid Until:
May 1999
ISO 20000-1:2011 (Training)
Training Institute:
University of Sindh Jamshoro
Date Attended:
March 2012
Duration:
36 hours
Sun Certified Java Programmer (SCJP) (Certificate)
Date Attended:
May 2003
Valid Until:
June 2020

Hobbies

  • Research,Internet browsing
    I have 12+ years working in information management, specializing in application development, coding, privacy, compliance and physician education. I truly enjoy investigating and solving issues to provide accurate and complete communication of data information, and in providing resources to inform and educate care providers. I love providing information that informs and assists people.