ramosinc

I build the reporting, data and automation that banks and mortgage lenders run on.

Carlos Ramos. Technology manager with more than ten years across capital markets and mortgage banking: development, system administration and leading the work. I also build small, useful software, and some of it is free to use right here.

Free tools

Every tool runs on my own server, not in your browser. What you enter travels over an encrypted connection, the answer is worked out there and sent back, and nothing is stored. Checking the server

Loan calculator

Monthly payment, total interest and payoff time. Add an extra monthly amount to see how much sooner the loan ends.

Work

Two industries, one job: get the right numbers to the people who depend on them. In capital markets that means trading-system reports, message routing and scheduled jobs. In mortgage banking it meant regulatory data, borrower tax reporting, the cloud and security. In both I have administered the systems and managed the programs, not only written the code.

BI and capital markets technology

City National Bank

  • Leading the move of treasury reporting from Microsoft Access to SAP BusinessObjects Web Intelligence: about 74 reports across FX, general ledger entries, AML compliance and deposits, with every query rewritten from Access syntax to T-SQL.
  • Built a Python toolkit that traces data lineage through OPICS views, so each report's dependencies are known before it moves.
  • Designed a five-job CAWA workflow for report delivery, and fixed a file-copy race condition with stable-file polling and a reconciliation step after every copy.
  • Built an Excel conversion pipeline in Python and deployed it to production servers with offline installs and full runbooks.
  • Reviewed the architecture of the OPICS to SWIFT message routing system and am writing its runbook and production verification checklist.

Technology and security lead

Mortgage banking

  • Ran the migration of on-premises systems to Azure and AWS.
  • Led the cybersecurity program on a Zero Trust model.
  • Built the data pipelines behind HMDA Loan Application Register reporting.
  • Automated borrower tax reporting for Form 1098.
  • Ran the help desk on Zoho Desk and Microsoft 365.
Management
Program leadershipCloud migration deliverySecurity program ownershipHelp desk managementChange management in ServiceNowRunbooks and documentation
System administration
WindowsMicrosoft 365Azure and AWSPowerShellProduction deploymentsOffline installsSystem inventorySynology NAS
Reporting and BI
SAP BusinessObjects WebIUniverse Design Tool and IDTCrystal ReportsExcel automation
Data
T-SQLSQL Server 2022Oracle 19cSQLiteData lineage
Capital markets
OPICSSWIFT messagingGL and Nostro reconciliationFX reportingAML reporting
Mortgage banking
HMDA LAR data pipelinesForm 1098 borrower tax reportingHelp desk operations
Automation
CAWA workload automationPythonPowerShellJob scheduling
Cloud and security
AzureAWSZero Trust

Built on my own time

I run a home lab that mirrors production SQL Server and Oracle, and I build local-first software that works offline and keeps data on the machine.

Proj

place holder

Python, tkinter, SQLite

Proj1

Place holder

Python, FSK

Proj2

Place holder

PowerShell, SQLite, Ollama

Feed

What is new on this site.

Private portfolio

Report samples and screenshots for hiring teams. If I sent you a password, enter it here.

This section is encrypted

The contents are stored encrypted with AES-256 and are decrypted in your browser only when the password is right.