Shifting the Lens

18+ years of designing and delivering enterprise-scale data platforms across Banking & Finance

Professional Summary

Data Solution Architect with 18+ years of experience designing and delivering enterprise-scale data platforms in the Banking and Finance industry. Proven expertise in modernizing legacy systems, leading mainframe-to-cloud migrations, and implementing high-performance data architectures. Recognized for driving business-critical transformations with Databricks, Azure Data Factory, Synapse Analytics, and Snowflake. Adept at leading cross-functional teams, optimizing ETL/ELT pipelines, and ensuring regulatory-grade data quality in demanding, fast-paced environments.

Experience Highlights

 Cloud Migration

Architected end-to-end Mainframe to Databricks migrations, leveraging GitHub Copilot to transform COBOL to PySpark and reduce development effort by 60–70% with full solution ownership.

 Multi Agent Orchestration

Building Semantic layer on Databricks and Snowflake using multi-agent orchestration — end-to-end from dev to deploy and test.

 AI-Powered Modernization

Leveraged GitHub Copilot to transform Informatica ETL mappings and workflows to PySpark on Databricks, reducing migration effort by 40–60%.

 Financial Data Expertise

Managed ODS Data Models for Global Wires Payments, ensuring accuracy, compliance, and real-time availability for one of the top 5 Canadian Banks.

 Data Engineering

Designed data archival strategies, enhanced data quality frameworks, and delivered high-throughput ETL pipelines across Azure.

 DevOps & Automation

Built CI/CD pipelines using Azure DevOps, GitHub, GitLab, and Jenkins — driving faster deployments and consistent delivery velocity.

 Multi-Technology Proficiency

Deep expertise in Azure alongside RDBMS (Oracle, SQL Server), AWS Glue, Snowflake, Cassandra, and MongoDB.

 ETL/BI Leadership

Designed Informatica PowerCenter mappings, PowerExchange integrations, and reporting solutions in Power BI, Cognos, and SAP BO.

 Big Data & Analytics

Skilled in PySpark, HDFS, Hive, and Spark2, delivering distributed, high-performance computation frameworks.

 Scripting & Automation

Automated monitoring of 10K+ Autosys jobs, built VBA dashboards, and implemented reusable Python/Unix scripts.

 Certified Cloud Expert

Azure Solutions Architect (AZ-303/304), Azure Data Engineer (DP-203), Azure Data Fundamentals (DP-900), and Azure AI Engineer Associate (AI-102).

Work History

Multi Agent System Architect Current
Building Semantic Layer on Azure Databricks & Snowflake using Multi Agent Architecture
  • Designed templates for specialised agents: Orchestrator, Planner, Maintenance, Executor, Deployment, and Test Agents.
  • Leveraged LLM-based code transformation (GitHub Copilot) to accelerate design and development of multi-agent pipelines under VS Code IDE.
Databricks Migration Solution Architect Banking & Finance
Migration of legacy Mainframe COBOL application to Azure Databricks for scalability, cloud adoption, and cost efficiency
  • Served as Solution Architect & Delivery Lead, owning end-to-end data flow architecture — ingestion, transformation, and extraction.
  • Leveraged GitHub Copilot for LLM-based COBOL → PySpark code conversion.
  • Integrated Azure Data Factory, Databricks, and ADLS Gen2 for data processing pipelines.
  • Designed and implemented metadata-driven frameworks.
  • Used CI/CD pipelines (Azure DevOps) to automate deployments and improve delivery velocity.
 Impact Achieved 60–70% reduction in development time and delivered a reusable modernization framework scalable across multiple mainframe workloads.
Senior Consultant / Azure Data Architect Top 5 Canadian Bank
New ODS on Azure for Real-time Global Wire Transactions & Payments
  • Created and enhanced Payments Data Model for real-time global wire transactions.
  • Designed Data Archival Solution Strategy and Data Quality Framework for ODS.
  • Data mapping across multiple payment message types to existing ODS data model.
  • Designed and developed new ADF pipelines to ingest on-premises files and generate extracts for downstream consumers.
  • Developed PowerShell scripts for ARM template deployment to higher environments.
  • Guided and optimised long-running queries/jobs; mentored junior ETL resources.
 Value Addition Built pipelines to track database table utilisation, enabling trend analysis for storage planning and archival decisions.
Azure Data Engineer Top 5 Canadian Bank
On-Premises Hadoop to Azure ADLS & Synapse Analytics Migration
  • Participated in framework design for data movement from on-premises Hadoop to Azure ADLS and Synapse.
  • Designed and developed PySpark modules for data integration via Azure Data Factory.
  • ETL processing using Azure Databricks with PySpark, loading results into Synapse.
  • Built medium-to-complex dataflows using ADLS, ADF, and Azure Databricks.
  • Supported System Integration Testing — analysis, debugging, and coordination.
 Value Addition Automated DDL review using Excel VBA and Python, saving significant person-hours in validation effort.
ETL Architect / Technical Lead Enterprise DWH
Enterprise Data Warehouse — designed and built from scratch
  • Led end-to-end delivery from requirements and design through to production with zero post-go-live defects.
  • Delivered high-level and low-level data flow and Data Model designs for a greenfield DWH.
  • Developed complex Informatica ETL code; implemented SCD1 and SCD2 strategies.
  • Managed onshore/offshore teams, resolving technical challenges and production bottlenecks.
  • Prepared technical design specifications for extraction, transformation, and loading.
  • Applied Lean Six Sigma methodologies to drive measurable process improvements.
 Value Addition Built a Power BI dashboard to monitor ~7,000 Autosys jobs, eliminating manual production monitoring through the GUI/CLI.
Senior Developer – ETL BI DWH Migration
BI DWH — SQL Server / SSIS → Informatica ETL, Cognos 10, Oracle 11g Exadata
  • Designed and developed medium-to-complex Informatica ETL mappings; tuned workflows with performance issues.
  • Authored high-level design documents covering data extraction, business logic, and target loading.
  • Drove System Integration, Performance, and User Acceptance Testing.
  • Conducted code reviews to maintain industry coding standards.
  • Built Excel VBA automation to convert SQL Server SSIS packages into Informatica mapping code.
Developer – ETL Early Career
  • Progressed through roles from team member to Project Lead across multiple delivery engagements.
  • Monitored daily and monthly ETL jobs — error identification and resolution on job failures.
  • Created Standard Operating Procedures (SOPs) and led Knowledge Sharing sessions.
  • Managed onshore/offshore team coordination for uninterrupted service delivery.
  • Developed SAP Business Objects and Cognos reports.

Technical Skills

AI / LLM

GitHub CopilotClaudeLangChainLangGraph

Cloud Technologies

Azure DatabricksAzure Data FactorySynapse AnalyticsADLS Gen2SQL MIApache Spark

Data Integration Tools

Azure Data FactoryAzure DatabricksInformatica PowerCenterPowerExchange

DevOps

Azure DevOpsGitHubGitHub ActionsGitLabBitBucketJenkins

Reporting Tools

Power BISAP Business ObjectsCognos ReportnetQlikView

Languages

SQLT-SQLPL/SQLPythonPySparkUnix ShellHiveQLVBScript

RDBMS

OracleSQL ServerAzure SQLMySQLMS Access

NoSQL

CassandraMongoDB

Scheduling Tools

AutosysApache Airflow

Developer Tools

VS CodeVisual StudioSSMSToadPL/SQL DeveloperPutty

Education & Certifications

Master of Computer Application (MCA)

Indira Gandhi National Open University (IGNOU), India  ·  2013

Bachelor of Science (Chemistry)

Berhampur University, India  ·  2007

Azure Solutions Architect Expert

AZ-303 & AZ-304  ·  Microsoft

Azure Data Engineer Associate

DP-203  ·  Microsoft

Azure AI Engineer Associate

AI-102  ·  Microsoft

Azure Data Fundamentals

DP-900  ·  Microsoft

Azure Fundamentals

AZ-900  ·  Microsoft

Additional Certifications

Apache Spark, Hive, Python, AWS Essentials  ·  Udemy & cognitiveclass.ai

Awards & Achievements

TCS Certified Lean Six Sigma Green Belt
TCS Technical Excellence Award
Beyond Performance Award
Star of the Month
On The Spot Award