Freelancer profile translated to English.
Back to original languageAbout Sebastien
With 15 years of experience in IT. First in investment banks as a business analyst consultant then a tactical VBA developer. My VBA experience is 10 years in large banking groups and most recently in a startup for 3 and a half years.
I offer you my experience and expertise to assist you in the design or evolution of VBA tools.
French
Native or bilingual
Polish
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- OctoberDesk strategist VBABANKING AND INSURANCESeptember 2018 - Today (7 years and 9 months)Paris, FranceResponsible for gathering requirements, maintenance, enhancements, and creation of VBA tools with management of specific requests in a single tool according to country needs:- "Spread" tool used by Sales, Credit Analysts, and Operationso Financial analysis of companies requesting a participatory loano Automated generation of documents (contracts, mandates, emails...)o Integration of external data including Moody's (project carried out with Italy)o Integration of automatic translations for project descriptions in 4 countries on the lending platformo Redesign of the financial ratio calculation modelo European level support in English- "Kirk" project: financial analysis tool (Cash Flow – P&L) for the company October:o Gathering requirements from the financial controller and CFOo Development of the process and tools necessary for monitoring the company's performanceo Joint testing with the businesso Creation of a summary tool presented to investorso Tool implemented for the Q3 Board- Various proposals for model enhancements- Management of countries with on-site travel to manage country-specifics- Integration of a database and joint work with a data scientist in Amsterdam for data analysis and creation of a new project pre-qualification model.- Management of 50 to 70 users in different countries
- AXA IMTactical VBA DeveloperBANKING AND INSURANCEAugust 2016 - August 2018 (2 years and 1 month)Paris, FranceResponsible for the maintenance and evolution of tactical tools for regulatory reporting and investment constraint monitoring:- AIFMD: Regulatory reporting for Alternative Investment Funds (AIF)- IFT: Tool for calculating and monitoring regulatory leverage and commitments- TE tool: Calculation of fund tracking errorMission:- Support for business requirements, analysis, and tactical development (VBA, Access)- Coordination with various teams (Investment Guidelines, Reference Data, Risk, Compliance, Client Reporting, Technology...)- Needs analysis and specification writing- Implementation of a continuous improvement process to monitor and enhance data quality
- Société GénéraleTactical VBA DeveloperBANKING AND INSURANCEJanuary 2013 - July 2016 (3 years and 7 months)Paris, FranceWithin the tactical team responsible for tools related to regulatory frameworks (ACP, Basel III, FSA, FED) and, more generally, to regulators' expectations regarding reporting, liquidity management, and oversight.- Analysis of user needs, estimation of costs, and development schedules.- Development of tactical tools in VBA Excel/Access.- Corrective and evolutionary maintenance of developed software components.- Writing and execution of complex SQL queries.- User support
Recommendations
Be the first to recommend Sebastien
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- DESS in Management Control and AuditUniversity Paris X2006Les compétences et aptitudes développées, métiers ou transversales, concernent : * Premièrement les méthodes et techniques classiques du contrôle de gestion (élaboration et mise en place des systèmes de pilotage, élaboration et pilotage du processus de planification et du processus budgétaire, consolidation des données, analyse et reporting, mise en place et optimisation du système d’information, calcul des coûts et analyse financière …) et les méthodes attendues de l’audit interne et du management des risques (mise en place et amélioration des systèmes de contrôle interne et de gestion des risques, cartographie des risques, définition du plan d’audit et des grandes orientations, réalisation des missions d’audit, identification et préconisation de pistes d’amélioration…). * Deuxièmement les méthodes plus spécifiques d’analyse des données (traitement quantitatif ou qualitatif et gouvernance des données de masse), de management de projet et de résolution de problèmes complexes en situation d’incertitude. * Enfin, troisièmement, les compétences linguistiques et soft skills (conviction, communication orale et écrite, leadership et créativité, sens relationnel, adaptabilité et éthique professionnelle).