Specialist – Data and Information Management
Msheireb Properties
Total years of experience :18 years, 3 Months
• Responsible for Data and Information Management across the Division including developing and implementing, strategies, plans and procedures for effective management of hard and soft data and information.
• Validation and verification of all data and information before formal adoption and storage
• Ensure systems, processes and procedures are in place, introduced and monitored for compliance with adopted policies, procedures and processes.
• Ensure Hard and soft Data and information is stored in the most appropriate manner.
• Manage digital transformation and twins
• Monitor performance with policies and procedures and produce regular reports and suggestions for continual improvement.
• Ensure adherence to legal and company regulations.
• Assist with recognizing and upholding digital security systems to protect delicate information
• Provide training and capacity building plans to support staff in works related to data collection and data management; data analysis and visualization; surveys and assessments; GIS analysis and mapping; reporting and translating.
• Coordinate and ensure an effective IM implementation, including refining standard data collection tools, scripting routine processes and (re)designing information products, managing effective information sharing and dissemination to all relevant stakeholders.
• Implement creativity in analysing incoming data to better respond to or highlight emerging needs
• Introduce more sophisticated technologies and/or methodologies to improve the efficiency and rigor of HRRP analysis.
• Work closely with and regularly inform HRRP coordinators about coverage and gaps, IM activities and priorities, and provide regular support as requested and agreed to by HRRP coordinator.
• Establish and maintain strong partnerships and regular liaison with key stakeholders in relation to D&IM and act as the Divisions Single Point of Contact
• Providing guidance to the business in Information Management (IM) and Information Governance (IG) and the execution of an information management strategy defining good information management practices, processes and requirements for the complete lifecycle management of all organizational information assets (business data, master data, reference data, content, integration and analytics
• Developed data management policies and underlying SoPs
• Defining roles and responsibilities of data owners, stewards, and custodians.
• Defining data discovery activities and criteria for critical data elements identification and ownership.
• Data lifecycle management, managing reports inventory and rationalization with data custodians
• Formalizing quality rules and remediation plans, along with data stewards, and reporting to data governance council.
• Designed, Implemented and operated comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
• Developed data warehouse process models, including sourcing, loading, transformation, and extraction.
• Created and implemented metadata processes and frameworks.
• Created plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
• Created supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Designed and implemented warehouse database structures.
• Developed and implemented data extraction procedures from other systems, such as administration, billing, or claims.
• Developed standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
• Implemented business rules via stored procedures, middleware, or other technologies.
• Developed data mapping documents between source systems, data warehouses, and data marts.
• Evaluation of all data and perform various tests on data warehouse and ensure effective implementation.
• Instrumental in providing analytical skills with the ability to research, identify and resolve data integration issues.
• Ensured compliance to standards and policies related to data.
• Coordinated closely with business owners, solution teams and design teams to ensure that solution architectures are fit-for-purpose and adequately meet data requirements
• Developed excellent visualizations and dashboards that helped for Decision making.
• Manage and continuously improve the design and implementation of Information and Data Architecture processes and artifacts
• Understand and advocate information/data architecture and Enterprise Architecture (EA) principles and be prepared to "sell" the information/data architecture process, its outcome and ongoing results
• Coordinate closely with technical and Business analysts to ensure EA and business interests are taken into account
• Coordinate closely with business data architects to ensure adherence to documented procedures and standards
• Responsible for guidance on high level solutions for information/data architecture requirements
• Assist, coach and mentor information/data architecture practitioners
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BI reporting.
• Lead and improvised existing Enterprise Data Warehouse
• Instrumental in creating process, procedures, policies and standards for data warehouse implementation
• Creating/ Managing the project plan, task allocation, work with stake holders and PMO office for achieving project goals in an agile work environment
• Designed architecture for SSIS implementation and cube creation using SSAS
• Co-ordinate with business owners, DBAs, reporting team to address system improvements
• Managed the project in breaking down the existing EDW to manageable data marts
• Mentored individuals from business and technical stand point
• Instrumental in creating an in-house tool for meta data and data governance for quality purposes
• Responsible for Data Modelling, Architecture, Production support and migration to various Database technologies
• Hands on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting
• Expertise in BI reporting using Tableau, MS Power BI
• Managed all the product development activities from inception and deployed within stringent timelines.
• Liaise with business subject matter experts in analysing business requirements (Productivity related - KPIs), understand the various data sources.
• Developed standard dashboards and reports based on the stakeholder requirements that lead to decision support.
• Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
• Translated business requirements into design and technical specifications for implementation.
• Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
• Engaged in data analysis, technical design, documenting, coding, unit testing, deployment and maintenance of various data load modules.
• Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.
• Delivered key support to multiple IT teams and business users, and created and maintained technical and application support documentation.
• Extracted data from IT systems created 20 years prior and without referential integrity, overcoming issues with extensive source data analysis as well as agreements on data extraction and usage rules with source system teams by having an interface control document in place.
• Provide database architecture and design for all current and future database systems.
• Hands-on database management for all data systems, including relational and non-relational database platforms.
• Hands-on management of databases, stored procedure/function development, data schema layouts.
• Instrumental in performance tuning the database to cater requirements of the clients with standard best practices.
• Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
• Work closely with IT and the Business group to understand business reporting requirements and analyse logical model, and develop subject matter expertise in a short time.
• Create and design logical and physical data models using ERWIN- identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.
• Architect the database schema and implement a relational (for ODS) and dimensional model (star schema). Review and maintain the schema, its tables, indexes, views and PL/SQL procedures in Oracle 10g.
• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes - define mapping, sessions and workflow
• Defines and captures metadata and rules associated with ETL processes
• Review and analyse database performance, cubes and reports generated using Oracle Discoverer, Crystal Reports, Cognos, OBIEE (based on client requirements)