PORTFOLIO / DATA & OPERATIONS
Alessandro Pennella
Data & Operations Analytics
I worked on monthly ACH returns reporting and PCI noncompliance reporting for billing at PayArc. I also built LocalMotion Endorsements, where I turned a business rule about payable miles into logic the app could apply. This portfolio shows how I prepare data, validate results, and explain what the numbers mean for an operational decision.
01 / SELECTED WORK
From source files to operational decisions.
Three projects in development. Synthetic data, documented methods, and a clear place for the evidence.
Complete
ACH Returns Reporting
A portfolio recreation inspired by my monthly reporting work at PayArc. The project uses fictional sponsor-bank files to demonstrate how I would standardize different layouts in Power Query, validate and summarize returns in SQL, and present monthly trends in Excel and Power BI.
Python · SQL · SQLite
Explore project
IN DEVELOPMENT
Billing Exceptions Audit
A synthetic billing review that compares expected charges with actual billing, flags duplicates and missing records, and presents discrepancies in a Google Sheets review queue.
SQL / Google Sheets
Explore project
IN DEVELOPMENT
LocalMotion Mileage Analysis
A case study using simulated trip records to explore the difference between total and payable miles. It will use Python for exploratory analysis, R to examine an association, and Tableau to compare cohorts.
Python / R / Tableau
Explore project
02 / SKILL INDEX
Browse by Skill
Find a tool or method, then jump to its planned evidence. Project work is still in development.
03 / ABOUT
An operational lens on data.
My experience connects payments reporting, recurring data preparation, and process automation. At PayArc, I worked on monthly ACH returns and PCI noncompliance reporting for billing. With LocalMotion Endorsements, I translated a payable-mile business rule into application logic.
This portfolio separates real professional experience from synthetic portfolio work. The case studies are recreations and explorations, not production deliverables.
04 / CONTACT
Let’s connect.
LinkedIn, GitHub, résumé, and contact details will be added here.
GitHub
Résumé
Contact