Stephen Hamilton Email & Phone Number

Belfast, Northern Ireland, United Kingdom

Belfast, United Kingdom

Specialised Analytics Manager

Belfast, United Kingdom

Fulfilling two roles within Pearson CurrentlyBusiness Intelligence AnalystBuilding reports and dashboards from functional specifications in OBIEE.Solving complex reporting requirements by using formula within OBIEE to produce bespoke calculations for the business.Assisting the ETL process by locating sources tables and data in SQL Developer to enable to migration of data.Detailed documentation of report testing approvals and quality assurance.Supporting existing… Show more Fulfilling two roles within Pearson CurrentlyBusiness Intelligence AnalystBuilding reports and dashboards from functional specifications in OBIEE.Solving complex reporting requirements by using formula within OBIEE to produce bespoke calculations for the business.Assisting the ETL process by locating sources tables and data in SQL Developer to enable to migration of data.Detailed documentation of report testing approvals and quality assurance.Supporting existing reports to ensure they meet standardisation guidelines and follow the Reporting Governance Model.Liaising with stakeholders to gather reporting requirements and create functional report specifications.As a member of the reporting delivery team responsible for service management for finance reporting across Pearson.Providing technical assistance and cross training to other team members.Financial Systems AnalystSupport Planning, Budgeting, & Forecasting Activities, by performing data extracts, transformations and load using, Oracle Hyperion Planning, Essbase and Smartview.Consolidate and translate Hyperion metadata maintenance requests for system administrators and rectify any data kick out logs and ensure data integrity during close processesMapping data to allow accurate data migration to take place between the various systems and the various chart of accounts. as well as reconciling and rectifying the variances and data integrity issues that arise during these processesCompleting data validations and identify variances across accounting systems. Create monthly audit backup for system integrity checks.Use advanced Excel techniques such Power query, Power pivot, in addition to other standard and complex Excel formulae, such as Index Matches, vlookups etc… to produce mapping files, and ad-hoc analysis between the various systems. Show less

Belfast, United Kingdom

The role of a SAS Data Analyst consists of developing SAS code, that creates analysis datasets, tables, figures, listings and electronic submission packages, to be included in Clinical Summary Report submissions to the Health authorities, for example the Food and Drug Administration (FDA).Performing Statistical QC of peer’s final reports to ensure a high standard of data quality and integrity.Compile final packages consisting of all relevant study documentation, datasets, tables… Show more The role of a SAS Data Analyst consists of developing SAS code, that creates analysis datasets, tables, figures, listings and electronic submission packages, to be included in Clinical Summary Report submissions to the Health authorities, for example the Food and Drug Administration (FDA).Performing Statistical QC of peer’s final reports to ensure a high standard of data quality and integrity.Compile final packages consisting of all relevant study documentation, datasets, tables, listings and figures and arrange the electronic data transfer to the study sponsor Show less

Ballymena

Managing a team of staff as well as all aspects of the LCID community information system. Some of which included. Developing reports, facilitating System Developments to user and supplier requirements. User Acceptance Testing. User Training.In addition, be responsible for reducing a range of reporting requirements from various systems and tools such as MS Access Databases, Business Objects, QlikView and the Healthcare Systems in the Trust

Holywell Hospital Antrim

Facilitating the rollout of ICT Projects. Project Management. PRINCE2 based projects. Requirements Analysis. Process Mapping. User Training. System Management