Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Scott P Wallace

Scott P Wallace

Information Analyst

Royal Bank of Scotland

Experienced Systems & Information Manager, Business / Data Analyst

Message
MENU ☰

Royal Bank of Scotland

Information Analyst

Selected by PWC for a 6 month contract to work in Non-Core HR to manage, maintain, control and report on all HR data particularly salary & bonus. RBS are undergoing what is the biggest global restructuring ever undertaken by a financial institution, and working in non-core HR is at the forefront of this restructuring. After initial 6 month contract was offered the role on a permanent basis.

Main responsibilites:
- Provide timely and accurate reports to HR Business Partners, Senior Exec's, leadership teams and execs. Showing market comparisons, bonus modelling salary data and streamlined waterfall reports.
- Provide analysis for large-scale global redundancies or repotting.
- Ensure Peoplesoft data is correct and maintained allowing for accurate data retrieval and report production.
- Work closely with IT teams and HR solution teams to ensure that our reporting needs can be met and advise on how data can be maintained and kept accurate.
- Maintain and manage hierarchy reports for the whole of non-core.
- Priovide reports and data to RemCo and ExCo and head of Non-Core.

Career medium 04
Career
Career medium 02

IG Index Plc

Reports Analyst

Selected to join the worlds leading online financial markets, gaming and spread-betting company to advise on and implement a reporting enterprise structure enabling the business to data mine effectively and efficiently. Create, write and distribute reports capturing circa 40+ global websites to aid analysts and business executives. Manage and take ownership of the entire reporting structure creating and distributing clear, concise and accurate reports. Work closely with all business areas to understand their reporting and data requirements and to implement solutions. Ensuring finance, marketing, sales, web analysts and IT teams, including chief executives and stake holders are armed with a wealth of information. Making key recommendations to DBA's to implement new tables, fields and reference data to ensure business requirements are met and to future-proof data integrity. Liaise with IT, Business and stake-holders and develop a close working relationship with each ensuring all reporting requirements, data management and analysis needs are met and delivered.

Main Responsibilities:
- Create and build reports using Crystal Reports (CRXI) from a range of data sources such as Oracle, Heat and financial spreadsheets.
- Analyse and produce reports on web trends across circa 40 websites, including Mobile & iPhone.
- Manage report infrastructure using BOE and InfoView, automating delivery through various channels such as email & network drives at key business times in a multitude of formats, from detailed spreadsheets to PDF dashboards.
- Create customer focus analysis reports, detailing client trends and behavioural patterns for all global clients.
- Analyse data for business decisions, highlighting areas of growth, or downturn in market and areas requiring more pro-activity.
- Create 'on demand' real-time reports to aid managers limit risk exposure in ever changing market conditions.

Career

HSBC Bank UK

Strategic Systems Manager

Design, implement and manage a complete property portfolio system and database with one of the worlds leading banks from inception to global roll-out. Purpose of system is to store all information relating to the branch portfolio, including staff, sales, customer focus, external contractors, operational and capital expenditure. Taking ownership of data, ensuring integrity, accuracy and ensuring Data Protection measures are adhered too. Provide support to users worldwide and continue to enhance system ensuring user requirements are met enabling the system to evolve with ever changing business needs.

Main Responsibilities:
- Manage the Multinational Property Portfolio System for UK & global users including data ownership and data integrity and producing reports and data analysis.
- Manage global roll-out ensuring users are fully trained and equipped to use the system effectively.
- Interacting with stakeholders, senior managers and other business areas and building strong working relationships ensuring business efficiency and ensuring cohesion between Business and IT.
- Write detailed procedures ensuring every process is documented clearly and concisely enabling adherence without complication.
- Translating user requirements into detailed functional specifications & manage & prioritise errors, fixes and system enhancements.
- Create and write UAT scripts, manage test strategies minimising impact & cost to business.
- Write & design dashboard reports and detailed MI ensuring stake-holders, chief executives and senior management are armed with information allowing for effective and accurate decision making.
- IT Cost Saving Initiatives, ensuring users have the correct equipment to do their job effectively, whilst ensuring minimal costs to the organisation.
- Manage Corporate Real Estate website, including design layout and content editing through CMS system.
- Track and analyse Web Trends and provide reports and information to site owners and teams across the business.

Career medium 03
Career
Career medium 05

HSBC Bank UK

System Coordinator

Promoted to support the Strategic Systems Manager in the ongoing management of the property portfolio system and act as deputy in their absence. Liaising with users, programmers and system developers, ensuring user requirements are met for ongoing roll-out of new system updates and releases.

Main Responsibilities:

- Design screens and write functional specification documents, detailing the processes of new screens.
- Carrying out and managing User Acceptance Testing, ensuring the system is fully functional before release.
- Designing and creating User Guides and providing training on new functionality.
- Producing detailed MI using Crystal Reports and Excel.
- Supporting staff on all IT issues, including Microsoft applications, such as Word, Excel and PowerPoint.

Career

HSBC Corporate Real Estate

Data Administrator

Collect data from existing systems for migration into the new Property Portfolio System (MAPPS). Managing Data integrity, ensuring information within new system is up-to-date and correct. Consultation with circa 500 users to ensure the information was correct and met their requirements.

Main Responsibilities;
- Managing and maintaining Property Reference Data within the new system.
- Offering support on new system to users, providing training where necessary.
- Assisted in the data integration from major re-branding from Midland Bank to HSBC ensuring all information within our systems was up-to-date and correct.
- Run and manage a help-desk to be the first point of call for all users on the newly released system ensuring errors prioritising errors ensuring fixes are documented and managed accordingly.

Career medium 04
Career
Career medium 03

Essex County Council, Social Services Department

IT & Office Business Coordinator

Manage budget for equipment purchasing for Social Services clients, ensuring clients needs are met whilst remaining within the strict local government budget. Used own initiative and made key decisions to ensure objectives were met within tight deadlines. Co-ordinate charging structures set-up for clients who use specialist equipment and to implement a charging structure that was fair and non profit-making. Learn all in-house systems and provide assistance to Social Workers and Occupational Therapists on all IT related queries. Install electrical equipment in clients homes and provide training on use. Liaising with clients, which required an understanding, polite and friendly approach, whilst proving to be helpful in often delicate and difficult situations.

Main Responsibilities:
- Analyse budget figures and market suppliers and write reports to show where cost savings could be made.
- Make comparisons where necessary against alternative equipment options ensuring product meets both clients needs and also strict budgetary demands.
- Creating MI presentations for directors and other members of the charging panel.
- Review all costs involved with each item of equipment including delivery and installation and write detailed reports on charging structure whereby costs can be covered by client funding.
- Create detailed and overview MI and presentations for directors and other government officials.
- Provide group training sessions and one-on-one support for all software and technical business processes.
- Produce intuitive, detailed and easy to understand user guides and information packs for users, clients and business teams.

Career

Braintree College

Bachelor of Technology (BTech), GNVQ, IT, Business & Finance

Tabor High School

English, IT, Maths