Anthony Ccasani

Data Analyst | Contact Strategy & Data Pipelines

I focus on building analytical solutions that combine data rigor, business context, and clear communication.

Data Analysis

I work with real business data, applying SQL, financial analysis, and problem-solving techniques to extract patterns, validate metrics, and answer concrete business questions.

Visualization

I design clear and interactive dashboards using Power BI, Domo, Excel, and Looker Studio, focusing on business-ready insights that support managers and stakeholders.

Data Modeling & BI Solutions

I build structured data models, ETL processes, and input/output schemas using SQL, Python, Power Query, and Cloud environments, ensuring data quality and consistency across reports.

About me

I’m a data analyst who works at the intersection of data pipelines and outbound contact strategy. My core focus: turning campaign data into business decisions — propensity scoring, decile segmentation, and the SQL Server + Python pipelines that feed daily dialing operations (Genesys Cloud).

I currently work with portfolios of 1.9M+ records for telecom outbound campaigns (Entel, Movistar), where my work connects three pieces that are usually siloed: the portfolio data, the dialing engine, and the business outcome — coverage, contact rate, cost per acquisition.

My background is unconventional: I trained as a Civil Engineer and moved into data engineering and BI self-taught, driven by curiosity about the data I was already handling in operational roles. That path is part of why I’m comfortable owning both the technical and operational sides of a data problem.

Stack: SQL Server (stored procedures, window functions, MERGE), Python (automation, pyodbc, API integration), Power BI, and DOMO (certified BI Developer & Professional). I’ve collaborated daily in English with BI teams across the US, Canada, and the Philippines.

I’m particularly interested in the space where data touches revenue directly — collections, fintech, contact strategy. If that’s your world too, let’s talk.

Outbound Contact Strategy & Data Pipeline — Telecom Campaign Operations

Designed and operate the data layer behind large-scale outbound campaigns (1.9M+ records) for telecom portability and retention. Built propensity scoring and decile-based segmentation to prioritize dialing by conversion likelihood, and engineered the SQL Server pipeline (stored procedures, MERGE-based deduplication, window functions) that feeds Genesys Cloud dialer operations daily. Automated the ingestion of dialer exports via Python, and built cross-channel matching between IVR and dialer data to unify contact visibility across a customer base — achieving ~68% phone-match coverage. This project sits at the intersection of data engineering and contact-center operations: the same discipline applies directly to collections and customer-engagement strategy.

«Production project — proprietary data, details available on request».

View a sample of my work

Stored on Github

🌍 Global Structural Correlation Study Across Socioeconomic and Environmental Indicators

A cross-domain global data analysis project that uses correlation matrices and heatmaps to uncover structural relationships between economic, health,
education, demographic, environmental, and geopolitical indicators, identifying key development patterns and systemic interactions across countries.
📊 Business Intelligence Workflows Implemented in SQL Server (Northwind Dataset)
A SQL Server portfolio project that implements automated invoicing, customer sales ranking, and shipping status reporting using the Northwind database to demonstrate structured business logic, KPI calculations, and production-style stored procedure development.
🛒 Retail Performance Analytics System Using SQL Stored Procedures
A SQL Server analytical project that builds a multi-report stored procedure to transform retail transactional data into structured sales, customer satisfaction, and profitability KPIs, demonstrating advanced T-SQL reporting logic and database-layer metric modeling.
📊 Medical Insurance Cost — Exploratory Data Analysis
An end-to-end exploratory data analysis of medical insurance records (1,338 observations) focused on identifying key cost drivers and evaluating how demographic and lifestyle variables influence annual healthcare expenses. The project applies structured data cleaning, distribution analysis, regression visualization, and correlation modeling to uncover that smoking status is the strongest predictor of high charges, followed by BMI and age, while gender and region show limited predictive power.
.📊 Global Tourism Analytics Dashboard – Travel Behavior & Destination Insights
An interactive Power BI dashboard analyzing travel preferences, demographics, nationality patterns, and transportation costs across seven major global tourist destinations, designed to uncover
behavioral trends and tourism segmentation insights.
💤 Lifestyle & Sleep Patterns — Exploratory Data Analysis
A structured exploratory analysis of lifestyle, health, and sleep metrics (374 records) aimed at understanding behavioral and physiological factors affecting sleep quality and duration. Using regression analysis, violin plots, grouped comparisons, and correlation heatmaps, the project reveals strong associations between stress level and sleep quality, positive relationships between physical activity and sleep duration, and subtle age-related trends, demonstrating applied health analytics methodology using Python.

Customer & Colleague words

Luis Fernández

«Anthony is someone you can trust to deliver solid analytical work.»


— BI Analyst

Carla Rodríguez

«He was able to turn complex datasets into insights we could actually use. His work supported better planning and more informed decisions.»


— Project Manager

Jorge Castillo

«Working with Anthony meant more structured data workflows and reliable reports. He consistently delivered results that added real analytical value.»


— Data Lead