Sinéad Breen

Experience

• 

  ERS Computer Solutions

  Feb 1997 - Sept 1999

  Software Developer

  Managing client meetings. Specifying, designing, developing and implementing various MSAccess applications. User training and support. Developing Sales Process software. Developing Stock Management software.

• 

  Experience IT Limited

  Oct 1999 - Mar 2004

  Senior Analyst Developer

  System Analysis and design of self-invoicing and sales applications.Data and code migration to Oracle 8i.Development and maintenance of several Oracle 8 and 9i applications requiring extensive use of SQL and PL/SQL.Complex front-end Access Development using VBA, MAPI and SQL.Development and maintenance of AMDOCS and BI integration logic and code.

• 

  O2 Ireland (a Telefónica Company)

  Apr 2004 - Sept 2007

  Senior Software Developer/Principal

  Development and maintenance of several Oracle 9i applications requiring extensive use of SQL and PL/SQL using triggers, sequences, views, procedures, XML, dynamic SQL etc. Developed N-Tier interface to Oracle for Middleware applications. Migration from Oracle 9i environment to Oracle 10g environment. Develop and maintain PL/SQL scripts for subscriber activity Data Mart. Developed dynamic SQL reporting tools allowing business users to generate reports using Data Mart data without SQL knowledge as SQL. Developed reporting tool security which made results user-specific. Oracle Performance tuning using Explain Plan and index analysis. Show less

• 

  AIG

  Oct 2007 - Apr 2008

  Technical Design Engineer (Contract)

  Investigating cause of, and technical solution to production issues in Sybase TSQL PL/SQL and Cobol environments. Review test results with BA and business owners to ensure quality and correct application of changes as per business expectations. Provide DBA team with change details for implementation on live environments.

• 

  Uniphar

  Apr 2008 - Dec 2009

  Data Migration and Integration Consultant (Contract)

  Formation of the Data Migration Strategy for the Uniphar Chrysalis Project.Master Data Source to Target MappingAnalysis, Extraction, Cleansing, Transformation & Loading of data from various legacy systems to SAP MM, FI & SD modules using SAP LSMW.Developed bespoke de-duplication software using VBA and Microsoft SQLDeveloped E-Forms application using SQL Server and MS Access Forms and Reports to create an intuitive GUI and GxP standard output Forms.Designed Data Governance workflow for E-Forms to allow business departments to more easily co-ordinate Master Data creation and sign-off activities post initial migration Show less

• 

  ICON plc

  Feb 2010 - Nov 2015

  Worked with Enterprise Architects to develop an information-sharing and analytics strategy for the organization, and ensure it supports key enterprise initiatives.Contributed to evaluation of emerging trends in enterprise-wide information sharing, such as big data, open data and linked data, and determine the impacts on the future-state EIA.Supported the creation of process, information or data models and the design of generalized interfaces for achieving information-sharing environments.Provided recommendations around frameworks and supporting processes and procedures to appropriately diagnose enterprise or line of business data quality issues, remediate them, and monitor the data quality.Lead efforts to redesign or modify the EIA as part of, or in coordination with, business improvement initiatives.Worked with business and IT stakeholders to evaluate complex situations accurately and identify viable solutions that create successful outcomes for the customer. Show less Dimensional Modelling using Embarcadero Data ArchitectETL development using ODIRPD and Report Development using Oracle OBIEE 10 and 11gSource system to Data Warehouse Mapping and Dimensional Modelling. Involving translation of complex SQL into concise dimension/metric definitionsData Analysis, Source to Data Warehouse Mapping & Business process MappingReporting requirements gathering, Data Quality assessment and process improvementApplication of the Scrum Agile Methodology to all project work Show less

  • Information Architect

    Apr 2015 - Nov 2015

  • Master Data Management Hub Analyst and Technical Lead

    May 2013 - Apr 2015

  • Senior Business Intelligence BA and Developer

    Oct 2010 - May 2013

  • Data Migration Consultant (Contract)

    Feb 2010 - Oct 2010
• 

  Valiance Partners

  Dec 2015 - Mar 2023

  Data Migration Lead

  Lead for several Content Management and Registration data migrations to Veeva Vault Source and Target System Data Analysis using SQL, PL/SQL (Oracle and SQL Server) Content Management System Migrations to Veeva Vault in Validated environmentsContent and meta-data migrations using validated TRUmigrate migration softwareSource to target comparison using TRUcompare validation softwareGxP standard Validation and Testing

• 

  MovieExtras.ie

  Nov 2023 - now

  Extra