Franck Belot

• Built a behavioral segmentation data model to reach customers with the right message and the right channel (Tested on 19 pilots’ initiatives) • Designed and published multiline dashboard leveraging behavioral segmentation • Created the data infrastructure to do Marketing ROI on different MEDIA (Web, PPC, TV, Radio, Addressed/Unaddressed Mail, Email, Billboards …) ( 100+ data sources with different granularity) • Created an optimization tool to leverage Marketing ROI to allocate budget for advertisement • Created an anonymized automated tool for operations to leverage NPS surveys to help agents on improve processes • Evaluated Text Mining solutions to handle Marketing Research surveys.

• Optimized tools and reports of the department • Implement structured database (DB2) to store historical financial reports • Developed unified Dashboard for Business Manager and Project Manager • Developed tools to automate manual processes

• Built, coached and implemented an innovative tool to segment financial advisors and consolidate financial information for Standard life combined Mutual Funds and Segregated Funds sales and meetings. • Actively participated in the infrastructure required for the Business Intelligence Data Warehouse to deliver self-serve capabilities of the Retail, Group Savings and Retirements and Group Insurance Departments organizing the information for a well-designed, flexible infrastructure (200 users); • Created, designed and published automatically retail reports and dashboards on a daily, monthly, quarterly and yearly basis for CEO, VP, Finances, Sales, Strategy and Business Development (equivalent of 1 FTE); • Created a probabilistic tool to manage marketing campaign to identify potential new leads; • Built and implemented a visualizing tool to analyze surveys to measure the Net Promoter Score (NPS); • Provided business analysis expertise in data infrastructure of functional and technical specifications; • Coached core team members’ methodologies for gathering, processing and organizing information.

• Built, integrated and consolidated internal and external data sources to quickly identify best candidates for current opened opportunities with Text Mining and statistical algorithms; • Organized, designed and implemented new CRM UI to exploit efficiently candidates’ profiles, seniority, competencies, skills and tools; • Performed database administration, development, as well as web development; • Provided thorough documentation for data management, BI applications and processes.

Consulting, Designing, Architecting websites. - Architect of Application for Website in PHP/CSS/XHTML

Strategic Consulting for the e-business. Technical development. - Develop PHP/CSS/XHTML website - Statistical analysis of members - Implementation of KPI - Design and implementation of design - Website Ergonomics Implementation

Working on algorithms for text mining - Study Text Mining Algorithm - Develop Text Mining Application for the CRSNG in C++ - Analysis of Business Rules - Advices on restructuration of processes for the CRSNG