Alexandre LE BIHAN

Internal Audit
• Audit of the AML process for an insurance
• Audit of the BCP/DRP for an insurance and for an Investment Bank

ITGC (interview, test, recommendations) on the following IT process
• Logical and physical security
• Change management
• Computer operations management
• Incident management
• BCP/DRP

Set-up and review of business process documentation on the following processes
• Accounting close
• Payroll
• Fixed Assets
• Treasury

Data analysis
• Data path test between source software and output results
• Reliability of interfaces between applications (completeness and accuracy of data)
• Spreadsheets risk analysis
• Analysis with ACL

Head of IT for Czech Republic, Slovakia and Hungary.

Management Activities
• Prepare and Manage IT Budget (300K€/year)
• Management of 2 IT Analysts in a multicutural environment
• Administration of recruitment and annual appraisal for IT Dept
• Member of 3 different Management Teams
• IT Suppliers contract management
• IT Cost killing (10% decrease)
• Creation of IT Governance tools (projects portfolio management)
• Implementation of new IT KPIs
• Creation of IT Project follow up tool

Project Management
• Implementation of a new Front Office tool
• Implementation of a BCP
• Implementation of several web projects
• Set-up of an insurance front office tool used in dealership

Technical Environment
• PHP, Ajax, HTML, CSS
• Advanced VBA
• Database Administration (SQL Server 2008/2012, Access)
• ETL (Pentaho)
• Bugtracking tool (jira, mantis, GLPI)

Management activities
• Prepare IT Budget
• Point of contact between the subsidiary and Paris
• IT Audit and cost control
• Redaction of BCP procedures
• Handle suppliers (network, phone, computer, internet, ...) relationship
• Lead IT committee
• Involved in several business committees (Management meeting, Permanent Control, ...)
• Establishment of an issue tracking tool (Mantis)

Business analyst activies
• Writing Functional Specification
• Leading workshop with end-users, Management of UAT

Day to day activities
• Helpdesk (all levels)
• Hardware and network administration
• Define and update IT procedure/policies
• IT rights management

Technical environment
• Advanced VBA development
• Database Administration (SQL Server 2005/2008)
• PHP development
• Define batches with pentaho (ETL)

Methodology development and evolution of the methodology
• IT Strategy Process
• Development of new Workflow of Issues Tracking

Management of new IT methods and tools
• Establishment of a TimeTracking tool (at home) and linked report
• Administration of an issues tracking tool (JIRA)

Development new control charts for CIO and customers
• Project Portfolio Management
• Creation of new key indicators on planning, status and cost controls of IT project

Project management on all phases of the lifecycle (design, specifications, tests, change) for 6 projects :
• CRM (Selligent x@)
• Tool for Nautical Leasing (Macro Excel)
• Reporting (datawarehouse – OLAP cube)
• Referential (People, Rate, …)
• Enterprise Application Integration (webMethods)
• BO Universe

Set-up of functional performance specifications, tests and training manual

Set-up and leading of functional design workshops

Student job