Ranjit Jain

At Bank of America, I led the architecture and production support of the Global platform — a
10 TB SQL Server data warehouse processing 600K active trades and 20K daily
adjustments. I designed and optimized complex **SSIS ETL pipelines**, dimensional data
models, incremental data loads, and successfully executed major migrations including
**Netezza to Oracle Exadata**. I also managed full-lifecycle database operations, including
upgrades from SQL 2005 to 2022, performance tuning, partitioning, and security controls.
A proactive player-coach, I consistently leverage Microsoft Copilot for SQL/ETL optimization
and ChatGPT for secure Python development. I excel at balancing hands-on delivery with
team leadership and stakeholder management across regions.

(Contract at Bank of America)

• Led migration from Vectorwise to Azure Synapse Data Warehouse and simplifying
complex data processing logic.