$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Strong Data Architect Profile
Somina Membere
,
Copenhagen, Denmark
Experience
Other titles
Skills
I'm offering
Technical leader experienced in working among executive, business and technical personnel to realise business value through strategic planning and implementation of data management practices. Combine a rare mix of technology and business savvy to implement innovative solutions to achieve company goals. Proven track record of defining data management technologies. Working with executive leadership, building relationship with partners, creating technical infrastructure, data mapping. Instrumental in streamlining and improving processes, enhancing productivity, and implementing technology solutions and architecture design. Leverage RDBMS skills in the design implementation of OLPT, enterprise data warehouse and reporting tools, Data vault, business data Integration, data Assets re-use, and in-depth knowledge of Transact-SQL (DDL, DML) Oracle Databases
Markets
United States
United Kingdom
Germany
Lithuania
Denmark
Norway
Sweden
Finland
Language
English
Fluently
Ready for
Full time contractor
Available
My experience
2019 - ?
job
Data Architect
LEO PHARMA.
on the LEO Pharma GCO Reporting - CTS System Replacement Project in Copenhagen Denmark.
ROLE: DATA ARCHITECT
Technology Used: Microsoft SQL SERVER, ERWIN 2019, Microsoft (Power BI, SSIS, SSMS), Oracle Mysql, Microsoft Visio, ETL, Veeva Vault
• Data model design and development for Pre-Staging, Staging and Production of 9 critical Pharmacology Reports developed in Microsoft Power BI and JREVIEW using Erwin, Microsoft Visio and Excel. Combination of reverse engineering and forward engineering processes.
• Designing Integrated Data Flow Diagram from Legacy Veeva Vault System through various data transformations involving Mysql and Sqlserver.
• Extensive Data Profiling and Data Quality validation and cleansing.
• Developing ETL Mapping strategy from Pre-Staging to Staging to Production.
• Developing the ETL process with the appropriate transformations and business logic.
• Validation and approval of SSIS packages post development before deployment into UAT and Production Environments.
• Compliance documentation for Project Golive.
Key Artefacts/Deliverables:
ROLE: DATA ARCHITECT
Technology Used: Microsoft SQL SERVER, ERWIN 2019, Microsoft (Power BI, SSIS, SSMS), Oracle Mysql, Microsoft Visio, ETL, Veeva Vault
• Data model design and development for Pre-Staging, Staging and Production of 9 critical Pharmacology Reports developed in Microsoft Power BI and JREVIEW using Erwin, Microsoft Visio and Excel. Combination of reverse engineering and forward engineering processes.
• Designing Integrated Data Flow Diagram from Legacy Veeva Vault System through various data transformations involving Mysql and Sqlserver.
• Extensive Data Profiling and Data Quality validation and cleansing.
• Developing ETL Mapping strategy from Pre-Staging to Staging to Production.
• Developing the ETL process with the appropriate transformations and business logic.
• Validation and approval of SSIS packages post development before deployment into UAT and Production Environments.
• Compliance documentation for Project Golive.
Key Artefacts/Deliverables:
Ssis, Processes, Logic, Production, Power, Server, BEE, Reverse Engineering, Development, Pharma, Data quality, Technology, Engineering, Design, Compliance, Visio, Deployment, ETL, Microsoft SQL Server, Microsoft SQL, Power BI, Oracle, SQL Server, Excel, Sql, Mysql
2018 - 2019
freelance
DATA GOVERNANCE & DATA QUALITY MANAGEMENT CONSULTANT
RICHMOND FELLOWSHIP.
Technology Used: Colibra DGC, Colibra Catalog, Informatica IDQ 9.5.1, IPC 9.5.1, Oracle 10, JBOSS. Erwin 9,
Seasoned professional with diverse experience in leading initiatives and designing a robust Data Governance program. Experience working on both business and enterprise data governance programs which provides a unique prospective on how to roll out the standards and policies.
• Designed Data Governance framework capturing concepts like; Data Ownership, Data Requirements, Metadata Management, Master Data Management, Data Quality, Data Sourcing, Data Corrections, Data Lineage, Critical Data Elements, Data related Controls, Access Management and Information Security.
• Identified CDEs for multiple finance reports and scored them determine various level of criticality (Gold, Silver and Bronze CDEs). This helped us focus on the most critical data elements first and implement highest level of controls to manage and protect the data.
• Built Data Governance implementation strategy for 2019 to focus on key reports and CDEs.
• Identified Sensitive Personal Information (SPI) and Non-Public Personal Information (NPI) in various finance system and proposed data masking and encryption of data as it moves across the enterprise.
• Developed training and growth program for Enterprise Data Management Office (EDMO) to enhance their data governance knowledge and help them implement Data Governance program.
• Oversaw Data Governance Stewards Council and Data Governance Committee meetings which were used to provide leadership with information on progress or key changes and allowed us to provide training to Data Stewards on various data governance concepts.
• Identified key controls needed to manage and measure data in movement and data at rest.
• Performed controls gap analysis to identify systems which required additional controls to manage and protect CDEs, SPIs and NPIs.
• Managed team of 4 solution designers to build and support various data movement controls, monthly reporting and data quality analytics.
• Supported business area customer in identifying and resolving significant control deficiency around their data movement control.
• Developed custom data quality rules and Address Validation processes.
• Coached and mentored individuals in the team to increase productivity and employee morale. This resulted in significant reduction in built time and production issues
• Developed advance data quality measures using statistical analysis for data anomalies.
• Stood up Data Quality Center of Excellence (CoE) which provided business area customers platform to learn about IDQ.
Key Accomplishments:
• Development of Data Governance Framework, GDPR Framework & Implementation of Data Governance Council.
• Development of Data Quality Measures, DQ rules & Exception Management Policies for Data Quality.
Seasoned professional with diverse experience in leading initiatives and designing a robust Data Governance program. Experience working on both business and enterprise data governance programs which provides a unique prospective on how to roll out the standards and policies.
• Designed Data Governance framework capturing concepts like; Data Ownership, Data Requirements, Metadata Management, Master Data Management, Data Quality, Data Sourcing, Data Corrections, Data Lineage, Critical Data Elements, Data related Controls, Access Management and Information Security.
• Identified CDEs for multiple finance reports and scored them determine various level of criticality (Gold, Silver and Bronze CDEs). This helped us focus on the most critical data elements first and implement highest level of controls to manage and protect the data.
• Built Data Governance implementation strategy for 2019 to focus on key reports and CDEs.
• Identified Sensitive Personal Information (SPI) and Non-Public Personal Information (NPI) in various finance system and proposed data masking and encryption of data as it moves across the enterprise.
• Developed training and growth program for Enterprise Data Management Office (EDMO) to enhance their data governance knowledge and help them implement Data Governance program.
• Oversaw Data Governance Stewards Council and Data Governance Committee meetings which were used to provide leadership with information on progress or key changes and allowed us to provide training to Data Stewards on various data governance concepts.
• Identified key controls needed to manage and measure data in movement and data at rest.
• Performed controls gap analysis to identify systems which required additional controls to manage and protect CDEs, SPIs and NPIs.
• Managed team of 4 solution designers to build and support various data movement controls, monthly reporting and data quality analytics.
• Supported business area customer in identifying and resolving significant control deficiency around their data movement control.
• Developed custom data quality rules and Address Validation processes.
• Coached and mentored individuals in the team to increase productivity and employee morale. This resulted in significant reduction in built time and production issues
• Developed advance data quality measures using statistical analysis for data anomalies.
• Stood up Data Quality Center of Excellence (CoE) which provided business area customers platform to learn about IDQ.
Key Accomplishments:
• Development of Data Governance Framework, GDPR Framework & Implementation of Data Governance Council.
• Development of Data Quality Measures, DQ rules & Exception Management Policies for Data Quality.
Master Data Management, UP, Processes, Access management, Framework, Npi, Enterprise, Production, Office, Management Consultant, Development, Implementation, Growth, Data quality, Support, Oracle, It, Quality Management, Technology, Security, Sourcing, Finance, Analytics, Management, Leadership, Information Security, GDpr, Data management, REST, Training
2017 - 2018
freelance
MDM CONSULTANT/ARCHITECT
ROCHE.
• Key member of leadership team in assessing project risks and impact on other project initiatives and the MDM project. Including interpreting BRD's to offshore development teams.
• Coordinated the Installation and Development of Informatica Hub Console in partnership with Database Administrators.
• Development of data profiling and analysis routines with Informatica Data Quality for data quality initiatives prior to data landing and stage processing.
• Defined and tracked Data Quality and Data Governance metrics.
• Developed Technical Design artefacts for the MDM Customer Domain.
• Define and Design of Conceptual and Logical models for Informatica MDM Landing, Stage and Base objects.
• Designed Transition and Target MDM architecture as part of the overall MDM implementation roadmap.
• Design the development of core batch interfaces To and From MDM Hub.
• Designed and developing multiple cleansing and standardization scenarios.
• Performing data standardization using Address Doctor, Trillium, Informatica Data Quality and Data Integration using SIF API's
• Defining match/survivorship rules and profiling the match rules results to assess the effectiveness of MDM process on data.
• Developed the mappings and cleanse functions following data analysis and profiling.
• Managing offshore resources by assigning tasks, overseeing the code changes, peer reviewing requirements and resolving any other issues.
• Managing a team of 5 offshore resources and 2 onsite data stewards for MDM projects.
Technology Used: Informatica MDM Hub Server IDD 9.7.1HF1, IDQ 9.5.1, IPC 9.5.1, Oracle 10, JBOSS. Erwin 9, VPN, SAP Power Designer
Key Accomplishments:
• Architecting the MDM hub and designing the MDM matching/survivorship rules
• Development of Data Quality metrics and Governance framework for MDM.
Key Artefacts/Deliverables: IDD, Hub Console, Data Access layer and BI. Artefacts include MDM SOW (MDM, PC, DQ Assessment), HUB to DAL publish rules, IDQ to HUB publish rules, Daily production processing schedules, Source to Attribute mapping, MDM functional specification, MDM Project Glossary, PKEY Functional Layout Definition, MDM Release Plans.
• Coordinated the Installation and Development of Informatica Hub Console in partnership with Database Administrators.
• Development of data profiling and analysis routines with Informatica Data Quality for data quality initiatives prior to data landing and stage processing.
• Defined and tracked Data Quality and Data Governance metrics.
• Developed Technical Design artefacts for the MDM Customer Domain.
• Define and Design of Conceptual and Logical models for Informatica MDM Landing, Stage and Base objects.
• Designed Transition and Target MDM architecture as part of the overall MDM implementation roadmap.
• Design the development of core batch interfaces To and From MDM Hub.
• Designed and developing multiple cleansing and standardization scenarios.
• Performing data standardization using Address Doctor, Trillium, Informatica Data Quality and Data Integration using SIF API's
• Defining match/survivorship rules and profiling the match rules results to assess the effectiveness of MDM process on data.
• Developed the mappings and cleanse functions following data analysis and profiling.
• Managing offshore resources by assigning tasks, overseeing the code changes, peer reviewing requirements and resolving any other issues.
• Managing a team of 5 offshore resources and 2 onsite data stewards for MDM projects.
Technology Used: Informatica MDM Hub Server IDD 9.7.1HF1, IDQ 9.5.1, IPC 9.5.1, Oracle 10, JBOSS. Erwin 9, VPN, SAP Power Designer
Key Accomplishments:
• Architecting the MDM hub and designing the MDM matching/survivorship rules
• Development of Data Quality metrics and Governance framework for MDM.
Key Artefacts/Deliverables: IDD, Hub Console, Data Access layer and BI. Artefacts include MDM SOW (MDM, PC, DQ Assessment), HUB to DAL publish rules, IDQ to HUB publish rules, Daily production processing schedules, Source to Attribute mapping, MDM functional specification, MDM Project Glossary, PKEY Functional Layout Definition, MDM Release Plans.
Implementation, IDD, Framework, Processing, Performing, Production, Power, PC, Assessment, Server, BEE, Development, Offshore, Design, Data quality, Technology, Architecture, Integration, Leadership, Database, SAP, Oracle, API, Data Analysis, Layout
2016 - 2017
job
INFORMATION SOLUTION ARCHITECT
THE MINISTRY OF JUSTICE.
• Responsibility for the development of the Business Information model (ie the business level logical data model) for MOJ National Prison Service (NPS) and 21 Community Rehabilitation Companies (CRC) transformation project.
• Responsibility for co-managing the stakeholder engagement activities. Ran extensive structured workshops and meeting sessions with the 21 CRC locations UK-wide. The purpose of the workshops/meetings were to address complex data governance issues revolving around the separation sensitive data, (Offender, Victims, Finance, HR & Corporate data)
• Responsibility for ensuring all end-to-end processing, data handling, data retention and data management processes were conducted in strict compliance with statutory data protection and regulatory standards within the Electronic Data Archiving project of the Transformation programme.
• Responsibility for carrying out comprehensive risk assessment with relation to data assets and proffering road map and recommendations for improvement and for expanding existing policies in the development of data governance and data quality processes and checks. Furthermore, ensuring that all data belonging to the National Prison Service was separated from systems and processes belonging to the newly created Community Rehabilitation Companies that would be managing the rehabilitation of low to medium-risk offenders on behalf of NPS.
• Responsibility for review, selection and recommendation of toolsets required for data cleansing, data quality and data profiling.
• Developed a robust data control and validation framework for the MOJ transformation program and produced formal data specification procedures for the NPS &CRC program.
• Collaborated with the business partners in establishing and operating data-related governance processes across MOJ CRC transformation project.
• Developed GDPR Compliance Gap Analysis to identify gaps within MOJ data protection processes and procedures and identify weaknesses relating to GDPR
• Developed a GDPR Compliance framework and implementation plan, including EU GDPR documentation toolkit.
• Development of GDPR User Guide including setting out tasks and responsibilities of DPO, Data Controllers and Processors, dealing with international data transfer rights and consent of data subjects.
• Liaising with technology partners selling Data protection and Privacy tools and applications, including IBM and Oracle
• Assisted with the MDM project framework by identifying key domains and key functionalities and capabilities for MDM implementation.
• Collaborated with delivery team (Business Intelligence, Solution Architecture, MDM developers, Program manager) to develop and implement Informatica Customer domain MDM solution.
• Designing, installing, configuring core informatica MDM Hub components including Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD
Technology Used: Oracle 11c, Visio 2013, Erwin 9, Microsoft SSIS, Toad, HPUX, Colibra Data Governance
Key Accomplishments:
• Development and implementation of the Business Information model (Conceptual, Logical & Dimensional) for MOJ National Prison Service (NPS) and 21 Community Rehabilitation Companies (CRC) transformation project.
• Successfully developed the Data Governance Vision, Charter & Framework for 21 CRC's and Establishment of Data Stewardship teams for all CRC's.
• Developed the EU GDPR Compliance Framework and Implementation plan for the 21 CRC's.
• Responsibility for co-managing the stakeholder engagement activities. Ran extensive structured workshops and meeting sessions with the 21 CRC locations UK-wide. The purpose of the workshops/meetings were to address complex data governance issues revolving around the separation sensitive data, (Offender, Victims, Finance, HR & Corporate data)
• Responsibility for ensuring all end-to-end processing, data handling, data retention and data management processes were conducted in strict compliance with statutory data protection and regulatory standards within the Electronic Data Archiving project of the Transformation programme.
• Responsibility for carrying out comprehensive risk assessment with relation to data assets and proffering road map and recommendations for improvement and for expanding existing policies in the development of data governance and data quality processes and checks. Furthermore, ensuring that all data belonging to the National Prison Service was separated from systems and processes belonging to the newly created Community Rehabilitation Companies that would be managing the rehabilitation of low to medium-risk offenders on behalf of NPS.
• Responsibility for review, selection and recommendation of toolsets required for data cleansing, data quality and data profiling.
• Developed a robust data control and validation framework for the MOJ transformation program and produced formal data specification procedures for the NPS &CRC program.
• Collaborated with the business partners in establishing and operating data-related governance processes across MOJ CRC transformation project.
• Developed GDPR Compliance Gap Analysis to identify gaps within MOJ data protection processes and procedures and identify weaknesses relating to GDPR
• Developed a GDPR Compliance framework and implementation plan, including EU GDPR documentation toolkit.
• Development of GDPR User Guide including setting out tasks and responsibilities of DPO, Data Controllers and Processors, dealing with international data transfer rights and consent of data subjects.
• Liaising with technology partners selling Data protection and Privacy tools and applications, including IBM and Oracle
• Assisted with the MDM project framework by identifying key domains and key functionalities and capabilities for MDM implementation.
• Collaborated with delivery team (Business Intelligence, Solution Architecture, MDM developers, Program manager) to develop and implement Informatica Customer domain MDM solution.
• Designing, installing, configuring core informatica MDM Hub components including Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD
Technology Used: Oracle 11c, Visio 2013, Erwin 9, Microsoft SSIS, Toad, HPUX, Colibra Data Governance
Key Accomplishments:
• Development and implementation of the Business Information model (Conceptual, Logical & Dimensional) for MOJ National Prison Service (NPS) and 21 Community Rehabilitation Companies (CRC) transformation project.
• Successfully developed the Data Governance Vision, Charter & Framework for 21 CRC's and Establishment of Data Stewardship teams for all CRC's.
• Developed the EU GDPR Compliance Framework and Implementation plan for the 21 CRC's.
Implementation, IDD, Manager, Processes, Framework, Processing, Guide, DPO, Assessment, Regulatory, Server, International, Community, Retention, Development, Transformation, Business Intelligence, Data quality, Workshops, Technology, Architecture, Ssis, Compliance, Service, Visio, Finance, Management, Solution architecture, GDPR Compliance, GDpr, Data management, Oracle
2015 - 2016
job
MANAGER, IT GOVERNANCE AND ARCHITECTURE
UNITY BANK.
Responsible for the overall data management strategy of Unity Bank including Data governance, data modelling, data quality, data profiling, Master Data Management and Data integration within the context of an overall Enterprise architecture framework. Further deliverables included managing the delivery of ISO 27001 Information Security Certification.
• Responsible for organisation and design of logical data models, data flows and data dictionaries into a Meta Data Repository and Credit Admin BI solution.
• Defining IT & Data governance policies and ensuring effective implementation and management through Data Stewards.
• Responsible for the re-engineering and re-design of the critical data structures of Unity Bank's core corporate client's database.
• Designed data cleansing and data quality management programs and managed its implementation in collaboration with Information Governance Board.
• Working with major vendors for large IT projects, to support major elements of infrastructure and technologies, including the delivery of major storage platform support implementation.
• Managed the delivery and implementation of enterprise wide data migration project involving Oracle & HP.
• Development of Bank KYC and IML standards as part of an overall Basel II initiatives.
• Defining Customer Policy, Customer Identification procedures, Monitoring of Transactions and Risk management standards of the KYC policy.
• Defining KYC Controls including Name matching, Collection and Analysis of basic customer information and Transaction monitoring.
• Member of Information Security Governance Board responsible for IML initiatives and risk management.
• Evaluation of MDM products including IBM, Infomatica and Talend.
• Implementation and customization of Talend MDM rules, user interfaces and workflows as part of UB's MDM solution.
• Designing the Talend MDM architecture including data models (logical and physical)
• Implementation of master repository for Address and Name for all systems to consume; real-time matching tool to support creation and search of addresses.
• The provision of MDM procedures, policies and standards that serve as solid framework for data uniformity and consistent business practice in the Bank.
• Providing change management expertise in helping the Bank migrate smoothly to the new MDM solution and setting expectations with measurement metrics.
• Working with analysts and IT to define functional and non-functional requirements of several departmental applications.
• Responsible for SLA for all Unity Bank Services and improved business continuity metrics and availability with reduced cost base.
• Acted as Chief Information Security Officer, ensuring IT Controls and key Information security policies are been maintained and strictly applied to external local and international regulatory satisfaction.
• As CISO, governed User Access Management improvements, Records management and Data Privacy issues within Unity Bank.
• Internally undertake security gap analysis and recommendations for corrective actions.
• Coordinate penetration tests with penetration tests experts, performance testing with development and IT teams.
• Conducting quarterly Information Security and regulatory compliance sessions within teams and departments.
• Coordinated the development and implementation of enterprise Information Security Management System (ISMS)
Technology Used: Colibra Data Governance, Oracle 11c, Visio 2013, Erwin 9, Talend MDM, Informatica IDQ, Powercenter, Toad, IBM AIX, HPUX, Tableau, Basel II, SAP Power Designer
Key Accomplishments:
• Established the Enterprise Data Architecture & Data Governance Practice of Unity Bank including developing Enterprise Data models, Architecture Artefacts including Transition and Target Architectures and Templates.
• Directed the implementation and delivery of the Bank's online retail and corporate Internet platforms, generating over $300M annually and developed and implemented training program for staff members to improve its operational efficiency.
• Managed multiple complex projects, reviewing plans to address outcome and carrying out gap analysis and recommended corrective actions
• Achieved the Attainment of ISO27001, ISO20000 certifications as part of the Bank's overall Information Security Management System (ISMS) and Governance initiative.
Key Artefacts/Deliverables: Data Architecture Strategy, Data Architecture Strategy Implementation Roadmap, Data Quality, Profiling and Cleansing Strategy, Extract, Transform and Load Strategy, Conceptual, Logical & Dimensional Data Models, Business Data Dictionary, Data Model Quality Report, Enterprise Data Governance Strategy, Data Privacy Policy, Source To Target Mapping, As-Is, Transition and Target Architectures
• Responsible for organisation and design of logical data models, data flows and data dictionaries into a Meta Data Repository and Credit Admin BI solution.
• Defining IT & Data governance policies and ensuring effective implementation and management through Data Stewards.
• Responsible for the re-engineering and re-design of the critical data structures of Unity Bank's core corporate client's database.
• Designed data cleansing and data quality management programs and managed its implementation in collaboration with Information Governance Board.
• Working with major vendors for large IT projects, to support major elements of infrastructure and technologies, including the delivery of major storage platform support implementation.
• Managed the delivery and implementation of enterprise wide data migration project involving Oracle & HP.
• Development of Bank KYC and IML standards as part of an overall Basel II initiatives.
• Defining Customer Policy, Customer Identification procedures, Monitoring of Transactions and Risk management standards of the KYC policy.
• Defining KYC Controls including Name matching, Collection and Analysis of basic customer information and Transaction monitoring.
• Member of Information Security Governance Board responsible for IML initiatives and risk management.
• Evaluation of MDM products including IBM, Infomatica and Talend.
• Implementation and customization of Talend MDM rules, user interfaces and workflows as part of UB's MDM solution.
• Designing the Talend MDM architecture including data models (logical and physical)
• Implementation of master repository for Address and Name for all systems to consume; real-time matching tool to support creation and search of addresses.
• The provision of MDM procedures, policies and standards that serve as solid framework for data uniformity and consistent business practice in the Bank.
• Providing change management expertise in helping the Bank migrate smoothly to the new MDM solution and setting expectations with measurement metrics.
• Working with analysts and IT to define functional and non-functional requirements of several departmental applications.
• Responsible for SLA for all Unity Bank Services and improved business continuity metrics and availability with reduced cost base.
• Acted as Chief Information Security Officer, ensuring IT Controls and key Information security policies are been maintained and strictly applied to external local and international regulatory satisfaction.
• As CISO, governed User Access Management improvements, Records management and Data Privacy issues within Unity Bank.
• Internally undertake security gap analysis and recommendations for corrective actions.
• Coordinate penetration tests with penetration tests experts, performance testing with development and IT teams.
• Conducting quarterly Information Security and regulatory compliance sessions within teams and departments.
• Coordinated the development and implementation of enterprise Information Security Management System (ISMS)
Technology Used: Colibra Data Governance, Oracle 11c, Visio 2013, Erwin 9, Talend MDM, Informatica IDQ, Powercenter, Toad, IBM AIX, HPUX, Tableau, Basel II, SAP Power Designer
Key Accomplishments:
• Established the Enterprise Data Architecture & Data Governance Practice of Unity Bank including developing Enterprise Data models, Architecture Artefacts including Transition and Target Architectures and Templates.
• Directed the implementation and delivery of the Bank's online retail and corporate Internet platforms, generating over $300M annually and developed and implemented training program for staff members to improve its operational efficiency.
• Managed multiple complex projects, reviewing plans to address outcome and carrying out gap analysis and recommended corrective actions
• Achieved the Attainment of ISO27001, ISO20000 certifications as part of the Bank's overall Information Security Management System (ISMS) and Governance initiative.
Key Artefacts/Deliverables: Data Architecture Strategy, Data Architecture Strategy Implementation Roadmap, Data Quality, Profiling and Cleansing Strategy, Extract, Transform and Load Strategy, Conceptual, Logical & Dimensional Data Models, Business Data Dictionary, Data Model Quality Report, Enterprise Data Governance Strategy, Data Privacy Policy, Source To Target Mapping, As-Is, Transition and Target Architectures
Storage, ISO27001, Infrastructure, Testing, Development, IT governance, Monitoring, ISO 27001, BEE, SOLID, Organization, International, Enterprise data architecture, Implementation, Regulatory, Search, Internet, Aix, Power, Enterprise, KYC, Online, Framework, Access management, Manager, Basic, Unity, Change management, Oracle, Retail, Training, SAP, Database, Data management, Tableau, Information Security, Risk Management, Management, Integration, Design, Visio, Compliance, Architecture, Engineering, Security, Technology, Quality Management, It, Master Data Management, Support, Data quality
2013 - 2014
job
ENTERPRISE DATA ARCHITECT
LONDON STOCK EXCHANGE.
The program was to integrate all the disparate customer data held across different platforms globally, into a new data warehouse (EDW), improve CRM reporting efficiency, provide single point of customer reference, enhance productivity, provide Customer Behavioural Analytics and Omni-channel Predictive Analytics for management decision making.
• Responsible for ensuring that the information and Data solutions proposed for the program are fit for purpose, including ensuring quality assurance for the overall technical design work done by delivery teams.
• Responsible for identifying data assets, data standardization and delivery of the data integration architecture for multiple subject areas including Agents & Accounts.
• Responsible for the delivery of data from multiple sources that include RMS, Self-Service reference data, Transaction data, SAP, CRM, mobile devices, big data store to a new data ware house (EDW) data marts on (Oracle) Platform.
• Involved in the complete project life cycle from RFP, Business Requirement Gathering, Impact Analysis, Technical Designs, Solutions Design, High level Design (HLD), Low Level Design (LLD), Technical Design Document (TDD), Implementation Build, Testing and Deployment.
• Conceptual, logical and physical data modelling, plus installation and configuration of Oracle 11g on Redhat Linux on Sun Blade cluster.
• Designed source to target data mapping solutions form various legacy systems and other sources, following a detailed transformation logic
• Responsible for the design of the Conceptual, Logical Physical and Models of both the "as is" and "to be" data structures and gap-fit analysis.
• Responsible for the delivery of end-to-end data and integration architectures in support of multiple enterprise systems, whilst compatibility and compliance with policy and standards.
• Designed AS-IS and TO-BE Target Architecture documents and blueprint for Integration Architecture Patterns.
• Designing lightweight Registry hub for Products MDM across multiple applications.
• Documentation of Governance and Regulatory framework for all MDM projects.
• Responsible for evaluating the Talend MDM and Data Governance architectures in collaboration with Talend Consultants.
• Data Architect and Technical Architect on Customer Repository System: Defined technical architecture and data architecture and designed Entity relationship Models for OLTP, (300 tables) using Oracle 9i Application Server, EAI, Oracle10g, Solaris and UML modelling
• Responsible for Data analysis, design of logical and physical data models in ERwin and managing the data architecture and requirements for new Operational Data Store, including developing, maintaining and the administration of the Canonical Data Model.
• Responsible for designing the DW Dimensions and Facts, determining the Business Processes, Identifying the Grains and Hierarchies using the Kimball's DW Development methodologies.
• Responsible for the evaluation of competing ETL, Reporting and Analytics tools for different program of work.
• Carried out preparatory work for Customer Master Data Management through the modelling of multiple reference customer data repositories.
• Design of Technical and Domain architectures in support of various Interactive web based platforms and portals for local and international customer base.
• Responsible for the implementation of several COT packages including large packages and custom solutions design as transition and target architecture deployment.
• Responsible for the development of data retention, archival and retrieval policies for the Global Customer Repository Program; including policies for the preservation of strategic data assets.
• Responsible for ensuring that the information and Data solutions proposed for the program are fit for purpose, including ensuring quality assurance for the overall technical design work done by delivery teams.
• Responsible for identifying data assets, data standardization and delivery of the data integration architecture for multiple subject areas including Agents & Accounts.
• Responsible for the delivery of data from multiple sources that include RMS, Self-Service reference data, Transaction data, SAP, CRM, mobile devices, big data store to a new data ware house (EDW) data marts on (Oracle) Platform.
• Involved in the complete project life cycle from RFP, Business Requirement Gathering, Impact Analysis, Technical Designs, Solutions Design, High level Design (HLD), Low Level Design (LLD), Technical Design Document (TDD), Implementation Build, Testing and Deployment.
• Conceptual, logical and physical data modelling, plus installation and configuration of Oracle 11g on Redhat Linux on Sun Blade cluster.
• Designed source to target data mapping solutions form various legacy systems and other sources, following a detailed transformation logic
• Responsible for the design of the Conceptual, Logical Physical and Models of both the "as is" and "to be" data structures and gap-fit analysis.
• Responsible for the delivery of end-to-end data and integration architectures in support of multiple enterprise systems, whilst compatibility and compliance with policy and standards.
• Designed AS-IS and TO-BE Target Architecture documents and blueprint for Integration Architecture Patterns.
• Designing lightweight Registry hub for Products MDM across multiple applications.
• Documentation of Governance and Regulatory framework for all MDM projects.
• Responsible for evaluating the Talend MDM and Data Governance architectures in collaboration with Talend Consultants.
• Data Architect and Technical Architect on Customer Repository System: Defined technical architecture and data architecture and designed Entity relationship Models for OLTP, (300 tables) using Oracle 9i Application Server, EAI, Oracle10g, Solaris and UML modelling
• Responsible for Data analysis, design of logical and physical data models in ERwin and managing the data architecture and requirements for new Operational Data Store, including developing, maintaining and the administration of the Canonical Data Model.
• Responsible for designing the DW Dimensions and Facts, determining the Business Processes, Identifying the Grains and Hierarchies using the Kimball's DW Development methodologies.
• Responsible for the evaluation of competing ETL, Reporting and Analytics tools for different program of work.
• Carried out preparatory work for Customer Master Data Management through the modelling of multiple reference customer data repositories.
• Design of Technical and Domain architectures in support of various Interactive web based platforms and portals for local and international customer base.
• Responsible for the implementation of several COT packages including large packages and custom solutions design as transition and target architecture deployment.
• Responsible for the development of data retention, archival and retrieval policies for the Global Customer Repository Program; including policies for the preservation of strategic data assets.
Server, Master Data Management, Support, Quality Assurance, Implementation, Transformation, Testing, Development, RFP, Retention, International, UML, Web, Regulatory, Patterns, Enterprise, Logic, Framework, Kimball, Processes, Blade, ETL, Data Analysis, Linux, Administration, CRM, Oracle, Big Data, SAP, Data Warehouse, Data management, Design, Deployment, Management, Integration, Analytics, Service, Compliance, Architecture, TDD, Predictive Analytics
2014 - 2014
job
XML, Tableau, SPARX EA (Enterprise Architect)
SSIS, SSRS,SSAS, MDM, MDS, DQS.
Business Objects, Oracle11G, Oracle, Oracle RAC, Erwin. Unix Scripting, SAN Storage systems, Windows 2008 r2, MS Visio, Excel, PowerPoint.XML, Tableau, SPARX EA (Enterprise Architect). UML, Agile methodology, Alteryx, Dimensional models Type-2 andType-3. IBM Infosphere Datastage, IBM Industry Models, Infosphere Data Warehouse, Amazon Redshift, Snowflakes Cloud Datawarehouse
Key Accomplishments:
• Designed technical solutions for the management, storage, access, navigation, movement and transformation of data.
• Designed source to target data mapping solutions form various legacy systems and other sources, following a detailed transformation logic and the design of Data Integration architecture.
• Providing technical leadership across database, applications, infrastructure and the delivery teams.
Key Artefacts/Deliverables: High level Design (HLD), Low Level Design (LLD), Technical Design Document (TDD), Logical & Physical Models, Dimensional Data Models, BI Data Mart Data Model, Source To Target Mapping, As-Is, Transition and Target Architectures
Key Accomplishments:
• Designed technical solutions for the management, storage, access, navigation, movement and transformation of data.
• Designed source to target data mapping solutions form various legacy systems and other sources, following a detailed transformation logic and the design of Data Integration architecture.
• Providing technical leadership across database, applications, infrastructure and the delivery teams.
Key Artefacts/Deliverables: High level Design (HLD), Low Level Design (LLD), Technical Design Document (TDD), Logical & Physical Models, Dimensional Data Models, BI Data Mart Data Model, Source To Target Mapping, As-Is, Transition and Target Architectures
Windows, Oracle RAC, Logic, Enterprise, SAN, Redshift, Storage, Amazon, Alteryx, BEE, Infrastructure, Transformation, UML, TDD, Architecture, Visio, Design, Integration, Management, Leadership, Tableau, Unix, Scripting, Cloud, Data Warehouse, Database, Agile, XML, Oracle, Powerpoint, Excel
My education
?
-
1992
MIDDLESEX UNIVERSITY
MBA, Business Administration
MBA, Business Administration
?
-
1988
UNIVERSITY OF SCIENCE AND TECHNOLOGY
BSc, N/a
BSc, N/a
Somina's reviews
Somina has not received any reviews on Worksome.
Contact Somina Membere
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Somina directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark