Alan Stewart Email & Phone Number

Edinburgh, Scotland, United Kingdom

Edinburgh, Scotland, United Kingdom

Edinburgh, United Kingdom

Edinburgh, United Kingdom

Brought in on day one of the project as a key domain expert to deliver a complex system migration between legacy and strategic platforms within the Private Equity division. • Defined the new Target Operating Model for a diverse user base from investment professionals to back office operational functions based on a thorough understanding of business processes and needs while understanding the firm’s desire to build a scalable, flexible and future proof way of working.• Primary conduit between end users and multiple technical delivery streams to ensure effective translation, refinement and specification of functional requirements. Projected a clear view of the strategic operating model through the system design, build and delivery phases. • Highly developed communication skills, workshop management and clear documentation ensured effective delivery between different teams. • Data analysis and complex data migration planning. Data extraction from legacy system (Equitrak), data cleansing, rationalisation and mapping to the Vendor Excel import templates to enable a successful load into the strategic platform (eFront).• Responsible for test pack creation, test execution management, defect tracking and prioritisation. • Clarification of requirements and change management where required.• Stakeholder management and reporting at all levels both within the program group and senior management within the wider firm encouraging business engagement by demonstrating capabilities of new system and advantages it would bring.• Training of business users in use of the new system during the testing phase to assist business readiness.

Edinburgh

Key Subject Matter Expert on strategic Private Equity integration project. A complex project ultimately tasked with migrating several legacy business models onto a single, strategic platform (eFront) and operating model.Conduit for effective communication between the business users and the remote technical team.Held requirements gathering interviews with key stakeholders across the business to ensure accurate and unambiguous articulation of requirements from all business functions;Liaised with remote technical experts to clarify, confirm and explain where necessary, the exact detail of each requirement ensuring all delivered artefacts reflected the requirement prior to exit from the development phase;Supported both business and technical colleagues throughout the testing phases to help identify, validate and resolve any defects or queries;Wrote technical process notes for the business users;Trained users on the new platform and provided on-going support through the go-live phase of the project;Carried out extensive data analysis using Excel to identify and resolve chronic historical data quality issues leading to poor reporting and accounting inaccuracies. Resolution and transformation into strategic data model;

Edinburgh, City Of Edinburgh, United Kingdom

Responsibilities• Reconciled cashflows on eFront (AAM system) to TPA cashbooks from present back to 2007.• To produce a cash reconciliation report to be used by analysts.• Given high profile piece of work by manager while she was on leave which involved presenting to Client Relationship Director.• Produce Excel templates to be used to supply quarterly sector to Front Office.• Entered underlying portfolio company information onto eFront. Achievements• Presented results of cashflow analysis to Head of Private Equity Accounting.• Held training seminar to present eFront cash reconciliation report to analysts providing supplementary assistance during “live” reconciliation work. • Presented results of high profile piece of work to Client Relationship Director receiving positive feedback.• Sector analaysis templates produced. Now used to complete quarterly submissions on eFront to Front Office.• Clearance of 6 month backlog of underlying portfolio company information.• Clearance of NAV and cashflow reviews.

Edinburgh, United Kingdom

Responsibilities• Responsible for finance and accounting of private equity funds reporting financial figures to investors and to Group Accounting using Hyperion Financial Management.• Overseeing output from administrators including management profit share, capital statements and financial statements.• Reviewed valuations of underlying fund investments (40).• Prepared valuations for co-investments (5), Valuation Committee papers (US and European) and Minutes of Valuation Committee meetings.• Monitored cash flows of funds and prepared investor transactions at optimum time.• Relationship Manager - administrators and US auditors.Achievements• Learned new area of accounting having had no Private Equity experience before this role.• Doubled the number of funds responsible for since started (2 to 4).• Worked with administrators to put in place waterfall models for funds to allow administrators to calculate distributable amounts.• Maintained high levels of work quality while company expanded doubling the number of fund products and valuations to be reviewed in the process.• Formed good communication lines with investment team and Finance Analysts essential for carrying out role.

Vienna, Austria

Responsibilities• Prepared annual, quarterly and monthly Group consolidated financial statements under IFRS (2009 Turnover: EUR 4,714M).• Provided external auditors with all documentation and analysis required for year-end audit and quarterly review.• Fulfilled project management function focusing on various commercial projects of Group.Achievements• Prepared benchmarking data for strategy department and business units.• Supplied financial information for inclusion in prospectus for public bond issue.• Prepared accounting process and procedure documents for the Group.• Researched and prepared detailed arguments for specific treatment of items in Group Accounts.

Luxembourg

Responsibilities • Controlled reporting of statistical information to Luxembourg Central Bank.• Trained staff in preparation of reports.Achievements • Established and developed communication lines with Luxembourg Central Bank.• Formed effective working relationships with Fund Accountants. • Resolved issues surrounding report configuration.• Cleared a one year backlog of reporting requirements.

Luxembourg

• Performed Group Accounting role which included agreement of month end inter-company balances and postings to Hyperion Financial Management under IFRS of Paper & Packaging Division (size: USD 2.6 Bn) reporting to the Division’s CFO and Board.· Support of Finance Controller in running of department.· Responsible for Managing and Controlling of Group Cash Flows · Reviewer of Bank Reconciliations, Loan Schedules and Monthly Management Accounts.· Supporting and reviewing of day-to-day accounting of assistant. · Major involvement in restructuring step plans. · Close liaison with Group Tax and Company Secretarial maximising information flow.· Attended and contributed to Controllers meetings for both the Group and Business Paper Division.· Main contact for external auditors.· Completion of Controlled Foreign Companies Returns working closely with Group Tax.

Edinburgh, United Kingdom

Worked in Business Services department preparing monthly, quarterly and annual accounts. Client facing role.

Perth, United Kingdom

Chartered Accountant, Accounting And Finance

Investment Operations Certificate (Ioc)

Ma Honours, Accountancy And Financial Economics

Activities and Societies: Football club, golf and badminton clubs.Accountancy and Financial Economics joint honours