FARSANA S

Professional Experience

Tata Consultancy Services (TCS) | Azure Data Engineer | Jul 2021 – Present

Project 3 – Enterprise Banking Risk & Regulatory Data Platform (Netherlands Bank)

• Designed and maintained metadata-driven ADF and Logic Apps solutions supporting EAD, IRB,RWA, IFRS9 calculators and finance reporting data flows.
• Implemented Medallion Architecture using ADLS Gen2 for scalable and governed data processing.
• Built automated failure-notification framework(SM9 Tasks) reducing incident response time by ~65%.
• Developed restart controller enabling batch recovery from point-of-failure, reducing manual intervention by ~80% and recovery time by ~70%.
• Managed Azure DevOps CI/CD deployments and contributed to AI-assisted development using Copilot.
• Improved onboarding efficiency by ~75% and operational efficiency by ~60% through reusable metadata-driven architecture.

Project 2 – Scribe to Azure Modernization (Finland Financial Services)

• Reverse engineered legacy Scribe integrations supporting fraud-monitoring, customer-data management, test-data provisioning and data-quality workflows.
• Rebuilt integrations using Azure Data Factory and metadata-driven orchestration frameworks.
• Reduced maintenance effort by ~60%, onboarding effort by ~70%, and testing support effort by ~65%.
• Improved integration reliability, monitoring visibility, and cloud adoption across business-critical processes.

Project 1 – Enterprise Data Migration Program (US Banking Client)

• Migrated 300+ banking tables across multiple schemas from on-premises databases to Azure SQL using ADLS Gen2 staging.
• Designed historical-load and incremental monthly batch ingestion pipelines using Azure Data Factory.
• Built reusable metadata-driven ingestion framework reducing onboarding effort by ~75% and manual processing effort by ~70%.