Alexandre Biton Email and Phone Number

To develop a data strategy for SKWEEK:- Created a strategic document and roadmap outlining the deployment plan.- Defined priorities for analysis platforms across multiple departments.- Developed a strategic document for the sales department highlighting key assets.- Led three tender processes for acquiring tools: web traffic analysis, multi-platform sponsor valuation (TV, Print, Web, Social Media), and data infrastructure (DataLake + BI tool).- Presented the Amaury group's structure for FEDCOM's chairman.- Created strategic documents to guide the company into its second year as an OTT broadcaster.- Analyzed end-of-season market studies and proposed a strategic approach for the next season based on target customers.- Modeled a data cube for Euroleague matches and pitched a product concept around statistics and a potential website to the board.To build a media group data ecosystem:- Established an Azure tenant to host datasets and develop Proof of Concepts on Power BI.- Implemented a traffic data analysis tool (Piano Analytics) to support business goals.- Automated OTT data retrieval to measure audiences and create customer profiles.- Developed 30+ reports for managers to track transactional, client, and content metrics.- Delivered the first "Season Review" to analyze key insights from the inaugural year as broadcasters.- Implemented a social media performance tracking solution via Horizm to inventory digital assets and increase sellable rights for the sales team.- Predicted marketing KPIs for the second season, aligning with the CFO’s business plan.- Automated a monthly performance report for the board of directors.- Secured a lead generation deal with Pearlfinders to support the sales team.Software: Power BI, Fabric, OneLake, Piano Analytics, GTM, HorizmLanguages: M (Power Query), DAX

Working on strategic subjects:- Conducted research on entering the Chinese market with recommendations, a savings plan (€200K), targets, and deployment strategies.- Led forecasting efforts for the digital acceleration plan.- Delivered monthly performance updates to the board of directors.- Developed and presented a comprehensive plan for NFTs in the crypto space (socios, sorare, etc.).- Automated forecasts and defined strategic KPIs (followers, churn, Brand Index, Buzz).- Led the creation of AS Monaco's strategic segmentation and developed an RFM app to simplify RFM segmentation for business goals.Other Achievements:- Regularly updated the department’s performance metrics for the board.- Created and delivered a monthly report to top management.- Spearheaded the strategic segmentation of AS Monaco's customer base, collaborating with top management and aligning clusters with key strategic pillars.

Developing a BI solution:- Audited the entire AS Monaco data landscape.- Benchmarked BI platforms (Tableau, Power BI, Sisense, ThoughtSpot) and created use cases for each.- Created documentation and decision matrix of the contenders and negotiated final pricing.- Highlighted the importance of data ownership for a football club.- Designed the BI infrastructure setup using Azure DataLake GEN2 and Synapse Analytics.- Connected the datalake to various data sources (APIs, FTPs, and databases).- Developed a complete end-to-end BI solution for commercial and marketing departments.- Built an app for the communication director to track interviews and delivered an automated BI dashboard for media and communication performance evaluation.- Presented AS Monaco's BI work to European peers and contributed a use case to Blinkfire's resources .- Fostered a data-driven culture across all departments.- Proposed a new BI revenue stream for AS Monaco.- Empowered users to extract insights from the BI solution.- Created end to end HR engagement survey plugged to a dashboard to better understand employee's need.Software: Power BI, Piwik Pro (Analytics, Audience, Tag Manager, Consent Manager), Forms, Power Apps, Power AutomateLanguages: M language (Power Query), DAX, Python

Developing a BI solution:- Built connections between various data sources within days to prove the concept.- Prepared FTP files and PowerShell scripts to fetch web analytics data, restructuring it daily.- Automated the initial email-to-web report, enhancing it through to the booking process.- Analyzed weekly campaign performance and presented insights to VPs.- Migrated outdated customer reports from Qlik & Spotfire to Sisense.- Developed a marketing approach by crossing cost and revenue data to identify all customer touchpoints.- Automated post-survey reports.- Set up alert notifications and Excel exports to automatically adjust prices according to RVM director's rules.- Proposed an online area and voyage interest report to assist the RVM team in demand forecasting.Analyzing the data:- Reported weekly email performance to the Business Review Marketing.- Created A/B tests for new website versions.- Built GTM, DTM, and Launch tags to track customer navigation more effectively.Managing the data:- Administered the Adobe Experience Cloud platform (user access, variable creation, tag management, deployment of new versions).- Integrated web data into the CRM to enhance customer profiles.- Developed multiple Python scripts to scrape web data and format files for daily use on the BI server.- Led the migration from DTM to Adobe Launch.- Managed and forecasted the digital team’s budget for the CMO and VPs.- Trained team members on various platforms.Working in the Data Science team:- Created a sentence cloud and text mining solution to quickly analyze customer surveys.- Implemented advanced time series models (Ensemble, ARIMA, Prophet, Holt-Winters) to forecast KPIs.- Built a cancellation score model to predict churn.Software: Sisense, Adobe Experience Cloud, PowerShell, Qliksense, Tibco Spotfire, SQL Server, PostgreSQL, Facebook and Adwords connectors via AdverityLanguages: SQL, JavaScript, R, Python, PowerShell

Developing a BI solution:- Collected project requirements and defined the scope with multiple stakeholders.- Self-trained using Sisense online tutorials and onboarding materials.- Implemented the tool on a production server (Windows Server 2012).- Defined end-user roles and access management rules.- Tested the tool’s performance to ensure reliability.- Scheduled regular updates for multidimensional datasets (cubes).- Deployed the tool and promoted its use through workshops, quizzes, and documentation.- Connected to various databases and APIs to provide comprehensive solutions for all departments (DB Sales, Traffic Data, DHL Costs, Travel Agency, Financial System).Analyzing the data:- Implemented recurring reports for consistent insights.- Created performance and marketing indicators to monitor success.- Monitored turnover objectives daily to ensure targets are met.- Investigated big data integration opportunities.- Developed data-mining solutions integrated into the BI tool.- Implemented machine learning algorithms to set alerts on activities.- Optimized pricing strategies, generating an additional €100K in revenue annually.Marketing the tool & preparing its commercialization:- Defined the business model in collaboration with the sales manager.- Introduced the tool to clients and potential investors.- Produced customized reports tailored for various clients.- Trained users and developed appropriate documentation.- Managed access rights and data permissions.- Participated in commercial negotiations for tool adoption.Ad-Hoc Studies:- Examined installment payment plans for client insights.- Published post-event reports on various case studies.- Challenged insurance thresholds, resulting in €75K of additional revenue annually.- Established dashboards for event organizers to track key metrics.Software: phpMyAdmin, MySQL Workbench, Sisense, Qliksense, Tableau, Tibco SpotfireLanguages: SQL, QlikView Script, R, Python

RFM Segmentation Restructuring- Collected company needs and defined the tool's scope.- Chose a methodology to partition segmentation by sector.- Integrated customer activity across all channels (web & store).- Established new RFM thresholds and trained users.High Potential Rating for New Customers- Gathered marketing managers' needs to define the tool's scope.- Developed numerous indicators related to new clients.- Created a scoring model using correlation matrices and logistic regression.- Analyzed model performance and trained users on the tool.E-commerce Skill Improvement- Researched big data clustering to save navigation data.- Conducted a click & collect study for online and offline customer paths.- Integrated web data into data mining environments.- Analyzed web performance using Google Analytics and Eulerian.Marketing Information Systems Migration- Described existing systems and defined target data models.- Participated in POCs to revamp infrastructure.- Managed contractors and validated functional specifications.- Tested performance of new tools.Client and Store Reporting- Defined key performance indicators with users.- Validated mock-ups and analyzed results for improvements.- Optimized reporting tools and created training documentation.- Ad-Hoc Reporting- Produced tailored customer reports for various departments.- Collaborated on business models for GL and BHV.- Monitored loyalty programs and contributed to commercial strategy.Software: DB2, Amadea (ETL), SPAD, SAS Base/Miner & SAS Guide, SPSS Modeler, SPSS Statistics, QlikView, Google Analytics, EulerianLanguages: SQL, SAS, Script Modeler, QlikView Script

Advanced Training on the Tool- Conducted 7 days of training throughout the year for newcomers.- Developed and updated training materials.Systematization and Deployment of Dashboards- Analyzed existing reporting systems within the company.- Updated and communicated current reports.- Managed ad-hoc reporting, including assessing the life cycle of the Mod’pass loyalty card.- Addressed diverse data requests for various departments (brand, store, clients, purchase sector).- Systematized and deployed marketing campaign analyses.- Collaborated on developing a cardholder weakness rating.Software: DB2, Amadea (ETL), SPAD, SAS Base/Miner & SAS Guide

Automation and deployment of dashboards- Maintained and enhanced codes of existing programs- Automated and deployed the SAS codeAd-hoc reportingSoftware : SAS Base

Detected and corrected the outliers - Tested different statistical methods (Principal component analysis, Grubbs’ test for outliers, etc.)- Redacted a document to explain my choice of method (threshold detection test) - Implemented and deployed the method Ad-hoc reportingSoftware : SAS Base/Miner