Renaud MOREL

Setting up and monitoring developments on a web application intended for all agencies of the group worldwide. Challenging Business Team concerning new needs, their maturity / consistency / prioritization and subdivisions Challenging of Application Maintenance and Support Team in the development of estimates, Software Functional Design / Software Technical Design, technical solutions, and their implementation Handling production incidents Improvement of mass testing and integration tools Coordination of exchanges with other functional departments

Functional domain: OCR (Optical Character Recognition) Agile management (SCRUM) of a team of technical analysts and developers Preparation and presentation during operational and management committees Project requirements gathering workshops / team coordination Drafting of scope notes, Technical Architecture Document, Technical Specifications Team and project workload planning Epic, User Story, sprint, backlog, grooming, and sprint end demos management

- International context: Daily use of English - Mission: Application project manager in the pharmaceutical domain Facilitation of project committees and change management (application turnover) - Responsible for managing processes (GxP) related to the pharmaceutical domain (Periodic activity controls, vulnerability tracking, revision planning, coordination of technical and business teams, documentation, validation, and archiving). - User management, application licenses, relationship with software vendors - Reverse engineering on applications to reduce level 3 tickets (paid) - Implementation of dashboards for users as part of an application decommissioning - Writing technical specifications and PL/SQL queries required for reporting - Analysis of processing logs, tracking root causes of issues, fixing, and production deployment - Management of tickets and incidents (analysis, communication, team coordination, fixes)

- International context: Daily English usage - Mission: Project manager for a calculation and reporting application (Attribution, Contribution, Regulatory) - Facilitation of meetings and project committees, reporting on release cycles, activity summaries, KPI analysis, backlog allocation - Facilitation of Business meetings (business objectives, application correlation) - Management of an offshore development team based in India (Chennai) and study DBAs - Supervision of developments (requirements analysis, estimation, solution design, scheduling, development, testing, data sets, automation, qualification, deployment, and production monitoring) - Code review, reverse engineering, documentation writing, and operation dossier creation - Technical expertise (optimization, live debugging in production), technical and application testing

Same mission as 2012-2014 professional experience - Developments from scratch (Analyze, development, test, validation, deployment, production support) - Coordination with JAVA architects for web pages and database access. - Planning - Learning and training sessions for junior team - Technical expertise (Migration Oracle 11g to 12c, test, validation, optimization) - Technologies and tools: Oracle PL/SQL, bash/ksh, WINSCP, Putty, FileZilla, Notepad++, Serena Dimensions, Microsoft Office 2013, Service SNOW, HP Application Lifecycle Management, Co Stream, Clarity

- International context: English speaking environment - Production support (Follow the Sun) - International meetings (New-York, London, Hong-Kong, Mumbai, Paris) - Development of scripts/procedures (UNIX/VBA/PL-SQL) for data calculation, check and validation of data for VAR (Value At Risk) and SBM (Stress Based Margining) reports - Analyze and performance improvement of support process - Documentation (Reverse Engineering) - Financial tools use (Trade Capture, Murex PB, Hawk web, Prime DB, Primeweb, Primerisk, PrimeCollat, PRSL, Marc, Syncova, WTS, Tiger, Calypso, Product Master, PB Portal, Eagle, Genesis) - Technologies and tools: Sybase, Oracle PL/SQL, Putty, Service SNOW, GECD Jira, MS Office 2013, VBA, FileZilla, Notepad++, Lotus Note

- Developments from scratch (Analyze, development, test, validation, deployment, production support) - Coordination with JAVA architects for web pages and database access. - Planning - Learning and training sessions for junior team - Technical expertise (Migration Oracle 11g to 12c, test, validation, optimization) - Technologies and tools: Oracle PL/SQL, bash/ksh, WINSCP, Putty, FileZilla, Notepad++, Serena Dimensions, Microsoft Office 2013, Service SNOW, HP Application Lifecycle Management, Co Stream, Clarity

Completion of functionnal and technical documents Writing/Completion of Operation Files UNIX/SQL/PL-SQL script development (Development/Debugging) / Production support OWB mapping creation Writing test cases/Technical and functional testing Monitoring Deliveries/Environment updates Analysis and Statistics on data flows, log reading, improvement of existing processes

Facilitation of project committees, activity reports for IT management Responsible for meeting deadlines Coordination between midshore MOE/MOA Responsible for testing strategy, implementation of test automation processes PL/SQL querying to check reference data feeds

- Définition du planning - Analyse de la méthode de gestion des projets de l’entreprise (4D : Discover, Design, Develop, Deploy) - Analyse des besoins fonctionnels auprès des différents chefs de projets de l’entreprise - Rédaction du cahier des charges de l’application de reporting - Réalisation des maquettes applicatives (Dashboards) - Définition des stratégies techniques - Attribution des tâches, gestion backlogs - En charge du respect des délais - Développement du CUBE OLAP (Reporting) - Responsable de la stratégie de recette - Mise en Production et suivi des incidents