Claire Dyer

Experience

• 

  TM-TECHNOLOGY

  Jul 1996 - Dec 1996

  Software Engineer

  The design and development of GUI's for the front end of SCADA packages using Power VB

• 

  Sema Outsouring

  Jan 1997 - May 1998

  Software Engineer

  To design and develop PC based software applications, for use on standalone and networked systems using MSAccess 2.0, DataEase 4.53, VB 4.0, Oracle8 and DSDM for customers within the DSS and its Agencies • This encompassed all activities of the software lifecycle ranging from visiting the customers to obtain a detailed technical analysis of requirements through to installation and support of the end product• Other duties included the evaluation, maintenance and enhancement of existing systems all working within tight timescales and budgets and to a defined Quality Management System (QMS). Show less

• 

  Pindar Systems

  May 1998 - Apr 1999

  Oracle Developer

  To design and program all server-side PL/SQL stored packages and procedures on an Oracle8 development database, running on an NT platform within three-tier client server architecture • Administration of the development database, implementing and maintaining database security and the creation and maintenance of all tables, triggers, indexes, synonyms and sequences

• 

  Canada Life

  Apr 1999 - Jan 2000

  Database Administrator

  The implementation of a core CRM and workflow system for over 150 users• The creation of the Oracle8 database, data loading from the legacy policy processing system and the development of the PL/SQL procedures for the nightly data processing and updates • Working as part of a team managing and administering numerous other Oracle8 and Oracle7 development and production environments running on NT, HP-UX 10.20, and AIX 4 platforms • Database design modifications, installation and upgrades of software and the creation and maintenance of the command centre database to monitor and assist with tuning and maximising the performance of all the production environments Show less

• 

  Bank of Ireland Asset Management

  Mar 2000 - Jul 2002

  Oracle Database Administrator

  Working in a team as an DBA \ PL/SQL developer on a high profile data warehousing project for the asset and wealth management division.• Development of data loading, validation and transformation routines for client holding information received in various internal financial service companies and external financial institutions • Development of inbound and outbound interfaces between the data warehouse and the main CRM and Internet applications, allowing clients access to a complete net worth statements• Assisting in the development of database monitoring, backup and contingency strategies including the creation of the standby database• General administration of production and development databases in an NT environment Show less

• 

  Marrakech

  May 2000 - Mar 2001

  Oracle Database Administrator

  Working as an Oracle 8i development DBA for a B2B company • The implementation and management of the day-to-day operation of all development and test databases on a UNIX/Solaris platform • This included the creation of databases, maintaining reliable backup and recovery strategies, Unix shell scripting, database maintenance and performance tuning • The design of database changes for ongoing application releases using Oracle Designer• The development of all PL/SQL packages and triggers and the loading and wrapping of JAVA classes Show less

• 

  IMS Health

  Oct 2002 - Jun 2005

  Senior Oracle Developer

  Supporting production and development environments in a team providing 24X7 support for over 200 large Oracle data warehouses and 150 SQL server databases on IBM AIX5.1/ 5.3 and Windows 2000 platforms.• Primarily working in an Oracle development team as a SQL developer / DBA creating a multi-county data warehouse of pharmaceutical sales data to be used as input into forecasting algorithms• Responsible for designing, modelling, coding, testing and tuning the databases • Development of the loading, validation and extraction PL/SQL packages, SQL*Plus scripts, SQL*Loader control files and Unix shell scripts• Configuring the environments and application backup & recovery strategies and ensuring all necessary security and access controls are in place• Performing object sizing and capacity planning and providing input into the growth and deployment of the production databases• Support in the identification and resolution of database problems (reported by Patrol, users, developers and support teams)• Installing software, patches and upgrades• Liaising with the Unix team to maintain file systems, database files and account management Show less

• 

  Dexia

  Jun 2005 - Sept 2005

  Senior Oracle Developer

  Contracted to develop and administrator Data Warehouse. Project cancelled due to changes in strategic planning.• Provide a central repository for analysis and reporting for the investment banking division• Implement database backup strategies• Test disaster recovery for all third party applications, which included Sybase, SQL Server and Oracle

• 

  Royal Bank of Scotland Business

  Sept 2005 - Jul 2012

  Oracle Projects \ Development DBA

  Technical Lead for numerous projects/programmes within the bank.• Including the Group Risk Data Warehouse which consolidates on and off balance sheet information across the whole Group providing data to a number of downstream operational & MI reporting systems• Engaging with onshore and offshore team members supporting the Production environments, Managed test Environments (MTEs) and compressed MTEs available to support and test applications• Root cause investigation analysis• Environment refresh strategies • Performance testing to ensure no adverse impact on current business SLAs• Ensuring adequate resourcing capacity for the implementation of the multiple production releases for the numerous on going projects• Review and sign off of designs, review of operational acceptance testing and operational principles• Advise on project waivers and exceptions to process• Authorising of team changes into the production and non functional Oracle estates to complying with the manage change process allowing the successful management and delivery of change Show less

• 

  Bishop Justus secondary and sixth form

  Sept 2014 - Sept 2016

  Computer Science Teacher

  Secondary school teacher, responsible for instructing Computer Science. Graded as outstanding during observation.• Planned lessons which adhered to curriculum objectives using a range of teaching methodologies• Prepared schemes of work, both short and long term• Sourced and created differentiated resources responding to students learning needs• Utilised classroom management techniques to create a positive environment for learning • Adapted a range of teaching and learning strategies to allow students to achieve their full potential• Record keeping and assessment recognising the importance of effective feedback and reporting • Advised older pupils with decisions about their careers• Adhered to school behaviour and management policies• Assisted in developing a popular after school club• Created constructive relationships with students to maximise learning Show less

• 

  Interpublic Group (IPG)

  Sept 2019 - now

  Project Manager delivering technical solutions to support the global privacy programme in meeting legal compliance obligations and expectations of clients.• Delivering a project with a highly complex data architecture to key milestones • Management and co-ordination of multiple workstreams across various business areas• Maintaining successful working relationships with all programme stakeholders• Translating business requirements into tangible, realistic technology deliverables and IT solutions• Regular and effective communication between all impacted parties ensuring common understanding of scope, deliverables, and progress Show less Working as a technical resource for the legal team responsible for the delivery of the GDPR privacy programme providing data compliance for EMEA. The development and administration of the One Trust third party privacy management platform supporting the rollout of the legal framework and policies of the collection and processing of personal information with the added complexities of working in a complex structure of 5 major marketing networks with 100+ subsidiary companies to deliver a comprehensive solution. Show less

  • IT Project Manager

    May 2022 - now

  • GDPR System Administrator

    Sept 2019 - May 2022