Greg Cochrane Email & Phone Number

Zurich, Switzerland

Zürich Area, Switzerland

• My role is as Senior Program Manager and involves liaising with business stakeholders to better understand their needs and improve the Business Intelligence offering. • Overall PM Responsibility for Pricing and CAT Reporting development project• Coordinate activities between multiple projects within a large scale strategy to migrate an on premise database infrastructure to a Cloud based Data warehouse solution: Snowflake.• Advised both Senior and Executive level management on the BI strategy and technical implementation moving forward.• Advising on how SAP BI Analytics Cloud can fulfil requirements from the business users and be part of the strategic tool set.• Spearheaded HR Reporting project where the key topic was security of sensitive data in the cloud.• PM on the SUN / CREP data integration project• On all projects, performed tasks central to project progress, including scheduling PM Meetings, SCRUM artifacts, estimations of work, budgeting, resourcing.

London, United Kingdom

Credit Risk IT. My function was to help build out the Credit Risk reporting platform for the CRAFT Project. The purpose of Craft is to address increased demands coming from Credit Risk Officers and worldwide regulators and the Federal Reserve in the US. The platform is based Oracle PL/SQL, SAP Business Objects v4.1. We are extremely oriented towards agile practices – SCRUM, Continuous Integration, and we have the best toolset to support our work: JIRA, Confluence.As Business Objects consultant my role was in the building of the Credit Risk Business Objects reporting platform. This involves working closely with the Business Analyst and Architecture team members to deliver a platform to enable the delivery of an initial reporting capability for Credit Risk.Key Responsibilities:• The creation of complex Management style packs covering exposure, collateral and limit reporting using Business Objects Web Intelligence 4.1• Developed and delivered Regulatory reporting such Living Wills into production environment• Creation of a tactical universe for reporting in Information Design Tool • Delivery of a reporting capability that will allow the end user to navigate the universe to self-build reports using Business Objects• Creation of more ad hoc reports using Webi• Customer facing role with large multi-national Investment Bank• Business Intelligence and Data Warehouse implementations• Delivering in a high pressured Global financial services environment• Dimensional modelling• SQL and database modelling knowledge• Working within Agile/SCRUM development methodology

Coutts and Co Wealth Risk and Compliance: Senior Business Objects MI Business Objects Lead MI for new regulatory developments such as CRE, FDSF (Firm Data Submission framework), B3 etc as they come on line. Strategically progressing the 'AIMS for Risk' (data warehouse) development that will introduce greater sophistication in reporting, leading to deeper portfolio management as well as reducing the operational risk inherent with the current arrangements. Core Responsibilities• To build out functional reporting/MI capability• Manage the development, production and delivery of high quality Credit & Market Risk governance reports to key internal SME’s for onward delivery to relevant Divisional and Group stakeholders, including Divisional Boards and Risk Committees, RBS Group Credit & Market Risk.• Respond in a timely fashion to external requests for information (regulators/auditors)• Appropriate accuracy and quality standards are upheld at all time.• Delivery of quality key risk metrics/MI to enable effective 2nd Line oversight of the key risks impacting RBS Wealth Division.• Ensure full optimization of the functionality within our core Risk Data Warehouse, AIMS Risk, plus other sources to fulfill reporting/MI requests and requirements. • Manage data extraction and analysis to support ad-hoc projects undertaken by Wealth Credit Risk ; Market Risk COO and in collaboration with other key stakeholders• Take ownership of Business needs and full understanding of the value to the organization improved customer service.• Ensure all reporting/MI responsibilities and processes are properly documented and all reporting materials produced are subject to appropriate 4-eyes control to distribution.• Reduce reliance on manual spreadsheets and EUDA’s or ensure an appropriate control framework is in place.

London, United Kingdom

My role was as Business Intelligence Manager for Barclays Investment bank. The role resided in the Client Facing Technology (CFT) of Group Technology within Barclays Capital. CFT delivers technology solutions to key client-facing businesses, which enable them to differentiate Barclays Capital to our clients, including trade and client life cycle tools as well as sophisticated qualitative and quantitative reporting and client analytics. Within Client On-boarding IT, the technology portfolio consists of several different applications using different technologies and platforms. Responsible for report delivery on a number of regulatory issues such as FACTA, Dodd Frank and MIFID (Markets in Financial Instruments Directive). Skills Utilised:• Business Objects Enterprise R4 suite• Business Objects Universe design and Web Intelligence• Using multiple data sources for BO reporting, linked Universes• Business Objects Enterprise architecture and security implementation• Data warehouse performance tuning and query optimisation• Translating business requirements into technical functionalities, and advice on the most suitable solution• Business Objects Administration

London, United Kingdom

The Enterprise Systems Management team is responsible for the architecture and engineering of a number of systems management toolsets. Roambi Project: • Delivered a reporting/Business Intelligence offering for the iPad for Deutsche bank senior management using the Roambi product. • Engineered the infrastructure and deployment of Roambi to a global user base.• Full project lifecycle, from design, architecture, development, performance testing, as well as building new reports and Roambi dashboards.Antivia Project: • Architecture, design and deployment of XWIS Enterprise platform for a global audience• Responsible for an implementation consisting of a sophisticated back-end server, which efficiently manages data access via BOE SDK, and a set of front-end components that reduce dashboard complexity and increase accessibility by caching documents away from BOE platform onto the Antivia server.• Responsible for the SSL, SSO and Tomcat / Apache configuration for Antivia • Design and architecture of the DR solution and failover of Antivia

BackgroundMerrill Lynch Commodities is a global organization with major trading centers in Houston and London. The Houston office currently trades both physical and financial commodities, including Natural gas, Power, Coal, Crude & Products, and Commodity Index. The Global Commodities Reporting team develops and supports reporting solutions for various Trading Systems using BI tool Business Objects in all three regions; Asia-Pacific, EMEA, and Americas. The reporting team support Front Office, Mid Office, Back Office, Sales & Marketing, Credit Risk, Market Risk and Corporate Risk reporting needs. Role Specific Responsibilities Development of Business Objects reports and queries using Desktop Intelligence and Web Intelligence.Design, develop and administer Business Objects universes Closely work with Business users to understand their reporting needs and help them with ad-hoc data analysis requirements.Administering Business Objects Enterprise (XI version) using CMCInstallation & configuration of Business Objects Enterprise in large scale multi-clustered environmentsVery good understanding of Business Objects products and SQL queries including features, benefits, and system compatibility.

MIS reporting and analysis in Capital MarketsRole Specific ResponsibilitiesDefining the technical solution for the front end reporting Gathering requirements from the User population for reporting applicationsProducing standardized report specification documentation Create Business Objects reports / Universes required for the Trading and Banking book implementation of the ALM system and Remedy Reporting SolutionSupport, enhancement and continuous improvement of the ALM / Remedy systems.Support and enhancement of Funding and Liquidity reporting databaseAssist Front Office users with analysis and design of technical solutionsSignificant projects:Installation, Deployment and configuration of XIR3.1 for the BMC Remedy Analytics Reporting solution. Responsible for Universe Design, Report Design in XIR3.1 for the Remedy ticketing system against SQL Server 2005.The migration and upgrade of Business Objects 6.1b to XIR2 for the ALM Riskpro Reporting Solution. I was technical lead on the project, designing and scaling the banks new system across a heterogeneous cluster of UNIX and Windows servers. Migration of approx 1000 reports, all associated Universes, and Users. Responsible for the development of reports and Universes both in version 6 as well BOXl R2 report writing for Desktop Intelligence and WebI, as well as the administration of the system from Supervisor (version 6) and the CMC (XI). Databases used are Oracle 9/10, Sybase 12.5, and MS SQL Server 2005.

My responsibilities encompassed the full lifecycle of a BI project from pre-sales to scoping a project,

As a Developer within Crawford and Company my responsibilities were to maintain Crawford's MI environment