Stephen Hamilton

Experience

• 

  Northern Health and Social Care Trust

  Mar 2013 - Oct 2017

  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 Facilitating the rollout of ICT Projects. Project Management. PRINCE2 based projects. Requirements Analysis. Process Mapping. User Training. System Management

  • System Manager

    Mar 2016 - Oct 2017

  • Project Administrator

    Mar 2013 - Mar 2016
• 

  Celerion

  Oct 2017 - Apr 2018

  SAS Data Analyst

  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

• 

  Pearson

  Apr 2018 - Dec 2019

  Business Intelligence Analyst / Financial Systems Analyst

  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

• 

  Citi

  Dec 2019 - now

  Specialised Analytics Manager

  • Project Management Lead

    Oct 2022 - now

  • Assistant Vice President

    Dec 2019 - now