SUMMARY:

• A business focused Data Management Professional with extensive end to end technical implementation experience MDM Data Architecture, Data Quality, Business Intelligence (SQL), ETL/Data Migration and Integration, Golden Record Management, coding Complex Business Rules with Advanced SQL & RegEx Skills; has a solid academic record in Computer Science, Economics & Applied Statistics; seeking opportunities in the Data Quality, MDM and Business Intelligence industry.
• Over 10 years experience in Data Management, BI/SQL Development, Data Quality and MDM, Data Architecture with On - site Client-facing engagements in the UK, EU & North America and liaison with off-shore colleagues
• Deep exposure to a wide variety of Data Domains and Large Scale Data sets across multiple industries including; Investment Banking, Insurance, Fraud Detection, HR, Transport, Retail, GOV, etc. in domains such as Party, Product, Address and Accounts.
• Solid track record of tactfully liaising with non-technical and technical Client Personnel at all levels to establish requirements and follow-through with strong technical skills for successful implementation across multiple teams and stakeholders
• A flexible team player and confident self-starter with timely delivery of 3/4 million worth of projects in the last 12 months -yielding over 1 million ROI in data enrichment benefits within year-1 of project implementation.

SKILL:

• 10 years’ experience in MDM & Data Quality Profiling, Cleansing, Mapping, Match & Merging Data from over 70 Disparate Sources
• 5 years expertise in Data Architecture & Modeling Conceptual, Logical and Physical Data Modeling, MDM Database Design with Referential integrity constraints and other complex business rules.
• 10+ years in Data Migration & Integration from internal, M&A and 3rd party sources using ETL Tools on RDBMS, CSVs, FTP loads, Web services: REST APIs, SOAP and delivering outbound Data as a Service through REST APIs
• 14+ years expertise in SQL programming and Data Analysis: stored procedures, functions, regular expressions, queries with multiple joins, subqueries, grouping, aggregation, pivoting, logical CASE switching, String Manipulation, Data Comparison etc.

TECHNICAL SKILLS:

Data Visualization & Reports: SSRS, PowerBI, SAP Business Objects, Tableau

Advance Excel: Macros, Pivot Tables, Slicers, Data Analysis Expressions (DAX) and several advanced formals

Tools: Informatica MDM, Reltio, Ataccama DQ, Colibra and Data3Sixty, Postman, SOAP UI, Jira, Slack, Github, HP ALM, Putty, PowerShell, ER Studio, ERWIN, SAP Power Designer, Advanced MS Office

Programming: SQL, Excel VBA, Basic Java, C#, Python & Regular Expressions, Able to quickly master the Basic syntax & semantics of any programming language over a weekend

EMPLOYMENT HISTORY:

Confidential

MDM Data Architect - Informatica MDM

Responsibilities:

• Hands-on End to End implementation of Informatica Multi-domain MDM for multiple Subject Areas/Domains including Party Location, Activity Centres and Activity Points. Quickly leveraged years of experience and own suite Project Accelerator Templates to build and demo a comprehensive MVP within my first 40 days.
• Designed and built a Physical Data Model in Informatica MDM Hub Console based on a Conceptual & Logical Data model built in SAP Power Designer with complex referential integrity and data quality constraints.
• Built Landing Tables used by Power Centre ELT to load data from Sources Systems
• Built Staging tables, Coded Business Rules in Custom Cleansing functions to map, match, merge and enrich data as it is loaded from Staging tables to Base Objects
• Configured Match Paths and built Put-packages and Display packages for external data access via SOAP or REST APIs
• Used IDD and the Provisioning Tool to configure a business friendly user interface for real time data management, data entry, matching & merging and approval workflows based on Entity360 Framework REST API
• Configured attribute level RBAC Security using Resource Groups and role inheritance
• Interviewed and coached of 2 junior colleagues to support post go-live actives as part of the 9 month of implementation programme.

Confidential

MDM Architect - Data Quality

Responsibilities:

• Design and Implementation of a Multi-domain MDM solution with a focus on Data Quality Improvements and Governance for Insurance Brokerage data sets including Parties, Addresses, Markets, Policies, Products, Business Units, Employees, etc. from 30 plus Data Sources across the world, as Confidential rapidly grows through a stream of mergers and acquisitions.
• Initiated a transition from Microsoft Master Data Services (MDS) and DQS to leveraging market leading tools such as Reltio, Ataccama, Colibra and Data3Sixty in building a 360-degree view of data
• Share and Track across the organisation to improve Data Quality & Governance, Regulatory Reporting and Support Underwriting Operations.

Confidential

Master Data Management Consultant

Responsibilities:

• Design and Development of a MDM solution for Funds and Investment Portfolios using Microsoft Master Data Services (MDS), Data Quality Services, Power BI, SSIS and SSRS to build a 360-degree view of data across the organisation to improve Data Quality, Regulatory Reporting and better Service Delivery.
• Using Custom Business Rules, DQS Matching, Store Procedures and extensive ETL to stage, enhance and transform data from over 70 provider systems to ensure consistency, respond to customers and improve overall data quality in the Data Warehouse (DWH), Operational Data Store (ODS) and several downstream systems on behalf of multiple business partners.

Confidential

BI Consultant/ Data Engineer

Responsibilities:

• Implementing Workforce Planning and People Analytics solutions using cloud based Big Data technologies for multiple Blue Chip clients across Financial Services, Pharmaceutical, Manufacturing and Mining Industries
• Presented a harmonised view of HR data for Global entities sourcing data from disparate multinational and local systems, inconsistent organisation structures, pay scales, insurance schemes and other benefits across multiple currencies and compensation policies

Confidential

Business Intelligence Analyst -MDM Developer

Responsibilities:

• Design and Development of BI Analytics and MDM solutions using Microsoft Power BI, SSIS, SSRS, MDS, Data Quality Services and MultiVue MDM to build a 360-degree view of data across the organisation to improve Data Quality, Detect Fraud, Identify Savings and promote Self-service Analytics for better Service Delivery.
• Using T-SQL to Extract and Enrich data to increase revenue, ensure consistency, respond to customers and improve overall data quality on behalf of multiple business units within the Organisation with a clear focus on presenting a single persistent version of the truth across Person, Property and Transactions.

Confidential

Projects Manager - Data Analysis & Business Intelligence

Responsibilities:

• Design and Development of Business Intelligence (BI) Solutions for Parking Enforcement and Payment Systems on behalf of multiple
• Confidential Clients across the country.
• Won the BPA National Young Professional as a Data Analyst in 2016 Define and generate business relevant data for Reporting 10 KPIs with 50+ measurable sub-indicators and SLAs.
• Delivered a single version of the truth across the business using MDM driven interactive dashboards SSRS reports and self-service analysis cubes
• Developed and maintained Interactive Reports for Haringey Adult and Leisure Services
• Created scripts and automation for the loading of business data for report use.
• Developed stored procedure, views, functions and scripts and batch jobs for client
• Designed and developed Functions, Common Table Expressions and SQL Objects for data transformation in SQL Server environment.