Mario Zamudio

๐Ÿ‘จโ€๐Ÿ’ผ About Me

I am an electronic engineer with 23 years of experience in telecommunications. I specialize in configuring, implementing, testing, and supporting complex solutions for major carriers. Over the last decade, I have transitioned into a Solution Architect, focusing on provisioning, charging control, and analytics while solving complex problems and leading technical teams with strong attention to detail.

My main goal is to deliver creative results that meet customer expectations and tackle challenges effectively. I can analyze client needs, review technical specs, define configurations, design solutions, plan projects, document testing procedures, and guide technical teams. I can also deploy solutions and integrate with third-party applications, facilitate go-live processes, and offer ongoing support.

As a Masterโ€™s candidate in Data Analytics at the University of Niagara Falls, I have significantly expanded my technical and analytical toolkit. My training has deepened my expertise in Python, Power BI, Tableau, SPSS, and SQL, as well as statistical modelling, data visualization, data warehousing, and machine learning. I am skilled in exploratory data analysis (EDA), regression analysis, predictive modelling, dashboard development, and leveraging data to generate actionable insights for business decision-making. Throughout my graduate studies, I have strengthened my abilities in data cleaning, hypothesis testing, advanced analytics, and the integration of multiple tools and platforms. These skills have been applied to real-world projects involving statistical inference, ETL processes and business intelligence. This blend of engineering experience and advanced data analytics empowers me to deliver end-to-end solutions, bridge the gap between business and technology, and add value to organizations in a data-driven world.

๐Ÿ“Š Featured Projects

1. ๐ŸŽต Spotify Data 2023 โ€“ Top Songs Analysis (SPSS)

Spotify 2023 Data

Exploratory analysis of Spotify's top tracks in 2023 using SPSS and statistical correlation techniques.

๐Ÿ”— View Details

2. ๐Ÿšฆ Traffic Accident Prediction (Python)

Traffic Accident Prediction

Regression modelling to forecast traffic accident risk in Toronto using weather and location data.

๐Ÿ”— View Details

3. ๐Ÿ“ˆ Sales Forecasting (Power BI)

Sales Forecasting Power BI

Forecast sales performance, customers, and profitability using interactive visuals in Power BI.

๐Ÿ”— View Details

4. ๐Ÿ”‹ Electric Vehicles Analysis (Python + Power BI)

Electric Vehicles Project Screenshot

Exploratory and statistical analysis of electric vehicle registrations using Python and Power BI. Includes regression models, data consistency validation by state, and growth trends over time.

๐Ÿ”— View Details

5. ๐Ÿ•ต๏ธโ€โ™‚๏ธ LAPD Crime Data Analysis (Python)

LAPD Crime Project Mosaic

Predictive and exploratory analysis of the Los Angeles Police Department Crime Dataset using Python. Includes EDA, feature engineering, demographic insights, spatial heatmaps, and Random Forest modeling to identify the key drivers of crime case solvability.

๐Ÿ”— View Details

6. ๐Ÿ“Š Superstore Sales Analysis (Tableau)

Superstore Tableau Dashboard

An interactive business dashboard for the popular Superstore dataset, built with Tableau. Explore regional sales, profit trends, category breakdowns, and key KPIs through dynamic maps and charts. Two linked dashboards provide actionable insights for managers and analysts.

๐Ÿ”— View Details

7. ๐ŸŒŽ Global Superstore Analysis (Tableau)

Global Superstore Tableau Dashboard

Advanced Tableau dashboards analyzing global sales, profits, customer segments, and trends in the Global Superstore dataset. Features regional performance, category analysis, and interactive insights for strategic business decisions.

๐Ÿ”— View Details

8. ๐Ÿ“ฆ Global Orders & Profit Dashboard (Tableau)

Global Orders Tableau Dashboard

Dual Tableau dashboards exploring global orders, profitability, shipping performance, and key metrics. Features interactive KPIs, geographic analysis, and data-driven insights for decision makers.

๐Ÿ”— View Details

9. ๐ŸŒ Global Trade Analytics (Python & Tableau)

Global Trade Analytics

End-to-end analysis of 34 years of global trade, tariffs, and economic disruptions using Python (EDA, regression, Random Forest) and Tableau (interactive dashboards, world maps). Hypothesis-driven insights for policymakers and business leaders.

๐Ÿ”— View Details
๐Ÿ  Back to Home

๐Ÿ“Š Other interesting Projects

1. ๐Ÿšฒ Bicycle Store (SQL Analysis)

Bicycles SQL Project

Database modelling and SQL analysis for a retail bicycle store.

๐Ÿ”— View Details

2. ๐ŸšŒ Bus Scheduling Optimization (Python)

Bus Scheduling Optimization

Optimization of bus resources for urban public transportation using LP and advanced modelling using Phyton Solvers.

๐Ÿ”— View Details

3. ๐Ÿ“Š Sales Modeling & DAX (Power BI)

Power BI Sales Analysis

Descriptive analysis of sales data using Power BI and advanced DAX measures.

๐Ÿ”— View Details

4. ๐ŸŒธ Iris Dataset Analysis (Python + Power BI)

Iris Analysis

Data exploration of the Iris dataset using Python preprocessing and Power BI dashboards.

๐Ÿ”— View Details

5. ๐Ÿ ๐Ÿ“‰ Housing Prices & Bike Sharing (Python + Power BI)

Housing Prices & Bike Sharing

End-to-end workflow using Python notebooks for preparation and prediction, paired with Power BI dashboards for housing prices and bike sharing.

๐Ÿ”— View Details

6. ๐Ÿงฉ Advanced Visualizations & Insights (Tableau)

Advanced Visualizations Tableau Dashboard

A Tableau dashboard showcasing advanced visualizations for multi-dimensional data analysis. Combines interactive filters, dynamic charts, and spatial analysis for deeper business insights and discovery.

๐Ÿ”— View Details

7. โค๏ธ Heart Attack Risk Dashboard (Tableau)

Heart Attack Risk Tableau Dashboard

Tableau dashboard analyzing heart attack risk factors and patient profiles. Includes interactive filters, risk segmentation, and trend analysis for healthcare analytics and preventive care insights.

๐Ÿ”— View Details

8. ๐Ÿ“‰ Sales Decline Analysis Dashboard (Tableau)

Sales Decline Tableau Dashboard

Interactive Tableau dashboards investigating the causes, patterns, and impacts of sales decline. Explore time trends, segment breakdowns, and actionable insights for business recovery and strategy.

๐Ÿ”— View Details
๐Ÿ  Back to Home

Resume

๐Ÿงช Experience

Solution Architect โ€“ Hewlett Packard Enterprise (HPE)
May 2010 โ€“ Oct 2024 | Colombia
Led full-cycle solution design and delivery for telecommunications clients in Latin America and Canada. Specializing in provisioning systems, charging control, analytics solutions, and automated testing.

Technical Consultant โ€“ Indra
2008 โ€“ 2010 | Colombia
Implemented enterprise integration architecture (SOA)

System Analyst โ€“ Tigo
2005 โ€“ 2008 | Colombia
Designed mediation platforms and satellite applications for operational efficiency across telecom systems.

Developer โ€“ Hewlett Packard (HP)
2004 โ€“ 2005 | Colombia
Developing a third-party payment platform to reconcile mobile network events with content providers. It was built using scripting and Java J2EE framework, and it features a server core for recording events in a database and a graphical user interface (Swing GUI and HTML) for clients to interact with processed information

Developer โ€“ Proyectos Compartidos
2002 โ€“ 2004 | Colombia
Developing as part of the team, different routines in Mainframeโ€™s banking using COBOL, scripting and Java using J2EE framework, using neuronal networks to forecast cash flow

๐Ÿ›  Skills

๐ŸŽ“ Education & Certifications

View my full experience on LinkedIn or download my CV.

Contact

๐Ÿ  Back to Home