Mario Rodriguez Email & Phone Number

Herzogenaurach, Bavaria, Germany

• Demonstrated the value of redemption by creating and overseeing adiClub business cases for each country, encompassing the definition and calculation of Sales Uplift at customer level.• Developed and implemented churn models to engage valuable members and enhance program efficiency.• Created insights for member discounts optimization across all countries.• Created omnichannel segmentation models for the Global Retail and eCom teams.• Automated the membership reporting framework through Power BI for automation and stakeholder reach.

Costa Rica

• Led market expansion and contract negotiations for Mastercard Rewards in Central America, closing $20M in deals.• Successfully launched loyalty programs for major banks in Costa Rica, El Salvador, and Honduras.• Managed loyalty programs for multiple issuers including FICOHSA (Honduras, Panama, Nicaragua, and Guatemala) Scotiabank Mexico and Davivienda Costa Rica with emphasis in customer engagement and retention.

Mexico City Area, Mexico

• Created an analytical framework through advanced Tableau dashboards for CRM revenue tracking as well as loyalty predictive models which helped to drive $10M in negotiations with merchants and banks.• Automated profitability models and business cases for key partnerships with Citi, Scotiabank, and others.• Closed deals worth $8M on loyalty solutions and defended contracts worth $25M yearly with major financial institutions.

Mexico City Area, Mexico

In charge of deploying the analytical strategies for the Mexican Market. Manager of the BI and data science team.-Created Predictive Models for client attrition and cross-Sell. Cluster creation in joint projects with FICO. -Created Microstrategy mobile dashboards for the Insurance and Mutual Funds business units.

Mexico City Area, Mexico

Head of a multidisciplinary team focused in generating BI and Social Knowledge throughout the bank.Activities include:-In charge of the incorporation of Tableau as the corporate BI front-end across different departments (Sales, Operations and Finance).-Coordinated Scorecard and Dashboard creation for the National Sales Dept.-Generation of joint solutions with the internal BI CoE to mitigate analytical costs through the implementation of Hyperion/Essbase solutions, in lieu of ad-hoc reporting.-Regulatory and Compliance report reengineering.-Data Mining tool assesment and implementation in order to leverage corporate analytical strategies.

Mexico City Area, Mexico

Coordinated the analysis, segmentation and profiling for targeted candidate customers for every Credit Card MKT Campaigns and strategies throughout the product life-cycle (Origination-Activation-Use-Retention).Developed Scorecards and P&L’s in order to measure success and financial results.Achievements:-Created a predictive retention model through Random Forest and Bayesian techniques using the client’s transactional and financial performance patterns.-Created a loyalty model based in a 360 analysis of the client’s behavior (age in books, usage and spend patterns).-Expanded the Risk Qualified Customer Base by 20% through SAS CHAID (Decision Tree) modelling.-Redesigned the Credit Line Increase Assignment strategies, reducing bad rate exposition by 20%.-Defined, segmented and deployed the portfolio MKT strategies for the 2011, 2012, 2014 periods, including two MXN$ 40 Million end-of-year campaigns with ROI achieved in under 6 months.

Mexico City Area, Mexico

*Time Period includes an additional 9 months student internship (Apr 2008 - Dec 2008).In charge of Business Intelligence analysis and Microstrategy Platform implementations (Linux/Windows). Core consulting activities included: -BI Reporting.-Balanced Scorecards and Interactive Dashboards design.-Data Modeling and OLAP Design.-ETL Assessments.-BI Platform Migrations.Relevant Projects:-Coordinated and deployed a complete ETL Tool asessment at Volkswagen.-Microstrategy deployment, data mapping, report and balanced scorecard creation at Telcel (Telecom).-DWH Modeling and Implementation at Orion (ceramic industry).

Monterrey Area, Mexico

-Developed segmentations and transactional profiling of every client in the Debit Card Portfolio.-Implemented Reporting and KPI Analyses in the Debit Card department through Oracle DB, SAS Enterprise Guide and SAP BW/BEx. Achievements: Cooperated with VISA in order to execute the implementation, and reporting of the impact achieved by joint Debit Card campaigns which increased debit card usage by 7%.

Master Of Data Science, Data Science

Data Mining For Analytics And Decision Making Certificate, Certificate

Predictive Model training, testing and evaluation through, R, Python and SAS: -Decision trees and Random Forests. -Bayesian learning..

Mba, Mba

B.S. Computer Systems For Management, Computer Systems For Management

Activities and Societies: Volunteer Service on ITESM High School giving Advanced English regularization classes to Campus employees.