Create Your First Project
Start adding your projects to your portfolio. Click on "Manage Projects" to get started
Data Migration for US Bank
Client
US Banking Client (Confidential)
Industry
Banking & Financial Services
Tools & Platforms Used:
Oracle, Databricks (Azure), SQL, Excel
Challenge:
Bank planned to migrate from Oracle to Databricks (Azure). Needed business analysis support for requirement gathering, mapping, and testing.
Objectives:
Ensure smooth migration with zero downtime
Validate data integrity
Document requirements and transformations
Tools & Platforms Used:
Oracle, Databricks (Azure), SQL, Excel
Approach (Step-by-Step):
Discovery & Requirement Gathering: Conducted sessions with US + offshore stakeholders.
Gap Analysis: Compared old Oracle schemas vs Databricks target structure.
Data Mapping: Prepared transformation & mapping documents.
Validation & Testing: Wrote SQL queries → validated migrated datasets.
Delivery & Training: Documented results, prepared KODs, and conducted UAT sessions.
Results / Outcomes:
Smooth migration with zero downtime.
Improved query performance by ~25%.
Detailed documentation ensured compliance and audit readiness.
Next Steps:
Recommended creating automated reconciliation dashboards.