Oscar Josue Melendez

• Led end-to-end analytics and reporting on hurricanes impact in several Caribbean Markets, integrating heterogeneous data sources (local file systems, Redshift, enterprise DWH, and geospatial APIs). Automated daily delivery of executive-ready dashboards, reports, and presentations, providing leadership with timely, data-driven visibility into impact severity and recovery progress.
• Built Prefect

Built analytics and automated workflows using SQL and Python, including ETL/ELT and API-based data ingestion. Delivered executive dashboards and reports on hurricanes impact by creating reliable analytics datasets and layers.

Applied advanced analytics to estimate price elasticity, segment customers, and inform pricing and revenue optimization. Built multi-market ML price sensitivity models and delivered insights through automated pipelines and dashboards.

• Applied advanced analytics to estimate price elasticity, segment customers, and generate insights that informed pricing/revenue optimization and customer behavior.
• Built a multi-market ML price sensitivity model for prepaid services, integrating usage, revenue, top-up behavior, and demographic/geospatial data.
• Reduced decision-making time for leadership by building analytical solutions that

• Improved data reliability across analytics workflows by implementing structured ETL pipelines and validation processes.
• Reduced data inconsistencies by introducing validation checks across multiple datasets used for reporting.
• Delivered insights on key business trends through statistical analysis, supporting operational decision-making.

Implemented structured ETL pipelines and validation processes to improve data reliability for analytics workflows. Delivered business insights using statistical analysis and reporting tools.

Designed and implemented an end-to-end data platform for the Digital Banking division, including pipeline orchestration and a dimensional star schema data model. Automated ingestion from multiple sources (including Telecom APIs and Firebase) to support analytics and business intelligence decision-making.

• Designed and implemented the end-to-end data platform for the Digital Banking division (Banco Azteca mobile app), establishing a scalable and reliable data foundation from the ground up.
• Led the orchestration of data pipelines to ingest high-volume transactional data from multiple sources, including Telecom APIs and Firebase.
• Architected and deployed a dimensional (star schema) data model

Led development and deployment of predictive machine learning models to improve collections strategy effectiveness. Coordinated cross-functional teams to deliver data products and integrated ML predictions into collections workflows.

• Improved collections strategy effectiveness by leading development and deployment of predictive machine learning models.
• Delivered end-to-end data products by coordinating cross-functional teams across data, engineering, and business units.
• Enabled operational use of ML models by integrating predictions into collections workflows and decision processes.

Developed predictive models to improve collections performance by analyzing customer behavior and repayment likelihood. Produced management dashboards and performance reports and identified optimization opportunities through data mining and trend analysis.

• Improved collections performance by developing predictive models for customer behavior and repayment likelihood.
• Enabled leadership decision-making through development of management dashboards and performance reports.
• Identified optimization opportunities in collections strategies through data mining and trend analysis.

• Worked remotely with an international team supporting an online trading platform. Started in customer support and gradually took on data-related responsibilities.
• Handled daily support via chat/email (40–60 tickets), mostly account and transaction issues
• Investigated trading inconsistencies by reviewing account activity and logs, escalating when needed.
• Extracted and cleaned data from inte

Needed to find the right career path.
This professional break also allowed me to deep dive into one of my hobbies: Music.

Started and managed a small independent e-commerce business, handling day-to-day operations and end-to-end order and payment/logistics management.

• Started and managed a small independent business outside my main field
• Handled day-to-day operations including sourcing, customer communication, and basic marketing
• Managed orders, tracked performance, and handled payments/logistics
• Gained experience working independently and managing end-to-end processes

As part of my minimum required hours of practice to graduate, I was part of the Regional Purchasing Team with the following acomplishments:
• Managed procurement of mobile devices across Central America for direct sales and postpaid plans.
• Worked directly with brands like BlackBerry, Samsung, and Sony to negotiate pricing, secure supply, and define product mix based on market demand.
• Coordin

Earned a B.S. in Industrial Engineering from Universidad del Valle de Guatemala from 2010 to 2015.

Earned a B.S. in Industrial Engineering from Universidad del Valle de Guatemala from 2010 to 2015.