• Integrated, cleaned, and transformed large-scale customer and transaction datasets from multiple companies within Grupo Mercantil using SQL and Python (pandas, numpy). • Designed and implemented statistical models (segmentation, scoring, behavior prediction) leveraging Python (scikit-learn, statsmodels) and validated through exploratory data analysis (EDA) techniques. • Built and deployed machine learning models (decision trees, random forests) to classify customers and forecast account balances and transactional behavior. • Automated dynamic Power BI dashboards connected to relational databases, enabling real-time tracking of key commercial and operational KPIs. • Developed AI-driven predictive segmentation models to detect early signs of customer churn and optimize targeting strategies for marketing and loyalty campaigns. • Generated segmented customer databases for commercial and loyalty campaigns, applying ETL processes and business logic for customer prioritization.

• Designed and executed data collection pipelines to aggregate client performance metrics, optimizing report generation and business insights. • Conducted in-depth exploratory data analysis (EDA) to uncover business patterns, identify customer segments, and support strategic planning. • Built and maintained interactive dashboards using Power BI to monitor client KPIs and operational performance in real-time. • Automated monthly and quarterly reporting processes using SQL and Excel, reducing manual workload by 30%. • Provided strategic recommendations to clients based on data-driven insights, improving campaign effectiveness and decision-making.

• Improved system database architecture by implementing data normalization techniques, ensuring data integrity and scalability. • Conducted seasonal trend analysis using Python and Excel, identifying product demand cycles and supporting predictive inventory planning. • Supported the development of data visualization dashboards for operational and sales reporting. • Collaborated with marketing and inventory management teams to translate analytical findings into actionable strategies.