Senior Data Architect

• Jan 2022 - Present

Data Architect

• Nov 2019 - Dec 2021

Involved in a global transformation programme, from the initial design phase through to go-live and now providing analytics capability.Main Responsibilities:• A solution to extract key information from all internal transaction systems and transform or merge the data before loading into different environments.• Provide a consolidated data solution to align both Master Data and reference data with several different business systems.• Designed and developed an alignment solution which allows all Record to Report (RTR) to show consistence information which is being sourced from different transactional systems. • Setting-up a process of gathering all possible meta-data (Technical and Business Logic) from different systems globally for the Enterprise-wide data catalogue.• Working alongside the global Enterprise Architect to establish the Business Intelligence Competency Centre (BICC).• Conceptualize a data warehouse solution with BI reporting capability for the company’s global consolidation commercial system.• Provide Architecture and Data presentation to senior leadership team for project scope and budget approval

Data Analyst

• Mar 2017 - Oct 2019

• Interpreted data from multiple discrete and disparate systems to identify common/uncommon nature of the same by analyzing the results• Identified patterns and trends in commercial data sets to convert it into meaningful information• Reported the results back to the relevant members of the business• Worked alongside the business and technical development teams to establish business needs• Evaluated the customer’s internal systems for efficiency, problems, and inaccuracies, and helped in developing and maintaining protocols for handling, processing, and cleaning data• Worked directly with management and users to gather requirements, provide status updates, and build relationships

Data Engineer

• Oct 2015 - Feb 2017

• Designed data extraction and processing methods of the data warehousing project. Originally taking over an hour to complete, the end to end processing time was reduced to a few minutes after introducing some performance enhancements.• Designed and helped build the ETL process which populated the dimension and fact tables for a number of different cubes. Utilized Microsoft SQL Server, SSIS, PL/SQL, stored procedures and database triggers.• Design and implement SQL Server databases for a market research application rewrite working in Agile development team.

Lead Consultant

• Nov 2013 - Sep 2015

• Managing a small technical team, who had experience in Microsoft Database and ETL technologies• Performing the role of a technical team lead giving direction and support to other team members• Producing technical specifications from functional specifications• Reviewing all test plans and procedures for the data load processing

Database Designer and Developer

• Mar 2011 - Oct 2013

• Working with System Analysts and Development managers to ensure database designs were developed according to the agreed requirements and timelines.• Developing and deliver database designs across multiple projects to application teams and support designs in development, test and production environments.• Detailed data analysis was performed to determine the root causes of the data quality issues.• Developed the appropriate logic to fix the data quality issues so the data was valid, accurate, and correct, and verified that the correct data relationships existed.

Junior Lecturer

• Jun 2009 - Feb 2011

• Trained student with adept knowledge and intense care. • Assisted student on yearly project activities. • Designed, implemented and administered training schedules. • Evaluated and assessed student progress. • Assisted and supported other personnel in classroom management. • Trained student with adept knowledge and intense care. • Assisted student on yearly project activities. • Designed, implemented and administered training schedules. • Evaluated and assessed student progress. • Assisted and supported other personnel in classroom management.