Data Insights
Turning raw data into clear, actionable stories.
Data Pipeline for Weekly Metrics
Built a nightly Python pipeline on Google Cloud VM to replace manual spreadsheet unpivoting. Parsed and normalized agent names from different data sources and connected all the data based on the primary keys and loaded data into Azure Database from SQL Management Studio enabling precise agent-level performance reporting.
PowerBI Dashboards
Developed a multi-paged Power BI Dashboard reporting system with over 30 pages combining Follow Up Boss and internal sales data. Built dynamic filters with DAX formulas with STAR schemas for creation date, stage, and agent attribution, allowing team leads to drill down into pipeline trends, close rates, and top-performing agents.


Created a real estate–specific AI assistant using OpenAI’s Assistant API. Prompt Engineered an Assistant that Enabled agents to ask legal, tax, and sales-related questions with CAR Forms. Agents were able to get their questions answered in seconds as opposed to waiting for others to answer their questions
Realtor Bot AI Assistant in Slack
Gallery
A selection of projects showcasing data insights and automation










Osvaldo transformed our data chaos into clear insights, making automation feel effortless and boosting our team's efficiency.
Ruben A.

★★★★★
