Program Information Management Officer
Save The Children - Lebanon
Total years of experience :14 years, 4 Months
Consolidates the collected data by IM data collection team
Ensures balance of data availability and analysis to inform decision making
Track the process of partner reporting against key results for donor and SitRep reporting, checking data quality and consistency
Ensure timely reporting submissions to PPD and donors
Takes full responsibility for reporting the data that feds within the CASH and Shelter IPTTs (Indicator Performance Tracking Table).
Ensures program teams are using tested and standardized data collection tools.
Supports in providing IM solutions that serves the CASH and Shelter activities.
Develop, support, maintain and strengthen Information Management systems, data usage, and general digitalization capabilities.
Support IM planning activities, IM capacity building, shelter and cash OPS Unit
Lead on development and roll out of Standard Operating Procedures (SOPs), systems and procedures for (Information Management) IM systems.
Create regular backups of internal databases.
Support mobile data collection designs, and utilization.
Minimize data collection, data entry and reporting efforts through introducing digital processes/ automatization.
Create geographical maps to analyze and visualize project implementation across areas and sites.
Handle shelter/cash database specific tasks such as creating queries, procedures, and functions to support application development.
Follow up with sector specialists to ensure project targets are updated within Information Management IM systems.
Administer, monitor, and follow-up on data entered into reporting systems.
Design, generate, and assist with periodic reports: monthly/quarterly, or as required.
Conduct data quality checks and ensure the reliability and cleanliness of the data.
Collect data from data collection tools such as survey123, ODK, KOBO, or CommCare.
Data cleansing and transforming to match the needed requirements
Extract data and produce Analysis weekly and monthly reports using different tool such as Excel, Power BI, survey123
Perform data quality checks
Develop reports and dashboards using different tools to track KPIs
Setup HLOUL & IPS IT infrastructure (All hardware and software related to the data network, servers, equipment, operating systems, and Microsoft Windows domains)
Maintaining Microsoft Dynamics AX administrative & Functional tasks daily
Gathered requirements for designing and implementing the data model for a large data warehouse and operational data store project
Database creation and maintenance tasks, designing and implementing SQL stored procedures to build report tables from star Schema
Developing queries, functions, views, and stored procedures used in building the ETL and the report presentation services area of the data warehouse
Configuring and maintaining the Customer relationship management system
Demonstrate IBM Cognos portfolio of products within each customer’s context
Communicate effectively with the customer’s multiple teams to understand their requirements and fulfill their expectations
Install and configure IBM Cognos TM1, Cognos BI, Power BI for HLOUL customers
Design TM1 cubes to run a corporate budget calculation system (multiple sister companies & consolidation) for sales, finance, personnel, production & inventory
Develop BI content (reports and dashboards) using different tools TM1, Cognos BI, Power BI to track KPIs & actual versus budget
Extract data and produce monthly reports for HLOUL’s customers (finance, sales, CRM, operations, HR, costing, Cash Flow, inventory, P&L, Balance Sheet)
Create monthly reports using AX, Cognos & excel and provide them to the CEO & CFO for high-level management meetings
Perform data quality checks
Train customer’s users and produce design documents
Architected and sold dashboard-based Business Intelligence system.
Developed and delivered technology presentations and product demonstrations.
Facilitated customers’ ability to make informed decisions for purchases of IT solutions through whiteboard presentations, product demonstrations, formal presentations, and round-table meetings with key executive personnel.
Developed architectures, and built a proof of concept demonstration systems focused on Data Integration, Data Quality, and Business Intelligence initiative
Multiple customers in healthcare, staffing, telecom, and analytics domains
Install and configure IBM Cognos (BI, TM1, Metric Designer, Transformer, Framework Manager), link to SQL Server / IBM DB2
Develop relational and dimensional business models
Design and run ETL models to load data from data sources into the data warehouse
Develop reports and dashboards to monitor key performance indicators
Design budget estimation calculations, implement data security
Users training and system documentation
Multiple IBM Cognos implementations for Quantech customers (environmental, manufacturing, insurance, banks, and healthcare companies)
Install and configure Cognos BI, Framework Manager, SQL Server
Create ETL using SSIS
Develop Framework model and BI content (reports and dashboards)
Produce monthly reports and dashboards to track company performance
Implement security and documentation
IT infrastructure (Network, Server, Laptops, Printers, Active Directory)
Laptop, printer, computer maintenance & Customer service